Narayana Mail ID: vc4pca@r.postjobfree.com

Mobile: - +91-729*******

3+years of Total IT Experience as ETL Developer.

Extensively used ETL methodology for supporting Data Extraction, transformations and load processing in a corporate-wide-ETL Solution using DataStage PX 7.5 and IBM Websphere 8.0.1

Involved in development phases in Websphere Integration tool DataStage Parallel Extender and Server Jobs.

Extensive knowledge in Data warehousing concepts.

Co-ordinate with the team and provide support to resolve technical issues.

Involved in Unit Testing & System Testing.

Educational Qualifications:

MCA (Master of Computer Application) from Kakatiya University.

Experience Summary:

Working as an ETL Developer at CSC, Chennai from Aug 2009 - Till Date.

Worked as an ETL Developer at Accenture Services Pvt.Ltd, Pune from May 2007 to July 2009.

Technical Skills:

ETL Tools : DataStage 8.0.1 and DataStage PX 7.5

RDMS : Oracle 9i, MS Access

Operating System : Windows XP, 2003 Server, UNIX

Office Tool : MS Office 2003 and 2007

Career Profile:

Project #1

Title : EDWC (Credit Application)

Client : Target Corporation, Minneapolis, USA

Role : ETL Developer

Environment : DataStage 8.0.1, Oracle

Duration : Aug 2009 to till date

Description:

Enterprises Data Warehouse – Credit is Target’s enterprise data warehouse for Target Credit Cards. The EDW-C will address TFS needs for reporting and Credit analytics elated requirements.

The TFS business areas need access to near-real time data and historical data to perform reporting and analytics. By developing a new data warehouse and data marts utilizing REDW data model, the TFS business areas would have ability to access Target VISA and Target Card (after completion of RUBY) data using business intelligence tools supported by TTS. This solution would continue to give TFS users the necessary business intelligence tools and data to perform strategic ad-hoc analysis and monthly reporting. This solution also supports TTS direction of using the REDW data model.

Responsibilities:

Analyzed the specification document.

Giving solutions to the customer based on the requirements.

Involved in extracting the data from source tables.

Developed Jobs using various Stages in DataStage Designer.

Constructing containers for repeated task to simplify the developer task.

Involved Unit testing and System Testing.

Developed Sequence and used different Stages according to the requirement.

Project #2

Title : Sales Business Intelligence system (SBIS)

Client : Classic Foods INC, USA

Role : ETL Developer

Environment : DataStage PX 7.5, UNIX, Oracle 9i

Duration : Jan 2008 to Jul 2009

Description:

Classic Foods Inc, USA. It is one of the MNC’s having number of stores and it sells various numbers of products. The Database has lots of historical data. So data warehouse plays a major role in enabling various stores to view the data at a lowest level and help them to make decisions to identify user data from all data sources on diversified systems. This System gives the ability to access, analyze and share information in the company’s database. Created Enterprise Business model after gathering system information and understanding business aspects.

Responsibilities:

Involved to prepare ETL Specification for developing Jobs.

Understanding the business model and customer requirements.

Giving solutions to the customer based on the requirements.

Using DataStage Designer to design the ETL jobs.

Involved in the integration of data from source to ODS and from ODS to data mart.

Sequence the jobs according to the requirement.

Used Job Control and job Sequencer to run the jobs by using parameters.

Involved in Error Handling.

Involved in Unit Testing, Integration Testing and so.

Error handling is done while loading the data from ODS to target.

Project #3

Title : Sales Ware House

Client : Network Appliance, USA

Role : Trainee

Environment : DataStage PX 7.5

Duration : May 2007 to Dec 2007.

Description:

The main objective of this project is to find the information about sales of the Net App and also This project is used to calculate the how many times we retained our promise by supplying products to the customers in time and also calculated how many times we failed by not sending products to the customers in time. Here we need to maintain the data about customers, orders, products, time and store.

Responsibilities:

Developed jobs using various Stages like Transformer, Aggregator, ODBC, Hashed Files and Sequential Files etc.,

Run the jobs With help of Director See View Logs

Constructing Local Containers, Transformations and Functions for repeated task to simplify the developer’s task.

Used Job Control and Job Sequencer to run the job by using parameters.

Involved to Compiling, Validating, Running and scheduling the jobs using the Data Stage Client tool i.e. Director.

Involved in Performance tuning techniques

Involved in Unit testing, System testing

Contact this candidate