GAURAV SHARMA
-
https://www.linkedin.com/in/gaurav-sharma-/
Meerut | -
About Me
I am a dedicated and quick-learning MCA graduate with 4 years of experience in data analysis and
business intelligence. I have worked on real-time projects in domains like HR, Sales, and Operations,
using tools such as Power BI, SQL, Excel, and Python to drive actionable insights. With a strong
understanding of data visualization, reporting, and business metrics, I bring a proactive attitude, strong
analytical skills, and a commitment to delivering value through data-driven decision-making.
EDUCATION
Master of Computer Applications (MCA)
Indira Gandhi National Open University (IGNOU), 2009
Bachelor of Science (B.Sc.)
Chaudhary Charan Singh University (C.C.S. University), 2004
SKILLS
Language
:
SQL, Python
Frameworks
:
Pandas, Numpy, Matplotlib
Tools
:
Power BI, Excel, Tabaleu
Soft Skills
:
Report Building, Presentation Skills, Good Communication Skills
WORK EXPERIENCE
Data Analyst
Shubham Software Solution, Meerut
June 11th, 2020 – March 10th, 2025
Analysed and interpreted complex data sets to identify trends, patterns, and actionable insights.
Developed and maintained automated reporting dashboards, enhancing data accessibility and
decision-making.
Proficient in SQL, and Python for data extraction, transformation, and analysis.
Used SQL queries extensively to filter, join, and transform data using clauses such as WHERE,
HAVING, GROUP BY, and ORDER BY to extract relevant and meaningful information.
Focused on data preparation and cleaning by selecting only useful records and columns required
for business dashboards.
Utilized data visualization tool Power BI to present findings to stakeholders effectively.
Collaborated with cross-functional teams to drive data-driven business strategies and
improvements.
Applied statistical methods to ensure data accuracy and predict future trends for optimized
operations.
Tools Used: Python, Power BI, SQL, Tableau, Excel
PROJECTS
Time Intelligence Sales Analysis Dashboard in Power BI
Developed an interactive sales dashboard to analyse sales performance, track key metrics like
Total Sales, Total Sales Last Year, YOY Growth % and Top-Performing Payment Mode.
Utilized Power BI for data visualization and reporting.
HR Analytics in Python
Created an HR analytics solution using Python for data cleaning, transformation, and analysis.
Focused on employee data to uncover insights related to attrition, performance, and employee
satisfaction.
Real Time Weather Insights Dashboard in Power BI
Built an interactive real-time weather dashboard in Power BI using API integration to fetch live
weather data for multiple Indian cities.
Sales Dashboard in Power BI
Developed an interactive sales dashboard to analyse sales performance, track key metrics like total
sales, profit, and top-performing products. Utilized Power BI for data visualization and reporting.
Healthcare Data Cleaning Project in Python (Pandas)
Performed data cleaning and pre-processing on a healthcare dataset using Python and Pandas.
Addressed missing values, removed duplicates, corrected inconsistent data formats, and handled
outliers. Focused on preparing clean and reliable data for further analysis in patient demographics,
treatment outcomes, and hospital performance metrics.
CERTIFICATION
SQL and Relational Database 101
Python for Data Science – IBM
Data Analysis Using Python – IBM
Data Visualisation : Empowering Business with Effective Insights – Forage (Tata)
STRENGTHS
Positive attitude with strong self-motivation
Quick to learn and adapt to new challenges
Eager to acquire new skills and adjust to changing environments
Strong problem-solving abilities
Natural leadership qualities
Good communication skills