Project Developer

Mobile: +1-602-***-****

E-mail: ********@*****.***

Summary

●Suresh Babu is an ETL Abinitio developer with over 9 years of IT experience. He possesses strong analytical and technical skills. He has good exposure in developing ETL applications using Ab Initio, DB2 and UNIX shell scripting.

●Experienced in interacting with the Business Analysts, identifying the needs, requirements of the system and developing technical documentation and high/low level design documents.

●Experienced in Onshore/Offshore working model and assist team in completing the tasks on time.

●Experienced in providing support to production issues through bridge call, coordinating with multiple dependent team to fix the issue.

●Excellent working experience in Incident, Problem and Change management.

●Expert in creating ad-hoc processes for issue circumvention, data collection and analysis.

Technical Skills

●ETL & BI TOOLS : Ab Initio (GDE 3.3.5, Co>operating System 3.2.7)

●LANGUAGES : SQL, Unix Shell Scripting

●OS : Microsoft Windows, UNIX, Linux

●DATABASES : SQL,DB2

●OTHER UTILITIES : Quality Center, MSSQL, Control-M, Service Now, STEP-Workbench.

Project Profile

Project Title 1 : AMEX

●Duration : April 2015 – Till date

●Location : Phoenix, Arizona (since June 2017)

●Operating Systems : Windows, UNIX.

●Technology/Tools : Ab Initio 3.2.7 GDE 3.3.5,Unix,DB2.

Project Title 2 : THD Merch Support Offs

●Duration : June 2014 – April 2015

●Location : Chennai

●Operating Systems : Windows, UNIX.

●Technology/Tools : Ab Initio 2.15 GDE 3.1.2,Unix,DB2,STEP-Workbench.

Project Title 3 : Capital One EDS

●Duration : November 2011 – June 2013

●Location : Chennai

●Operating Systems : Windows, UNIX.

●Technology/Tools : Ab Initio 2.15 GDE 1.15,Unix,Teradata.

Client Description

●The American Express company is an American multinational financial services corporation which is best known for its credit card, charge card and traveler’s cheque businesses. Amex cards account for approximately 24% of the total dollar volume of credit card transactions in US.

●The Home Depot is the world’s largest home improvement speciality retailer and the second largest retailer in the United States. The company employs approximately 325,000 associates and has 2200 stores in 50 states, the District of Columbia, Puerto Rico, 10 Canadian provinces and Mexico.

●Capital One Financial Corp is a U.S.-based bank holding company specializing in credit cards, home loans, auto loans, banking and savings products. A member of the Fortune 500, the company helped pioneer the mass marketing of credit cards in the early 1990s, and it is now the fourth-largest customer of the United States Postal Service and has the fifth-largest deposit portfolio in the United States.

Education

●Bachelor’s Degree (B.E) in Computer Science and Engineering.

(Seethaiammal College of Engineering - 2010) – Anna University

Employment History

Name of the Company

Designation

Employer Address

From

To

Duration

Atos SYNTEL Ltd.

Tata Consultancy Services

(Payroll: Clairvoyant Tech Soft Private Ltd)

Cognizant Technology Solutions

Associate Consultant

Systems Engineer

Programmer Analyst

13430 N Black Canyon Hwy #280, Phoenix, AZ 85029

Digital Zone, No. 79, IT Highway, Karapakkam

Chennai - 600096

OMR road, 5/639 Chennai – 600096

April 2015

June 2014

February 2011

Till date

April 2015

July 2013

5.7 years

10 Months

2.5 years

Work Experience

Project # 1:

Project : Global Corporate Client Profile – L2

Client : AMEX, USA

Role : ETL Developer

Duration : June 2017 – Till date

Tools : Ab Initio, Unix, DB2, Control-M and Service Now.

Project Description:

The main objective of GCCP -L2 is to bring development and operations organizations closer together to speed up time to market. It does this by focusing on the people, process, capability and infrastructure used by technology teams.

As part this project, the problem records raised by Level 1 support team for frequently occurring issues/incidents in Amex-GCP DTU application has to be fixed and ensure to tune the production activities. Interact with client’s business team to identify and fix the processes, Design Gaps and to find the RCA and notify the Development team not to occur such scenario again.

Responsibilities / Activities:

●Have involved analysis, coding, testing, Implementation.

●Effectively leading offshore team and delivering all installs on time.

●Enhancing the existing functionality by making changes to the programs.

●Involved in the enhancement activities based on the requirement.

●Responsible for analysis of the service requests, problem identification and fixing the root–causes.

●Maintain application level SLA and report to business and leadership.

●Manage relationships with vendors, development team and business partners to ensure Service delivery targets are achieved.

●Provide 24 Hours / 7 days a week on-call support to Operations to help them resolve production or System problems relates to application.

●Involved in giving code walkthrough to Production support team.

●Have guided the L1 resources to get the knowledge on applications.

Project # 2:

Project : Pegasus JAPAN Data file migration and CM Masking

Client : AMEX, USA

Role : ETL Developer

Duration : April 2015 - June 2017

Tools : Ab Initio, Unix, DB2, Control-M and Service Now.

Project Description:

The main objective is to deliver Unbilled transactions/ profile information to the End users (Corporate card users) on their request in the form of files/reports in Japanese file format. The requests are posted through the Web tool in GIDM and after processing them, they are sent back to the end users via the stratus/CIW.

As part of Pegasus JAPAN Data file migration project, JAPAN markets have been migrated from the legacy AR platform to Globestar.

Responsibilities / Activities:

●Have involved analysis, design, coding, testing, implementation and warranty support of the project.

●Effectively leading Pegasus JAPAN GDFS team from offshore and delivering all installs on time.

●Developing the new functionality/ enhancing the existing functionality by making changes to the programs.

●Involved in the enhancement activities based on the requirement.

●Deliver technical solution to problems identified through incidents and problems.

●Enable service restoration activities, including availability to join restoration bridge calls during off hours (24/7 on call support).

●Identifying and communicate work around for production issues to ensure business continuity and customer satisfaction.

●Monitor database maintenance activities such as backup, reorg, runstats.

Project # 3:

Project : THD Merch Support Offs, Tata Consultancy Services

Client : The Home Depot, USA

Role : Developer

Duration : June 2014 to April 2015

Software : Ab Initio, Unix shell scripting and DB2

Project Description:

The main objective of the project is to develop new processes to manage Item Data in a more effective way which would result in an Item Master which houses quality data to be used in multiple downstream processes and by multiple business units and geographies

Responsibilities / Activities:

●Development using Ab Initio, UNIX and Maintenance and support using STEP Workbench.

●Developed 2 graphs for Item Data Validations.

●Providing support for Item Data Management.

●Understanding of business & various applications.

●Providing multiple technical and functional approaches.

Project # 4:

Project : ESCRA Phase I & II Enhancement Project

Client : CAPITAL ONE, USA

Role : Tester, Developer

Duration : June 2012 - July 2013

Software : Ab Initio, Unix shell scripting and Teradata

Project Description:

The main objectives of the project is to receive the signal files from the chordiant server and generate the clean file after performing data quality checks and load the clean file to stage table and from stage table to main table.

Responsibilities / Activities:

Development using Ab Initio, SQL, Unix

●Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components like Reformat, Join, Sort, Rollup, Normalize, Assign Key and Partition components.

●Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Pset, XFR, deployed scripts and DBC files for connectivity.

●Developed wrapper scripts to periodically notify users in case of any failures with debugging information.

●Understanding of business & various applications.

●Providing multiple technical and functional approaches.

●Interact with the Clients/Onsite coordinator, to get the System Requirements to cover the functionality, mode of operation, technical issues and scope of work.

●Requirements analysis and Design.

●Preparation of Unit test plans.

●Production implementation & Post implementation support.

Project # 5:

Project : ECR Enhancement Project

Client : CAPITAL ONE, USA

Role : Developer

Duration : Jan 2012 - June 2012

Tools : Ab Initio, Unix shell scripting and Teradata

Project Description:

3 streams text files will be received on EDE and then these will be transferred to DDE. Data validations and data quality checks will be performed on DDE platform and clean files will be created. The clean files will undergo some transformations and then these will be loaded into main table. Initially the data will be loaded into stage tables and then into main tables.

Responsibilities / Activities:

Development using Ab Initio and shell scripting

●Requirements analysis and Design.

●Developed 3 graphs and 3 psets and done validations for the addition of new fields as per requirement.

●Preparation of Unit test plan.

●Interact with the Clients/Onsite coordinator, to get the System Requirements to cover the functionality, mode of operation, technical issues and scope of work.

●Production implementation & Post implementation support.

●Ensure that the Production problems are resolved within SLA.

Declaration

I hereby declare that the above furnished details are true to the best of my knowledge and belief.

Date:

Place: Phoenix (Suresh Babu T)

Contact this candidate