Summary

I have been involved in design, coding, testing of application, and programming using

COBOL,PL/1, JCL, DB2, VSAM, CICS, Information expert,Fileaid, File Manager, DCLGEN, IMS DB/DC, Debugger/ COBOL, CICS, DB2, JCL,File Manager, Clear Quest, Req Pro, DB2 Command Center, DEBUGGER etc.

Information expert, server 2000 and TSO/ISPF

16+ Years of IT Experience as Project Lead, Team lead and Mainframe developer..

Extensive experience in designing and testing systems following the waterfall and agile software models.

Well versed in all the stages of the software development life cycle like Requirement Gathering, Architectural design, High level Technical design and coding, testing with the Mainframe applications.

Hands on experience in writing and analyzing various SQL like Oracle, DB2 for 8+ years.

Strong functional experience includes, Retail, Credit Cards and Banking/Financial domain

Extensive knowledge in COBOL,JCL,DB2, VSAM, Store Procedures & CICS and other Mainframe Utilities

Experience in handling on call application support for the production failures.

Knowledge with using version control tools namely Endevor, Changeman & GIT

Comfortable with technical and functional applications of RDBMS, Data mapping, Data management and Data transportation.

Analyze business requirements, preparing the flow chart, perform the gap analysis, and maintain the traceability matrix as per the project need.

Professional Experience

Around 17 years of professional experience in all the SDLC and AGILE process of mainframes

Working as a Senior Consultant for eligibility system in California Medicaid system(CAMMIS)

(Dec ’15 – till now)

Working as a Consultant in Washington state government

(Jan ’14 – Dec-15)

Working as a project Lead at American express

(Nov ’10 – Jan-14)

Worked as a Team lead at Computer Sciences Corporation

(Jun ’05 – NOV-10)

Worked with Data Software Research Pvt Ltd, Chennai as a Programmer

(May ’04 – May ’05)

Worked in bharti airtel as programmer from Jan-04 to May-04

Education

B.E Mechanical

Madras University, Chennai, India

Technical Skills

Software : COBOL, PL/1, JCL, CICS, DB2, Information Expert,

VSAM, SQL Server 2000

Operating System : MVS, WIN 95, 98, & 2000, MS-DOS

Tools & Utilities : FILE AID, TSO/ISPF, SPUFI, SDF, DCLGEN, QMF,

Change Man, XPEDITOR, CA-7, Easytrive, Endevor,

File Manager, File aid, Debugger, SQLCI, ENSDB, IMS DB/DC

Work Experience

Project 1:

Duration

:

Dec ‘2015 to till now

Project

:

CAMMIS

Client

:

CALIFORNIA MEDICAID SYSTEM(CAMMIS)

Role

:

SENIOR Consultant

Client Description

:

CAMMIS Projects motive was to make system HIPAA compliant and make necessary changes for the claims related work, add new changes to keep it on par with national HIPAA code and Eligibility validation in both Online/Batch

Software

:

COBOL, JCL, DB2,VSAM, IMS DB, Debugger, SAS,Clear Quest,MCWEB

Responsibilities

:

Held the following responsibilities:

Applies consulting, troubleshooting, and problem solving

skills to resolve complex problems and issues with mainframe

Security.

Completely responsible for Eligibility modules services such as Full scope check, Foster care check, Claims check, Disability check and aid codes validation in both online and batch

Document Business Rules, & requirement; Review rules & gather requirements with customers

Mentor junior developers on the best practices for developing the CUT phase.

Ensure all metrics data is collected for all critical processes during the Design and the Development Phases of the SDLC lifecycle

Creating design for new development and coding the programs

Working on the change request, problem request and call records,Parallel runs

Directly responsible for the completion of the implementation, data conversion, test results, and cleanup of test environment after implementation. Creates and executes unit and system test plans to verify solutions meet specifications. Undertakes Quality Assurance Review for Unit Test, SIT, UAT and Regress Test results. Verifies program functionality by comparing actual to expected results.

Maintenance and Development changes in Eligibility system and MCWEB

Experienced in coding and querying databases

Working on the SEV2/SEV3 support tickets

Reviewing the task related to Eligibility system towards team and involving in all the eligibility-based requirement

Project 2:

Duration

:

Jan ‘2014 to DEC 2015’

Project

:

ACES

Client

:

Washington state government(DSHS)

Role

:

Consultant

Client Description

:

The Health Care Authority (HCA) provides a wide range of medical services based upon a client's circumstances and needs. Work in this area include ongoing development of health care quality metrics, along with studies of medical risk, disease progression, and health care costs and other outcomes.

DSHS services includes the following

Homelessness and Housing –

TANF systems (maintenance and Development)

Food benefits (maintenance and Development)

Cash benefits (maintenance and Development)

Medical benefits (maintenance and Development)

Eserv, Aces Online, Aces 3g and ACES Legacy systems

Long-term Care and Developmental Disabilities Safe Babies, Safe

Moms Evaluation.

Temporary Assist Needy Families (TANF). This project is developing

the capability for DSHS to report data to the Federal government (The

Administration for Families and Children

Software

:

COBOL, JCL, DB2,VSAM, Natural/ADABAS, IMS DB/DC, debugger, Clear Quest

Responsibilities

:

Held the following responsibilities:

Creating design for new requirement and coding the programs

Working on the change request, problem request and call records

Production support on a weekly basis

Performing Integration/Parallel run

Design and analysis of requirements for Welfare and ACES eligibility system.

Coded new DB2 stored procedures for Childcare and foster care.

Defined the testing strategy and prepared test cases and scripts for various phases of Unit and System Testing.

Coded new COBOL copybooks / SPUFI files. Debugged the deliverable using IBM Debugger

Coded new SQL, DB2/COBOL programs to load and unload data and create reports.

Created GDG bases for QA regions to unload DB2 tables.

Reviewed requirements created test plans, setup test plans and validated plans.

Used SQL, Relational Databases, DB/2, MVS JCL, SDLC, Debugging Tools, Web Service, Web Methods, Performance Tuning, TSO, SPUFI and QMF

DB2 performance tuning, running Explains and Catalog Management.

Project 3:

Duration

:

Nov 2010 to Jan 2014

Project

:

SMCTCC, FRAUD AND PRIVACY

Client

:

AMEX

Role

:

Project Lead

Client Description

:

AMEX is Founded in 1850, the U.S. based American Express is one of the 30 components of the Dow Jones Industrial Average. According the Business Week and Interbank, American Express is the 15th most valuable brand on the globe, estimating at $21.94 billion. In the total volume of credit card transactions, Amex cards account for 24% of them. The company was founded by the owners of Wells & Company (Henry Wells), Livingston, Fargo & Company (William Fargo), and John Warren Butterfield (Wells, Butterfield & Company) to be an express mail business.

Software

:

COBOL, Tandem, JCL, DB2,VSAM,QC (10.0), IMS DB/DC,ETL tools

Responsibilities

:

Held the following responsibilities:

Analyzed the existing system and determined the impacted programs for the new requirement

Integrating multiple interfaces using cobol,JCL/IMS/DB2/VSAM

Enhancements of the impacted programs according to the new requirements

Impact analysis and prepared documents as per the guidelines provided

Created Adhoc report for the users

Working on the change request

On call support

Preparing an effectiveness and compliance graphs to review with the Project manager

Project 4:

Duration

:

AUG ‘2008 to NOV ‘2010’

Project

:

RAS

Client

:

TDC (Denmark Telecom)

Role

:

Team Lead

Client Description

:

RAS is the billing system within TDC, which is mainly used to bill the landline. RAS is an abbreviation in Danish for Regnings Administration System which means Billing Administration System. RAS is used to bill Private telephone customers, Business Customers and Cable Television. RAS contains different modules like Interface with Columbus, Interface with TOT, Billing and Payment control.

Software

:

COBOL, PL/1, SQL server, Tandem, JCL, DB2, IMS DB

Responsibilities

:

Held the following responsibilities:

Actively involved in development and unit testing in all the modules in RAS

Billing Module Development

Created Adhoc report for the users

Impact analysis

Fixing the issues

Modified the SQL query to fetch entitlement reason code from CME entitlement reason code table.

Prepared test cases and test scripts for various phases of Unit and System Testing.

Analyzed the Defect Reports and Test Cases.

Managed problem tickets (MPRs) and implementing the changes.

Created technical designs based on client's business requirement.

Reviewed requirements created test plans, setup test plans and validated plans.

Utilized SQL, DB/2, MVS JCL, Debugging Tools, Performance Tuning, TSO, SPUFI, QMF, Relational Databases, SDLC

Project 5:

Duration

:

JUN ‘2007 to 2008

Project

:

Electronics & Safety.

Client

:

Delphi, U.S.A

Role

:

Sr software engineer

Client Description

:

Delphi is a world leader in mobile electronics and transportation components and systems technology. Multi-national Delphi conducts its business operations through various subsidiaries and has headquarters in Troy, Mich., USA. Delphi has approximately 185,000 employees and operates 164 wholly owned manufacturing sites, 41 joint ventures, 53 customer centers and sales offices and 33 technical centers in 38 countries.

Project Description

:

Delphi E&S personnel system (CPS), Hourly payroll system (CHP) and Account receivable (CAR).

CPS

The Personnel System (CPS) is used to manage personnel issues for the Delphi-E&S workforce. This system handles: promotions, job recalls, interdepartmental transfers, etc. The online system is primarily used to support the Kokomo UAW agreement.

CHP

The local Hourly Payroll system (CHP) is used by Delphi-E&S Hourly Payroll department, hourly plant floor clerks, and the Capital Management department and uses Cobol II, JCL, ISPF panels and data files to generate and view weekly/monthly labor distribution reports used to track labor spending, receives EDSELIT files and prints GM Labor Distribution Process (GMLDP) reports.

Software

:

COBOL, DB2, JCL, CICS, FILE AID, TSO/ISPF, SPUFI, DCLGEN, CA-7, Easytrive, Endeavor, IMS DB, File manager. Tandem MF

Responsibilities

:

Held the following responsibilities:

Creating Reports

Scheduling jobs in CA-7

Created Adhoc report for the users

Impact analysis and prepared documents as per the guidelines provided

Fixing the issues.

Created new copybooks, jobs and procedures to execute batch modules for debit card processing for Odysseus releases.

Coded new modules to create output files to send data to the customer master.

Reviewed requirements created test plans, setup test plans and validated plans.

Created technical designs based on client's business requirement.

Extensively worked with DB/2, MVS JCL, TSO, SPUFI, QMF, SQL, Relational Databases, SDLC, Debugging Tools and Performance Tuning

Project 6:

Duration

:

JUN ‘2005 to June 2007

Project

:

KERMIT

Client

:

Kroger, U.S.A

Role

:

Team Member

Project Description

:

Kroger (www.kroger.com) has retained CSC to maintain its Accounts Payable and HRS systems for the Fred Meyer division. The KERMIT (Kroger Employee Resource Management and information Tracking) application handles payroll processing and employee record-keeping for all Dillon, King Snoopers, and Fry’s. The base code is third party software (GEAC E series Human resources/Payroll) that has been modified to meet Company Needs.

Operating System : OS/390

:

OS/390

Software

:

COBOL,PL/1, DB2, JCL, CICS, FILE AID, TSO/ISPF, SPUFI, DCLGEN, Change man,IMSDB,SQL

Responsibilities

:

Held the following responsibilities:

Analyzed the existing system and determined the impacted programs for the new requirement

Enhancements of the impacted programs according to the new requirements

Writing new programs as per client’s requests

Impact analysis and prepared documents as per the guidelines provided

Created Adhoc report for the users

Done Production support around the clock

Project 7:

Organization

:

Data Software Research Pvt Ltd

Duration

:

APR’2004 to APR’2005

Project

:

Time Management System

Client

:

RS SOFTWARE

Role

:

Team Member

Project Description

:

The Time Management System Using (Access Card) is used to maintain attendance, working hour of each employee in a concern. Whenever the employee gets in or goes out he must swipe the access card on the card reader. The card reader reads the details in the card and enters corresponding time-in and time-out values in data base. These values are later used to calculate the working hour of the employee and his salary

Operating System : OS/390

:

MVS

Software

:

COBOL, DB2, JCL, SQL, ISPF, VSAM and XPEDITOR.

Responsibilities

:

Held the following responsibilities:

● Requirement analysis

● Coding of new Programs to enhance the system.

● Preparing unit test plans& and unit testing.

.

Personal Profile

Date of Birth

: 15 Feb 1980

Age

: 40 Years

Gender

: Male

Contact this candidate