Back to Developers
Shiraz Mohd

Shiraz Mohd

Data Analyst

Dehradun, Indira 9+ yrs exp 90 · Outstanding

About

Data Analyst with 7+ years turning large, high-volume datasets into KPI reports, automated dashboards, and business insights, built primarily within insurance operations. Automated reporting for 1,500+ employees across 190+ branches, cutting turnaround time and improving data accuracy for leadership decisions. Proficient in Advanced Excel, SQL, and Power BI (DAX, M Query/Power Query, Data Modelling — Star & Snowflake Schema), with hands-on Power BI projects focused on dashboard design and data storytelling. Comfortable owning a dataset end-to-end — from cleaning through to a dashboard that supports data-driven decision-making.

Skills & Expertise (26)

Power BI Advanced
8.5/10
5
Years Exp
KPI Tracking Advanced
8.0/10
9
Years Exp
Trend Analysis Advanced
8.0/10
9
Years Exp
Ad-hoc Analysis Advanced
8.0/10
9
Years Exp
Advanced Excel Advanced
8.0/10
9
Years Exp
Data Cleaning Advanced
8.0/10
9
Years Exp
Data Transformation Advanced
8.0/10
9
Years Exp
SQL Advanced
8.0/10
9
Years Exp
DAX Advanced
7.8/10
5
Years Exp
Data Modelling Advanced
7.5/10
5
Years Exp
M Query Advanced
7.5/10
5
Years Exp
Python Intermediate
6.5/10
3
Years Exp
Stakeholder Reporting Cross-Functional Collaboration Data-driven decision making MIS Reporting Sales Analytics Windows functions Subqueries CTEs Aggregations Joins VLOOKUP XLOOKUP Pivot Tables Power Query

Work Experience

Associate Sales Manager — Sales & Business Analytics

Max Life Insurance

Sep 2023 - Nov 2025

Analysed 1,000+ customer and sales records to identify growth opportunities and improve conversion rates across assigned branches. Tracked and reported 4 core KPIs across 7 business segments, giving leadership a consistent view for performance decisions. Supported automated dashboard reporting for shortfall and root cause analysis, and target tracking, reducing manual reporting effort. Analysed renewal and engagement trends to flag at-risk customers, contributing to improved retention. Partnered with branch teams and stakeholders on weekly/monthly performance reporting used directly in target-tracking decisions.

Circle Coordinator / Data Analyst

Max Life Insurance

Apr 2018 - Aug 2023

Automated a daily KPI dashboard for 1,500+ employees, cutting preparation time to ~1.5 hours. Built fully automated Excel dashboards, reducing reporting turnaround to ~2 hours. Analysed 10,000+ records across 190+ branches and 10+ channels, using Power Query to clean and transform data for accuracy. Built monthly dashboards tracking 10+ KPIs and developed Power BI dashboards to identify regional performance gaps. Automated Target vs. Achievement and segment-level reporting, improving tracking accuracy and turnaround.

Senior Process Associate

Omniscient Solutions

Apr 2016 - Apr 2018

Managed financial reporting and budgeting processes, preparing and presenting reports to leadership. Collaborated with internal teams and vendors on business analysis and process alignment. Handled vendor communication, payments, and discrepancy resolution.

Education

MBA (Operations) - SMU

- 2017 · Afghanistan

B. Com - D.A.V College, Dehradun

- 2014 · Afghanistan

Intermediate (I.S.C. Board) - Dehradun

- 2010 · Afghanistan

High School (I.C.S.E Board) - Dehradun

- 2008 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 15/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 90/100

Profile Overview

Member sinceSep 2026

Availability Details

Visa Status

Citizen

Relocation

Depends on Offer