Mainframe developer

Detailed Candidate Profile

Detailed Candidate Profile

Over 20 years of extensive programming experience for application software utilizing COBOL, CICS,

•

VSAM, DB2, JCL MQSERIES and standard mainframe development tools.

Strong experience in DB2/SQL programming for writing procedures, user defined functions and triggers,

•

SQL quires tuning and optimization.

Debugging and diagnostic skills in batch and online program preparation processing.

•

Productive self starter with a strong work ethic; consistently achieve goals.

•

A good team player, who loves to meet the challenges, and can work independently with minimal

•

supervision,

Able to work under pressure, use own initiative and motivation to meet deadlines, juggle multiple projects,

•

and set priorities without close supervision.

Experience to lead teams of up to 5 developers and interact with the client from requirements gathering

•

till production support to facilitate a quality of end product.

Familiar with all MS Office products (Word, Excel).

•

Pro active, flexible, enthusiastic, and results driven.

•

Experience Summary (Overall work Exp.): 20 Years

Technical Skills

Domain : Corporate Banking, Investment Banking, Life Insurance and Manufacture Industries

Programming Languages : COBOL, COBOLII, COBOL LE, CICS (Command level), BMS, Assembler, VSAM, DB2, SQL,

MQ Series, JCL

Operating System : Z/OS, OS/MVS/XA, OS/MVS/ESA, DOS/VS, VM/MVS

Tools /DB/Packages : TSO/ISPF, QMF, SPUFI, PLATINUM, EXPEDITER, INTERTEST, FILE AID, ABEND-AID, ENDEVOR,

CHAGEMAN, INFOMAN, LIBRARIAN, OMEGAMON, PANVALET, OPC, QTODBC and DATA STUDIO,

QMF for Windows

Qualifications Details

Degree Institute Major and Specialization

Ph.D. Moscow Institute of Electronic

(MIEM), Russia [1985] Computer Science

Master Moscow Forest Technical

Institute (MFTI) [1973] Electrical Engineering

Career Profile

Dates Organization Role

Senior Programmer Analyst / Technical

October 2009 till Current LNT Infotech Ltd. Lead

September 2003 – October

2009 Citigroup Senior Programmer Analyst

July 2001 – August 2003 NYK Line Software developer

June 2000 – May 2001 Salomon Smith Barney Software Engineer/Developer

January 1998 – May 2000 Chase Manhattan Bank Senior Programmer Analyst

April 1996 – December

1997 MetLife Insurance Company Senior Programmer Analyst

October 1994 – March 1996 Pershing Programmer Analyst

Professional Experience

Honda HNA/HNS new company and GSP

Project#1

Period October 2013 – July 2014

Team Size 4

Description 1.Honda North America (HNA) Human Resources Information System project

to create new company Payroll, Time and Attendance, Benefits, Bonuses and

other information systems. 2.GSP

Detailed Candidate Profile

project to create new Account Receivable interfaces and database transfer

from People Soft to SAP.

Role Team Lead, Developer, Tester.

Responsibilities • Development new, modification existing batch and online programs

to provide HNA new company HR processes and AR interfaces

between Legacy systems and SAP through web server.

• Tuning and optimization SQL queries to increase efficiency and

improve application performance.

• Specification and Test Plan preparation including Test Strategy, Test

Scope, and Constraints on Testing, Test Scripts, Test Cases,

Objectives, and Proofs to be collected for each test performed.

• Participating in Unit and System testing (including regression test)

and test results verification.

• Development and modification of JCL procedures, jobs and control

cards.

• Implementation required changes and post implementation support.

Century for CitiDirect® for Securities

Project#2

Period October 2009 – October 2013

Team Size 4

Description Century project for CitiDirect® for Securities that offers analytic tools,

transaction banking, dynamic information and other online services that

securities professionals need to increase efficiency, reduce operating costs

and improve performance.

Role Analyst, Developer, Tester.

Development and debugging new mainframe batch COBOL programs

Responsibilities •

and jobs, DB2 stored procedures, triggers and functions to deliver all

business needs.

SQL quires tuning and optimization to increase efficiency and improve

•

application performance.

Creating new and modification existing DB2 database objects (TS,

•

Tables, Indexes, Views, SP and triggers) to add new functionality and

reduce operating cost.

Test Plan preparation including Test Strategy, Test Scope, and

•

Constraints on Testing, Test Scripts, Test Cases, Objectives, and

Proofs to be collected for each test performed.

Participating in Unit and System testing (including regression test)

•

and test results verification.

Development and modification of JCL procedures, JCL jobs and

•

control cards.

Scheduling and monitoring Job execution utilizing OPC job

•

scheduling system.

Implementation required changes and production support.

•

Project#3 CitiChecking

Period September 2003 – October 2009

Team Size 8

Description Intraday and EOD Financial Transaction processing and Posting

Role Analyst, Developer, Tester.

Responsibilities • CDS1 and CDS2 Reporting systems – to provide various types of

online and scheduled batch reports to clients.

• GIW - Liquidity Data Mart – to return to Global Information Warehouse

(GIW) Redemption amount for Puerto Rico Sweep related data.

• GIW - Basel II Backend Data Integration - to create daily feed to GIW

with balance adjustment and back value amounts for all available

CitiChecking transactions as of end of business day.

• US Dollar Pooling - to deliver to Global Information Warehouse (GIW)

daily USD Pooling funds movement

• Real-Time Posting - to create CitiChecking intraday transaction

postings batch process that provides financial transactions to be

posted prior to the start of the current batch nightly process.

• Regional Balance Control System (RBCS) - to support the credit

checking of Funds Transfer transactions for Corporate and Financial

Institution accounts.

• Simultaneously worked on multiple other projects, including Early Fed

Opening, Check Status Inquiry-Disbursements, MT941 SWIFT Balance

Report, and many others and provided enhancement and

improvements of different on-line and batch programs.

Project#4 NYK Line Shiping

Period July 2001 – August 2003

Team Size 3

Description Large-scale system in support of Orders, Shipping, Billing, and Reporting

Role Analyst, Developer, Tester.

Responsibilities • Participate in the requirement gathering and high-level system

design.

• Daily interactions with clients to identify, resolve and correct

problems, make enhancements to the system and perform other

data maintenance routine.

• Design and develop batch and on-line applications.

• Design and implement system’s infrastructure including a

relational data model scheme.

• Create and test DB2 stored procedures and SQL queries

utilizing PLATINUM DB2 tools.

SSB Global Product and Administration (G.P.A) System

Project#5

Period June 2000 – May 2001

Team Size 5

G.P.A. system provides functionality for data management, that allows

Description

Detailed Candidate Profile

data related to funds and their inventory be maintained by the

responsible product managers and reported on by management

throughout Citigroup

Role Analyst, Developer, Tester.

Responsibilities • Designed and developed Global Fund Administration

Module that allows quick lookups, view-only data, and

modification of the data, Global Fund Security Module for

maintaining user access rights and security validations at

the data element level, and Global Fund Reporting Module

for producing and distributing various reports.

• Designed, managed and documented Global Funds

database structure containing over 60 tables and views;

Designed and implemented the client/server components

utilizing HTML, Java script, J2EE implementation (JSP,

Servlets, JDBC, Java Beans) and JFC, Symantec Visual Café

3.1, HomeSite 4.5, and JRun application server.

• Was responsible for development and implementation of

Global Fund Security Module reporting directly to Project

manager.

• Designed and developed security interface that interacts

with Global Fund Administration Module’s applications to

prevent an unauthorized data access and manipulation

Chase Manhattan Bank Maintain Corporate Actions (MCA) System’s

Project#6

Flexible Reporting and Letter Writing Subsystems

Period January 1998 – May 2000

Team Size 5

Provide Customer Service Representatives and Trade Administrators

Description

with powerful tool for monitoring client responses to corporate actions

and client inquiries, and handling various Proxy and Special Reporting

functions.

Role Team Lead, Analyst, Developer, Tester.

Responsibilities • Discussed and defined user requirements, designed and

documented technical specifications to be distributed to

the programmers to help facilitate a quality end product;

• Developed on-line and batch applications utilizing

COBOL II, CICS, JCL, BMS, DB2 (stored procedures), and

VSAM in OS/MVS/ESA;

• Developed system component that uses MQSeries to

query mainframe’s VSAM file for the Web applications;

• Navigated PLATINUM DB2 tools in TSO to investigate

DB2 tables and table properties;

• Led a team of programmers to develop and implement

Web-based applications utilizing HTML, JavaScript, Java

Beans, JDBC, JSP, and Java Servlets;

• Prepared job streams, cataloged procedures,

copybooks, and run books;

• Assisted in post implementation production supports.

MetLife MSAM and CITRIS Systems

Project#7

Period April 1996 – December 1997

Team Size 4

Address the needs for the central repository of policy information at a

Description

transaction level (capturing Life Annuities and Mutual Funds lines of

business) and facilitate automated data gathering.

Role Analyst, Developer, Tester.

Responsibilities • Analyzed the new systems, provided technical

information to users for writing the Conceptual System

Proposal and the Detailed System Proposal.

• Prepared specifications, project plans, status reports,

conducting meetings, helped interview contract

programmers, trained and managed programmers.

• Designed on-line screens layout utilizing SDF and BMS.

• Developed, debugged, and tested various batch and

on-line applications utilizing COBOL II, CICS, BMS, DB2,

VSAM, and Dynamic File Allocation System;

• Merged the new systems with global information

system.

• Prepared job streams, cataloged procedures, copybooks

and run books and implemented applications using

documentation database (DDB) and SAR.

• Production support

Global Account Management Information System

Project#8

Period October 1994 – March 1996

Team Size 3

Address the needs for the central repository of policy information at a

Description

transaction level (capturing Life Annuities and Mutual Funds lines of

business) and facilitate automated data gathering.

Role Analyst, Developer, Tester.

Responsibilities • Modified and developed new screens, programs, converted

programs to Cobol II, built test data, tested, and delivered

completed programs.

• Engaged in development, technical support, and enhancement

of on-line Stock Transfer System that provides a

comprehensive service to affect Transfer-of-Owner of securities

issued by corporations and government institutions. Designed

CICS programs, submitted DB2 design requirements to DBA for

building Views, Tables, Indexes, and RCT entries, etc.

Detailed Candidate Profile

Contact this candidate