SUMMARY:

• Over 7 Years of experience in Analysis, Design and Development in the fields of data Warehousing, Data Integration, Data Migration and developing Client server application using IBM (Ascential) DataStage (8.1/7.5x/6.x/), Oracle, PL/SQL, DB2 UDB, Teradata.
• Extensively worked using Data Stage Client components such as Data Stage Designer, Director, and Administrator in Data Warehouse development.
• Extensively worked on DataStage Designer and developed various complex jobs, routines
• Extensively worked on creating sequences, dependency across various jobs, and scheduling data stage jobs using Sequences
• Involved in Data Modeling and creation of Star Schema and Snowflake Dimensional Schema, Data Mart
• Extensively worked on various stages such as Dataset, File Set, Oracle Enterprise, Lookup, Lookup file set, Transformer, Sort, Aggregator, Join, Merge, Copy, Modify, Remove Duplicates, Funnel, Slowly Changing Dimension, Peek, Row Generator, Column Generator, and Surrogate Key Generator for developing Parallel jobs.
• Proficient in developing UNIX Shell Scripts
• Used Control-M and AutoSys as scheduling tools
• Developed various PL/SQL Programs as part of the ETL Application wherever required.
• Experience in using SQL*Loader to leverage the benefits of faster loading.
• Expertise in Data Warehousing techniques for Data Cleansing, Slowly changing dimension phenomenon
• Extensively worked on Production issues as part of post implementation support and maintenance. Involved in highly demanding and production support environment and follow-up with QC Tickets
• Used Data Stage partition concepts such as hash, round-robin, random, Entire, and others to tune the jobs
• Analyzing the Source System data and Understanding of business requirements.
• Experience in all phases of the Software Development Life Cycle (SDLC).
• Strong analytical and problem solving skills with ability to work within team and independently. Strong communication, time management and interpersonal skills.
• Strong customer interface, problem-solving, managing, planning, analyzing, designing and programming capabilities.
• Excellent troubleshooting capabilities, resolving both functional and performance issues.
• Provided after hours production support for the components with pager.
• Extensively worked on gathering requirements from users and hands on experience in documentation and designing with Visio.
• Excellent team player with good written and interpersonal communication skills.

PROFESSIONAL EXPERIENCE:

Confidential,West Allis, WI Apr ’08 – till date
Sr.ETL Developer
Material System was designed to help reduce administrative work related to purchasing. The system is aimed at automating and taking care of all activities relating to materials sequence of activities from the receipt of purchase requisition to goods received. The module consists, Vendor Maintenance/ Purchase requisition/ Requirement planning/ Inquiry for quotation/ Vendor selection/Preparation of Purchase Order/material received note/ MRN Inspection/Stores issue voucher (SIV).

Responsibilities:

• Involved in requirements gathering to implement theData Warehouse, and Data Marts
• Developed various jobs to read from Complex Flat Files from Flat Files and Database, transform and load to Target databases.
• Involved in all the phases of building the Data Marts like analyzing the business requirements, ETL process design, performance enhancement and maintenance.
• Worked with QC and Prod Support teams and bug fix and followed-up with QC-Tickets.
• Extracted data from various source systems like Oracle, SQL Server, and Flat Files.
• Extensively Worked on Parallel Extender (PX)
• Extensively used DataStage Designer to design, develop ETL jobs for extracting, transforming and loading the data into different DataMarts.
• Used various stages of Parallel Jobs such as aggregator, sort, transformer, sequential file and hashed file.
• Performed Import and Export of DataStage components and table definitions using Data Stage designer.
• Created sequences to sequentially execute the designed jobs.
• Participated in data model review discussions and provided the inputs to data architect.
• Created Stored Procedures to transform the data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Used After/ Before job routines to perform specific task.
• Written various Unix Shell Scripts for scheduling and formatting the files.
• Implemented enhancements to the current ETL programs based on the new requirements.

Performed Unit Testing, Integration Testing and User Acceptance Testing (UAT) for every code change and enhancement.

Environment: Ascential DataStage 8.1/7.5.3, Oracle 10g, TOAD, PL/SQL, SQL, Control M, UNIX Shell Scripts, ERWIN

Confidential,Chicago, IL Jan ’07 – Mar ’08
Sr.ETL Developer
The aim of CDS (Consolidated Data Source) was to build a Data Warehouse to capture and store data from OLTP (Online Transaction Processing System) for business analysis. Data stage was used to load source data into the database. This data warehouse is used for analyzing customers information, and their insurance status, also for customer details like contract status and for shipment details etc. This Data Warehouse is also used by business users for enterprise decision making and business analysis.

Responsibilities:

• Involved in requirement gathering and analysis to define business and functional specifications.
• Involved in data modeling. Worked closely with data modeler and database architect during the design and development of ETL technical specification document
• Developed DataStage jobs for extraction transformation and loading of the data from source systems
• Extensively used Sequential File stage, DB2 UDB Stage, and Aggregator Stage during ETL development
• Used DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse database.
• Performed Import and Export of DataStage components and table definitions
• Used DataStage Director to monitor the Jobs performed, automation of sequence execution.
• Designed and created reusable components like Shared Containers
• Created and used views in Oracle to simplify the mappings and make them easier to maintain.
• Wrote / modified stored procedures, stand alone functions and PL/SQL packages to comply with the requirements
• Involved in Production Support and Operations teams to resolve production issues in a timely and efficient manner.

Environment: Ascential DataStage 7.5.1, DB2 UDB, SQL, PL/SQL, Teradata, SQL*Loader, Toad, Windows 2000, IBM AIX 5.2, Autosys and Erwin 4.0

Confidential,St Cloud, MN Oct ‘05 – Dec’06
ETL Developer
Working on Investment and retirement products banking application. The marketing software application is called USPRO. It helps bankers with Customer Relations by helping decide on the type of retirement benefits to choose. The main objective of the project is to implement new enhancements based on market conditions.

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and testing.
• Used IBM DataStage EE/Parallel Extender as an ETL tool to extract data from sources like DB2 and flat files and loaded to target tables.
• Developed Data stage Parallel jobs for various components and strings involved in the calculation of quotes and rates.
• Developed parameter driven ETL process to map source systems to target data systems with Data stage complete source system profiling.
• Created Parallel Shared Containers for reusable calculations in various strings.
• Developed Batches & Sequencers in designer to run & control set of jobs.
• Extensively used Data stage Designer stages such as ODBC, Aggregator, Transformer, Join, Dataset, Lookup, Funnel, Peek, Pivot and Modify.
• Used Director for executing, analyzing logs and scheduling the jobs.
• Worked on Control-M tool for scheduling and monitoring data stage job sequences
• Performed Import/export of various job components to various projects.
• Used Type2 mapping to update a slowly changing dimension table to keep full history.
• Involved in SQL & PL/SQL programming for procedures, functions, packages to extract data from various source systems.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts.

Environment: IBM Data stage EE 8.0(Designer, and Director), DB2 UDB, SQL, PL/SQL, Unix Shell scripts, SQL*Loader, TOAD, UNIX AIX 5.2., Control – M.

Confidential,Charlotte, NC Jan ‘05 – Sep’05
ETL Developer
The main functionality of the Monitor project was to do the performance analysis of the marketing campaigns.. The company’s data comes from different operational sources and stored in a staging database and then data is loaded into a centralized database for various strategic business reports. The project assisted the Marketing department to keep track of the money invested in the campaigns and keep a check of the flow of money by monitoring the quality of marketing in the project.

Responsibilities

• Involved in the requirements gathering, analysis to define business and functional specifications.
• Involved in Data Modeling discussions and provided inputs to data architect
• Prepared Functional and Technical Design for the Client
• Involved in designing, developing and documenting of the ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems (Oracle) feeds using Data Stage, PL/SQL and Unix Shell scripts.
• Extracted data from various sources like DB2, Oracle, XML and Flat Files and loaded to target tables.
• Used Datastage Designer to design and develop jobs for extracting, transforming, integrating, and loading data targets.
• Developed Shared Containers, which can be reused several times.
• Extensively used Data stage Designer stages such as FTP, Folder Stage, ODBC, OCI, Aggregator, Transformer and Hashed File.
• Used Job Control routines and Transform functions in the process of developing the job.
• Job Parameters were extensively used to parameterize the jobs.
• Used DataStage Director to schedule running the jobs, monitoring and debugging its components.
• Developed star schemas and created custom star schema as per the business requirements.
• Applied Performance Tuning logic to optimize jobs performance.
• Developed PL/SQL stored procedures for source pre load and target pre load to verify the existence of tables.

Environment: Ascential Datastage 7.x (Designer, Director), DB2 UDB, Oracle 9i, PL/SQL, Unix Shell scripts, TOAD, SQL*Loader, UNIX AIX

Confidential,Philadelphia, PA Sep’03 – Dec’04
ETL Developer

Clinical Information Architecture is a centralized gateway providing access to the company’s analytical and data reporting tools. It provides an automated interface to send real-time data updates. It also provides online validation of patient data. Modules involved: Data Management Utility - This provides the user the ability to view, validate and update patient data.

Responsibilities:

• Analyzed Source System data.
• Understanding of business requirement document and formulated the Technical solution.
• Used the Datastage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Developed many jobs for data processing, loading. Jobs are scheduled using Data stage Director.
• Imported Metadata from Oracle database. Imported metadata definitions into the repository.
• Exported and imported Data stage components.
• Performed Troubleshooting and Tuning of Data stage Jobs for better query performance.
• Involved in Writing the SQL/PLSQL query’s for Extraction of Data.
• Developed Shared containers for object reusability and to eliminate redundancy.
• Actively participated in discussions and implementation of Error Handling and Reject management functions.
• Extensively worked with Fact and Dimension tables to produce source - target mappings based upon business specs.
• Extensively used SQL tuning techniques to improve the database read performance through Data stage jobs.
• Involved in implementing Star Schema for the data warehouse using Erwin for logical and physical data modeling.
• Involved in Unit Testing, System Testing, Integration and Performance Testing of the jobs.
• Involved in discussions regarding technical and business requirement issues.

Environment: Ascential DataStage 7.5, Business Object 5.1, Oracle 9i, PL/SQL, Flat files, UNIX

Confidential,NY. June’02 – Aug’03
DataStage Developer
Responsibilities:

• Worked on Business Analysis, Design documents and requirements gathering.
• Created Dimensional Tables and Fact Tables based on warehouse design.
• Developed ETL Process to Load the Data from various database systems into single Warehouse Database using Data stage.
• Written the Job specifications for Parallel Jobs.
• Extensively worked on Director for Scheduling, Running, Monitoring the jobs.
• Performed import, export jobs from one environment to another.
• Worked with Data stage Administrator to create/modify/delete projects and unlock the Job.
• Imported table definitions from the different Plug-ins table definitions available.
• Extensively worked on Parallel Extender to develop Parallel Jobs.
• Extensively used Shared Containers to reuse the logic in another Job.
• Reviewed the jobs, prepared the review comments and bug fixing.
• Used both Pipeline and Partition Parallelism for improving performance.
• Extensively used Oracle, SQL Server, ODBC, Dataset, Sequential, Lookup, Join, Merge, Sort, Aggregator and Transformation Stages. Etc.,
• Implemented Slowly Changing Dimension to insert data into DIMENSIONAL Tables.
• Perform necessary unit, performance and integration tests, as and when needed.
• Adopted performance-tuning techniques to improve the ETL process.
• Worked with Business Analysts (BA) to verify BRS.
• Environment: Data Stage 7.5.1, UNIX, TOAD and Oracle.

• Master of Science in Mechanical Engineering