SUMMARY:

• Senior DBA Consultant & Project Manager with Solid background in Application & Database Architectures and Systems & Solutions Architectures
• 15+ years of Epic EMR/HCI practice as a consultant and Cache DBA.
• 20+ years of relational database consulting practice including Oracle, SQL Server, Sybase & Informix
• Certified as an Epic Cache DBA and trained in Data Courier and security
• Extensive use of Epic Bridges, Chronicles, Data Courier, DBA Utilities, and Clarity
• Experience with all aspects of Cache Management including installation of Cache and Epic, backups, environment copying, upgrades, Cache Server Pages, MyEpic, and Epic Dashboard, etc.
• Cache upgrades and code installs (version 4, 5, 2007 thru 2015)
• Perform Epic upgrades (versions 4, Spring05, Summer05, Spring06, Spring07, and Spring08, 2009, 2010, 2011, 2012, 2014, 2015)
• Implemented Cache/Epic Security functions ( SECURITY) - Cache/Unix level security, Epic/Cache Security Roles, Classes, & Points.
• Strong working knowledge of both logical and physical data modeling & database design including normalization, indexing strategies, and stored procedures.
• Extensive experience with web and database technologies and solutions. Experience with a wide a range of ETL/DTS tools used to expose data to web services and APIs. Project Management, Knowledge of web based application servers, Technical Support, Technical Writing.

TECHNICAL SKILLS:

Database: Inter-systems Cache (ver. 4 thru 2015), MS SQL (4.2 thru 2012), Oracle (7, 8i, 9i, 10), Sybase (4.9, 10, 11, 12), Ingres, Informix (7, 10, 11), DB2, MySQL, Unify

OS: AIX (6.1, 6.3, 7.1), Solaris, HP-UX, Red Hat Linux, VMware, NT, Windows, HP/DEC VAX/VMS

Languages: Visual Basic, PERL, Korn/Bourn /C Shell, Java, HTML, XML, CGI, UML, C, C++, ASP.NET, Visual Studio.NET, PL/SQL, T-SQL, SQL, ODBC, VAX Basic, Pascal, COBOL, FORTRAN

Tools: Crystal Reports, Business Objects, Epic Workbench, Epic Clarity, Hyperspace, MyEpic, Erwin, Rational Rose, ER Studio, Oracle Designer 2000, DTS/SSIS, SQL Navigator, Discover, Essbase, Informatica, ETL Tools, BMC Web Logic, PowerBuilder, DBArtisan, Enterprise Manager, Toad, Oracle Warehouse Developer, SharePlex, MS Project, Front Page, Cold Fusion, Dream Weaver, Legato Networker, VERITAS Netbackup

Applications: PeopleSoft, ADP/HR, Lawson, Medical/Clinical Systems, Claims Processing, Banking / Investment Systems, Call Center/Telecom Management, Netscape Server, Web Logic Server

Hardware: IBM R6000, HP 9000, SUN Cluster, DEC VAX Clusters, DEC Alpha, PDP 11, Intel 310 family, Motorola Systems, PC 386/486/Pentium, Macintosh

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Responsibilities:

• Provide production support for the Epic Cache DBA team on Epic 2014 implementation
• Provide support, testing, and planning for Epic 2015 upgrade
• Provide training and support for newly hired DBA’s preparing for Epic classes/testing

Confidential,Boston,MA

Senior DBA Consultant & Project Manager

Responsibilities:

• Provided Go-Live support Epic 2014 implementation
• Provided change management control and support
• Provided Clarity and Cogito (data warehouse) support and troubleshooting during Go-Live
• Provided support for Data Courier including tracking usage and troubleshooting problems

Provide secondary support to the Epic Cache DBA team

Confidential,Allentown, PA

Senior DBA Consultant & Project Manager

Responsibilities:

• Provided daily support for pre and post Go-Live for Epic 2014 implementation
• Responsible for daily Change Management Control and approval for 2nd shift Go-Live
• Provided support for Data Courier including tracking usage and troubleshooting problems
• Provide direct support to the Epic Cache DBA team including documentation development

Confidential,San Francisco, CA

Senior DBA Consultant & Project Manager

Responsibilities:

• Project Manager for 14 software projects being implemented at the new Mission Bay Confidential .
• Project Manager/Sr. Consultant supporting implementation and build on Epic 2012 upgrade.
• On-site support and training to new Epic Infrastructure Manager of IT-Clinical Services
• Confidential responsible for developing and implementing a new and consistent process for Nova Notes assignment and review across server and build teams.
• Developed initial DR testing plans for an Epic off-site failover.

Confidential,Baltimore,MD

Senior DBA Consultant & Project Manager

Responsibilities:

• Project & Infrastructure manager supporting implementation and build on Epic 2012 utilizing Redhat Linux 6.3 on VMware 5.1
• Provide on-site support and training to Mercy staff across Cache/Epic tools and environments including Chronicles, Bridges, Data Courier, Clarity, Red Alert, refresh configurations, kernel parameters.
• Developed security recommendations and implementation following industry best practices including root level, file and directory access, permissions, and ownership.

Confidential,Portland, ME

Senior DBA Consultant & Project Manager

Responsibilities:

• Epic Cache DBA Consultant supporting Epic 2010 Go-Live
• Resolved outstanding action items from Epic Go-live audit across all environments
• Provided Red Alert support/configuration on non-production environments.

Confidential,Reading, PA

Responsibilities:

• Sr. Consultant supporting Data Courier and Epic Cache 2010/2011 pre Go-Live
• Supported all Data Courier migration in multiple environments
• Provided on-going production and development support for Cache and Data Courier

Confidential

Project Manager

Responsibilities:

• Project Manager responsible for Data Courier implementation during Epic 2008/2010 upgrade and production Go-Live
• Established and supported all pre and post production Data Courier migration in multiple environments with extensive coordination with the build teams.
• Developed Service Level Agreements with all stake holders who were utilizing Data Courier.
• Resolved a wide range of DC related problems using Bridges, Chronicles, Security, and DB tools.
• Developed and conducted training program for staff.
• Part of the Change Control Team responsible for ensuring adherence to established guidelines and requirements.

Confidential,Houston

Solutions Architect

Responsibilities:

• Solutions Architect - provided ETL development and design support for migrating data from Epic Cache database and Clarity (Oracle) database and other SQL databases to a single SQL Server data repository for use as a registry database.
• Documented ETL process and data association and history for audit purposes.

Confidential

Solutions Architect/Project Manager

Responsibilities:

• Solutions Architect/Project Manager supporting the Summer 2009 production upgrade
• Provided on-going planning & support for a broad range of Cache DBA functions and tasks including ETL/DTS data migration from Cache to Oracle/Clarity database, Epic and VPSX print services.
• Providing Best Practices consulting services for a variety of Epic related systems & projects.
• Act as DBA liaison and consulting resource for Epic Build group, Epic security, Oracle Data Warehouse project.

Confidential,San Diego

Data Warehousing Architect

Responsibilities:

• Data Warehousing Architect - Responsible for production SQL Server data migration from Clarity (Oracle) and Epic/Cache databases
• Provided support for Business Objects and Crystal Reports development.
• Provide mentoring and training to current and new staff.

Confidential,Los Angeles

Sr. Consultant

Responsibilities:

• Sr. Consultant- Provided support for a broad range of Cache DBA functions and tasks.
• Go-Live support for EpicRx, Epic ASAP, and Inpatient.
• Responsibilities include implementation, utilizing Data Courier for a wide variety of code migrations. Also responsible for loading SNOMED, IMO, and related ICD-9 and HL-7 coding data files and configuration setup.
• Confidential responsible for configuring and supporting Epic Print Services and VPSX. Providing on-call support for all production and non-production Cache/Epic based systems and related applications.
• Provided support to the SQL Server and Oracle team for Epic/Cache data migration.

Confidential

Senior technical team member

Responsibilities:

• Worked as a senior technical team member on a three and one half billion dollar national medical information system network for a non-profit healthcare provider that spans the continental United States and Hawaii.
• My role required complementing the technical skill sets of my colleagues as necessary in order to develop first and second generation deployment and implementation processes and procedures for a newly designed enterprise-wide healthcare software application.
• Responsibilities include being the Confidential for database implementations (building, loading, backups, restores, and performance enhancements) for Cache, Oracle, and SQL Server environments.
• Provided development and support for various applications including Document Imaging, Clarity, Workbench, MyEpic, Crystal Reports & Business Objects.
• Confidential responsible for engineering, validating, and implementing all Epic/Cache related code that is submitted from all software vendors and internal developers.

Sr. DBA/Data Architect

Confidential

• Hired as a key member of a project team to migrate the existing Criminal Justice System database from a mainframe ADABase environment to SQL Server environment.
• Key technical expert in the design and implementation of this Criminal Justice System.
• Performed extensive logical and physical database modeling and performance tuning.
• Established a multi-tiered security environment using Active Directory and database security.