Skills
Analytical Tools
Power BI, Advanced Excel.
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.