Keith Bene

**** ***** ***** *****

Cleveland, OH 44109

216-***-****

acgxet@r.postjobfree.com

CAREER SUMMARY

Over 15 years of healthcare administration experience has been attained through various roles. This

experience is complemented by Information System proficiency and an analytical acumen.

WORK EXPERIENCE

Amerimark, Middleburg Heights, Ohio 02/2014 – present

Senior Analyst / T-SQL Developer

• Develop SSIS packages for the ETL process that loads data into the company data warehouse

and create and schedule SQL agent jobs in SQL Management Studio for these SSIS packages

• Create audit reports of the daily load to ensure the accuracy of information loaded into the DW

• Design SQL scripts to create reference tables from the initially loaded tables in the DW

• Design complex stored procedures that incorporate business logic needed to produce summary

and detailed reports for various departments of the company

• Develop views of the data that combine data from multiple tables for reporting purposes

• Create proper indexes on the tables and manage the index fragmentation of the tables

• Create reports and dashboards using Tableau and then deploy them to the server

• Create and deploy SSRS reports to Reporting Services and schedule subscriptions

• Use SQL Profiler and Performance Monitor to try to identify high resource usage jobs

• Manage the deployment of licenses and rights to end users as the Tableau Administrator

• Assign end user login and access rights to databases and objects in SQL Management Studio

• Train end users on how to use SQL Management Studio and write basic queries using T-SQL

University Hospitals, Cleveland, Ohio 01/2012 – 01/2014

Health Information Management Analyst

• Transform existing Crystal Reports to SQL Server Reports (SSRS) and deploy them to SharePoint

for internal customers to run on demand

• Convert existing Data Transformation Services (DTS) packages to SQL Server Integration

Services (SSIS)

• Compare data from different sources to ensure data is being transmitted correctly and create audit

reports to identify any inconsistencies between the systems sharing data.

• Develop SSRS reports to calculate rates for the AHRQ patient quality indicators from the US Dept

of Health and Human Services

• Create multiple productivity reports (OP, IP) that merge data from multiple data sources, the

timekeeping system (Kronos) and the coding system (Meta)

• Modify several manual report creation processes (that were previously using Excel) into

automated reports utilizing Microsoft Access

• Enhance basic canned reports with crosstabs, drill-downs, and interactive sorting features

Medical Mutual of Ohio, Cleveland, Ohio 07/2011 – 01/2012

Senior Statistical Analyst

• Identify process and system inefficiencies and determine alternative ways to improve reporting

• Write detailed documentation of all procedures and queries utilized to produce standard reports

• Design databases for measuring performance guarantees, member mailings and FTE counts

• Responsible for creating queries to define all the measures for the WHP Accreditation project

• Produce (ad hoc, weekly, and monthly) reports using DB2, QMF and Microsoft Access

cont’d

KePRO, Independence, Ohio 01/2006 – 07/2011

Health Care Business Analyst

• Generate the contract deliverables (weekly, monthly and quarterly reports)

• Calculate client savings and return on investment for each client

• Provide analysis and client recommendations in Business Intelligence briefs

• Load weekly claims (text files) and identify and report high cost/high usage members

• Produce and schedule phone reports using Nortel’s Symposium/Contact Manager

• Calculate phone reports metrics e.g. abandoned calls per hour to monitor phone queues

• Create automated tasks to run macros and export data to appropriate servers

• Create client reports using Microsoft products such as Excel, Publisher and Word

• Design forms, macros, pass through queries and reports using Microsoft Access

• Generate ad hoc reports using Crystal Reports and Business Objects

• Develop file and report naming standard for the department

• Author and deploy reports using MS SQL SSRS

Keith Bene

Hillcrest Hospital, Mayfield, Hts. Ohio 09/2004 -12/2005

Clinical Decision Support Analyst

• Produced departmental scorecards with detailed charts for specific key indicators

• Identified operational inefficiencies in daily work processes and attempted to refine the process

• Designed the database used to monitor the discharge by noon initiative for the East Region with

the premise being to free up more available beds to produce more revenue

• Created reports that break out the data by hospital, nursing floor, and physician

• Created ad-hoc reports for executive management

SYSTEMS CAPABILITIES

• Database: SQL Server 2008 and 2012

• BI: Business Objects, Crystal Reports Monarch, SSRS, SSIS, and Tableau

• Tools: Adobe Full Version, Visio, SharePoint, MS Project, SPSS, and Outlook

• Microsoft Office – Access, Excel, SQL Management Studio, PowerPoint, Publisher and Word

• Operating Systems: Windows server 2000-2008, Windows XP, vista, Windows 7

TECHNICAL SKILLS

• Skilled in business process analysis, statistical and econometric data analysis and development of

business intelligence, business analytics and databases

• Healthcare knowledge, financial analytics, problem solving, project leader

• Resourceful in data extraction, data manipulation, and adapting to new processes and

technologies.

• Experience with researching data quality issues, performing root cause analysis and presenting

findings

EDUCATION

Cleveland State University Cleveland, Ohio

Master of Arts in Economics, 1993

Bachelor of Arts, Major: Economics; Minor: Mathematics, 1991

References available upon request

Contact this candidate