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 the 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 the 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 the requirements and to build the 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 the 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 the target tables using the DataStage Designer
• Designed, developed job sequences to run multiple jobs
• Used DataStage Designer for importing the source and target database schemas, importing and exporting jobs/projects, creating new job categories and table definitions.
• Designed and developed the Routines and Job Sequence for the 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 the DataStage Director to run, schedule, monitor, and test the application on development, and to obtain the performance statistics.
• Developed Packages and customized functions and Triggers based upon the business logics
• Involved in Performance tuning of complex queries
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the 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 the upgrading the Data Stage 7.5.2 to Web Sphere Data Stage 8.0.1
• Worked with the 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 the 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 the 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 the flow of data from staging area into the target area on the Database.
• Fine tuning of jobs by following best design practices, configuration changes and best data partitioning/collecting methodologies to meet the project requirement.
• Standardized the 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 the review of Technical, Business Transformation Requirements Document.
• Good noledge 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 the Target Schema definition and Extraction, Transformation (ETL) using Data stage.
• Working as a Technical team lead for the Data stage team for production support, testing and development environments.
• Involved in gathering requirements from the End users. Understanding the Business requirements.
• Involved in designing the functional specifications and technical specifications for project.
• Designed Data stage Best practices, Naming conventions to be followed for the developers.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Created Shared Container to simplify the Datastage design, and used it as a common job component throughout the project.
• Involved in performance tuning of the ETL process and performed the data warehouse testing
• Extensively worked on Error handling, cleansing of data, Creating Hash files and performing lookups for faster access of data.
• Used the 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 the requirements and documented the Program Specifications for the ETL jobs.
• Involved in Requirements gathering, developed mapping documents with Modeling documents, Written techno functional documents, test cases, test case scenarios based on the 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 the Designer.
• Involved in the identification and analysis of the source data for performing the ETL operations.
• Used SAP Packs to extract data from SAP Systems.
• Efficiently upgraded from Datastage 7.5 to Datastage 8.1 and assisted with the changes in 8.1
• Tuned Data Stage jobs for better performance by creating Data Stage 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.
• 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 noledge 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 the Manager.
• 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.
• 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 the 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 that 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 the ad hoc reporting requirements of the 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 the Runtime Improvements and tuning and optimization of the critical queries of the 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.