Sql Server Analyst

EPIC APPLICATION SECURITY ANALYST

Experience in supervision, project management, data system design, and

budgeting. Looking for a healthcare company with a requirement for an

Epic application security analyst with extensive data handling, analysis,

and reporting experience.

SKILLS

Security environment contained: ASAP; Cadence, OptTime;

Orders; Prelude, Radiant; Resolute PB.

Over two years of security analyst experience

Completed 3 major facility implementations

EPIC Security Certification June 2011

Healthcare Industry Experience

EXPERIENCE

April 2009 - Present Bon Secours Health System Inc.; Richmond, Virginia;

Position: EPIC Application Security Analyst. Department: Enterprise

ConnectCare Security. Created/modified/deleted large datasets of EMP and

SER records via Reflections & Hyperspace (manual and import process).

Exported datasets via Reflections for data analysis and reporting using

VBA, Excel, and MS Access. Used Chronicles for on-line querying, subset

creation, and record review. Completed training: EpicCare Inpatient

Fundamentals; Clinical Administration; Chronicles. Completed EPIC

Security Certification June 2011. Completed 3 full implementations since

April 2009. Worked with INIs: EMP, SER, ECL, LPR, E2R, E2U, E2N, E2O,

HAL, HAC.

June 2008 - February 2009 Suntrust Bank; Richmond, Virginia via Modis,

Inc.; Position: Consultant, Data Analyst/Developer. Department:

Consumer Lending Strategic Reporting & Analysis. Developed automated

report generation applications using VB, Excel, MS Access and SQL Server

8.0. Complete adhoc data requests by querying SQL Server, Oracle, and

DB2 databases, creating the necessary SQL statements, formatting the

resultant datasets, and placing in MS Excel worksheets, or pivot tables.

March 2006 - March 2008 Capital One; Richmond, Virginia via Sapphire

Technologies, Inc.; Position: Consultant, Data Analyst/Developer.

Department: Internet Services. Developing and maintaining data transport

processes within the Unix and Teradata environments. Developed data

analysis applications using VBA in Excel. Test Lead for project team

centered on the development and implementation of database applications.

January 2006 - March 2006 Amerigroup; Virginia Beach, Virginia via Apex

Systems, Inc.; Position: Consultant, Business Analyst. Department: Med-

Finance. Generating User Requirements & Design Specification

documentation, along with System Test Plans for financial revenue and

expense forecasting and reporting application in MS SQL Server

environment.

November 2003 - November 2005 American Cybersystems, Inc.; Tucker,

Georgia; Position; Consultant, Data Architect @ Capital One, Richmond,

VA. Department: Technical Resource Management. Working to improve IT

project imple-mentations. Designed data migration process to move capital

investment budgetary data into Oracle-based project management system.

Developed MS Access database (linked to Oracle-based application) for the

import, processing, standardized reporting, and adhoc analysis of the

investment budgetary data.

April 2000 - March 2003 Heritage Information Systems, Inc;

Richmond, Virginia. Position: Manager, Business Systems Analysis.

Supervised and directed a small group of data analysts. Assisted in the

development of SQL Server/Visual Basic auditing application. Managed

project, collected audit user requirements, worked with programmer and

auditors for design, completed design specifications, and coded

application. Used MS SQL Server, MS Office Suite, MS BizTalk, and FoxPro

for the transporting, manipulation, analysis, and reporting of large

healthcare claim and reference data files. Mentored a programmer and an

auditor analyst to resolve analytical and design issues.

November 1998 - April 2000 Gamma Computer, Inc.; Woodland Hills,

California. Position: Consultant. Location: Nashville, TN. Created

customer-required ABAP enhancements. Completed functional/technical

specification documents for various SAP modules through collection

business requirements through user interviews and team meetings.

Resolved design issues with user and analyst recommendations. Completed

testing procedure for new code procedures. Worked with modules:

Manufacturing Management; Production Planning; Project System. Clients:

Bridgestone-Firestone; Newport News Shipyard.

April 1996 - November 1998 Metro Information Services, Inc.;

Richmond, Virginia. Position: Consultant. Location: State Corporation

Commission; Developed large scale MS Access database application for

monitoring business registrations by the SCC. Completed data analysis

and data modeling through user interviews. Generated design

specifications (with user approval). Generated testing, training, and

system manuals. Completed interface programming, data conversion

procedure, acceptance testing, and user training.

CERTIFICATIONS

EPIC Security Analyst Certification, June 2011.

ABAP Programmer Certification: Lambton College; Sarnia, Ontario, Canada;

September 1998 - October 1998.

EDUCATION

Epic Headquarters: Voyager Hall; 1979 Milky Way; Verona, WI; December 2009

- February 2010 (not continuous). INP100: EpicCare Inpatient Fundamentals;

CLN200: Intro to Clinical Administration; CLN300: Staff-Related

Administration; CHR200: Chronicles Install Utilities; CHR210: Hyperspace

Configuration.

Master of Science in Finance: Virginia Commonwealth University; Richmond,

Virginia; December 1992.

- Additional courses in Accountancy outside degree create a total of

18.0 accounting credits.

Engineer-In-Training Certification; Virginia Commonwealth. 1988.

Bachelor of Science in Chemical Engineering: University of Minnesota

(Institute of Technology); Minneapolis, Minnesota; 1986.

Contact this candidate