Keith Hoffman Email & Phone Number

Greater Boston

Greater Boston Area

Provide analytics from Medicaid and private dental insurer’s data. Projects\Tasks include:• Cohort\Trend analysis to determine member and cost behaviors.• Texas Medicaid\CHP date of service\payment metrics.• Shift analysis to monitor provider cost utilization.• Support Business Analysts Ad-Hoc Reporting.• Analytic’s department liason to production/data governance committee.

Wellesley, Ma

Provide information technology expertise to the actuarial department in the development and maintenance of all software programs using SAS and SQL. Projects\Tasks include:• Conversion of company’s data to Enterprise Data Warehouse (EDW)• Automating process of actuarial revenue forecasting• Member health risk analysis to determine insurance plan utilization• Detailed analysis of all components that are used to calculate PMPM (per member per month) cost analysis• Analysis of company’s claim data relevant to calculation of Pooling Charges and member cost sharing determination • Development of Age/Gender pricing factors• High cost claimant probability predicting• Membership Migration Analysis

Waltham, Ma

Data analysis and reporting for a health care performance improvement organization that specializes in Quality Improvement Programs. Projects included: • Asthma/Diabetes quality improvement analysis.• Hospital profile report for all MassHealth inpatient hospital visits.• Colorectal Screening rate by county within state of MA.• Nursing home quality measure benchmarking rates.

Westwood, Ma

Sr. Project Manager (1995 – 2005)Responsible for leading the definition of the study feasibility, data gathering, analysis, and reporting for actuarial mortality studies for the insurance industry.• Processed 125,000,000 data records to produce the Society of Actuaries 2001 Valuation Basic Table used in the pricing of insurance products. • Converted SAS code to ASCENTIAL• Received data in several formats and converted it to SAS format and exported the results to Excel.• Interfaced with clients at insurance companies on all matters relevant to the preparation of their company’s data contribution to industry studies.• Prepared Minimal Guaranteed Death Benefit Study from fixed and variable annuities.• Created 2001 CSO mortality table used in Individual Life Mortality Study• Produced Diabetes and Build studies created from Impairment data.Project Manager (1990 – 1995)• Applied SAS FREQ, SUMMARY, TABULATE, and REPORT procedures for data analysis and generating reports• Created industry data reports• Assisted in creation of Group Annuity Mortality table using existing Group Annuity data• Managed large data setsSr. Systems Analyst (1985 – 1990)• Data Preparation from raw data files using Import Techniques and modification of existing data• Created industry actuarial life insurance studies for the Society of Actuaries• Worked with Group Annuities and Disability Income• Received data in Mainframe data format

Stratford, Ct

Designer Programmer/AnalystSoftware support in development of Abrams M-1 military tank engines.

Kent, Wa

Responsible for software development and maintenance relevant to development of 767 & 757 programs.