EPIC, Clarity, ETL, DBA

Tim Blagbrough

Senior Technical Specialist / SQL Server DBA / Epic Clarity ETL Administrator

*************@*****.***

Summary

Over eighteen years of experience within the information technology field in diversified environments. Areas of

expertise include AS/400 and Domino operations and administration. Business Objects, SQL Server, EPIC

Clarity ETL, Extensive knowledge with troubleshooting, communications, installations, upgrades, backup and

recovery. Knowledgeable with system security and Database installation and customization. Familiar with the

Sun Solaris platform, knowledge of CL coding, shell scripting and with all Microsoft products. Great sense of

urgency and attention to detail.

IT experience = 24 years

Healthcare Industry IT experience = 10 years

SQL Server experience= 5 years

Database Design & Development = 15 yrs

DBA experience= 10 years

Advanced Testing (planning & execution) = 10 years

Experience

Epic Clarity Consultant at Cone Health

January 2014 - Present (8 months)

Epic Clarity ETL Administrator

Windows Server Administrator

SSIS, SQL Server, Server Tuning, Windows Scripting (VBScript/Powershell)

Performance Tuning, Cluster Technology, FTP/SFTP, PGP

Certified Epic Clarity ETL Administrator at Riverside Medical Clinic

August 2012 - August 2013 (1 year 1 month)

Performed DBA activities associated with the design, deployment, use, control, monitoring, support and

performance of Clarity database management systems to ensure their optimum use within the organization.

Institutes administration policies, procedures, techniques and methodologies that enhance database support

and provides optimum integrity, performance and availability

• Ensured that proper backup strategies were in place and being followed, and verified restore media and

documentation

• Monitored database size and fragmentation levels, along with other maintenance tasks that are appropriate

for optimizing performance

• Monitored database server performance

• Applied Microsoft SQL hotfixes and service packs when necessary

• Routinely tested any failover procedures for high availability

Page1

• Verified and monitored the security of the database server

• Verified that the Clarity ETL process was completed every day. Troubleshot and resolved errors that

occurred during the ETL process

• Installed, configured, and maintained the Clarity database and ensured optimal performance and integrity

• Worked with Windows Administrators to ensure regular updates to the Clarity Console server were installed

• Modified the ETL process in response to reporting needs, as necessary, performing tasks such as creating

new tables/views or performing a Clarity Compass upgrade

• Worked with report writers to identify and resolve possible discrepancies between Cache and Clarity

• Assisted in the administration of enterprise and/or departmental storage as needed

• Develop SQL Stored Procedures/Functions/Views for Analytical reporting

• Optimize existing SQL queries

• Exposure to Meaningful use and Core measure reports

• Respond to change requests and incidents for the reporting team

• Provide training and tip sheets for end users and report writers

• Develop SQL extracts for third party vendors

• Deploy Clarity reports in both BOE Infoview and Epic-Crystal Integration

DBA / Systems Engineer at Quill and Scribe

February 2008 - August 2013 (5 years 7 months)

Quill and Scribe is a medical transcription company with 3 locations and focuses on supporting physician

dictation.

• Was initially hired to create web presence for the firm

• Designed and built digital dictation system from scratch using a combination of FTP, MS SQL, JavaScript

and HTML.

• Developed custom application that transferred and assigned files via website

• Server Admin, primary IT support

DB2 Server DBA, Domino Administrator at Session Control Systems

March 2000 - January 2007 (6 years 11 months)

DB2 Server DBA, Domino Administrator

Session Control Systems is a medical software company that focuses on the automation of Independent

Medical Examinations.

• Was hired to architect and design the system.

• Designed and built system from scratch utilizing the Lotus/IBM Domino platform as a front end and DB2

database storage on the backend.

• System utilized first generation tablet computers not previously used in the industry

IT Consultant at E.T.C.S.

January 1997 - January 2007 (10 years 1 month)

• System Operator on AS400, Windows, and Domino systems for a web-based insurance claims processing

application.

• Developed company intranet and portal for in-house applications

Page2

• Responsible for user support and maintenance, in-house applications development and testing,

administration of hardware and license program products, performance analysis/adjustments

• Daily, weekly and monthly backups, communications troubleshooting and configurations

Certifications

EPIC Clarity ETL Administration

Epic October 2012

Courses

Computer Science

Long Island University, Brooklyn Campus

Computer Science

Skills & Expertise

Healthcare

EMR

Epic Systems

Medical Records

EHR

Business Objects

ETL

DB2

Medical Coding

Windows Server

Microsoft SQL Server

HIPAA

Software Implementation

Radiology

Medical Billing

Medical Terminology

PACS

Informatics

Healthcare Consulting

Practice Management

Revenue Cycle

Healthcare Information Technology

HL7

Healthcare Management

Physicians

Hospitals

Clinical Research

Page3

Databases

Integration

Technical Support

Database Design

Troubleshooting

Education

Long Island University, Brooklyn Campus

Computer Science, 1989 - 1991

Page4

Tim Blagbrough

Senior Technical Specialist / SQL Server DBA / Epic Clarity ETL Administrator

*************@*****.***

Contact Tim on LinkedIn

Page5

Contact this candidate