David R. Skinner **** Willamet Road
Kettering, Ohio 45429
Phone: 937-***-****
*************@*****.***
Profile Experienced Healthcare Data Analyst with expert knowledge and experience in SAS, Microsoft Access, Excel and other data analysis tools. Proven data management and analytical skills with the ability to translate large volumes of operational, financial and clinical data into practical, actionable information usable by non-technical managers. An inquisitive mind with an aptitude for puzzle solving.
Work Experience
CareSource, Dayton, Ohio (2010-present), Sr. Regulatory Reporting Analyst/Sr. HEDIS Analyst
Wrote programmatic logic for several HEDIS measures, using NCQA Technical Specifications, to verify accuracy of results produced by 3rd party HEDIS software vendor and segment each population for targeted initiatives to improve consumer health care and increase HEDIS rates.
Identified 20 low performing provider groups for a specific HEDIS measure and produced graphical reporting to facilitate a discussion with these provider groups leading to a 3.6% rate increase and state Medicaid pay-for-performance bonus increase of $2.1M.
Identified a medical coding anomaly for a specific HEDIS measure averting a potential rate decline of 4.0% leading to state Medicaid pay-for-performance bonus increase of $1.3M.
Created data structure from 3rd party HEDIS software vendor tables for data analysis, ad hoc reporting and metrics including quality measures for NCQA and the state of Ohio.
Developed reporting to meet regulatory requirements for claim prompt payment, CMS PQRI provider incentive bonus payment and state required submissions.
Examined data sets and reports to discover inconsistent patterns and trends that required further examination and led to an increase in accurate information delivery.
CareSource, Dayton, Ohio (2006-2010), Decision Support Analyst
Incorporated critical analytical thinking to ensure accurate and timely company-wide claim, member and provider reporting for Medicaid and Medicare lines of business.
Developed extensive reporting to give visibility to the Provider Relations department processes and facilitate understanding of data process and data integrity issues.
Explored extensive data relationships to identify issues and solutions for internal and external customers resulting in effective process changes.
The Berry Company, Dayton, Ohio (2005-2006), Data Analyst
Created and produced a complete sales proposal calculator in Microsoft Excel for over 500 unique telephone directories to facilitate every customer sales opportunity giving sales representatives a more comprehensive, user-friendly software tool.
Automated several existing Microsoft Excel and Access processes to ensure timeliness and accuracy of queries and reports eliminating paperwork and file redundancies.
Eastway Corporation, Dayton, Ohio (2002-2005), Data Analyst
Developed a bi-weekly agency-wide management reporting process, using Microsoft Access and Excel, allowing real-time access to key statistical measures and reporting of operating performance, labor efficiency and revenue production in a comparative format.
Facilitated financial analysis, developing a process for analyzing and reporting discrepancies and inconsistencies within the current computer system that has resulted in the recovery of lost revenue totaling 8% of total agency revenue.
Education
Rets Tech, Centerville, Ohio (July 2000)
Computer Applications and Programming, Associate Degree
Skills
Advanced knowledge of SAS Programming using SAS Enterprise Guide. Experience with Facets and Cactus databases. Advanced knowledge of Microsoft Office, most notably Excel and Access products, including the development of queries, forms, reports and macros. Working knowledge of SQL Programming, Seagate Crystal Report and Business Objects.