Leading a dynamic team dedicated to bolstering external partnerships, I spearhead the complete lifecycle of project delivery utilizing the BCBSM data mart. My role encompasses a comprehensive spectrum of responsibilities: from initial requirement gathering and meticulous analysis design to adept data extraction via SQL. Following data retrieval, I delve into rigorous result analysis, craft insightful reports, and ensure effective communication of findings to both management and key stakeholders.

Working closely with key business stakeholders to ensure their work was focused on business priorities - weekly meetings with our primary business partner. Communication to ensure deliverables and delivery dates were clear, and frequent statuses were provided.Nearing completion of successful delivery of data and reports for 2 key customers who have transitioned to Medicare Supplemental. Required collaboration with multiple areas within the corporation.Management of a team of… Show more Working closely with key business stakeholders to ensure their work was focused on business priorities - weekly meetings with our primary business partner. Communication to ensure deliverables and delivery dates were clear, and frequent statuses were provided.Nearing completion of successful delivery of data and reports for 2 key customers who have transitioned to Medicare Supplemental. Required collaboration with multiple areas within the corporation.Management of a team of analysts and programmers in support of Medicare Advantage at a time of significant transition. Specifically, maintaining support of the business during the transition of key staff members to other roles and responsibilities, the hiring and training of new staff members, and the transition of the department to a more data-focused role rather than analytic role. Capacity planning, base project prioritization, base project reporting throughout the course of transition between different tracking systems. Project management for work utilizing the BI technical experts, removing roadblocks and staying on track with teams involved in design, analysis, construction, testing, and implementation. While at the same time communicating statuses with the business and obtaining input and approvals as needed. Show less

Care management analytics. Estimating care management savings and clinical quality improvements for Senior Leadership. Led implementation of BlueHealthConnection case selection and stratification, working with Dr. David Wennberg of Health Dialog. Ongoing enhancement of criteria. Liaison with Health Dialog for data transfers and program analyses.Business Intelligence. Project Manager for creation of SQL database to track commercial care management data; Data Steward for External Lab… Show more Care management analytics. Estimating care management savings and clinical quality improvements for Senior Leadership. Led implementation of BlueHealthConnection case selection and stratification, working with Dr. David Wennberg of Health Dialog. Ongoing enhancement of criteria. Liaison with Health Dialog for data transfers and program analyses.Business Intelligence. Project Manager for creation of SQL database to track commercial care management data; Data Steward for External Lab Values.Medicare Advantage. Working with Thomson MedStat on study of Medicare Advantage care management savings. Leading Fast Track for Medicare Program Activity data, including business requirements and execution of data feeds from 2 vendors. Show less

Long-Term Care- Directed implementation planning working with legal, regulatory, finance, marketing, communications and advisory councils.- Presented BCBSM certificates and riders to HCDC Board committee .- Developed and presented financial forecast to Finance Committee of BoardDeveloped presentations for VP Marianne UdowSupervised junior staff members' preparation of papers, presentations

Research, planning and analysis for a wide variety of projects, for example:- Whether BCBSM/BCN should expand its Medicaid HMO - What BCBSM's position should be on federal small-group legislationAnalysis of Long-Term Care led to recommendation that BCBSM enter the market - approved by senior managementLong-Term Care- Directed implementation planning working with legal, regulatory, finance, marketing, communications and advisory councils.- Presented BCBSM… Show more Research, planning and analysis for a wide variety of projects, for example:- Whether BCBSM/BCN should expand its Medicaid HMO - What BCBSM's position should be on federal small-group legislationAnalysis of Long-Term Care led to recommendation that BCBSM enter the market - approved by senior managementLong-Term Care- Directed implementation planning working with legal, regulatory, finance, marketing, communications and advisory councils.- Presented BCBSM certificates and riders to Board.- Developed and presented financial forecast to Board.Developed presentations for Vice President.Supervised junior staff members' preparation of papers, presentations Show less

Actuarial lead within the team responsible for the valuation and purchase of the Accident Fund Company and PPOM.Actuarial lead directing the calculation of the Hospital Copayment Rebate Settlement, between BCBSM and the State of Michigan.Responsible for developing and ongoing management of the BCBSM Financial Forecast - also trained new staff.Analyzed and monitored corporate claims reserves and target reserve levels.