MBA 

Binghamton University

BA

University of Rochester

Diversified Healthcare Services

15950 76th St, Scottsdale, AZ 85260

Senior Programmer Analyst

Financial analysis and SQL Server database administration for a prescription benefit manager serving small employers, self-insured groups, pharmaceutical manufacturers offering coupon discount programs, Medicare providers, third-party administrators, and insurance carriers. Tracking of accumulated benefits for enrolled members of health plans.  Design of financial analysis tools and programs to invoice several millions in revenue twice monthly.  Ad hoc analyses for management, marketing proposals and special customer requests.  

Employment

​SQL programming and database administration; financial analysis and reporting; design of programs to support EDI in a variety of formats.  Creation of web-based tools and software applications for reporting and database maintenance; compiling documentation and training for applications.

Richard Zencker

Data Analyst / Programmer

1999 - 2005

Education

Current

Terros Inc

Terros Inc., 3003 N. Central Ave., Phoenix AZ 85012

Data Solutions Developer

Design of reporting solutions for provider of behavioral health and recovery services. Creation of programs to provide reports to local and federal regulatory agencies as well as internal financial and human resources functions. Platforms include websites and iOS apps, connected to SQL Server databases.

2013 - 2015

2005 - 2013

Caremark/AdvancePCS/PCS Health Services

9501 E. Shea Blvd., Scottsdale, AZ 85260

Lead Analyst

Design of reporting suites for three large automated mail pharmacies to show volume, turnaround time, and manage pharmacy operations.  Design of special tools to monitor pharmacy services and compliance with performance guarantees for large clients such as Federal government employees.  Platforms supported included large mainframes with IBM DB2 databases as well as smaller SQL Server installations.

Skills

Zephyr Computing, Principal

Design and implementation of database and analytics solutions for finance, health care, and insurance.