Manager Project

Madhavi ValluruETL/DataStagei

Phone: 302-***-****

: **************@*****.***

Resumes ID: 48698

Location:, Delaware

Posted: 11.08.2012

Resume Details:Summary

* ***** ** ***** ** experience in the Analysis, Design, Development, Testing, Implementation and Support for Data Warehousing for various industry verticals.

IBM certified Datastage developer 8.0.1.

Experience in Dimensional Data Modeling, Star/Snowflake schema, FACT & dimensions tables.

Excellent communication and interpersonal skills and strong ability to perform as part of a team and individually.

Experienced in Full Life Cycle Development of building a Data Warehouse for large technology projects including Analysis, Design, Development, Testing, Maintenance and Documentation.

Practical experience in Quality Assurance – designing and execution of test cases, test scripts and test procedures

Very strong experience with various versions of Ascential Datastage.

Working knowledge on different data sources as Flat files, Oracle, SQL Server, and DB2.

Used Quality stages for enrich data to meet business objectives and data quality management standards

Worked with UNIX Shell scripts for Job control and file management.

Hands on experience in tuning ETL jobs, identify and address performance bottlenecks in various levels like sources, targets and mappings.

Hands on experience in Migration Projects

Extensively Worked on Job Sequences to control the execution of the job flow using various activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities

Complete team co-ordination involving task allocation among team members and holding frequent discussions to monitor progress of project work

Experience in working onshore-offshore business model.

Extensively worked on Parallel Jobs using Various Stages like Join, Lookup. Lookup File Set, Change Capture, Filter, Funnel, Copy, Surrogate Key Generator, Sort, File set, Sequential File, Data set, Oracle Enterprise, Merge, Aggregator, Remove Duplicate Stages.

Strong interpersonal, written and verbal communication skills. Multilingual, highly organized, detail-oriented professional with strong technical skills.

Education:

Bachelor of Computers from S.V University

Skills / Tools

ETL Tools

Datastage (8.1.x/PX/EE, 7.x)

Operating Systems

IBM AIX 4.2 and Windows(Server 2003, NT 4.0)

Languages

Unix Shell,C

RDBMS

Oracle 11g/10g/9i/8i/, SQL Server 7.0/6.5, PL/SQL,Teradata v2r5, DB2 UDB 7.1

Scheduling tools

Control-M/Autosys

Experiences:

Project Summary:

#1.GMIS American Express, AZ

Environment: IBM InfoSphere Datastage 8.1, DB2, UNIX Shell Scripting, AIX 4.2

Feb’10 to Jan’12

Introduction:

The primary objective of the Global Merchant Information Strategy (GMIS) Reporting & Analytics (R&A) Initiative is to enable access to consolidated merchant data and to power analytical capability in order to answer key business questions more effectively and efficiently across all regions of American Express. There is a proven overlap of data used by business constituents across systems and regions (approximately 70-80%). This program seeks to improve analytics by addressing the business need to access globally consistent key metrics, integrated with the merchant information needed for their core business decision making.

A consolidated program approach enables the business to centralize on a consistent global data model and realize scale and scope synergies through a common platform/implementation.

Responsibilities:

Involved in Analyzing the Business Requirements

Responsible for Extracting the data from source systems (Flat Flies, DB2) Transforming and Loading data into data warehouse.

Involved in designing of LLD and Mapping documents.

Used various Stages such as Sequential File, Dataset, File set, Transformer, Lookup, Filter, Aggregator, Join, Sort, Funnel, and Merge.

Used DataStage Designer tools for creating Parallel jobs and importing and exporting the jobs.

Used DataStage Job Sequences to execute the jobs in a sequence order.

Used Quality stages for enrich data to meet business objectives and data quality management standards.

Used DataStage Director to run and monitor status of the jobs.

Created DataStage Jobs to build business rules to load data.

Involved in preparation of Unit test case document and contributed the test paln.

Involved in execution of Unit test cases.

Involved in Performance Tuning and Enhancement.

#2. Lenovo_EDW Lenovo, NC

Environment: IBM InfoSphere Datastage 8.1, DB2, SAP 7.10, BI 7.0, SAP PACK, UNIX Shell Scripting, AIX 4.2 Aug’08 to Feb’10

Introduction:

Lenovo operate as a company organizational structures using world sourcing to harness the power of innovation across global team. They design innovative and exciting products and services to meet the customers’ needs. Currently I am involving in Lenova_EDW Phase–II is SAP-BW migration to DB2 by using IBM WebSphere Datastage8.1.In this Project mainly we are doing SAP extraction and load into stage tables and reject analysis means which is not met to the business requirements. The main objective of the project is migrate from SAP-BW to DB2 and built the Data Warehouse.

Responsibilities:

Understanding the existing business and customer requirements.

Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into Warehouse.

Used the stages like SAP BW Openhub, Copy, Transformer, Sort, Lookup, Join.

Used DataStage Director to validate, run and monitor the jobs.

Used DataStage Manager to export, import the DataStage jobs.

Develop the job according to the given design document, Prepare Unit Test plan for the jobs.

Implemented best performance strategies during the project.

#3. International Film Distribution System (IFDS) Sony, CA

Environment: Ascential Datastage 7.5.1 PX (Enterprise Edition) Oracle 10g, UNIX IBM AIX 4.2. Jan’07 to Aug’08

Introduction:

SONY Pictures Entertainment (SPE) is the media/entertainment unit of Sony Corporation of America, the U.S arm of Japanese electronics giant Sony,is home to Columbia Tri-Star Motion Picture Group, also under the Sony Pictures Entertainment umbrella are Sony Picture Television (TV production

& distribution), Columbia Tri-Star Home Entertainment (home video acquisition and distribution), and Sony Picture Digital Entertainment (digital production). Sony Pictures is in the business of distribution of Pictures in the domestic & International Markets. Sony Pictures uses the IFDS Application for booking, billing, box office collection, cash application, print control, and Accounts receivables for theatrical product, distribution business. The purpose of this data conversion is to be able to retain and re-engineer any data from the various territories that have been identified as in scope for the IFDS Replacement project that can be utilized and maintained in the new system.

Responsibilities:

Extensively used DataStage designer to develop Jobs for extracting, transforming, integrating and loading data into Target tables.

Used the stages like Sequential File, Funnel, Transformer, Aggregator, Sort, Lookup, OCI, ODBC, Peek stage…

Used DataStage Director to run and monitor the DataStage jobs.

Developed Jobs in DataStage for loading data from source to target.

Used DataStage Manager to export, import the DataStage jobs.

Contribute in Unit Test plan creation and validation

#4. Data Integration Project (CTP-CRAS) Lloyd’s, UK

Environment: Ascential Datastage 7.5.2/7.5.1 PX (Enterprise Edition) Oracle 9i, UNIX IBM AIX 4.2 May’06 to Jan’07

Introduction:

Data Integration Involves the Commercial Transformation Programmer (CTP), in which Commercial customers and accounts will be migrated to the retail operating model and supporting systems. CTP will change some of the source systems that produce extracts to CRAS (Credit Risk Assessment System). This will inevitably result in changes to the content of some of the data feeds. The system will receive data on a monthly basis from a number of systems. CRAS is supporting Business Banking operating model for credit monitoring renewal of facilities and monitoring of customer risk and facility take up for Business Banking.

Responsibilities:

Understanding the business functionality & Analysis of business requirements

Review of the documents and ensure its prompt delivery to the Business for approval.

Worked on DataStage – DataStage Designer, DataStage Manager and DataStage Director. Involved in the development of DataStage jobs.

Developed parallel jobs with collection of all source stages, target stages and processing stages like Aggregator, Transformer, modify, look-up, join etc.

Implemented Local containers for same job and Shared Containers for multiple jobs that have same business logic.

Designed Generic jobs which will run for multiple instances

Created Job Sequencer for dependency jobs and to run the jobs by using parameters.

Viewing Log for the jobs and cleaning up the resources using Director.

Running and monitor the jobs in Director.

Used most of the stages such as the Transformer, Datasets, Sequential File, Aggregator,, Peek, Funnel, Change Data Capture etc.

Involved in Unit Testing and Test plan preparation to meet proper testing activity.

#5. Data Integration Project (CTP-Statements) Lloyd’s, UK

Environment: Ascential Datastage 7.5.2/7.5.1 PX (Enterprise Edition) Oracle 9i, UNIX IBM AIX 4.2. Jan’05 to May’06

Introduction:

Lloyds TSB Private Banking Limited is regulated by the Financial Services Authority and a signatory to the Banking Code. Registered in England

The main objective of CTP Statements project is to reduce the postage cost by merging the bills from TBMS-F with the statements for the customers from CBS. The customer’s bills from TBMS-F will be included with the invoice statements from CBS if the bill sheets will fit into the same envelope, which holds a maximum of 9 sheets (this number can be configured and updated through a parameter for future requirements), and sent to the customer. This will reduce the postage cost as an estimated 85% of the bills can be sent with the statements in the same envelope.

Responsibilities:

Understanding the business functionality & Analysis of business requirements

Involved in the preparation of the Detailed Platform Application Design document

Review of the documents and ensure its prompt delivery to the Business for approval.

Worked on DataStage – DataStage Designer, DataStage Manager DataStage Director. Involved in the development of DataStage jobs.

Developed parallel jobs with collection of all source stages, target stages and processing stages like Aggregator, Transformer, look-up, join etc.

Created Job Sequencer for dependency jobs and to run the jobs by using parameters.

Viewing Log for the jobs and cleaning up the resources using Director.

Running and monitor the jobs in Director.

Used most of the stages such as the Transformer, Datasets, Sequential File, Aggregator, Peek, Funnel, etc.

Involved in Unit Testing and Test plan preparation to meet proper testing activity.

Prepared the Deployment guide and release notes for the project. Which contains the entire configuration details and paths of project deliverables which will be useful for system testing to deploy the build?

Having exposure to Connect: direct software which will transfer the data from one system environment to another environment.

Having exposure to QC, where we can reassign the build for System testing people.

Contact this candidate