Aditya Sample
Data Analyst · SQL, Python, Power BI · Retail & Insurance
- Gurugram, Haryana
- aditya.sample@example.com
- +91 9XXXX XXXXX
- linkedin.com/in/aditya-sample
- github.com/aditya-sample
Summary
Data analyst with 3 years of experience turning sales and operations data into dashboards and recommendations for business teams. Strong in SQL and Power BI, with Python for automation and analysis. Comfortable presenting findings to store, category and finance managers.
Experience
Data Analyst
Mar 2025 – PresentAdventure Works Retail Pvt. Ltd. · Gurugram
- Built a Power BI sales and inventory dashboard used weekly by 60 store managers, replacing 12 manually prepared Excel reports.
- Wrote SQL cohort analysis on loyalty data that showed repeat purchase dropping after the second order; the resulting win-back campaign recovered about 9% of lapsed members in a quarter.
- Analysed an A/B test of a new checkout layout for the app team, including sample size checks and segment cuts, which supported a full rollout.
- Automated daily data quality checks in Python (pandas) on 15 source tables, flagging missing and duplicate records before reports refreshed.
MIS Executive
Jul 2023 – Feb 2025Contoso Insurance Services · Noida
- Prepared daily and monthly claims MIS for operations leadership using Excel (Power Query, pivot tables, XLOOKUP) and SQL Server.
- Cut monthly report preparation from 2 days to 3 hours by moving manual steps into Power Query and scheduled SQL views.
- Identified a recurring data entry error in claim status codes that overstated pending claims; fix approved and rolled out across 4 regional teams.
Projects
IPL ball-by-ball analysis
Python, SQL, Power BI
- Explored a public ball-by-ball dataset to compare death-over economy rates by venue; published the notebook and dashboard on GitHub.
Skills
- Analysis: SQL (joins, CTEs, window functions), Python (pandas, NumPy, Matplotlib), Excel (Power Query, pivots)
- BI & visualisation: Power BI (DAX, data modelling), Tableau, Looker Studio
- Statistics: A/B testing, Hypothesis testing, Regression, Cohort analysis
- Data: SQL Server, PostgreSQL, BigQuery, Data cleaning, ETL basics
Education
B.Sc. (Hons) Statistics
2020 – 2023Example University · Delhi · First Division
Certifications
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- Google Data Analytics Professional Certificate