David Mbogo Email: acn3jc@r.postjobfree.com

Sr SAP EIM Consultant - Integration and Implementation Specialist

(SAP BW, SAP BI, SAP BODS & HANA)

Summary:

Over 10 years of information systems experience in Deployment,

Architecture, Design and Development of SAP Products with focus on Business

Objects Data Services/ Data Integrator, Legacy to SAP data Migrations, SAP

BI-BO implementations, Enterprise Reporting, Data Warehousing and ETL.

- Exceptional Success in Team leadership, providing technical leadership

support on the use of SAP Information Management tools for both

offshore and onsite business models

- Excellent communication skills with the ability to interact directly

with client, business and IT leads

- Very Strong in Business and Project Analysis, Blueprinting and Project

Planning, Techno-Functional SAP BI expertise, SME in BI integrating

with PS, SD, MM, FI and Master Data Governance

- Expert in SAP Upgrade and Legacy Data Migration using IDOCS, LSMW and

RDS

- Successfully Completed 6 major SAP implementations (Legacy to ECC,

Legacy to BW, HANA using BODS), One SAP Rapid Marts implementation

covering SAP GL, AP, AR, PS and SA Rapid Marts

- Hands on experience in Business Objects data services (BODS)

architecture framework (Extracts, Profiling, Cleansing,

Transformations and Loading), BODS Designer, Data Quality, and

Information Steward.

- Hands on experience in Business Objects Enterprise reporting using

BOBJ Universe Designer, Crystal Reports, Web Intelligence, Lumira and

BO Explorer

- Hands on experience in SAP ERP /ECC functional modules : FI-CO, MM,

PP,SD

- Hands on experience in designing, developing and configuring SAP

Business Warehouse 3.5 and 7.x.

- Hands on experience in designing SAP BW Info Objects, Info Cubes,

DSOs, Data Sources, Transformations, Process Chains using data

warehousing principle Layered Scalable Architecture (LSA)

- Hands on experience in SAP HANA Modeling (Attribute, Analytic &

Calculate views), data provision using: SLT &BODS, reporting and

security.

- Experience in Data Architecture, Data Modeling, Data Cleansing and

Database Programming (PL/SQL).

- Experience in Installing and Upgrading DI 6.5 to BODS 4.2 in Windows

and UNIX environment.

- Hands on Experience with BO EIM products (Data Services/Data

Integrator, Metadata Manager, Information Steward) administration,

environment maintenance and providing day-to-day operational support,

troubleshooting and fixing production issues.

- Hands on experience in hardware sizing, software installations,

landscape setup and configurations of core BO EIM Enterprise product

suite; data Services, information steward.

- Experience in SAP escalation process to resolve product issues working

along with SAP support and system integrator.

- Hands on Experience working with BODS Web Services, Adapters for Sales

force and configuring ODBC data direct drivers.

- Extensive hands on experience with SAP Business Objects Information

Steward to extract, transform and load master data and transactional

data for validation

- Thorough hands-on development experience with HANA Modeling, data

replication and creation of BODS ETL jobs to populate HANA tables

- Experience in Retail, Manufacturing, Pharmaceuticals and Chemical

industries SAP implementations.

- Strong understanding of Business requirements & converting them into

HANA Model design blueprints, Converting Functional Specifications

into Build.

- Strong understanding of Business Objects information requirements,converting them into functional specifications, delivering conceptual

designs, developing, implementing, and support of SAP BW/BODS/HANA

solutions

Specialties:

. SAP Business Objects Suite: 4.x, 3.x BODS, DQM, Web

Intelligence, Crystal Reports & Excelsius

. SAP BI-BO Integration

. SAP Information Steward

. SAP Rapid Marts (AP, AR, GL, Inventory, PS and Sales)

. HANA Modeling

. Data Warehousing & ETLOracle, SQL Server, SQL and PL/SQL

Technical Skills:

. Data Warehouse: SAP BI 7.0,7.3,BW 3.5/3.1, EDW, Informatica 9.0

. ERP Packages: SAP R/3 4.6, SAP Net weaver 2004s.

. ERP Integration: SAP R/3 - SD, MM, FI, CRM

. Reporting Tools: SAP BEx, WAD, Query Designer, SAP Business Objects

R3.1, SAP Business Objects 4.0 (WEBI, Xcelsius, BO Explorer),

. Business Objects : BOXI 3.2, BO4.1, BOD1 3.2, Business Objects Data

Services 4.0 and 4.1

. SAP HANA 1x SP70

. Operating Systems: Microsoft Windows 9X/ NT/2000/XP/Linux RH4- LRH5

. Other Tools: MS VISIO, MS Outlook, MS Word, MS Excel

Professional Experience:

Hitachi Consulting,

Job Title: Sr SAP Data Migration Lead (EIM / BODS / Data Services /

Information Steward)

Industry: Chemical

Period: August 2014 to November 2014

Client: Albemarle, Baton Rouge, LA

Environment: SAP Net weaver 2004s stack, ERP 4.6c,SP BW 7.0, BOBJ 3.1, BI

4.2,Microsoft Server 2000, 2005, 2012, SAP Data Integrator 6.5,DI

3.1,DS 4.2, Web Intelligence, BO Lumira, HANA 1x SP 70.

Project: Manufacturing Analytics and Data Services Upgrade

Project Overview: The overall objective of the project is to upgrade the

Current BODI Infrastructure from SAP DI 6.5 and 3.1 to HANA Repositories

and SAP Data Services 4.2.

. Involved in architecting the ETL solution that is aligned with project

requirements

. Involved in Hardware sizing for the SAP Data Services 4.2 and sizing

the data migration environment to handle appropriate volumes of data

. Involved in Preparation of Upgrade Strategy for Data Integrator 6.5

and 3.1 to SAP DS 4.2

. Installed and configured SAP Information Management software including

Information Steward, Data Services and SAP Business Objects

Information Platform Services

. Integrated SAP Data Services, Information Steward and Platform

Services

. Migrated Data Integrator from 6.5 on Server 2000 to DI 3.1 on Server

2005

. Migrated Data Integrator 3.1 Server 2005 to DS 4.2 Server 2012

. Migrated all Data Services Repositories to SAP HANA 8.2

. Integrated SAP BW, ECC & SQL Source and Targets with Data Services

. Migrated and Tested all the Data Services Jobs and Workflows, Conducts

bug scrub meetings and status review meetings

. Planned, developed, and executed various components of system testing

and/or quality assurance.

. Worked on Data Services CMS for Jobs Schedule and Configuration

. Conducted performance tuning and capacity management for the Data

Services Jobs

. Provided technical leadership on the use of SAP Information Management

tools to perform ETL, data profiling, building quality scorecards

using Information Steward

. Worked with IT and business users to resolve support and technical

questions and Implemented patches and other day-to-day BODS

administration task

. Ensured the project team is enabled to deliver the project on-time,

within budget and at the highest level of customer satisfaction

. Extensive hands on experience with SAP Business Objects Information

Steward to extract, transform and load master data and transactional

data for validation

. Developed and designed HANA Information Models : Attributes views,

Analytic views and Calculation views, Extracting, Transforming and

Loading the Data through Oracle and into HANA Data Base

Accenture LLC,

Job Title: Sr SAP Reporting Lead (ECC / BO / BODS /BODI / HANA )

Industry: Retail

Period: July 2012 to August 2014

Client: AT&T Wi-Fi, Austin, TX

Environment: SAP Net weaver 2004s stack, ECC6.0, BOBJ 3.1, BO 4.0, Oracle

11g., BODI 3.2, BODS 4.1, Web Intelligence, BO Explorer, HANA 1x SP 70.

LRH4 & LRH5

Project: Alliance and BI Reporting

Project Overview: The overall objective of the project is to support the

Current BODI Infrastructure, Optimize the performance, install and manage

new Rapid Marts, Consolidate the Rapid Marts Jobs,create a file transfer

to external server, Upgrade the Data Services to BODS4.1, Support ETL

Loads to Oracle and HANA Systems and the Reporting Requirements .

. Worked with business process owners, stakeholders to understand and

document the requirements. Interacted with the manager to understand

the business requirements and implemented the business rules to

redesign and enhance the existing dataflow.

. Installed and Configured Information Platform Services (IPS), Data

Services 4.2 and Information Steward 4.2 components on Linux Server.

Configured the Repositories, Users and Security on BOE platform

. Participated in Blue Print discussions and identified the Profiling

rules and scorecard requirements to configure in Information Steward.

Identified the Data Cleansing rules that needs to be implemented in

Data Services 4.2

. Design and Development of various batch/real time jobs for data

migration.

. Invoked BAPI calls from data services to pull and push the data

from/to SAP.

. Configured the development, QA and production data services

environment and migrated the jobs from one environment to other.

. Played vital role in BODI Rapid mart( AP,AR,GL) installation &

configuration

. Involved in Migration of Jobs from Dev to Test, Test to Production and

customization of Rapid mart Jobs as per the requirements.

. Heavily used the LSMW with IDOCS, ABAP Programs, and Direct Batch

Programs for loading the data back in ECC

. Implemented best practices, development standards for Data Services

and Information Steward

. Participated in data quality analysis, standardization and validation,

and develop data quality metrics

. Developed business rules, transformation rules, validations, error

reports and data quality reports using Business Objects Information

Steward

. Through workshops gathered Business requirements converting them into

HANA Model design blueprints and Functional Specifications into Build

for SAP HANA models

. Developed and designed HANA Information Models : Attributes views,

Analytic views and Calculation views, Extracting, Transforming and

Loading the Data through Oracle and into HANA Data Base

. Steered bug scrub meetings and status review meetings and providing

quality assurance feedback throughout the project life cycle and

status reports to project business owner

. Created test estimates from design documentation and creates quality

assurance project schedules.

. Defined information requirements,converted them into functional

specifications, delivered conceptual designs, developed, implemented,

and supported SAP WEBI and explorer reports using SAP HANA and Oracle

systems

. Handled tickets with different priority tickets and Maintained Work

History for all test tickets until it is closed down and submitting

the Ticket Status (Open/Close) report.

.

Cognizant Technology Solutions,

Job Title: Sr SAP BW/BI/ Onsite Lead

Industry: Retail

Period: May 2012 to July 2012

Client: 3M, St Paul,MN

Environment: SAP Net weaver 2004s stack, BI7.0, ECC6.0, E.P 7.0, BOBJ 3.1,

BO 4.0

Project: BW Upgrade & Enhancement Projects

Project Overview: The overall objective of the project is to support the

Current BW/BI Upgrade Project and provide support to Production

environment.

. Interact with stakeholders, Coordinate workshops/meetings to ensure

all requirements are captured and hold design sessions with key

customer personnel and vendors

. Held Regular calls with offshore to review projects, scope, and

timelines and to make sure project coordination and deliverables as

per the plan and within budget.

. Prepared Functional Documents and Technical Documents detailing the

mappings of R/3 Fields with BI Info Objects per the requirements and

leveraging business contents.

. Installed Standard Business Content Extractors, Info Cubes and DSO

objects, Info objects to fulfill user requirements for SD Extractors

. Developed ETL logic using Transfer rules, Update rules and Start and

End routines using ABAP to incorporate Business logic and perform data

manipulation.

. Created, Scheduled and monitored Info Packages and process chains to

automate load from SAP ECC 6.0 Extractors to BW

. Steered bug scrub meetings and status review meetings.

. Involved in Planning, developing, and execution of various components

of system testing and/or quality assurance.

. Management and coordination of change request testing activities and

timelines to meet planned implementation dates.

. Involved in Development of specific test conditions and expected

results for functional and regression Test Scenarios and Test Cases

based on Functional requirements, and Technical & Interface

specifications.

. Steered bug scrub meetings and status review meetings and providing

quality assurance feedback throughout the project life cycle and

status reports to project business owner

. Created test estimates from design documentation and creates quality

assurance project schedules.

.

WIPRO Technologies,

Job Title: Sr SAP BW/BI/ Onsite Lead

Industry: Retail

Period: May 2010 to Feb 2012

Client: Apple Inc, San Jose, CA

Environment: SAP Net weaver 2004s stack, BI7.0,BI 7.3, ECC6.0, E.P 7.0,

BOBJ 3.1, BO 4.0, Informatica Power Center 8.0, Oracle 11g. BODS 4.0, Web

Intelligence, Xcelsius 2008, QaaWS, LiveOffice .

Project: GBI Services & Retail Enhancement Projects

Project Overview: The overall objective of the project is to support the

Current BW/BI Projects in specific Apple Care: design, build, Deploy,

enhance the Data Sources according to user requirements, and provide

support to Production environment .Support Global Apple Retail Expansion

Projects

. Gather requirements from business users and convert them into

Technical and Functional specifications for enhancements or

implementations projects and document development phases into IT

solution design documents, including functional design specification

and technical design specification documents

. Designed, Enhanced and implemented Generic and Custom Data Sources to

fulfill business requirements.

. Created, Scheduled, monitored Info Packages and created process chains

to load data from ECC, EDW and flat files using Programs,

informatica generated workflows and wait events to automate the loads

. Enhanced the performance of BW loads by creation of BW aggregates,

Cube Compressions, Data rollups, Rebuilding statistics, index

maintenance, enabling parallel activation of the DSOs, Activation of

number range buffering, increasing the package sizing.

. Enhance Query Performance by Changing the BLOB settings of the Queries

in RSRT, Creation of aggregates for the affected cubes, adding the

cubes in BIA.

. Involved in BW System Preparation for Landscape refresh,Support Pack

and Hot Pack upgrades to ensure all BW back end Objects are

functioning normally and report are executing fine

. Involved in Technical and Functional Upgrade of BI 7.0 to BI 7.3 :

migration of BW Objects from 3.5 to 7.3 using Projects, creation of

Hybrid Providers to provide mass data with latest delta at Query

runtime

. Scheduled and handled Regular calls with offshore to review projects,

scope, and timelines and to make sure project coordination and

deliverables as per the plan and within budget.

. Worked extensively on Finance Data Source: 0FI_GL_4 (General Ledger

Line Item) Data Source to Extract Transform and Load Financial Data

for Balance Sheet and Income Statement and Publish the same data to

Hyperion Finance Module for validations and consolidations.

. Worked extensively on Logistic Cockpit Data Sources: Quality

Management: 2LIS_05_Q0ACTY, 2LIS_05_Q0CAUSE, 2LIS_05_Q0ITEM,

2LIS_05_Q0NOTIF, 2LIS_05_Q0TASK, For loading Service notification

data for Apple Care Service Excellence and Quality Management

. Worked on Logistic Cockpit Data Sources SD: Sales: 2LIS_11_VAITM,

2LIS_11_VASCL. Shipping: 2LIS_12_VCHDR, 2LIS_12_VCITM Billing

:2LIS_13_VCHDR, 2LIS_12_VCITM for Loading Inventory data .

. Worked on Retail Enhancement projects which involved gathering

requirements for new Enhancements i.e addition of a new Company Code,

Plant, Sales Orgs from the Business Requirement Document, Analyzing

the impact on the existing extractors and BW Objects, down stream

systems such as Business Objects and Hyperion, Enhancing,

implementing, conducting regression, Integration, Unit and User

acceptance testing and deploying the changes from Development, Test, Quality and production system

. Was involved in design and development of Business Objects Data

Services as a solution tool to extract data for SAP ECC systems to

Oracle System and migration of existing BW Extractors to use BODS

. Defined Data stores in Data Services, Defined Data Services System

Configurations,

. Created Data Services Batch Jobs, Trouble Shoot Batch Jobs using

Traces, adding annotations, using interactive debugger.

. Used built in Functions to transform the data, created Jobs scripts

to automate data loads and variables with Parameters

. Used various Platforms Transforms i.e Merge, Case, Map Operation,

Data Integrator Platforms, Pivotal and data transfer to load data

. Captured Slow Changing Dimensions by using Source based CDC( Source

Data Capture ), time stamps in source - based CDC, Target based CDC

and setting up various Error handling mechanisms using try catch block

and alternative workflows .

. Worked extensively in Business Objects XI 3.1 Application Suite and BI

4.0 while migrating BW Queries to BO reporting layer

. Migrated BW Reports to Business Objects XI 3.1 by replicating BW

Logics from the Update rules to BO staging area

. Migrated SAP Netweaver BW Reports to Business Objects 4.0 by using

OLAP Universes and through SAP BI Consumer Services (BICS )

. Worked extensively on Single Source Data Foundation and Multi Source

Data foundation for creating Apple Business Layers and Universes

. Designed universes for the migrated BW Queries using Universe

development cycle : Preparation, Analysis, Planning, Implementation, Testing, Deployment, Updating and Universe Maintenance

. Created Relational Universe, OLAP Universe, Multi source Universe

using Information Design tool in BO 4.0

. Enhanced and built Universe structure by defining the Schema, Classes

and Objects

. Enhanced Universe and Webi Performance by resolving various resolving

loops issues, SQL Traps and applying restrictions on objects.

. Helped design various security and authorizations for the Users,

Groups and Universe to restrict all wide access to the data.

. Worked with IT and business users to resolve support and technical

questions and

Professional Experience:

WIPRO Technologies,

Job Title: SAP BW/BW/BO SPM Architect

Industry: Manufacturing

Period: March '10 to May '10

Client: Colgate Palmolive, Morristown NJ

Environment: SAP Net weaver 2004s stack, BI7.0, ECC6.0 Business Objects XI

3.1 SP2,SAP IK XI 3.1SP2, Web Intelligence, Xcelsius 2008, QaaWS,

LiveOffice .BO SPM 1.0

Project: BO SPM, Spend Performance Management 1.0 Implementation

Project Overview: The overall objective of this project is to assist

Colgate Palmolive in the design, build, and deployment of an SPM solution

that will improve its business processes and support future growth.

. Interact with stakeholders, Coordinate workshops/meetings to ensure

all requirements are captured and hold design sessions with key

customer personnel for Spend Performance Management Project

. Involved in preparation of Universe Scope, adoption of business

standards and analysis candidate objects for SPM

. Involved in Planning and review of BO Architecture, System landscape

to be used, connectivity, Security, Support and Change Management

Plan

. Involved in Implementation, Schema design with Classes and Objects,

review of joins and performance

. Involved in IT Integration testing, Unit testing and deployment of

the Universe to Quality Assurance and Production

. Developed security model for SPM and administration tasks for change

management i.e addition of new users, creation of groups,folders,

info view, User and objects security

. Handled scheduling and publishing of the reports to users through CMS

. Enhanced Webi intelligence performance from OLAP Cubes using Query

Stripping and XCelsius caching

. Designed & Developed Data Sources, Info Sources to load SPM Data,

Developed Transfer rules, Update rules and Start and End routines

using ABAP to incorporate Business logic and perform data

manipulation.

. Installed BOBJ Enterprise XI 3.1 SP2 and Fix pack 2.5 and SAP

Integration Kit SP2 and Fix pack 2.5 on BOBJ Dev, QA and PRD systems.

. Built reports that have multiple display objects on a single page

tables and charts) in Web Intelligence for user friendly analysis of

data.

. In WEBI used Calculations, Variables, Breaks, Sorting, Alerts,

Prompts, slice and dice, and Drill down/up functionality for creating

Master-Detail reports, Cross-tab reports related to the company's

Accounting and Financial Planning.

. Generated Canned Reports using BO Universe as the data provider.

. Configured QAAWS and Live office to Dash boards using Xcelsius

. Developed Executive dashboards using Xcelsius such as Net Sales,

Revenue and Maketing

. Developed OLAP Universes on top the bex queries and applied MDX code

on some objects.

. Worked on bex query restrictions, created Characteristic KF'S,

Restricted KF'S and structures and also Selection variables.

. Worked on SAP Authentication in BOBJ CMC to add Multiple SAP Systems

. Worked on Single Sign on to set up users in SAP and BOBJ systems, and

also on security privileges such as Roles and Folders.

. Worked on BOBJ CMC in Servers management, Events Handling and

Security of Users, Groups and Folder Access management

. Worked on Email Automation and Scheduling of reports using BOBJ Events

based on SAP BI Process chains

. Worked on Performance tuning on BOBJ and SAP BI 7.0.

. Responsible for migrating SAP BO Universes, Reports to Quality and

Production Environments.

. Prepared training documents and provided end user training.

. Worked with IT and business users to resolve support and technical

questions and

Professional Experience:

WIPRO Technologies,

Job Title: SAP BW/BI Consultant

Industry: Pharmaceuticals

Period: March '09 to February '10

Client: Johnson's & Johnson's, Jacksonville FL

Project: ERP Up gradation from R/3 4.7 - ECC 6.0

. Involved in the upgrade preparation of BW Extractors from R.3 4.7 to

ECC 6.0. Checked the validity and consistency of all Extractors prior

to and post upgrade.

. Involved in identifying test scenarios, i.e. extractors, process

chains, user exits and programs

. Involved in creation of test scripts, testing of the extractors and

reports using Mercury test tool

. Involved execution of test scripts testing for CRM, MM, SD & FI,

COPA modules

. Involved in maintaining documentations for all the test activities for

GxP and SOx compliance.

. Maintained URD, FDS and TDS documentations

. Involved in transporting the objects within the Landscape using

Transport Management System.

. Involved in Managing of Info Cubes, which involves Info Cube Content,

Performance issues like Indexes, Statistics, Compression of Info Cube

and Rolling up the data to the Aggregates.

. Handled tickets with different priority tickets and Maintained Work

History for all test tickets until it is closed down and submitting

the Ticket Status (Open/Close) report.

Professional Experience:

WIPRO Technologies,

Job Title: Sr SAP BW/BI Developer

Industry: Retail

Period: April '08 to Nov'08

Client: Thomson's Reuters, Eagan MN

Project: BI 7.0 Implementation for Thomson Reuters Tax Services

. Interact with stakeholders, Coordinate workshops/meetings to ensure

all requirements are captured and hold design sessions with key

customer personnel and vendors

. Held Regular calls with offshore to review projects, scope, and

timelines and to make sure project coordination and deliverables as

per the plan and within budget.

. Prepared Functional Documents and Technical Documents detailing the

mappings of R/3 Fields with BI Info Objects per the requirements and

leveraging business contents.

. Installed Standard Business Content Extractors, Info Cubes and DSO

objects, Info objects to fulfill user requirements for FI, HR and SD

Extractors

. Developed ETL logic using Transfer rules, Update rules and Start and

End routines using ABAP to incorporate Business logic and perform data

manipulation.

. Created, Scheduled and monitored Info Packages and process chains to

automate load from SAP ECC 6.0 Extractors to BW

. Involved in Debugging Update Routines, Start routines, Transfer

Routines.

. Performed Performance Tuning I. aggregate rollups, index maintenance,

Compression, Number range buffering and parallel master data and ODS

data activation. optimized the load performance by adjusting the

packet size, data selection and number of Info packages

. Created Documentation of test plans,Involved in Integration, Unit

Testing and stress test of the Data Targets In Development, Quality

and Staging landscapes

. Handled the transport move process through the landscapes Development,

Quality, Staging and Production, Well versed with the transport error

handling mechanisms.

. Used Restricted (RKF) and Calculated Key Figures (CKF), Formula

Variables, Replacement path Variables, User entry Variables in the

Query Designer to develop reports.

. Used RRI jump queries using transaction RSBBS for drilling down to

other queries and R/3 transactions.

. Worked Extensively with BW reporting via BEX Analyzer, BEX Web

reporting using Web Application Designer. Created web templates using

Web Application Designer and published the reports in the portal

folder.

. Worked hand in had with Portal Administrator in creating I views,

Pages, Work set and assigning them to the Roles.

. Portal User Administration i.e. creating users in the portal, Locking

and Unlocking users and assigning users to respective roles in the

portal

. Educated users to use standard reports and provided detailed

documentation on using different features of reports.

. Involved in publishing the Process Hand Book for the Support

activities.

Professional Experience:

WIPRO Technologies,

Job Title: SAP BW/BI Consultant

Industry: Manufacturing

Period: July '07 to March '08

Client: SCJohnsons, Racine WI

Project : ERP Up gradation from R/3 4.7 - ECC 6.0

. Involved in Pre Upgrade activities i.e in ERP, Delta Queues clean up

for Logistic Cockpit, locking of the users, Data Sources and

programs identification for testing and co-ordination with Global SAP

Team

. Identified test scenarios for the extractors, user exits, Functional

modules, BADIS and other RFC programs impacted

. Executed Integration test scripts to ensure ECC Data Sources function

well

. Executed Unit Test Scripts to ensure ETL is functioning as before and

the respective interfaces

. Coordinated BW Objects migration and Cut over activities during go

live and initial testing coupled with post production support

. Involved in migration of 3x Data sources ISFS to BI7 RSDS, Migrated

Transfer structure, transfer rules and Update rules, Routines to

transformation and DTP

. Involved in transporting the objects within the system Landscape using

Transport Management System from Dev, Quality then to Production

environment.

. Involved in Managing and maintenance of Info Cubes, DSOs, and

Performance issues like Indexes, Statistics, Compression of Info Cube

and Rolling up the data to the Aggregates.

. Remodeling DSOs using the remodeling tool to add info objects as per

the user requirement

. Designed and developed process chains (RSPC) for master data loads and

Transaction data Loads Scheduled for periodic loads using timed events

. Worked extensively on standard and custom defined LIS, LO extractors.

Used LO structures for extracting sales order, delivery information.

Logistics Cockpit configuration and customization.

Professional Experience:

Pentacle Solutions,

Job Title: Sr SAP BI/BW Consultant

Industry: Manufacturing, Oil & Gas

Period: April' 05 to March 07

Client: Houston, TX

Project: BW /BI Various Projects

. Assigned Data sources to the Info Source, Defining Transfer

Structures, and Metadata maintenance for the Info Source and source

system.

. Activated and installed required objects from Business content.

. Identified and modeled data sources from the OLTP side to be converted

into Info Sources.

. Activated and installed technical content Info Cubes, queries to

prepare BW statistics report.

. Developed Queries using Filters, Restricted Key figures, Calculated

Key figures and Variables for Characteristics, Key figures,

Hierarchies, etc.

. Involved in creating functional specification documents and technical

design documents.

. Day-to-day responsibilities include analysis of data requirements and

translation of these requirements into dimensional data models.

. Extensively worked on Info Cubes, Data Stores (DSOs) and

Multiproviders for SD, MM and FI.

. Activated business content extractors, Info Objects, Info Cubes, Multi

Providers and DSOs (Data Stores) according to the Business

requirements.

. Generated reports with replacement path, adjusted exceptions for

detailed reporting and designed Exceptions, Variables, Structures,

Restricted Key figures, calculated key figures on BEx Queries.

. Created RRI jump queries using the transaction RSBBS for drilling down

to other queries and R/3 transactions.

. Handled performance tuning of queries using aggregates, table

partitioning, indexing of Info Cubes.

Professional Experience:

Job Title: SAP End User

Industry: Manufacturing

Period: Sep' 02 to Feb 04

Client: Hewlett Packard, Houston, TX

. Performed online trouble shooting: identify, qualify problems

documented them down and offered technical advice

. Filled service request from customers

. Create, enter and

Contact this candidate