Sql Server Support

Dmitriy Dreytser

Southampton PA, ***** cell 215-***-**** *******.********@*****.***

Senior Developer/Group Technical Lead

To design, develop, implement and maintain the efficient data centric applications for complex business requirements.

30+ years in Information Technology and Data processing.

Strong skills in SQL Server and DB2, relational data management and ETL.

Extensive experience in system analysis, design, development and production support.

In depth knowledge and understanding of business processes and data in the Group Insurance Industry.

Expert in translating business requirements into technical solutions.

Technical Leader in account implementations, system support and maintenance

TECHNICAL SKILLS

Platforms: Windows, z/OS

Database: SQL Server, DB2 (z/OS and UDB)

Languages: SQL, T-SQL, SQL Server stored procedures, DB2/UDB stored procedures, COBOL, EASYTRIEVE Plus, CICS

ETL: SQL Server Integration Service (SSIS)

Tools: Job scheduling: CA Workload Automation (ESP), Tivoli Workload Scheduler (TWS), CA-7;

SQL server Performance management: Idera SQL diagnostic tool, Ignite 9 Performance tool

Mainframe: TSO, DB2 IBM Utilities, BMC, FileAID, XPediter; SPUFI, DB2 IBM utilities, BMC tools

Additional experience and knowledge: SSRS, VB.Net (console) program development, Sterling Mapper (B2B); deep understanding of Data Warehousing concepts, including star and snowflake schemas, dimension and fact modeling, SCD and overall ETL approaches and best practices

EXPERIENCE

CIGNA (Group Insurance), Philadelphia PA

Senior Consultant/Group Leader (12/2010 - present) via CGI Corporation

Production support and maintenance of various policy administration systems and file intake processes on different platforms:

-Problem resolution and management;

-Data analysis and adhoc reporting;

-SQL Server stored procedure tuning;

-File Intake process automation, optimizing file processing, business report enhancement;

-Application enhancement, analysis and implementation;

Technical environment: SQL Server, DB2, SSIS, z/OS, Windows, UNIX, TWS, ESP, CA-7, Sterling, VB.NET (console)

CIGNA (Group Insurance), Philadelphia PA

Application Development Senior Specialist (02/2001- 12/2010)

Design, development, implementation and support of ETL processes utilizing various tools and programming languages including:

-SQL Server stored procedures, SSIS, VB.NET (console) to support consumer domain databases and process flows;

-Development of the processes to support medical underwriting reporting and SSO data propagation, utilizing MS SQL Server;

-DB2/UDB stored procedures to support policy administration data warehouse;

Technical Team leader for various projects utilizing zOS, DB2, COBOL, CICS, VSAM and EASYTRIEVE Plus including:

-Policy administration, medical underwriting and eligibility/enrollment application development.

-Numerous enhancements and projects on Policy Administration systems;

-Support National and Medium range clients’ data inceptions;

-Adhoc business reporting as well as various other extracts.

Technical environment: SQL Server, DB2, T-SQL, SSIS, COBOL, VB.NET (console), EASYTRIEVE Plus, JCL, TSO/ISPF, IBM Utilities, DB2 IBM utilities, BMC tools, CICS, VSAM

CIGNA (Group Insurance), Philadelphia PA

Senior Programmer / Analyst – Consultant (03/1999 – 02/2001) via DPT Corporation

-Leading role in design and development of the file intake component for the Group Insurance eligibility and enrollment application;

-Support Group Insurance client implementation for Life, Accident and Disability products.

Technical environment: IBM 3090 MVS, TSO/ISPF, IBM Utilities, COBOL-COBOL II, DB2, JCL, SPUFI, DB2 IBM utilities, BMC tools, EASYTRIEVE Plus

CSX Corporation, Philadelphia PA

Programmer / Analyst – Consultant (08/1998 – 03/1999) via ARC Corporation

-Data analysis in support of data migration from CONRAIL payroll databases to CSX;

-Design, develop and implement extract modules and streams for data migration;

-Develop adhoc reports

Technical environment: DB2, EASYTRIEVE Plus

VANGUARD Group, Valley Forge, PA

Programmer / Analyst – Consultant (05/1996 – 08/1998) via RCG Information Technology Inc

-Design, code and test adjustments to Participant Related Services application;

-Production Support duties.

Technical environment: DB2, VSAM, COBOL, CICS, MicroFocus COBOL

CONRAIL Corporation, Philadelphia PA

Programmer / Analyst – Consultant (03/1994 – 05/1996) via ARMS Inc

-Support, maintain and design enhancements for Account Payable, Account Receivable and Procard applications;

-Design, analyze, code, test and implement modules for Account Payable system (Collection department).

Technical environment: DB2, VSAM, COBOL, CICS

THOMPSON-CSF – Scientific Research Institute, Kharkov, Ukraine

Programmer / Analyst (1989 – 1992)

-Production support and development enhancements for real time gas tracing system

Technical environment: FORTRAN, ASSEMBLER

Central Post Office of Kharkov, Kharkov, Ukraine

Computer Engineer (1986 – 1989)

Hardware and software maintenance

EDUCATION

Kharkov National University of Radioelectronics, Kharkov, Ukraine (1981-1986)

BS in Computer Engineering

TRAINING

-Dimensional Modeling – Declaring Dimensions by Pragmatic Works, Online (05/2018)

-SSIS – Loading Dimensions by Pragmatic Works, Online (05/2018)

-Implementing Data Warehouse with SQL Server by MS, Online (04/2018)

-Series of Data Warehousing concept lectures by Skillport, Online (04/2018)

-Reporting Services (SSRS), Online (02/2018)

-Bash Basics, Online (01/2018)

-Pragmatic Works SSIS Online Training, Philadelphia PA (05/2009)

-DataStage Essentials for Enterprise Edition v8, Philadelphia PA (11/2008)

Contact this candidate