PROFESSIONAL SUMMARY

 
• Over 12 years of  experience in Analysis, Design, Development/Coding, Testing, Maintenance  (Enhancements and Change Requests) and Documentation of business application  systems.

 
• Strong technical skills inNATURAL, ADABAS, COBOL, CICS, DB2, JCL and VSAM programming.

 
• Extensive experience in MVS utilities and tools such as TSO/ISPF,  IDCAMS, QMF, FILEAID, DB2UTILITIES, FTP, SPUFI, MQ, XPEDITOR, PREDICT, CONSTRUCT,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 support.

 
• Extensive global working experience.

 
• Masters  in Computer Application (MCA).

 
• Having H1B visa valid  up to 2011.

Technical  Summary

Languages: NATURAL, COBOL, CICS, C, REXX, PL/I, PL/SQL, VB 6.0, Java

      Databases: DB2,    ADABAS, Oracle 9i, MS-Access

    Operating    Systems: MVS,    Windows XP/2000, UNIX, Linux

    Others: JCL,    ISPF, VSAM, PREDICT, CONSTRUCT,    IDCAMS, MQ, QMF, FILEAID, SPUFI, XPEDITER, DB2UTILITIES, FTP, CHANGEMAN, XML, MS Office

MAJOR WORK EXPERIENCE

Confidential, Netherlands01/08   -  Till Date

    Project: VL Code Transfer

    Description: Extract all the business  rules from the source application in Mainframe environment and generate  corresponding components in Java and .Net environments.

    Role: Senior Mainframe  Architecture

    Responsibilities: Distribution of jobs, Analyzing user  requirements, Preparing program specifications, Coding, Unit Testing.

    Platform:IBM  3090, Windows Server

    Development Tools:NATURAL, ADABAS, COBOL, DB2, VSAM,MSSQL, ORACLE

Confidential,  Dalian, China02/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

    Responsibilities: Load data into DB2 tables and CMDW  Interface tables, Distribution of jobs, Analyzing user requirements, Preparing  program specifications, Coding, Unit Testing.

    Platform:IBM  3090

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

Confidential, IL, USA01/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

    Responsibilities: Analysis, coding and unit testing, Job  distribution, Onsite Coordinator, Project Scheduling, Preparing Defect  prevention plan, Project Status Reports.

    Platform:IBM S-390

    Development Tools:NATURAL, ADABAS, CONSTRUCT, COBOL,  DB2, JCL

Project:  Customization of the Walker Purchase Order Module

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

    Role: Team Leader

    Responsibilities: Enhancement  and Maintenance,  Analysis, Coding, bug fixing,  testing of batch portion of the system and support to  other team.

    Platform:IBM S-390

    Development Tools:COBOL, CICS, DB2, NATURAL, ADABAS, VSAM, CONSTRUCT, JCL

Project: Mileage Plus  System

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

    Role: Team Leader

    Responsibilities: Analysis, Enhancements and maintain  certain sub-systems, designing data models, coding and testing.

    Platform:IBM S-390

    Development Tools:COBOL, JCL, VSAM, REXX, FILE-AID, CHANGEMAN, XPEDITER

  

  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

  Responsibilities: Onsite Coordinator, Installation and  Upgrade, Allocating system storage Optimizing the performance, Creating and  modifying primary objects (tables, views, indexes), Maintaining database  Security, Planning backup and recovery,  Application/Business Logic, Creating database triggers and stored  procedures, Restoration of database in the event of a crash.

  Platform:HP-UX, IBM-AIX

  Development Tools:Oracle, MSSQL, DB2, Shell Script, Perl, XML, JAVA

  

  Project: Condor

  Description: This is a  crew scheduling conversion project

  Role: Project Leader

  Responsibilities: Migrating from mainframe to Unix  environment with Pro*C and Oracle. Define and develop the business rules,  Database analysis and design, Coding, Unit Testing, Interacting with Client,  Job Distribution.

  Platform:HP-UX

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

Confidential, CA, USA09/98  to 12/99

    Project: Single Image  Solution

    Description: SIMS  (Single Image Solution) project of Safewayis to reengineer merchandising and  retail applications to get a competitive edge in the market.

    Role: Mainframe  Developer

    Responsibilities: Analysis, coding, preparing execution  scripts, unit testing, scheduling and loading data that are captured daily and  weekly into various tables.

    Platform:IBM  3090

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

Confidential,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

    Responsibilities: Analysis, coding, preparing test  plans, unit testing.

    Platform:IBM Mainframe

    Development Tools:NATURAL, ADABAS, COBOL, CICS,  VSAM, REXX, JCL, FILE-AID, CHANGEMAN, VLT, XPEDITOR, Comparex, Hourglass.

Confidential, USA06/96  to 07/97

    Project: VISA EDIT  SYSTEM

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

    Role: Mainframe  Developer

    Responsibilities: Analysis, coding, preparing test  plans, unit testing.

    Platform:IBM Mainframe

    Development Tools:VS-COBOL II, VSAM, JCL

Confidential, USA   05/95 to 06/96

    Project: Morgan Stanley  Financial Accounting Systems

    Description: This was developing software for  Financial Accounting areas.

    Role: Mainframe  Developer

    Responsibilities: Analysis, coding, preparing test  plans, unit testing.

    Platform:IBM Mainframe

    Development Tools:NATURAL, ADABAS, JCL

MCA

B.Sc in Mathematics

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

    C++ and Java  From  OSDATA, Calcutta, India