Jaydip Chakrabarty

(***)-987-***-****

acev02@r.postjobfree.com

PROFESSIONAL SUMMARY

. Over 12 years of experience in Analysis, Design, Architecture,

Development/Coding, Testing, Maintenance (Enhancements and Change

Requests) and Documentation of business application systems.

. Strong technical skills in COBOL, CICS, DB2, NATURAL, ADABAS, PL/I,

REXX, JCL and VSAM programming.

. Extensive experience in MVS utilities and tools such as TSO/ISPF,

IDCAMS, ENDEVOR, QMF, FILEAID, DB2UTILITIES, CHANGEMAN, CONTROL-M, CA-

7, FTP, SPUFI, MQ, XPEDITOR, ABEND-AID.

. Well versed with SDLC methodology and quick to grasp complex business

requirements with sound analytical skills.

. Experienced in On Call, Production Support and Customer/User Support.

. Extensive experience in Migration projects such as Mainframe

technologies to Java or .Net technologies.

. Strong technical knowledge in Database conversion projects.

. Extensive global working experience.

Technical Summary

Languages COBOL, CICS, NATURAL, C, REXX, PL/I, PERL, VB

6.0, Java, XML

Databases DB2, ADABAS, Oracle, TERADATA, MS-Access

Operating Systems MVS, UNIX, Linux, MS-Windows

Others JCL, ISPF, VSAM, IDCAMS, MQ, QMF, FILEAID,

CONTROL-M, CA-7, SPUFI, XPEDITER,

DB2UTILITIES, FTP, CHANGEMAN, XML, MS Office

MAJOR WORK EXPERIENCE

Employer : IBM/Magna Infotech

04/11 - Till Date

Project: Wal-Mart Global Replenishment System (GRS)

Description: The Global Replenishment System (GRS) is an exception-

driven and integrated system that will provide a consistent

replenishment platform across all countries and formats.

Role: Senior Technical Leader

Platform: IBM z/OS

Development Tools: CA-7, DB2, Teradata, IMS, VSAM, Oracle, JCL

Responsibilities:

Data refresh from production for various databases.

Understand the design and clarify doubts with clients.

Monitoring and maintaining jobs in CA-7.

Induct new team members with that knowledge and guide them during

different phases of project.

Task distribution within team.

Co-ordination with Onsite counterpart, client design lead and other

interrelated technology team.

Regular reporting to PM about project status

Managed multiple tasks like setting up various testing environments,

support to normal release.

Quality assurance and timely delivery from team.

Employer : American Solutions Inc (AMSOL), USA

Kohl's Department Stores, Inc, USA

01/10 - 12/10

Project: Quantum Retail Replenishment Replacement (Q)

Description: The project "Q" allows retailer clients to align inventory

with constantly changing customer demand and achieve higher sales,

profits and customer satisfaction.

Role: Senior Technical Leader

Platform: IBM z/OS, Linux

Development Tools: JCL, ESP, CA-7, COBOL, MQ, Oracle, Shell Script

Responsibilities:

Providing 24X7 production application support.

Setup different sort jobs using SYNCSORT and JCL.

Automated the job flow by using Schedulers like CA-7, ESP, changes

made to interfaces as per customers' needs, monitored different logs.

Written complex SQL to generate the reports based on the Client

Requests.

Provided JAVA application support.

Conducted different testing like Unit Testing, Integration Testing

and parallel testing under different interfaces.

Managed multiple tasks like setting up various testing environments,

meeting the SLAs, support to normal release.

As a Tech lead gathered Requirements and Participated in Analysis and

Technical specification Document design.

Provided Estimates for the Tasks and assigned the tasks to the Team.

Employer : Evolveware Information Technology Ltd

KASBANK, Netherlands

01/08 - 11/09

Project: VL Code Transfer

Description: Extract all the business rules from the source application

in Mainframe environment and generate corresponding components in .Net

and Java environments.

Role: Senior Mainframe Architect

Platform: IBM z/OS, Windows Server

Development Tools: COBOL, CICS, DB2, C#, JAVA, NATURAL, ADABAS, PL/I,

VSAM, JCL

Responsibilities:

Extracted the source code and data from the source application in

Mainframe environment using SYSTRANS, FTP,

Executed MQ and ENTIRE-X for data transfer

Setup different sort jobs using SYNCSORT and JCL.

Submitted the source to S2T tool for conversion to Java and VB.Net

components.

Written complex SQL to generate the reports based on the Client

Requests.

Conducted different testing like Unit Testing, Integration Testing

and parallel testing under different interfaces.

Managed multiple tasks like setting up various testing environments,

support to normal release.

Gathered Requirements and Participated in Analysis and Technical

specification Document design.

Provided Estimates for the Tasks and assigned the tasks to the Team.

Employer : IBM, Dalian, China

02/06 to 12/07

Project: Field Management System (FMS)

Description: The system is used to extract employee data from Enterprise

Directory (known as Blue Page)

Role: Senior Mainframe Developer

Platform: IBM z/OS

Development Tools: COBOL, VSAM, DB2, PL/I, JCL, MQ, FILE-AID

Responsibilities:

Extracted and loaded data into DB2 tables.

Executed MQ for data transfer

Setup different sort jobs using SYNCSORT and JCL.

Designed and prepared Data models for CMDW interface tables.

Written complex SQL to generate the reports based on the Client

Requests.

Conducted different testing like Unit Testing, Integration Testing

under different interfaces.

Managed multiple tasks like setting up various testing environments,

support to normal release.

Gathered Requirements and Participated in Analysis and Technical

specification Document design.

Provided Estimates for the Tasks and assigned the tasks to the Team.

Employer : Skytech Solutions Pvt Ltd, India

United Airlines, IL, USA

01/00 to 12/05

Project: Cargo Freight Accounting System

Description: The Freight accounting Cargo deals with processing of

airway bills and invoices.

Role: Project Leader

Platform: Unix

Development Tools: COBOL, UDB, Shell Script

Responsibilities:

Worked as Onsite Co-ordinator

Developed and maintained different modules using Microfocus COBOL and

UDB

Written complex SQL to generate the reports based on the Client

Requests.

Involved in preparation of test plans and Unit Testing.

Gathered Requirements and Participated in Analysis and Technical

specification Document design.

Provided Estimates for the Tasks and assigned the tasks to the Team.

Project: Customization of the Walker Purchase Order Module

Description: Walker PO module (R16.6) is for Accounts Payable

implementation.

Role: Team Leader

Platform: IBM S-390

Development Tools: COBOL, CICS, DB2, VSAM, GENTRAN, ENDEVOR, Focus, FILE-

AID, JCL

Responsibilities:

Developed and maintained different modules

Involved in analysis and bug fixing

Involved in preparation of test plans and Unit Testing of batch

portion of the system

Provided support to the other teams

Provided Estimates for the Tasks and assigned the tasks to the Team.

Project: Mileage Plus System

Description: Mileage Plus is United Airlines' frequent flyer program.

Role: Team Leader

Platform: IBM S-390

Development Tools: COBOL, CICS, JCL, CA-7, VSAM, REXX, HIPERSTATION,

ASSEMBLER, FILE-AID, CHANGEMAN, SMARTTEST

Responsibilities:

Developed, enhanced and maintained different sub-systems

Involved in analysis and bug fixing

Involved in preparation of test plans and Unit Testing of batch

portion of the system

Designed data models

Provided Estimates for the Tasks and assigned the tasks to the Team.

Project: Database Support Services (DBSS)

Description: Database Support Services is a frontline 24X7-production

support center for United Airlines dedicated to support any database

related activities (production and development)

Role: Project Leader

Platform: HP-UX, IBM-AIX

Development Tools: Oracle, MSSQL, DB2, MQ, Shell Script, C++, Perl,

XML, JAVA

Responsibilities:

Onsite Coordinator

Installation and Upgrade of the Oracle Software.

Allocating system storage and planning future storage requirements

for the database system

Monitoring the growth of data in the database and hardware capacity

Pro-active monitoring and optimizing the performance of the database

including rebuilding index

Optimizing the performance

Creating and modifying primary objects (tables, views, indexes).

Maintaining database Security

Planning backup and recovery

Managing Batch Jobs

Creating database triggers and stored procedures

Restoration of database in the event of a crash

Project: Condor

Description: This is a crew scheduling conversion project

Role: Project Leader

Platform: HP-UX

Development Tools: Oracle, Pro*C, SQL Loader, XML, MQ, JAVA, HTML,

JAVASCRIPT

Responsibilities:

Involved in migration from mainframe to Unix environment

Involved in analyzing the business rules

Developed and enhanced different modules

Involved in preparation of test plans and Unit Testing

Designed data models

Provided Estimates for the Tasks and assigned the tasks to the Team.

Employer : Syntel Inc, USA

Safeway Inc, CA, USA 09/98 to 12/99

Project: Single Image Solution

Description: SIMS (Single Image Solution) project of Safeway is to

reengineer merchandising and retail applications to get a competitive

edge in the market.

Role: Mainframe Developer

Platform: IBM 3090

Development Tools: COBOL, CICS, SAS, REXX, HIPERSTATION, DB2, VSAM, JCL,

CA-7

Responsibilities:

Setup different sort jobs using SYNCSORT and JCL.

Automated the job flow by using Schedulers, changes made to

interfaces as per customers' needs, monitored different logs.

Written complex SQL to generate the reports based on the Client

Requests.

Conducted different testing like Unit Testing, Integration Testing

under different interfaces.

American Family Insurance, WI, USA. 07/97

to 09/98

Project: Year 2000

Description: This project is to determine Year 2000 compliance of

various systems

Role: Team Leader

Platform: IBM Mainframe

Development Tools: NATURAL, ADABAS, COBOL, CICS, VSAM, REXX, JCL,

SMARTTEST, FILE-AID, CHANGEMAN, VLT, XPEDITOR, CA-7, Comparex,

Hourglass.

Responsibilities:

Developed, enhanced and maintained different modules

Involved in analysis and bug fixing

Involved in preparation of test plans and Unit Testing

Employer : RS Software, India

VISA, USA 06/96 to

07/97

Project: VISA EDIT SYSTEM

Description: Maintain and edit package BASE II and ARECON system of

Visa.

Role: Mainframe Developer

Platform: IBM Mainframe

Development Tools: VS-COBOL II, CICS, VISION PLUS, VSAM, JCL

Responsibilities:

Developed, enhanced and maintained different modules

Involved in analysis and bug fixing

Involved in preparation of test plans and Unit Testing

Morgan Stanley, USA 05/95 to

06/96

Project: Morgan Stanley Financial Accounting Systems

Description: This was developing software for Financial Accounting

areas.

Role: Mainframe Developer

Platform: IBM Mainframe

Development Tools: NATURAL, ADABAS, JCL

Responsibilities:

Developed, enhanced and maintained different modules

Involved in analysis and bug fixing

Involved in preparation of test plans and Unit Testing

EDUCATION

MCA Jadavpur University at Calcutta, India 1992

B.Sc in Mathematics Jadavpur University at Calcutta, India 1988

PROFESSIONAL TRAINING

Oracle 9i DBA From SQL*STAR, Calcutta, India

C++ and Java From OSDATA, Calcutta, India

Contact this candidate