Keith Bene

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

Cleveland, OH 44109

216-***-****

r4nfy5@r.postjobfree.com

CAREER SUMMARY

Over 15 years of healthcare administration experience has been attained

through various roles. This experience is complemented by systems

proficiency and an analytical acumen.

WORK EXPERIENCE

University Hospitals, Cleveland, Ohio 01/2012 - present

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) and schedule them

. 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

. Responsible for creating queries to define all the measures for the

WHP Accreditation project

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

cont'd

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

Nova star Home Mortgage 08/2003 - 08/2004

Loan Officer

. Analyzed customer credit reports and their current financial status to

determine their eligibility for a more favorable mortgage loan or

equity loan

. Submitted loan application to processing and underwriting for approval

. Followed-up to ensure that documents required by lender are secured in

a timely manner

Cleveland Health Network 09/2001 - 07/2003

Financial Analyst

. Responsible for monthly uploading and cleansing of insurance claims

into the claims database

. Performed several audit routines that search for claims without

capitation or ineligible members

. Responsible for identifying members which exceed certain dollar

amounts for reinsurance

. Generated reports tracking budgeted member months versus actual by

risk pool

. Responsible for designing and implementing insurance rate audits

. Created ad-hoc requests as requested

SYSTEMS CAPABILITIES

. Database and BI: Business Objects, Crystal Reports Monarch, SSRS,

SSIS

. 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