Mainframe Designer/Developer
Resume:
SUMMARY
IBM Mainframe Application developer, with 9+ years of hands on experience in various domain Retail and Utility applications
Extensive experience in the IT industry, involved with full project life cycle, complete Software Development Life Cycle (SDLC)
Proficient knowledge in developing programs which deal with MQ’s, DB2 Stored Procedures and online CICS screens
Experience working on the project built using the Waterfall and Agile Methodology
Received best performer award from Safeway/Walmart Client
Received best performer award from employer UST-Global
SKILLS SUMMARY
Operating System : Z O/S, MVS, DOS, WINDOWS
Languages : VS COBOL-II, COBOL-85, JCL, DB2 stored Procedure, Easytrieve Plus, PL/I
Databases : VSAM, DB2, IMS DB, Teradata SQL
OLTP : CICS
Middleware Interface : MQ series, CICS REST Web service
Web Applications/Servers : MQ, Connect Enterprise Mailbox & PM4DATA
Tools : Changeman ZMF, TELON, NVDM, INFOPAC (View
Direct), MQ Explorer, MQ controller, INTERTEST,
COBTEST, SPUFI, INSYNC, PM4DATA, DUMPMASTER,
CONNECT DIRECT, FILE-AID DB2, DTCN, Librarian tool,
FILE-AID, ENDEVOR, ABENDVWR, Expeditor, Install-1, PLA&QMF
EMPLOYER DETAILS
UST Global INC
Duration -
Sep 2005 to till date – Employee (119 months)
CLIENT DETAILS
#
Name
Working Location
Duration – Length
Domain
1
Sempra Energy
San Diego, CA
Mar 2012 to till date – 40 Months
Utilities (Gas & Electric)
2
Walmart
Bentonville, AR
July 2011 to Mar 2012 – 8 months
Retail
3
Safeway
Trivandrum, KL India
Sep 2005 to June 2011 – 70 months
Retail
EXPERIENCE HIGHLIGHTS
DURATION: Mar 2012 to till date
Software Used: z/OS 1.9, VS COBOL II, DB2, VSAM, RSAM, JCL, HTML, XML, FILE-AID, FILE-AID DB2, CUSTOMER/1, INSTALL/1, EASYTRIEVE, XPEDITOR, ENDEVOR, RDZ, WEB LOGICS, QMF, SYNC SORT, HP QUALITY CENTER
Roles: Designer & Developer
Project 11 – Smart Meter Billing systems
Description:
Electric and Gas Meters in Southern California are being replaced by an automated network of “Smart” electronic meters equipped with communication equipment that allow a two way interaction between the utility and the meters at the customer’s premise. This technology can read both gas and electric meters automatically at regular intervals. It also allows the utility company to communicate to the meter and send customers information about energy prices and the community's overall energy use situation.
The benefits of the project include:
Demand/response control that helps the utility company to reduce peak energy usage.
Improved customer service.
Improved management and faster resolution of Electric or Gas outages.
Reduced need to access customer property.
Availability of real time energy usage information that would help customers have better control over their usage
The project involves major enhancements and modifications to the existing IT systems to be compatible with the Smart meters. All installed Smart meters communicate with a centralized Collection Engine which in turn relays the meter data to a Meter Data Management System (MDMS). This system filters, processes and sends the data to the Host Mainframe. The data is then processed by the Meter Reading / Measurements, Service Orders, and Billing systems on the mainframe. These three critical mainframe systems are undergoing extensive enhancements to handle real time processing of meter data.
Responsibilities:
Direct client Interactions for requirement gathering
Played key role in creation of Smart meter Interval data load process (MDMS to CISCO), building Smart meter interval data aggregation and Rebate/Rebill Processes for Smart Meter Billing System
Gained strong knowledge on interaction between Customer/1 System and MDMS
Hands on experience with CIS billing systems
Designed and Build various web interfaces program between CISCO-MDMS and Head-End systems using RDZ tool
Convert data to/from XML; build SOAP messages and Invoke Web services
Performed Performance testing for Web Services
Designed and Developed Remote Meter Configuration process between CISCO and Head-End System using COBOL, DB2, RDZ, AXG, Layer 7
Worked directly with ITRON for system integration between CISCO and MDMS
Played Key Role in various Smart meter Implementations (Metes and Measurements, Service orders and smart meter Billing projects)
Design and construction of efficient programs
Coordinate and participate in testing efforts at all levels like Unit testing, application testing, string testing, integration testing, End to End Testing and UAT
Coding online and batch programs (COBOL,DB2,CICS,INSTALL/1,JCL)
Involved in Design and Review process of various interfaces between CISCO (Customer/1) and MDMS
Provide technical support for the client’s applications
Issue Resolution, which includes managing the issues that come up during the course of the project and getting it resolved in time with the help of the client.
Ensuring that the organizational processes, based on CMMi Level 5 standards, are adhered to in project
Helping the business development team with technical solutions on potential projects.
DURATION: Jul 2011 to Feb 2012
Software Used: VS COBOL II, JCL, DB2 stored procedure, IMS DB, IMS DC, EASYTRIEVE, CICS and REST Web service
Roles: Technical Lead & Developer
Project 10 – Modular Base Merchandising
Description:
Modular Base Merchandising (MBM) is a project to identify the item number and corresponding Store number based on business conditions in different business areas that should be cleaned up from Mark down Database.
Tasks
Identify the items & stores that are active on Purchase Order from Teradata tables
Identify the replenish items and corresponding store from Teradata tables
Identify the Relocation stores from DB2 tables
Identify the Parent and Child relationship changed items
Identify the recall items and corresponding stores
Create the CICS REST web service program to send the records to web service
FTP the Mainframe files to and from UNIX server to manipulate them as needed
Responsibilities:
Understand the business
Identify the tables from DB2 and Teradata
Design the SQLs as per the business conditions
Designing, Coding and unit testing of components
Clarify the QA team on deliverables
Production deployment
Post and pre deployment activities
DURATION: Sep 2010 to June 2011
Software Used: VS COBOL II, JCL, VSAM, CICS and DB2
Roles: Technical Lead & Developer
Project 9 – Galleria Optura Next Gen
Description:
Galleria is a 3rd-party tool that is used to aid analysts in making assortment decisions. Analysts look at 6 key characteristics when considering the assortment mix: Brand, Flavor/Scent, Form, Size, Product Type, and Package. Through the manual analysis of these characteristics in conjunction with other key performance factors, Client may decide to carry or not carry particular items to their assortment. Currently 3 vendors are sending the details to Client for Galleria analysis. As part of this project we need to retire the process of one of the existing vendors and also incorporate the new vendor along with existing vendors.
Tasks
Need to identify impacted COBOL-DB2 programs are used by Galleria in given modules
Need to identify the screens that may require the enhancement
Need to make sure that no impact in the existing flow due to this new change
Responsibilities:
Requirement capturing
Mainframe high level Design and low level design
Estimation
Coding and unit testing
System testing
Production deployment
Post and pre deployment activities
DURATION: Jan 2010 to Aug 2010
Software Used: VS COBOL II, JCL, VSAM, CICS and DB2
Roles: Technical Lead/Developer
Project 8 – Harmonized Sales Tax
Description:
As of Jan 2010, Canadian provinces British Columbia and Ontario were issuing PST (Provincial Sales Tax-7%) and GST (Goods and Service Tax-5%) for most of the items. Government wants to introduce the HST (Harmonized Sales Tax-12%), which is combination of PST and GST for all the taxable items and effective from July 1st 2010.
Tasks
Need to identify impacted programs in given modules
Need to identify the DB2 tables and design, optimize the query
Need to make sure that no impact in the existing flow due to this new change
Responsibilities:
Requirement capturing
Mainframe high level Design and low level design
Estimation
Coding and unit testing
System testing
Production deployment
Post and pre deployment activities
DURATION: Sep 2009 to Feb 2010
Software Used: VS COBOL II, JCL, VSAM, CICS and DB2
Roles: Technical Lead & Developer
Project 7 – Flexible Spending Account card project
Description:
IRS has issued various tax favored cards such as Health Saving account card (HSA), Health Reimbursement card (HRA), Flexible Spending card (FSA) etc. These cards can be used at the various retail store locations to purchase qualified medical expenses.
Currently accepts the FSA cards at the stores for items labeled as FSA in the POS system and the reimbursements are automated. HSA cards are also currently accepted in all US stores. But there is no item level validations happening for HSA at stores. Customers have to manually submit the sales receipt for reimbursement to 3rd party. Client is not directly involved.
Prior to 2008, HSA and FSA were mutually exclusive and could not both be offered.
In December 2007, IRS introduced a new combo health plans with both HSA and *LIMITED* (perhaps vision and dental only) FSA components.
These Combo (HSA + FSA) healthcare plans require an Rx sub-sub-total, as they need to make sure OTC (Over the Counter items – need not have a prescription) items are not purchased under the limited FSA purse. The plans can use the additional Rx sub-sub-total to ensure the HSA purse handles the Rx portion of purchases, while the FSA purse handles the non-Rx OTC portion
Tasks
Need to identify the FSA items that need to be send to store
Need to identify the DB2 tables and design the query
Need to make sure that no impact in the existing flow due to this new change
Responsibilities:
Requirement capturing
Mainframe high level Design and low level design
Estimation
Coding and unit testing
System testing
Production deployment
Post and pre deployment activities
DURATION: Mar 2009 to Oct 2009
Software Used: VS COBOL II, JCL, VSAM and DB2
Roles: Team lead & Developer
Project 6 – Handheld Application Uplift
Description:
For SOLO ordering we will need to send items with Locally Assigned Codes (LAC) to the store CT2020 database. Locally Assigned Code – a number system 4 generated UPC code used to represent items that have not been assigned a manufacturer UPC. LACs are used for items that are typical not sold at the store such as material, expense, and resale items. An example of a resale item is meat primal that are ordered and then cut to make meats sellable items.
Tasks
Need to identify the business requirements to send the items that are missing in store
Need to identify the DB2 tables and design the query
Need to append the missing items with existing flow
Need to make sure that no impact in the existing flow due to this new change
Responsibilities:
Requirement capturing
Mainframe high level Design and low level design
Coding and unit testing
System testing
Production deployment
Post deployment activities
DURATION: Mar 2009 to Jun 2009
Software Used: VS COBOL II, JCL, VSAM, CICS and DB2
Roles: Designer/Implementer
Project 5 – CAMS
Description:
The scope of the Canadian Air miles Project is to migrate the existing Legacy Air miles system running on Mainframe to Copient, which is maintained by NCR. The primary objectives with this migration are
Enhance current system to accurately award the miles earned by customers
To be able to view transactional information regarding miles being earned
Customers to use Air miles card to avail of air miles promos and to earn points
Tasks
Gathering information for the Legacy (QMF) reporting conversion
Determining all minimal requirements to continue shelf talker functionality (Air mile sign printing) on MVS environment
Analyzing communication with Loyalty Management Group (LMG) (3rd party that maintains Air miles for customers) and modifying this process for the migration to Copient
During the migration from Legacy to Copient, the analysis and implementation to allow conversion for pilot retail stores. The required reporting for validation during the pilot phase will also be designed and implemented
Retirement of the Legacy system once everything has been migrated to Copient
Responsibilities:
Design
Coding and unit testing
DURATION: Dec 2008 to Mar 2009
Software Used: PL/I, JCL, VSAM, PM4DATA, Connect Direct and DB2
Roles: Technical lead/Designer/Implementer
Project 4 – IAM
Description:
Identity and Access Management is a combination of business processes and technical infrastructure that consistently and efficiently enforces business and security policies, regardless of network entry point by employees, partners and customers. The need to implement an Identity and Access Management (IAM) solution has been identified as an integral part of satisfying client’s current and future operational and technical objectives.
Tasks
Extract the Client employee’s data from database
Format the report as UNIX needed
Transfer the reformatted report to UNIX server
Responsibilities:
Requirement capturing
Design
Coding and unit testing
Deployment Activities
Production support
DURATION: Nov 2006 to Nov 2008
Software Used: VS COBOL II, JCL, VSAM, MQ, Connect Enterprise, PKZIP, CICS and DB2
Roles: Technical lead/Designer/Implementer
Project 3 – WIC EBT
Description:
The scope of WIC EBT project is to convert the Retail stores from paper-based food instruments (i.e., checks or vouchers) to electronic food instruments (i.e., smart cards). This change is mandated by the United State Government.
Tasks:
Receive the APL and HCL files and send it to stores
Retrieve the claim files from stores and reformat the claim files, as State government needed
Send the reformatted claim files to State government
Receive the reconciliation files from State
Receive the error files from State and Resend the claim files
Send the alerts to Support team, if state echoes back error file
Prepare the reports from Claim and Reconciliation files and send to NASC
Develop the Screen to update the database with WIC info provided by state
WIC EBT application has been completed in state of Texas, New Mexico, Wyoming and Nevada for Client stores
Responsibilities:
Requirement capturing
Design
Minor Enhancements, as per the client requirement
Coding
All type of testing (unit, regression and system)
Deployment Activities
Production support
DURATION: Nov 2005 to Nov 2006
Software Used: VS COBOL II, JCL, VSAM, MQ, Connect Enterprise mailbox and DB2
Roles: Developer/Implementer
Project 2 – WIC MICR
Description:
The primary goal of this project is to enable capture of WIC check MICR while scanning a WIC check and send it across to Northern California, Southern California and Pennsylvania State WIC server.
Tasks
Retrieve the MICR files from stores
Send the claim files to State government as needed
Prepare the reports from Claim files and send to NASC
Update the database with WIC info provided by state
WIC MICR application has been completed in state of California and Pennsylvania for stores
Responsibilities:
Requirement capturing
Designing Mainframe
Coding
All type of testing (unit, regression and system)
Deployment Activities
Production support
DURATION: Sep 2005 to Oct 2005
Software Used: VS COBOL II, JCL, VSAM and DB2
Roles: Implementer
Project 1 – SAFWPACT
Description:
Promotion Analyze category review tool system analyzes and prepares the reports for
STS – Short term scheme
LTS- long Term Scheme
Coupon management system
There is a change request from client to modify the length of the 2 columns from existing DB2 Table. Accordingly we need to change and test all the queries and Programs that deals with this table, which involved preparing the above 3 reports. These reports are coming from UNIX system and going to Tara data server.
Responsibilities:
Unit testing
System testing
Deployment Activities
Production Support
ACHIEVEMENTS:
One of the Mainframe and Tools trainers for offshore team
Participated in 2 Project proposals and acquired both from Client
Received best performer award 4 times from Safeway/Walmart Client
Received best performer award 5 times from employer UST-Global
EDUCATION DETAILS:
Bachelor of Engineering (B.E.) Electronics Communication Engineering
CLIENT REFERENCE:
Beverly Ann Delaney – Software Team Lead at Sempra Energy, San Diego, CA
Work Phone # : 858-***-****, Email_id : ********@***************.***
Donna Robinson – Senior Software Developer/Designer at Sempra Energy, San Diego CA Work Phone # : 858-***-****, Email_id : *********@***************.***
PERSONAL DETAILS:
Full Name : Suresh Karthikeyan
Email-id: **********@*****.***
Phone number: 949-***-****
Current location: San Diego, CA
Contact this candidate