PIYUSHA GUNJAN
Redmond,WA
Summary
With a proven track record of enhancing data-driven decision-making, I spearheaded analytics initiatives at EPIC, significantly reducing data processing time by 20%. Skilled in SQL, Python, and Tableau, I excel in transforming complex datasets into actionable insights. My collaborative approach and effective communication have streamlined reporting processes, exemplifying my technical expertise and leadership abilities.
Overview
9
9
years of professional experience
Work History
Claim Data Analyst
CCHP
07.2024 - Current
- Led the development and implementation of ETL processes to integrate disparate healthcare data sources, including electronic health records (EHR), claims, Provider rosters Data, and patient satisfaction surveys
- Utilized SQL to extract, transform, and analyze large Datasets for insights into patient demographics, clinical outcomes, and healthcare utilization patterns
- Implemented quality control measures to ensure the accuracy and reliability of automated processes, including error handling and validation checks
- Collaborated with eligibility and enrollment, provider network management, compliance departments, and external clients, including Covered California and other small EDI groups, to establish data requirements, validate data quality, and ensure adherence to healthcare regulations (e.g., HIPAA)
- Designed and maintained interactive dashboards and reports using data visualization tools such as Tableau or Power BI to facilitate data driven decision-making at all levels of the organization
- Presented findings and recommendations to executive leadership through clear and actionable insights, contributing to strategic planning and resource allocation decisions
- Developed and maintained data pipelines using SQL and Excel to automate data ingestion, cleansing, and transformation tasks, reducing manual effort and improving efficiency
- ACHIEVMENT: Implemented streamlined data collection procedures, resulting in a 20% reduction in data processing time
- ACHIEVMENT: Automated SSRS report design process, reducing development effort by 30% and improving report accuracy and timeliness.
Claims Data Analyst
EPIC
05.2023 - 07.2024
- Led comprehensive workers' compensation analytics initiatives, leveraging advanced data analysis techniques and Tableau for dynamic reporting and dashboard creation
- Spearheaded workers' compensation analytics initiatives, ensuring data accuracy and relevance
- Utilized advanced data collection techniques from various sources, including internal databases and external platforms
- Conducted thorough data cleaning and transformation processes to enhance data quality and integrity
- Developed new metrics and key performance indicators (KPIs) to provide deeper insights into claims data
- Generated and maintained a comprehensive range of reports, including Claim Review Reports and Weekly/Monthly/Quarterly Claim Status Reports, tailored to client requirements
- Produced over 300 reports tailored to meet the diverse needs of clients across Northern California, representing various sectors
- Distributed reports efficiently to clients, ensuring timely delivery and responsiveness to inquiries and feedback
- Collaborated effectively with cross-functional teams to gather requirements and deliver tailored solutions to clients
- Demonstrated strong communication skills in conveying complex technical concepts to non-technical stakeholders, ensuring clarity, and understanding
- Performed ad-hoc analysis and delivered presentations to technical and non-technical audiences, facilitating informed decision-making, and enabling effective communication of results
- Trained team members on different tools and technologies, enhancing skills and productivity by 45%
- Attended partner meetings to develop domain expertise and analyze relevant data sets and metrics
- ACHIEVMENT: Implemented streamlined data collection procedures, resulting in a 20% reduction in data processing time
- ACHIEVMENT: Automated Tableau report design process, reducing development effort by 30% and improving report accuracy and timeliness.
HR Compensation Data Analyst
Test Yantra
10.2019 - 03.2022
- Understand the functionality and business requirement by connecting with Business Stakeholders and document business functional requirements into the technical specification document
- Partners with HR Business Partners to design people analytics metrics and develop standard and ad-hoc reports to identify trends and/or issues related to attrition, headcount, talent acquisition and mobility
- Performed descriptive and diagnostic analytics to extract key findings utilizing Tableau
- Build and Design monthly and quarterly HR Dashboards to track trends of KPI's related to talent acquisition
- Perform data manipulation to build SQL Script to be used in BI Tools (Tableau, Qlik Sense)
- Perform complex aggregation of data coming from multiple Data Sources
- Build Relational and Dimensional Data Models by getting Data from several data sources including Data Warehouse, Data Mart, and Relational Database
- Perform Ad-hoc analysis and presentations of results for technical and non-technical audiences
- Extract actionable insights from complex data sets and report insights via internal dashboards and visualization to business stakeholders
- Develops and maintains productive working relationships with other teams across Information Technology to facilitate the development of cross-functional software deliveries
- Analyze and interpret compensation data to help my organization to develop fair and competitive pay structures
- Including experience with benchmarking, market analysis, and data modeling
- Communicate complex compensation data and analysis findings to non-technical stakeholders, such as senior executives or HR business partners
- Emphasize my ability to work with cross-functional teams to gather and analyze data, make recommendations, and implement changes
- Experience managing compensation-related projects from start to finish, including defining project scope, developing project plans, and tracking progress
- Ability to manage and manipulate large sets of data while ensuring accuracy and completeness
- ACHIEVMENT: Implementation of service level metrics reduces the average time to hire from 9.4 days to 5.2 days
- ACHIEVMENT: Automated standard reports and data validation, decreasing standard report workload by 75%.
HR Recruitment Specialist
Test Yantra
09.2018 - 09.2019
- Performed end-to-end technical recruitment across the UK and European markets, sourcing from job portals like CW Jobs and Monster
- Conducted pre-screening calls, negotiated salary details, and managed recruitment administration efficiently
- Maintained GDPR-compliant candidate database, built influential candidate relationships, and provided timely feedback
- ACHIEVEMENT: Recruited and oriented over 500 new permanent and contract employees across multiple clients in the UK and European Region.
HR/Business Development Executive
Test Yantra (Q Spiders)
10.2017 - 09.2018
- Recruited consultants for IT companies, engaging with HR Managers to customize recruitment solutions
- Generated new business opportunities through networking, cold calling, and advertising
- Developed rapport with clients, planned persuasive approaches, and consistently exceeded revenue targets through effective sales strategies.
HR Relationship Officer
Hinduja Global Solutions PH
09.2016 - 09.2017
- Managed end-to-end recruitment processes, including sourcing, screening, and coordinating interviews for technical professionals across various levels
- Collaborated with Account Managers to align job requirements, meet deadlines, and led a proactive team with enthusiasm and positivity.
Education
Bachelor of Technology - Computer Science and Engineering
MATS University
01.2008
Google Data Analytics Certificate -
Tableau Certification -
SRHM-CP -
Certified Human Resources Executive (CHRE) -
Skills
- SQL Server
- Big Query
- Oracle
- Postgres
- ETL
- Python
- Database Query Language
- My SQL
- MS SQL
- Oracle SQL
- Postgres SQL
- Data Discovery/Data Visualization
- Tableau
- Power BI
- Microsoft Excel
- R
- Tidyverse
- Janitor
- Ggplot2
- Here
- Shiny
- Plotly
- Pandas
- NumPy
- Matplotlib
- Seaborn
- MS Office
- Word
- Power Point
- Outlook
- Talent Acquisition
- Recruitment
- Sourcing Strategy
- Interviewing
- Negotiation
Timeline
Claim Data Analyst
CCHP
07.2024 - Current
Claims Data Analyst
EPIC
05.2023 - 07.2024
HR Compensation Data Analyst
Test Yantra
10.2019 - 03.2022
HR Recruitment Specialist
Test Yantra
09.2018 - 09.2019
HR/Business Development Executive
Test Yantra (Q Spiders)
10.2017 - 09.2018
HR Relationship Officer
Hinduja Global Solutions PH
09.2016 - 09.2017
Google Data Analytics Certificate -
Tableau Certification -
SRHM-CP -
Certified Human Resources Executive (CHRE) -
Bachelor of Technology - Computer Science and Engineering
MATS University
Similar Profiles
Charneice McClainCharneice McClain
Recovery Specialist at CCHPRecovery Specialist at CCHP
Jonida DuqueJonida Duque
Director at Central Community Health Partnership (CCHP), a program of Open SkyDirector at Central Community Health Partnership (CCHP), a program of Open Sky
Dawit GebreslassieDawit Gebreslassie
Security Officer at Axum HotelSecurity Officer at Axum Hotel
Deepak JainDeepak Jain
Senior Manager –Supply Chain & Program Management at AmazonSenior Manager –Supply Chain & Program Management at Amazon
Victoria RodriguezVictoria Rodriguez
Babysitter at Jennifer PalmerBabysitter at Jennifer Palmer