Professional Summary
· Mainframe Professional having around 10 years of experience in Fortune 500 Companies in Analysis, design, development, testing and implementation of IBM Mainframe and client-server projects in various industries such as Insurance(Auto, P&C, Annuity), Reinsurance, State and Local Government, Financial services and Airline sectors.
· Proficient in IBM Mainframe Technologies such as COBOL, CICS, JCL, VSAM, DB2, EASYTRIEVE, XPEDITOR, INTERTEST, FILEAID ,Sync Sort, Easytrive,... etc in MVS environment and has enough working experience in J2EE, Microsoft .net and UML.
· Having Experience as a Tech Lead/ Programmer Analyst/Onsite Coordinator (Technical Lead) in mainframe and client/server environments.
· Versatile experience in providing 24X7 on call support.
· Expertise in obtaining project requirements from user and manager, formulating the requirements into functional and technical specifications.
· Having versatile experience in resource handling, team mentoring, task estimation- scheduling- tracking,
· Full understanding of all phases of Project Life Cycle/SDLC including Requirement gathering, Analysis, Design, Development, Implementation, Testing, Software quality standards and configuration management and change management and Quality procedures.
· Writing Easytrieve/COBOL/JCL programs for generating adhoc reports and extracts for the businesspersons for important audits and also for other business improvements purposes.
· Expertise in Project documentation , Flow charts, Structure charts, Coding, Testing and Quality audit reviews
· Extensively worked on MS Office Tools (EXCEL, WORD, VISIO, POWERPOINT and ACCESS) and Mercury Interactive.
· Good Programming and Communication Skills with excellent work ethics, easy adaptability to demanding time schedules coupled with positive user interaction and excellent team spirit.
· Exceptional ability to quickly master new concepts.

Technical Summary:

Languages: COBOL, JCL, Easytrieve, Rexx, Informatica, VB, ASP, VB Script, JavaScript, HTML, SQL, PL/SQL, UNIX Shell Scripting.
OLTP: CICS
Databases: DB2, VSAM, IMS, ORACLE 7.X/8i, SQL SERVER, MS-Access
Librarian products: Endevor, Panvalet, Changeman and Control M.
Operating systems: MVS/ESA, OS/390, WINDOWS 95/98/2K/NT, MS - DOS and XP
GUI: Visual Basic 5.0, ASP, Power Builder 7.0

Project Experience:

Confidential,Pittsburgh, PA

March 2010 to Present

During this period, Ketan is involved in the following projects as Mainframe Developer:
Multicurrency Platform Project
Ketan is involved in the Multicurrency platform project, which involved analysis , design, coding interface integrating the existing PNC bank mainframe application into Oracle Flexcube ( Banking Product). His responsibilities include:
· Gathering and analyzing PNC Bank user requirements for Multi Currency Platform.
· Analysis, designing and coding STX( Suspicious transaction system ) , WTS ( compliance system), FX Ocharlie interface from Oracle Flexcube to PNC bank Mainframe.
· Technical design document created for three Interfaces.
· Oracle Flecube to mainframe interface development involved COBOL Programs, JCLs, PROCs, ISPF/TSO, File-AID, CA Quick Edit and Endevor in IBM ES-3090 under the MVS/ESA operating system, Data base mapping Involved Micro soft Office products, ORACLE DB and ORACLE GI ( Generic Interface ) tool.
· Writing Easytrieve/COBOL/JCL programs for generating adhoc reports and extracts
from the Oracle Flexcube.

Environment: COBOL, ISPF/TSO, File-AID, Sync Sort, Easytrieve, ORACLE Flexcube, ORACLE DB, UNIX Shell Scripting, Informatica, PL/SQL

Confidential,Chattanooga, TN

August 2008 to March 2010

During this period, Ketan is involved in the following projects as Mainframe Developer:
Integration Project
Ketan is involved in the integration project, which involved integrating the existing LIFE/70 mainframe application into Internet technology. His responsibilities include:
· Gathering and analyzing user requirements
· Converting five applications in the mainframe system by changing JCLs, including Subroutines, ISPF/TSO, MQ Series, File-AID, Change Man, CA Logic Record Facility, IMS and CICS and all OS/VS COBOL to VS COBOL II code for conversion change in IBM ES-3090 under the MVS/ESA operating system
· Creating similar test environments as production baseline for testing JCLs, which included Subroutines and source code of VS- COBOL II program transfers in the test region
· Performing module, system integration, date rollup, parallel, and user acceptance testing for the conversion change
Environment: Subroutines, ISPF/TSO, MQ Series, File-AID, Sync Sort, Easytrieve
ChangeMan, IMS, DB2 Stored Procedures, CICS, and MVS/ESA

Confidential,Trenton, NJ

August 2006 to August 2008

Confidential,As Performance Test Lead, Ketan led a team in the development and testing of the SACWIS project, which is a transfer of the eWiSACWIS web-based system developed by CGI- AMS and now in use in Wisconsin. The new SACWIS system supports case practice reforms undertaken by the Division of Youth and Family Services to promote child safety and well being, by supporting case tracking and integrated case management. His responsibilities included:
· Developing and testing COBOL batch programs and providing overall technology support across the project
Environment: COBOL, DB2, QMF, SPUFI, MicroFocus Net Express, J2EE 1.3, Struts 1.1, JSP 1.1, Servlets 2.3, JDBC 2.0, JMS, WebServices, JAAS, SQL, HTML, DHTML, JavaScript, Active-X, MS Visual Basic, IBM WebSphere Suite 5.1, Oracle 10g, Shell Scripting, VI Editor, KSH, HP Service center, MS Windows, AIX, and Linux

August 2006 to April 2007

Financial Management System (FMS/3)
As Performance Test Lead, Ketan led a team in the testing of the FMS/3 project. The first phase of FMS/3 implementation involved functionality and integration with the Department of Education (DOE) that allows processing of Other Than Personal Services (OTPS) expenditure chain functionality consistent with City-wide accounting and procurement guidelines. His responsibilities included:
· Serving as the Performance Test Lead for IFA and OTPS applications, which included integration, batch, online, query, and reporting tests
Environment: COBOL, DB2, JCL, Xpeditor, File-AID, SPUFI, QMF, CICS, J2EE 1.3, JDK 1.4, EJB 1.2, JMS, MQ Series, WebSphere Application Server 5.1, Advantage 3, Oracle 9i, and AIX

April 2006 to July 2006

MBNA - Retail and Vendor Integration
As Technical Consultant, Ketan was involved in the development and testing of the MBNA - Retail and Vendor Integration project. His responsibilities included:
· Coding and testing Payment Channel interfaces - Retail and Vendor Integration assignment using COBOL, JCL, Subroutines, ISPF/TSO, File-AID, DB2, QMF, SPUFI, SQL, REXX, CICS, ChangeMan, and Xpeditor
· Coding conversion file transactions Data Exchange Repository System (DERS) for test and production. All DERS transaction is used for Bank of America to Customer and Customer to Bank of America
· Coding and testing balance and status transfer file programs in Bank of America’s Mainframe and MBNA transition work assignments for payment channel interfaces BIN table subprograms and copy books
· Performing module and system integration testing using Mainframe for Balance and Status file module for MBNA - Retail and Vendor Integration assignment
Environment: COBOL, JCL, Subroutines, ISPF/TSO, File-AID, DB2, QMF, SPUFI, SQL, REXX, CICS, ChangeMan, and Xpeditor

February 2004 to April 2006

PrimeWire Benefits Administration Application
As Team Lead, Ketan led a team in the analysis, design, development, and testing of the PrimeWire Benefits Administration application, which integrates all key aspects of employee benefits administration from eligibility and enrollment to reporting and billing reconciliation. His responsibilities included:
· Gathering user requirements
· Analyzing, designing, coding, and testing programs
· Coding various client maps for the PrimeWire benefits administration application on their proprietary language
Environment: .NET Framework, C#, VB.NET, ASP.NET, ADO.NET, SOAP, WSDL, Firewall, FTP, Data Junction tools, and Windows Security

June 2003 to February 2004

CLARUS Revenue Mainframe Application
As Developer/Technical Lead, Ketan was involved in the development and testing of the CLARUS Revenue Mainframe application. His responsibilities included:
· Coding adapter and wrapper applications using SAS, COBOL, JCL subroutines, ISPF/TSO, File-AID, DB2, QMF, Xpeditor, SQL, CICS, MQ Series, ChangeMan, DB2, and Stored Procedures
· Performing module, integration, system, and regression testing using TestDirector
· Maintaining DB2 and MS SQL Server databases
· Resolving application problems
Environment: SAS, COBOL, JCL subroutines, ISPF/TSO, File-AID, DB2, QMF, Xpeditor, SQL, CICS, MQ Series, ChangeMan, and DB2 Stored Procedure

Confidential,WA, DC

September 2001 to June 2003

Quick Rule
As Developer, Ketan was involved in the analysis, design, development, testing, and full life cycle support for the Quick Rule project. His responsibilities included:
· Gathering user requirements
· Analyzing, designing, coding, and testing programs
· Performing object oriented analysis and design using Rational Rose and UML
· Developing the mainframe application using COBOL, JCL subroutines, ISPF/TSO, DB2, CICS, REXX, IDMS, ChangeMan, DB2 Store Procedures, Xpeditor, File-AID, and QMF
· Developing the front-end using HTML, Java, Servlets, IBM WebSphere, and Visual Age for Java
· Converting back-end Fare Manager mainframe applications using DB2 and IDMS
· Providing full life cycle support of “Quick Rule” an EAI (Enterprise Application Integration) project
Environment: COBOL, JCL subroutines, ISPF/TSO, DB2, CICS, REXX, IDMS, ChangeMan, DB2 Store Procedure, Xpeditor, File-AID, QMF, HTML, Java, Servlets, IBM WebSphere, and Visual Age for Java

April 2001 to September 2001

New Claim System Phase IV
As Build Coordinator, Ketan was involved in the development and testing of the New Claim system Phase IV project, which involved integrating new Java front-end applications with the existing mainframe legacy system. His responsibilities included:
· Gathering user requirements
· Reporting applications connecting to the existing Blue Cross Blue Shield mainframe using COBOL, DB2, CICS, SAS, MQ Series, JCLs, Subroutines, ISPF/TSO, File-AID, REXX, ChangeMan, Xpeditor, SQL, and QMF
· Creating system test plans for the development environment and program transfer in the test region for the new claim system
· Developing the module and system integration testing application environment for the new CICS region. The region included entry for PPT, PCT, RCT, FCT Programs, and Transactions and File applications
· Testing JCLs and source code for VS COBOL II applications
Environment: COBOL, DB2, CICS, SAS, MQ Series, JCLs, Sync Sort, Easytrieve , Subroutines, ISPF/TSO, File-AID, REXX, ChangeMan, Xpeditor, SQL, and QMF

August 2000 to September 2001

During this period, Ketan was involved in the following projects as Senior Consultant:
Enterprise Application Integration (EAI) Project
Ketan was involved in the analysis, design, development, testing, deployment, and support of the Enterprise Application Integration (EAI) project. This project integrates the new website with Cigna’s Mainframe legacy system. Some of the applications used in the integration, include Eligibility Benefits and Claim Status transaction for providers. His responsibilities included:
· Performing object oriented analysis and design using Rational Rose and UML
· Creating system use cases and class, sequence, and state diagrams based on requirements
· Developing and customizing Java Server Pages (JSP) for the customer user interface (UI) online registration
· Developing the web tier using XML, JSP, XML, Java, Java Beans, Servlets, IBM WebSphere, and Visual Age
· Analyzing, mapping, designing, coding, and testing adapter programs for the Eligibility and Claim application in Cigna’s’ Mainframe using COBOL, ISPF/TSO, DB2, CICS, IDMS, ChangeMan, MQ Series, DB2 store procedure, File- AID, QMF SPUFI, and Xpeditor
· Performing module, integration, system, and regression testing using TestDirector
· Deploying the application on WebSphere
· Supporting system and user acceptance testing
Environment: COBOL, Subroutines, ISPF/TSO, DB2, CICS, IDMS, MQ Series, ChangeMan, DB2 Store Procedure, Xpeditor, Java, EJB 2.0, JSP1.2, JMS, DB2, Oracle 9i, JavaScript, HTML, UML, Cascading Style Sheet, MQ Series, WSAD, Lotus Notes, ClearCase, ClearQuest, CICS Transaction Gateway, and WebSphere 5.1.2
Vendor Feed Outsourcing
Ketan was involved in the testing and support of the Vendor Feed Outsourcing project, which is an Enterprise Application Integration project that integrates MS Visual Basic front-end vendor applications with the CIGNA mainframe legacy systems to provide Eligibility and Benefit feeds for vendors. His responsibilities included:
· Gathering and analyzing user requirements
· Performing feasibility study, unit, system, and regression testing, and implementation of "Vendor Feed Outsourcing” project applications
· Reporting applications connecting to the existing Cigna mainframe using COBOL, JCLs, DB2, CICS ISPF/TSO, ChangeMan, DB2 Store Procedures, File-AID, and Xpeditor
Environment: COBOL, JCLs, DB2, CICS ISPF/TSO, ChangeMan, DB2 Store Procedures, File-AID, and Xpeditor

August 1998 to August 2000

Year 2000 Date Conversion Project
As Mainframe Developer, Ketan was involved in the Year 2000 Date Conversion project. His responsibilities included:
· Gathering and analyzing user requirements
· Converting five applications in the mainframe system by changing JCLs, including subroutines, ISPF/TSO, MQ Series, File-AID, ChangeMan, Xpeditor, SQL, and CICS and all OS/VS COBOL to VS COBOL II code for year 2000 change in IBM ES-3090 under MVS/ESA operating system
· Creating similar test environments as production baseline for testing all JCLs, which included subroutines and source code of VS COBOL II program transfers in the test region
· Performing module, system integration, date rollup, parallel, and user acceptance testing for the Year 2000 Change
Environment: ISPF/TSO, MQ Series, File-AID, ChangeMan, Xpeditor, Sync Sort, Easytrieve ,SQL, and CICS

March 1998 to August 1998

Point In Time (PIT)
As Senior Systems Analyst, Ketan was involved in the development, testing, and implementation of the PIT project, which involved transferring data from VS COBOL II Mainframe to AIX/Unix using MF COBOL. His responsibilities included:
· Creating VS COBOL II programs for extracting data from IMS database to IBM ES-3090 mainframe that used MVS/ESA as their operating system
· Developing JCLs for various unit work using ISPF/TSO of mainframe
· Creating the DB2 database using AIX Unix platform and Active-X utility program
· Coding and testing the PIT project VS-COBOL II programs with MVS as the operating system and MicroFocus COBOL programs with AIX/Unix and MS Windows 95/NT as network operating systems
Environment: VS COBOL II, ISPF/TSO, DB2, AIX/Unix, and MS Windows 95/NT

July 1990 to February 1998

Billing System of Global System for Mobile (GSM) Software Package
As Software Developer, Ketan was involved in the analysis, design, development, testing, and implementation of the Billing system of the GSM software package, which maintains information of the customer care, cashier, billing and collection, finance, and engineering. His responsibilities included:
· Gathering, analyzing, and enhancing user requirements
· Participating in the entire life cycle of the project consisting of 7 modules
· Conducting the feasibility study
· Creating the user interface
· Designing and coding the Stock Transfer Activity Solution software application using FoxBase, Dbase III, Clipper, C, and Unix and the Total Stock Trading Business Solution software, which is a package consisting of Financial Accounting, Sales Invoicing, Inventory Management, and Costing applications and developing a part of the system using Oracle as the back-end and Developer 2000 as the front-end and coding other applications using dBASE, FoxBase, FoxPro, and Oracle
· Designing and implementing Data Compression and Date Cryptology software packages
· Testing and debugging the application
· Developing the package using MS DOS, Unix , and VAX as the operating system and C as the programming language and the rest of the project using “Hoffman Coding”, and a bit level data compression method using C as the programming language with Unix as the operating system
· Performing module, integration, system, and regression testing
· Providing support for the final implementation of the Billing system software
Environment: CA-Relia COBOL, Lapres, Btrieve, Panel Edit Facility, Oracle, Unix, C, C++, Novell NetWare, dBASE, FoxBase, FoxPro, Oracle, MS DOS, Unix , VAX and MS Windows NT
Education:
· Bachelor of Science in Computer Engineering\\

Certification / Training:
· Training in Java and Object Design, Object Space Inc., Dallas, TX