Customer Service Project Manager

Yakov Khanuk

***** ****** ****, ****, ******** **377

Phone: 248-***-**** E-mail abnsla@r.postjobfree.com

Objective: Position as an Datawarehouse ETL Designer / Architect

Technical Summary:

Qualified by: Over twenty years of Data Processing experience in design, system, business and

technical analysis, database design, data modeling, project leading,

writing specification, coding, testing and implementation of software for on-line, batch, Web,

and Datawarehouse applications on IBM Mainframe, UNIX, and MS Windows platforms.

Excellent analytical and communication skills.

Operating Systems: z/OS, UNIX AIX, MVS/ESA, MVS/XA, Windows NT, MS DOS

Languages: COBOL, JCL, ANSI SQL, UNIX Shell scripts, SQL PL, Java Servlets, HTML,

JavaScript, C/C++

Software: DB2 (zOS and UNIX), IBM DataStage 8.1, CICS, VSAM, MS Access, MS Excel,

Expediter, File-Aid, IBM Utilities, PowerDesigner, ERwin, BusinessObjects

Application: Automotive, Banking application, Hospital application,

Insurance, Communication, Customer service.

Experience:

12/94 – 03/09 Compuware Corporation, Detroit, Michigan.

Consultant CHRYSLER LLC.

10/96 – 03/09 Datawarehouse ETL Analyst / Team Lead

Current responsibilities include:

Lead efforts to provide smooth and uninterrupted process to populate project’s

datawarehouse and datamarts. Develop specifications and test documentations for offshore

maintenance team as well as review final procedures and documents before production

implementation.

Analyze and examining data sources according to business requirements and specifications

Design and develop ETL procedures – Mainframe extracts, IBM DataStage jobs and

sequences, UNIX scripts, and schedules.

Perform data modeling and design of new tables as a part of Datawarehouse expansion.

Model and design Datamart for dealer’s inventory tracking and managing.

Analyze ETL procedures performance in order to improve performance and guarantee data

integrity.

Performed on-demand data loads into test and production databases.

Developed complex quires for customized data retrieval using SQL ANSI.

Analyze Database structure to improve data access by BusinessObjects reporting system.

Develop standards to provide better and faster ETL development.

Maintain Data model using PowerDesigner and ERwin.

Participate in regular meeting with users to gather data requirements and finalize designs.

Maintain all ETL related documentation: process description, dependencies, scheduling

information.

The most recent achievements include:

Developed a new Datamart and ETL process to populate it.

This Datamart serves as a back-end for Business Objects reporting on KPI

of the new inventory management initiative, which greatly maximizes dealers’

inventory usage and efficiency.

Developed a new process which allowed complete daily refresh of over 40 million records

table on daily basses. This process replaced the old inefficient and error prone “delta”

process.

Participated in smooth transition form the old UNIX environment to the new – provided fast

and reliable data transfer of the Datamart database as well as BusinessObjects repositories.

Past activities on this assignment included:

Business/System Analyst on Supply Chain Scorecard project. In charge of overall technical

design of the system. Involved in developing technical specification and identifying data

sources to fulfill customers’ demands.

Responsibilities included: performing business analysis, writing business and technical

specification, gathering necessary requirements from customers, assisting customers in

developing business specifications.

Facilitated meetings with business users.

Leading role in designing and developing back-end applications for a new Internet-based

system replacing old CICS-based on-line application. This activity included developing the

framework of accessing CICS COBOL programs from Java and developing and using stored

procedures, as well as coordinating and supervising coding, testing, and implementation

by team of developers.

System Lead and Project Manager Assistant on a major conversion project.

Involved in performing system analysis, writing specification, code review and training

of a team of entry-level programmers. Assisted the Project Manager in

compiling work plans and distribution and scheduling assignments. Also took part

in interviewing new team members and end of assignment evaluation reviews.

Environment: IBM Mainframe, UNIX AIX, Windows 95, IBM PC, COBOL II, DB2, CICS,

JCL, DataStage, BusinessObjects, T-SQL, MS Word, MS Server 6.5,

Access, Excel, HTML, Java Servlets, JavaScript, TSO, Expeditor

Consultant NATIONAL BANK OF DETROIT.

05/95 – 09/96 Designed and developed on-line Monthly Balancing report system of General Ledger

accounts. The system produces both on-line and hardcopy reports on individual terminals

and printers in CICS environment. Duties included: Technical analysis, evaluating

different methods of on-line printing, based on various types of terminal printers, coding,

unit and system testing, interaction with customers. Took part in creating user’s manual.

Participated in conversion from Panvalet system to ChangeMan.

Evaluated the feasibility of transferring information, produced by vendor’s software

from different PC sites to one site via Mainframe.

Finished various assignments, including on-line and batch update and browsing

programs. During these assignments was responsible for designing screens, coding,

testing and implementation.

Environment: IBM Mainframe, IBM PC, COBOL II, CICS, JCL, VSAM,

TSO, Xpeditor, File-Aid, ChangeMan, Panvalet.

Consultant HANDLEMAN COMPANY.

12/94 – 05/95 Participated in System testing of the Inventory Cost Accounting system. In the course of

the project performed overall analysis of the system, elaborated test plan, developed the

flow chart to define the system structure and identify missing and misplaced modules

and data. Designed several batch and on-line programs, necessary for completion of the

system.

Environment: IBM Mainframe, COBOL II, CICS, JCL, VSAM, Datacomm,

TSO, Xpeditor, Librarian.

08/94 - 11/94 United Insurance Company, Chicago, Illinois.

Sr. Programmer/ Enhanced the existing on-line system, allowing Human Resources Department to change

Analyst and adjust hiring and effective dates of sales personnel, which led to more accurate

commission payment. Improved existing programs and procedures to reduce execution

times and produce more correct results.

Environment: IBM Mainframe, COBOL II, CICS, JCL, DB2,

VSAM, TSO, Panvalet.

09/91- 08/94 Cap Gemini America, Southfield, Michigan.

Consultant. UNIVERSITY OF MICHIGAN HOSPITAL.

Participated in the implementation of a new release of the Patient Care system, based

on new release of ADS, using DCL and Table Management software.

Developed new background transactions, which performed updating and reporting

of available resources in “real time” CICS environment, in addition to batch

processing.

The implementation of this project significantly improved accuracy and reliability of the

scheduling process.

Led project to develop a system, designed to monitor unattended background transactions.

Duties included research, technical analysis and writing specifications.

Completed pilot project to allow end users, inquire data from Mainframe files via

Client/Server and analyze them on individual PC. Duties included system and technical

analysis, coding and testing of the entire system in constant contact with end users.

Environment: IBM Mainframe, IBM PC COBOL II, CICS, JCL, IMS DB, Visual Basic,

Excel macros, SQL Server, VSAM, TSO Librarian.

ALLNET COMMUNICATION COMPANY.

Developed a series of programs to track and report sales activities for management of the

company. Duties included technical analysis, coding, complete testing and

implementation.

Developed a system to produce customized reports for Customer service and Billing

departments. Duties included coding, testing and evaluating user requests and

suggestions.

Environment: IBM Mainframe, COBOL II, CICS, JCL, VSAM, Datacomm,

TSO, Librarian.

MICHIGAN NATIONAL BANK.

Designed customized system to post entries from vendor’s supplied file into General

Ledger. Duties included evaluating test data, designing system flow chart, coding and

testing on-line and batch programs.

Environment: IBM Mainframe, COBOL, CICS, DB2, JCL, TSO, Librarian.

ALEXANDER HAMILTON LIFE INSURANCE COMPANY.

Wrote number of programs for annual reporting system.

Environment: IBM Mainframe, COBOL, CICS, DB2, JCL, TSO, Librarian.

01/89 - 08/91 American Community Mutual Insurance Company, Livonia, Michigan.

Programmer/ Responsible for maintaining existing and designing new on-line and batch programs for

Analyst for various lines of individual life and health insurance business. Duties included

designing, coding, testing and implementing changes made to existing systems, as well as

direct contact with customers from various departments such as Customer Service, Sales

and Actuarial.

Completed two major projects:

Modification of the Commission payment system, due to changed structure of

commission

distribution. Duties included: developing project plans writing and modifying batch and

on-line programs, unit and system testing, implementation.

Modification of Customer service, Billing and Commission payment systems, due to

opening new states for business. Duties included: developing project plans,

coordinating interchanges between systems, modifying and writing batch and on-lines

programs and procedures, unit and system testing, implementation.

Environment: IBM Mainframe, COBOL, CICS, VSAM, JCL, TSO, SAS, Panvalet.

09/81 - 12/87 Computer Technology Service Company, Moscow, USSR.

Designed, developed and wrote new software for processing payroll, inventory and

other financial applications for a number of Moscow companies. Also participated in

training and managing data entry and clerical personal.

Environment: IBM Mainframe (clones), IBM PC (clones) COBOL, Basic, VSAM, JCL.

Education:

1975 - 1981 Moscow College of Electronic Communication, Moscow, USSR.

Degree: MS Computer Science.

Training: Oracle Development, C/C++ Language, BusinessObjects Reporting and Universe Design.

IIS 8.1 Training including DataStage 8.1, QualityStage, FastTrack.

Contact this candidate