Janani Sabapathy
Edison
Summary
Results-driven Data Analyst with expertise in SQL and data visualization, honed at Change Healthcare. Achieved an 18% improvement in payer match rates through rigorous data validation. Skilled in developing executive dashboards and automating reporting processes, leveraging strong problem-solving abilities to enhance decision-making and operational efficiency.
Overview
8
8
years of professional experience
Work History
Data Analyst
Change Healthcare
Nashville
01.2020 - 12.2024
- Led cross-functional analytics initiatives focusing on eligibility, claims, provider quality, and utilization management across national payer networks, which enhanced decision-making capabilities and improved data reliability.
- Identified and resolved discrepancies in eligibility feeds using SQL-based validation, resulting in an 18% improvement in payer match rates and a reduction in claim rejections.
- Built executive dashboards in Tableau and TIBCO Spotfire to monitor over $100M in annual claims, boosting transparency and operational efficiency for stakeholders.
- Designed and automated ETL pipelines using SQL and Python, creating robust and scalable data workflows that streamlined reporting processes.
- Developed responsive UI components with HTML5, CSS3, JavaScript, React.js, and Node.js, which significantly improved the overall user experience.
- Transformed and integrated various data formats such as JSON, Avro, and Protobuf for payment services, ensuring compatibility and efficiency.
- Integrated Jenkins for CI/CD automation, which effectively reduced build, test, and deploy cycle times, leading to faster delivery of updates.
- Developed optimized SQL queries and data models for PostgreSQL and Snowflake, ensuring both data integrity and high performance.
- Utilized AWS RDS for PostgreSQL to guarantee automated backups, high availability, and scalability of our data solutions.
- Delivered comprehensive analytics solutions for claims, revenue cycle, and payer-provider interactions, supporting key strategic initiatives within the organization.
- Defined key performance indicators (KPIs), standardized data definitions, and implemented validation checks that led to a 35% reduction in errors, enhancing data reliability.
- Applied Python (Pandas, Scikit-learn) and predictive modeling techniques to identify cost-saving patterns in patient behavior, providing actionable insights.
- Provided strategic insights through dashboards and presentations that influenced provider and claims workflows, driving more informed decision-making.
- Ensured HIPAA compliance and supported internal audits, maintaining the integrity and confidentiality of sensitive data.
- Automated executive reports by integrating Snowflake queries with Python and Excel, saving over 40 hours per month in manual reporting efforts.
- Designed Power BI dashboards to track claims, eligibility, and provider performance, which ultimately influenced decisions impacting over $100M.
- Improved SQL query performance by 70% through effective indexing and optimized joins in Snowflake and SQL Server, yielding faster data retrieval times.
Data Analyst
Hyve Solutions
CA
09.2017 - 03.2018
- Collected, cleaned, and maintained operational and supply chain data from multiple sources, which ensured high-quality input for analytics and reporting.
- Built interactive dashboards in Tableau and Power BI to monitor key metrics, including inventory turnover, production cycle times, and on-time delivery rates, which provided clear visibility into performance.
- Collaborated with engineering and manufacturing teams to define reporting needs and translate business questions into SQL queries and data models, helping to align data efforts with business objectives.
- Developed automated scripts in Python to streamline data validation, reporting delivery, and anomaly detection, which saved over 30 hours per month in manual effort and improved efficiency.
- Identified process inefficiencies and proposed data-driven improvements, resulting in a 15% increase in reporting speed and better executive visibility, which enhanced decision-making capabilities.
Billing Associate
PG&E
CA
03.2017 - 09.2017
- Processed and validated high volumes of customer billing data to ensure accuracy and compliance with utility regulations.
- Reconciled billing discrepancies by analyzing usage reports, reducing errors by 20%.
- Utilized advanced Excel functions, including VLOOKUP and PivotTables, to track billing cycles and create summary reports.
- Collaborated with finance and customer service teams to resolve escalated billing issues, improving resolution time.
- Developed proficiency with data entry systems and billing analytics, establishing a strong foundation for data analysis roles.
- Provided critical data for rate analysis and energy usage trends, enhancing operational reporting.
Education
MBA - Professional MBA
Campbellsville University
KY, UNITED STATES03.2020
Master of Science - computer science
Northwestern Polytechnic University
CA, UNITED STATES12.2016
Skills
- Data analysis and reporting
- SQL expertise
- Data profiling and validation
- KPI development
- Trend and cohort analysis
- Statistical analysis
- Business intelligence tools
- Tableau and Power BI
- Dashboard and visualization development
- Python programming
- R basics
- Shell scripting and API integration
- Database management systems
- Snowflake and PostgreSQL proficiency
- Data modeling techniques
- Cloud technologies expertise
- AWS and Azure services
- ETL orchestration tools
- Healthcare data compliance
- Medical billing knowledge
- Soft skills in problem-solving
Timeline
Data Analyst
Change Healthcare
01.2020 - 12.2024
Data Analyst
Hyve Solutions
09.2017 - 03.2018
Billing Associate
PG&E
03.2017 - 09.2017
MBA - Professional MBA
Campbellsville University
Master of Science - computer science
Northwestern Polytechnic University