Execution for GBD and CSBD Health Outcomes and Analytics servicing New Hampshire and North Carolina local markets.

Medicare CoC for Elevance's GDB Health Outcomes and Analytics.

Fully embedded at Anthem's GBD HCCO team focusing on Indiana Medicaid CoC via a special funding arrangement as a vendor.

As part of the Finance and Reporting team, I am responsible for sales reporting, breaking our P&L down to a group client level, partner bonus program calculations, market penetration and opportunity reporting and all things SQL (P/L SQL and TSQL). I work closely with our actuary, underwriting, and accounting teams on data needs. While working with our Salesforce administrator; I build, run, and help with data governance and clean up on a monthly basis.

Perform rate setting calculations and analysis of final rates for Medicaid pharmacy programResearch drug pricing variances and make recommendationsDesign,analyze and report, on metrics to help clients manage the programExtensive use of SQL and Excel to perform analysis using stored procedures, views, and T-SQL -Mimicked claims processing system for claims repricing -Migrated data to increase efficiency reduce query times -Used SSIS, SSRS, SSMS, and Excel to load, review, analyse, and report data to clientSupport other areas of the firm with Excel knowledgeDevelop reporting and processes to improve current workflowWork closely with IT developer and data teams

Manage reports for system calibration and analysis Design and implement new reports for C level review quarterly Report investigator effectiveness to management Prepare monthly workflow for investigations teams Support AML department with IT and automation of reporting Build use cases for Business Objects reporting Audit monthly processes internally

Manage reports for system calibration and analysisDesign and implement new reports for C level review quarterlyReport investigator effectiveness to managementPrepare monthly workflow for investigations teamsSupport AML department with IT and automation of reportingBuild use cases for Business Objects reportingAudit monthly processes internally

Managed compensation payments and modeling for 100+ sales employeesPrepared board level compensation documenration annuallyBuilt and analyzed 64 cost center budgetsAdvanced use of Microsoft Excel including use of Access, SQL, Powerpivot and other tools for data analysis. Developed effectiveness reports and sales metrics reporting for management teamsVarious ad hoc reporting