Professional Summary :

• Mainframe Professional having around 15 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 Bank, Insurance(Auto, P&C, Annuity), 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 review
• 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.
• Extensively involved in development of COBOL, DB2, CICS, REXX, MQ series, J2EE,Servlets, JSP, JDBC, JavaBeans, EJB, JNDI,Struts, Java scripts, XML, HTML.
• Worked developing Stateless, Statefulsession beansand Container Managed Entity beans.
• Good working knowledge with Application Servers like Web sphere, Web logic, and Apache
• Expertise includes client side and server side XML using DOM and JDOM parsers.

• Strong experience in designing applications using MVC Architecture, Object Oriented Analysis and Design (OOAD), Design Patterns and Rational Rose.

Have excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and work as a part of a team as well as independently.
Key Skills/Tools:

• Web Technologies : MVC Frameworks Struts 1.0, 1.1, Servlets, JSP, JSTL, Hibernate Spring Framework1.2, HTML, Java Script and Freemarker
• Distributed Technologies : J2EE1.3, EJB 2.0, JMS, RMI
• XML and Web-Services : XML, XSLT, XPATH, SAX/DOM Parsers, AXIS , XML Beans SOAP, WSDL, SOA, XML SPY
• Web /Application Servers : Tomcat 3.1.1/4.0, Weblogic Server 8, Websphere5.0, JBoss, Jrun.
• Source /Version Control tools : PVCS, Rational Clear Case and CVS
• Languages :COBOL, Java, JCL, C, HTML, XML, SAS
• Databases :Oraclex//8.x/9 MS SQL Server 6.x,DB2, IMS,IDMS
• TESTING TOOLS :Test Director, Win runner, File-aid, Expeditor
• Other :CICS, TELON, EZTRV, endeavor, EDI, TSO, CA7 Scheduling, SPUFI, SQL, Change man ,DB2 store procedure, GSM, MS Office, EAI, CM (Configuration Management), SAS, PVCS, Clear case, Clear Quest, Lotus Notes, SDLC etc

Professional Experience: 
Confidential
12/19/2011- Continue
Client: State farm Insurance Corporation

As a Sr. Systems Analyst, Mr. Ketan Shah will be assigned to projects for STATE FARM Corporation. STATE FARM Life Insurance has several Software applications that need designing, coding, as well as end- to- end development , system, integration & performance testing.

State Farm applications run on the Mainframe, Web and UNIX platform. The UNIX applications include GUI entry and response screens and an intray (which are accessed via a browser from the intranet), and terminal-emulated screens (which use the Rumba emulation package). These UNIX applications exchange information with several other platforms. They send/receive transactions to/from CICS (corporate MVS) via MQSeries. 
Mr. Ketan Shah’s job duties comprise the following:
· Analyze, Design, Develop, Implement, integrate and maintain mainframe and web related applications including Internet, intranet and internal business applications including automation of back end systems using the knowledge of business models, online transactions, ethics and security, entity-relationship model and business rules; object-oriented modeling; logical and physical Database design & Relational model; Multiple table queries; functional dependencies and normalization, client server and middleware architecture, Transaction processing and recovery Database security and authorization, Data warehousing and data mining; etc.;
· Create programming to monitor and report statistics utilizing automatic data capture technologies and control structures: sequence, repetition and selection algorithms, program components: variable, constants, assignment statements and arithmetic statements and arithmetic operators, Built-in functions and random number generation, value-returning functions and program-defined functions, void functions and passing variables, pseudo code and flowcharts, character and string manipulation, object-oriented programming and the class definition, sequential access and random access files: writing and reading, Arrays: one and two dimensional.
· Research Mainframe and Web Technologies. Gathering and analyze business requirements and ensure that underlying application technology meets both short-term and long-term business needs and that system designs can adapt to emerging business and technology demands.
· Manage the development infrastructure, change control, configuration items and application security utilizing knowledge of information resource management. 
· Test and document all code changes. This includes Unit testing, component integration testing, system integration testing, and performance testing, capacity testing and quality reviews. 
· Communicate with project managers as to the progress of open items and work with other developers, suppliers, other infrastructure resources as needed using knowledge of information systems infrastructure, systems development stages, systems development life cycle, rapid application development, systems analysis, systems design, steps in preliminary construction, steps in final construction, data modeling, process modeling, object modeling, project planning and control, economic system and project justification, evaluation of systems alternatives, web and GUI design, systems view, systems constraints, methodology selection. Preliminary investigation, project analysis, design tips, etc.
· Perform and provide systems and business analysis. Documenting business requirements, business process, systems process and systems requirements, systems configuration, systems testing and systems test scripts. Preparing Unit test scripts, component test scripts, user test scripts and incident logs for application development. All of the above job duties are being performed under supervision from Team leader.

· Processing adhoc request from Business customers

• Adhoc research / report for State Farm LIFE specific account
• Installing and Configuring State Farm LIFE applications.
• Adding New user to State Farm LIFE application Providing assistance to customers with State Farm Life Applications.
• Providing LIFE insurance report monitoring.
• Resolving Application problems.
• Maintaining DB2 database
• Configuring and maintaining Tasker Machine
• Configuring and Maintaining VB Download Manager
• Updating PMR ( Policy Master Record) in Mainframe
• Installing and Configuring State Farm Life Insurance Applications System Support
• Providing 24/7 production support to critical UNIX, Mainframe and Web Application.
• Providing support to development and test environment for mission critical application like RISK Advisor, LPV, LHUS.

As a member of state farm’s Life insurance development and testing team, Mr. Ketan Shah will continue to utilize his technical expertise to analyze, design, code , test, implement, integrate and maintain mainframe, UNIX and web related software for State Farm’s Life insurance applications.
· RISK ADVISOR: This application scrutinizes the Life Insurance applications that are submitted and issues or rejects the applications based upon the information. This is a web based J2EE application. Development and support is needs knowledge in IBM Web Sphere, XML, Java Bean, Servlet , Junit, Eclipse, Oracle, IBM Webspehere, CICS Gateway, CICS transaction server, UNIX, MQ series , COBOL, File Aid, Expeditor, DB2, CICS, JCL, Endeavor..
· LHUS( Life Health Underwriting System) issues Life Applications that are not issued through the Systems Underwriting process. Application support needs Mainframe , MVS, COBOL, DB2, CICS , File AID, XPEDITOR , Endeavor for Testing and Production Fixes.
· Guided Processing System ( GPS) is a web based application for Policy name changes, Dividends, Withdrawals etc. Application supports needs knowledge of Java, Eclipse, Java Bean, XML, COBOL, DB2, CICS, JCL, File Aid, Expeditor, 
· LPV ( Life Policy View) is a system used to retrieve Mainframe records.
It needs COBOL programs , DB2, JCL, CICS, Copy books, File Aid, Expeditor, Endeavor to retrieve policy record request.

• Reviewing and Maintaining Mainframe LPV job Scheduling
• Creating new and updating existing COBOL programs per request of business customer Integrating End-to-end testing support.

Confidential
11/18/2010 - 12/192011
Client : PNCBANK

Serves as a Technical Consultant: in PNC bank Treasury Department for their Multi Currency account engagement.
Multicurrency Platform Engagement
Ketan was involved in the Multicurrency platform engagement, 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 Endeavor 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
11/03/2008 – 11/18/2010
Chattanooga, TN
USA
Client: UNUM

Served as the technical lead on mainframe application, adding new users for specific accounts With UNUM’s Mainframe legacy system.

• Resolving application problems, Maintaining DB2, SQL server database
• Coded reports applications using SAS, COBOL, JCL Subroutines, ISPF/TSO, FILEAID, DB2, QMF, Expeditor, File-Aid, SQL, CICS, IMS DB/DC, MQ series, Change man, DB2 store procedure and Expeditor.
• Performed Module, integration, system and regression testing using Test Director

Confidential
08/01/06- 11/03/2008 
NJ SACWIS Project, DYFS, State of NJ– (04/06/2007 to 11/03/2008)
The State of New Jersey has begun the development of its statewide automated child welfare Information system (SACWIS), a transfer of the eWiSACWIS web-based system developed by CGI- AMS and now in use in Wisconsin. The new SACWIS system will support 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. CGI- AMS has completed the work on the modification and implementation of Release 1, which rolled out intake functionality in November 2004. The balance of full SACWIS system functionality will be implemented statewide as Release 2. CGI-AMS will implement Release 3 for interfaces and overall system enhancements and modifications. When Release 2 is implemented, more then 6000 users will have access to a web-based case management system that meets all Federal SACWIS requirements and the State’s business requirements. The application is based on J2EE 1.3 platform with Oracle 10g as the database with WebSphere Application Server 5.1 as the runtime environment, AIX 5.2 as the OS on a P-series platform.

Responsibilities:
Team member – COBOL batch programs development, testing and overall Technology support across the project.
Technical Environment: COBOL, DB2, QMF, SPUFI, Micro focus Net Express, J2EE 1.3; Struts 1.1; JSP 1.1, Servlet 2.3, JDBC 2.0, JMS, WebServices, JAAS, SQL, HTML, DHTML, Javascript, ActiveX, Visual Basic, IBM WebSphere Suite 5.1; Oracle 10g; Windows, AIX and Linux;

FISA, City of New York, NY – (08/04/06-04/06/2007)
There are various projects that are based on AMS Advantage 3.0 platform. The City of New York (“City”) will replace its current Financial Management System (FMS/2) with an application based on the AMS Advantage 3 (ADV3) Financial Management product. It is a significant upgrade that will focus on using the baseline ADV3 software along with system modifications to meet the City’s business needs. The modified ADV3 application will be known as “FMS/3”.
The first phase of the FMS/3 implementation will involve functionality and integration with Department of Education (DOE) that will allow processing of OTPS (Other Than Personal Services) expenditure chain functionality consistent with City-wide accounting and procurement guidelines. The DOE currently use it own financial system, “FAMIS”, to process these transactions. To achieve this integration, enhancements will be needed on both FMS/3 and FAMIS applications to support batch as well as real-time data exchange.

Responsibilities: 
Performance test team member for OTPS applications which included integration, batch, online and query and reporting tests.
Technical Environment: COBOL, DB2, JCL , IMS DB/DC ,Expeditor, 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; AIX

Confidential
Philadelphia, PA
04/16/06-continue
Client: Bank of America,
Norfolk, VA
Technical Consultant,
04/16/2006- 06/30/2006

Served as Technical Consultant in MBNA - Retail and Vendor Integration assignment. I am responsible for coding, testing MBNA transition work assignments for Payment Channel Interfaces BIN Table subprograms and copy books. I am also responsible for coding, testing Balance and status transfer file programs in Bank of America’s Mainframe. I also worked in TSYS in Bank of America.

• Coding and testing payment Channel interfaces - Retail and Vendor Integration assignment using COBOL, JCL, Subroutines, ISPF/TSO, FILEAID, DB2, QMF, SPUFI, SQL, REXX, CICS, IMS DB/DC ,Change man and Expeditor.
• Coded all conversion file transactions DERS (Data Exchange repository system) for test and production. All DERS transaction is used for Bank of America to Customer and Customer to Bank of America.
• Performed Module and System integration testing using Mainframe for Balance and Status file module for MBNA - Retail and Vendor Integration assignment.

Confidential
Ahmedabad, India 
02/15/04-04/15/2006
Team leader

Served as technical lead on the eNucleus PrimeWire benefits administration application. PrimeWire benefits administration application integrates all key aspects of employee benefits administration from eligibility and enrollment to reporting and billing reconciliation. In addition to simplifying employee enrollment and improving employee access to benefit information via the Internet, the PrimeWire benefits administration enables its clients to reduce their "hard" benefits administrative costs and enables them to deploy their resources and human capital more efficiently. Primewire benefits administration used Data junction software for client interface.

Coded various Client Maps for PrimeWire benefits administration application on their proprietary language. 
Support duties included but are not limited to analysis and design, collection of user requirements, coding and testing

• .Net Framework, C#, VB.NET, ASP.NET, ADO.NET, Data Junction tools

Confidential
06/01/2003 – 02/15/2004
Vienna, VA
USA
Client: CIGNA Corporation 
06/01/2003 – 02/15/2004
Philadelphia
Developer
Served as the technical lead on CLARUS revenue mainframe application, adding new users CLARUS. Adhoc research / reports for specific accounts or journals. With Cigna’s Mainframe legacy system

• Resolving application problems, Maintaining DB2, SQL server database
• Coded all adapter and wrapper applications using SAS, COBOL, JCL Subroutines, ISPF/TSO, FILEAID, DB2, QMF, Expeditor, File-Aid, SQL, CICS, MQ series, Change man, DB2 store procedure and Expeditor.
• Performed Module, integration, system and regression testing using Test Director.

.
Confidential
09/01/2001 -06/01/2003
Washington, DC
Developer
Provided full life cycle support of “Quick Rule”, an EAI (Enterprise Application Integration) project.

• Analysis and design, collection of user requirements, coding and testing.
• Developed mainframe application using COBOL, JCL subroutines, ISPF/TSO, DB2, CICS, REXX, IDMS, Change man, DB2 store procedure, IMS DB/DC , Expeditor, File-Aid and QMF.
• Converted all back-end fare manager mainframe applications using DB2 and IDMS.
• Developed the front-end using HTML, Java, Servlets, IBM Web Sphere, and Visual Age for Java.
• Used Rational Rose, UML for Object Oriented Analysis and Design.

Confidential
08/01/2000 – 09/01/2001
New York, NY
Sr. Consultant
Client: CIGNA Corporation 
Served as the technical lead on “Med unite", an EAI (Enterprise Application Integration) project. The project integrated 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. Analyzed user requirements and provided feasibility studies.

• Coded all adapter and wrapper programs for Eligibility and Claim Applications using SAS, COBOL, JCL Subroutines, ISPF/TSO, FILEAID, DB2, CICS, MQ series, Change man, REXX, DB2 store procedure, Expeditor, File-Aid, SQL and QMF.
• Performed Module, integration, system and regression testing using Test Director.
• Used Rational Rose and UML for OO design and analysis.
• Developed front-end application using XML, Java, Java bean, Servlate, IBM Web Sphere, and Visual Age.

• Provided support for "Vendor Feed Outsourcing project”, an EAI (Enterprise Application Integration) project. The project integrated Visual Basic front-end Vend or applications with the CIGNA Mainframe legacy systems to provide Eligibility and Benefit feeds for vendors.
• Analyzed and collected user requirements.
• Performed feasibility study, unit testing, system testing and regression testing implementation of "Vendor Feed Outsourcing” project applications.
• Used COBOL, JCLS, DB2, CICS ISPF/TSO, Change man, DB2 store procedure, FILEAID, and Expeditor for the reporting applications connecting to the existing Cigna mainframe.

Client: Blue cross Blue shield ( Federal Employee program) 4/01/2001 – 9/01/2001
Washington, DC
Build Coordinator
Served as the Build Coordinator for the “New claim System Phase IV " project. The project integrated new java front-end applications with existing mainframe legacy system.

• Gathered user requirements.
• Used COBOL, DB2, CICS, SAS, and MQ series, JCLS, Subroutines, ISPF/TSO, FILEAID, REXX, Change man, Expeditor, File-Aid, SQL and QMF for the reporting applications connecting to the existing Blue cross Blue Shield Mainframe.
• Created system test plans for the development environment and program transfer in test region for the new claim system.
• Created Module and system integration testing application environment for new CICS Region. The region included entry for PPT, PCT, RCT, FCT Programs, Transactions and File applications.
• Tested JCL, Source Code of VS- COBOL II applications.

Confidential
8/01/1998–08/01/2000
Clearwater, FL
Client: Trans World Airlines. (TWA) 
Kansas City, MO 
Technical Consultant

Project development, coding and testing for Year 2000 Date Conversion project.

• Analyzed and Collected user requirements.
• Converted five applications in the mainframe system by changing JCLS, Includes, Subroutines, ISPF/TSO, MQ series, FILEAID, Change man, Expeditor, File-Aid, SQL and CICS.
• Converted all OS/VS COBOL to VS COBOL II code for year 2000 Change in IBM ES-3090 under MVS/ESA operating system.
• Created similar test environments as Production baseline for testing of all JCLs, INCLUDES, Subroutines, Source Code of VS- COBOL II program transfers in test region.
• All application testing included, Module, system integration, Date rollup, parallel and user acceptance testing for Year 2000 Change.

Confidential
3/01/98 – 8/01/98 
Client: Sun guard Shareholders Systems, Inc. 
Kansas City, MO 
Sr. Systems Analyst
Served as the Sr. Systems Analyst on "PIT" (Point In Time) project. " PIT" is the software used for Mutual Fund and related company activity. The project goal was to transfer data from VS COBOL II Mainframe to AIX/UNIX using MF COBOL. Provided full life cycle support for the “PIT” project including requirements gathering, testing and implementations.

• Developed VS- COBOL II programs for the data extraction from IMS Database to IBM ES-3090 mainframe that used MVS/ESA as their operating system.
• Developed JCLs for different unit work using ISPF/TSO of mainframe.
• Created DB2 database using AIX UNIX Platform and Active X utility program.
• Coded and tested "PIT" project VS-COBOL II Programs with MVS as the operating systems.
• Coded and tested Micro focus COBOL programs with AIX/UNIX, Windows95, Windows NT as network operating system.

Confidential
7/01/90 – 1/01/98
India
Software Developer 
Served Software developer for Fascel LTD, a telecommunication company in Gujarat State, INDIA. Developed and implemented "Billing System of GSM (Global System for Mobile) software package. The system is used for maintaining information of Customer care, Cashier, Billing & Collection, Finance and Engineering. Every application has separate programs that provide required data like Costing, Fixed Assets, Financial, Budget Actual, Promotion, Customer Billing and Vendor information.

• Used CA- Relia COBOL, Lapres, Btrive, Panel Edit Facility, Oracle, UNIX, C and C++ with Novell NetWare and Windows NT operating system.
• Analysed, Enhanced, and Collected user requirements
• Conducted a feasibility study, performed Module, integration, system and regression testing.
• Provided full support of the final implementation of the Billing system software.
• Responsible for designing and coding of the Total Stock Trading Business Solution software, a package consisting of Financial Accounting, Sales Invoicing, Inventory Management and Costing applications.
• Part of the system was developed using Oracle as the back-end and Developer 2000 as the front-end. Other applications were coded in dbases, FoxBASE, FoxPro and Oracle.
• Coded and designed a "Stock Transfer Activity Solution software application using FoxBASE, DbaseIII, clipper, C and UNIX.
• Involved in the design of the user interface, debugging and testing of the application as well.
• Designed and implemented Data Compression & Date Cryptology software package.
• Involved in the entire life cycle of the project consisting of 7 modules on a Pentium Machine.
• Developed the package using MS-DOS, UNIX and VAX as the operating system and C as the programming language.
• The rest of the project was developed using “Hoffman Coding”, a bit level data compression method and C as the programming language with UNIX as the operating system.

TRAINING:
Successfully Completed professional training in "Java and Object Design" with one of the top ranking training institute in OOD (Object oriented Development) Object Space Inc, Dallas, USA.

EDUCATION: 
B.S. (Computer Engineering) 
Exposure: MVS/ESA, COBOL, Visual Basic,