PROFESSIONAL SUMMARY:

• Have around 7.5 years of IT experience in software development, designing and implementing high quality business solutions, with major focus on Data Warehouse and ETL processing.
• Strong experience in building and developing strategies for Extraction, Transformation and Loading from disparate sources into Data warehouse and Data Marts by using IBM/Ascential Data Stage 9.1/8.7/8.5/8.1/7.5(Designer, Director, Manager and Administrator).
• Extensive experience in DW/ETL requirements gathering, design and testing for many data extractions and data migration projects.
• Used the Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Expertise in working with IBM Datastage, Administrator, Manager, Designer, Director, Parallel Extender and Quality Stage.
• Implemented complex business rules using different Stages, Jobs, Sequencer, Shared Containers etc.
• In depth experience in dealing with Data Stage stages (Hash, ftp, merge, sort, aggregator, lookup, transformer, Join, Funnel, filter etc.).
• Implemented logic for Slowly Changing Dimensions.
• Experience in integration of various data sources like Oracle, DB2, Teradata, SQL Server, MS Access, XML and Flat files into the Staging Area.
• Extensively used TOAD 9.0/8.5 to access Oracle database and Control center to access DB2 Database.
• Experience in Scheduling the DataStage jobs using Control - M, Autosys.
• Excellent Knowledge of SQL, PL/SQL, Stored Procedures, Function, and Triggers.
• Experience in programming using SQL, PL/SQL, and UNIX Shell Scripting.
• Strong Experience in Unit testing and System testing of the DataStage jobs.
• Performed Debugging, Troubleshooting and performance tuning of DataStage Jobs.
• Expertise in OLTP/OLAP System Study with focus on Oracle Hyperion Suite of technology, developing Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables) used in relational, dimensional and multidimensional modeling, physical and logical Data modeling using Erwin 4.2/4.1/3.x.
• Involved in designing and preparing Functional specification documents, Technical specification documents, Mapping Documents for Source to Target mapping with ETL transformation.
• Strong Experience in Banking, Financial, Medical, Retail and Insurance Domains.
• Excellent communication and interpersonal skills, teamwork, problem solving skills, flexible, self-direct and energetic person.

TECHNICAL SKILLS

ETL Tools: IBM Information Server 9.1/8.7/8.5/8.1/7.5,Qualitystage 8.7/8.1 (Administrator, Designer, Director), Parallel Extender

Scheduling Tools: Control-M, Autosys

Dimensional Data Modeling: Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions tables, physical and logical data modeling, Erwin 4.1.2/3.x

Programming Languages: C, C++, java, Unix shell scripting, SQL, PL/SQL

Operating Systems: Microsoft Windows, UNIX

Databases: Oracle 11g/10g/9i, DB2 UDB 9.7/8.0, Teradata v2R6/v2r5

DB Utilities: Toad, SQL*Loader, Sql Assistant

PROFESSIONAL EXPERIENCE:

Confidential, Arlington Heights, IL

DataStage Developer

Responsibilities:

• Designed and Developed various new processes, Fixed the existing process with new business requirements and meetings with users for Input.
• Designed and developed jobs for extracting, transforming, integrating, and loading data into data mart using DataStage Designer.
• Developed, executed, monitored and validated the ETL DataStage jobs in the DataStage designer and Director Components.
• Worked with DataStage Director to schedule, monitor, analyze performance of individual stages and run DataStage jobs.
• Extensively used change capture, Transformer, Modify, copy, Join, Funnel, Aggregator, Lookup Stages and development stages to develop the parallel jobs.
• Worked with data feeds from various source systems from flat files, XML files, Teradata server databases.
• Used SSH to exchange the keys between servers for secure file transfers.
• Extensively used File set stage like Sequential file for extracting and reading data.
• Involved in analyzing and modifying the existing scripts.
• Have worked on unix shell scripts to encrypt the flat files(sensitive data) to gpg and send them to business for auditing purpose.
• Developed Sequences and used different Stages like Execute Command, Job Activity, Notification Activity, Routine Activity, Sequencer, and Wait for File Activity stages.
• Coordinated the code and data movement to production in production implementation activities.
• Designed the draft or spread sheet to schedule the jobs in control-m.
• Job properties and environment variables were edited for performance tuning and ease of implementation.
• Defined test cases as a part of user testing and drove testing cycle execution of both SIT and UAT. Also documented the results for test cycles.
• Enhancements are made to jobs as per the requirements and Unit testing of the jobs.
• Involved in production support activities.
• Involved in writing scripts for loading data to target data warehouse using mloads.
• Involved in the preparation of ETL documentation by following the business rule, procedures and naming conventions
• Performed Troubleshooting and Tuning of DataStage Jobs for better query performance.
• Reviewing the developed jobs based on the build review checklists.
• Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data.

Environment: IBM Information Server Datastage 9.1, Oracle, Teradata, DB2 UDB, SQL, Unix Server, Flat Files, Complex Flat Files, UNIX scripting, Control-m.

Confidential, NYC

DataStage Developer

Responsibilities:

• Designed jobs to extract and load data, optimize and transform the data as per business requirements.
• Extensively used DataStage Designer, Director, Admin and Web console.
• Developed jobs in Parallel Extender using different stages like Join, Lookup stage, Oracle Enterprise DB2 Connector, ODBC stage, FTP stage, CFF stage, Copy stage, Filter, Aggregator, Change Capture and Funnel stages.
• Developed Job Sequencer and batches and have edited the job control to have jobs run in sequence.
• Performed Troubleshooting and Tuning of DataStage Jobs for better query performance.
• Implemented logic for Slowly Changing Dimensions Type II by using Date methodology.
• Optimized DataStage jobs utilizing partitioning and pipelining features of DataStage.
• Responsible for UNIT, System and Integration testing. Developed Test scripts, Test plan and Test Data.
• Involved in designing and implementing Best practices for ETL processes. The Best practices include Restartability, Recovery, Parameter standardization, Error Management and Capacity planning etc.
• Wrote SQL queries for Unit testing and Validation purposes.

Environment: IBM Information Server Datastage 8.7(Quality Stage, Parallel Extender), Oracle, Unix Server, DB2 UDB, SQL, Flat Files, Complex Flat Files, UNIX scripting, Autosys JILs Scheduling and programming.

Confidential, Hartford, CT

DataStage Developer

Responsibilities:

• Responsible for implementing proper SDLC from the design document, development, unit test and performance test to production.
• Worked on tuning Data stage server engine and parallel extender to improve existing processes for extracting, cleaning, transforming, integrating, and loading data into Teradata target tables.
• Involved in designing and implementing Best practices for ETL processes. The Best practices include Restartability, Recovery, Parameter standardization, Error Management and Capacity planning etc.
• Configured the DataStage projects - created projects, enabled project properties and set the user accounts using DataStage Administrator.
• Converted business rules into ETL processes using Parallel Extender/Server jobs and extensively wrote user SQL coding for overriding for generated SQL query in DataStage.
• Developed Master Controlling Sequencer jobs using DataStage Sequencers to maintain the dependency between jobs and restartability.
• Optimized DataStage jobs utilizing partitioning and pipelining features of DataStage.
• Worked extensively in performance tuning by removing performance bottlenecks that occurs in the target, source, mapping and session.
• Developed user defined Routines and transformations to implement business logic and Shell scripts to automate file manipulation and data loading procedures
• Extensively used SQL scripts to unit test and validate proper functioning of DataStage code.
• Wrote Shell scripts to run DataStage jobs, for passing parameters to DataStage jobs and to automate the FTP process to transfer the files between the UNIX and Windows

Environment: IBM Infosphere Server Suite 8.1/8.7 (Designer, Director and Administrator), Ascential DataStage (Designer, Director, Manager and Administrator), Test Director, Autosys, Oracle 11g, UNIX AIX 5.3, IBM Cognos 10.1, SQL Server, Oracle, Teradata, Windows XP, Erwin.

Confidential

DataStage Developer

Responsibilities:

• To study the business functions and flow control with various levels of users.
• Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
• Performed tuning on database queries, ETL mappings and end-user queries.
• Developed Architecture for building a Data mart by using data modeling.
• Developed Analytical applications that can analyze large amounts of online and offline data.
• Worked with Datastage Manager for importing metadata from repository.
• Used the Datastage Designer to develop processes for Extracting, Cleansing, Transforming, Integrating, and Loading data into data mart database.
• Worked on programs for scheduling Data loading and transformations using Data Stage from legacy system to Data Warehouse.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging and monitoring the Datastage jobs.
• Wrote shell scripts to automate file manipulation and data loading procedures.
• Unit tested and deployed the jobs to Production.

Environment: Ascential DataStage 7.x (Designer, Administrator, Manager, Director), Oracle 8i, PL/SQL, UNIX.