Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

Preeti Kumari

Gurugram

Summary

Data Analyst with 2 years of experience in data visualization, statistical analysis, and predictive modeling. Proven ability in problem-solving and critical thinking, leading to successful project outcomes and enhanced team collaboration. Overall 9 years of experience in healthcare operations, contributing to improved data-driven decision-making.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Data Analyst

Teleperformance
Gurgaon
10.2024 - Current
  • Executed SQL queries to extract critical operational data from diverse sources.
    Integrated datasets using Power Query in Excel and Power BI for unified analysis.
    Applied DAX functions in Power BI to conduct in-depth data analysis and generate insights.
    Developed interactive visualizations, including charts and dashboards, to enhance data representation.
    Cleaned datasets by addressing missing values, duplicates, and inconsistencies using Excel and Power Query.
    Designed comprehensive data models in Power BI with established relationships and KPIs aligned with objectives.
    Monitored real-time business performance through live data connections and automated reporting in Power BI.
    Performed advanced analytics using DAX for trend analysis and predictive modeling, revealing key insights.

Career Break and Upskilling

Self Employed
Gurgaon
09.2023 - 09.2024

Data Analyst

Optum (UHG)
Gurugram
11.2022 - 08.2023
  • Utilized data-driven approaches to improve organizational performance and patient outcomes.
  • Created intuitive visualizations from complex datasets for strategic analysis.
  • Developed user-friendly dashboards that support data-driven decision-making processes.
  • Produced detailed reports to convey insights clearly and concisely.

Process Expert

Optum (UHG)
Gurugram
07.2016 - 10.2022
  • Revised provider demographic and contractual information for members via United Healthcare website, leveraging Phycon system to enhance platforms utilized by United Healthcare for community plans and uphold Network Database (NDB).

AR Analyst

Accretive Health
Gurugram
07.2014 - 11.2015
  • Navigated complex medical billing denials for providers, including physicians and hospitals, ensuring optimal reimbursement through effective engagement and follow-up calls regarding denial updates.

Executive

IBM Daksh
Gurugram
10.2012 - 06.2014
  • Ensured accurate processing and completion of medical claims with exceptional attention to detail.
    Consistently processed claims outside automatic adjudication, meeting stringent turnaround standards efficiently.

Education

EPGP - Data Science and Machine Learning

International Institute of Information Technology (IIIT)
Bangalore
08.2024

MBA - Information Technology and HR

Amity University
NOIDA
05.2015

Skills

  • Programming languages: Python, SQL
  • Data libraries: Pandas, NumPy, Matplotlib, SciPy, Scikit-learn, Statsmodels
  • Visualization tools: Power BI, Excel
  • Machine learning techniques: Supervised learning, Unsupervised learning, Time series analysis, Predictive modeling, Statistical techniques, Model evaluation and validation, Feature engineering
  • Software proficiency: Jupyter, Visual Studio, GitHub, Anaconda, Microsoft Power BI, Microsoft Teams, Microsoft PowerPoint, MySQL
  • Soft skills: Dynamic storytelling, Engaging presentations, Proactive client management, Cross-functional collaboration, Strategic analytical thinking

Certification

  • SQL: HackerRank SQL Intermediate https://www.hackerrank.com/certificates/37f166a5f4c9
  • Python: HackerRank Python Basic https://www.hackerrank.com/certificates/31dbe9309b6a
  • Data analytics: Google Data Analytics https://www.coursera.org/account/accomplishments/professional-cert/GCWIH2WYTP6D

Projects

Customer segmentation analysis| SQL, Excel, Python

  • Utilized RFM analysis and the K-Means algorithm to segment customers, boosting sales efficiency by 20%, and improving retention
  • Developed Power BI dashboards to share insights and support data-driven decisions

Financial performance analysis| Excel, SQL, Power BI

  • Analyzed expenses to identify high-cost areas and spending patterns, providing insights for more accurate financial forecasting
  • Compared actual spending against set financial targets to highlight discrepancies and inform adjustments in financial strategies

Insurance premium sales analysis| Excel, Power BI 

  • Implemented Power BI dashboards for real-time sales insights, highlighting top and underperforming areas
  • Automated sales reporting through Power BI reduces manual work, cuts labor costs, and enhances reporting accuracy for better strategic planning

Customer churn analysis| Power BI, DAX, Power Query, Python, and data visualization

  • Built a comprehensive dashboard that provides an overview of customer churn metrics and visualizations
  • Created visualizations to represent customer churn trends over time, comparing different segments, and utilized charts, graphs, and tables to highlight key insights and anomalies

Timeline

Data Analyst

Teleperformance
10.2024 - Current

Career Break and Upskilling

Self Employed
09.2023 - 09.2024

Data Analyst

Optum (UHG)
11.2022 - 08.2023

Process Expert

Optum (UHG)
07.2016 - 10.2022

AR Analyst

Accretive Health
07.2014 - 11.2015

Executive

IBM Daksh
10.2012 - 06.2014

EPGP - Data Science and Machine Learning

International Institute of Information Technology (IIIT)

MBA - Information Technology and HR

Amity University

Similar Profiles

CREATE PROFILE
Preeti Kumari