Software Engineer Data

Prakash Devarajan

Ph: 770-***-**** Email: ***********@*****.***

Professional Summary :-

• Over all 8+ years of IT experience in mainframe technologies.

• Experience in a production support, Analysis, design, development, testing, integration, documentation and implementation of large / complex IBM Mainframe projects using OS/390 & Z/OS, TSO/ISPF, COBOL, JCL, CICS, EASYTRIEVE, XML, VSAM, DB2, IMS/DB.

• Good experience production support 24x7, gathering, analyzing business requirements and developing technical specifications/programs.

• Xpediter and intertest used for both batch and CICS programs for debugging.

• Experience in different testing levels like Unit testing, regression testing, systems testing & user acceptance testing.

• Used various configuration management tools like ENDEVOR, ELIPS (CA-LIBRARIAN), PROGRAMSTRYR.

• Used DB2 BMC (Catlog manager), QMF, SPUFI and DB2 FILE-AID.

• Used Job-trac for scheduling the batch jobs, monitoring and resolving abends.

• Proficient in writing Batch programs using COBOL, DB2.

• Having extensive knowledge on Manual Testing using CICS screens on IBM Mainframe using DB2 and flat files.

• Extensive working knowledge in Software Development Life Cycle (SDLC) having a thorough understanding of various phases such as requirement Analysis/design, LLD ( Low Level Design Doc), development , testing.

• Good working experience in project Analysis, Preparing design documents like LLD ( Low level design documents) , Detail design documents in Insurance projects and Telecom projects

• Exposure to various CMM procedures by working in CMM level- 5 environment.

• Experienced in Onsite-Offshore model.

• Highly motivated team player with organizational and analytical skills

• Good working knowledge in MS-WORD, MS-Excel, MS-PowerPoint, VISIO, MS-Outlook, Lotus-Notes, IM and Sametime.

Technical Skills:

DBMS DB2, MS Access and IMS/DB

Hardware IBM Compatible computers and Apple Mac

OS MVS, OS/390, Z/OS, Windows 2000/XP

Languages COBOL.JCL, EASYTRIEVE

Tools XPEDITER, FILE-AID, FILE MANAGER, TSO, ISPF/PDF, QMF, SPUFI, SAR, ABEND-AID, RACF, MQ SERIES SDF2, CA-7, JOB TRACK, XML, MF-VISIO, MS-OFFICE, MS PROJECT, POWER POINT, WINSQL, LOTUS NOTES,CA-JOBTRAC, PRISMA, ENDEVOR , QUALITY CENTER, ENDEVOR, SYSTEMWARE, INFOMAN

Education:

• Masters in Information Technology and Management

• Bachelors in Commerce

Professional Experience:

Client: PNC Bank, Pittsburgh

Senior Software Engineer/Programmer Sep 2011 to till date

The ultimate goal of testing is to prevent any disruption to customers access to their customer and related account data and to make their experience of being transitioned from one bank (RBCB) to another bank (PNC) as seamless as possible.

A primary testing objective is to ensure that RBCB customer and account information is converted to PNC CIF resulting in minimal to zero errors in the conversion of data. The accuracy of converted CIF data helps result in minimal impact to branches and call centers by lessening number of question or issues that would escalate to them from impacted customers. The clean CIF data should also result in downstream application such as Genesis and online banking having access to clean and accurate data.

An additional testing objective for the CIF team will be to successfully test the mailfile(s) that will be mailed to the converting customers . The goal of testing is to ensure the correct customers receive the correct mailers with the correct customer and account related data as dictated by the requirements for the mailing. A final primary objective is confirming that the implementation of relaxed edits results is significantly lower number of defects, while also ensuring that there are no unintended or negative customer due to the relaxed edits.

Responsibilities:

• Responsible to test cycle support for bank conversion one banks RBC bank and flag start Bank to PNC bank.

• Responsible for executing bank conversion jobs(JCL)

• Provide the error customer status to clients using system ware.

• Provide the output put files to the client for further process.

• Modified the COBOL according to new requirements

• Responsible for defect fixing in DB2 tables and IMS/DB and resolving defect fixing in Cobol programs users through HPQC tools for the error customers before going to production.

• Modified and enhanced existing batch COBOL programs for various Emergency

production fixings using version control tool Endevor at time of testing bank conversion one bank to another bank.

• Responsible for bank conversion at Production RBC bank and flag start to PNC bank.

• Modified the JCL according to new requirements.

• Responsible for develop new COBOL program from scratch.

• Responsible for tape extensions using Infoman for GDG Versions.

Environment: Cobol, CICS, JCL, DB2, IMS/DB, XML, Spufi, QMF, File-Aid, Quality center, MS-Office, Windows-XP, IBM Utilities, Intertest, ENDEVOR, Systemware, Infoman.

Client: IMS health insurance, Atlanta

Senior Software Engineer/Programmer Apr 2009 to Sep 2011

The demand for reliable market intelligence and accountability in global healthcare has never been greater. From researchers and payers to government agencies and pharmaceutical manufacturers, healthcare stakeholders need to better understand the role prescription drugs play in delivering high-quality, cost-effective care. At the same time, pharmaceutical companies face unprecedented competition for market share and pressures to maximize brand lifecycles, all while proving the value of their medicines. In today's complex healthcare marketplace, a growing set of audiences depend on IMS to yield the most accurate perspective of global market dynamics. Organizing a vast array of healthcare data and facts into solid, relevant metrics to help answer key questions is an enormous undertaking. IMS can apply insight and capabilities to a tremendously rich set of data assets and analytics. We are the gold standard in pharmaceutical and healthcare market intelligence, relied on by virtually all of the world’s largest pharmaceutical and biotech companies along with government agencies, policymakers, researchers and financial analysts around the globe. Our end-to-end solutions integrating unparalleled information, analytics, consulting and services play a central role in supporting high-quality, cost-effective healthcare. Our people bring the facts and figures to life, leveraging our extensive global network and expertise.

Responsibilities:

• To find out a solution for reusing existing code to reduce development effort.

• Security feature, error handling implementation for the new interface

• Relatively new development team

• Smooth Release management in a multi vendor environment

• XML Parser was implemented in CICS Pipeline to eliminate third party parser module use in the interface programs and hence reduced the coding effort drastically.

• Utility programs and few business logic programs using COBOL and DB2 / IMS/DB were changed to reuse existing decentralized platform programs to adopt to web services mode ,resulting in quick turn over time for UAT for those interfaces as the programs are already tested from other platforms

• A XML Schema Auto generation program was built in JAVA to create XML schemas automatically out of data model and considerably reduced the XML Schema development effort. Also effective use of tools like ECLIPSE, XML SPY for XML developments.

• Effective use of IBM Rational tool to auto generate bind files, copybooks and first level web service interface program to further reduce the development effort.

• Testing phase: Use of ECLIPSE 3.5 (Freeware) to create test data and input XML string to reduce the effort for test data preparation.

• Automation of MQ Upload and Download programs to be used by all developers to reduce time on test environment preparation using JCL(jobs).

• Effective use of HP Quality center for defect tracking, evaluation and delegation.

• Release Management: Integration of Subversion tool into ECLIPSE 3.5 resulting in effective control of XML development and release to third party vendors as well as project document control.

Environment: Cobol, CICS, JCL, DB2, IMS/DB, XML, ECLIPSE, Spufi, QMF, File-Aid, Quality center, Z/OS ,MS-Office, Windows-XP, IBM Utilities, Intertest.

Senior Software Engineer / Team Lead Apr 2008 to Apr 2009

Client: UNUM (USA) Domain: Insurance

Unum Corporation is a publicly owned insurance holding company. Unum is the industry leader in group and individual income protection and related coverage and services, insuring more than 25 million working people. Unum offers a comprehensive, integrated portfolio of products and services backed by industry-leading return-to-work resources and disability expertise.

UNUM help protect individuals from the financial effects of illness, injury, death or long term care needs, enable them to stay at work or to return to work after an illness or injury. Also, help employers better manage their overall benefits program, enhance productivity, and provide for their employees welfare.

Based on business requirements of UNUM can be classified into the following major modules like Enrolment, Policy Admin System, Billing System, Claims processing etc.

Responsibilities:

• Responsible as team lead for test cycle support.

• Monitoring schedules, batch JCL jobs and resolving abend jobs using Control-M scheduler.

• Support on-site application development team for their implementation activities.

• Modified and enhanced existing batch COBOL programs for various Emergency

production fixings using version control tool EASYTRIEVE.

• Responsible for defect fixing in DB2 tables and IMS/DB and resolving defect fixing in Cobol programs users through HPQC tools

• Coordinate with on-site team on weekly basis and discuss on the

current issues.

Environment: Cobol, CICS, JCL, DB2, IMS/DB, EASYTRIEVE, Spufi, QMF, MQ series, File-Aid, HP Quality center, MS-Office, Windows-XP, IBM Utilities, Control-M.

Software Consultant / Developer Aug 2005 to Apr 2008

Client: AAPT (Australia) Domain: Telecom

MEGA is mainframe application to cater the following business requirement like order management, Account management, Rating and billing application for AAPT business processes. It also supports various data transfer and data back up services between various interfaces like REBILL, INBILL, and SWITCH DATA.

The majority of users access MEGA via a web-based interface SSWEB and the native CICS screen, the MEGA batch invoice cycle process mainly rate the calls using CDR(call detail records) from various interfaces for various range of service types like landline, mobile, dial up, ADSL, ISDN etc. then the rated calls details are delivered to InBill (for Inter-carrier billing), Australia Post, Direct Debit , Credit Card processing, data backup and MEGA sends data to the Secure Mail Services (SMS) Company for traditional printed invoices.

Responsibilities:

• Responsible for on call production support 24*7 for the MEGA batch system.

• Monitoring schedules, batch JCL jobs and resolving abend jobs using CA-JOBTRAC scheduler.

• Support on-site application development team for their implementation activities.

• Modified and enhanced existing batch COBOL programs for various Emergency

production fixings using version control tool Endevor.

• Responsible for production data fixing in DB2 tables and resolving service request raised by the MEGA application users through CAMS tools

• Coordinate with on-site team on weekly basis and discuss on the

current issues

• Onsite explore: 2 months oncall production support handled at Australia (Sydney).

Environment: Cobol, CICS, JCL, DB2, ENDEVOR, Spufi, QMF, File-Aid, CAMS, MS-Office, Windows-XP, IBM Utilities, Job-trac.

Software Consultant / Developer Mar 2005 to Aug 2005

Client: SENSHUKAI Order Management Systems, Japan

The Order management system accepts good order thru online and telephone for all the types of home appliances, electronic and electrical goods. The programs are developed with PL/1 programs, and it converted into JAVA based programs.

Responsibilities:

• Conduct meetings to discuss the application design and feasibility issues and helped to JAVA peoples to code their programs.

• Involved in Case study and project planning of migration project Mainframe to target system JAVA

• Involved in inventory Analysis for the migration project.

• Involved in DB2 Database Analysis.

• Involved in PL/1, Subprogram analysis.

• Prepared the documentation for JCL jobs.

• Designed the flow chart for the program structure.

• Involved in peer review.

Environment: PL/1, CICS, JCL, DB2, Spufi, QMF, File-Aid, CAMS, MS-Office, Z/OS, MQ series,Windows-XP, IBM.

IBM Global Service India (Melstar Information Technologies).

Software Engineer / Developer Feb 2004 to Mar 2005

Client: AT&T, USA, Domain: Telecom

Responsibilities:

The Corporate Tax System collects, organizes, and distributes current and historical tax data used for billing AT&T customers. This includes the tax rates, rules about what taxes apply to AT&T customers, and rules about what taxes apply to the services and products AT&T provides. It is used corporate-wide by AT&T billing applications.

The Corporate Tax System includes jobs to update and unload these databases, an IMS ADF online system for updating and retrieving tax data from the databases, callable modules to return tax data to other modules, jobs to process tax compliance data produced by AT&T billing systems and a system for collecting and reporting on tax compliance statistics.

• Involved in COBOL program analysis.

• Involved in effective coding for tax module programs using database IMS/DB.

• Modified the JCL according to new requirements

• Changed effected documentation preparation.

• Unit test plan preparation.

• Involved in review and testing.

Environment: Cobol, JCL, IMS/DB, ENDEVOR, Spufi, QMF, File-Aid, CAMS, Z/OS, MS-Office, Windows-XP, IBM Utilities.

Software Engineer / Developer Sep 2003 to Feb 2004

Client: AT&T, USA, Domain: Telecom

The Global Billing Platform Application was developed by IBM in early 90’s to support the services available on the Global Network. GBP is primarily used to support the Managed Services and it supports the billing needs of the AGNS country organizations (80 + Countries). Following are some of the tasks performed by the GBP Application

•Service Boarding, Mediation Services, Service Bundling, Rating, Aggregate discounting, Adjustments, Online Inquiry, Batch Inquiry, Country currency support, Country Language support, Business Controls, Taxing, Invoicing, Journalization, E-Invoice, A/R - Collections

The Application is mainly divided into two processes, the Accounting Process and the Billing Process. The Accounting process receives data from variety of services and communication modes and processes the data. The processed data is either sent back to the countries for billing, or processed by the GBP billing process. The billing process receives usage and fixed accounting data supplied by the daily accounting system, along with real time data from MQ Series, and calculates charges that are stored in DB2 tables. The batch-processed charges are combined with real time charges and are used to calculate discounts for all the eligible customers. The combined charges are then summarized into charge account and control account for the month and loaded into various DB2 tables which are later used for reporting, invoicing, etc.

The GBP system supports multiple currencies and multiple languages providing a Year 2000 certified billing platform for countries throughout the world. The GBP system has both a batch process and an online real time process providing multiple facilities for receiving and processing billing data.

Responsibilities:

• Testing of the corporate billing flow the technologies involved in COBOL, JCL, and DB2.

• Integrations testing

• User acceptance testing

• Involved in review

• Test data preparation using PRISMA tool

Environment: Cobol, JCL, DB2, ENDEVOR, Spufi, QMF, File-Aid, CAMS, MS-Office, Z/OS Windows-XP, IBM Utilities, PRISMA.

Status : H1B

Contact this candidate