DURAIMAHARAJ VARATHARAJAN

Email: ad0mnb@r.postjobfree.com

Contact No: +1-646-***-****

SUMMARY OF EXPERIENCE

Overall 13+ Years of Total Experience in the IT Industry and my career objective is to get prominent in the discipline assigned by exploring my skill sets and work to the best of my ability for the benefit of the concern and myself.

Strong Skills in Data warehousing, ETL, Ab initio, UNIX and SQL.

Well versed in E2E Software development life cycle which includes Requirement gathering, Analysis, Estimation, Design, Development, Testing, QA, UAT support, Implementation & Maintenance

Extensively worked on High volume, High complexity data processing, data movement and Automation projects

Holding a Valid H1B VISA and working as an Onshore Technical Manager.

Holding a Valid B1 VISA and travelled to US twice in 2017 and 2019 as Business Analyst/technical designer role for the Purpose of Project Initiation and discussion with Clients on upcoming future scope.

Rich experience of working with Fortune 500 customers & have good exposure on Customer Handling – Client interactions, onsite offshore coordination, working with support team and so on

Addressing project escalations – working on RCA & implementing corrective and preventive actions

Worked on Agile projects - Have good experience on PI planning, sprint planning, story grooming, story point estimation, daily scrums and retrospectives meetings.

TECHNICAL SKILLS

Tools

Ab-initio

Operating Systems

Unix, Windows

Languages

PL/SQL, Shell Scripting

Domain

RLT,BNFS and Telecom

Database

Oracle

PROFESSIONAL EXPERIENCE

Company Name: CAPGEMINI AMERICA INC <From: JUL’23> - <To: Till date>

Project Name

TD Continuance

Client Name

Discover Financial Services

Technology

Ab Initio, Oracle, Unix

Duration

1 Year 3 Months [ till date]

Role

Technical Manager

Team Size

6

Responsibilities:

Designing and developing ETL solutions.

Managing and staffing resources.

Business and Technical discussions/calls with Business Analyst/Clients.

Taking the overall responsibilities for the project deliverables.

Interacting with the Customers, Vendors, End-2-End team, in order to gather more information for Analysis/Design Phase and Providing Solutions accordingly

Providing the technical guidance to the team members on regular basis.

Analyzing complex Abinitio Graphs & optimizing/performance tuning of those graphs as per the Abinitio standards.

Project Description:

TD Continuance team scope is to reduce/decommission the usage of Teradata database. The goal is to Migrate the data and its associated tables which falls under DNA to snowflake DB or Amazon S3 and by doing that the cost will be greatly reduced.

TD continuance team acts as COE which is responsible to Migrate the entire database irrespective of the tables handled by separate data engineering teams.

As it’s a huge step, it’s been initially started by purging the older data from all TD tables by keeping the required data which is only for certain period of time and finally decommission it once all respective data engineering teams moves to SF/S3.

Company Name: ATOS SYNTEL INC <From: JAN’17> - <To: JUN’22>

Project Name

HRT

Client Name

FedEx

Technology

Ab Initio, Oracle, Unix

Duration

6 years 6 Months

Role

Project Technical Lead

Team Size

9

Responsibilities:

Designing and developing ETL solutions.

Taking the overall responsibilities for the project deliverables.

Interacting with the Customers, Vendors, End-2-End team, in order to gather more information for Analysis/Design Phase and Providing Solutions accordingly

Providing the technical guidance to the team members on regular basis.

Analyzing complex Abinitio Graphs & optimizing/performance tuning of those graphs as per the Abinitio standards.

Involved in analysis of requirements & existing programs.

Resolving and analyzing root cause for the production job abends.

Maintaining all the quality related documents.

Making permanent fixes (i.e.) providing permanent solutions to production issues.

Working on the user requested IMRs and providing the resolution on time as per the client requirements.

Project Description:

HRT system is a Legacy Mainframe System with handling Employee, Timecard and Pay Allocations. Scope is to migrate the project from Mainframe to Abinitio. Abinitio Corporation has given the framework by converting the Mainframe code to Abinitio and enhancements were carried out on the differences encountered by comparing both the results of Mainframe and Abinitio.

As of now we are on the way to implement the solutions through Ab initio which we say HRT Modernization by replacing the Legacy System. We are also implementing solutions for various interfaces [Vendor interfaces, Redirects and WDAY integrations] through reports/file generation.

Company Name: ATOS SYNTEL LTD <From: Nov’15> - <To: Dec’16>

Project Name

GCCP

Client Name

AMEX

Technology

Abinitio, Unix and DB2

Duration

1 Year

Role

Project Lead

Team Size

7

Responsibilities:

Involved in Requirements gathering till Deployment.

Preparation of SDLC Documents (Design, Mapping and Component test scripts)

Development of Ab Initio graphs based on business requirements using various AbInitio components

Involved in unit testing and Created unit test case docs and unit test results docs and executed the Components test scripts in QC and raised internal code defects in QC for all the projects that I had developed.

Provided SIT & UAT support, Creating RFC’s and artifacts for code migration to Production environment. Provided warranty support till 3 months from deployment.

Project Description:

Global Corporate Client Profile (GCCP) is the POA system of record for Global corporate clients, Billing Hierarchy, MIS Hierarchy, Products & Client level Limits. This project involves Consolidation and migration of legacy AR Systems to GCCP POA tables.

Company Name: Cognizant Technology Solutions India Private Ltd <From: Jan’14> - <To: Oct’15>

Project Name

GFT App Dev and Maintenance-LRI IRR

Client Name

JPMC

Technology

Abinitio, Unix and Oracle

Duration

1 Year 10 Months

Role

Team Lead

Team Size

4

Responsibilities:

Involving in requirement analysis, design, functional specification, development and deployment of the application.

Coding Ab Initio graphs by analyzing the ETL high level design.

Lead role for development releases.

Impact analysis and performing comparison reports.

Development/Troubleshooting for technical issues

Co-ordination with dependent components across different vendors for the successful end to end delivery of the project

Project Description:

GFT App Dev and Maintenance is the centre core team responsible for development and Maintenance of all applications like LRI, BASEL, CEBRA and IRR.

Liquidity Risk Infrastructure(LRI) which is responsible for reading the incoming files from various source systems, validating them if they are received intact, split/expand them if needed, convert them into CF( Common Framework Layout), Cleanse them per business rules, and finally load them into common framework repository

Company Name: Oracle Financial Services Software Ltd

<From: Dec’12> - <To: Jan’14>

Project Name

ETL COE

Client Name

CITIBANK

Technology

Abinitio, Unix and Oracle

Duration

1 Year 2 Months

Role

Senior Developer

Team Size

6

Responsibilities:

Involving in requirement analysis, design, functional specification, development and deployment of the application.

Preparation of ETL templates by analyzing requirements.

Coding Ab Initio graphs by analyzing the ETL templates.

Performing Impact Analysis for the new/future changes.

Development/Troubleshooting for technical issues

Co-ordination with dependent components across different vendors for the successful end to end delivery of the project

Project Description:

ETL COE (Center of Excellence) is the core team responsible for all ETL related activities in Private Banking .CPB initiated the Project One initiative that contains the client data from the different sources into a centralized database. ETL COE is a data warehousing project that involves data warehousing of data bases. It is the bridge between data warehousing and data bases. ETL fetches the data from the centralized database and providing it to the different applications such as AGS, CSR etc.

So the target of the project is to have RAINBOW (Everything under one roof) i.e. to aggregate various the client data from different sources (PPs) in a central database and provide a single view of clients relationship with the bank.

Company Name: Virtusa India Private Ltd <From: Oct’10> - <To: Dec’12>

Project Name

BT MDM CMF RoBT NAD

Client Name

BT

Technology

Abinitio,Unix and Oracle

Duration

2 Years 2 Months

Role

Developer

Team Size

12

Responsibilities:

Working in Ab-initio, UNIX, Trillium 6.0, XFB and Oracle.

Involving in requirement analysis, design, functional specification, development and deployment of the application.

Development/Troubleshooting for technical issues.

Involved in all phases of the Software development Life cycle.

Co-ordination with dependent components across different vendors for the successful end to end delivery of the project.

Project Description:

MDM CMF( Master Data Management Customer Master File) manages Address and Name data that we receive from Upstream Systems and that we expose to downstream systems. MDM CMF gives 360 degree view of Customer data.

NAD being the location master provides centralised management of Customer Name and Address and online customer validation capability to increase the overall quality and management of BT corporate data. Trillium is used to enrich and improve the addresses from different source systems. The addresses are enriched by referring UK Postal address file (PAF) from Royal Mail.NAD has been identified as a system that needs to be physically split into two separate systems:

OR-NAD – An instance of NAD owned by Openreach and containing only Address data from systems that are in turn owned by Openreach

RoBT NAD – An instance of NAD owned by the Rest of BT and containing only Name and Address data either owned or purchased by BT Retail or BT Wholesale (e.g. Acxiom, BT Retail Billing Names and Addresses)

VISA Details

Visa Type

Visa No

Visa Issued Date

Visa Expiry Date

H1B

R7679848

12/30/2022

05/22/2025

B1

M1566498

03/21/2017

03/16/2027

EDUCATION

Degree

Specialization

Month/Year Of Passing

College Name

University Name

Percentage / Grade

BE

Electrical and Electronics Engineering

April,2010

Dr.Mahalingam College of Engineering and Technology

Anna University

70%

I hereby declare that the information that I have furnished is authentic, and true to the best of my knowledge.

Contact this candidate