Data Test Cases

Dmitry Shtivelberg

Cell: 847-***-****

*******@*****.***

OBJECTIVE: Data Analysis, Software Development, Programming and Project Management.

SUMMARY:

Data Analysis and Systems Development for ETL in financial and health industries. End to end systems development activities including the development of requirements, design, programming, QA testing and support. Strong data analysis skills focused on forefeel business requirements, test cases development, and production issues modeling. Effective use of tools for data analysis and program coding on different stages of software development. Excellent problem solving skills. Ability to ask the right questions to identify the core of business processes. Perfect record of production support as a Second Level Support for a 24/7 production cycle and new production releases. Strong customer focus and management of user relationships.

SOFTWARE: SAS, SQL, Informatica, Excel, Cobol II, CICS, DB2/SQL, SPUFI, Stored Procedures, OS/MVS JCL, Endevor, QMF, TSO/ISPF, FILE-AID.

ENVIRONMENTS, OS: Linux/Unix, Windows, MVS, IBM 3090/370, 308X.

METHODOLOGIES: Agile Scrum methodology and matrix management.

PROFESSIONAL EXPERIENCE

Senior Data Informatica Analyst. 12/2011 – 6/2017

HDMS. Chicago, IL. Health Data and Management Solutions.

Completed projects in Linux/Unix, Windows environment using SAS, SQL, Informatica, Excel, TextPad, UltraEdit and SAS Universal Viewer.

Implemented major health plan data processing (greater than 700 million records monthly) upgraded from a legacy system to a company standardized process by developing custom client specific macros and incorporating them to common production jobs.

Analyzed and processed data from 5 health plans in a monthly process that included evaluation of input data omissions and anomalies, meticulous inspection of log and list files for inconsistencies with past production runs, analysis of data frequency and reconciliation at every step of the process to understand emerging or new trends in the client's data.

Thorough analyzed determinative key indicators of process for financial measurements, accounts structure and patient classification system.

Developed and implemented process for new plan as sub plan of existing process for general population by retrofitting current macros to handle input data from a new different layout but receive output data in one common format.

Maintained production environments with recurrent dimension updates from specifications of private and government sources, before / after research of updated data for changes, analysis of formats and testing different development / production environments.

Introduced new processing and update measures such as Health Reimbursement Arrangement (HRA), ICD-9 to ICD-10 Crosswalk, Low-value Care Measuring, NDC Time Sensitive Lookup, Prevention Quality Indicator (PQI), First Paid Date Logic, etc.

Mainframe Programmer Consultant. 9/2010 – 11/2011

The Vanguard Mutual Funds. Malvern, PA. Mutual Funds Group.

Completed in mainframe environment using Cobol II, DB2/SQL, SPUFI, Stored Procedures, OS/MVS JCL, Endevor.

Prepared specifications for new software with cooperation of business clients and a front end IT team that uses newly developed products.

Had a role in the connection between conflicting business requirements and system resources.

Coordinated all stages of testing included in the client’s acceptance test with a focus on troubleshooting new development processes to bring defect free software to production.

Participated in planning to develop system capability to introduce an international product for domestic and foreign clients by working closely with a developmental group in the firm’s overseas offices.

Exhibited leadership skills with regular participation in business meetings.

Programmer / Tester Consultant. 7/2009 – 8/2010

Home Medical Inc. Northbrook, IL. Medical equipment supply.

Completed projects in Unix and Window environment using SAS, SQL and Excel.

Participated in the testing of software to validate drug claims.

Managed all phases of testing for assigned components, ensured test plans and test cases were completed and met business requirements.

Worked with development teams to investigate and correct software bugs and deficiencies based on the test results.

Generated system test scripts for different test scenarios covering all aspects of project functionality.

Performed various types of testing, such as functional, regression, user acceptance, negative and installation testing, recording and documenting the results.

Senior System Analyst/Programmer 3/1998 – 4/2009

Discover Financial Services. Riverwoods, IL. Credit card issuer.

Projects completed in mainframe environment using Cobol II, DB2/SQL, SPUFI, Stored Procedures, OS/MVS JCL, Endevor, QMF, TSO/ISPF, FILE-AID.

Principal responsibilities included application design; development and testing; technology architect; production support; manually modification production data.

Served as a key member of the Merchant Boarding team. Developed numerous processes for acquisitions merchants of Discover Card usage.

Analyzed business requirements, collected data to establish rules, designed process, extended test of components of new and modified software, production implementation.

CONTINUED EDUCATION

Introduction to Informatica. SAS Programming Essentials. SAS Macro Language Essentials.

COBOL in MVS environment. DB2 for COBOL programmer. JCL for COBOL developer.

Data gathering for IT professional. Quality Assurance and Testing Training. Endevor Change Manager Overview. Agile Methodology Foundation.

EDUCATION

B.S. Mechanical Engineering.

Polytechnic Institute, Moscow, Russia.

REFERENCES Available upon request.

Contact this candidate