Team Lead, Senior ETL Developer

Sudeshna Rajak

**** ****** ***,****** ****, CA **303

Contact: +1-818-***-****

Career Objective: To Acquire a responsible position in order to utilize my

skills and expertise.

Career Highlights:

. 5 years of experience in IT industry.

. End-to-end implementation of projects starting from requirements

gathering, high level designs, on-site co-ordination, integration testing

support and go-live support

. Experience in Onsite-offshore model set up

. Proficient in design and implementation of application integration using

ETL tool

. Extensive experience on DB2 database, UNIX Shell scripts, PL/SQL

. Effective inter-personal communication skills and ability to plan,

organize, and prioritize work to meet deadlines and ensure a high level

of customer satisfaction

. Strong debugging and problem solving skills

. Worked in all phase of SDLC model.

Management Proficiency:

. Personal skills include Strong Communication, Requirements Gathering,

High degree of Initiative, Planning and Excellent Customer Relations

. Excel at communicating with stakeholders to provide accurate reporting

and information regarding the ongoing projects and initiatives.

. Ensuring the delivery from the projects adhered to the appropriate levels

of quality, on time, in accordance with the plan and governance models

. Effective Issues and Risks management with status tracking and compliance

with quality tools and standards.

. Prepare, Baseline project plans including schedule management plan,

change management plan, stakeholder management plan, quality management

plan, and configuration management plan.

. Track Issue Register and Risk Register and publish the updates as and

when necessary to the stake holders.

. Report Customers with exact and precise information during Monthly Review

Meetings with the Executives.

. Experience in coordinating, negotiating resources in support of time line

and IT project deliverables.

Technical Skills:

Packages Microsoft Office Suite (MS Word, MS Excel, Power Point, Outlook), Textpad

Databases DB2, MS-Access, MS SQL Server,Netezza

Platforms Windows XP, Windows 7,Unix, HP-UX

ETL Tool AbInitio, Informatica

Professional Experience:

Role:

Developer / Project Coordinator

Client:

First Data

Description:

The System involves building a Merchant Decision Support System (MDSS) to

improve overall quality and productivity of existing processes and

deploying reliable and accurate information. Extracting data from different

sources like Mainframe, DB2, Oracle, Flat File and transforming the data

based on user requirement using AbInitio's component container and loading

into target, by running the graphs. This information is delivered into

various data marts to formulate analytical information and reporting groups

for generating reports.

Duration:

Jan 2011 - Feb 2014

Team Size:

15

Responsibilities:

o Understand, Analysis, Study and validation of the Business Requirements.

o Design and Developed the Data Model.

o HLD, DLD preparation and review using MS Word and PowerPoint .

o Development of codes.

o Development of mapping logic through PL/SQL programming.

o Co-ordinate between offshore and onsite team.

o Managing and leading the project team.

o Monitoring project progress and performance.

o Creation of Unit Test Scripts and performed the testing.

o Creation of System Test cases and Test scripts.

o Working closely with users to ensure the project meets business needs.

o Definition and management of the User Acceptance Testing program.

o Involved in production rollout activities and warranty support.

Other Information:

Certified in in DB2 UDB V8.1

Role:

Developer

Client:

CITIBANK

Description:

This project is designed to extract the data of the various accounts with

the various roles associated with it. A role here describes a customer

associated with the account no. This project is designed to identify those

roles for an account number with whom CITI can make good business.

This is done by looking at how the customers using the various

services of CITI. When the bank identifies the features used by the

customer, it provides some benefits to the customer keeping in mind that

CITI needs to profit too.

Duration:

Dec 2008 - Jan 2011

Team Size:

8

Responsibilities:

o Requirement analysis and understanding

o Analyze the DTD and interact with the Business Analysts

o Detail Design Document preparation and review

o Perform reviews of the design/code and suggest improvements.

o Ensure the deliverables are delivered within the deadlines.

Education:

. Bachelor's in Computer Science from Calcutta University, India .

Contact this candidate