SUMMARY

• Around 5 years of profound IT experience in Design, Development and Implementation of Relational Database and Data Warehousing Systems using IBM InfoSphere Information Server 8.1(DataStage, QualityStage), IBM Data Stage Enterprise and Ascential Datastage 8.5/8.1/7.5 Client - Server environment.
• Experience in various phases of IT projects Software Development Life Cycle (SDLC) such as analysis, design, construction and testing, deployment and production support.
• Highly experienced in designing, developing, documenting, and testing of ETL jobs and mappings in Server and Parallel versions of DataStage.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Extensive experience in Mapping, Extract, Transformation and Load data from heterogeneous sources like Oracle(11g, 10g, 9i) / DB2/ and other sources like Flat files into DataStage.
• Extensive experience in loading high volume data, and performance tuning.
• Strong skills in data mapping for the Slowly Changing Dimensions - SCD1, SCD2 (Flagging, Time Stamping and Version), and SCD3.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Involved in Designing, Compiling, Testing, Scheduling and running Data Stage jobs.
• Expert in understanding and working on dimensional modeling (Star Schema modeling and Snow flake modeling).
• Involved in daily interactions with the Business team to understand their requirements and creating design documents.
• Interacted with Developers, Business analysts, Database team, Deployment team, and Release Management in an efficient and effective manner.

TECHNICAL SKILLS

ETL Tools: IBM Infosphere Data Stage 8.X, Data Stage 7.5.2 Designer, Director, Administrator, Manager, Ab Initio, Microsoft DTS Designer

Databases: Oracle 11g/10g, DB2 UDB, Sybase, SQL Server, Teradata

Data Modeling: Erwin 4.1/3.5, ER/Studio 3.5, Microsoft Visio 2000

Languages: SQL, PL/SQL, C, Java, Visual Basic 5.0, UNIX Shell scripting

Operating Systems: SunOS 5.10, IBM AIX 5.3, Windows 95/98/2000/XP.

Reporting Tools: Crystal Reports and Business Objects

Scheduling: AUTOSYS, Control-M and ASG Zena

Application Suite: MS Office, MS Project, MS Share Point, Microsoft Visio Professional5.0/2002.

PROFESSIONAL EXPERIENCE

Confidential, Pella, IA

Data Stage Developer

Responsibilities:

• Interacted with Business Analysts to gather the requirements and created the technical design document for Coding.
• Designed and developed Data Stage Parallel Jobs while using required stages, data from different sources
• Formatted, Cleansed summarized and transformed and loaded into data warehouse.
• Involved in design and development of parallel jobs, sequences using the Designer.
• Extensively worked with all the new features in IBM information Server.
• Worked with SCD stage for implementing SCD Type 7.0
• Created Master Job Sequences to control sequence of Jobs using job controls.
• Scheduled and supported execution of master job sequences.
• Used Data Stage Director for running and monitoring performance statistics.
• Performed Unit Testing on all the jobs developed and created Unit Test Documents.
• Involved in ETL documentation, strictly following naming conventions.

Environment: Data Stage 8.5 (Designer, Administrator, Director), Windows XP, Oracle 11g, SQL, PL/SQL, Toad, SQL Developer

Confidential, Chicago, IL

Data Stage Developer

Responsibilities:

• Interacted with Business Analysts to finalize the requirements and documented the technical design document for Coding.
• Developed DataStage Parallel Jobs where in using required stages, data from different sources formatted, Cleansed, summarized, aggregated and transformed and loaded into data warehouse.
• Involved in design and development of parallel jobs, sequences using the Designer.
• Extensively worked with all the new features in IBM information Server.
• Worked with SCD stage for implementing slowly changing dimensions.
• Involved in the installation of IBM Information Server.
• Tuned Data Stage jobs for better performance by creating DataStage Lookup files for staging the data and lookups.
• Created Shared Containers to increase Object Code Reusability and to increase thru put of the system.
• Experience developing complex transformations, surrogate keys, routines, dimension tables and fact tables.
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs and debugging them.
• Exposed to the Quality analysis techniques in order to check the quality of data
• Performed automation QA analysis of the application for governing the data
• Involved in the identification of Facts and dimensions for developing logical design of the data marts.
• Performed extraction, transformation and loading of data using different types of stages and by performing derivations over the links connecting these stages.
• Enhanced the Job Performance by using proper Partitioning methods and analyzing the resources utilized using Job Monitor.
• Created Master Job Sequencers to control sequence of Jobs using job controls.
• Used Data Stage Director for running and monitoring performance statistics.
• Created Test Plans for Unit Testing for designed jobs.

Environment: DataStage 8.5 (Designer, Administrator, Director), Windows XP, Oracle 9i/8i, SQL, PL/SQL, Erwin7.0, UNIX, MS Access, Sybase, DB2.

Confidential, NJ

Data Warehouse Developer

Responsibilities:

• Worked with the Business analysts and the DBA’s for requirements gathering, analysis, testing, and metrics and project coordination
• Successfully implemented the slowly changing dimensions. Involved in the Dimensional modeling of the Data warehouse. Involved in designing various jobs using PX
• Created and populated Data Warehouse structures using DataStage
• Developed documents like Source to Target mapping for developing the ETL jobs
• Populated Data Marts at different levels of granularity for the inside Customers using DataStage (being executed from shell scripts driven by Autosys)
• Worked with DataStage server stages like OCI, ODBC, Transformer, Hash file, Sequential file, Aggregator, Sort, Merge, Link Partitioner, Link collector, IPC and other stages
• Designed and coded high performance DataStage routines
• Imported the required Metadata from heterogeneous sources at the project level
• Developed Parallel jobs using Parallel stages like: Merge, Join, Lookup, Transformer (Parallel), Teradata Enterprise Stage, Funnel, Dataset, Oracle Enterprise Stage.
• Performed debugging on these jobs using Peek stage by outputting the data to Job Log or a stage
• Worked on programs for scheduling Data loading and transformations using Data Stage from legacy system and Data Warehouse to Oracle 9i.
• Used the Slowly Changing Dimension Stage itself to implement SCD Type-1 & 2.
• Exported the project from Development to Test environment using Data Stage Manager.
• Transformed and loaded from heterogeneous sources using Microsoft DTS
• Created DTS packages in order to accommodate the business logic
• Wrote the SQL queries &PL/SQL code tables and Data Mart Staging Tables to validate the data results by counting the number of rows in both the tables.
• Developed UNIX shell script to run jobs in multiple instances by using a parameter file.
• Interacted with Solutions analysts, system staff, ETL, BO developers and the data load staff.
• Involved in Unit, Integration, System and User Acceptance Testing (UAT).

Environment: DataStage Parallel Extender 8.X (Designer, Manager, Director), Microsoft DTS, Ab initio, Oracle 10g, TOAD, SQL/PLSQL, Teradata V2 R5, Teradata SQL Assistance 7.0, Erwin 4.0, UNIX (AIX) and Windows NT/2000.

Confidential, NJ

Data Warehouse Developer

Responsibilities:

• Designed and developed jobs for extracting, transforming, integrating, and loading data into data mart using Data Stage Designer.
• Developed, executed and monitored the ETL Data Stage jobs in the Data Stage designer and Director Components.
• Worked with Data Stage Director to schedule, monitor, analyze performance of individual stages and run multiple instances of a job.
• Extensively used Sequential File, Aggregator, ODBC, Transformer, Hashed-File, Link Partitioner, Link Collector and Plug-ins Stage.
• Generated Surrogate Keys for composite attributes while loading the data into Data Warehouse using Key Management functions.
• Developed Architecture for building a Data warehouse by using data modeling tool Erwin.
• Responsible for developing, validating, and communicating data modeling solutions, including both relational and dimensional models.
• Developed user defined Routines and Transformations for implementing Complex business logic.
• Developed Job Sequencer and batches and have edited the job control to run jobs in sequence.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements.
• Implemented reporting functionalities using Business Objects in interaction with the Report Developers.
• Involved in the preparation of ETL documentation by following the business rule, procedures and naming conventions.
• Performed job tuning for better performance.
• Performed Unit and Integration testing on the jobs created.
• Developed shell scripts to validate, schedule Data Stage jobs.
• Developed the automated and scheduled load processes using UNIX shell scripting and Autosys.

Environment: Ascential Data Stage 7.5, Oracle 9i, PL/SQL, SQL*Plus, UNIX Shell Scripts, Windows 2003/NT 4.0, ERWIN 7.3, Business Objects 5.0, Meta Stage and Integrity.

Confidential

DataStage Developer/PL-SQL

Responsibilities:

• As a Technical Team Member I was involved in Development of different modules and PL/SQL procedures.
• Was responsible for identifying the business user requirements.
• Developed transformations logic and developed various mappings in DataStage Designer.
• Used ODBC to connect to the target Oracle database.
• Used SQL overrides extensively and substituted them in place of multiple transformations.
• Used transformations for data complex aggregations.
• Responsible for improving query and session performance.
• Created, launched & scheduled sessions and batches using Server Manager.
• Defined mappings for slowly changing Dimensions and slowly growing targets.
• Created Unit test plan documents and executed the same successfully.
• Used DataStage Director for executing and scheduling the jobs.
• Used DataStage Manager for export/import various DataStage components.
• Used Before/ After Job-Subroutines in Job Properties.
• Responsible for performance Tuning.
• Performed Unit Testing.

Environment: DataStage Designer, DataStage Director, Designer Manager, Oracle, IBM DB2 UDB, Teradata, Mainframes, Unix Shell Scripts, PL/SQL,UNIX And DOS Sequential Files, MS Access.