Aashish

Aashish

Data Analyst | Business Intelligence Specialist
Gurugram, IN.

About

Highly analytical Data Analyst with a Master's in Data Science and proven expertise in transforming complex data into actionable insights. Skilled in Power BI, SQL, Python, and Advanced Excel, I have driven significant improvements in business retention, reporting accuracy, and operational efficiency. Eager to leverage strong analytical and business intelligence capabilities to solve complex challenges and contribute to data-driven decision-making in a dynamic organization.

Skills

Analytical Tools

Power BI, Advanced Excel, Power Query, DAX Studio.

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
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

Certificates

Data Analytics Bootcamp

Issued By

Codebasics