RAGHURAM YELLANKI

IBM Certified Consultant

Phone: 309-***-****

abm4oj@r.postjobfree.com

Summary:

Certified IBM professional Having around 8 years of experience in

Information Technology in the Insurance and Banking Industries with

extensive experience in Application Study, System Analysis, Testing,

Implementation, System Ownership, Maintenance, Design and Development of

applications.

Extensive experience in System Analysis, Design, Maintenance and

responsible for maintaining the applications in production systems

Experience in work estimation and distribution of work to the team members

Preparation of High level design/Low level design based on the requirements

frozen.

Extensive experience in Testing, Coordinating all aspects of testing

efforts like providing test estimates and schedules, creating test

deliverables including test cases.

Proficient in developing and maintaining software applications using COBOL,

ISPF, DB2, UDB, JCL, IMS DB/DC,CICS, MVS, FILE-AID, QMF, SPUFI, VSAM,

MVS-ESA, MQ-Series, OS/390, Z/OS, TERADATA, XPEDITER, ENDEVOR, TSO, SDSF,

SYNCSORT and IBM Utilities

Well-versed with most DB2 Interactive utilities like SPUFI (SQL Processor

Using File Inputs), QMF (Query Management Facility), PLATINUM/DB2

Aptitude for analyzing, testing, debugging code, identifying problems, and

creating solutions.

Have a good combination of technical, communication and interpersonal

skills, which provide the ability to be an effective mediator between

programmers, end-users and clients Plays a crucial role in a team

environment.

Hard working, self-motivated, attention to details and able to meet

aggressive project schedules

Excellent problem solving skills & proven track record.

Functional expertise in Banking, Insurance and Finance Domains

Certifications:

IBM Certified Database Associate -- DB2

Brain bench RDBMS Concepts assessment

Brain bench Software Quality Assurance

Brain bench CICS user

Education:

Bachelor of Technology in Computer science

Technical skills:

Operating Systems : WINDOWS, OS/390, Z/OS, DOS

Programming Languages : COBOL, JCL, JAVA, C, C++

Database : DB2, IMS, SQLSERVER, DB2 Control Center

FMS : VSAM

Middle Ware : MQ Series

Data Ware house : TERADATA

Printing/Documentation : Exstream Dialogue, AFP, CSF

Tools:

Debugging Tools : XPEDITOR, INTER TEST, IBM DEBUGGER

Tools : Visio, File-Aid, File Manager, ADS, TSO/ISPF

Version Control : ENDEVOR, CHANGEMAN, VSS

Database Tools : SPUFI, QMF, FILE-AID, PLATINUM

Change Management : CAMS

OLTP : CICS

Scheduling : CONTROL-M, CA-7

Trackers : DTS, DNTRACKER, QUALITY CENTER

Others : FTP, XCOM, XML, IHUB, WCC, RATIONALROSE

Packages : MS-OFFICE

Project Profile:

Title : UDAP Regulations

Client : First Data Resources, Omaha, NE

Role : Exstream Analyst/Developer

Environment : Z/0S, COBOL, JCL, ENDEVOR, FILE MASTER, NDM, ENDEVOR,

EXSTREAM DIALOGUE 6.1,CSF,

Duration : Aug 2009 to till date

Applications :

Tiffany&Co -- Aug 2009 to

Dec 2009

BML -- Jan 2009 to till date

For decades, First Data has helped merchants and financial institutions

process transactions, improve cash flow, and better manage risk with our

product solutions. Providing payment solutions, card issuing solutions,

prepaid and paperless payroll solutions, mobile commerce, ecommerce,

internet banking, terminals and supplies, ATM, loyalty solutions, Fraud

risk Management, Bill payment solutions.

Currently working on UDAP regulation project

Roles:

Migration, Conversion and Enhancements to the existing processes using CSF

(Custom Statement Formatter) and AFP (Advanced Function Presentation,

Advanced Function Printing) to a new bill format and design using AFP, PDF

and Exstream Dialogue with Dialogue Anywhere (for messages).

Performed systems analysis and design of a document automation

infrastructure for Client correspondence application utilizing Exstream

Dialogue

Create the Technical design documents for the new developments and the

enhancements carried out.

Analyze the Business requirements coming up with Dialogue design document

Created the variables, data mapping, handling Pages, Documents and

Applications, for maintenance and development assignments.

Worked on page components; text boxes, tables, flow frames, logos,

pictures, shapes, colors, relative positioning, headers, flow headers.

Implemented rules and formulas.

Good knowledge about Output file format handling - AFP files, generating

PDF, Report files and Output Queue handling.

Running dialogue engines from Mainframe to simulate real production

scenario and triggering the prints.

Worked on Tag Sets, Fonts, and page size/template handling. Ability to

handle special fonts like barcodes, OCR, IMB, USPS fonts.

Handling and defining Driver files, Reference files, Section based files.

File fudging and cropping, messages; checks, coupons, remits. Well informed

about Input file handling - data files

Title : Enterprise Customer Information File

Client : Nationwide Insurance, Columbus, OH

Role : System Analyst

Environment : Z/0S, COBOL, DB2, JCL, CHANGE MAN, FILE-AID, IBM DEBUGGER,

XML,WCC, IHUB, MQ SERIES, MDM,UNIX,CA-7,FTP,XCOM,CICS,QUALITY CENTER,IMS

Duration : March 2007 to July 2009

Applications:

COMM LOADS -- March 2007 to October 2007

FER -- November 2007 to March 2008

OFAC -- April 2008

to June 2008

CIF SHUTDOWN -- July 2008 to October

2008

MDM UPGRADE -- November 2008 to Apr

2009

SEARCH ADDRESSEE -- May 2009 to July 2009

The Enterprise Customer Information File (ECIF) is being developed to

provide a consolidated enterprise-wide 360-degree view of customer

information across product lines and business units. The project involves

the migration of customer information from today's Property & Casualty

Customer Information File (CIF) and the Enterprise Customer Information

Broker (ECIB) into a common data store utilizing the Web Sphere Customer

Center (WCC) (aka DWL Customer) product. Existing data feeds and user

access points for CIF and ECIB will be migrated to a future state Services

Oriented Architecture (SOA) interfacing with the new Enterprise Customer

Information File (ECIF) database.

Roles:

Created data mapping document from existing CIF file system to ECIF

database fields.

Analyze business and system requirements, including impact analyses on

existing systems, to develop systems specifications.

Used Message Broker to transfer data/messages between JAVA based frontend

and Mainframe based backend application.

Written COBOL/VSAM Batch programs for Report generations and data

processing.

Used CEMT, CECI, CECA, CEBR etc. CICS Transactions.

Worked on AIX platform to access/debug and test data on IBM DB2 in IHUB

Database

created couple of scripting files to access and compare data from DB2

database

Checking the file-status on IHUB Using shell script

Used OMEGAMON to monitor the different CICS regions, hence simplify the

debugging.

Used CICS links calls and Dynamic memory allocations to build the

modularity so as to simplify the coding.

Understand client configuration for each system and major applications used

i.e. IMS, DB2, etc

Developed test plans, conditions, and cases used in testing based on

business requirements, technical specifications and/or product knowledge to

ensure they function properly.

Built DB2 components to unload and load the database tables.

Used DB2 tools and techniques in optimizing overall performance of database

operation.

Created IT, ST and UAT Test plans according to business requirements.

Problem Analysis & Detailed Design preparation.

Deployed the components according to Implementation plan.

Development and modification of Batch programs, generation of user reports

& enhancements.

Worked on DB2 Stored procedures

Extract the Data from Teradata for Front end Redirects project

Involved in Design and Technical specifications

Point of Contact for Regression Testing in ECIF

Worked in requirement gathering for addresses cleansing

Write the technical specifications based on the requirement

Involved in DWL/Web Sphere Customer Center (WCC), a MDM product from IBM to

manage customer Information across all the lines of business within the

enterprise.

Post Implementation support and involved in acceptance testing and post

implementation checkouts to ensure that the product is developed as per the

business requirements

Analysis & Design of Enhancements and bug fixing

Prepared Requirement Traceability Matrix (RTM) for the use cases.

Worked on designing the applications and representing design in UML

diagrams with Rational Rose.

Title : GROUP DATA WAREHOUSE (GDW)

Client : Common wealth Bank of Australia

Organization : EDS INDIA

Role : Information Associate

Environment : OS/390, COBOL, JCL, TERADATA, MLOAD, NDM,

FASTEXPORT, CONTROL-M, CAMS, ENDEVOR, FILE MANAGER

INTER TEST, TSO/ISPF, UNIX, INFORMATICA POWER CENTER 6.1

Duration : May 2006 to Dec 2006

Roles:

Involved in complete software development cycle - gathered requirements

from clients, prepared technical, functional specification (documentation

and use case diagrams), test cases development, coding and testing.

Worked on Teradata system with 240 AMP 26 node system with 10 Tb of data.

Carried out DASD/CPU utilization analysis and finding out the effective

solution for cost saving to reduce the infrastructure cost.

Used Mload, Fast Export process for load and unload the data from the

warehouse

Performance evaluation and impact analysis for each program after

implemented in test regions.

Designed complex ETL mappings and configured the sessions and workflows to

populate the Decision Frame work tables in Data ware house

Worked on the Performance tuning, ETL Procedures and processes

Involved in Production support and enhancements and solved various

production abends successfully.

QMS related activities.

Generated UML diagrams using Rational Ross

Carried out numerous Gap analysis studies & system conversion approaches.

Coordinate and/or perform change and revision management to ensure inter-

operability of systems.

Title : TRACS

Client : Bank of Ireland

Organization : Perot Systems Tsi (INDIA) Ltd

Role : Associate

Environment : OS/390, COBOL, JCL, VSAM, IMSDB/DC, DB2, MQ SERIES,

VB, VC++, SQL-SERVER, DTS, FILE-AID, XPEDITOR,

FTP,

ENDEVOR

Duration : May 2005 to Apr 2006

Roles:

Involved in solution scoping, design analysis, system integration and

development

Review of source code as per requirements listed in the design phase and

subsequent testing of the code.

Analysis, testing and debugging of new code before it promotes to

production

Involved in setting up the test environments.

Developed Batch programs DB2. Created and modified test and production

JCLs/Procs/Parms and provided on-going support.

Involved in Design, Analysis, Coding, Reviewing and Testing Batch (DB2,

VSAM) AND online COBOL programs for Foreign Exchange System.

Developed DB2 embedded COBOL programs with IMS commands to link to other

programs.

Prepared the functional specifications for the COBOL/IMS components, from

the Analysis a

Worked on DB2 Stored procedures

Coding and unit testing of Batch & Report Generation programs.

Prepared test plans and created test reports for verification.

Fixed problems reported by client by research, coding, testing, and

production installation.

Prepared JCL's and PROCs for UAT and PROD regions.

Developed new COBOL routines for customer reporting using DB2 Embedded SQL.

Analyzed the business requirements documents against selected programs to

ensure business requirements were met.

Prepare low-level specification of modules and processes.

Title : ONLINE BANKING SYSTEM

Client : National west minister, U.K

Organization : Perot Systems Tsi (INDIA) Ltd

Role : Associate

Environment : 0S/390, COBOL, JCL, IMS, DB2, VSAM, FILE-AID, XPEDITOR AND

ENDEVOR

Duration : Apr 2004 to Apr 2005

Roles:

Prepared JCL's and PROCs for UAT and PROD regions.

Developed new COBOL routines for customer reporting using DB2 Embedded SQL.

Analyzed the business requirements documents against selected programs to

ensure business requirements were met.

worked on IMS online Regions

Prepare low-level specification of modules and processes.

Interacting with the client for clarifications and working as a point of

contact between offshore and onsite

Analysis & Design of Enhancements and bug fixing

Title : SI - MSTAT

Client : Selective Insurance Company of America

Role : Associate

Environment : 0S/390, COBOL, JCL, CICS, DB2, VSAM, FILE-AID, INTERTEST AND

ENDEVOR

Duration : Aug 2003 to Mar 2004

Roles:

Run the Test system cycles based on client request

Conversion from VSAM to DB2

Resolving production abends

Preparing Test procedures/ Test cases for testing.

Analysis, testing and debugging of new code before it promotes to

production

Involved in setting up the test environments.

Moderate Programming in CICS

Developed a manual entry system into an ONLINE application written in CICS-

Web enable approach using DB2 and KSDS files

Developed Batch programs DB2. Created and modified test and production

JCLs/Procs/Parms and provided on-going support.

Title : Client Search Services and Household Reports

Client : State farm Insurance, Bloomington, IL

Role : Software Engineer

Environment : COBOL, TSO, VSAM, DB2, IMS, JCL, FILE-AID, VSAM, XPEDITOR,

ENDEVOR

Duration : Aug 2002 to July 2003

Roles:

Test Case/Results documentation

Coding and testing of Trigger Creation Process

Develop and maintain systems documentation such as design specifications,

user manuals,

Technical manuals, description of application operations, and methodology

documentation.

Analysis, testing and debugging of new code before it promotes to

production

Preparing Test procedures/ Test cases for testing.

Performed analysis and programming for engineering, manufacturing and

financial systems utilizing COBOL, IMS, DB2 and Easytrieve.

Contact this candidate