Design Customer
Resume:
RAGHURAM YELLANKI
IBM Certified Consultant
Phone: 309-***-****
****************@*****.***
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