Resume for DataSatge 3+

Resume for DataSatge 3+

CURRICULAM VITAE

NAME:xxxxxx                                                                                 Address

Objective:

To seek a suitable position in Data warehousing thus utilizing 3+ years of experience in ETL, Data Integration tools like Data stage, DSEE (PX).

Summary:

•  Over 2 years of experience in Data Warehousing (ETL) with extensive experience in DataStage
•  ETL implementation & Development of business applications.
• Worked with AI Financial services
• Expertise Knowledge in all components of Data Stage. 
• Used DataStage6.0 & 7.5 as an ETL tool to extract data from source. Mappings, Transformations and working with sequencer and Batch loads.
• Acquainted in Parallel Jobs processing.
• Implemented the Routines in DS server & PX.
• Worked with Automated Monthly and Nightly loads with Delta data.
• Used DataStage 7.5 as an ETL tool to extract data from source systems to Target system.
• Have good experience in Repositories, like maintaining versions of repositories, managing users and upgrading repositories.
• Designed and developed  reports for DataStage logging  at project level , job level and stages level.
• Involved in writing shell scripts in Linux and calling in DataStage
• Involved in documentation of ETL job designs
• Involved in performance tuning of DataStage jobs at stage level , buffer level and OS level
• Maintained best practices.
• Also have good experience in understanding & creating source and target definitions, Mappings, Transformations and working with Sessions.
• Very good knowledge in Financial Services

Skill Set:

ETL	DataStage6.0/7.5 ,DataStage Parallel Extender
RDBMS	DB2 , Oracle 8.x/7.x, SQL Server, MS-Access
Internet Tech	HTML
O/S	UNIX, Linux, MS- Windows 2000/98, MS Windows NT 4.0.

Professional Experience:

Technologies   Solutions

Jan’2005 to Tilldate

Position: Sr.ETL developer

Ltd

Jul’2003 to Dec 2004

Position: Consultant-ETL

Tech

Feb’2002 to Jun 2003

Position: Warehouse Developer

Project Details:

Vertical Technology Solutions                                                                     (Jan’2005 – till date)

Project 1                                                                                              Jun 2005 – Jan 2006

Client:ADF,Paris.
                        
ADF is building the nation’s largest network to provide wireless personal communications service to 260 million people. ADF was created in 1996 through a joint venture between ADF and three cable television companies, Telecommunications, Inc., Comcast Corp., and Cox Cable

Position: ETL developer.

Responsibilities:

·         Involved in extracting the data from different data sources like Oracle and flat files.

·         Involved in creating DS Repository.

·         Performed transformations like cleansing, scrubbing of the data and loaded the cleansed data

·         Involved in designing to different stages using complex mappings.

·         Involved in the designing delta load using automated Batch jobs.

·         Involved in creating and maintaining Sequencer and Batch jobs.

Project 2                                                                                              Feb 2005 – May 2005

Client: Royal Bank of NL

Position: ETL Developer.

Responsibilities:

·         Analysis of BRDs and design the process document for ETL in DS

·         Involved in ETL design Docs  creation

·         Responsible   for Process documents designing

·         Also Designed DS reports for Control sums Involved in creating and maintaining Sequencer and Batch jobs.

Amazon International Group                                                                       (Jul’2003 –Dec 2004)

Project 3                                                                                              May 2004 – Dec 2004

Client: Rating Express

Position: ETL   Developer.

Responsibilities:

·         Involved in extracting the data from different data sources like DB2, XML and spread sheets.

·         Developed the logic to parse the XML DTD / xsd.

·         Involved in extracting the data from staging sequential files and then to Relational.

·         Involved in designing to different  stages  using complex mappings using XML parsing

·         Involved in the delta load using XML schemas and DTD conventions.

·         Involved in creating and maintaining Sequencer and Batch jobs.

·         Worked on Map stage tools.

·         Involved in writing shell scripts for FTP and calling the scripts in Batch jobs.

·         Developed   Data stage routines and execution.

Project 4                                                                                              Aug2003 – Mar 2004

Client: Risk in Securities

Risk in Securities are the   form of financial analysis on different factor impacting the market. Company is required to report all financial investments in its annual financial statements, and to that end has collected FINANCIAL Investments via Schedule 49 in the SI.

. 

This system would potentially automate the template in the ECO consolidation process

Position: ETL Developer.

Responsibilities:

·         Involved in extracting the data from different data sources like DB2, Oracle and flat files.

·         Involved in extracting the data from staging to Relational.

·         Involved in designing to different stages using complex mappings.

·         Involved in the designing delta load using automated Batch jobs.

·         Involved in creating and maintaining Sequencer and Batch jobs.

·         Involved in data cleansing in key process.

·         Involved in writing shell scripts and calling the scripts in Batch jobs.

·         Involved in production monitoring and analysis of findings.

·         Developed   Data stage routines and execution.

·         Maintaining the ERMT data for Risk Analysis.

.

SwissTech                                                                                                 (April 2002 – Jun 2003)

Project 5                                                                                                    Jun2002-April 2003

Client:SwissLaboratories
Swiss Laboratories has evolved into a diversified health care company that discovers, develops, manufactures and markets innovative products and services that span the continuum of care – from prevention and diagnosis to treatment and cure.

Position: Data Warehouse Designer/ Developer

 

Responsibilities:

·         Prepared load order procedural dependencies on target database.

·         Developed complex Mappings and monitored those mappings.

·         Developed various ETL transformations and PL/SQL program units.

·         Developed Incremental and updateable loading through mappings.

·         Designed reusable transformations and shortcuts to share different mappings.

·         Created and edited multiple sequencers and added them into batch component.

·         Debug, and resolve the loading failures by verifying the log files.

·         Validate the data in data marts after loading process balancing with source data.

·         Resolve the performance issues by using different methods and techniques.

·         Customized data by adding calculations, summaries and functions.

·         Created List Reports, Cross Tab Reports and Drill through reports.

·         Presenting complex data summary report.

·         Created summary and detailed filters.

Personal Profile:

Education                              :               Master of Business Administration

Gender                                  :               Male