CHERIE O’DONNELL
North Tonawanda,NY
Summary
Accomplished Senior Business Analyst with a proven track record at Wellsense Healthplan and Independent Health, adept in SAS and SQL, and skilled in translating complex data into actionable insights. Excelled in enhancing decision-making for senior management through advanced data analysis and Tableau dashboards, demonstrating exceptional analytical and collaborative abilities.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Senior Business Analyst
Wellsense Healthplan
Boston, MA
08.2022 - Current
- Support the bid renewal process for the Medicare Advantage line of business
- Build Tableau dashboards for Senior Management from EDW data, including membership, claims, revenue and expense (MLR)
- Analyze claims data showing cost drivers
- Support the Sales team by building a Tableau dashboard showing the daily sales during Medicare AEP and throughout the year
- Complete ad hoc requests as needed for Senior Management and various departments
- Complete competitive intel analysis showing plan comparisons to various carriers and enrollment by plan
Actuarial Analyst – Senior
Independent Health
Buffalo, NY
01.2020 - 08.2022
- Support budget development process including forecasting and actual to budget comparison
- Support the Medicare bid process, providing claims extracts to the third-party Actuaries
- Responsible for development, support, and improvement of developmental projects with minimal supervision
- Understands multiple sources of data, able to identify and utilize most relevant source to complete task
- Ensures overall data integrity
- Complete monthly reporting for Senior Management including MCR reports, group reporting, trend detail reports and monthly accruals for Accounting
- Complete ad hoc reports as requested by Senior Management
- Interview and provide input on the hiring of summer intern candidates for the Actuarial and Underwriting department
Research Analyst – Senior
Independent Health
Buffalo, NY
01.2016 - 01.2020
- Prepare Employer Performance Reports for group accounts, gathering, compiling, validating and analyzing claims data, identifying key drivers and trends for Fully Insured and Self-Funded accounts
- Analyze claims data based on Place of Service, Utilization, Demographics, High Dollar Members, Milliman Medical Episode Groupers, Emergency Room and Urgent Utilization, Maternity, Mental Health/Substance Abuse, Primary Care Physician Analysis, Preventive Care Compliance, Disease Registry, and Pharmacy Trends
- Work collaboratively with other departments, including Sales and Wellness, to execute the Employer Performance Report delivery in a timely and accurate manner
- Extract, summarize, validate, and analyze data for ad hoc requests in a meaningful way that meets the needs of the organization, brokers, and clients ensuring adherence to HIPAA
- Review EPRs and ad hocs for other associates in the department to ensure quality
- Ensure instructions for EPR processes are accurate for internal associate use
- Update the EPR process, as needed, based on changes requested by Sales, Clinical Account Managers, and MedInsight grouper changes
- Assist in the interview process and training of new hires in the department.
Underwriter/Actuarial Analyst
Independent Health
Buffalo, NY
08.2007 - 01.2016
- Accountable for the preparation of prospective, retrospective, minimum premium, premium equivalent, and fixed rates for existing and new business, maintaining confidentiality, analyzing cost drivers, and ensuring adherence to NYS filed formula
- Audit business associates’ rate development for quality assurance
- Provide professional consultation to Sales on rate development and assist in Broker/Client meetings
- Work on cross functional teams regarding new and existing business custom plan builds
- Propose, assist in the development, and implement process improvements within the department
- Assist with training new hires within the Underwriting Department
- Maintain a schedule of prospective business for the Underwriting Department which documents key elements for rating
- Prepare ad hoc reports for Senior Management
- Prepare prepaid premium reports, retrospective rating schedules, premium deferral schedules, and minimum premium schedules for Accounting in a timely and accurate manner
- Interview and provide input on the hiring of summer intern candidates for the Actuarial and Underwriting department
- Oversee the department intern projects to ensure deadlines and quality metrics were met
Education
Bachelor of Business Administration - Finance And Business/Public Management
SUNY Institute of Technology
Utica, NYSkills
- SAS proficiency
- SQL proficiency
- Data warehousing
- Data analysis expertise
- Tableau
- Microsoft Excel
- Microsoft Word
- Microsoft Power Point
Certification
- Managed Healthcare Professional (MHP)
- Professional Academy for Healthcare Management (PAHM)
References
References available upon request.
Timeline
Senior Business Analyst
Wellsense Healthplan
08.2022 - Current
Actuarial Analyst – Senior
Independent Health
01.2020 - 08.2022
Research Analyst – Senior
Independent Health
01.2016 - 01.2020
Underwriter/Actuarial Analyst
Independent Health
08.2007 - 01.2016
Bachelor of Business Administration - Finance And Business/Public Management
SUNY Institute of Technology
Similar Profiles
Kimberly CavettKimberly Cavett
Supplier Relationship Manager Senior at WellSense Health PlanSupplier Relationship Manager Senior at WellSense Health Plan
Princess BellamyPrincess Bellamy
Member Service Representative at Wellsense HealthMember Service Representative at Wellsense Health
Sonia Lynnette WilsonSonia Lynnette Wilson
Business Project Manager at Kaeppel Consulting - WellSenseBusiness Project Manager at Kaeppel Consulting - WellSense