Analytical Tools
Power BI, Advanced Excel, Power Query, DAX Studio.
About
Skills
Programming Languages
SQL (Structured Query Language), Python.
Database Management
MySQL, Microsoft SQL Server, Relational Databases.
Work Experience
Mithras Consultants
|Actuarial Data Analyst (Full-Time)
Gurugram, Haryana, India
→
Highlights
Applied advanced statistical techniques for trend analysis, data cleaning, and dynamic dashboard creation, contributing to a 15% increase in business retention.
Managed and maintained relational databases containing up to 50 million records, ensuring seamless data access and integrity for cross-functional teams.
Leveraged SQL to extract and analyze large datasets (over 1M rows), significantly improving reporting accuracy by 30%.
Resolved 90% of client and auditor queries through comprehensive trend analysis on historical data in Excel, improving data accuracy and consistency by 8-10%.
AtliQ Technologies
|Data Analyst (Internship)
Gurugram, Haryana, India
→
Summary
As a Data Analyst Intern, I developed interactive Power BI dashboards and standardized HR datasets, optimizing data integrity and performance for insurance operations.
Highlights
Developed an interactive Power BI dashboard for 'Shield Insurance,' automating data transformations and trend analysis for over 2,000 records using Power Query.
Cleaned and standardized a 5,000+ record HR dataset, calculating work-from-home percentages and analyzing attendance trends for 200+ employees using Excel and Power BI.
Normalized datasets by creating 10+ fact and dimension tables and debugged 15+ SQL queries to ensure data integrity and optimize performance.
Projects
FMCG Analysis - FMCG
→
Summary
Developed a comprehensive Power BI dashboard to monitor critical FMCG supply chain metrics, including On-time delivery (OT) %, In-full delivery (IF) %, and On-Time in Full (OTIF) %. Helps to analyze suppy chain
Hospitality Analysis - Hospitality
→
Summary
Addressed a 5% loss in market share and revenue for Atliq Grands by analyzing guest satisfaction and booking trends over 14 weeks, revealing an 8% decline in occupancy rates and shifts in customer preferences.
Business Insights 360 - Brick & mortar & ecommerce
→
Summary
Customized a multi-functional Power BI dashboard to analyze AtliQ hardware's global sales trends, integrating data from Excel/CSV files and a SQL database.
Education
Chandigarh University
→
Master of Science
Data Science
University of Delhi
Delhi, Delhi, India
→
Bachelor of Commerce
Commerce