Reume for ETL Developer (Data Stage)

Reume for ETL Developer (Data Stage)

                                                               

 Name :

 

Professional Summary :

           

·         Overall 3.2 years of total IT experience out of which 2+ years of experience as ETL Developer using DataStage Parallel Extender and  1 year experience as SAS programmer.

·         Involved in performance tuning of DataStage jobs at stage level , buffer level.

·         Applied multiple lookups using lookup file set.

·         Used DS manager for nodes creation and dataset management.

·         Good knowledge in data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables

·         Implemented Local containers for same job and shared containers for multiple jobs, which have the same business logic.

·         Good domain knowledge in Finance.

·         Worked with Delta data.

·         Performed various activities like import and export of Data Stage Projects.

·         Unit Testing & Integration testing

·         Good Knowledge in Oracle9i

Skill Set

 

ETL Tools                  : DataStage 7.5 , Datastage 7.5x2

Operating Systems   : MS-DOS, Windows-98/2000/NT/XP, Unix.

Database                   : Oracle 8i, MS-Access, SQL Server 2000.

Languages                 :  SAS 8.0(Base SAS, SAS Access, SAS STAT,SAS EG3.0 )

Designing Tools         : HTML, Java Script, XML

Education

 

·         MCA  with First Class from  Acharya Nagarjuna University

Experience Summary

 

• Working as a ETL Developer

Company  : Satyam Computers, Secunderabad

      Duration     : Feb’ 2006 to Till Date.

• Worked as a SAS Programmer

Compamny :  SLG Technologies., Bangalore

Duration      : Dec’ 2004 to January 2006.

Professional Experience

 

   Projects  

      

#1 Name                    : IBS                                                  Oct’ 2007 – Till Date

     Client                     : RBC

     Team Size              : 5

     Environment         : DataStage7.5X2, Oracle 9i,Unix and Windows 2003.

Description:

 Royal Bank of Canada  has 70,000 full-and part-time employees serving 15 million clients through offices in North America and 34 countries around the world, RBC offers a full range of financial products and services of personal and commercial banking, wealth management services, insurance, corporate and investment banking and transactions processing services on a global basis. The  objective of this project is to design and maintain a complete data warehouse system for Royal Bank management. This Project is to provide different reports and support adhoc queries for making intelligent banking decisions based on data available in various branches across the country collected over a period of time.  The activities of the project ranged from data extraction, staging and loading into data warehouse through Datastage to developing end users.

               

Contribution: As an ETL Developer

• Used the transformations like Lookup, Filter, Aggregator, transformer in the development of data stage jobs
• Develop and implement strategies for performance tuning
• Used Sequential file, Oracle Enterprise,  fileset, datasets, change capture, filter stage for designing the jobs in the DataStage Designer.
• Used Data Stage Director for running and monitoring & scheduling the jobs.
• Worked with Data Stage Manager for Export & Import Jobs. 
• Involved in Unit Testing and integration testing.

#2   Name                :  EDW for General Motors                                      Dec’ 2006 – Sep’ 2007

       Client                :  General Motors

       Team Size        :  6

       Environment   :  DataStage7.5X2, Oracle 9i,Unix and Windows 2003.

Description:

GM is the major manufacturer of motor vehicles. The main objective of the project is to outsource the Strategy, Design, Development, Coding, Testing, Deployment and Maintenance of the Enterprise Data warehouse. This Project would cover the subject areas such as Vehicle Product Offering (VPO), Volume Mix Rates (VMR), Posts Structure Cost (PSC), and Account for Production Material (APM) and Control Vehicle Financials (CVF). Data from various source systems is gathered into a staging area,   where data is cleansed and then finally moved into an Enterprise Data warehouse Database. Data Stage 7.5x2 is used for extracting data from various Sources to Staging area; Staging area to DW. Business Objects is used as the reporting tool.

Contribution: As an ETL Developer

·         Mapping Documents, ETL Job Scheduling   and maintenance documents.

·         Performed  import   and export of Data Stage Jobs using DS Manager.

·         Creating jobs   involving   Aggregator, transformer Stages

·         Creating reusable components using shared containers.

• Integrated Sources from Oracle and Flat Files.

• Created Data stage Sequencers to run Batch jobs.
• Used merge, lookup, change capture and transformer.

#3    Name               : MTNL CRM Analytics                 Feb’ 2006 – Nov’ 2006

        Client             : MTNL- Delhi, Mumbai.

        Team Size         : 5

        Environment    : DataStage 5.7X2, Oracle 9i,Unix and Windows 2003.

Description:

        The MTNL (Mahanagar Telephone Nigam Limited) is an Indian Government owned telephone service provider in the cities of Mumbai, Thane, New Delhi and Navi Mumbai in India. The company was a monopoly till 2000 when telecom sector was thrown open to other service providers. The prime aim of the Analytics module in this project is to generate analytical reports for MTNL business analysis purpose. In the process of designing the analytical reports, DW architecture has been designed and implemented using Data Stage as the ETL tool and COGNOS as the OLAP tool.

.

Contribution: As an ETL Developer

Ø  Transforming, integrating, and loading data into data warehouse database.

Ø  Perform data manipulation using  DataStage transforms .

Ø  Used the Data Stage Director for scheduling, validating, running and monitoring the jobs.

Ø  Create and use DataStage Shared Containers, Local Containers for DS jobs and retrieving   Error log information.