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 and Insurance 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

Confidential,Omaha, NE Role : Exstream Analyst/Developer

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

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

Confidential,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)
Confidential
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
Confidential
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
Confidential
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
Confidential
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

Confidential,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.