Available for new opportunities

Amir Khan

Senior Data Analyst & BI Consultant

CBAP® certified analyst with 7 years of experience transforming complex data into actionable intelligence across Banking, FMCG, and Consulting domains. Specializing in end-to-end data pipelines and enterprise dashboards.

7+
Years Experience
30+
Projects Delivered
3
Top-Tier Firms
AK
Amir Khan
Senior Data Analyst · New Delhi, India
Power BIAlteryx SQLPython AzureTableau AutomationETL

🏦
Bank of America
Current · Team Leader
📊
Ernst & Young (EY)
2020 – 2024 · BI Consultant
📍
New Delhi, India
Open to Remote / Hybrid
🏅
CBAP® Certified
Alteryx Core Designer Certified
Who I Am

Turning Data into Decisions

I'm a Senior Data Analyst and BI Consultant based in New Delhi with 7 years of hands-on experience across Banking, FMCG, and Management Consulting. I bridge the gap between raw data and business intelligence — designing scalable ETL pipelines, enterprise dashboards, and analytics solutions that drive real decisions.

At Ernst & Young, I led teams of 8–10 developers, delivering 30+ enterprise-grade data solutions for global clients. At Bank of America, I lead data engineering and analytics initiatives in the Wealth Management domain, mentoring junior analysts and collaborating directly with business stakeholders.

My work spans solution design (HLD/LLD), stakeholder management, ETL automation, and cloud-based analytics — always with a focus on measurable business outcomes.

🎯
Domain Focus
Banking & Wealth Management · FMCG · Consulting
🛠️
Core Stack
Power BI · Alteryx · SQL · Python · Azure · Fabric
📜
Certifications
CBAP® · Alteryx Core Designer
🌍
Languages
English · Hindi · French (Diploma)
🤝
Consulting Style
HLD/LLD · Agile/Scrum · Stakeholder Management
Productivity Impact
Improved team productivity by 20–30% via pipeline optimization
Technical Expertise

Skills & Tools

📊
BI & Visualisation
Power BI95%
Tableau88%
DAX & Power Query90%
Dashboard Design92%
⚙️
Data Engineering & ETL
Alteryx95%
SQL (SQL Server, Impala, MySQL)92%
ETL Pipeline Design90%
Data Modelling (Star Schema)88%
🐍
Programming & Cloud
Python (Pandas, NumPy)82%
Azure Analytics78%
Microsoft Fabric75%
API Integration & Automation80%
💡
Consulting & Soft Skills
HLD / LLD Design Stakeholder Mgmt Requirement Gathering Agile / Scrum Team Leadership Solution Architecture Performance Tuning Data Validation Data Migration Workflow Optimisation CBAP® Certified Mentoring
Career Journey

Work Experience

7 years across top-tier Banking and Consulting firms

Bank of America
Oct 2024 – Present
Team Leader · Wealth Management
// Wealth Management Analytics
  • Leading data engineering and analytics initiatives in the Wealth Management domain
  • Designed and optimized ETL workflows using Alteryx, reducing manual effort and improving processing efficiency
  • Wrote complex SQL queries to extract and transform data from SQL Server and Impala
  • Built enterprise dashboards in Tableau, delivering real-time insights to portfolio managers
  • Automated data ingestion using Python scripts, improving data quality and reducing manual dependencies
  • Providing technical guidance and mentoring to junior team members
Ernst & Young (EY)
Dec 2020 – Oct 2024
BI Consultant & Data Engineering Lead
// Process Automation & ETL Delivery
  • Led a team of 8–10 developers delivering scalable ETL and data transformation solutions
  • Designed reusable Alteryx pipelines reducing processing time from hours to under a minute
  • Delivered 30+ enterprise-grade data solutions, improving efficiency and accuracy for global clients
// P&L Dashboard & S&OP Dashboards · FMCG Nigeria
  • Developed a real-time P&L dashboard integrating forecasted, prior, and current business turnover data
  • Enabled dynamic financial health tracking using bar-line graphs, heat maps, and KPI tiles
  • Conducted ad-hoc data analysis using Python (Pandas, NumPy, Matplotlib, Plotly)
// Landscape Monitoring Dashboard · FMCG
  • Built a Power BI dashboard to monitor storage usage and consumption across internal teams
  • Integrated Power BI on-premises gateway with twice-daily automated scheduled refresh
// Gate Pass & Plant Monitoring · Manufacturing
  • Developed an interactive Visitor Dashboard tracking pass validity, gender, nationality, purpose, and area of visit
  • Highlighted KPIs: Unique Visitors, Repeated Visitors, enabling operational security oversight
// Global COVID-19 Real-Time Tracker
  • Used Alteryx to perform API calls, cleanse data, and feed it into a live Power BI dashboard
  • Displayed Total Cases, Vaccination Status, Deceased, and Recovered at global and country levels
Del Monte Foods Pvt Ltd
Mar 2019 – Dec 2020
Data Analyst
// Distributor Management System (DMS)
  • Led initiative to align PAN India distributors with standardized desktop billing software for consistent data capture
  • Automated Excel report generation as a Power BI data source, enabling distributor performance monitoring
  • Designed interactive dashboard covering Sales, Inventory Checks, and regional trends across India
Selected Work

Featured Projects

POWER BI · FMCG
P&L Real-Time Dashboard

Designed and delivered an interactive Profit & Loss dashboard for a Nigerian FMCG client integrating forecasted, prior-period, and current turnover data into a single dynamic view for executive decision-making.

Power BIPythonPandasPlotly
POWER BI · ALTERYX
Global COVID-19 Tracker

End-to-end real-time analytics pipeline — Alteryx API ingestion → data cleansing → Power BI dashboard displaying global and country-level pandemic metrics including cases, vaccinations, and recoveries.

AlteryxPower BIREST API
POWER BI · ON-PREM GATEWAY
Landscape Monitoring Dashboard

Built a storage monitoring dashboard for an FMCG client with on-premises gateway integration and automated twice-daily refresh cycles. Enabled proactive system management and resource utilisation tracking.

Power BIOn-Prem GatewayScheduled Refresh
TABLEAU · SQL · MANUFACTURING
Gate Pass & Plant Visitor Dashboard

Real-time visitor management system for a manufacturing plant. Tracked pass validity, visitor profiles, purpose of visit, and KPIs like Unique vs Repeated Visitors using complex SQL-backed Tableau dashboards.

TableauSQLHeat Maps
ALTERYX · BANKING
Banking ETL Automation (30+ Workflows)

Led a team delivering 30+ reusable Alteryx ETL pipelines for banking clients at EY. Reduced processing time from hours to under a minute. Improved team productivity by 20–30% through systematic pipeline optimisation.

AlteryxSQL ServerPython
POWER BI · FMCG · INDIA
Distributor Management System

Standardised billing and data capture across PAN India Del Monte distributors. Automated Excel report generation feeding into a Power BI dashboard monitoring Sales, Inventory, and regional trends nationwide.

Power BIExcelSQL
Qualifications

Education & Certifications

🎓
Bachelor of Technology (IT)
Jamia Hamdard, New Delhi
2017
🇫🇷
Certification & Diploma in French
Jamia Millia Islamia, New Delhi
2017 – 2019
🏅
CBAP® Certified
IIBA — Certified Business Analysis Professional
⚙️
Alteryx Core Designer
Alteryx — Core Certification
Let's Connect

Open to Opportunities

Available for senior analyst, BI consultant, and data engineering roles in India or remotely.

"Data is the new currency — I help businesses spend it wisely."