SUMMARY

• Experience in software systems Development client/server Business systems with 8 years of strong Data Warehousing experience on Extraction, Transformation and Loading (ETL) processes using IBM Information server 8.1/Data Stage 7.5/7.1/6.0 and Information Analyzer (Profile stage) and Quality Stage.
• Strong Knowledge of Business Intelligence (BI), Data Warehousing, ETL, and OLAP.
• Efficient in all phases of teh software development lifecycle (SDLC), coherent with Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing (UAT).
• Experience in analyzing Star Schema/Snowflake Schema, Dimensional Data Modeling, Logical and Physical Data Modeling using ERwin4.0/3.5 and UML.
• RDBMS experience with TeraData v2r6 / v2r12, Oracle 10g/9i/8i, SQL Server, DB2 including database development, developed Stored Procedures, Triggers, Functions, Packages, Views, Materialized Views and Partitioning tables, Nested Tables.
• Extensively worked with Parallel Extender for splitting bulk data into subsets to distribute teh data to all available processors to achieve best job performance.
• Extensively worked on DataStage client Components Designer/Manager, Director and Administrator.
• Extensively worked on various databases like Oracle, Teradata, DB2 and SQL Server.
• Strong in process creation for both Server and Parallel Extender in Ascential Datastage.
• Over 2+ years experience in SAP BW Pack BAPI (Staging Business API) for loading into BW& extract data from BW.
• Experience in Data integration with SAP systems, extensively used Datastage plug - ins for SAP R3 and SAP BW.
• Data migration, synchronization, consolidation and cleansing of operational systems, such as legacy, ERP and CRM applications, to enable strategic, tactical and operational business intelligence.
• Strong in IBM Datastage ETL, SQL, Teradata Scripts, Unix/Linux, FTP, SDLC (System Development Life Cycle), DB2, UAT Testing, and mainframe utilities.
• Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.
• Hands on experience in Enterprise Scheduling tools like Control-M and Autosys.
• Strong background in ETL tools, such as Data stage parallel Extender.
• Implemented quality stage for data cleansing, data standardization and matching process.

TECHNICAL SKILLS

ETL: II Ascential Datastage 7.5.2/7.1/6.0/5.1 EE client components (Designer, Director, Manager, Administrator), Profilestage, Websphere Information Server 8.0 (Datastage & Qualitystage) & Information Analyzer 8.1

Data Modeling: S Star Join Schema, Snow-Flake Schema, Dimensions & Fact Tables, Physical and Logical Data Modeling, Erwin (Forward & Reverse) engineering

BI Tools: C Business Objects XI, OBIEE 3.1

Databases: O Oracle 10g/9i, DB2 9.x, MS SQL Server 2005, Teradata V2R12/V2R6

Languages: Java, XML, SQL, T-SQL, PL/SQL, C, C++

Environment: Windows 2003/2000NT 4.0, Sun Solaris 2.x/5.x, AIX 5.2/4.3, HP-UX, Linux

ERP / CRM: S SAP R/3 ABAP 4.7, SAP CRM5.0,SAP BW3.5, Oracle 11i, Siebel 8.0

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Sr. DataStage Developer

Responsibilities:

• Work closely with Business analysts and Business users to understand teh requirements and to build teh technical specifications.
• Responsible to create Source to Target (STT) mappings.
• Responsible to design, develop and build datastage parallel jobs using DataStage designer.
• Developed and supported teh Extraction, Transformation and Load process (ETL) for a data warehouse from various data sources using DataStage Designer.
• Designed and developed Parallel jobs to extract data, clean, transform, and to load teh target tables using teh DataStage Designer
• Designed, developed job sequences to run multiple jobs
• Used DataStage Designer for importing teh source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Designed and developed teh Routines and Job Sequence for teh ETL jobs
• Prepared Technical Specification Documents for DataStage Jobs.
• Involved in Unit testing and integration testing.
• Responsible for running jobs using Job Sequencers, Job Batches.
• Developed Parallel jobs using various stages like Join, Merge, Funnel, Lookup, Sort, Transformer, Copy, Remove Duplicate, Filter, Peek, Column Generator, Pivot and Aggregator stages for grouping and summarizing on key performance indicators used in decision support systems
• Implemented logical and physical data modeling with Star and Snowflake techniques using Erwin in Data warehouse.
• Extensively worked on Teradata MLoad, Teradata Enterprise Stage, and Teradata API Stage to extract, transform and load data.
• Good understanding of Teradata Load Utilities like BTQ, Multiload, Fastload, BTEQ, TPump in order to work with Teradata stages in DS Designer.
• Understanding of source code control concepts.
• Extensively used Reject Link, Job Parameters, and Stage Variables in developing jobs
• Used teh DataStage Director to run, schedule, monitor, and test teh application on development, and to obtain teh performance statistics.
• Developed Packages and customized functions and Triggers based upon teh business logics
• Involved in Performance tuning of complex queries
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate teh functionality for various modules.
• ERP development and implementation.
• Responsible for analyzing and preparing dependencies and sequence in which job/processes should be scheduled in Enterprise Scheduling tools like Control-M scheduler
• Used Business Objects to Custom Reports

Environment: IBM Websphere DataStage 8.1.1 (Designer, Director and Administrator), Teradata V2R12 & V2R6, AIX 5.3, SQL Server, SQL Assistant, Control-M Desktop Manager 6.3.01, Control-M 6.3.01, Windows XP, Visio, Erwin, Business Objects

Confidential, Chicago, IL

Sr. Data Stage Consultant

Responsibilities:

• Developed complex extraction, transformation, and load (ETL) processes for data conversions and construction of data warehouse using IBM Web sphere Data stage 8.0.1/7.5.
• Extensively used Data Stage designer to develop Jobs for extracting, transforming, integrating and loading data into data warehouse tables.
• Worked with teh upgrading teh Data Stage 7.5.2 to Web Sphere Data Stage 8.0.1
• Worked with teh migration of ETL jobs from Data Stage 7.5.2 to Web Sphere Data Stage 8.0.1.
• Used Data Stage Director to run, debug and monitor teh Data Stage jobs.
• Developed transformations using various jobs including ODBC, Hashed file, Aggregator, Transformer, Filter, Join, Lookup, Merge, Dataset, Funnel and Sequential file stages.
• Scheduled teh server jobs using Data Stage Director, which controlled by Data Stage engine and also for monitoring and performance statistics of each stage.
• Sequences were developed to support teh flow of data from staging area into teh target area on teh Database.
• Fine tuning of jobs by following best design practices, configuration changes and best data partitioning/collecting methodologies to meet teh project requirement.
• Standardized teh data from different sources using Quality Stage.
• Extensively used Data Stage Manager to import/export metadata, jobs, and routines from repository, and also created data elements.
• Designed Mappings between sources to operational staging targets, using Star Schema.
• Wrote UNIX shell Scripts for file validation and scheduling Data Stage jobs.
• Participated in teh review of Technical, Business Transformation Requirements Document.
• Good knowledge in Business Intelligence Concepts for building custom reports

Environment: IIS DataStage 8.0.1 (DataStage and QualityStage Designer, Directory and Administrator), Information Analyzer, Ascential Data Stage 7.5.1.A, XML files, CSV files, flat files, Oracle 10g, SQL server 2010, UC4, UNIX, Windows NT,BI

Confidential, Memphis, TN

Datastage consultant

Responsibilities:

• Designing teh Target Schema definition and Extraction, Transformation (ETL) using Data stage.
• Working as a Technical team lead for teh Data stage team for production support, testing and development environments.
• Involved in gathering requirements from teh End users. Understanding teh Business requirements.
• Involved in designing teh functional specifications and technical specifications for project.
• Designed Data stage Best practices, Naming conventions to be followed for teh developers.
• Used teh Data Stage Director and its run-time engine to schedule running teh solution, testing and debugging its components, and monitoring teh resulting executable versions.
• Created Shared Container to simplify teh Datastage design, and used it as a common job component throughout teh project.
• Involved in performance tuning of teh ETL process and performed teh data warehouse testing
• Extensively worked on Error handling, cleansing of data, Creating Hash files and performing lookups for faster access of data.
• Used teh Datastage Designer to develop processes for extracting, cleansing, transforming and integrating.

Environment: Ascential Datastage 7.5 (Parallel Extender) (Manager, Designer, Director, Administrator), Oracle 10i, PL/SQL.

Confidential, Omaha, NE

Sr.Datastage Developer

Responsibilities:

• Interacted with end users in finalizing teh requirements and documented teh Program Specifications for teh ETL jobs.
• Involved in Requirements gathering, developed mapping documents with Modeling documents, Written techno functional documents, test cases, test case scenarios based on teh ETL PROCESS, functional specification documents
• Developed Data Stage Parallel Jobs where in using required stages, data from different sources formatted, Cleansing, summarized, aggregated and transform into data warehouse.
• Involved in design and development of server jobs, sequences using teh Designer.
• Involved in teh identification and analysis of teh source data for performing teh ETL operations.
• Used SAP Packs to extract data from SAP Systems.
• Efficiently upgraded from Datastage 7.5 to Datastage 8.1 and assisted with teh changes in 8.1
• Tuned Data Stage jobs for better performance by creating Data Stage Lookup files for staging teh data and lookups.
• Created Shared Containers to increase Object Code Reusability and to increase thru put of teh system.
• Experience developing complex transformations, surrogate keys, routines, dimension tables and fact tables.
• Extensively worked on SAP R3 PACK for DataStage.
• Designed, developed datastage jobs using ABAP Extract stage, IDoc Stage, BAPI Stage to interface SAP transactional data into Enterprise data warehouse.
• Good understanding of SAP architecture.
• Good knowledge of SAP R3 Transaction (T-Codes) Codes.
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs and debugging them.
• Created jobs in DataStage to import data from heterogeneous data sources like Sybase, Oracle 9i, Text files, PeopleSoft and MS SQL Server
• Imported metadata, table definitions and stored procedure definitions using teh Manager.
• Enhanced teh Job Performance by using proper Partitioning methods and analyzing teh resources utilized using Job Monitor.
• Created Master Job Sequencers to control sequence of Jobs using job controls.
• Created Test Plans for Unit Testing for designed jobs.
• Data Cleansing & Standardization, De duplication & Identification and address verification of customer and vendor data using Quality stage Stages.
• Implementing teh SCD Type-2 using SCD stage & Change Capture stages.

Environment: Ascential Datastage 7.5 Parallel Extender (Designer, Manager, Director and Administrator), Ascential Quality stage 7.5.1, Profile Stage 7.5, Erwin 4.2, Oracle9i, Business Objects 6.5, SAP R3 Extract PACK, TOAD, UNIX- AIX, MS Word, Excel

Confidential

Responsibilities:

• Created Business Objects Universe dat caters to Customer profitability, Product profitability and branch performance.
• Created canned reports using OLAP techniques like Slice & Dice, Drill Down features and designed cross tab and Master Detail reports.
• Assisted in finalising teh ad hoc reporting requirements of teh user and creating reports having Drill Down, Slice and Dice and Alert features.
• Coded a number of PL/SQL stored procedures and data base trigger functions.
• Involved in teh Runtime Improvements and tuning and optimization of teh critical queries of teh application.

Environment: Business Objects, Oracle 8i, Forms 4.5, Reports 2.5, SQL and PL/SQL on Window95, SQL*Plus, SQL*Loader, MS SQL Server 7.0, UNIX.