Mainframe developer

Sachidanandan A

Mobile +858-***-****)

Personal mail ID: ******.*******@*****.***

Summary

Having 10+ years of experience in Mainframe Application Development, Maintenance & Enhancement Projects and also in Production Support System.

Completed IBM DB2 9.0 Family Fundamentals Certification.

Extensive experience in using COBOL, JCL, CICS, DB2, VSAM, IMS/DB, CA-TELON & MQSERIES, SDFII tool.

Proficient in working with Databases like DB2 (RDBMS) & IMS-DB (HDBMS).

Extensive experience with MVS utilities and tools TSO/ISPF, File-AID, FILE-MANAGER, INSYNC, XPEDITOR CHANGEMAN, ENDEVOR, Dump Master, QMF, Control-M, SPUFI, NDM, FTP, IDCAMS, SYNCSORT, TSRM tool.

Worked under esteemed clients like SDGE Sempra Energy & Utilities, Safeway CMS Retail, Anthem Blue Cross & Blue Shield, H.E.B Retail Shop, Nissan Motors, Citi Bank Corporation & Standard Chartered Bank etc.,

Possess extensive knowledge of various processes and quality management standards like CMM Level-5 and P-CMM for deliverables.

Strong exposure to various phases of Software Development Life Cycle (SDLC) including Requirement Analysis, Design, Development, Debugging, Testing, Implementation, Quality Co-ordination, Production Support and Client Co-ordination by way of implementing waterfall model and agile methodology.

Recognized for creativity and innovational ability to think outside traditional parameters, devise cost-effective solutions to difficult and complex situations.

Good domain knowledge of Energy & Utilities, Banking, Insurance Health Care, Credit Card System, Retail System and Automobile.

Skill Summary

Operating Systems : MVS OS/390, Z/OS & Windows platform, UNIX

Languages : COBOL, JCL, Easytrieve, SAS Programming, CICS, SQL & Java

Databases : DB2, IMS-DB & ORACLE10G

EAI tools : MQSeries

Internet Technologies : HTML & Javascript

Change Management tools : ENDEVOR, CHANGEMAN & PANVALET

Debugging tools : DT tool, DTCN tool & Xpeditor

Tools and Utilities : TSO/ISPF, VSAM, QMF, File-Aid, INSYNC, NDM, GDG, SYNCSORT, FTP, IDCAMS, CA-7, CONTROL-M, CONTROL-D, DB2 Platinum & SPUFI, Install One too, Fault Analyzer

Application Generator Tool : CA-TELON

Reporting Tool : Oracle BI (OBIEE) 10g, BI Publisher

Academics & Certifications

Master of Computer Application, (M.C.A) in First Class

Professional Experience:

CLIENT: Anthem Blue Cross and Blue Shield Association - (USA) California

About Client and Services

Anthem Inc. is an American based health insurance company founded in the 1940s, prior to 2014 known as WellPoint, Inc. It is the largest for-profit managed health care company in the Blue Cross and Blue Shield Association. STAR membership and billing handles member enrollment and premium collection from the members for the service rendered. STAR system deals with the insurance coverage provided for individuals as well as small companies with an employee strength less than 100. WGS membership deals with the insurance coverage that deals with large companies with employee strength more than 100.STAR membership system is maintaining member data for the following business such as Small Group, Individual (Under 65), Senior & State sponsored.

Project Title : STAR Membership System (Health Insurance)

Duration : Oct’15 – Till date

Company : UST Global International Pvt Ltd., Woodland Hills, CA

Role : Technical Programmer Analyst

Responsibilities:

Involved in enhancement project ALICS eligibility file system for the new product refresh 2016 project for the member enrollment in small groups which includes requirement gathering, impact analysis, preparation of the technical design document and technical response, Estimation, Coding, Unit Testing, Baseline Audit, SIT & UAT Plan document and Deployment Plan in Production region by way of implementing Agile Methodology.

Involved in writing a new batch application programs for the new product 2016 refresh project for Optional Supplementary Life & Disability Product using COBOL,JCL & DB2 for generating the six eligibility extraction file such as Group Extract File, Employee Extract File, Class Extract File, Member Benefit File, In-force billed file & In-force paid file for the ALICS system.

Involved in ACA decoupling project for the Cal Cobra letter process handling system for hybrid and non-hybrid groups’ category which involves coding a batch program using COBOL & JCL, Involved in Unit Testing, Preparing the Design Document, Preparing Test Cases, Interaction with PSD Publication Team for letter process handling to the customers.

Involved in BCBSA retention project for the mandate cancellation letter process handling system for group level as well as member level category which involves co-ordination activities for helping offshore team to involve coding, testing, preparing design document, preparing test cases and updating clarification tracker on the status call meeting with the client.

Involved in handling Clear Quest defect issues prior to the pre-implementation and post implementation defects for the STAR & WGS membership project.

Scheduled meeting with the clients for the current ongoing project and sending status update to delivery manager.

Involved in preparing the CAST violation report from the dashboard tool for the WGS project for sending report on each deliverables.

Handling issues in Clear Quest Tool and providing solutions to the business user for the defects reported during SIT/UAT Phase Cycle.

Assigning task to offshore team members for the ongoing project work.

Technologies: COBOL, CICS, JCL, DB2, IMS/DB, VSAM, Change Man, Sync Sort, SPUFI, FILEAID, Fault Analyzer & QMF

CLIENT: SDGE (San Diego Gasoline & Electricity) – Location: San Diego, CA (USA)

About Client and Services

SORT IT (Service Order Routing Technology) which receives the service order messages from many host system and process the orders to Advantex system which is running on UNIX platform. The service order will be created in CISCO side and then comes to SORT IT mainframe application and from there it will go to Dispatch Application (DA) in Advantex server. The role of SORTHUB is to receive the order details from SORT mainframe through web services and transmit to Advantex Queue in SORTHUB server. Sort hub and Advantex are connected through JMS Bridges. Once the message reached to Advantex Queue in SORTHUB, then Queue in Advantex Server will read the message. After message reached to Advantex service suite, it will send back the acknowledgement to SORT MMI (Mainframe Messaging Interface).

Project Title : SORT IT System – SDGE Energy & Utilities

Duration : December 2012 – October 2015

Company : UST Global Inc. San Diego, CA

Role : Technical Programmer Analyst

Responsibilities:

Involved in development activity with the help of requirement gathering, preparing the design document, execution LOE, Coding, Unit Testing and deploy the code changes in Production region by way of implementing agile methodology.

Involved in SOPE Migration development project from Power Builder to Mainframe application for the complete end to end SDLC process such as uploading the one-time table load process through batch program, designing the new online screen maps through SDFII tool, coding online programs using COBOL, CICS, JCL & DB2, debugging the programs and maintained the defect tracker for identifying the pre defect issues to the business user during SIT phase.

Involved in designing and coding the SOPE application using SDFII tool, COBOL & DB2 for the following screens such as SORT SOPE Main Menu, Parameter Maintenance, Destination Maintenance, Job Code Maintenance, District Maintenance, City Maintenance, Order Type Maintenance, Order Generation Type Maintenance, Order History & Order Creation screen.

Involved in preparing the technical design document, preparing the UTP & UTR document for Unit testing, SIT & UAT testing was conducted by separate teams and we maintained the coding standard as per the SORT IT application standard.

Implemented SOPE Migration Project, Call Reminder Project, and CISCO & NMS invalid character Project successfully deployed in production environment.

Handling couple of SIR like CISCO Invalid character report creation program, OMS error handling from host to distribution and NMS invalid character program to avoid unplanned outage happened during processing the orders from SORT to NMS system.

Involved in monthly maintenance support activity for Advantex server restart process which is running under UNIX platform for improving the performance.

Assigned task to offshore team member and provided guidance for technical issues for the SORT IT application.

Involved in DB2 upgrade testing activity in test environment as well as production environment for checking the data validation and shared the report to the appropriate counterpart on the monthly scheduled maintenance activity.

Technologies: COBOL, CICS, JCL, DB2, VSAM, Endeavor, SPUFI & QMF, XPED tool, SDFII tool, UNIX, Java Web services

CLIENT: 10860 – CMS and Sensitivity Code Project (Safeway- USA)

About Client and Services

CMS and Item Sensitivity Code project will automatically adjust the club card coupon value for an item based on the sensitivity of the item, store cluster information, and SMIC (Group and Sub-Group only). The adjusted coupon value will be viewable by pricing staff and will be sent to the stores, via Host POS, to formulate the club price of the item. Pricing adjustments will be made so that a given item’s Club Card price is more tailored to how much a customer values a particular product in a store cluster.

Project Title : 10860 – Safeway CMS and Sensitivity Project – Retail

Duration : May’12 – Nov’12

Company : UST Global International Pvt Ltd., Chennai

Role : Mainframe Designer

Responsibilities:

Involved in requirement analysis with the help of BTRD document and prepared the Technical Design document for MEC585 new online screen, Estimation, Resource Traceability Matrix (RTM) document, Release Notes, Pre-delivery Checklist document for each phase of life cycle.

Involved in coding part using CA-TELON tool, CICS, COBOL & DB2 for developing a new online screen for MEC585 (COUPON ADJUSTMENT FACTOR MAINTENANCE) screen.

Preparing UTP and UTR document and involved in regression testing and fixing the defect.

Rectifying issues through help of using DTCN debugging tool and promoting the package for the required online regions.

Preparing defect log report when there is any coding defect found in online screens.

Provided technical training to fresher’s in Mainframes competency.

Participated in weekly status meeting and gave suggestion for improvements in Telon coding standards handled by our team members.

Used CHANGEMAN tool for promoting CA-TELON COBOL/CICS code to development region for testing.

Developed test methodologies, test strategies, test plans and test cases for Unit Testing, System Testing, Functional Testing & Regression Testing.

Actively participated in technical touch base meeting which was conducted from the client side on weekly basis and provided suggestions for business queries.

Coding, testing and promoting the changes to QA, regression testing, UAT and follow-up through pre-screening process and finally implemented the code into production including post implementation monitoring and data verification.

Technologies: CA-TELON, COBOL, JCL, DB2, Changeman, DTCN debugging tool

CLIENT: WellPoint Senior Lights-on Support - SNRLO (USA) California

About Client and Services

WellPoint is one of the leading health benefits company in USA, serving the needs of 34.1 million Members nationwide. It offers a spectrum of network-based managed care Plans to the large and small employer, individual, Medicaid (low income) and senior beneficiaries. WellPoint is contracted by the CMS to process the Medicare claims and Report to them. Senior IT system is the department of WellPoint that caters to the Medicare Plan for all citizens coming under the categories of Age greater than or equal to 65, people with disabilities and those that have fatal renal disease.

Project Title : WellPoint SNRLO & SSCR Project - SBG (Health Care)

Duration : Jan’11 – Mar’12

Company : UST Global International Pvt Ltd., Chennai

Role : System Analyst

Responsibilities:

Involved in requirement gathering with the help of analyzing the BTRD document and prepared the technical design document, Estimation, Resource Traceability Matrix (RTM) document, Release Notes, Baseline Audit, Pre-delivery Checklist document, Unit Test Plan document, SIT Plan document & UAT Plan document etc.,

Understanding the business logic flow for the different process in the Senior-IT-Application support system and to provide status report on the daily basis to client side about any major impacts from the business.

Involved in coding Dis-enrollment batch program using COBOL,IMS/DB & JCL.

Provided 24X7 on-call production support for Senior-IT application system and involved in batch support activities through TSRM tool for identifying the problem.

Identifying root causes for production issues within the SLA time based on the service level category.

Preparing defect log report on the monthly basis based on the coding defect.

Provided technical training to fresher’s in Mainframe competency.

Participated in project meetings and gave suggestions for improvements in Coding/QC techniques.

Actively participated in Handover meeting on every deliverables in SSCR Project and troubleshooting the issues and providing technical solution as well as business solutions.

Preparing Minutes of meeting report for weekly status call within our offshore team.

Preparing tracker for monthly release deliverables, Service Request tracker, RFC tracker, Job ABEND tracker for weekly metrics report to onsite counterpart.

Technologies: COBOL, JCL, IMS-DB, VSAM, Changeman, DT debugging tool, File Managr IMS

CLIENT: H. E. Butt Grocery Company (H-E-B), USA (Texas & Mexico)

About Client and Services

H-E-B is one of the largest independently owned food retailer in Texas and Mexico with over 310 stores and 75,000 employees. Presently UST Global is providing application support and maintenance support with UST’s technical team located onsite – offshore. The nature of work involves the maintenance, production support and enhancements for the on-going HEB applications and development of new applications under various business verticals. Issues are logged in the form of tickets in HP Service Manager & Enhancements and Maintenance tasks are logged in the form of PPM Requests.

Project Title : HEB MF-GM SUPPORT, ENHANCEMENTS AND ROOT CAUSE FIXES.

Duration : Aug’09 – Dec’10

Company : UST Global International Pvt Ltd., Trivandrum

Role : Production Support Expert

Responsibilities:

Understanding the business logic for the General Merchandise & Supply Chain Management domain and its architecture.

Supporting more than 30 application from offshore and onsite team on 24/7 production support for fixing the production issues in batch & online support system with different severity level category.

Actively participated in major critical applications like OMI, Billing, Store Replenishment System (SRS), FEOB application & DDT enhancement project by using batch programs such as COBOL, VSAM, DB2 & JCL.

Involved in writing Easytrieve programs for Customer Maintenance Reporting program for Store Replenishment System.

Developed SRS automation process application through batch application program by using COBOL, DB2, VSAM & JCL in a customized way.

Involved in TIBCO integration process using MQ series application for implementing SRS maintenance application message process in batch system from the mainframe side to TIBCO.

Actively participated in on-call video conference status meeting on bi-weekly & participated in lead’s meeting on the weekly basis.

Preparing Minutes of meeting report for weekly status call within our offshore team.

Troubleshooting the issues and providing technical solution as well as business solutions.

Identifying root causes for production issues within the SLA time.

Preparing conceptual, functional and job flow design documents.

Technologies: COBOL, JCL, CICS, DB2, IMS-DB, VSAM, Easytrieve+, Zeke Job Scheduler, Changeman,MQ-Series, Sync Sort, DB2 Platinum utility & SPUFI

Project Name : PACKAGE 5 Apr’08 to Dec’08

Client Location : Nissan North America, Nashville, TN. USA

Company Name : PERI Software Solutions Inc., Newark, USA

Role : Programmer Analyst

Description

Nissan North America deals with service warranty with the processing of claims submitted by dealer for the repair done for Nissan Vehicles. CPIA is the major system that deals with business rules that affect the processing of claims. This system was built and rolled out in 1995 and has a record of claims starting from 1995. This system was rolled out to Nissan Canada, Nissan Puerto Rico and Nissan Guam in 2003. The CPIA system was planned to replace the old warranty system (Warranty Claims) but so far only the daily processing functionality and some monthly processing functionality have been incorporated into this system.

Responsibilities:

Worked on the Claims Warranty Systems, which had 29 applications in it.

Involved in writing codes using COBOL, JCL, DB2 for generating In-bound interface process to source vendor purchase orders details from NNA and NCI internal system on a daily basis with CPS system.

Completely responsible for maintenance of PACKAGE 5 application with more than 200 COBOL-DB2 programs with embedded SQL as well as DB2 stored procedures.

Extensively used FILE-AID tools to browse, edit, copy, compare, allocate and delete the Sequential files (PS), Partitioned data sets (PDS) as well as VSAM files.

Proactively request for counter measure ticket to avoid the future exceptions from recurring using REMEDY (Action Request System).

Tested SQL statements, outside the application program before embedding them in the source program code.

Accessed CA7 for Scheduling jobs with Batch Support System.

Involved in coding, testing and promoting the changes to QA, UAT and follow-up through migration to production including post implementation monitoring and data verification.

Technologies: COBOL, JCL, CHANGEMAN, XPEDITOR, DB2, CA7, JCL & SPUFI

Project Name : PROMO (Promotion Systems) May’07 to Jan’08

Client Location : Citicards, Singapore

Company : Satyam Computer Services Ltd.,

Role : Senior Software Engineer

Description

The Promotions System (PROMO) allows Citibank to reward its cardholders based on the account status and the card usage. This is an incentive designed to increase the purchases and build loyalty. This document describes how a cardholder gets the benefits of this Rewards System. The cardholder has to be enrolled for the program. Once he is enrolled, he can earn the reward points based on certain conditions. That is, he can start accumulating these points. Finally, on the fulfillment of the set limits he can avail the rewards he is entitled to. Hence, the Rewards process in the PROMO system can be broadly categorized into three stages: Enrollment, Accumulation and Fulfillment

Responsibilities:

Prepared the File comparison program in the Automated Insert and Messaging system (AMS file) and Identified the source codes, JCL, copy books.

Involved in Impact analysis in the source program and changed working storage variables based on the requirement.

As a member of 10 member offshore team, involved in preparing test cases and analysis of specifications sent by the onsite coordinator.

Involved in modifying the programs, writing new programs and quality assurance with each subsystem is being converted after successful completion of century date.

Involved in extensive querying of the DB2 table using SPUFI utility tool.

Groom the new team members in the functional and technical aspects of the project and sharing the best practices of the team.

Prepared Adhoc jobs based on their requirement on daily, weekly or monthly basis and downloaded reports by using View Direct Reporting System.

Provided technical training to ELTP in Mainframes competency.

Developed test methodologies, test strategies, test plans and test cases for functional testing.

Active participation in meetings to discuss project release and to meet the dead lines.

Environment: COBOL, JCL, CHANGEMAN, DB2, XPEDITOR, SPUFI, QMF & INSYNC

Project Name : Profitability Analysis System (PAS2) May’05 to Apr’07

Client Location : Standard Chartered Bank, UK

Company : Scope International Pvt Ltd.,

Role : Product Analyst

Description

PAS2 is a reporting system for Standard Chartered Bank on profitability and performance for improving business decision. The PAS provides information and details used for high-level management reporting in the Pipeline pack, managing the business line functions, evaluating customer relationships, measuring performance of the Relationship Managers (RM’s) and product management. PAS2 is the central system to collect data from around 16 transaction processing systems namely Hogan, Payment, MSA General Ledger, IMMS etc., and then standardize the aggregate data for other systems.

Responsibilities:

Involved in Production Support activities with batch support system for seven countries and attend calls through ITSC service support.

Interacted with users and got the functional details for the New FTP Policy development work and answered their day to day business queries on Hogan Support System.

Worked in Hogan Mainframe application Support System for Maintenance & Enhancement activities.

Handled Action Request System (Remedy Access) and Change request System.

Downloaded reports to downstream systems through View Direct Reporting System.

Conducted SIT & UAT for many sub-projects and preparation of UTP, Minutes of Meeting, Software Migration form & Adhoc job request.

Worked on Severity2 and Severity3 exceptions and provided solutions with in the SLA (Service Level Agreement).

Involved in EBBS (Electronic Banking & Business System) project for Indonesia & Standard Build 2.0 upgrade project.

Participate in project meeting, suggest for improvements in Coding/QC techniques.

Maintained coding standards during construction part & migrated Hogan as well as SYSGEN application system from CQS to COBOL application.

Provided 24X7 on-call production support for batch application system.

Worked in Control-M & Control-D job schedules & reporting system for handling complex business issues for Standard Chartered Bank.

Technologies: COBOL, JCL, ENDEVOR, DB2, CQS, Expeditor, SPUFI, LOTUS Notes & FTP

Contact this candidate