Analyst Project

JAGADISH PATEL

********@*****.***

Summary

Over 25+ years of experience as a Systems Programmer/Analyst with emphasis in COBOL (24 years), COBOL II (24 years), SAS (12 years), PL/1 (10 years), DB2 (10 years), IMS DB/DC (15 years), Natural (8 years), ADABAS (8 years), IDMS (5 years), MVS IBM (25 years), JCL (23 years), CICS IBM (5 years), TSO ISPF IBM (23 years), SYNON (5 years) TELON (3 years), Informix (4 years) TPF (4 years), C++ (1 year), C/370 (1 year), MQ Series (3 years), PL/SQL Oracle (4 years), MS Office (7 years), RPG IV (3 years)

Works well independently and part of a team, possesses the ability to learn complex applications quickly and is highly adaptable in a rapidly changing environment.

Ability to satisfy the requirement of one or more user area, work closely with client management to identify and specify complex business requirements and process as well as research and evaluate alternative solutions and make recommendations.

Industry experience:

Airlines (American Airlines, Trans World, Sabre, SABRE, Intercontinental Hotels Group),

Telecommunication (AT&T, Sprint, South Central Bell, Lucent, Verizon),

Hospital and Healthcare (Parkland Memorial Hospital, West Bridge Corp, JCPenney Insurance, Caremark Rx, UHG, Express Scripts, IMS),

Insurance (West Bridge Insurance, JCPenney Insurance, UHGI),

Government (Tarrant County,Dallas County, AAFES),

Goverment Defense – Federal Government (Lockheed Martin Information System, Northrop Grumman)

Finance (Computer Language Research, Nations Bank, AmeriCredit, Fidelity Investment),

Retail (JCPenney, Frito Lay/Pepsi, Wal-Mart, COSTCO),

Education (Pearson Education)

Mainframe systems knowledge in Vantage-One, DSS, or RPS and Insurance downstream systems

Experience in leading the development, FTP, Quality assurance and deployment of mid-level business process support as well as full lifecycle projects.

Technical Skills

Programming Languages: COBOL, COBOL II, COBOL 370, COBOL 60, COBOL VSE,

OSCOBOL, COBOL 85, Tandem COBOL, VAX COBOL, Micro Focus COBOL, PL/1, TPF, ALC, Assembler, Natural, SAS, Visual Basic, PL/SQL, C++, C/370, RPG IV.

Testing Tools: Automated testing tools, BPT, QTP, QTP 9.5, Win Runner, Defect Tracking Tool, Test Director, Mercury Test Director, Performance Testing, Use Case, UNIT Testing, System Integrated Test, User Acceptance Test, Regression Test and Customer Test. Extensive experience developing Test Plan, Test Script and Test Cases, OATS and OTS Reporting.

Databases: DB2, CICS, IMS DB/DC, IDMS, ADABASE, VSAM, IDMS, Amigo DB, Oracle 9i.

Utilities: JCL, Easytrieve, Dyl280, SAS, TSO/ISPF, Panvalet, ChangeMan, Control-M, Endeavor, SYNON, CMS, BTS, Xpediter, Via Soft, Syncsort, NDM, FTP, MQ-SERIES, REXX.

Other Technology: FTP, Expediter, Inertest, QMF, Spufi, SQL, Windows XP, Automated testing tools, Quality center, Rally, QTP, Test Director, Mercury Tools, IBM iSeries for DB2, Citrix, EPR, Web logic, HTML, XML, Fat Wire, Black Box, White Box, Portal intranet Oracle BRM, ETL Process, Ab Initio.

PC Software: dBase, MS Word, MS Excel, MS Access, MS PowerPoint, MS Office.

Operating Systems: UNIX, OS/MVS, MVS/XA, IBM Rational Developer for System z

Hardware: IBM 309X, IBM 38XX, IBM 43XX, AS400, IBM PC, IBM Z/OS, OS/390

Education and Professional Development

A.S. in Computer Science, Maplewood Community College, Kansas City, MO.

B.S. in Physics and Math, Gujarat University, Ahmedabad, Gujarat State, India

Technical Training: Visual Basic, Borland C+, C++, Microsoft Office (97, 2000), Access Database, and UNIX

CBT Training: Java 2, HTML, Oracle 9i (Design, Create, Develop), PL/SQL script writing testing, MQ Series, and ABAP for SAP

Professional Experience

Tarrant County, Fort Worth TX Jul. 2016 - Dec 2018.

Senior QA / BA Analyst

Project: Criminal and Justice system.

Responsibilities:

Preparing high level of comprehensive businesses document.

Preparing technical documents for interfacing process.

Prepare Test Plan document Prepare Test Cases Write Automated test scripts for software in Tarrant County environment.

Organize and prepare Requirements Tractability Matrix to map test steps to requirements and conditions of acceptance (CoA) Coordinate testing efforts; coordinate testing execution Monitor and control testing process.

Environment: Mainframe IBM, DW, PL/SQL, Rally, Waterfall, Agile, HP Quality Center, Load Runner, Share point

AT&T, Remote(Atlanta) Apr. 2015 - Dec 2015

Senior Analyst – Scrum Master(Lead)

Project: Billing and Accounting.

Project:

Preparing and reviewing POD/user stories/Req/Scrum Master:

Creating and reviewing User Stories & loading into RALLY.

Environment: Mainframe, TSO/ISPF, JCL, IBM Utilities, FTP UNIX, UNIX COBOL, IMS, CICS, VSAM, FTP, SAS, ALC, FTP, PL / SQL, MQ-SERIES, Rally.

Hanes Brand Inc. Winston-Salem, NC Dec.2014 - Mar. 2015

Mainframe Developer and Senior analyst

Project: AS400. Legacy System & MF resource to support the DTC WM project.

Project:

Working with middle ware team for MQ Services and the enterprise over SOA framework.

Maintaining existing object consistency documents for product cycle, including test design.

Maintaining existing object consistency documents for product cycle, including test design.

Building Test Suites on HP-ALM for multiple phases, validating and testing regressions & E2E at enterprise level.

Environment: AS400, Mainframe, Assembler, COBOL II, DB2, Oracle, SQL, SOA, SOAP, SQL, WM.

COSTCO Issaquah, WA. Aug. 2013 - Dec2014

Business and Technical Interface Analyst.

Project: AS400. Legacy System & SAP Integration for COSTCO Wholesale Club.

Preparing requirement for the test scenarios as defined at various layers on DB2, SQL & Oracle.

Working with middle ware team for MQ Services and the enterprise over SOA framework.

Maintaining existing object consistency documents for product cycle, including test design.

Building Test Suites on HP-ALM for multiple phases,

validating and testing regressions & E2E at enterprise level.

Studing Legacy system flow for integration and interfacing process to and from SAP.

Preparing technical documents for interfacing process.

Maintain business relationship with other application area, such as, SAP-FICO/MM/HCM, HFM, CRM, ERP, KRONOS, Preparing documents, such as Testing strategies, Testing scenarios, and / or Test Plans for each objects.

Environment: AS400, Mainframe, Assembler, COBOL II,

SAP/ERP/CRM- FICO, HCM, HFM, MM, KRONOS, DB2, Oracle, SQL, SOA, SOAP, SQL, People Soft, Integrations.

Verizon Atlanta, GA. Jan. 2013 - Aug. 2013

System and Business Analyst.

Project: Business and Technical Documents.

Creating Business document for Legacy System for renwal.

Studing system flow and preparing technical document for current legacy process.

Studing and reviwing codes of rhe current object for Technical document.

Preparing chart for current system and project managment.

Object codes are in Assembler and Cobol combine.

Environment: Mainframe, COBOL II, ExsSream, ALC, SAS, IMS DB/DC, DB2, VSAM, TSO/ISPF, Via Soft, JCL, File Aid (Batch, Online), IBM Utilities, Syncsort, Easytrieve, FTP, PL / SQL, MQ-SERIES

Fidelity Investment (Verritude) Westlake, TX. January 2012 – December 2012

System and Performance Analyst

Project: Statement and Year End Process

Monitoring monthly statement process, preparing performance report

Preparing Year End Statement report and modification

Projects including; EAI, AI, TAX form etc.

Preparing unit, regression, and UAT test process for QA Team

Environment: Mainframe, COBOL II, ExsSream, CSF, ALC, SAS, IMS DB/DC, DB2, VSAM, TSO/ISPF, Via Soft, JCL, File Aid (Batch, Online), IBM Utilities, Syncsort, Easytrieve, FTP, PL / SQL, MQ-SERIES, SunGard

Express Scripts, Inc. Bloomington, MN November 2011 - January 2012

Senior System Analyst - Test Lead

Project: Medicare - D Explanation of Benefits, Form Admin

Preparing high level of comprehensive businesses need for EOB and Form Admin

Preparing preliminary test plan and test scenarios

Maintain project management plan

Analyzing and creating impact analysis for current process

Analyzing batch job streamline and its dependency

Leading as well as working with offshore and onsite team

Preparing assumption and dependencies document

Environment: Mainframe, COBOL II, ALC, SAS, IMS DB/DC, DB2, VSAM, TSO/ISPF, Via Soft, JCL, File Aid (Batch, Online), IBM Utilities, Syncsort, Easytrieve, FTP, PL / SQL, MQ-SERIES

IMS Health Collegeville, PA September 2011 - November 2011

Senior System Analyst –Test Coordinator - Team Lead

Project: Medicare Part –D Business Unit Legacy

Analyzing Part – D for Medicare 2011 and 2012

Preparing project documents for 2012 Pard – D

Preparing analysis document Project Plan, Test Plan and Requirment Matrix

Analyzing and creating impact analysis for current process

Analyzing Batch Job streamline and its dependency

Leading and Working with offshore and onsite team

Environment: Mainframe, COBOL II, ALC, SAS, IMS DB/DC, DB2, VSAM, TSO/ISPF, Via Soft, JCL, File Aid (Batch, Online), IBM Utilities, Syncsort, Easytrieve, FTP, PL / SQL, MQ-SERIES.

IHG (Intercontinental Hotels Group) Atlanta, GA April 2011 - August 2011

Senior Analyst – Team Lead

Project: System Integration Documents

Analyzing and supporting Hotel Reservation system and creating and preparing document

Working on UNIX system with VI editor and korn shell script

Analyzing assembler and C++ source code for future system integration

Analyzing and creating impact analysis for current process

Analyzing batch job streamline and its dependency

Leading and working with offshore and onsite team

Environment: Mainframe, COBOL II, ALC, SAS, IMS DB/DC, DB2, VSAM, TSO/ISPF, Via Soft, JCL,

File Aid (Batch, Online), IBM Utilities, Syncsort, Easytrieve, FTP, PL / SQL, MQ-SERIES.

AT&T Richardson, TX December 2010 - March 2011

Senior Analyst

Project: Billing and Accounting

Supporting billing system, creating and preparing related document for Data Validation

Working on UNIX system with VI editor and korn shell script

Analyzing and creating impact analysis for current process

Analyzing batch job streamline and its dependency

Working with offshore team

Data Validation for accounting and billing system

Working ERP on Z9/Mainframe Process large amount of data to support support customer relationship management systems and resource planning.

Environment: Mainframe, TSO/ISPF, JCL, IBM Utilities, FTP UNIX, UNIX COBOL, IMS, CICS, VSAM, FTP, SAS, ALC, ERP.

Wal-Mart Inc. Bentonville, AR July 2010 – December 2010

Senior Analyst – Project Lead

Project: HRIS System - Mainframe

Developing system test plan, performance test plan, test approach document, UAT test plan for user

Preparing documentation for UAT and performance test scenario and test procedure

Managing offshore team

Data Migration from Legacy system to new HRIS-GLMS system

Supporting existing system and working with developers for COBOL, COBOL II and DB2 application

Learning system added to the HRIS. For Wal-Mart Corporation, approximately 1.3 million employees will be affected.

Working with technical group

Doing business consulting, business process design, and systems integration for HRIS

Helping business group to get this system working to their expectations

Support testing from unit testing to system testing

Managing and reviewing mainframe applications for HRIS developing offshore (COBOL, IMS, CICS, DB2)

Environment: Mainframe, TSO/ISPF, Via Soft, JCL, File Aid (Batch, offline/ Online), IBM Utilities, FTP UNIX, Java, Oracle, PL/SQL, Windows XP, Automated and Manual testing tools, Use Case, Quality Center, Rally, QTP, Test Director, Mercury Tools, IBM iSeries for DB2, Citrix, Web logic, HTML, XML, Fat Wire, Black Box, White Box, AS400, COBOL, SAS, ALC, RPG – IV, ALC, CICS, VSAM and SAS, synonym, IBM R D for System z

United Health Group Frisco, TX May 2010 – July 2010

Senior Analyst – Project Lead

Project: United Health - Boeing project

Prepared development of system test plan, performance test plan, test approach document, and UAT test plan for user

Providing assistance to QA and BA group

Prepared documents for test scenario and test procedure

Managing and reviewing mainframe applications for Boeing project developed by offshore Team (COBOL, CICS, DB2)

Analyzing and validating data loaded to the database (CICS and DB2)

Supporting and managing script for Quality Center

Environment: QTP, Test Director 8.0, Quality Center, TOAD, Oracle DB2, SQL, UNIX, JAVA, PL/SQL, Windows XP, Automated and Manual testing tools, IBM iSeries for DB2, Citrix, Web logic, IBM Z/OS AS400, COBOL, RPG – IV, CICS, SAS, SYNON

FedEx Pittsburgh, PA March 2010 – May 2010

Senior Analyst – Project Lead

Project: Ground and Redirect process system

Preparing document for project analysis, project plan, functional design document, testing approach document, UAT test plan and E2E test plan documentation. Creating and modifying test plans, test cases, and documenting them along with the test results for unit test, regression test and E2E test.

Work closely with the other members of the Development Team and Marketing to review the designs of systems, implement test plans, and test the quality of software products

Work closely with the Development Team to insure the effectiveness and quality of the components and systems developed

Developing and modifying existing COBOL and RPG programs on AS400 system as required

Environment: Mainframe, TSO/ISPF, Via Soft, JCL, File Aid (Batch, offline/ Online), IBM Utilities, FTP UNIX, Java, Oracle, PL/SQL, Windows XP, Automated and Manual testing tools, Use Case, Quality Center, Rally, QTP, Test Director, Mercury Tools, IBM iSeries for DB2, Citrix, Web logic, HTML, XML, Fat Wire, Black Box, White Box IBM Z/OS.

Pearson Education Iowa City, IA February 2008 – December 2009

Senior Analyst - Project Lead

Project: Building Team for production Validation Process

Project analysis, project plan, functional design document, testing approach document, UAT test plan and E2E test plan documentation. Creating and modifying test plans, test cases, and documenting them along with the test results for unit test, regression test, E2E test and web testing.

Develop and manage accurate project timelines and project plans

Data Migration from Legacy system to new Validation process

Managing onsite and offshore team

Developing and modifying existing COBOL and RPG programs on AS400 system as required

Involved in configuration management, BPT, UAT, performance testing, and regression testing, integration testing, and system testing. Portal intranet Oracle BRM, ETL Process, OATS and OTS Reporting.

Environment: Mainframe, TSO/ISPF, Via Soft, JCL, File Aid (Batch, offline/ Online), IBM Utilities, FTP UNIX, Java, Oracle, PL/SQL, Windows XP, Automated and Manual testing tools, Use Case, Quality center, Rally, QTP, Test Director, Mercury Tools, IBM iSeries for DB2, Citrix, Web logic, HTML, XML, Fat Wire, Black Box, White Box, AS400, COBOL, SAS, ALC, RPG – IV, DB2, CICS, VSAM and SAS, synonym, IBM R D for System z

AmeriCredit Arlington, TX August 2007 – January 2008

Senior Analyst - Project Lead

Project: Data Validation for Long Beach Acceptance Corp. with AmeriCredit

Project analysis, project plan, functional design document, testing approach document, UAT test plan and E2E test plan documentation. Creating and modifying test plans, test cases, and documenting them along with the test results for unit test, regression test, E2E test and web testing.

Data Migration from Legacy system to current AmeriCredit financial system

Developing and modifying existing COBOL and RPG as well as SAS programs on AS400 system as required

Develop quick COBOL program for retest of functional and business requirements

Environment: AS400, Mainframe, TSO/ISPF, Via Soft, JCL, File Aid (Batch, offline/ Online), IBM Utilities, COBOL, SAS, RPG – IV, SYNON, DB2, CICS, Natural, VSAM, FTP, PL/SQL, Windows XP, Automated and Manual testing, Performance testing, Use Case, QTP, Test Director, Mercury Tools, F. R. O. G. IBM iSeries for DB2, Citrix, IBM R D for System z

Caremark Rx Richardson, TX October 2006 – August 2007

Senior Programmer and System Analyst - Team Lead

Developing and modifying existing RPG programs on AS400 system as required

Involve in general test functions and test cases as per requirements

Data Migration from Legacy system to new CVS system

Preparing functional requirement to convert SAS programs into COBOL

Develop some quick programs in COBOL and SAS for extraction, reports and statistical analysis

Environment: Mainframe, TSO/ISPF, Via Soft, JCL, File Aid (Batch, offline/ Online), IBM Utilities, AS400, COBOL, ALC, SAS, RPG – IV, SYNON, DB2, CICS, Natural, VSAM, FTP, PL/SQL, Windows XP, Automated and Manual testing, Performance testing, QTP, Test Director, Mercury Tools, IBM Z/OS

AAFES Dallas, TX Apr. 2006 – October 2006

Senior Programmer and System Analyst

Customer interface for the project

Using SAS for data extraction, reports and statistical analysis

Develop quick COBOL programs for retest functional and business requirement

Involved in production support

Environment: COBOL II, ALC, SAS, IMS DB/DC, DB2, VSAM, Natural, TSO/ISPF, FTP, ViaSoft, JCL, File Aid (Batch, Online), IBM Utilities, Syncsort, Easytrieve.

HRS Enterprise October 2004 – Apr. 2006

Business Consultant / Analyst

Financial Consultant to small business

Lockheed Martin Information System Oklahoma, OK October 2001 – October 2004

Senior Programmer and System Analyst - Team Lead

Conversion project from Legacy system to Data Warehouse (IMS to Oracle)

Develop any documentation according to prescribed delivery process necessary to clearly communicate project requirements and parameters

Developed new design documents for EDW and Comprehensive Engine Management system

Maintenance and production support for Comprehensive Engine Management system

Develop quick programs using COBOL for reports

Using SAS for data extraction, reports and statistical analysis

Extract Reporting Process (ERP) for new system (DW and Oracle)

Environment: COBOL II, ALC, SAS, REXX, IMS DB/DC, DB2, IDMS,VSAM, TSO/ISPF, Via Soft, JCL, File Aid (Batch, Online), IBM Utilities, Syncsort, Easytrieve, ERP, FTP, ORACLE, Ab initio PL / SQL, MQ-SERIES, HTML

Saber Inc. Fort worth, TX January 2001 – July 2001

Senior System Analyst

Maintenance of Pricing and Fares System

Production support of Pricing and Fares System

Developed Adhoc Report for Online User called – ‘Threshold Report'

New major project, Historical Fare system, developed analytical design and detail design documents

Developed coding in C++, C/370

Environments: ALC, Assembler, MVS-C, IMS DB/DC, IDMS DB2, VSAM, Via soft, FTP, TSO/ISPF, JCL, File Aid (Batch, Online) IBM Utilities, Syncsort, SAS, TPF

Rest of the IT Professional History December 1978 - December 2001

Performed duties as a Senior System Analyst, Senior Programmer Analyst, Senior QA Analyst, Senior Business Analyst, QA Analyst for Y2K project, Q & E Tester and Project Lead responsibility.

Developed and supported and all kinds of testing including; Airline related applications, Billing, Patient Accounting and Management system, Credit Card System, Banking and Finance, Credit Card system, GSA, Human Resource, Payroll systems, Account receivable, General Ledger, Merchandise Ledger, Account payable, Retail and Catalog System, Justice and Criminal System, Insurance Industries, Health Care, and Air Force – Department of Defense, USA - Comprehensive Engine Maintenance System experience.

Contact this candidate