Sql Server Data

CHRISTOPHER T DYNE

**** ********** ****, ***** *******, Oh 44130 H: 440-***-**** C: 440-***-**** *****.****@*****.***

Summary

Senior Software Engineer with experience in Full Life Cycle development of various

Data Base, Client, and Data Warehouse applications.

Highlights

SQL Server 2005,2008,2012,2016 Strong decision maker

Data warehousing and analytics Complex problem solver

SSIS, SSAS, SSRS Efficient data management

DB2 Microsoft Development Tool Set

SQL / T SQL SQL expert

Performance and scalability Optimization Erwin

Data Modeling IBM Mainframe Tool Set

Azure SQL Server Azure Data Warehouse Design Netezza Data Warehouse Design Oracle 12c

Toad for Oracle and DB2 Toad Data Modeler

Pl/SQL

Experience

Data Base Designer – Modeler / Oracle DBA Consultant September 2017 to Current

PNC Bank – Cleveland, Ohio

All Data Modeling, Data Requirements and Oracle Data Base Functions related to PNC Customer Service System. Created and maintained all Logical, Physical, and Entity models for PNC Customer Service System in IMS and DB2 using Toad Data Modeler. Created and maintained PNC’s Data Dictionary, Meta Data, and Reference Data based on User requirements and relational models.

Data Base Designer – Modeler / Data Warehouse Architect Consultant Jan 2017 to August 2017

Westfield Insurance – Westfield Center, Ohio

All Data Modeling, Data Requirements and Data Base Functions related to Data Base and Data Warehouse Architecture Design and Implementation. Lead integration of multiple transaction Data Stores into Netezza Enterprise Data Warehouse. Integrated Policy Administration Package into Transactional and Data Warehouse Data Stores. Created and maintained all Logical, Physical, Entity, and Dimensional Data Base models for all of Westfield’s Corporate OLTP Data Bases and OLAP Data Bases for SQL Server and DB2 using Erwin. Created and maintained Westfield’s Data Dictionary, Meta Data, and Reference Data based on User requirements and relational models.

SQL Server DBA/Data Warehouse Architect Mar 2016 to Dec 2016

Software Answers - Brecksville, Ohio

All SQL Server DBA functions, including performance and tuning, backup and recovery, and

maintenance functions. Designed and Developed a SQL Server 2016 Data Warehouse in the cloud with Azure using AZCOPY, Azure Data Factory and SSIS. Designed and developed multiple Cubes and Data Marts using Analysis Services for business users with SSDT and Visual Studio 2014.

Data Warehouse Developer Contractor Oct 2015 to Mar 2016

Ohio Caterpillar - Brecksville, Ohio

Worked on converting and Migrating IBM Cognos Data Warehouse Model into SQL Server

2012, utilizing SSIS, SSAS, and SSRS data tools. Designed and developed Multi-Dimensional Cubes using Star Schema, created a New Data Warehouse in SQL Server 2012 and created SSIS packages and Analysis Services Solution for Business Users. Designed and developed multiple SSRS reports.

SQL Server DBA/Business Intelligence DBA Contractor Dec 2014 to Oct 2015

Eaton Corp - Beachwood, Ohio

All SQL Server DBA Functions including Backups, Installations, Migrations, and any SQL Server

DBA Functions as needed by the client. Designed and developed Microsoft Business

Intelligence Infrastructure for full SQL Server 2012 Stack, including SSIS packages design and

installation, SSRS creation and installation, Cube design and SSAS creation across a Global

Network.

Data Base Engineer/Data Warehouse Developer Oct 2001 to Dec 2014

Progressive Insurance - Mayfield, Ohio

Drove continual improvement to system architecture by refactoring old legacy Cobol and

DB2 Code and ported the code to C#,.Net and SQL Server. Drafted detailed design objectives

and developed architectural and system design documents. Developed desktop applications

using Microsoft Tool set and Microsoft BI Tools. Organized and lead meetings with

stakeholders, contractor product teams and customers. Conducted technical Code reviews

and suggested improvements .Conducted full-life cycle software development in multiple

software environments such as DB2 and SQL Server. Performed functional, non-functional,

regression and performance tests to measure legacy system, updated systems, and new

systems for optimal performance metrics. Migrated legacy DTS applications to SSIS. Designed and modeled Data Bases in both SQL Server and DB2 for operational and Warehouse systems. SQL and Data Base subject matter expert for Claims IT. Created and maintained all Logical, Physical, Entity, and Dimensional Data Base models for all of Progressive Claims IT OLTP Data Bases and OLAP Data Bases, including SQL Server, DB2, and IDMS using Erwin. Created and maintained Claims IT Data Dictionary, Meta Data, and Reference Data based on User requirements and relational models.

Senior Consultant Dec 1996 to Oct 2001

Various Consulting Companies - Cleveland, Ohio

Worked for various companies to develop internal Web Sites, external Web sites, internal

distributed systems, and legacy systems. Developed production and beta websites using HTML,

Java Script, C#, ASP.Net, and ADO.Net. Converted a legacy health provider system from Cobol, CICS, and DB2, to a distributed system using .Net and C#. Implemented a Decision Support System

in Business Objects with an Oracle 10 backend. Created a Web Based Billing System for a Major

Health Insurer in C# and the .Net Tool Set. Performed SQL Server DBA duties for a major

health provider.

Senior Programmer/Analyst Dec 1994 to Dec 1996

KeyCorp - Cleveland, Ohio

Supported the Treasury and Brokerage Departments for both Mainframe and Client based

systems. Tools used for Mainframe System support SQL, DB2, Cobol, CICS, VSAM, JCL and

Librarian. Tools and Languages for Client Support Visual Basic 6, Windows NT, .Net, SQL

Server, T-SQL, Access and Visual Source Safe.

Programmer/Analyst Nov 1989 to Dec 1994

Blue Cross/Blue Shield - Cleveland, Oh

Supported the Medical Insurance Company, both Mainframe and Client based systems. Tools

used for Mainframe System support SQL, DB2, Cobol, CICS, VSAM, and JCL. Tools

and Languages for Client Support Visual Basic 6, Windows NT, .Net, SQL Server, T-SQL and

Visual Source Safe.

Accomplishments

Overall Tech Lead on a SQL Server 2008 Migration effort that saved company $20 Million in

license fees. Lead IBM DB2 conversion that saved company $15 Million in license fees. Part of

team that Migrated 600 + SQL Server DTS packages and converted them to SSIS.

Education

Bachelor of Science, Computer Science

Cleveland State University - Cleveland, Ohio

MBA, Management

Baldwin Wallace College - Berea, Ohio

Delta Mu Delta - Business Honors

BBA, Accounting/Finance

Bowling Green State University - Bowling Green, Ohio

Contact this candidate