Project Data

Sairam

E-mail: **********@*****.***

Ph. #: 858-***-**** (M)

Experience Summary:

Fifteen years of focused experience in Information Technology with strong

background in Data warehousing/Business Intelligence including 6+ years of

Design, Development, Testing and implementation of software applications in

SAP BW7.0/3.5, 8+ years of development & administering experience in

Informatica PowerCenter 8.0/7.X/6.X/5.X, 3+ years of experience

DataStage8.0 and 9+ years of experience in relational database in Oracle.

Technical Skills:

BI/ETL Tools: SAP BW 7.0/3.5, Business Objects XI R3/R2/6.x/5.x, Xcelsius

Informatica PowerCenter8.0/6.X/5.X, Informatica

Power Connect for SAP R/3, Power Exchange 5.1

(Striva/Detail),

RDBMS : ORACLE 10G, SYBASE 10.0, MS SQLSERVER 7.0

GUI/TOOLS : ERWin/ER1, Web Focus 4.3.x/5.x

Languages : C, SQL, PL/SQL, ABAP/4.

Operating Systems: Windows and UNIX

SONY ELECTRONICS LTD., San Diego, CA Jan '04 -

Present

Position: Lead Architect

Environment: SAP BW 7.1/3.5, DB2, ABAP/4

Projects:

. BI7.0 Technical Upgrade

. Implementation of EWM (Warehouse Management) Reporting in BW

. Calendar Change

. Oracle OMS conversion into SAP R/3 OMS for VAIO Retail and VAIO Direct

. Sony Style Reporting into BW

. ECC Upgrade

. Real-time Data Acquisition and Reporting

. Reports Broadcasting

. Service Module Reporting in BW

. Redesign of Point of Sale Reporting

Responsibility:

. Actively involved in identifying the Functional Area/Objects which

require changes and identifying and activating the business content.

. Involved in the group meetings to discuss the functional change need to

be made to reflect the OMS Conversion change, Calendar Change and

reporting changes.

. Updated the required functional & technical documents for the changes and

new reports.

. Analysis of MultiProviders to facilitate additional reporting on multiple

data targets.

. Created Process chains to schedule the new data loads.

. Worked with Operations Support Group to schedule new jobs and changes to

existing jobs.

. Upgrading Inventory functional area from BI 3.5 to BI7 and Post Upgrade

Support.

. Documented test cases coordinated various phases of testing, Complete

Unit Testing, Cycles of Integration Testing and Resolving defects and

technical issues.

. As the owner of the transports in the BW, reviewing the requests from the

team members and providing the transports after reviewing the FD and TD

updates as per the standards.

. As a Business Process Leader maintaining the transports related to all

the projects within BI team and working with basis team for the migration

of the transports to the different systems in the landscape.

. Working with basis and DBA team to improve the reporting and data load

performance.

. Working with basis team to complete the quality system post refresh

activities at the end of each month.

. Working with basis support to setup the project landscape for the new

projects.

. Working with basis support to clear SPAU/SPDD after the service pack

upgrades.

. Presenting the changes in Change Management meeting for the production

migration approvals.

. Managing the BW cutover activities.

. Implementing Report to Report interface (RRI) functionality in the

reports.

SATYAM COMPUTER SERVICES, Parsippany, NJ July '99 - Jan

'06

Client: Sony Electronics Jan.2003 to Jan

2004

The Sony Corporate data warehouse provides quality information within SEL

by reporting off integrated views of previously disjoined data using Oracle

web reports, Web focus & Business Objects. CDW with database size of 1

terabyte supports around 1500 users.

Environment: Oracle 9i, Informatica PowerCenter 8.0/7.1.3/6.2.2,

Informatica Power Exchange 5.1 (Striva/Detail), Power Connect for SAP/R3,

DataStage8.0, Business Objects 5.1.2, SQL*Loader, PL/SQL Cartridge, Erwin.

Projects:

Consolidate Sales and Orders Reporting (QUEST)

QUEST comprises of Sales, Orders, Budget and forecast details in a start

schema on Oracle DB. QUEST gets the data from mainframe, SAP and Oracle

systems. Reports are developed in Web Focus and Business Objects. Reports

generated will be used for Decision Support System and corporate analysis

purpose.

Sony On Line Asset Reporting (SOLAR)

The purpose of the SOLAR project is to enable and empower ISSA to analyze

customer data as it moves through the supply chain i.e. planning through

delivery of the product. This customer data is built around 29 specific

business metric reports and it gets the data from multiple legacy source

systems.

Key Metrics include:

. On Time Delivery, Commitment Attainment, Commitment versus

Forecast, Weeks of Supply and Sell thru Forecast Variance.

Responsibility:

. Defining and analyzing requirements with inputs from users group for data

modeling.

. Preparing functional specifications, data mapping documents and look up

data.

. Maintaining the data model using Erwin. Managing the data integrity

issues and Impacts.

. Installing and maintaining Informatica PowerCenter8.1/7.X/6.X,

Informatica Power Exchange5.1.0 on AIX UNIX.

. Performed upgrade from Informatica PowerCenter 6.2.2 to PowerCenter 7.1.3

and 7.1.3 to 8.X.

. Worked on a pilot project for Power Connect for SAP/R3

. Creation of Informatica mappings and workflows to load the data into the

fact and Dimension tables from different sources.

. Creation of Striva detail (Power Exchange) data maps to pull the data

from mainframe.

. Creation of Materialized views and partitions the oracle tables to

improve reporting performance.

. Monitoring ETL process and providing Production support.

. Creation of UNIX shell scripts to ftp the files from source.

. Creation of Control files and PL/SQL procedures to load the data from

flat files to oracle tables and for data cleansing.

. Responsible for the development of system test plans, test case creation,

monitoring progress of specific testing activities against plan, and

successfully completing testing activities within the requisite project

timeframes.

Client: Deutsche Bank, NY Feb.2000 to

Dec.2002

Environment: Oracle 8i, Informatica 5.1, Business Objects 5.1.2, SQL*Loader

on Sun Solaris 2.6(Server - IBM RS/6000 S80), Erwin

Project: Global Data Hub (GDH)

The Global Data Hub (GDH) provides globally standardized real time Asset

Management data services and facilitates global trade processing. GDH

consolidates accounting data from across the globe offices of Deutsche Bank

- Asset Management Group. The data is then made available as business

objects to underlying applications for view within and outside the Bank.

The data, which mainly consists of Security, Position and Transaction

information, is fed to the Hub from the accounting systems of local

offices. Essentially there are two types of processes applied on this data

before it is stored in the GDH warehouse. One, the data from individual

accounting systems is translated to a common set of codes maintained in

GDH. Two, the GDH performs standardized calculation on this data using

market prices that are directly fed to the warehouse. The two processes

together ensure consistency in data from across accounting systems.

Responsibility:

. Involved from the analysis stage to user acceptance stage.

. Interaction with users group and QSSG team to analyze the requirements

and designing the database and finalizing the lookup tables data.

. Involved in data mapping and ETL designing.

. Creation of control files to load the data using SQL*Loader.

. Creation of procedures and packages to process the data. Fine tuning of

the procedures. -Trouble shooting and Production support.

. Creation of mappings and workflows to migrate the process from control

files & stored procedures to Informatica PowerCenter environment.

Client: Jaguar Cars, NJ, USA

Sep. '99 to Feb.2000

Environment: Oracle 8.0, Visual Basic 5.0 on Windows 95

Project: Re-engineering Re-Marketing application

The Re-Marketing application was re-engineered with new set of business

rules and was also upgraded to a new version of the development platform.

The application reads flat files and loads the same against a set of

business rules. Three of the existing legacy systems was integrated and

migrated as one application.

Responsibilities:

. Analysis of the specifications provided by the clients

. Design and Development of front end screens using Visual Basic

. Developed reports using Crystal reports

. Involved in creation of stored procedures, triggers, tables and views as

part of the backend design for the RMJCC process to load and process the

data

. Responsible for overseeing the Quality procedures related to the project

Client: Selective Insurance Company of America, NJ, USA July '99 to Sep.

'99

Environment: Oracle 8.0, Visual Basic 6.0 on Windows NT4.0

Project: Flood Insurance Project, (FIP)

It consists of 3 different modules Claims, System Administration and

Financial Accounting for the flood insurance. I was involved for the System

Administration module. Major functions of System Administration module are

Agency Administration Maintenance, Commission Schedules Maintenance and

Writing Companies Maintenance.

Responsibilities:

. Created class objects, Master and Transaction processing screens using

Visual Basic

. Used ADO to interact with database.

. Preparation of Unit and System Test plans and Conducted System and

Unit Testing

HCL Infosystems Ltd. INDIA Jul '98 - June '99

Client: RGNDWM, Govt. of India

Environment: Oracle 7.1, Visual Basic 5.0/6.0, Designer 2000 on Windows 95,

Pentium

Project: Integrated Management Information System

Jul. '98 to June '99

This is an Integrated Management Information System of 10 different

modules. I was involved for Finance & Works Accounting System and

Contractor & Supplier Information System. Major functions in Finance &

Works Accounting System are keep track of the grants received from Govt. of

India for different schemes that will be executed by different implementing

agencies and utilization of the grant.

Responsibilities:

. Ascertaining and Documenting User Requirements in respect of new systems

and preparation of Software Requirement Specifications according to IEEE

standards.

. Building of the Detailed Design Documents for the new systems.

. Building of Process models, Functional Higherarchy Diagrams and Entity

Relationship Diagrams using Designer 2000.

. Back end development includes Triggers and Stored Procedures.

Karvy consultants limited, India Aug '97 - Jul '98

Client: Karvy Consultants Ltd., India

Environment: Sybase10.0, Visual Basic 5.0 on Windows 95

Project: National Securities Depository Ltd., (NSDL) Aug '97

to Jul'98

It is an Integrated Transaction Processing System for Mutual Fund

Management with Interactive Query/ Response. It facilitates Transaction

Processing for Dematerialization i.e.converting of physical documents of

Shares, Units, and Equities etc. to electronic holdings, Rematerialization

i.e. converting of electronic holdings to physical documents and data

transfer to NSDL Cell and from NSDL cell to update the current status of

electronic holdings for different account holders.

Responsibilities:

. Preparation of project plans such as Software Project Management Plan,

Software Quality Assurance Plan and Software Configuration Management

Plan.

. Preparation of Software Requirement Specifications.

. Building of the System Design Documents and test plans.

. Back end development includes Triggers and Stored Procedures.

. Development of Master and Transaction Processing Screens using Visual

Basic 6.0.

. Development of Transaction related Reports using crystal reports 7.0.

. Conduct of unit/module/system acceptance tests and Bugs Fixation.

. Conduct of Quality Audits. Implementation and User training

Shell Information Technologies, INDIA Jan. '95 - July

'97

Projects:

. Stores Management Information System

. Integrated Materials Management Information System

. Personnel Information Management System

Environment: MS Windows 3.1, Sybase 10.0, Power Builder 5.0, Visual Basic

3.0

Personal Profile:

Qualification : B.E in Mechanical Engineering

Contact this candidate