SUMMARY

• Over 17 years’ experience in Data Management, Data Administration and Business Intelligence in enterprise accounts including Confidential
• Extensive experience using ETL Tools Informatica PowerCenter and Microsoft SSIS
• Extensive experience with ETL (Extract, Transform and Load) and Database queries
• Experience with Designer, import/export, query and utilities in SSIS/SSRS
• Excellent understanding of complex logical to physical DB structures
• Extensive “Report Writing” experience using Tableau, COGNOS and CRYSTAL REPORTS
• Experience developing Documentation for all Database/Data Warehouse projects
• Very good knowledge in analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Experience performing Database Performance Tuning
• Experience with SQL server installation and Security Management levels
• Experience with CDM data analysis

TECHNICAL SKILLS

Databases: SQL 2008 R2/2012, Oracle 10g/11g, Teradata

BI/ETL Tools: Informatica 8.1, Business Objects, Cognos, SSIS/SSRS/SSAS

Data Modeling: Erwin, ERStudio

Reporting Tools: Tableau, SSRS, Crystal Reports, Cognos

Productions Apps: MS Visio, Microsoft Office (Word, Excel, PowerPoint), Visual studio, SharePoint, Team Foundation Services

Languages: PL/SQL, C#, Java, HTML, Oracle Toad

Methodologies: Agile Scrum

Platforms: Window, IBM OS/400 iSeries, AIX, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, TN

Sr. Database DBA

Responsibilities:

• Support over 3000+ Confidential clinical data movement, data analysis, data fix, Solutions.
• Worked with development team on Enterprises solutions, design, In/out bound queues analysis, Performance review an all Applications servers and databases servers troubleshooting.
• Developed SSIS packages to load data from Clinical data (Snappy) to SQL Server 2008 database.
• Support Data movement using eGate interface, data absent, month end close claims support.
• To support BILLPROD/Clinical client data movement and development team support.
• Worked FSO team on Snappy Backups/restoring databases new install/release versions.
• To Monitoring HPOV database system details within the database, including stored procedures and execution time, plan cache for databases.
• Worked and extracted data into ROPS Dashboard status and SSRS reporting analysis.
• Develops, implements, and maintains change control and testing processes for modifications to databases in DEV/QA/Production systems.

Environment: Oracle, SQL server, BI (SSIS/SSRS), SharePoint 2010, ServiceNow, Visual studio 2013, CA Erwin, HP Open view tool, EGATE interface, ETL, Tableau.

Confidential, Kingsport, TN

Sr. Epic Clarity Cogito Data Warehouse consultant

Responsibilities:

• Epic Clarity Databases production problem analysis, client support and on call support.
• Backups/restoring databases on Dev/STG environments.
• Develop T - SQL stored procedures, views, functions and triggers for Development SSIS/SSRS.
• Epic Cogito Data warehouse design, ETL develops in staging and production systems.
• Epic Clarity report in hospital and clinical data analysts and designs/testing.
• Developed ETL from Clarity databases to Epic CDW databases and design CDW databases using star schema (facts and Dimensions models).
• Worked databases and T-SQL performance tuning and query analysis.
• Worked databases updates and uses requests, data analysis.

Environment: SQL 2008/12, Epic Hyperspace 2014, Epic Clarity Console, Cogito Clarity, PL/SQL, T/SQL, Crystal Reports, C#, SharePoint 2010, Toad, ER/Studio, SharePoint, Service Connect, Epic CDW.

Confidential, Franklin, TN

Sr. Database Architect/Database Developer

• Migration, replication, reporting and on call support for clients product databases.
• Databases design Erwin model all release products databases.
• Developed SSIS packages to load data from IBM iSeries database to Oracle PL/SQL, Toad, views, procedures, triggers, and functions in Oracle /SQL Server 2008 database.
• Developed reports using tools SSRS, Crystal and Cognos and deploying the client locations.
• Worked in an Agile and SCRUM Software and changing requirements.
• Clinical, Patients, order, EHR, DM, HIM, HL7 databases support.
• Backups/restoring databases new install/release versions.
• Database administration, maintenance, and schema design for DB2 and MS SQL Server
• Create all objects using Aldon change Management.
• To Monitoring database system details within the database, including stored procedures and execution time, plan cache for databases.
• Develops, implements, and maintains change control and testing processes for modifications to databases in DEV/QA/Production systems.

Environment: IBM iSeries, AS400, Java, WebSphere 7.5, SOAP, JSM, Oracle 11g/12c, HTML 5, SQL Server 2008/2012, BI (SSIS/SSAS/SSRS), Cognos, HL7, Jira, SharePoint 2010, IBM I navigator, Salesforce, Aldon Life Cycle

Confidential, Nashville, TN

Sr. Application Engineer / ETL Developer

• Provided support for Clinical Data (CDM) and DR Databases.
• ETL (Extract Transform and Load) developer using SSIS packages
• Design and build SSIS packages for Meditech 6.0 applications and FTp’ed data files to EDW.
• Migrated databases, SSIS packages and SSRS report code in QA and Live systems.
• Migrate SharePoint 2008 to 2010 using .Net, C# code to design custom web pages, AD login access
• Build reporting design in SSRS reports in CDM applications.
• Meditech NPR data extract into EDW system and design SSRS reporting.
• Backups/restoring Meditech DR databases (Focus/NPR).
• Co-ordinate to BMC change, code builds, Stonebranch and fixing incident tickets.
• Using C# scripts in SSIS packages FTP, file process to data validate.
• Creating Data sets for NPR/DR databases using SSRS report develop and deploy.
• Design, implement and maintain ETL components supporting CDM (Clinical Data Management) and EHR (ADM/ABS/OM/HIM/SCH) data.

Environment: Meditech 6.0, SQL server 2008, BI (SSIS/SSRS), Oracle 10g, PL/SQL, TFS 2010, Remedy, SharePoint 2010, Visual Studio 2008, XML, C#, .Net, HTML, XML, Tableau, Teradata, DB2 and BMC.

Confidential,Nashville, TN

Sr. Database Developer/Reports Writer

• Databases - Backup, design, implementation, stored procedures and triggers.
• Create PL/SQL using stored procedures, functions, Views for Crystal XI.
• Load data from FoxPro using SISS/SQL *loader to SQL/Oracle databases.
• Responsible for all database architecture and program design, report developers, and interfaces with clients’ CRM software.
• Migrate Crystal reports XII to SSRS reporting and design new reports in SSRS and deploying UAT/PROD servers.
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining SSIS packages.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
• Wrote installation and procedural manuals for support staff.

Environment: Oracle 10g, SQL server 2005, Crystal Report XI, SSIS, SSRS, MS studio 2010, TFS 2010, Unix, PL/SQL, Toad, Visio, FoxPro, C#, SharePoint.

Confidential,Franklin, TN

Sr. Database Administrator

• Provided support for DB2/IMS databases production environments
• Provided Daily backups, data restore and recovery, user accounts, privileges for Database support, troubleshooting, planning and migration.
• Resource planning and coordination for application migrations with project managers, application and web app teams
• Monitoring of database size and disk space in Production, Staging & Development environments.
• Conducted Performance Tuning using DB2/IMS and BMC Performance Monitor.
• Performed ETL (Extract Transform and Load) functions using Informatica v6.0
• Created Custom ETL solutions using T-SQL stored procedures schedules as jobs Responsible.
• Configured Database mail, linked servers in SQL server 2005/2008.
• Conducted training sessions for Customers on Business Objects Full client version

Environment: Windows NT/XP, z/OS, DB2, COBOL, JCL,VSAM,CICS, IMS, Essbase, SQL server 2005, Oracle 10g, Informatica 6, ETL, UNIX, .net, C#, SharePoint, TFS, SQL Profiler, Unix, BMC, Erwin, Windows, DBArtisan, BMC Remedy.

Confidential

Mainframe DB2 DBA / ETL support

• On Call support for the production environment.
• Creation of new database environment
• Provided ETL functions using Informatica
• Supported Data Architect - end-to-end vision, and to see how a logical design will translate into one or more physical Databases, and how the Data will flow through the successive Stages
• Providing access privileges to the database users.
• Backup & Restoration, databases design of the databases for DB2 on Mainframe.
• Performed the Disaster Recovery process
• Performed Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for DB2/Oracle databases.
• Created/configured MQ Objects, Queue Managers, Remote Queues, Local Queues, Queue Aliases Designed distributed queuing client server architectures and configured MQ
• Created and maintaining Databases, Stored procedure, cluster indexes
• Created and maintaining data warehouse
• Troubleshot and Optimized Database Performance.
• Develop plans and manage and execute complex technical efforts.

Environment: MVS, DB2, COBOL II, IMS DC/DB, CICS, Windows, MQSeries, MQI, PL/1, Enterprises Manager, Query Analyzer, Informatica, and Data Warehouse, IBM utilities, JCL, VSAM

Confidential

Mainframe DB2 DBA / Programmer

• On Call support for the production environment.
• Creation of new database environment
• Backup & Restoration, databases design of the databases for DB2 on Mainframe.

Environment: MVS, DB2, COBOL II, IMS DC/DB, CICS, Windows, MQSeries, PL/1, Query Analyzer, IBM utilities, JCL, VSAM