Gaurav Sharma

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