Analytical Tools
Power BI, Advanced Excel.
Skills
Programming Languages
SQL (Structured Query Language), Python.
Database Management
MySQL, Microsoft SQL Server.
Data Visualization
Power BI, Dashboards.
Work
Gurugram, Haryana, India
→
Summary
Analyzes complex actuarial data, manages large databases, and develops dynamic dashboards to enhance business retention and reporting accuracy for clients.
Highlights
Applied advanced statistical techniques for trend analysis and pattern identification, contributing to a 15% increase in business retention through dynamic Excel-based dashboard creation.
Managed relational databases containing up to 50 million records, ensuring seamless data access and integrity across cross-functional teams.
Leveraged SQL to extract and analyze large datasets (1M+ rows), significantly improving reporting accuracy by 30%.
Handled 90% of client and auditor data queries, conducting in-depth trend analysis on historical data in Excel to achieve an 8-10% improvement in accuracy and consistency.
Gurugram, Haryana, India
→
Summary
Developed interactive Power BI dashboards and standardized HR datasets to automate data transformations and optimize performance for internal operations.
Highlights
Developed an interactive Power BI dashboard for 'Shield Insurance,' automating data transformations and analyzing trends from 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 system performance.
Projects
FMCG Analysis - FMCG
→
Summary
Developed a Power BI dashboard to monitor key performance indicators (KPIs) for FMCG operations and automated data transformation processes using Power Query.
Hospitality Analysis - Hospitality
→
Summary
Analyzed market share and revenue loss for Atliq Grands, identifying key trends in guest satisfaction and booking, and developed a Power BI dashboard for strategic insights.
Business Insights 360 - Brick & mortar & ecommerce
→
Summary
Customized a multi-functional Power BI dashboard to analyze global sales trends for AtliQ hardware, integrating data from diverse sources and optimizing report performance.