Hello

Summary: Leading a team of highly skilled managers and analysts to develop innovative reporting and analytics and meet the needs of internal and external Medicare clients. Developed and enhanced current reporting automation to achieve savings of 20,000 work hours. Migrated the data analytics team to use new data engineering tools to improve workflow and streamline reporting assets. Designed an algorithm to calculate medication adherence scores for Medicare Advantage patients.

• Leading three teams: Reporting & Visualization; Markets, Pharmacy, & Risk Analytics; and Automation & DQA teams

• Provide mentorship, training, and development to direct reports

• Define, own, and deploy Data Analytics and Reporting roadmaps for CareAllies and other Cigna Government lines of business

• Transform raw data using SQL, Python, or SAS into scalable reporting that is insightful and user-friendly to users with varying backgrounds

• Design and develop innovative dashboards using Excel, Tableau, Power BI, and Plotly

• Maintain and improve upon existing reporting by building centralized data sources and implementing automated solutions in Airflow

• Lead the automation team to deploy code and processes using Jenkins and GitHub

• Work with data science partners to identify opportunities for using advanced analytics and machine learning solutions

• Evaluate and utilize Social Determinant of Health data (SDoH) to identify customers most at risk due to socioeconomic factors

• Build and support medication adherence reporting for CareAllies and Cigna Medicare Advantage

• Lead the Markets & Risk Analytics team to analyze market trends and identify top geographic expansion opportunities

May 2019 - Jan 2021

Agile Business Analytics Advisor

Evernorth - Cigna

Summary: Led the development of a next-generation healthcare analytics platform that cuts cost and enhances quality of care. The initial product release was successful and helped analysts and clinicians enhance the forecast for savings opportunities from Cigna’s partners.

• Data integration and product design lead for Cigna’s Network Analytics team (Blueprint)

• Helped leadership develop and present solutions roadmaps and integration planning for the Enhance Quality of Care Agile teams

• Developed cutting-edge informatics to evaluate cost and quality opportunities, which help eliminate unnecessary utilization consumption, enhance provider quality of care, and improve the well-being of Cigna customers

• Lead the data engineering team to facilitate AWS deployment, automation, and DQA procedures

• Worked with data scientists to develop next-generation incentives models for Fee-for-Value and Fee-for-Service

• Lead the UX/UI design and product personalization

• Designed and conducted product demos and training for the new platform

• Built dashboards in Tableau and Power BI to serve as a prototype for the Blueprint application

• Converted and integrated current SAS process into a scalable and automated process using Hadoop Hive queries
   

Cost Containment Analytics Manager

Feb 2021 - Present

Cigna

Summary: Led the development of a scalable ETL system that leveraged automation and support of Cigna’s offshore team. The final product expanded the analytics capability of the team and helped cut costs by reducing SLA time from 10 to 4 workdays.

• Data Lead and Architect for the Out-of-Network Cost Containment claims database

• Supervised a team of onshore and offshore developers to migrate the department’s ETL process to a scaled and highly automated end-state

• Product owner of all analytics projects for Non-Participating (NonPar) provider data and medical economics department

• Provided logical and physical database design and modeling for enterprise solutions

• Performed NonPar analysis, data mining, ETL, and reporting on an ad-hoc basis using SAS, SQL, Excel, and Tableau

• Lead the data governance team to resolve data discrepancies and increase data quality

• Built interactive Tableau dashboards as a front-end BI tool for MS SQL Server, Oracle, and Teradata reporting tables

• Managed projects between onsite and offshore teams with agile methodology using JIRA

• Building automated dashboards using Excel and Tableau to perform QA checks for monthly loads

• Building earnings reports with forecasting and trend analysis using Tableau and Python statistical libraries

• Migrated the NonPar datastore from using old legacy upstream sources to the new enterprise data warehouse

• Created a wiki for process documentation and diagrams in confluence and built code repository using GIT

Data Engineering Senior Specialist

Jan 2013 - May 2016

Cigna

Summary: Led one of the engineering teams that helped build the foundation for Cigna’s corporate data warehouse, which served as a hub for multiple applications and BI reports for medical and pharmacy analytics.

• Worked as a Data Engineer to build a new, high-performance cost analysis application that utilizes Cigna’s big data warehouse and uses Tableau to visualize markets and cost drivers

• Worked on finding effective ETL solutions to load raw medical and pharmacy data from DB2, SAS, and Oracle sources to Teradata

• Built, maintained, tuned, and scheduled table loads using Teradata’s BTEQ, stored procedures, shell scripts, DataStage, and CA ESP scheduler

• Created bash scripts in Unix and utilized Regex and Perl to clean up, scrub, and sort raw datasets

• Used TD Viewpoint, Stats, and Explain Plans to help optimize SQL queries for business users

• Led QA and unit testing for data warehouse migration to minimize data discrepancies and improve quality

• Trained and supervised team members and prioritized IT tasks with Agile methodology

• Collaborated with IT project managers and scrum masters to develop focused plans and solutions using Agile methodology

• Earned kudos for supporting successful flagship business initiatives and introducing new cutting-edge tools

• Helped develop tools to assist with the corporate’s migration to Windows 7 and provided walkthroughs to impacted business customers