Sushmita Pandey

Experience

• 

  EXL

  Feb 2021 - now

  - Maintained and built relationship with onshore stakeholders, gathering requirements and ensuring timely delivery with strict client deadlines.- Complete ownership of strategizing, designing, development, testing and production of 70+ interactiveeasy to use operational dashboards and reports (Tableau and SAP BO). - Descriptive and Exploratory data analysis (SQL) to develop new KPIs and Metrics to measure patient care experience and provide actionable insights into operational processes.- Primary data sources being used are : EPIC Clarity and Caboodle.- Able to understand and implement processing ICD-9/ICD-10 , CPT codes , referral and post authorization.- Mentored fellow analysts and guided them with business workflow. Project:Nurse Triage- Enhancing nurse telephone triage for consistent, quality patient care.- Created a SAP BO report to closely monitored weekly nurse consultations, comparing them systematically to past weeks. Analyzed key metrics and pinpointed areas for improvement in efficiency and nurse productivity.- This resulted in 30% increase in the efficiency of nurse triage consults, leading to a more streamlined and effective healthcare service delivery.PMG Throughput Dashboard- Rooming optimization within medical practice to improve efficiency and enhance patient satisfaction.- Setting reasonable appointment lengths and productivity standards for VPC providers to achieve 3 pts/hr.- Consistently tracked key rooming metrics, benchmarking against established standards. Collaborating across clinics to standardize efficient rooming practices, offering training and support based on metric analysis.- Above process resulted in Improved efficiency through outlier identification and best practices, reducing wait times and enhancing patient experience. Targeted training improved resource allocation, optimizing care with data-driven decisions. Show less - Conducted regular meetings with customers and internal business units to manage requirements gathering and maintain effective communication in process of identifying most efficient approach to probable solutions to analytics needs and developing reports and dashboards (SAP BO) . - Above process involved Understanding requirements, initial data exploration (SQL), building drafts, assisted in conducting User Acceptance Test (UAT) to make sure all user requirements are catered followed by production and deployment. - Documented a simple and detailed information in Collibra referring to intended use, data sources, KPI definition, allowable exclusions and inclusion/criteria.- Managed Ad hoc request from stakeholders and aligning it with timelines.Project : Asset Integrity and documentation :- Maintaining Collibra documentation of 240+ reports, dashboards and KPI. - Managing data assets and related data policies and rule to ensure data integrity that allow users to access the most current versions of the assets and policies.GI Referral Work queue trend & stats :- Built a dashboard maintaining historical data from the referral work queue for gastrointestinal specialty to observe, on average, how long it takes from referral date to scheduled. - Observing productivity of clinic staffs ensuring patients are contacted and scheduled within the timeframe required (goal of 48 hrs.) which resulted in improving staff productivity by 20%. -KPIs : Number of outreaches, Number of referrals pushed down to work queue, Number of visits that are being scheduled, Number of miscellaneous phone calls, Nursing Note, Timestamps for difference (referral created date, scheduled date, node datetime. Show less - Executed on-premise to cloud data migration using Azure infrastructure. - Conducted workflow analysis for US healthcare processes, extracting insights from diverse Data universes like Clarity and Caboodle. - Performed in-depth secondary analysis of reports, scrutinizing coding and attributes to enhance understanding and functionality. - Built a report analyzing patient appointment wait times, helping improve timely care by identifying departments with delays.Project - Lead Time Analysis : Generated a report (SAP Business Objects) on patient appointment lead times (difference in Appointment Scheduled to Appointment made time), focusing on department-wise averages and 90th percentile lead times. Outcome: The report aims to reveal patient wait times from appointment scheduling to provider interaction, guiding efforts to reduce delays in departments with high lead times as well as monitoring lead time to physicians ratio broken down by department. This data guides strategies for timely patient care improvements. Show less

  • Assistant Manager

    Jan 2024 - now

  • Business Analyst

    Jul 2022 - Jan 2024

  • Reporting Analyst

    May 2021 - Jul 2022

  • Decision Analyst

    Feb 2021 - May 2021