PROFESSIONAL SUMMARY:

• Over 5+ years of progressively responsible experience in development, testing, documentation, production support & Integration applications using IBM DataStage 11.3, 9.1, 8.x IBM DB2, Oracle 10g Technologies in Data Warehousing and experience on various technologies like Oracle PLSQL, Teradata, SQL server and UNIX Shell scripting.
• Expertise in Software Development Life Cycle (SDLC) and Production Support Life Cycle
• Experience in Data Architecture (involving physical and logical design) of Data Warehouse applications.
• Experience in Designing and Implementing Data Warehouse applications, mainly Transformation processes using ETL tool Datastage also actively involved in Database Querying, Data Analysis, Production support, Review, on call support.
• Good hands on experience in RDBMS like Oracle, SQL Server, Teradata, and DB2.
• Working experience in data modeling and implementing stored procedures using PL/SQL.
• Extensive knowledge of writing complex queries using SQL.
• Experience in Data Integration, EDW and Data Mart projects.
• Strong knowledge in OLAP and OLTP Systems, Dimensional modeling using Star Schema and Snowflake Schema.
• Demonstrated work experience in Oracle to DataStage Migration projects.
• Working experience in DB2 Cursors, PL/SQL Triggers and Stored Procedures.
• Expert in working with DataStage Designer and Director.
• Performance tuning of IIS servers and Install, export/export of SSL s and Managing IIS 5.0 / IIS 6.0/IIS 7.0 Web servers and hosted web sites.
• Experienced with TOAD and PL/SQL Developer.
• Used Operations Console to monitor the jobs performance and memory / CPU usage.
• Proficient in developing ETL procedures using IBM DataStage 8.x, 9.1, 11.3 and UNIX Scripts.
• Worked and extracted data from various database sources like Oracle 9i/10g, Flat files, DB2, UDB, XML.
• Experience in writing, testing and implementation of the Stored Procedures, Packages and functions at the Database Level in Oracle 10g.
• Experience in performance tuning both at Application Code Level and Databases Level.
• Experience in designing optimum data marts and data warehouse tables with limited redundancy and for effective and performance efficient reports.
• Have been a team player involved in many enhancements/developments and ensured successful completion of all the projects as per SLA (Service Level Agreements).
• Extensive experience in using Built - in, Plug-in and Custom Stages for Extraction, Transformation and loading of the data.
• Experience in design and implementation of Server and Parallel Jobs including Batches and Job Sequencers.
• Strong communication and analytical skills and a demonstrated ability to handle multiple tasks as well as work independently or in a team towards resolution.
• Extensively Written SQL/PL SQL Queries to extract data from various source systems and populate in SAP reports.

TECHNICAL SKILLS:

Operating System: Windows, UNIX & Linux

Environment: Client/Server

DBMS: DB2 V8.1, DB2 V9.0, Oracle 9i, Oracle 10g and MS Access DB2 V8.1, DB2 V9.0, Oracle 9i.

Database: Oracle, SQL Server, Teradata & DB2.

ETL Tools: IBM DataStage 8.0, 8.7, 9.1,11.3

Languages: SQL, Oracle PL/SQL, UNIX Shell scripting

Other: Remedy, SSH, Reflection, Putty

WORK EXPERIENCE:

Epic DataStage Developer

Confidential

Responsibilities:

• Designed and tested the DataStage jobs for extract, transform and load.
• Extensively involved in the data migration team to build the Re-usable DataStage job templates, common parameter sets, common DataStage job containers, analyzing with info analyzer 8.1, SQL extract procedures and common re-usable Shell Scripts.
• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Data analysis, Data modeling concepts, Database design and Data migration using Quality stage.
• Provide the Staging Solutions for Data Validation and Cleansing with PL/SQL and Data Stage ETL jobs.
• Implemented Aggregate, Filter, Join, Lookup, Rank and Update Strategy Transformations.
• Used Star Schema and Normalization data modeling techniques for warehousing of data.
• Extensively worked with DataStage 11.3, V - Designer and Director to load data from source extract files to the warehouse.
• Created DataStage jobs to load data from sequential files, CSV, Flat files.
• Developed various jobs using Aggregator, Sequential File stages.
• Worked towards optimal performance when using Stages like LOOKUP, JOIN and MERGE.
• Designed and developed DataStage jobs for Loading Staging Data from different sources like Oracle, DB2 DB into Data Warehouse applying business rules which consists data loads, data cleansing and data massaging.
• Used the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components and monitoring the resulting executable versions
• Worked with Metadata Definitions, Import and Export of DataStage jobs using DataStage Tools Functionality.
• Created Parameters and Parameter Sets where necessary.
• Tuned DataStage jobs for better performance by creating DataStage Hash files for Staging the data and Lookups.
• Scheduled the server jobs using DataStage Director, which are controlled by DataStage engine and also for monitoring and performance statistics of each stage using IBM Quality Stage 8.1.
• Used SQL to maintain ETL frameworks and methodologies in use by the company.
• Participated actively in the Team meetings with the developers for bug reviews.

Environment: DataStage 11.3, DataStage Designer, Data Stage Director, IIS, Data Stage Manager, Quality Stage 8.1, Info Analyzer 8.1, AutoSys, Oracle, SQL/PLSQL, Windows.

ETL Datastage & DB Developer

Confidential - Detroit, MI

Responsibilities:

• Expertise in designing and implementing DataStage Architecture in data warehousing and Business Intelligence projects.
• Expertise in IBM dataStage with data cleansing and transform the data.
• Worked with a Functional Team and Data Modelers/Architects to identify and understand the data from different source systems.
• Process JSON, XML, CSV and Text raw data after cleansing the data.
• Involved in the analysis of the functional side of the project by interacting with functional experts to design and write technical specifications.
• Data base design and base model - Logical & Physical design with hands on experience in DDL and DML SQL operations.
• Used Workflow Repositories to investigate, standardize, match and survive for data quality and data profiling issues during the designing.
• Created DataStage Workflows (ETL Process) using Power center Designer and Mfor populating the data into the Data Warehouse constantly from different source systems like ODS, Flat files.
• Writes 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.
• Extensively analyzed the Data Sources in identifying data anomalies, patterns, value ranges using Quality Stage.
• UNIX Shell Script to run jobs in multiple instances by using a parameter file.
• Worked on programs for Scheduling Data Loading and Transformations using Data Stage from a legacy system and Data Warehouse.
• Preparing development timing plans & reporting to senior management about the supplier progress system & ensuring their engineering support for onsite integration & production launch.
• Worked in a Team with other associate product & component developers.
• Analyzing & Designing, worked on changed requests as per clients and projects technical specification needs.
• Awareness about the functional/business aspects for the components.
• The automated process of workflows monitoring which helped in minimizing the manual intervention & documenting them perfectly.
• Involved in the Documentation of the ETL phase of the project.
• Extensively Written SQL/PL SQL Queries to extract data from various source systems and populate in SAP reports.
• Developed the reusable components, best practices that were later on used in other Data Warehouse.

Environment: Datastage 11x, Data Warehousing, ETL, Oracle 11g, SQL*Loader, SQL, PL/SQL, Shell Scripts, Autosys, Windows XP Professional.

DataStage Developer

Confidential

Responsibilities:

• Extensively used DataStage for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
• Collaborated with EDW Team in, High Level design documents for extract, transform, validate and load ETL process data dictionaries, Metadata descriptions, file layouts and flow diagrams.
• Collaborated with EDW Team in, Low Level design document for mapping the files from source to target and implementing business logic.
• Generation of Surrogate Keys for the dimensions and fact tables for indexing and faster access of data in Data Warehouse.
• Tuned Transformations and jobs for Performance Enhancement.
• Extracted data from flat files and then transformed according to the requirement and Loaded into target tables using various stages like Sequential file, Look up, Aggregator, Transformer, Join, Remove Duplicates, Change Capture Data, Sort, Column generators, Funnel and Oracle Enterprise.
• Created Batches (DS job controls) and Sequences to control set of jobs.
• Extensively used DataStage Change Data Capture for DB2 and Oracle files and employed Change Capture Stage in parallel jobs.
• Executed Pre and Post Session commands on Source and Target database using Shell Scripting.
• Collaborated in design testing using HP Quality Center.
• Extensively worked on Job Sequences to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Extensively used SAP R/3 and SAP BW packs
• Collaborated with BI and BO teams to find how reports are affected by a change to the Corporate Data Model.
• Collaborated with BO teams in designing dashboards and scorecards for Analysis and Tracking of key business metrics and goals.
• Utilized Parallelism through different partition methods to optimize performance in a large database environment.
• Developed DS jobs to populate the data into staging and Data Mart.
• Executed jobs through sequencer for better performance and easy maintenance.
• Performed the Unit Testing for jobs developed to ensure that it meets the requirements.
• Developed UNIX Shell Scripts to automate file manipulation and data loading procedures.
• Scheduled the jobs using AutoSys, Tivoli and Corntab.
• Responsible for daily verification that all scripts, downloads and file copies were executed as planned, troubleshooting any steps that failed and providing both immediate and long-term problem resolution.
• Provided Technical assistance and support to IT analysts and business community.

Environment: IBM InfoSphere DataStage and QualityStage 8.5 (Administrator, Designer, Director), IBM Information Analyzer 8.0.1a, Microsoft SQL 2005/2008, IBM DB2 9.1, AIX 6.0, Microsoft SQL 2008, Oracle 11g, MS Access, SAP BW, SAP MDM, AS/400, Shell Scripts, WinSCP, ERwin 4.0, HP Quality Center, Tivoli, Corntab, AutoSys.

DataStage Developer

Confidential

Responsibilities:

• Analyze the existing complex data loading procedure of the Application and identify the jobs need to be modified.
• Develop new jobs.
• Prepare Technical Specification Documents.
• Populate data from a different source.
• Coding for jobs and create reports for the end user.
• Transform the field as user requirement.
• Creating and Maintaining Traceability Matrix for the Test Plan/Test Specification (vs) Requirements.
• Implement project in production.
• After going live did also some change request and ISJR for some of the Intermediate Requirements to fulfill some more requirements and preparing technical and test document.
• Investigate Testing environment and fix bugs if any.
• Built DataStage jobs to read files from multiple tables using Oracle Connector Stage Created Sequencers with Exception Handling and Restarting Logics.

Tools: iWay Software, DataStage, IBM Quality stage 8.1, IBM Information Analyzer 8.1, Web FOCUS, VB6