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 : acrgmb@r.postjobfree.com

Donna Robinson – Senior Software Developer/Designer at Sempra Energy, San Diego CA Work Phone # : 858-***-****, Email_id : acrgmb@r.postjobfree.com

PERSONAL DETAILS:

Full Name : Suresh Karthikeyan

Email-id: acrgmb@r.postjobfree.com

Phone number: 949-***-****

Current location: San Diego, CA

Contact this candidate