Ankur Verma

Data Analyst | Business Intelligence (BI) Analyst | BI Consultant

Delhi, India 7+ yrs exp 90 · Outstanding

About

Data Analyst & BI Consultant with 5+ years of total professional experience — including 3+ years focused on data analytics, business intelligence and supply chain operations — delivering measurable business impact across e-commerce, healthcare, hotel, retail and supply chain domains. Proficient in Advanced Excel, SQL Server, Power BI and Tableau, with strong skills in data cleaning, data modelling, ETL, KPI reporting, dashboard development and stakeholder management.

Skills & Expertise (38)

Power BI Advanced

8.5/10

Years Exp

Advanced Excel Advanced

8.3/10

Years Exp

Data Visualization Advanced

8.0/10

Years Exp

Data Wrangling Advanced

8.0/10

Years Exp

SQL Server Advanced

8.0/10

Years Exp

Data Analysis Advanced

8.0/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

Tableau Intermediate

7.0/10

Years Exp

ETL Intermediate

7.0/10

Years Exp

Vendor Management Parameters Calculated Fields Stakeholder Management Procurement Analytics Inventory Management Dashboard Development Business Intelligence SQL MS Excel Data Modeling Reporting & MIS KPI Tracking Inventory Analytics Dashboards KPI Reporting Data Modelling Indexing Data Cleaning SSMS Query Optimization Window Functions CTEs MIS Reporting Index-match VLOOKUP Pivot Tables Power Pivot Power Query

Work Experience

Independent Consultant – Data Analyst

Independent Consulting (Self-Employed)

Jun 2024 - Present

Delivered 10+ end-to-end analytics projects for independent clients across e-commerce, healthcare, hotel and supply chain domains, driving significant revenue optimization; analyzed 1M+ records using SQL, Power BI & Advanced Excel. Built 15+ automated Power BI dashboards (DAX, data modelling), reducing decision-making time; engineered SQL pipelines with CTEs, reducing manual work and improving data accuracy. Identified cost savings via procurement analytics & inventory optimization; enabled real-time KPI tracking for 50+ stakeholders.

Data Analyst Intern

Meri SKILL & 360DigiTMG

Jul 2023 - Oct 2023

Analyzed 200K+ records using SQL, Power BI & Tableau; automated KPI reporting, eliminating manual effort and identifying growth opportunities.

Admin Executive → Supply Chain Executive (Promoted)

Orient Craft Limited

Jun 2013 - Sep 2018

Admin Executive (2013–2016): Managed office administration, documentation, MIS tracking & vendor file management; supported procurement and supply chain teams. Supply Chain Executive (2016–2018): Managed procurement for 100K+ orders for M&S, GAP & Zara; achieved 98% on-time delivery through vendor management. Built Advanced Excel MIS systems (Power Query, Power Pivot) for inventory & vendor scorecards; reduced cycle time by 15%, delivering annual cost savings.