SUMMARY

• Over 11 years of experience in Information technology, with over 8 years of expertise in DataStage and Data warehousing in various domains using IBM Infosphere (Ascential) DataStage 8.5/8.1/7.x (Manager, Designer, Director, Administrator, Version Control), Parallel Extender, ProfileStage, and QualityStage.
• Extensively involved in teh development of DataStage ETL process for extracting data from different data sources, data transformation and Loading teh data into data warehouse for data mart operations
• In depth experience in dealing with Ascential DataStage stages (hash, ftp, merge, sort, aggregator, lookup etc)
• Developed E - Mail Notification Process on Successful Completion or Failure of DataStage Jobs
• Experience in creating Infopackages for SAP-BW and writing data into SAP-BW using PACK for SAP R/3-BAPI, ABAP extract PACK for SAP R/3, IDOC Load PACK for SAP R/3 and IDOC Extract PACK for SAP R/3
• Strong Skills in Coding (Stage Variables, Derivations and Constraints) Business Logics in Transformation Stage
• Developed DataStage jobs in Server and Mainframe environment
• Extensive experience in DataStage Job Sequence
• Created table definitions and custom transforms using DataStage Manager
• Used DataStage Director to validate and run teh DataStage jobs
• Used built in transforms and created custom transforms in DataStage
• Accomplished complex tasks and scheduled multiple jobs using Universe Basic
• Well versed with understanding/grasping complex table hierarchies and business models
• Extensively used Parallel Stages like Sort, Merge, Aggregator, Remove Duplicates, Join, Row Generator, Column Generator, Head and Peek for development and debugging purposes
• Used DataStage Parallel Extender for improving teh performance of jobs
• Knowledge of configuration files for Parallel jobs
• In depth noledge of Dimensional Data Modeling, Star Schema, Snowflake
• Involved in maintaining logical and physical models
• Experience in utilizing Defect Tracking Tool (Rational ClearQuest)
• Exposure to QualityStage and MetaStage
• Very strong in Oracle and Teradata SQL
• Excellent communication and interpersonal skills
• Versatile team player with proven problem solving skills

TECHNICAL SKILLS

Languages: PL/SQL, SQL, COBOL, Java, HTML, XML

Databases: Oracle 11g, DB2, TERADATA, SQL server2000, Sybase, MS - Access

Scripting Languages: SQL Scripts, UNIX shell scripting, JCL

GUI Tools: Developer/2000, Visual Basic 5.0, TOAD, DB Admin, RBMS, TestMan.

ETL Tools: Infosphere 8.1/8.5, DataStage 7.x, QualityStage V 7.5, DataStage PX (Parallel Extender), DataStage Version Control

Data Warehouse Tools: Visio, Erwin

CRM: SAP-BW 3.1, ABAP, BAPI and IDOC

BI Tools: Business Objects V6.1, SAS

Operating Systems: HP-UX, UNIX (SunOS 5.9, Solaris 2.9/2.8/2.6), AIX, MVS, Windows

PROFESSIONAL EXPERIENCE

Confidential, Hines, IL

DataStage Developer

Responsibilities:

• Extensively used DataStage Designer for extracting, cleansing, transforming, integrating and loading data
• Strong skills in coding Stage Variable, Constraints for implementation of business logic in transformer stage
• Analyze conversion requirements, specifications and data
• Involved in design and code reviews
• Extensively used hashed file for lookup and to improve teh performance of jobs
• Worked extensively on different types of stages like Sequential file, Oracle OCI, ORABULK, Hashed File, Complex Flat File, Aggregator, Transformer, Sort, Link Collector for developing jobs
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance
• Created validation jobs, test cases for unit testing and integration testing
• Provided teh necessary support for building DataStage projects, jobs and teh migration of code through teh development environments to Production.
• Used DataStage Manager for Export, Import of Projects and Run Multiple Job Compilation
• Run conversions in test and production environments
• Used DataStage Director to run, monitor, validate and check for any errors in jobs after job run was successful
• Maintained a backup of teh DataStage in case of emergency with daily DataStage back up
• Performed performance tuning of teh jobs by monitoring job run statistics
• Analyzed application coding errors, functional specifications and business requirements associated with design enhancements
• Extensively used Defect Tracking Tool (Rational ClearQuest)
• Used Serena Dimensions as software repository for all documentation and code
• Developed reports manually as well as using SQL scripts & UNIX Shell Scripting
• Documented Run Books for all conversions (VETSNET, CH31,VITAL)

Environment: IBM Websphere DataStage 7.5/Infosphere 8.1/8.5, SunOS, Oracle 11g, Tuxedo, Rational ClearQuest, Serena Dimensions, PL/SQL, Unix shell scripting, SQL Scripts, Attachmate Reflection X

Confidential, Milwaukee, WI

DataStage Developer

Responsibilities:

• Analyzed metadata and data
• Mapped multiple source’s Metadata to Single Metadata
• Extensively used DataStage Designer to design & develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse
• Strong skills in coding (stage variables, derivations and constraints) business logics in transformation stage
• Extensively used Hashed files to improve teh performance of Referential Lookups
• Strong skills in coding Error Handling - functionality
• Strong skills in defining user defined SQL in Oracle stages for better job performance
• Designed and developed DataStage job templates and naming standards
• Extensively used Link Partitioner and Link collector in improving teh performance
• Used Environment Variables, Stage Variables and Routines for developing Parameter Driven Jobs
• Used DataStage Manager for creating new job categories, metadata definitions, and data elements, import/export of projects, jobs and datastage components, viewing and editing teh contents of teh repository as well as writing routines
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Involved in Design and Code review and walkthroughs
• Used DataStage Director and its run-time engine to schedule, validate, run and monitor teh resulting executable versions
• Implemented change request
• Used IBM’s “best practices” to design and code all DataStage jobs
• Worked closely with teh writers of teh Technical Specs
• Proficient in creating CSV files for SAP-BW and Using BW plug-in Stages
• Involved in creating SAP-BW info packages
• Created Test Plans for Unit and Integration Testing for designed jobs
• Analyzed teh performance bottlenecks and fine-tuned teh jobs

Environment: DataStage7.5.1, SAP-BW v3.1, Windows 2000 Server, SunOS 5.9, Oracle9i, Toad, Citrix MetaFrame.

Confidential, Indianapolis, IN

DataStage Developer

Responsibilities:

• Involved in review, design & developing environment (development, testing, version and production) for Datastage migration process on NT platform
• Reviewed and modified existing COBOL version of ETL process specifications to Datastage process
• Developed logical job flows for Datastage jobs basing on existing COBOL programs
• Designed jobs in PX as per given specs
• Used Parallel Extender to extract data from source systems such as Oracle, Flat files to target system on Oracle
• Performed ETL Optimization and tuned some key DataStage jobs for better performance
• Used stages like Sort, Merge, Aggregator, Remove Duplicates, Join, Transformer, Dataset, Peak, Funnel, Row Generator, Row Merger and other stages
• Created naming and system standards for lookup, transformation and target tables
• Strong skills in coding (stage variables, derivations and constraints) business logics in transformation stage
• Experience in using built-in & custom defined transform functions & routines
• Coded user defined SQL’s in ODBC stages for better job performance
• Involved in developing job automation process, to run Datastage jobs using global parameter file
• Involved Document Review’s with business analysts and involved in training business analysts & existing COBOL programmers to understand DataStage ETL Process
• Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence
• Created UNIX shell script
• Created Test Plans for teh designed jobs for unit testing

Environment: DataStage PX (Parallel Extender), Oracle 9i, UNIX, MS-SQL Server2000, DB2, MVS, JCL, COBOL, Business Objects V5.1, OS/390, Windows NT, IBM AIX 5.2, Erwin 3.5

Confidential, Indianapolis

ETL Developer

Responsibilities:

• Created DataStage server jobs using Designer and extracted data from various sources, transformed data according to teh requirement and loaded into data warehouse
• Involved in identifying source systems and analyzing metadata and data
• Used DataStage Manager to define Table definitions, Custom Routines and Custom Transformations
• Worked with various stages like Hashed File, Aggregator, ODBC, Transformer, Pivot, UDB DB2 and OCI Stages
• Extensively wrote Custom Routines and Transformations as per teh business requirements
• Used Hashed files, IPC stages to improve teh performance of jobs
• Involved in development phase meetings for Business Analysis and Requirements document reviews
• Developed Jobs Sequencer and Created shared containers
• Created test cases for unit testing and integration testing
• Moved jobs across multiple environments

Environment: Ascential DataStage V7.5/7.x, Oracle 9i/8i, TOAD, UNIX, SQL*plus, Windows NT

Confidential, Hartford, CT

DataStage Developer

Responsibilities:

• Extensively worked with DataStage Active and Passive Stages
• Extensively involved in creating database procedures, functions and triggers
• Used DataStage for extracting, cleansing, transforming, integrating, and loading data into data warehouse
• Used DataStage Manager to export/import jobs
• Extensively used Hashed files to improve teh performance of Referential Lookups
• Used shared containers, Link Partitioner, Link Collector, Sequential File, OracleOCI and ODBC stages in jobs
• Created Master Job Sequencer
• Analyzed teh performance bottlenecks and fine-tuned teh jobs

Environment: DataStage 6.x/7.0, Windows NT, Oracle 9i/8i, SQL, PL/SQL, SQL*Loader, RAFT, Mainframe systems

Confidential, NY

Oracle Developer

Responsibilities:

• Designed and developed forms and reports covering both new reports and customization of existing report layout to include additional columns, additional parameters, changes in layout
• Tested individual modules for conformance to teh client's specification
• Conducted Integration testing for checking teh effective and efficient working of teh application
• Involved in writing shell scripts, PL/SQL, stored procedures, functions and teh database triggers

Environment: Oracle 7.3/8x, SUN Solaris and Windows NT Client Server, PL/SQL 8.0.5, SQL*PLUS 8.0, SQL Navigator, TOAD, Developer 2000 (Forms4.5/5.0 & Reports 2.5/3.0)

Confidential

Oracle Developer

Responsibilities:

• Identified system requirement, create schema objects like indexes views, stored procedures and synonyms
• Involved in writing teh triggers which internally calls procedures and functions
• Designed user interface to enter teh employee personal details, qualifications, awards, punishments and loans
• Prepared test cases and generated reports
• Involved in documenting teh entire technical process and testing teh UAT to satisfy teh end user

Environment: VB 6.0, Oracle 8i, Windows 98