DRISHTI GUPTA

Dynamic and detail-oriented professional with extensive experience in data analysis, healthcare documentation, and process optimization. Proven expertise in utilizing SQL, Power BI, and Excel to drive data-driven decision-making and enhance operational efficiency. Adept at managing complex projects, from healthcare analytics to insightful reporting, and committed to leveraging advanced tools and continuous learning to achieve excellence.

• Microsoft Excel 2023 - from Beginner to Expert in six hours (03/24)
• Microsoft Excel - Excel from Beginner to Advanced on Udemy (03/24)
• SQL for Data Science on Coursera (01/24)
• Microsoft Power BI Desktop for Business Intelligence on Udemy (10/23)
• Introduction to Data Analysis using Microsoft Excel Project on Coursera (10/23)
• Excel Basics for Data Analysis on Coursera (09/23)
• Microsoft Excel 2016 for Beginners: Master the Essentials on Udemy (07/23)
• HIPAA Certification (08/22)
• Leading Health care and Quality Course on Coursera (06/20)

From Data to Health: Using Analytics to Drive Employee Incentives and Wellness (March’24)

• Utilized SQL queries to extract data on employee health metrics and absenteeism.
• Created a Power BI report to visualize the eligible employee list.
• Provided a list of Healthy Individuals & Low Absenteeism for a healthy bonus program -Total Budget $1000 USD.
• Calculated a wage increase or annual compensation for insurance budget of $983,221 for all non-smokers.
• Created a dashboard for HR to understand Absenteeism at work based on approved wireframe.

SQL and PowerBI Portfolio Project (February’24)

• Extracted, cleaned, and transformed employee data from multiple sources using SQL queries.
• Designed and implemented data models to create a relational database for efficient data analysis.
• Created interactive dashboards in Power BI to visualize key HR metrics such as employee count by different departments, employees working from headquarters vs remote, employees by state etc.
• Implemented dynamic filters and slicers to enable users to explore data at different levels of granularity.

Supermarket Sales Project in PowerBI (December’23)

• Identified the KPIs, designed an intuitive and visually appealing dashboard, and added interactive visualizations and filtering capabilities to allow users to explore the data at various levels of granularity.
• Provided valuable insights to business entities regarding the effectiveness of their sales strategies through visualization and charts.
• Leveraged historic data and applied time series analysis to generate sales forecasts.
• Generated valuable insights and actionable information that can drive strategic decision-making and support the supermarket's goals for growth, efficiency, and customer satisfaction.

Store Data Analysis in Excel (December’23)

• Conducted thorough data cleaning and preparation to ensure the accuracy and reliability of the dataset.
• Applied Excel functions and formulas to handle outliers, missing values, and inconsistencies.
• Created visually compelling charts and graphs to effectively communicate trends, patterns, and insights.
• Designed and built interactive dashboards within Excel for a user-friendly and intuitive data presentation.

Sales Data Analysis in Excel (September’23)

• Worked on a sample company's sales data using MS Excel.
• Used sorting and filtering tools to reorganize and access specific information about the data.
• Used functions like IF, and VLOOK UP to create new data and relate data from different tables.
• Created Pivot Tables to summarize and look at the comparisons within the data.

• Top Performer, Cognizant Technology Solutions Ltd, (2023-Present)

     - Consistently achieved targets and received recognition for good performance. 

• Top Grade, Lovely Professional University, Punjab (2018-2021)

     - Consistently ranked at the top of my class throughout my entire graduation.

• Advancement in Technologies of Water Management in Rural Areas, 10/23
• Phosphate Solubilizing Microbes: A Sustainable Tool for Healthy Agriculture, 08/21, http://www.envirobiotechjournals.com/article_abstract.php?aid=11613&iid=334&jid=3

• International Conference on Bioscience and Biotechnology, Punjab (November’19)

      -Volunteering in Stage Committee

• Youth Speak Forum, Punjab (September’19)

      -Volunteering in Stage Committee

• AIESEC, Punjab (August-December’19)

      -Global Volunteering Experience in Business and Marketing