PEERZADA ABRAR ARIF
New Delhi
Summary
Analytics and BI Professional with 10 years of experience delivering data platforms, executive dashboards, and automation across healthcare, retail, and financial services. Led multi-region analytics projects across Asia, US, and Canada, improving delivery speed by up to 35%, cutting manual effort by 70%, and driving measurable revenue and cost impact, focusing on accuracy and efficiency. Specialization in Power BI, SQL, ETL, and stakeholder delivery, while leading analytics teams, aligning stakeholders, and turning complex data into executive-ready insights.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Business Intelligence Reporting - Manager
Mercer India Pvt ltd (Marsh McLennan)
Gurgaon and Noida
03.2022 - Current
- Led the Asia Health Report delivery across 10+ APAC markets, accelerating monthly reporting by 35%, increasing accuracy by 98%, and supporting a 115% improvement in NPS.
- Delivered finance and accounting Power BI dashboards by validating and reconciling revenue, expenses, costs, margins, and variances, developing MTD and YTD performance views across 11 Mercer business locations, and ensuring alignment with accounting standards to support accurate financial analysis, management insights, and executive reporting.
- Designed, developed, and deployed scalable self-service Power BI dashboards by partnering closely with business stakeholders, translating requirements into clear, actionable insights that supported informed decision-making across teams.
- Improved data quality, performance, and governance by validating data sources, optimizing data models and DAX queries, and promoting best practices in dashboard design, resulting in faster, more reliable, and user-friendly reports.
- Developed and optimized complex SQL queries across on-premise (SQL Server, PostgreSQL) and cloud databases (Azure, AWS RDS), extracting and transforming multi-million-row datasets to support enterprise BI dashboards, KPI scorecards, and executive reporting; implemented indexing, window functions, and query tuning techniques that reduced data refresh times by 40%, and enabled near real-time insights for cross-functional stakeholders.
- Managed end-to-end BI projects using Agile/Scrum and PMP practices, delivering on time and within budget.
- Led and mentored the analytics team; handled delivery planning, performance reviews, and cross-training.
Process Developer (Data Delivery Lead)
Genpact India Pvt Ltd.
Noida and Bangalore
01.2020 - 02.2022
- Delivered retail and FMCG analytics for U.S. clients, covering sales, margin, inventory, and promotions.
- Built Power BI dashboards tracking daily sales, gross margin, transactions, SKU-level performance, and store KPIs and delivering them on Month on Month.
- Executed complex SQL queries across on‑premise and cloud databases (SQL Server, PostgreSQL, Azure), extracting and transforming large datasets to support BI dashboards, KPI reporting, and executive decision‑making
- Built automated ETL pipelines, loading POS, e-commerce, CRM, and ERP data for near-real-time reporting.
- Tuned complex SQL queries to improve the refresh speed and accuracy of reporting models.
- Optimized SQL queries and data pipelines, reducing refresh time, and improving data accuracy.
Senior Operation Officer
Axis Securities Ltd.
Jammu & Kashmir
09.2013 - 09.2017
- Streamlined processing workflows for loans, mortgages, and credit products, reducing turnaround times and improving customer satisfaction. Developed reporting tools to track loan processing performance and ensure compliance with credit policies.
- Validated and verified financial documents for credit analysis and maintained customer credit portfolios. Met and exceeded monthly client acquisition and sales targets, earning “Employee of the Year” award in 2015 for outstanding performance.
Education
MBA - HR & Marketing
IGNOU
PGDMM - Marketing
IGNOU
B.Com. -
Delhi University
Skills
Analytics and BI tools: Power BI, Qlik Sense, Tableau, DAX, data modeling, dimensional modeling, star schema, KPI frameworks, dashboard development, executive reporting
Data and ETL: SQL (T-SQL, PostgreSQL), Power Query, SSIS, Dataflows, ETL pipelines, data warehousing, data integration, data transformation, data validation
Delivery and leadership: agile, scrum, stakeholder management, program delivery, resource planning, risk management, team leadership, vendor management
Business and strategy: cost optimization, revenue analytics, forecasting, capacity planning, utilization analysis, SLA management, MIS reporting, governance
Certification
• Data Science, Pentasoft Institute of Management & Technology, 2023.
• Google Certified Data Analyst, 2021.
• Power BI for Professional Course.
• Generative AI & Prompt Engineering.
• Advanced Excel (VBA & Macros)
• Google Certified Data Analyst, 2021.
• Power BI for Professional Course.
• Generative AI & Prompt Engineering.
• Advanced Excel (VBA & Macros)
Languages
- English
- Kashmiri
- Urdu
- Hindi
- Arabic
Awards
- Received Employee of the Year in Axis Securities Bank Ltd.
- 1st position in state-level competition examination.
Timeline
Business Intelligence Reporting - Manager
Mercer India Pvt ltd (Marsh McLennan)
03.2022 - Current
Process Developer (Data Delivery Lead)
Genpact India Pvt Ltd.
01.2020 - 02.2022
Senior Operation Officer
Axis Securities Ltd.
09.2013 - 09.2017
MBA - HR & Marketing
IGNOU
PGDMM - Marketing
IGNOU
B.Com. -
Delhi University