SUMMARY

• 22 years MS SQL Server versions 4.9 to 2012
• Architect and Data modeler expert in Conceptual, Logical and Physical modeling.
• Expert in VLDB and geospatially dispersed databases
• Designed and enacted Best Practices methodology for Production Backup, Maintenance, Recovery, and Disaster Recovery.
• Able to function as team lead, team player or solo.
• Self-starter who can make order in the midst of chaos. Disasters a specialty.
• Expert in TSQL, Stored Procedures, Triggers, Functions, Views, and ETL.

Professional Objectives

• I am looking for consulting opportunities with a company with extreme database challenges. I specialize in helping you solve those problems.

Employment History:

SQL Developer

Confidential

• Clients including: PDR Physicians' Desk Reference Montvale NJ and M T Bank Corp 17th largest bank in the US at 170 Billion, Buffalo and others.
• Trouble shooting and performance tuning job in MS SQL Server 2005, 2008r2, and 2012. Working with SQL, TSQL stored Procedures and infrastructure.

Confidential

• Requirements gathering in the Confidential with translation into Conceptual, Logical and Physical Data models.
• Executed the Architecture in Boyce Codd 3rd Normal Form.
• Development DBA and TSQL, SSIS, SSRS Developer.
• Database design, Architecture and development in MS SQL Server 2012. Requirements gathering, functional Specifications and Analyzing business processes and performing in-depth work analysis. Translation of work analyses into logical and physical data models.

Confidential

• Due to unprecedented growth Broadridge was having difficulty keeping up with the volume of processing to support their customer's needs. Database servers were running at 100 CPU utilization with periodic crashes. Processing smaller amounts of data alleviated the crashing problem but exacerbated the problems in meeting client deadlines. Put solution in place to solve both problems.
• Worked with Technical Team Leads and clients to define scope of problem and enact solution.
• Corrected problems in database design, adjusted indexes, optimized worst performing SQL Code and helped developers in writing cleaner faster code. Solved problem without expensive new equipment or an extensive rewrite of the frontend. Despite drastic increase in new volume system was able to process client needs well within the time allowed. Some SSIS with Visual Studio 2010

Technologies: SQL, SQL Server 2008, SQL stored procedures, and TSQL, Visual Studio 2010, SSIS and SSRS.

Confidential

• Project: PASSHE Pa. State System of Higher Education , PA Dept of Education, November 2010 April 2011. Designed and created Conceptual, Logical and Physical Data Model in SQL Server 2008r2 Enterprise. TSQL Development, DDL, and Stored Procedures using User defined Table Types. Created SSIS packages.
• Project: Analytical Graphics Inc. April 2010 to November 2010. Project for the Space Data Agency. Translation of logical design to physical model in SQL Server 2008r2. TSQL Development, DDL, Stored Procedures, and SQL Tuning. High availability system running Peer to Peer Replication in three data centers in the UK and US.
• Boulder Design Group. Upgrade SQL Server 2000 to SQL Server 2008. Modification and correction of ETL system in SQL Server 2008 SSIS for Frontier Telephone, Rochester, New York.
• Project: Kastle Systems International, January 2010 to April 2010. Performance tuning of legacy SQL code with version migration. Code assessment and correction to migrate first to SQL Server 2005 and then SQL Server 2008. Conversion of Non-ANSI SQL to ANSI SQL.

Technologies: SQL, SQL Server 2000, 2005, 2008, SSIS, SQL stored procedures, user defined functions, cursors and query batches

Confidential

• Senior Database Advisor: Performance Tuning of VLDB HL7 V2.x and V3.0 healthcare EMR electronic medical records multi-terabyte EMR database for hospitals, integrated delivery networks IDNs , health systems and health information exchanges HIEs .
• Senior Database Administrator DBA SQL Server 2005 migration to 2008 with some Performance tuning of Oracle 11g. Maintenance of data dictionaries, data models, performance tuning. Coordinates database changes and tests. Provided PL/SQL support to the Canadian Healthcare system project. Database Modeling, Capacity planning and technical design documentation of a MMIS Medicaid Management Information System interface for the District of Columbia. Worked with Architecture team to create and execute documentation.

Technologies: SQL, SQL Server 2005, 2008, SSIS, SQL stored procedures, user defined functions, cursors and query batches

Confidential

• Senior Database Advisor: Data Modeler on projects to integrate new client healthcare claims systems. Developed stored procedures, triggers, functions and views using Microsoft Technologies. Initiated Disaster Recovery plan and a Backup schedule with offsite storage.

• SQL Server 2005, Production DBA and Performance Tuner.

Technologies: SQL, SQL Server 2000, 2005, 2008, SSIS, SQL stored procedures, user defined functions, and TSQL

Confidential

• Contractual SLA was that screens populate in 1 second and when they brought me in the screens were populating in 45 seconds. Through Code Optimization and implementation of Indexed Views I was able to deliver 300 millisecond response times.

Technologies: SQL, SQL Server 2008, TSQL. Performance Tuning

Consulting multiple positions

Confidential

• Clients including: CIGNA, NIH National Institute of Health , Sylvan Learning Center, John Kerry Presidential campaign, Deutsche Bank, AutoZone, Johnson Controls, US Department of State, Fannie Mae, DOJ, World Bank, Freddie Mac, Sallie Mae, US Mint and others.

• VLDB administration in SQL Server 7.0, 2000, 2005, and 2008.
• Architecture, data modeling, ETL, Administration and a focus on Performance tuning.
• DR/BCP, Capacity Planning, Backup Planning, Forecasting, Performance Tuning, Change Management, Release Process, and Version Control.

• Consultant on a wide range of MS SQL Server, Oracle and Access projects
• MS SQL Server DBA Optimization of stored procedures in a new system.
• Several Data Conversion projects from Mainframe, Wang and others to SQL Server and to Oracle.
• Install SQL Server and create database, tables, queries, views, BCP scripts and benchmark load times.
• ETL Extraction, Transformation, and Loading, data migration and data cleansing.
• Data Modeler and Team lead on a new budgeting system for AOL.
• Data analyst on an Oracle 7.3, and Visual Basic 5.0 project. Involved data modeling and use of ER-WIN case tool.
• Design and create new database, create tables, view, indexes, etc in MS SQL Server. Move data from mainframe and build Access reports.
• Data modeling and use of ER-WIN case tool.
• Programmer on a web based reporting system in HTML, CGI, and Access
• Server D.B.A. and Visual Basic Programmer. Primary responsibility for production servers both maintenance and development including parts in C/C , Awk, SGML, and Visual Basic 3.0. Use of MDI and APPC gateways to DB2 on Mainframe. Conversion of Visual Basic 3.0 code to Visual Basic 4.0.
• Programmer/Analyst on MS Access and SYBASE 10 strategic plans application. Use of ODBC links to SYBASE System 10. Requirements gathering, design, implementation, and Report writing. Extensive use of SQL and Access coding.
• Oracle Development D.B.A. and Lead technical programmer on a system test of two Oracle 7 Client Server systems on different OSs. Creation of Oracle databases.
• Lead technical programmer on a call center automation project.
• Lead technical programmer on a call center automation project. Use of MS Access, Access ADT, and Windows API calls. Converted macros to code and made improvement to a system under development.
• Executive Information System for the Secretary of Housing and Urban Development. System integrated Multi-Media with Data Warehousing and Geo-Coding. Audio and Visual enhancement to System front end GUIs. Visual Basic Pro 3.0 using DB-Lib MS SQL Server 6.0. Data Warehouse drew on 7 different Mainframe systems. Load scripts and data cleansing.
• Visual Basic technical lead on client server application using Visual Basic 3 Pro, with a variety of VBX Controls, to build front ends for MS Access and SQL Server back end data servers with use of PVCS and Crystal Reports.
• Importing from DB2, into Sybase, de-normalizing in Access to create flat files suitable for SAS statistical regressions and reports.
• Programmer/application developer on a Telephone Co. billing system working prototype in MS Access 2.0. Very large scale use of Access in virtually every facet of data manipulation. An application with over 100 queries which runs for more than twenty hours. Design and implementation of test and test plan. Migration to client server using SQL Windows and Oracle.

Technologies: SQL, SQL Server 2000, 2005, DTS, ETL, SQL stored procedures, user defined functions, cursors and TSQL

Confidential

• 14 years working my way up to Vice President of Sales and Marketing with oversight of IT.
• Supervision of multiple currency trading system, system management and network administration. Responsible for requirements and design of MIS and regulatory reporting systems. Responsible for system and network administration. This included programming and design in D-Base with migration to MS Access.