PROFESSIONAL SUMMARY:

• Over 16+ years of Data warehousing experience in the areas of ETL design and development. Involved in complete software development lifecycle (SDLC) of various projects, including requirement gathering, system designing, data modeling, application development, maintenance and support.
• Extensive ETL tool experience using multiple versions of IBM WebSphere DataStage. Worked on DataStage client tools like DataStage Designer, DataStage Director, DataStage Manager and DataStage Administrator.
• Extensive knowledge of data warehousing, business intelligence and ETL processing.
• Strong understanding of the principles of DW using fact tables, dimension tables and star/snowflake schema modeling.
• Experienced in scheduling server and parallel jobs using Autosys, DataStage Director, and UNIX scripts.
• Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
• Worked with and extracted data from various database sources Teradata, Oracle 10g/9i/8i, DB2, SQL Server and Sequential files.
• Experience in troubleshooting of jobs and addressing production issues like performance tuning, load balancing and enhancement.
• Knowledge in using ERwin as leading Data modeling tool for logical (LDM) and physical data model (PDM).
• Knowledge in Reporting Tool such as Cognos.
• Assisted in development efforts for Datamarts and Reporting.
• Technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience using rational toolset like Clearcase for source code migration and version management.
• Knowledge in using PL/SQL to write stored procedures, functions, and triggers.
• Involved in conversion project of Datastage jobs to Ab - Initio
• Involved in providing support in Dev, QA and Prod environments.
• Ability to analyze, diagnose and resolve complex programming and system problems independently.
• Excellent communication, interpersonal, analytical skills and strong ability to manage and motivate the team.

TECHNICAL SKILLS:

ETL Tools: IBM Infosphere DataStage 8.7, 8.5, 8.1, IBM Websphere Information Server 8.0 (Designer, Director, Administrator), Websphere DataStage 7.5.X (Designer, Director, Administrator, Manager), Ascential DataStage 7.0/6.0.

Data Modeling: Data Modeling, Star Schema Modeling, Snowflake Modeling, Fact and Dimensions, Physical and Logical Data Modeling, ERwin.

Databases: Teradata, Oracle 10g/9i/8i, IBM DB2/UDB, SQL Server 2003/2005/2008.

Tools: Autosys, Clearcase, UC4, SQL Plus, Version One,SQL*Loader, TOAD.

Operating system: IBM AIX 5.2/4.x, Linux, Windows 2000/2003/XP. 

Languages: SQL, PL/SQL, Unix Shell Scripting, HTML

.WORK EXPERIENCE:

Confidential, Plano, TX 

Developer

Responsibilities:

• Involved with Business users and ETL Leads from different teams to implement ETL Frame Work using Server/PX combination of jobs.
• Extracted data from various sources like DB2 UDB, Flat Files and loaded into a Corporate Data warehouse.
• Upgraded to IBM Websphere DataStage 7.5.1 from Ascential DataStage 7.0.
• Implemented various strategies for Slowly Changing Dimensions using PX jobs.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Filter, Dataset, Lookup File Set, Remove Duplicates, Change Data Capture, Switch, Modify and Aggregator.
• Involved in developing Designer- Server and PX jobs for Extracting, Cleansing, Transforming, and Integrating/Loading Data into Corporate Data Warehouse (CDW).
• Developed Job Sequencers with restart capability for the designed jobs using Job Activity, Exec Command, E-Mail Notification Activities and Triggers.
• Extensively designed, developed and implemented Parallel Extender jobs using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Extensively used Director to Monitor and check the run statistics of the Jobs and to clear the job logs, job resources.
• Extensively used - Manager to Export/import components.
• Involved in Unit Testing of the jobs.
• Created Shell scripts for scheduling various Batch jobs.
• Used configuration management tools like ClearCase/ClearQuest for version control and migration.

Environment: IBM Websphere Datastage 7.5.x (Director, Designer, Manager, Administrator), Ascential DataStage 7.0, DB2 UDB 8.1.6(EEE), SQL Server, DB2, UNIX Shell Scripting, Clear Case/Clear Quest, IBM AIX

Confidential, Chicago IL

Datastage Developer

• Worked as a Datastage developer on the on-going design and implementation of high quality conceptual, logical and physical data models working closely with technical and product teams in an Agile (SCRUM) environment.
• Operate with a team of architects (responsible for application and services) - in a setting that involves interacting with Product Management, Engineering/QA, and Operations.
• Work with the Architects, DBAs, and Senior Developers to identify, design and document data procedures and processes.
• Designed and developed ETL jobs using IBM Infosphere Datastage 8.7 to extract, transform and load the data into Teradata from SQL Server and Flat files.
• Achieved the performance tuning of datastage jobs during the development and QA phases.
• Developed Job Sequencers with restart capability for the designed jobs using Job Activity, Exec Command, E-Mail Notification Activities and Triggers.
• Migrated Datastage jobs from development to QA and production environments using import and export functions.
• Used UC4 to schedule the jobs in Development, QA and Production.
• Performed unit testing of Datastage jobs.
• Fulfilled exit criteria for development work including code review, unit test case review, and test case results.
• Used Version One as the project management tool in an Agile (SCRUM) environment.
• Actively participated in the Data Development Community of Practice, sharing knowledge, reviewing best practices and constantly seeking opportunities to fulfill the objectives of the IT organization.

Environment: IBM Infosphere Data Stage 8.7, Teradata, SQL Server, Version One, UC4 Scheduler, Flat files.

Confidential, Lincoln, NE

ETL Developer

Responsibilities:

• Designed the ETL jobs using IBM Infosphere Datastage 8.1 to extract, transform and load the data into staging and then into Oracle database.
• Designed and developed Server jobs and Parallel jobs which distributed the incoming data concurrently across all the processors, to achieve the best performance.
• Extensively developed and deployed UNIX Shell scripts as wrappers that provide values to DataStage jobs during runtime.
• Involved in the Performance Tuning of the DataStage jobs.
• Developed Server routines to do the Audit process.
• Scheduled jobs using Sequencers and Autosys job scheduler utility based on the requirements and monitored the development and test environments closely.
• Migrated projects from development to QA and production environments.
• Taking the regular backups of the jobs using Data Stage Manager Export/Import utility.
• Involved in creating Source to Target mapping document for all the ETL jobs.
• Involved in documentation of the steps that have been followed during the development process.
• Participated in Unit testing and Integration testing of DataStage jobs.

Environment: IBM Infosphere DataStage 8.1 (PX & Server), IBM AIX 5.2, Oracle 10g, Flat files.

Confidential, Minneapolis, MN

ETL Designer/DataStage Developer

Responsibilities:

• Designed the ETL jobs using IBM Web Sphere Information Server 8.1 to Extract, Transform and load the data into Staging and then into Teradata database.
• Prepared the Functional Design, Technical design, Unit Testing, Integration Testing, Turnover documents and Production Support documents for reference and Audit purposes.
• Developed Source to Target mapping document for all the ETL jobs.
• Created UNIX scripts for file transfers (FTP) and to call Data stage jobs.
• Used Clearcase as a code migration tool to move the code from development to QA and Production environments.
• Involved in performance tuning of datastage jobs by managing the Teradata utility and session usage.
• Supported Production applications.
• Experience with Trouble shooting applications with resource, bottleneck problems and implemented them for improving performance.

Confidential, Peoria IL

Datastage Developer/Data Conversion Developer/Data Analyst

Responsibilities:

• Designed and developed ETL jobs using IBM Infosphere Datastage 8.5 to extract, transform and load the data into SAP.
• Extensively used ABAP Extract and IDOC load stages for extracting and loading data from/to SAP R/3 repository.
• Used the Datastage Administrator for SAP to define the connection between datastage and SAP also to initialize and set up IDOC types for a new SAP Client
• Worked with the existing jobs to convert them into the GRID environment where they can be run in parallel.
• Achieved the performance tuning of datastage jobs by utilizing the grid implementation. (by creating a dynamic configuration file at run-time)
• Developed Job Sequencers with restart capability for the designed jobs using Job Activity, Exec Command, E-Mail Notification Activities and Triggers.
• Migrated Datastage jobs from development to QA and production environments using import and export functions.
• Used import and export inbuilt designer functionalities to migrate the datastage jobs.
• Performed unit testing of Datastage jobs.
• Loaded the Data into SAP R/3 using various programs like LSMW, Z-tran and Datastage.
• Created and managed the defects/tickets and scripts for tracking work assignments and executing loads using HPQC.
• Reviewed the functional specifications (CDD) and created the High-level design documents and technical design documents as per the specifications provided.
• Worked closely with various teams in various geographical locations.

Environment: IBM Infosphere Data Stage 8.5, DB2 UDB, SAP R/3 V 6.0, Remedy, HP Quality Center, TUFops, Flatfiles.

Confidential, Strongsville, OH

ETL/Sr. DataStage Developer

Responsibilities:

• Designed the ETL jobs using IBM WebSphere Information Server 8.1.
• Extensively used the designer to develop various parallel jobs to extract, transform, integrate and load the data into Corporate Data warehouse (CDW).
• Designed and developed the ETL jobs using Parallel Extender that distributed the incoming data concurrently across all the processors, to achieve the best performance.
• Handled Performance Tuning of Jobs to ensure faster Data Loads
• Extensively developed and deployed UNIX Shell scripts as wrappers that provide values to DataStage jobs during runtime.
• Worked with Slowly Changing dimension stage for implementing slowly changing dimensions.
• Used Director to monitoring jobs, run and validating its components.
• Involved in the Performance Tuning of the DataStage jobs using different methodologies like configurations of the environment variable file, designing and editing configurations, managing the Teradata utility and session usage, increasing the reading as well as the writing speed while fetching or loading data to files or databases.
• Migrated projects from development to QA and Production environments using Clear case.
• Performed the Integration and System testing on the ETL application.
• Taking the regular backups of the jobs using Data Stage Manager Export/Import utility.
• Assisted operation support team for transactional data loads in developing SQL & Unix scripts
• Participated in Unit testing and Integration testing of DataStage jobs.
• Scheduled jobs using Autosys job scheduler utility based on the requirements and monitored the production closely for any possible errors.

Environment: IBM Infosphere DataStage 8.1 (PX & Server), IBM AIX 5.2, Oracle 10g, Teradata, Flat files, Autosys, Clearcase.

Confidential, Gaithersburg MD

DataStage Developer

Responsibilities:

• Extensively used DataStage Designer to develop processes for extracting, transforming, integrating and loading data from various sources into the Data Warehouse database.
• Developed several complex ETL jobs for Historical data loads and ongoing data loads using various active and passive stages.
• Extensively used SQL queries to retrieve data from various database tables and used those queries in the jobs to reduce the complexity of processing data.
• Upgraded to IBM Websphere Information server 8.0 from IBM Websphere DataStage 7.5.3.
• Extracted data from flat files Transformed according to the requirement and Loaded into staging schema using various stages like sequential file, Aggregator, Transformer stage, Oracle enterprise, dataset, Look up, Aggregator, joiner, Remove Duplicates, Change capture, sorter, Column generators, Funnel and Sequencer.
• Involved in performance tuning of the jobs while developing the jobs.
• Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements.
• Created the various complex jobs to load the data from staging area to the application database and from there to data mart.
• Used Parallel Extender for splitting the data into subsets and to load data, utilized the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
• Transfer of large volumes of data using Teradata Fast Export, Multi Load.
• Developed batches and sequencers in designer to run and control set of jobs.
• Involved in importing and exporting jobs category wise and maintaining the backup regularly.
• 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.

Environment: IBM WebSphere Information Server 8.0 (Designer, Director, Administrator), IBM Websphere Datastage 7.5.x (Director, Designer, Manager, Administrator), DB2, Teradata, SQL Server, Oracle 9i, Clear Case.

Confidential, CA

DataStage Developer

Responsibilities:

• Extensively used for extracting, transforming and loading databases from sources including Oracle, Teradata and Flat files.
• Worked on Datastage Designer, Manager, Administrator and Director.
• Loaded data into load, staging and lookup tables. Staging area was implemented using flat files.
• Created jobs in DataStage to import data from heterogeneous data sources like Oracle 9i, Text files and SQL Server.
• Generation of Surrogate IDs for the dimensions in the fact table for indexed and faster access of data in server jobs.
• Ran jobs using Parallel Extender for splitting bulk data into subsets and dynamically distribute to all available nodes to achieve best job performance.
• Tuned transformations and jobs for Performance Enhancement.
• Created Batches (DS job controls) and Sequences to control set of jobs.
• Created Data Model using ERwin from data sources and defined the dimensions, levels and measures in the model.
• Utilized Parallel Extender PX, to optimize performance in this very large database environment.  
• Implemented the underlying logic for Slowly Changing Dimensions.
• Executed Pre and Post session commands on Source and Target database using Shell scripting.

Environment: Ascential 6.0, Parallel Extender PX, SQL Server, Oracle 9i, Teradata, Text Files, ERwin, UNIX.