Portfolio - Mandeep Sharma

About Me

Data Analyst with 1+ year of experience working across SQL, Power BI, Power Query, DAX, Excel, and Python (Pandas, NumPy) — handling everything from data cleaning and ETL to dashboards and automated reporting.

I've worked in healthcare, insurance, and retail — building revenue dashboards, tracking KPIs, and cutting manual reporting effort by up to 75%. One project uncovered a 12% jump in repeat purchases that directly shaped a retention strategy.

Currently exploring Python automation and advanced SQL. HackerRank SQL Gold · Power BI Certified · BCom in Statistics & Business Reporting.

Key Skills

sql

python

pandas

Power BI

M.S. Excel

My Projects

Business Insights 360 Dashboard

Domain/Function: Finance, Sales, Marketing and Supply Chain

Walmart Sales Analysis

Domain/Function: Sales And Finance

Sales Analytics(FMCG)

Domain/Function: Sales And Finance

Olympic Medals and Performance Analytics

Domain/Function: Sports Analytics

My Experience

EyeQ Vision — Data Analyst Jul 2025 – Present · Gurugram

Working with SQL Server, Power BI, and Power Query to automate revenue reporting and build dashboards that track KPIs like ARP, revenue trends, and department-wise performance in near real time.

Reduced manual reporting effort by 75% by automating MTD product-wise reports. Run daily ad hoc analysis and data reconciliation across patient, location, and revenue data to keep business decisions grounded in clean, accurate numbers.

Tools: MS SQL Server · Power BI · DAX · Power Query · Excel

AtliQ Technologies — Data Analyst Intern Mar 2025 – Apr 2025

Built an end-to-end Power BI dashboard for an insurance client, covering revenue trends and business opportunities. Cleaned and normalised datasets to improve accuracy by 20%, debugged SQL logic to cut reporting discrepancies by 15%, and automated Power Query workflows that halved manual processing time.

Tools: Power BI · SQL · Power Query · Excel