SUMMARY:

Extensive career Experience in Data Warehousing, and Decision support Systems, and has Wide Experience in implementing Data Warehousing solutions to large corporate clients and has professional experience working with various industries such as Banking, Financial, Secondary Insurance, Manufacturing and Pharmaceutical.

• Strong Consulting experience in Implementing Full Life cycle Data Warehousing Projects.
• Skilled in defining and implementing the various components of a data warehouse such as Operational source systems, Data staging, Data presentation and Data access tools.
• Strong in designing Star Schemas and snow Flake Schemas.
• Skilled in Converting the Business Logic into Technical Specifications.
• Over 8 years of experience in Extracting, Transforming, Loading (ETL) and Maintaining of Data Warehouses and Data Marts using IBM WebSphere DataStage ETL process, handling large data loads, performance tuning for large data loads in optimized time using DataStage (Server Jobs & Parallel Jobs).
• Having 7 years of high-end programming experience using PL/SQL, SQL*Loader, Unix Shell Scripting & Perl.
• Excellent knowledge in Extraction, cleansing and modification of data from/to various Data sources, Flat files, Mainframe COBOL files and Comma Delimited files.
• Extensively worked on Parallel Jobs using Various Stages like Sequential File, Data set, CFF, Lookup, Join, Merge, Aggregator, Remove Duplicate, Filter, Funnel, Copy, Surrogate Key Generator, Sort, Switch, Transformer, Change Capture, Oracle Enterprise, DB2/UDB Enterprise Stage.
• Designed and developed jobs using Parallel Extender for splitting bulk data in to subsets and to dynamically distribute to all available nodes to achieve best job performance.
• Extensively worked on Quality Stage jobs using Match, Standardize and Survivor stages.
• Implemented necessary Unit Test Plans to ensure the successful execution of the data loading processes.
• Involved in the User Acceptance Testing phase.
• Over 4 years of experience with Business Objects, Web Focus.
• Conceptual knowledge on SAP R/3 and SAP BW
• Expertise in deploying OLAP tools, Materialized Views, and partitioning techniques for highly responsive Decision Support Systems.
• Implemented XML, Java & J2EE Technologies.

Educational Qualification:

• Bachelor’s Degree in Electrical & Electronics Engineering

Technical Skills:

• ETL Tools: IBM WebSphere DataStage v 8.1,7.5.2/7.1
• Data Quality tools: Quality Stage 7.x, 8.1.
• OLAP Tools: Web Focus 7.6.10 & Business Objects XI/6.5.1/6.1b/5.x/4.x
• Operating Systems: Unix ( Sun Solaris , AIX ) and Windows - XP ,NT
• RDBMS: Oracle 8i/9i/10g/11g, DB2 8.1 and SQL Server 2005.
• Languages: UNIX Shell Script, Perl, SQL, PL/SQL, Java & C++.

Professional Experience:

Confidential, (Dallas – TX)
Sr. DataStage Developer
07/2010 to till date

Confidential,

Confidential,is used to identify the services and products sold by FedEx Office in many of the systems across the organization. The SKUs currently used are restricted to 4 digits, which limits the total number of products and services that can be uniquely identified to 9999. Additionally, SKU numbers are not able to be re-used due to year by year historical revenue reporting issues as well as tax related issues. Expansion of the 4 digit SKU number is needed to sustain the ability to add new items and services offered by FedEx Office.

Responsibilities

• Involved in business requirements gathering from all the impacted systems like RETEK, TODS, OTPC, XPAY, ECOMM, Data Warehouse and preparing architecture design documents
• Involved in preparing ETL Software Requirements Specification Documents for development and testing.
• Involved in impact analysis and identified all the ETL jobs across all DataStage Projects that are impacted with SKU Expansion.
• Involved in ETL Development to load modified SKU Dimension Table and SKU history Table added to Data warehouse.
• Involved in ETL Development to modify various Fact Tables loads to include additional SKU dimension fields.
• Involved in ETL Development to modify the SKU feeds to different systems.
• Involved in ETL Development to load the parts explosion and SKU parent child relationship data into reporting tables.
• Extensively worked on Parallel Jobs using Various Stages like Sequential File, Data set, Lookup, Join, Aggregator, Remove Duplicate, Modify, Filter, Funnel, Copy, Surrogate Key Generator, Sort, Switch, Transformer, Change Capture, Oracle Enterprise.
• Involved in creating System test plans and prepare the Environment ready for system test run.
• Involved in unit test, system test, integration and UA testing.
• Involved in preparing implementation plan and code migration from development to test and production environments.
• Implemented UNIX shell scripts to FTP the files from different servers, validate, and process the Flat Files for different projects
• Involved in Autosys jobs design and development for scheduling the ETL jobs.

Environment: IBM WebSphere DataStage v 8.1, Oracle 10g/11g, Business Objects XI 3.0, Flat files, SQL, PL/SQL,TOAD, Windows XP and AIX UNIX ,Autosys.

Confidential, (Saint Paul – MN)
Sr. DataStage Developer
02/2010 to 6/2010

Confidential,

Confidential,) Client and Prospect Data, the Employee, Opportunities, Activities that pertain to the HNW Client, Prospects and the Generated & Derived Data that in-turn feeds the Reporting programs that generate Standard and Adhoc Reports to Business Line to track and gauge the performance.

Responsibilities

• Involved in business requirements gathering and preparing architecture design documents for subject areas like clients, employee, opportunity, revenue goals and activity.
• Involved in preparing Technical Design Documents for ETL development and testing.
• Involved in writing UNIX shell scripts to transfer data from operational data source to ETL staging area.
• Developed Datastage parallel and server jobs to extract operational source data and transform according to mapping rules and load into Reporting mart.
• Extensively worked on Parallel Jobs using Various Stages like Sequential File, Data set, CFF, Lookup, Join, Merge, Aggregator, Remove Duplicate, Modify, Filter, Funnel, Copy, Surrogate Key Generator, Sort, Switch, Transformer, Change Capture, Oracle Enterprise, DB2/UDB Enterprise Stage.
• Involved in creating System test plans and prepare the Environment ready for system test run.
• Involved in unit test, system test, integration and UA testing.
• Involved in code migration from development to test and production environments.
• Involved in Autosys jobs design and development for scheduling the ETL jobs.

Environment: Datastage7.5.2, Microsoft SQL Server 2005, Oracle 10g/11g, DB2 8.1 , Web Focus , Flat files, SQL, PL/SQL, SQLLDR, TOAD, Windows XP and AIX UNIX ,Autosys .

Confidential, (Salt lake city, UT)
Sr .DataStage Developer
05/2005 to 12/2009

Confidential,warehouses data to primarily support the lending function of the bank. CIR provides data to allow any user to identify and monitor a customer\'s total relationship with the bank. CIR supplies the capability to combine obligations from multiple customers into a single lending relationship, provides debt and deposit totals at the customer and lending relationship level to create credit presentations, and creates management reporting for loan portfolios at the officer and cost center levels. The CIR online system is deployed over the internal Intranet to the user population. CIR also provides online viewing of various relationship level, operational, and management daily, weekly, monthly and quarterly reports developed from the CIR database.

Responsibilities

• Translating business requirements into Data Mart design and develop ETL logic based on the requirements using DataStage Tools.
• Involved in loading source data into database to support unit test, system test and UAT.
• Used Ascential Datastage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into Data Mart.
• Developed all Parallel jobs to improve performance by reducing the runtime for several jobs.
• Extensively worked with DataStage Parallel Extender for parallel processing to improve job performance while working with bulk data sources.
• Extensively worked on Parallel Jobs using Various Stages like Sequential File, Data set, CFF, Lookup, Join, Merge, Aggregator, Remove Duplicate, Filter, Funnel, Copy, Surrogate Key Generator, Sort, Switch, Transformer, Change Capture, Oracle Enterprise, DB2/UDB Enterprise Stage.
• Involved in code deployment from Test Environment to Production Environment.
• Involved in the implementation of Control files for SQL Loader to populate database tables.
• Involved in the implementation of UNIX shell scripts to process the Flat Files.
• Involved in the implementation of UNIX shell scripts to invoke the Datastage jobs.
• Involved in the implementation of UNIX shell scripts to copy the files among different servers.
• Involved in creating System test plans and prepare the Environment ready for system test run.
• Involved in Control-M jobs design and development for scheduling the ETL jobs.
• Involved in weekly and monthly production support , Monitor production jobs and resolve production issues and make data available to business within the time

Environment: Datastage7.5.2/ IBM WebSphere DataStage v8.1, Quality Stage7.5.1/8.1, Oracle 10g/11g, DB2,
Business Objects XI, Flat files, SQL, PL/SQL, SQLLDR, TOAD, Windows XP and UNIX, Comtol_M.

Confidential, (Plainsboro, NJ)
Sr. DataStage Developer
06/2004 to 04/2005

As a DW developer designed, developed, and deployed Data Stage Jobs and associated functionality. The warehouse employed highly complex data transformations including Slowly Changing Dimensions and a series of Stored Procedures, which made performance tuning and efficient mapping highly critical.

Responsibilities

• Responsible for creating and testing ETL jobs composed of multiple Data stage jobs using Data stage job sequencer.
• Created several general routines (Before-After, Transform function) used across the project.
• Developed various jobs using Ora OCI, ODBC, Hashed file, Aggregator, Sequential file stages.
• Implemented XML Plug-ins for reading data stage log files and populated system a table with audit data.
• Imported Oracle schema in to data stage with Manager for data mappings.
• Used shared containers for multiple jobs, which have the same business logic.
• Used Data Stage Manager for importing metadata from repository, new job categories and creating new data elements
• Tuned Data Stage jobs for better performance by creating Data Stage Hash files for staging the data and lookups.
• Used the Manager to import, export jobs/routines.
• Created Oracle SQL scripts for data testing and data validations.
• Created shell scripts, which will invoke the Data Stage jobs passing all the variables for the job to execute like Source and Target databases connection information, user id, password and others, file locations.
• Worked with all Data Stage components for Data conversion & loading data into target.
• Created database procedures, functions using PL/SQL.
• Creation of reports like Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports. Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed reports using BO-6i Report Designer and Distribute them using BCA.
• Used Business Objects to develop Financial Reporting System for developing Financial Reports for its various branch locations across United States.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.

Environment: Data Stage 7.0/7.5, XML plug-ins, Quality Stage & Meta Stage, Audit Stage, Profile Stage, version control, and Oracle 8i/9i, PL/SQL, HP-UNIX and Windows NT Business Objects-6i.

Confidential, (Milwaukee, WI)
Sr .DataStage Developer
08/03 to 06/04

• Designed, Tested and Ran Parallel Jobs.
• Extracted data from OPS/MVS, COBOL mainframe system.
• Designed architecture set up for development, Test & Production environments.
• Collected Business requirements from users and prepared specifications.
• Used Oracle warehouse builder for migrating data from source oracle system to staging oracle Database
• Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
• Used the Data stage Director and its run-time engine to Schedule running the solution,
• Testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
• Designing and Developing Procedures, functions, and packages to create Summary tables.
• Mapping Data Items from Source Systems to the Target System.
• Extensively used Meta Stage for importing metadata from ER/Studio Tool and export
• Used Meta stage (Process Meta Broker) tool to capture meta data of data stage for reporting.
• Implemented Quality stage for standards of data patterns.
• Parsed the data by using the quality stage for data cleansing process.
• Used the Data stage Designer to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Migrated projects from development to test to production environments.
• Implemented production data warehousing best practices.
• Designed specifications for reports.
• Developed Reports for Global Reporting Factory Application.
• Installed & Configured BO & WEBI & BCA on AIX.
• Designed Universes for multiple subject areas.
• Designed reports for multiple user groups

Environment: DB2, UDB, OPS/MVS, COBOL mainframe, Oracle Warehouse Builder, Quality Stage, Meta Stage, Data Stage 7.0 XE390 /6.X (Manager, Designer, Director, Administrator, Parallel Extender) ER/Studio, AIX 5.1, Business Objects 6.0,J2EE, java, XML & Autosys

Confidential, (St.Louis, MO)
DataStage Developer
12/02 to 07/03

• Involved in business requirements gathering.
• Designed and documented business & physical model for the warehouse and data marts.
• Defined star schema data model for data marts, & warehouse and ER model for ODS.
• Migrated DB2 data & COBOL files to oracle data warehouse.
• Implemented CFF stages for migrating mainframe COBOL files to oracle warehouse.
• Designed server jobs for migrating data from staging area to warehouse to data marts.
• Formatted, Cleaned, summarized, aggregated and transformed data into data warehouse.
• Developed database triggers for data validations.
• Designed and implemented slowly changing dimensions methodologies.
• Used Data Stage jobs called from Unix shell programs in batches.
• Provide technical support for data warehouse
• Deploy application to end-users.
• Responsible for integrating the data warehouse on both Windows and Unix platforms.
• Designed, build, and maintained Business Objects universes.
• Responsible for fitting Business Objects into the Information Architecture of the company as well as supporting business users and developing new and maintaining existing Universes.
• Design and develop extensive Business Objects reports, including complex reports using multiple queries, combination chart and tables, Will set up Business Objects Universe for each reporting group Assist in establishing a Business Objects environment.
• Interaction with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution.

Environment: Data Stage 5.1/6.0/XE, Mainframe, COBOL, DB2, Business Objects 5.1.4, Oracle 9i, AIX UNIX

Confidential, (Bethlehem, PA)
Data Ware House developer
04/2000 to 11/2002

This warehouse deals with different aspects of steel business. Main process is to build a Decision Support System and to provide the access of reports to all the top management members of the company to take qualitative decisions based on historical/current performance. The data warehouse is stored on Oracle database. The DSS was built using BUSINESS OBJECTS.

• Installation and configuration of BO and repository set up.
• Used BO for standard reporting and Adhoc reporting.
• Designed universe for Products Offering Application.
• Gathered functional requirements and designed Technical specifications.
• Designed and developed standard reports and summary reports.
• User support for ad-hoc reporting point of view.
• Conducted training for ad-hoc users.
• Maintenance of development and production repositories.
• Development, QA & UAT for all reports.
• Implemented drill down with slice & dice options.
• Written VB script for Automation of certain functionalities.
• Scheduled reports with Document Agent Server.
• Developed High-level security with supervisor.
• Performance and tuning of the reports

Environment: Oracle 7.3.2, Windows NT, Unix, Shell Script, and Business Objects4.1