SUMMARY

A growth driven self-motivated Datastage / Mainframe Analyst with over 10+ years of progressive experience in the Business Information Management sphere. Offering a rich mixture of business and technical expertise in Mainframe, ETL and reporting, lineal to the Banking / Financial and Insurance domain. A track record in consulting, requirement analysis, designing, developing, testing, integrating and implementing novel end-to-end Business solutions, aligned with critical business requirements, under stringent deadlines, for ace business corporations.

PROFESSIONAL EXPERIENCE:

10+ years of working experience for Tata Consultancy Services both at onshore and offshore in various capacities.

Working as a Technical Lead of 5 (1 Onshore, 4 offshore) member team for the EIB -Life ETL (Mainframe/Data Stage) Team from March ‘16 to till date based out of Charlotte, NC and Syracuse.

Experienced in Full Life Cycle Development of building a Operational Data Store for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation.

7+ years of working experience in Mainframe – TSO, COBOL, JCL, PROC, REXX, VSAM, CICS, DB2, NDM in the Operational Database Applications.

3+ years of experience in Data analysis and Design using IBM WebSphere DataStage 11.5/9.1/8.7/8.5 (Designer, Director and Administrator), DataStage Plug-In, ETL, Data mart, OLAP and OLTP. Strong design experience to independently turn Physical Data Model into DataStage job design.

Very strong experience with various migrations, upgrade and acquetions projects in Mainframe and DataStage.

Experience in supporting multiple applications and integration.

Extensively Worked on Job Sequences to control the execution of the job flow using various activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities

Extensively worked on Parallel Jobs using Various Stages like Join, Lookup. Lookup File Set, Change Capture, Filter, Funnel, Copy, Sort, File set, Sequential File, Data set, Oracle Enterprise, Merge, Aggregator, Remove Duplicate Stages, Pivot Stage, Stored Procudure stage, CFF Stage.

Good experience in the Conversion projects, Data migrations and Mainframe to ETL technology transformation projects.

Good experience with Client Interaction, Onshore – Offshore working model.

Quick learner with excellent analytical and problem solving skills.

Good interpersonal, written and verbal communication skills. Multilingual, highly organized, detail-oriented professional with strong technical skills.

Passionate about all aspects of the software development life-cycle, from design through development, deployment, Production Support and Data Quality & Data Management.

COMPUTER SKILLS

Operating Systems

IBM Mainframe Z/OS,Unix,Win95/NT/2000/XP,

Languages/Scripting

COBOL,JCL,Eazytrieve,Unix Shell Scripting,SQL,PL/SQL

Database

IBM - DB2/IMS,Oracle 11g

Mainframe Supporting Tools

FILE-AID, FILD, DB2I, Spufi, SDSF, Change-Man, Endevor,

Expeditor (batch and online), Abend-Aid, SAR,

CA7,QMF, NDM,FTP

ETL Tools

IBM Info Sphere Data Stage 8.7((Administrator, Manager, Designer, Director), Tectia Terminal and File Transfer,XML Spy,TFS,Eclipse

Other Tools

Microsoft Visio, Ultra Edit, Clear Case IBM Data Studio 3.1,TOAD for DB2, SQL Developer for Oracle, Quality Center, Maximo,Remedy,SharePoint CHANGEMAN,CA7,NEXUS

Methods

Waterfall Model, AGILE

Domain Experience

Insurance, Banking and Finance Services, Retail

CERTIFICATIONS\TRAINING DONE

Certifications

Database

IBM Certified Application Developer - DB2 9

ETL

IBM Certified Solution Developer - Info Sphere DataStage v8.5

SAS

SAS certified Base programmar for SAS 9

Employment Details

Employer

Start Date

End Date

Tata Consultancy Services

17 May 2007

Till Date

EDUCATION

Bachelor of Engineering in Electronics and Communication Engineering from Anna University, Chennai (2002-2006).

PROFESSIONAL EXPERIENCE:

Employer : Tata Consultancy Services

Client : AXA Equitable/Charlotte, USA Aug ‘16 – till date

Project : EIB – Middle ware – DOL project

Role : Data Analyst / Technical Lead

Hardware : Windows XP/UNIX Platform

Languages : UNIX Scripting

Database : Oracle

Special

Software : IIS DataStage 8.7, Autosys/CA7, Tectia Terminal and File Transfer,

Designer, Director, TFS, SQL Developer, Visio 2.0,Ecilpse,Splunk

Description:

In support of AXA’s corporate vision, Ambition 2012 emerged with associated initiatives. The Life 2012 New Business project is an important strategic business initiative in support of Ambition 2012. Synthesizing the operations and processes will enable enhanced speed to market, flexibility to accommodate almost any business model, reduced costs via operational efficiencies, improved ease of doing business with AXA Equitable through Timely customer communications and Enhanced customer service.

Responsibilities:

Working with client and IT management and staff to establish and maintain consistent data element definitions across computing environments

Working with Business Analysts, Solutions Architects, and Systems Analysts to design solutions for clients

Create/Refine technical specifications.

Analyzing and developing the logical data designs, data models.

Defining the data validation rules / standards

Understanding the data requirements, data types, possible values and understand the structure of data in Web service

Identifying the ACORD XML tags/JSON structure for each of the new data elements

Creating Request Data Mapping for the identified data elements with transformations for Real time interface

Creating the Response Data Mapping for the identified data elements with transformations for Real time interface

Creating the Data Mapping for all new data elements with transformations for batch interface

Working with the middleware and application teams to address all the Data Quality & Data Integration issues

Creating sample Request XML/JSON Request for Real time interface

Creating sample Response XML/JSON Response for Real time interface

Create sample Request XML for batch interface

Create SID for real time interfaces

Create BID for batch interfaces

Review the Data Mapping and BID/SID with the middleware and application teams

Producing the necessary documents to ensure transition to support team once development is complete

Employer : Tata Consultancy Services

Client : AXA Equitable/Charlotte, USA March ‘16 – August’16

Project : EIB - Life

Role : Technical Lead/ Senior developer

Hardware : Data stage, Mainframe,Windows XP/UNIX Platform

Languages : COBOL, Eazytrieve,UNIX Scripting

Database : DB2/IMS

Special

Software : Mainframe, COBOL/DB2, JCL, CA7, FILD, FILAID, SAR, SDSF, SPUFI,

CICS, MAPs, NDM, Change-man IIS Data Stage 8.7, Autosys/CA7,

Tectia Terminal and File Transfer, Designer, Director, TFS, SQL Developer,

Visio 2.0, Eclipse, Splunk

Description:

In support of AXA’s corporate vision, Ambition 2012 emerged with associated initiatives. The Life 2012 New Business project is an important strategic business initiative in support of Ambition 2012. Synthesizing the operations and processes will enable enhanced speed to market, flexibility to accommodate almost any business model, reduced costs via operational efficiencies, improved ease of doing business with AXA Equitable through Timely customer communications and Enhanced customer service.

Responsibilities:

Involved in understanding the existing system process and providing a suggestion for redesigning the existing process and finding an opportunity for Performance tuning in jobs.

Requirements gathering from business analyst and creating technical specifications.

Active participation in decision-making and QA meetings and regularly interacted with the Business Analysts & development team to gain a better understanding of the Business Process, Requirements & Design.

Developed Mainframe online / batch jobs in COBOL, JCL, CICS to extract, process and load the data in the Enterprise data warehouse and send custom reports back to Clients

Created Common module and routines to get better performance and reusability

Extensively worked on Production Job migration, scheduling and monitoring

Retrofit to every platform that is currently under release and also migrate all new changes through the pipeline

Propagate the changes across all release platforms. Planning and execution of batch processes for the release for every business requirement and applications involved.

Testing Region preparation before each testing phase. Migration of the job/schedule changes to productions

Finding route cause for every failure and fixing the job before next batch run.

Interaction with upstream application to set the expectation and dependencies for every project.

Performed ETL coding using Datasets, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign Data Stage jobs for performing the required integration.

Used Quality stages for enrich data to meet business objectives and data quality management standards.

Imported table/file definitions into the Data stage repository.

Controlled jobs execution using sequencer, used notification activity to send email alerts.

Involved in code review, Unit/UAT test Case preparation and maintained the data validation

Created standard process document to future reference of the project.

Employer : Tata Consultancy Services

Client : Bank of America/Charlotte, USA Feb ‘15 – Feb’16

Project : Reference Data systems

Role : Technical Lead /Senior developer

Hardware : Data stage, Mainframe, Windows XP/UNIX Platform

Languages : COBOL, Eazytrieve, UNIX Scripting

Database : DB2/IMS,Oracle

Special

Software : Mainframe, COBOL/DB2, JCL, CA7, FILD, FILAID, SAR, SDSF, SPUFI,

CICS, MAPs, NDM, Change-man IIS Data Stage 8.7, Autosys/CA7,

Tectia Terminal and File Transfer, Designer, Director, TFS, SQL Developer,

Visio 2.0, Eclipse, Splunk

Description:

Bank of America has diverse enterprise application servicing the various Lines of Business like Consumer Real Estate, Deposits, Ecommerce, Card Solutions and Transaction Services.

Statement and Pricing (SPX) :

SPX stands for Statements and Pricing .It is the system of Record for Combined Statement ( CS) and Relationship Pricing (RP) .

WCC (Web Sphere Customer Center):

WCC is based on IBM’s Master Data Management (MDM) product which is real time, transactional Customer Data Integration (CDI) software product . It maintains consistency of data and provide a 360- degree view of customer information through the WCC Hub.

FFD (Federated Financial Data store ):

Federated Financial Data store system is an Account repository that provides a single enterprise view of the Accounts of the customers with Bank of America.

Global Access ID (GAI/GAID) :

GAID is the centralized authentication and entitlement system for customer facing channels of the Bank such as online banking, VGS, .com and PFM (Quicken,QuickBooks,Microsoft Money).

CNE (Customer Notification Engine) :

CNE stands for Customer Notification Engine. CNE support around 30 channels across the bank to generate alert notifications to customers in format of email Text & HTML, SMS and Mobile PUSH notifications . CNE stores notification preferences that customer enrolls from online banking screen.

OFR ( Offer Federated Repository) :

Offers Management manages the life cycle of offeres from the moment BANA considers creating them, to the pont where they have expired and are no longer of interest in determining new offers to create . Offers management provides the fron door to decisioning process for all channels and line of business at the bank. The WCC Offer project is to migrate offers data from KTC to the WCC target system and enable data access and feeding activites to support offer management applications.

Federated Relationship Data store (FRE) :

FRE is a federeated application designed to store and retrieve high priority relationship,risk,privacy and house hold profitability information at the customer level for operational clients . FRE is also repository for the customer document indexes which are retrieved by online banking to display in the statements and document link for the customers .

Responsibilities: .

Responsible for reviewing functional specifications and preparing technical design framework for Mainframe. Interacted extensively with client/onsite team to resolve technical and infrastructural issues.

Create/Review LLD & HLD documents as per the requirements specification.

Interacted with Business Partners to understand the business requirements, Analyze and design the integration Approach.

Performed Mainframe coding using COBOL/DB2, JCL and Eazytrieve.

Used CA7 Scheduler to schedule and execute the jobs based on the schedule.

Used SDSF/SAR to run and monitor status of the jobs.

Planning and execution of batch process for the release for every business requirement and application involved.

NDMed the files usig NDM utitilites and File Transfer using FTP

Involved in Performance Tuning and Enhancement.

Documented test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Used Autosys job scheduler for automating the regular BAU Callendar schedule cycle in both production and UAT environments.

Coordinating with Release Management, Data Management and Configuration Management.

Responsible to apply retrofit to every platform that is currently under release and migrate all new changes throght the pipeline.

Region prepartion before each testing phase.

Migration of components/schedule changes to production

Contionus enhancement and optimization of the batch execution

Finding route cause for every failure and fixing the job before next batch run

Employer : Tata Consultancy Services

Client : Bank of America/Texas, USA Mar‘12 – Jan’15

Project : AV054-BOA-CARD-OPTIMUS-FP-US

Role : Technical Lead

Hardware : Datastage,Mainframe, Windows XP/UNIX Platform

Languages : COBOL, UNIX Scripting

Database : DB2/IMS,Oracle

Special

Software : Mainframe, COBOL/DB2, JCL, CA7, FILD, FILAID, SAR, SDSF, SPUFI,

CICS, MAPs, NDM,Change-man,IIS DataStage 8.5, Autosys, Tectia Terminal and

File Transfer, Designer,Director, Quest Central, SQL Developer, Visio 2.0,Clearcase

Description:

Bank of America has diverse enterprise application servicing the various Lines of Business like Consumer Real Estate, Deposits, Ecommerce, Card Solutions and Transaction Services.

The Project involves Analysis, Design and Development of Technical Solutions to Cards

Authorization application of Bank of America, which operates on Mainframe technology.

The Authorization application is mainly a batch application running in mainframe environment.

Responsibilities:

Involved in analyzing the existing mainframe programs and creating the Requirement documents.

Performed Mainframe coding using COBOL/DB2, JCL and Eazytrieve.

Used CA7 Scheduler to schedule and execute the jobs based on the calendar schedule.

Used SDSF/SAR to run and monitor status of the jobs.

Responsible for reviewing functional specifications and preparing technical design framework for ETL. Interacted extensively with client/onsite team to resolve technical and infrastructural issues.

Review LLD & HLD documents as per the requirements specification documents.

Interacted with Business Partners to understand the business requirements, Analyze and design the integration Approach.

Performed ETL coding using Datasets, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign DataStage jobs for performing the required integration.

Used DataStage Designer tools for creating Parallel jobs and importing and exporting the jobs.

Used DataStage Job Sequences to execute the jobs in a sequence order.

Used Quality stages for enrich data to meet business objectives and data quality management standards.

Created DataStage Jobs to build business rules to load data.

Used DataStage Director to run and monitor status of the jobs.

Imported table/file definitions into the Data stage repository.

Controlled jobs execution using sequencer, used notification activity to send email alerts.

Involved in Performance Tuning and Enhancement.

Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.

Used Autosys job scheduler for automating the regular BAU Calendar schedule cycle in both production and UAT environments.

Coordinating with Release Management, Data Management and Configuration Management.

Ensure technical relationships with third party vendors.

Support Bank’s acceptance testing needs.

Conduct the Weekly Status meetings with onshore and offshore Teams.

Employer : Tata Consultancy Services

Client : Bank of America/Charlotte, USA April ‘11 – Feb’12

Project : AV054 – Products AMS – Time Deposits

Role : Technical Lead

Hardware : Mainframe, Windows XP/UNIX Platform

Languages : COBOL, REXX

Database : DB2,IMS/IDMS

Special

Software : Mainframe, COBOL/DB2, JCL, CA7, FILD, FILAID, SAR, SDSF, SPUFI,

CICS, MAPs, NDM, Change-man

Description:

Bank of America has diverse enterprise application servicing the various Lines of Business

like Consumer Real Estate, Deposits, Ecommerce, Card Solutions and Transaction Services.

The Project involves Analysis, Design and Development of Technical Solutions to Time

Deposits application of Bank of America, which operates on Mainframe technology.

The Time Deposits systems offeres a wide range of features and functions to support Bank of

America CD/IRAs products and services .

The Time Deposits application is mainly a batch application running in mainframe

environment .

Responsibilities:

Involved in Analyzing the existing mainframe programs and creating the Requirement documents.

Performed Mainframe coding using COBOL/DB2, JCL and Eazytrieve.

Used CA7 Scheduler to schedule and execute the jobs based on the calendar schedule.

Used SDSF/SAR to run and monitor status of the jobs.

Responsible for reviewing functional specifications and preparing technical design framework for ETL. Interacted extensively with client/onsite team to resolve technical and infrastructural issues.

Review LLD & HLD documents as per the requirements specification documents.

Interacted with Business Partners to understand the business requirements, Analyze and design the integration Approach.

Coordinating with Release Management, Data Management and Configuration Management.

Ensure technical relationships with third party vendors.

Support Bank’s acceptance testing needs.

Conduct the Weekly Status meetings with onshore and offshore Teams.

Participate in Disaster recovery process.

Lead the offshore Time deposits team

Employer : Tata Consultancy Services

Client : Bank of America/Charlotte, USA Nov ‘09 – Mar ‘11

Project : Batch strategic Service

Role : Technical Lead /Team Member

Hardware : Mainframe

Languages : COBOL, Eazytrieve,JCL,REXX

Database : DB2/IMS/IDMS

Special

Software : Mainframe, COBOL/DB2, JCL, CA7, FILD, FILAID, SAR, SDSF, SPUFI,

CICS, MAPs, NDM, Change-man

Description:

Bank of America offers credit cards and services to the members of professional, academic, sports and personal interest groups through endorsed marketing. The credit card for a nurses’ organization, alumni association, NASCAR, etc. is the product of this endorsed marketing. The endorsing organizations are referred to as “affinity groups”.

Credit cards issued by Bank of America also bear the logo of the Associations (Visa, MasterCard or American Express). Through Bank of America's authorization systems we enable customers to make purchases at merchants worldwide. Visa, MasterCard and American Express provide the network that allows a charge to go through.

Bank of America actually issues the credit card products and sets account fees or interest rates. Bank of America’s packages of products, services and fees are specific to each affinity group.

Bank of America maintains customer accounts, generates customer statements and provides customer support services.

Processing of credit card transactions incorporates interfaces between the Associations and Bank of America. Mainframe, batch processes handle core processing at Bank of America.

This network includes systems for clearing the process that allows a charge to be posted on a Customer’s statement and settlement, the process that allows Bank of America to pay the merchant’s bank.

Below are the major cards applications.

Warehouses – Input Systems

National Systems

VI Issuer Update

Direct Debit

PSI

601/650

FM

Renames

Post FM

Statements

Letters

Settlements

Comments

Source

Responsibilities:

Develop new JCL, PROC's, PARM's and CA7 as requested by applications team

Creation / Implementation of NDM & FTP processes.

Update and verify JCL from developers for new releases, independent initiatives and IPT SIT, Retro-fits, based on received requests.

File fixes

JCL moves

Special overrides

Run Time Improvement/Automation

CA7 Scheduling Exceptions

Update JCL, PROC’s and Parms for abend resolution

ABENDS – reruns and restart

Contention Resolution

Performance improvements

Conducting Reviews of Software artifacts

Conducting FI for the assigned Projects

Creation and assignment of tasks to the team members and delegation of work for timely completion.

Using IPMS for all project management related quality activities.

Performing configuration management.

Lead the off shore team

Employer : Tata Consultancy Services

Client : Nielsen/Green bay,Wisconsin, USA Nov ‘08– Oct’09

Project : MIPS Reduction (RTI)

Role : Technical Lead /Team Member

Hardware : Mainframe programmer

Languages : COBOL,Eazytrieve,JCL,REXX

Database : IMS DB/DB2/IDMS

Special

Software : Mainframe, COBOL/DB2, JCL, CA7, FILD, FILAID, SAR, SDSF, SPUFI,

CICS, MAPs, NDM,Change-man

Description:

The project MIPS Reduction project involves analysis, Design and Enhancement of an existing code with run time efficiency. We have analyzed the existing codes which is taking

more CPU time in run time and provide solution to minimize the CPU time.

Responsibilities:

Discussions with RMS Nielsen team based on the System Requirements Document to cover the functionality with reduced CPU time, operationally, technical issues and scope of work

Coding

Testing

Code Review

Employer : Tata Consultancy Services

Client : Nielsen/Green bay,Wisconsin, USA May ‘07– Oct’08

Project : Master Close Automation (MCA)

Role : Programmer /Team Member

Hardware : Mainframe

Languages : COBOL,Eazytrieve,JCL,REXX

Database : IMS/DB2

Special

Software : Mainframe, COBOL/DB2, JCL, CA7, FILD, FILAID, SAR, SDSF, SPUFI,

CICS, MAPs, NDM,Change-man

Description:

The project Market Close Automation (MCA) involves analysis, design and development of an automation system for Masters Application of Nielsen. MCA is an ongoing project to automate the store placement, Q-file and locking process which is currently done through manual effort. This onsite-offshore project involves total effort of 8 months. The project team consist of 6 members in offshore and three members in onsite.

Responsibilities:

Involved in Analyzing the existing mainframe programs and creating the Requirement documents.

Performed Mainframe coding using COBOL/DB2, JCL and Eazytrieve.

Used CA7 Scheduler to schedule and execute the jobs based on the callendar schedule.

Used SDSF/SAR to run and monitor status of the jobs.

Responsible for reviewing functional specifications and preparing technical design framework for ETL. Interacted extensively with client/onsite team to resolve technical and infrastructural issues.

Review LLD & HLD documents as per the requirements specification documents.

Interacted with Business Partners to understand the business requirements, Analyze and design the integration Approach.

Coordinating with Release Management, Data Management and Configuration Management.

Ensure technical relationships with third party vendors.

Support Bank’s acceptance testing needs.

Conduct the Weekly Status meetings with onshore and offshore Teams.

Participate in Disaster recovery process.

Lead the offshore Time deposits team

Personal Details

Date of Birth May 11, 1984

Sex Male

Nationality Indian

Marital Status Married

Designation Assistant Consultant

Location Charlotte, North Carolina

Visa Details H1B

Visa Start date - 27 Mar 2012

Visa End date - 07 Jan 2019

Driving License Available

Mobile No 980-***-****

Mail id ac2ak0@r.postjobfree.com

Contact this candidate