Mainframe Application Development
Resume:
RESUME
Chari G L N
Mobile No.: +91-998*******
********@*****.***
https://in.linkedin.com/in/chari-g-l-n-a3821816
PROFILE
1.Possessing 12 years 5 months of work experience in Mainframes under Banking, Financial and healthcare insurance domains. Hands-on experience in Software development life cycle of a project
2.Expertise in areas such as Application design and Development, experience in COBOL, PL/1 programming, Easytrieve, Embedded SQL programming, CICS, Websphere MQ Application programming for Z/OS, DB2 Application performance Tuning and SWIFT
3.Self-motivated, good learner and quick to adapt to any changes has helped in achieving satisfactory results
4.Ability to communicate with clients effectively, willing to accept responsibility and has good analytical and logical skills
5.Worked on projects using agile methodologies and worked in all levels starting from software engineer trainee to technical team leader. Possessing both regular employee and consultant experience.
6.Performed various job responsibilities which include Understanding Functional & Non-Functional requirements, preparing Detail Designs, Coding, testing and reviewing code, Test Plans, Test results, resolving problem tickets, Change Management and Account level initiatives
PROFESSIONAL EXPERIENCE:
Company
Joining Date
Relieving Date
Designation
DESTAR INC
19-Sep-2016
Till Now
Senior Consultant
MONA COMPUTER SYSTEMS(S) PTE. LTD.
14-Apr-2014
07-Apr-2016
System Analyst
IBM INDIA PVT. LTD.
05-May-2010
10-Apr-2014
Senior System Engineer
ITC INFOTECH INDIA LTD.
20-Aug-2008
30-Apr-2010
Associate IT Consultant
NOUS INFOSYSTEMS PVT. LTD.
21-Feb-2005
14-Aug-2008
Senior Software Engineer
EDUCATION:
Sl. No
Class
University / Board
Year –Pass
1.
B.E
Biju Patnaik University of Technology
2004
2.
XIITH
Board of Intermediate Education
1999
3.
XTH
Board of Secondary Education
1997
CERTIFICATIONS:
Sl. No.
Certifications/Awards
Year Attended
1
IBM 000-543 DB2 9.7 Application Developer
2012
2
Global English Edge Business English Certification
2012
3
IBM INDIA Spark Award
2013
TRAININGS at IBM:
Sl. No.
Trainings Attended
Year Attended
1
DB2 UDB Application Programming Workshop - CF820
2012
2
DB2 UDB for z/OS V8 Database Administration Workshop Part-1
2011
3
DB2 UDB for z/OS Application Performance and Tuning - CF961
2011
TECHNICAL SKILLS: (Scale of 1 to 5, 1 – Minimum & 5 – Maximum)
Skill Set
Duration (Years)
Rating
COBOL
12
4.0
JCL
12
3.0
DB2
12
4.0
VSAM
5
3.0
CICS
7
3.0
IBM WEBSPHERE MQSERIES
7
3.0
PL/1
1.6
3.0
EASYTRIEVE
2
3.0
SWIFT
3.6
3.0
CHANGEMAN
3.6
4.0
ENDEVOR
10
4.0
LIBRARIAN
1.6
3.0
MQCC
1
3.0
MICROFOCUS EXPRESS
1.6
3.0
ACU-COBOL
1.6
3.0
INFOGIX ACR
1
3.0
IBM RATIONAL DEVELOPER for Z/OS
2
3.0
IBM DATA STUDIO for DB2
2
3.0
FILE-AID for DB2
5
4.0
FILE-AID
5
4.0
AQT
1
3.0
VISUAL EXPLAIN
1
3.0
DITTO
3.6
4.0
RATIONAL TEAM CONCERT
2
3.0
CA-INTERTEST
3.6
4.0
IBM DEBUGGING TOOL
10
4.0
HP QUALITY CENTRE
4
4.0
PEREGRINE SERVICE CENTRE
2
3.0
REMEDY
3
4.0
SERVICE NOW
1
4.0
Z/OS PERFORMANCE EXPERT
1
3.0
HTML,JAVA,NETSTYR
2
3.0
Z/OS,UNIX, WINDOWS 2000, WINDOWS XP
10
4.0
MS-OFFICE, IBM LOTUS PACKAGE
10
4.0
Projects:
I. Project Name: STOPLOSS Improvements
Environment: COBOL, DB2, JCL, VSAM & INFOGIX ACR
Duration: Sep ‘2016 – Till Now
Team Size: 11 members
Domain: Health care Services Company (HCSC)
Description:
This project is to deal with improvements to STOPLOSS product of client. As part of these improvements we have introduced new ways of validating reimbursement claims, automation of contract creation and un-assigning of expired contracts.
As part of this project we have also corrected the credit/debit accumulation of STOPLOSS adjustments into monthly bill to customer. Monthly bill is being generated by ‘Billing and account receivable’s department for customers with STOPLOSS contracts. I have done complete analysis of the spillover adjustments and corrected it in batch cycle so that adjustments will be factored in the same month of the customer bill which helps customer for reconciling his accounts faster than ever.
Role & Responsibilities:
1.Requirement Analysis
2.Providing estimations
3.Impact Analysis
4.Preparing detail design
5.Coding & Unit Testing
6.System Integration Testing
7.Reviews
8.UAT support
9.Release Implementation
II. Project Name: Withdrawal & Nomination Systems
Environment: COBOL, EASYTRIEVE, DB2, CICS & JCL
Duration: Apr‘2014 – Apr’2016
Team Size: 11 members
Domain: Central Provident Fund
Description:
This project includes both development & enhancement tasks of Withdrawal and Nomination applications. Some of the development projects are Generic Mailer’s Exclusions and Centralization of customer account numbers throughout the CPF system.
Day to day activities include writing program specifications, coding, testing and change management for new projects and working on program change request.
Role & Responsibilities:
1.Technical Review Meetings
2.Preparing Program Specifications
3.Coding & Code Review
4.Unit Testing & Review
5.System Integration Testing
6.UAT support
III. Project Name: Premier Provider Tool Enhancements
Environment: COBOL, DB2, Websphere MQ for Z/OS, CICS
Duration: Jan ‘2013 – Mar ‘2014
Team Size: 4 members
Domain: Health care Services Company (HCSC)
Description:
This project is to deal Provider’s and pricing services application of the client. I deal with all new enhancements and defect fixes for provider application. Provider application of client deals with data of Illinois, Oklahoma, Texas and New Mexico. Our day to day activity is working on Enhancements and Defect fixes for the application. Upon accepting a defect I will analyze the programs and suggest client whether it is an Enhancement or regular maintenance work.
Role & Responsibilities:
10.Preparing Detail Designs
11.Coding & Code Review
12.Unit Testing & Review
13.System Integration Testing & Review
14.UAT support
15.Release Implementation
IV. Project Name: Account Level Problem Investigations (PBI)
Environment: COBOL, DB2, Websphere MQ for Z/OS, CICS
Duration: Jul ‘2012 – Dec ’2012
Team: Individual Contributor
Domain: Corporate Non-Life Insurance
Description:
Client Company assigns Problem investigations to team which are created in Remedy Tool. I will have to investigate on problems and fix them within stipulated period of time. Main focus of these investigations is to find out the issue and fix it from root. As per the process after finding out the root cause I have to prepare RCA documents, attend the RCA call to explain the problem and recommend solutions.
Latest problem investigations and recommended solutions have helped Client Company to rid of extra cost for CPU hours in lower development regions. Initiatives like installing automatic purge for long running CICS transactions and developing automatic bind and new copy jobs have been helpful to get rid any unforeseen looping issues.
Analysis of DB2 Accounting trace reports has helped to identify time taking SQL’s to be optimized by choosing better predicates and recommending better indexes.
Role & Responsibilities:
1.Problem Management in Remedy tool
2.Preparing Root Cause Analysis Documents
3.Attending RCA calls
4.Initiating and completing tasks and work towards closure of PBI
V. Project Name: D & B Database table Modifications and search Enhancements
Environment: COBOL, DB2, Websphere MQ for Z/OS, CICS
Duration: Jan ‘2012 – Jun ‘2012
Team Size: 4 members
Domain: Corporate Non-Life Insurance
Description:
This project is to deal with DB2 table modifications and search enhancements. It includes production DB2 table column & index modifications. As a result of the project, Client Company got rid of extra costs of paying third party vendor for each search which is being made for getting client information. Project includes both enhancements to existing on-line programs & batch process and new developments for online programs. Customer information is being used by several other interfacing applications, changes done as part of this project impacts several other applications. I have invented several new processes while executing and testing these changes done under project which addresses impacts to other applications and performance of application. Change management is done using Remedy tool and this change was almost planned for 19 hours in production during weekend.
Presently Client Company avoided most of its costs for getting (searching) client data from third party vendor and using its own services for getting current financial health of the particular customer based on which insurance will be awarded.
Role & Responsibilities:
1.Preparing Detail Designs
2.Coding & Code Review
3.Unit Testing & Review
4.System Integration Testing & Review
5.UAT support
6.Certification (Performance) Test Support
7.Release Implementation
VI. Project Name: Entity Typing & Suspect Duplicate Processing
Environment: COBOL, DB2, JCL
Duration: Jun ‘2011 – Dec ’2011
Team: 3 Members
Domain: Corporate Non-Life Insurance
Description:
This project is to deal with Data Consolidation of Client data. We are dealing with Client information which includes name & address of clients, submission & policy information and also client to client relations. I identified that data gaps present in the system are due to multiple reasons, almost 15% of data is duplicated and client records existed with incorrect entity typing. I have performed 3 phase implementation for achieving complete client information data consolidation.
1. Streamlining Client Data Creation: In our hybrid environment there are several applications which use client data for quoting and Policy issuance. There are several systems which create client data apart from Enterprise Client management application. Some services create client data and insert these records in Enterprise Client management system. Due to this there are duplicate data created and also entity typing is not proper. I have identified different entry points and tagged these records which need to be sent for entity typing and suspect duplicate processing.
2. Entity Typing of Client Data: Presently there are clients whose data is not correctly bifurcated. I have created extract jobs with all the client information and sent it to Quality stage for further processing. After getting the input from quality stage on bifurcation I will apply the changes to data in the host, along with entity bifurcation I will also have to change the format of Name stored in database according to entity.
3. Suspect Duplicate Processing: Several applications within the system are creating client information data and as there was no mechanism to check the duplicates almost 15% of client information data has duplicates. As part of Suspect Duplicate Processing I have created extracts with client information like Name, Address, Submissions, Policies, Client relations, Policy Effective dates etc. This data is sent to Quality Stage and probabilistic and deterministic matches are applied to cleanse the data. Once done these changes are applied on host database to get rid of duplicates.
Role & Responsibilities:
1.Requirement analysis
2.Preparing Detail Designs
3.Coding & Code Review
4.Unit Testing & System Testing
5.UAT support
6.Certification (Performance) Test Support
7.Release Implementation
VII. Project Name: New Development Track Setup
Environment: Endevor (version control tool), Websphere MQ for Z/OS, CICS, DB2
Duration: Mar ‘2011 – May ‘2011
Team Size: 3 members
Domain: Development track – Mainframe Infrastructure Setup
Description:
This project is to deal with setting up new track of Test, Acceptance and Certification environments for development activities which will be a replica of Production track. Activities include deciding processor groups and Types for programs in Endevor. Deciding Load libraries, DBRM libraries, copy libraries, bind libraries for the environments. Working with Plans, collections and local packages for DB2 and deciding on MQ’s for each of these regions.
This also includes working with setting up Endevor environment’s automatic bind in ‘EDVBIND’ table, working with ‘EDVCEMT’ table for supporting CICS regions, working with ‘EDVPARMS’ for changing compiler options.
Role & Responsibilities:
1.Change record planning & checkout using Remedy
2.Reviewing DB2 setup using DB2 Admin Tool
3.Reviewing Endevor setup
4.Checkout of Development track
VIII. Project Name: Data Interchange between Mainframe DB2 & Unix DB2 Servers - POC
Environment: COBOL, DB2, Websphere MQ for Z/OS, CICS
Duration: Jan ‘2011 – Feb ’2011
Team Size: 1
Domain: Corporate Non-Life Insurance
Description:
This project is to deal with data interchange between Mainframe based DB2 and AIX UNIX DB2 servers. Project also includes data conversion from ASCII to EBCIDIC when ever required when data is transferred from AIX UNIX DB2 to Mainframe. This is a Proof of Concept is for another large Enterprise Project.
Role & Responsibilities:
1.Requirement Analysis
2.Preparing Detail Designs
3.Coding
4.Unit Testing
5.System Integration Testing
IX. Project Name: Commercial Search Enhancements
Environment: COBOL, DB2, Websphere MQ for Z/OS, CICS & Java
Duration: May ‘2010 – Jan ‘2011
Team Size: 5 members
Domain: Corporate Non-Life Insurance
Description:
This project is to deal with commercial clients search enhancements. This is to Maximize Search match ratio in the clearance process. As part of the project I have improved and added new search functionalities for searching client database after a new submission has been created, New DB2 Tables have been created and performed Index Improvements for achieving faster Searches on huge tables with lot of data. Project includes both enhancements and new developments in Online and Batch processes.
Role & Responsibilities:
1.Requirement Analysis
2.Preparing Detail Designs
3.Coding
4.Unit Testing
5.System Integration Testing
6.UAT support
7.Certification (Performance) Test Support
8.Release Implementation
X. Project Name: Corporate E-banking – Cash Management
Environment: PL/I, DB2, MQSeries, Microfocus Express, HTML & NETSTYR
Duration: Aug ‘2008 – Apr ‘2010
Team Size: 7 members
Domain: Cash Management
Description:
This project is to deal with Cash Management of corporate E-banking which includes developments and enhancements tasks for 5 European countries. Project includes new developments and enhancements. Few enhancements in project include implementing Bulk postings and implementing new Advices. New developments include implementing E-invoices for corporate customers.
Implementing new procedures for tracing & logging errors and bug fixes related to Cash Management. Resolving MQ related tickets.
Role & Responsibilities:
1.Requirement Analysis
2.Preparing Technical Approach Documents and Construction Design
3.Preparing test Plans in Quality Centre
4.Coding
5.Testing
6.UAT support
7.Release Implementation
XI. Project: Communication Enquiry - II
Environment: VS COBOL II, JCL, DB2, CICS, MQSeries & Java
Duration: Jan ‘2008 – Jul ‘2008
Team Size: 5
Domain: Corporate Actions
Description:
This project is to deal with Corporate Actions department of the client. It deals with inbound and outbound communication from agents and clients. Project includes SWIFT messaging, and third party tools through which messages are sent and received from clients and agents. Scope of the project includes providing enhancements to existing programs, generation of Weekly and Monthly report and development of MQSeries read program
Project enables tracking facility for different types of Corporate Action SWIFT Messages like MT564, MT565, MT566, MT567, and MT568. All the above mentioned Corporate Action Messages will be tracked, counted and bifurcated
Role & Responsibilities:
1.Prepared Analysis documents for candidate programs
2.Coding
3.Reviewing the code
4.Unit-testing
5.QA testing and UAT support
XII. Project: Orbit
Environment: COBOL-85 and Open Sco Unix
Duration: Jun ‘2007 – Dec ‘2007
Team Size: 3
Domain: Brochure Distribution
Description:
Orbit application is a COBOL-based application, for various business activities concerned to Brochure distribution. The users are internal employees from various departments, External agents, external consumers, system administrators and auditors with various user levels and roles. This application allows creating products, definition setting for regular dispatch, versioning, complicated consolidation of products, product searching and many facilities
Role & Responsibilities:
1.Support Analyst
XIII. Project: Communication Enquiry - I
Environment: VS COBOL II, DB2 & CICS
Duration: Jan ‘2007 – May ‘2007
Team Size: 4
Domain: Corporate Actions
Description:
This project is to deal with Corporate Actions department of the client. Project includes SWIFT messaging, and third party tools through which messages are sent and received from clients and agents. Scope of the project includes providing enhancements to existing work ticket programs enabling PDF printing, changing printer locations, Bifurcating tickets, implementing enhanced tracking facilities
Role & Responsibilities:
1.Prepared Analysis documents for candidate programs
2.Coding
3.Unit-testing, system testing and UAT support
XIV. Project: Smf – Mutual Fund Audit Trail
Environment: VS COBOL II, DB2 & CICS
Duration: Feb ‘2006 – Nov ‘2006
Team Size: 6
Domain: Mutual Funds
Description:
This project was to provide a historical audit trail that detailed all setups, changes and deletions made to the Custody Securities Master File (CSMF). The scope of project included storing and displaying an audit trail of setups, column-level changes, and physical purges for a security that impacted five tables which is exclusively for Mutual fund individual accounts and Group Accounts. If a security gets purged, then the audit trail for the purged security will remain for a period of seven years after the purge date. The audit trail for an active security will not be purged. When a security was physically purged, the information about the security was stored on a set of eight new tables. The eight tables, referred to as deleted versions, will store a snapshot of the security that reflects the state of that security just before it was physically purged. They are structurally identical to active tables. If any changes are made to the active tables, they are also made to the deleted version of the tables.
Role & Responsibilities:
1.Coding
2.Unit testing
XV. Project: AOD – Insurance Management System
Environment : ACU-COBOL, Windows 2000
Duration: Feb ’2005 – Jan ‘2006
Team Size: 5
Description:
It is a conversion project from VAX/VMS COBOL to ACU COBOL, using the IDE ACU Bench. The project involves changing the CUI screens to GUI, while maintaining the business logic in COBOL. The old VAX COBOL code involving core business logic is integrated into new ACU COBOL code with minimal changes. The system handles entry, maintenance and deletion of Certificates, Billing, Termination and Premium Distribution. Different management reports viz. Commitment/ Certificate report, Delinquent/Payoff report, Premium Billing/Collected report, Amortization Schedule etc.
Role & Responsibilities:
1.Screen Designing, Coding and performing enhancements
2.Unit testing
3.UAT supporting
Personal Details:
Complete Name : Gudimella L N Charyulu
Father Name : Gudimella S R Acharyulu
Date of Birth : 03/07/1982
Marital Status : Married
Languages Known : English, Hindi and Telugu
Personal mail id : ********@*****.***
********@*****.***
Contact this candidate