Jaydip Chakrabarty
************@*******.***
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