BORIS KHAVULYA

*** ****** *****

West Orange, NJ 07052

973-***-**** (res.)

732-***-**** (mobile)

Email : acx8zq@r.postjobfree.com

SUMMARY: Extensive experience in data processing full project life cycle development, maintenance and production support of a variety of large scale IBM zOS/MVS business applications such as investment, brokerage, banking, insurance, telecommunications and finance.

HARDWARE: IBM 308X, 309X, IBM 370/390 Series, IBM PC and compatible.

SOFTWARE: DB2/SQL/XDB/QMF/XML, DB2 Native and External Stored Procedures, SQL PL, DB2 Triggers, COBOL II, CICS(C/L), IBM Rational Developer for System z (RDz), VSAM, TSO/ISPF, ENDEVOR, CHANGEMAN, XPEDITER (Batch and CICS), CA InterTest, JCL, MicroFocus COBOL/CICS, MS Office (Windows, Word, Excel, Project, Access, VISIO, PowerPoint), CA Clarity PPM (Project and Portfolio Management) System.

EXPERIENCE:

3/14 – present Mercedes-Benz USA, LLC – Montvale, NJ

Senior Mainframe Software Developer/Team Leader

Worked as AfterSales Business Development (ASBD) group team lead on various projects implementing Market Research Aftersales (MRA) business area requests to improve key performance indicators in Parts Data Warehouse (PDW). Major projects: introduction of Express Service and Roadside indicator flags to the MRA Repair Order Header Staging tables; ETL (Extract-Transform-Load) Open Repair Order data from vendor DMI (Digital Motor Works, Inc.); parts inventory and reporting maintenance; PDW data extracts for MRA users; enhancements to user access and maintenance for NetStar StarTuned magazine subscriptions establishing a long-running conversational transaction returning data to the client channeling front-end java frameworks’ calls to the back-end SQL native stored procedures.

Analyzed, designed, coded, tested and documented new and existing ETL modules for Parts Data Warehouse.

Reviewed business requirements and documents, created technical design documentation, developed, deployed and documented technical solutions.

Troubleshot system issues reported by Help Desk, I.T., or end users.

Provided real-time technical support for production Data Warehouse applications and ETL processes.

Experience in working with SQL DB2 native stored procedures on UDB / DB2 for z/OS database applications.

4/12 – 2/14 VerizonWireless – Orangeburg, NY

Lead Software Developer/Analyst

Worked on Virtual Information System Integrated Online Network (VISION) 4th Instance project implementing modifications to COBOL/CICS/DB2 software and infrastructure design. Created a series of backend online and batch processes to setup software transition and deployment, and migrate business customers server (DB2) data from all 3 geographic instances to the new VISION B2B (business-to-business) geographically independent billing instance.

Created and modified a series of batch and backend online mainframe modules and DB2 SQL native stored procedures utilizing latest mainframe technologies interfacing with DVS (Distributed Vision Services) middleware, centralized WebSphere Application Development interface environment generating Java wrapper classes based on the COBOL Copybook (COMMAREA) and sending XML/http request to Global Router to retrieve and update customer data.

Worked on DB2 tables with Triggers Cleanup project. The UPDATE, INSERT and DELETE database operations on the tables with triggers have been impacted by producing a negative -723 SQL code whenever an invalid hexadecimal character was detected in the CHAR or VARCHAR XMLELEMENT data type defined column causing processes to ABEND. Created a software package comprised of JCL, COBOL/DB2, SPUFI programs and scripts to replace invalid hexadecimal characters with spaces to resolve the issue. Modified existing and created new batch and backend COBOL/CICS/DB2 modules and DB2 stored procedures supplementing existing code with exit routines that allowed handling of invalid entries.

Worked with web development users on modifications to the frontend and middleware software components to restrict invalid data entries by customer service and account representatives.

As acting Task Management and Solutions consultant lead COPS (Customer Operations & Pricing Services) Business Continuity group in managing and coordination of 8 scheduled during each calendar year Enterprise Release (ER) events. Utilized CA Clarity SDLC software to implement agile project management practices to align, expedite, and automate project requests, planning, and ER deliveries.

oMajor ER projects: 4th Instance Business-to-Business (B2B) Billing project, Order Rewire DataGrid Project, Data-Pop Triggers Cleanup project, Verizon EDGE Affordable Payment Purchase Plan project.

Defined priorities and assigned tasks to the team of software developers, managed short/long term and ad-hoc development projects from requirements to deployment, provided technical and management expertise advisory.

The software was designed, developed and implemented during and between recurrent production releases and off-releases scheduled in phases and maintained using latest mainframe and web technology software such as DB2 UDB for z-OS/V10, CICS V3.2 with Channels and Containers, COBOL Z/OS/ILE, RDz and other IBM, CA and CompuWare systems application development and testing tools.

9/07 – 2/12 UPS – United Parcel Service, Paramus, NJ

Lead Programmer/Analyst

As part of the Software Engineering group worked on development of the new and support of the existing Batch and Online mainframe common modules and DB2 Stored Procedures that were being used to calculate International Global Time-In-Transit (GLTNT) Scheduled Delivery Date (SDD) and Rescheduled Delivery Date (RDD) for the International and/or Domestic shipments.

Utilized by most business and technology application groups throughout UPS, these modules also provided functionalities such as tracking numbers validation, type of service determination including implementation of new services, package tracking and activity information updates, origin and destination service guarantee profile information and many more.

Created and implemented a new DB2 Stored Procedure to store and maintain new web tracking statuses for small packages, freight delivery exception statuses, package clearing and delivery statuses, etc. to be accessed and processed by Customer Automation-Internet System and UPS Tracking applications in the distributed web environment.

The software was designed, developed, implemented with production releases scheduled in phases and maintained using latest mainframe and web technology software such as DB2 UDB for z-OS/V9, CICS V3.2, COBOL Z/OS/ILE, CWS and other IBM, CA and CompuWare systems application development and testing tools.

7/04 – 8/07 UBS Financial Services, Weehawken, NJ

Lead Associate

Participated in New Account Welcome Package (NAP) for Client On-Boarding Initiative (COBI) project as a lead developer for COBOL/CICS/DB2/DB2 Stored Procedures and backend modules to support data processing entered through a distributed web based front-end online application build on a Java/WebSphere server.

Responsible for scoping, analysis, technical design and software development of the Welcome Package Print Option screen that provided client’s capability for paging of eligible accounts, search engines by account number or Financial Advisor ID, Signature Page Print options updates, Welcome Package Mailing Options selection update, client’s salutation for use in Welcome package display, etc. Worked on the application’s component to enable Financial Advisor (FA) Name Override updates accessible from a number of screens to be used in Welcome package.

Implemented common backend routine used to restrict data to be partially viewable depending on the user’s USA entitlement security level, i.e. data viewable exclusively by either a particular branch, or selected branches, or a particular FA, or group of FA’s.

Coordinated all development, development’s unit and integration testing as well as UAT (User Integration Test) and QA testing between COBI and Document Generation Group. Smoothly launched first pilot production implementation block for 2 USA branches.

Worked on the AOO (Account Opening Overhaul) DMS (Document Management System) Rewrite development and redesign project for Client and Account Information ADS/RCA subsystems.

As a member of the batch/backend implementation team was responsible for the Document Management System (DMP) software development and design creating new and replacing existing job streams supporting users’ business systems in the Document recovery, Client and Account verification and other business areas. The software has been developed using Mainframe COBOL3/DB2 (DB2 Stored Procedures) modules and utilities, thoroughly tested and implemented in production in May 2006.

Provided monitoring and support of the newly designed system to ensure an efficient transition and timely response to the post production implementation issues.

Worked on the CDB Retirement conversion project for Client and Account ADS/RCA subsystems. The project involved replacement of the old CDB MODEL204 based system with CRDB DB2 based system and redesigning of all batch mainframe software using COBOL3/DB2 programming as well as DB2 database and Mainframe utilities.

09/00 – 05/04 UBS PaineWebber, Jersey City, NJ

Senior Programmer/Analyst

Participated in the Intel Asset Conversion project designed to reallocate Intel Employees stock shares and cash balances from two vendors - Merrill Lynch and E-Trade to UBS PaineWebber.

Uploaded vendors’ files on to the Mainframe after receiving them in the Excel format. Created MVS software to identify asset type such as shares, cash, fractional shares, Cash In Lieu and to prepare transfer files to book Transactions on the conversion dates to the Bookkeeping and General Ledger Journals. Conducted several volume tests using the test files supplied by the vendors to insure data integrity and consistency. Commenced the process and maintained close watch on the date(s) of the conversion to provide smooth transition and technical support for the process. Reviewed the transferred data and ‘totals’ results after the jobs had successfully run.

Worked on the Branch Symbol Numeric (BSN) conversion project that was implemented to convert a currently two byte character PaineWebber (PW) Branch Symbol having an alphabetic value in first position and alphanumeric in the second.

BSN (or Wire Code) is a basic building block embedded in other key data items such as Broker ID, Client Account Number, G/L Account Number, etc., which limited the number of potential retail offices and correspondent client firms of many PW business systems.

Redesigned COBOL II (both batch and online) source programs, JCL utility programs control cards and JCL procedures for HISTORICAL STOCK RECORD – HSR – PW acronym (a part of the PW Corporate Actions business application) to enable expansion of the existing BSN value to a three (3) byte long character. Introduced a new HSR branch symbol beginning with numeric values in the field’s second position and reserved blank first position for future uses. Set up and ran JCL job streams to ‘condition’ the input files, and coordinated a MOCK (parallel) unit and system tests to ensure a correct data sequence in the output files. Performed an online manual PRODUCTION/MOCK data ‘spot’ checking after the DB2 tables have been updated in batch cycle. Ran ISPF COMPAREX reports to compare extract files where specific wire codes with new standard values were being replaced during batch updates.

09/99 – 08/00 American International Underwriters, Parsippany, NJ

Senior Programmer/Analyst, Team Leader

Worked on development, maintenance and production support to the existing Windows based Risk Management IntelliRisk application that enabled personnel to access, analyze and use client information such as policy and claim summary and detail data, payment analysis and history, adjuster activity reports, etc.

Was responsible for technical design, modifications, testing and production implementation of the Overseas General Information System module to replace existing Realigned input file with original Reporting Office Consolidated file to monthly update IntelliRisk DB2 data warehouse with the original currency gross premium and expense financial data.

Designed and implemented Loss Supplemental Correction Facility, a collection of batch JCL jobs, procedures and COBOLII / DB2 programs, to update Supplemental Database with the loss data corrected by the client for the previous, non-currently processed account periods.

Modified an existing process of claim financial reporting to include Factored Line Allowance Calculation in addition to indemnity profile reporting. Changes were also made to existing associated CICS BMS and source modules to reflect the changes on-line.

Developed a sub module to summarize multiple per account period DB2 table entries for outstanding reserves and create a Common Data Interface backend file record fields with a single outstanding reserve amount shown for the particular client’s Claim and claim related identifiers.

Utilized CICS/COBOL II/DB2 software tools, utilities and programming languages to develop all systems under OS/MVS/ESA environment.

11/97 – 08/99 Bankers Trust Co., Jersey City, NJ

Programmer/Analyst/Change Management Administrator

As a part of the BTIS CM Group worked on a Library Management Turnover project that involved implementation of the bank’s corporate COBOL/CICS/DB2 software conversion from the current Library Management to ENDEVOR 3.7 controlled environment.

Was responsible for COBOL/DB2 batch and CICS on-line source coding, modifications and compile options setup. Verified code syntax and contingency of the program flow logic, including provisions for the successful CICS and DB2 precompile, compile and link edit of the source programs as well as DB2 DBRM BIND’s.

Set up standard naming conventions with allocations of the application external PDS libraries, sequential and VSAM data sets for the production migrations. Defined logical structures, systems, subsystems, types and processor groups within the ENDEVOR environment.

Conducted a number of application turnovers to production via ENDEVOR with heavy JCL modifications made to the existing JCL JOB and PROC code. Implemented ENDEVOR environment mapping and production conversion ship package preparation for the final software migration and post-migration development and QA testing.

08/97 – 11/97 Merrill Lynch, Somerset, NJ as a Consultant

Programmer/Analyst

Responsible for General Ledger month-end Financial Foundation Report production runs in the Strategic Information System department group.

Involved in testing and debugging of the Asset Based programs renovated for Y2K implementation.

The software was based and written using DB2/CICS/VSAM Host Mainframe platform.

05/96 - 08/97 Ameritech Cellular Services, Bedminster, NJ

Programmer/Analyst

Worked on development and system test of the Wireless Information Next Generation System designed to process data required by cellular billing department. The system included several applications that provided the capability to enter, access and process information on-line, perform batch functions to bill customers, rate messages and maintain the post payment information.

Responsible for technical and program design, coding, testing and implementation of existing and new modules for the Cellular Account Receivable, Payment, Customer Management, Collections, Price/Plan Management and Message Processing subsystems using MicroFocus COBOL/CICS/XDB on OS/2 and Windows operating systems platform and SPII PC front-end on-line applications.

Participated in a Basic Integration Test stage of the project as a member of the ‘fix’ team performing requested process change control modifications, elements debugging and ENDEVOR Version Control and Migrations across the participating regions.

10/95 - 05/96 American International Group, Parsippany, NJ

Programmer/Analyst

Participated in development of the Distributed On-Line Loss Adjustment Revenue System designed to process billing and invoicing for the AIG Claim Services Accounting Department.

Responsibilities included development and implementation of the Invoice Print Processing part of the backend construction, including technical and business analyses and system documents preparation, coding, testing and debugging of the Physical Paper Invoice File and Summary Report File modules using batch COBOLII/DB2 programming techniques.

Created QMF Suspense Reports as a part of the end-of-month Reporting Documentation INFOPACK Facility used by the upper level management personnel.

Maintained close contacts and communications with the client's business and technical support staff in developing details of the system architecture and design.

3/93 - 10/95 Chase Manhattan Bank, New York

Programmer

Was involved in modifications of the on-line Integrated Securities Processing and Control System that handled securities movement and control, dividend/income processing and reconciliation, provided processing for due bills, stock dividends and interest payments.

Responsible for analysis, coding, testing and implementation of various CICS on-line and batch programs to provide data entry, database population, inquiry functions for securities related information. Prepared program and system documentation, provided user training. Programs were written in CICS/COBOL II utilizing SQL to access DB2 database under OS/MVS/ESA environment.

5/91 - 3/93 Chemical Bank, New York

Programmer

Worked on various enhancements to the on-line Customer Information System that was designed to provide an ability to create and maintain all common static data required by other processing systems (including money markets, loans, FX).

Was responsible for coding, testing and debugging of various CICS on-line and batch programs to perform data entry, file update and customer/account inquiry functions. Used QMF to produce various ad-hoc reports.

EDUCATION:

The National Technical University of Ukraine “Kiev Polytechnic Institute” (NTUU " KPI")

oMS in Computer Science.

Contact this candidate