Data Sap

Sreenivasa Mandalpu

***** ******** *** #**

North Hollywood, CA -91602

Cell: 614-***-**** Home: 818-***-****

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

PROFESSIONAL SUMMARY

• 10 years of IT experience with 9 Years of strong experience in using ETL (Extraction,

Transformation, Loading) utilizing Informatica5.1/6.2/7.1/8.1 (Power Mart/Power

Center) and Business Intelligence utilizing Business Objects 6.1/5.X, Application

Foundation 5.

• Extensive experience in OLAP/DSS tools like Business Objects, Siebel Analytics,

MS-OLAP, Application Foundation, Oracle Discoverer and SAP Brio.

• Experience with Retail, Financial-mutual funds, Pharmaceutical and Supply Chain

Management.

• Experience in interfacing with SAP R/3, SAP BW and Oracle Apps 11i for data

warehouse requirements.

• Ability to analyze source systems and business requirements, identify and document

business rules, design data architecture.

• Extensive Knowledge in Dimensional Data modelling, Star Schema modelling,

Snowflake modelling, Fact and Dimensions tables, Slowly Changing Dimensions

(SCD’s), Physical and logical data modelling, using Erwin data modelling tool.

• Excellent working knowledge of UNIX shell scripting, job scheduling on multiple

platforms like windows NT/2000, Sun Solaris and AS/400 (Using OPCA Scheduler)

• Experience in all phases of a project lifecycle including Feasibility and Definition,

Analysis, Design, Development, Testing, Implementation, Support and Maintenance.

• Proven ability to work on multiple projects, interact at different levels with business

users and perform in a cross-functional team.

TECHNICAL EXPERTISE:

ETL Tools: Informatica Power Center 8.1/7.1/6.2/5.1, Power Mart 6.0/5.0

Reporting Tools: Business Objects 6.1/5.1/5.0, Cognos 7.3, Siebel Analytics, SAP

Brio, MS-OLAP, WebIntelligence, Application Foundation, SAP

BW, Oracle Discoverer.

Data Modelling Tools: Erwin4.0/3.x

RDBMS: Oracle 9i/8i, Teradata, SQL Server2000, MS Access.

Languages: SQL, TSQL, PL/SQL, C, C++, Java, UNIX Shell Scripting.

Oracle Utilities: SQL Loader, TOAD, SQL Navigator, SQL *Plus.

Web Technologies: HTML, ASP, MS FrontPage.

Operating Systems: Solaris, HP-UX, Red Hat Linux, MS DOS, Windows NT/2000/XP

EDUCATION

Master of Science (Computer Engineering) - University of New Mexico, Albuquerque.

Bachelor of Engineering (Electronics and Communications) - Osmania University, India.

PROJECT EXPERIENCE:

Client: Warner Bros Entrainment Inc, CA

Duration: February 2008 to Till date Role: Senior Enterprise Data Integration Specialist

Description:

MARVIN is Warner Home Video data warehouse for reporting Sales, Account Receivables,

shipping and handling data for Warner home video global users. Involved in interface design for

loading incremental transactional and master data from SAP BW and SAP R3 to MARVIN.

Responsibilities:

• Involved in design and development of Business Content Interface (BCI) frame work

which leverages SAP Business Content Extractors. This frame work is designed with

objective to bypass data extraction from SAP BW. BCI Framework is developed using

Informatica powerconnect BCI methodology.

• Developed Informatica workflows to extract data from SAP BW info spokes and load data

to Teradata Stage tables using Teradata external loaders fastloader and mloader.

• Transformed transaction based data feeds from SAP IDOCs from Standard SAP format

to customized Warner data structures using Informatica Powercenter ALE/IDOC data

integration interface

Involved in Informatica upgrade effort from version 7.1.4 to version 8.5.1

•

Environment: Informatica Power Center 8.5/7.1, AIX, Windows XP, Teradata, SAP R/3, SAP

BW, Business Objects XI, Tidal scheduler.

Client: Abbott Vascular, CA

Duration: August 2006 to December 2007 Role: ETL Designer

Description:

Abbot Vascular Data Warehouse (AVDW) is main data repository for reporting Sales, Rebates,

Shipments, Inventory, Commissions and Open Orders to US Commercial division business users.

Acted as ETL Designer on AVDW project to provide ETL development standards, Data Auditing

process and design interface to receive data from external sources. The data is mainly sourced

from SAP R/3, extensively interacted with SAP team to build the interface to receive SAP data

into AVDW.

Responsibilities:

• Involved in setting the ETL development standards and guidelines for developing the

mappings.

• Involving in designing the dimensional data model using Erwin Data Modeler.

• Designed process for Data Auditing.

• Designed error handling strategy with in Informatica mappings.

• Analyzed the functional Specifications with Business Analysts and converted functional

specification into detailed technical Specifications.

• Conceptually modeled functional components and systems interfaces to downstream

applications.

• Designed and developed Informatica mappings for source system data extraction; data

staging, transformation, validation, and error handling.

• Migrated external interface Informatica mappings from version 7.1 to Version 8.1.

• Involved in Informatica repository administration.

• Analyzed SAP R/3 table for data requirements for reporting.

• Extensively coordinated with SAP team for designing the SAP feeds to AVDW.

• Created extensive documentation on the design, development, implementation, daily

loads and process flow of the mappings.

• Mentored new team members in getting up to speed with development.

• Involved in End user testing.

Environment: Informatica Power Center 8.1, AIX, Windows XP, Oracle 10g, ERWIN Data

Modeler, SAP R/3, Control M.

Client: Capital Group Companies, CA

Duration: April 2006 to August 2006 Role: ETL Designer

Description:

The Capital Group Companies (CG) is one of the most experienced and successful investment

management organizations. Acted as ETL designer on the MIDAS project designed to provide

‘American Funds’ shareholder transaction and accounts data to the SAP-BW system. This data

was sourced from various source systems including Mainframe, Oracle DWH, Excel and SAP-R/3

using Informatica and delivered to SAP BW. Informatica’s Power connect for SAP was utilized to

extract master data from R/3 to be loaded into Oracle for validation during the transformation

process.

Responsibilities:

• Extensive user interface to gather requirements and perform business analysis.

• Participated in converting requirements to detailed design.

• Profiled source systems to identify data gaps and data quality

• Designed error handling strategy for Informatica ETLs

• Created technical specifications for all mappings and interfaces.

• Analyzed the source systems to create a road map for the ETL process.

• Designed and developed the Informatica mappings for source system data extraction;

data staging, transformation, validation, and error handling.

• Designed testing procedures and test plans for mappings, workflows, and interfaces.

• Developed schedule processing scripts using Autosys scheduler.

• Coordinated and executed historical data loads.

• Created extensive documentation on the design, development, implementation, daily

loads and process flow of the mappings.

• Managed Change control implementation and coordinating daily, monthly releases and

reruns.

Environment: Informatica Power Center 7.1, HP-UX B.11.11, Windows XP, Oracle 9i, ERWIN

Data Modeler, SAP BW, SAP R/3, Autosys.

Client: Cisco- Linksys, CA

Duration: November 2005 to April 2006 Role: Senior Data warehouse Developer

Description:

Finance Base Margin Data Mart is one of the important metric used to support sales reporting in

Finance and Sales operations. This data mart contains Base Margin fact with Base Margin

Granularity at BU/SKU/Day level. The base margin is calculated from Account receivables,

Material transactions and GL transactions of Oracle ERP. Summary reporting of Base Margin

across different dimensions is facilitated by Aggregate tables. The data from Oracle ERP is

consolidated in ODS using Informatica PowerCenter then loaded into Linksys Data Warehouse

(LDW). The Base Margin Measure is analyzed across different dimensions using Siebel

Analytics Dashboards and adhoc reporting is supported by Siebel Answers.

Responsibilities:

• Involved in the design, development and implementation of ETL processes for loading

AR, Material and GL transactions into Operational Data Store and consolidating the data

for Base Margin processing in LDW.

• Designed the dimensional data model for Data Mart using Erwin data Modeler.

• Extensively used Informatica Power Center to create mappings, sessions and

workflows for populating the data into the dimension, facts, and aggregate tables

constantly from different source systems.

• Deployed reusable transformation objects such as mapplets to avoid duplication of

metadata, reducing the development time.

• Designed the data model for the Base Margin Data Mart using Reverse Engineering and

Forward Engineering features of ERWIN.

• Involved in designing the physical and logical layers for presenting Base Margin Metric in

Siebel Analytics using Siebel Administrative workbench.

• Defined the Metrics for Base Margin Dash Board using Siebel Analytics.

Environment: Informatica Power Center 7.1, Solaris 5.6, Windows 2000, Oracle 9i, ERWIN

Data Modeler, Oracle Apps 11i.

Client: SEM Materials, OK

Duration: August 2005 to October 2005 Role: Senior Data warehouse Developer

Description:

The main objective of PACE ODS is to implement outsourcing agreement between Pace Global

System and Sem Materials. Pace Global Systems pays utility invoices for SemMaterials in return

for a fee and sends the data related to the payments to SemMaterials daily. The amounts

processed by Pace Global Systems will be sent to the Oracle Apps general ledger in summary

format for accruals and payments. Accruals entries will be generated daily when Pace Global

Systems processes the invoices. The accrual entries will create the expense entries at a service

& cost centre level and the liability side will be summarized and booked by company and liability

type.

Responsibilities:

• Involved in the design, development and implementation of ETL processes for loading

Utility Charges and Payments data into ODS for General ledger accruals and payment

processing.

• Designed the Source - Target mappings and Involved in designing the Selection Criteria

document.

• Fine-tuning the new Informatica mappings for performance optimization.

Environment: Informatica Power Center 7.1, Solaris 5.6, Windows 2000, Oracle 9i, ERWIN

Data Modeler, Oracle Apps 11i.

Client: Hewlett Packard, Singapore

Duration: June 2004 to July 2005 Role: Senior Data warehouse Developer

Description:

RADAR (Reports Analysis Data Repository) is a central data repository of Asia Pacific region

Image Print Group (APAC IPG). This application consolidates information and facilitates analysis

along subject areas like Shipment, Orders, Forecast, Quota and Revenue, across several

divergent Finance data source. RADAR gets data from RSAP BW (SAP BW), XPRESS (Oracle

DB) and flat files. This data from divergent data sources is consolidated and loaded into SQL

Server database using Informatica Power center. Reports are designed using Business Objects

data reporting tool as per user requirements and scheduled through Broadcast agent. The OLAP

capability is supported by MS-OLAP cubes.

Responsibilities:

• Analyzed the functional requirements and arrived at Technical solution with the help of

Data Modelling methodologies using ERWIN.

• Implemented ETL logic using Informatica Power Center for loading master data and

transaction data into the warehouse for analytical reporting needs of IPG Finance group.

• Developed ETL mapping in SQL server using DTS to load data from Staging to Data

warehouse

• Identified ad-hoc reporting requirements through user interviews.

• Designed Business Objects Universe for reporting requirements of IPG Finance group

• Created Business Objects report specifications and guided the development team in

developing Business Objects reports.

Environment: Informatica Power Center 7.1, Solaris 5.6, Windows 2000, Oracle 9i, SQL

Server 2000, SAP BW, SAP R/3, Business Objects, Web Intelligence and Broadcast Agent.

Client: Experian, GA.

Duration: October 2003 to May 2004 Role: ETL Developer

Description:

The JJill Group, Inc. is a specialty retailer of high quality women’s apparel, accessories and

footwear that markets its products through its catalogs, retail stores and e-commerce website.

The MMDB (Multi Channel Marketing Database) is Experian’s solution to provide JJill with an

integrated view of their customer data. The JJill MMDB (Multi Channel Marketing Database)

Project is concerned with the extraction of data from the various source files and loading them in

a consistent and integrated database using Informatica as ETL tool. This database is designed to

support the Campaign Management and Decision Support components. MMDB is facilitating ad-

hoc query and reporting via the Business Objects reporting tool & Web Intelligence.

Responsibilities:

• Involved in the design, development and implementation of ETL processes for MMDB

(Multi-Channel Marketing Database) data mart for integrating and centrally storing

Customer data.

• Analysed and prepared functional requirements.

• Created logical & physical data models using Erwin.

• Created source definitions for specially created flat files coming from various source

systems and relational target definitions for the data mart.

• Designed and developed various mappings for ETL processes using Mapping designer.

• Created and executed test cases & data for sessions to verify ETL processes.

• Tuned the database design to cater to reporting needs and better performance.

• Automated ETL processes using UNIX shell scripts.

• Developed and tuned stored procedures using Oracle SQL and PL/SQL.

Environment: Windows 2000, Solaris 5.6, ERWin, Informatica PowerCenter (6.2), Oracle

8i, Korn scripts

Client: Somerfield, UK

Duration: June 2002 to September 2003 Role: Data Warehouse Developer

Description:

BIDS is Buyers Information Desktop. The main objective of this project is to give Buying department the

product performance information across all the stores and early visibility on the performance of promoted

products by comparing actual sales against forecasted sales on the first few days of the promotion.

Responsibilities:

• Designed and Developed the Business Objects Universe for BIDS.

• Created canned reports as well as adhoc reports for Business users using Business

Objects.

Environment: Windows 2000, Solaris 5.6, AS/400, ERWin, Informatica PowerCenter (5.1),

Oracle 8i, Business Objects (5.1).

Client: Somerfield, UK

Duration: July 2001 to April 2002 Role: ETL Developer

Description:

Somerfield maintains a Data warehouse (Information Warehouse - IW) using ORACLE 8i

database and Business Objects front end. The IW System stores all relevant Business data

including the two-year history.

Responsibilities:

• Extracted source data from Oracle, SQL Server, Flat files and IBM Mainframes using

Informatica, and loaded into Oracle or flat file targets.

• Created Informatica mappings for initial load and daily updates. Involved in testing of

Informatica mappings

• Developed, tested stored procedures, functions and packages in PL/SQL.

• Analyzed the query performance and designed the loading process schedules.

• Wrote shell scripts to process the PL/SQL procedures and wrote the PL/SQL program

units for data extracting, transforming and loading

Environment: Informatica-Power Center 5.0, Oracle 8, Erwin, SQL, PL/SQL, Solaris, AS/400

and Windows NT 4.0.

Client: Research Bureau, New Mexico Department Of Transportation (NMDOT)

Duration: November 1999 to May 2001 Role: Application Developer (Intern)

Description:

Research Bureau is research and development wing of New Mexico Department of

Transportation The main objectives of Information Systems Integration project is to integrate

information residing in different databases spread across different departments of NMDOT and

provide complete, current and more timely data.

Responsibilities:

Involved in following phases of the project

1. Data Acquisition

2. Data Validation:

3. Operations/Reporting:

4. Database Administration:

Environment: Oracle 8i, SQL * Loader, SQL, PL/SQL and Windows NT 4.0.

Contact this candidate