SUMMARY

• I am a Senior Database Engineer/Architect/BI Developer with over 20 years professional experience in architecture, design and development of RDBMS’s including SQL Server 6.5 thru 2016.
• Currently consulting as a Data Migration Consultant for a large hospital migrating to a large EHR application.
• My overall experience encompasses several IT arenas including database design, development, Internet/Intranet application development, BI application development, using SSIS, SSRS, VB.NET and reporting with Dynamics AX2009.

TECHNICAL SKILLS

• SQL Server 2005 thru 2016 logical/physical modeling ERStudio/DBArtisan.
• Stored Procedures, triggers, DTS/SSIS, OLTP, OLAP, Data Warehousing.
• Extensive T - SQL, data conversions, migrations, upgrading 2000/2005/2008 R2.
• Clustering, SQL Server Farms, backup, recovery, replication, jobs, optimization.
• Oracle 7.x - Oracle 11g RAC
• DB2 5
• Oracle 9i/10g/11gRAC production support, PL/SQL,Grid Control 10.2, RMAN, ASM
• Oracle 8.1.6 logical & physical data modeling with ERStudio and DBArtisan
• Designed tables, views, triggers, stored procedures, PL/SQL.
• Oracle 7.x/8x ETL with SQL Server 7/2000, exporting, importing, transformations.
• Microsoft ASP.NET & VB.NET/Visual Studio 6.0/Visual Basic 6.0 & IIS 4/5
• NET/VB.NET desktop and distributed apps, ASP.NET
• ASP, XML, JavaScript, VBScript, HTML development Internet/Intranet applications.
• Microsoft Dynamics AX 2009 AOT,AP, AR, GL and COA
• Windows NT 4.0/2000-2012 R2 Architect/Admin. ed Hat 4/5,SunOS 5.10
• Extensive designing, installation, configuration and administration of network infrastructure.
• ISDN, T1, Switches, Routers, TCP/IP, PPTP, VPN, RAS, DNS, DHCP, NWLink, Telnet, FTP.
• Domains, Forests, Trees, User and groups, NTFS security, permissions and rights.
• MS Clustering (SCSI/Fiber) fail-over IP, disaster recovery, logon scripts, batch files.
• T-SQL, Visual Studio\TFS 2012/2014, PL\SQL, ASP, LogiXML 12.2.116, XML, HTML, JavaScript, VBScript, VB.NET, VB 5/6, ERwin, ERStudio, DBArtisan, Cognos (Transformer, Decision Stream, Improptu), Business Objects/Crystal Reports XI, Sagent Design Studio 4.5i/Automation (Opalis)

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Data Migration

Responsibilities:

• Coordinate and assist with Data Collection Worksheets for migration to Cerner Millenium.
• Troubleshooting and assisting with merging duplicate patient data.
• Working with Connectivity and Interface Integration teams from current to future state.
• Ensure proper data, datatypes and logic are migrated from current to future state systems.

Confidentia, Atlanta, GA

Sr. DBA Developer

Responsibilities:

• Installation, configuration, migrations and upgrades for SQL Server 2008R 2/2014/2016.
• Configure Always On Availability Groups, Failover Clustering, Kerberos SSPI.
• Install, configure and maintain Transactional Replication
• SentryOne and Idera SQL configuration, backups, restores and monitoring performance.
• Optimize SQL queries, stored procedures, index analysis, using Microsoft Best Practices.

Confidential, Charlotte, NC

Sr. DBA Developer

Responsibilities:

• Installation, configuration, migrations and upgrades for SQL Server 2008R 2/2014/2016.
• Configure Always On Availability Groups, Failover Clustering, Kerberos SSPI.
• Install, configure and maintain Transactional Replication
• SentryOne and NetBackup configuration, backups, restores and monitoring performance.

Confidential, Atlanta, GA

Sr. DBA Developer

Responsibilities:

• Senior Database Consultant designing Health Analytics web apps with LogiXML/SQL Server.
• Developed Web applications with LogiXML, session variables, and CSS for formatting.
• SCRUM methodology used to complete tasks in Sprint and fulfill Product Backlog.
• Developed complex stored procedures, using CTE’s, Windows functions, etc,
• Optimize SQL queries, stored procedures, index analysis, using Microsoft Best Practices.

Confidential, Monterey, CA

Sr. DBA Developer

Platform & Tools: Windows 2012 R2, SQL Server 2012, SSIS, SSRS, AllScripts SCM 14.3-15.3Windows Failover Clustering Instance (WFCI), AlwaysOn(AvailabilityGroups/HADR)

Responsibilities:

• Senior Database Consultant upgrading AllScripts 14.3 - 15.3 PROD, DEV, TEST,TRAIN.
• Enhancing AlwaysOn upgrade process restoring databases, Sync/Asynch transaction logs.
• Analyzing and tuning SQL Server WFCI/HADR configuration using Microsoft Best Practices.
• Troubleshooting SCM.SQL Server jobs and store procedures during upgrade.
• Monitoring and supporting AlwaysOn Health Events/Dashboard, Sync/Asynch configuration.

Confidential, Los Angeles, CA

Sr. DBA Developer

Platform & Tools: Windows 2012 R2, SQL Server 2005/2008R2/2012/2016, SSIS, SSRS

Responsibilities:

• Creating complex SSIS packages to handle Cruise Travel/Logistics
• Upgraded SQL Server 2005/2008 to SQL Server 2014 with 350 SSIS packages in WFC.
• Created complex SSIS reports for Cruise Sales Statistics/Call Center/Travel Logistics Apps.
• Created complex stored procedure for ETL from multiple data sources to SQL Server 2014.
• Analyzing and tuning SQL Server WFCI/HADR configuration using Microsoft Best Practices.
• Troubleshooting long running stored procedures and T-SQL queries using index analysis, WHERE clause and JOINS, use of CTE’s, and functions, Execution Plans, etc.

Confidential, Los Angeles, CA

Sr. BI Developer

Platform & Tools: Windows 2012, SQL Server 2012, SSIS, SSRS, Oracle 11gOracle Attunity Drivers

Responsibilities:

• Senior BI Developer for Productivity Billing Application for Confidential .
• Creating complex procedures to handle ETL from Oracle 11g to SQL Server 2012
• Creating complex SSRS reports with healthcare data and strict business logic.
• Creating Parent/Child SSIS packages with project parameters, using configuration tables.
• Advance T-SQL queries and stored procedures optimization inside business logic.