SSRS, SSIS, T-SQL, BI
Resume:
Keith Bene
Cleveland, OH 44109
**********@*****.***
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