Sap Data

OLA OLADUTE

Address: ***** ***** **** **., *******, Texas, 77036

Contacts: Mobile Phone: 832 –758-8141 Email: abnbs7@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 5 years of experience in SAP BW/BI as a Consultant/Analyst with 3 full life cycle

implementations and Post Production experience.

Involved as a key member of project teams through all phases of Implementation - Project

Preparation, Blueprint, Realization, Go-live, and Post implementation support of SAP BW in

MM and SD modules.

Experience in SAP Netweaver BI 7.0

Writing functional specification documents and converting same to Technical documents.

Concepts and architecture of the SAP Business Information Warehouse

Hands-on experience of working with the SAP BW tools, focusing on Extraction,

Transformation and Loading of Data. (ETL)

Knowledge of the SAP BW Metadata repository

Concepts and OLAP functions of SAP BW Reporting

Usage of predefined SAP reports (Business Content)

Working knowledge of SAP ASAP methodology in Project Life Cycle implementations.

Datasource activation and enhancements from LO cockpit.

Installation and enhancement of Business Content datasources.

Experience in automating loads using process chains and the use of BW Monitor to supervise

data loading

Experience in working with standard and custom Multiproviders - InfoCubes, InfoObjects,

ODS/DSO.

Dimensional data modeling using SAP extended star schema,

Data extraction from SAP R/3, non-SAP R/3 Systems.

BW Reporting – Developing queries and reports using Query designer, BEx Analyzer, BEx

Browser, Web Application designer.

Developed workbooks using Filters, Conditions, Exceptions, Calculated Key Figures, and

Restricted Key Figures.

Business Objects/Crystal Reports Knowledge

Experience in cube Performance Tuning using Aggregates, Compression, Partitionng, and

Query read modes .

Capable of working independently with minimum supervision as well as in a team.

Highly motivated, eager to learn and take on greater responsibility.

TECHNICAL SKILLS

SAP BW 3.5/BI 7.0, SAP Netweaver Portal

SAP R/3 4.7, ECC 6.0; Crystal Reports, Business Objects

SAP ABAP Skills.

MS Office 2007 (Word, Excel, Access, PowerPoint)

QuickBooks

EMPLOYMENT HISTORY

PROJECT.

CLIENT: HEWLETT – PACKARD (HP), HOUSTON, TX.

ROLE: SAP BI/BW CONSULTANT

DURATION: 08/01/2009 – 10/30/2009

ENVIRONMENT: SAP BI 7.0

Participated in meetings with end-users to determine the requirements and scope of various

financial reports

Worked on various datasources in the SAP R/3 Financials such as 0FI_GL_4 (General

Ledger: Line Item datasource) and 0FI_GL_1, (General Ledger: Transaction figures)

0FI_AR_5(Account Receivable: Payment History), 0FI_AP_4 ( Accounts Payable: Line

Items)

Performed Data extraction from Special Purpose Ledger in R/3 and transferred the necessary

fields to BW to satisfy the requirements for various financial reports.

Design Query and executed same in Bex Analyzer to prepared various AP/AR Operational

Reports such as Monthly Payment Discount Statistics, Payment with Duplicate Amounts and

Invoice Dates, Vendor Open and Cleared Items Report and Customer Open & Cleared Items

Report using a Multiprovider

Used the BEx Analyzer to Prepared reports based on GL datasources such as General ledger

Line Item details report, Trial Balance Statements.

Used BEx analyzer to develop and facilitate data analysis using Filters, Navigational

attributes, Calculated and Restricted Key Figures

Worked on Query Designer to create Queries in calculating DPO (Days Payment

Outstanding & DSO (Days Sales Outstanding) using Restricted Key Figures, Calculated Key

Figures, Customer Exit Variables.

Translated the BW Reports to Cyrillic texts for Russian users

PROJECT.

CLIENT: SHELL OIL (U.S.), HOUSTON, TX.

ROLE: DOWNSTREAM APPLICATION SUPPORT ANALYST- (SAP BW).

DURATION: 4/ 2008 – 7/31/2009

ENVIRONMENT: SAP BI 7.0

Attend to call tickets issued from Super users and Users in the Service Center.

Liaise with end-users to gather business requirements needed for creating a change in the

reporting Infocube.

Worked with Offshore Application specialists in resolving first call resolution of tickets as

soon as possible.

Involved in on-going end user training for the forthcoming migration from SAP (3.5) to

GSAP (Business Intelligent 7.0) for the American Region

Exported BW 3.5 infosource to 7.0

Extracted data from 0HR_PA_0S_1and loaded same to the Transactions assignment

infocube 0PAOS_C01. A report showing the Actual working time versus Planned working

time

Activated and installed InfoCube (0PA_C01)- Headcount and Personnel Actions. Used

datasource 0HR_PA_PA_1 (Headcount – Transaction data) and 0HR_PA_1( Personnel

Actions- transaction data) to data into the cube). Generated a report displaying various

employee’s data for a given month

Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT)

Implemented various performance tuning techniques such as Aggregates, Compression,

Query read mode and Partitioning to solving Query issues

Created DSO for drilldown reporting for Asia Pacific Regional user(APR)on Global

operations for Hydrocarbon Management and Lubes Supply Chain reports

Scheduling of load using Process Chain

Maintained the structure of data flow from source system to BW ensuring correctness of data

extraction

Datasource activation and enhancements for a new reporting requirement for Oil Sand.

Troubleshooting and subsequent fixing of issues in the BW server such as:

Master data found missing in BW sever and needed to be reloaded

Data load runs into an error

Data in the Infocube need to be validated

Enhancement needed to be carried out on datasource

New BW objects such as Infocube and ODS need to be created.

Data modeling need to be restructured based on new reporting requirement

Trained users on the features of BW front- end reporting such as following:

Design of queries to meet complex reporting demand using Multiprovider

Execution of Queries in the BEx Analyzer in form of financial reports

PROJECT

CLIENT: GROCERS SUPPLY INC, HOUSTON, TX

DURATION: 10/ 2006 – 03/ 2008

ROLE: SAP BW Analyst

ENVIRONMENT: SAP BW 3.5

BUSINESS AREA (SD MODULE)

RESPONSIBILITIES

Held meeting with end user to gathered business requirements.

Assigned responsibilities to individual team members during project implementation.

Performed extraction of data from multiple source systems and load the data into one target

server

Designed data models for ODS objects – Sales, Billing and Deliveries to perform detailed

level reporting

Designed and maintained the structure of data flow from source system to BW ensuring

correctness of data extraction.

Installations of standard objects from Business Contents.

Designed & developed standard DataSource, and other BW Objects to fulfill user

requirements.

Used Process Chain to developed data loading strategies for master data and transactional

data.

Worked extensively on standard and custom defined LO Extractions.

Extracted and loaded data from SAP R/3 into Sales Overview InfoCube ( 0SD_C03) using

Infosource 2LIS_11_VAHDR- Sales Document Header data, Infosouce 2LIS_12_VCHDR-

Delivery header data and 2LIS_13_VDHDR –Billing Document Item data.

Created Infospokes to extract data from infoObjects, Infocubes, ODS, and transfer the data

to external datamarts using Open Hub Service.

Worked on creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups as

Performance improvement mechanisms.

Developed drill down reports through queries and workbooks for the required Sales

Overview infocubes and Deliveries infocubes.

Extensively worked on Query Designer and Web application designer to create Queries to

forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key

Figures, Variables, Filters, Condition and Exceptions.

Developed different queries based on calendar day week, month, quarter and year in order to

obtain any combination of reports from the infocubes.

PROJECT

CLIENT: PILLARS & STRONG INC, HOUSTON, TX

DURATION: 09/2004-08/ 2006

ROLE: SAP BW ANALYST.

ENVIRONMENT: SAP BW 3.5

BUSINESS AREA (MM MODULE)

RESPONSIBILITIES

Participated in meetings with users to determine requirements and scope.

Maintained data balancing by extracting data from multiple source systems and loading them

into different servers.

Analyzing and fixing any failed data loads.

Extracted data using flat files for raw materials in order to track inventory.

Performed Data extraction from R/3 (LO Extraction) and Flat files.

Designed & developed custom Infocube based on clients’ specification.

Extracted and loaded data from SAP R/3 into Purchasing Groups infocube (0PUR_CO4)

using datasource (2LIS_02_HDR), and into Purchasing Data infocube (0PUR_C01) using

Infosource (2LIS_02_ITM – Purchasing Data Document Item Level) and Infosource

2LIS_02_ITM – Purchasing Data Document Schedule Line Level)

Activation and installation of Business Content datasource 2LIS_03_BF (Material

movement from Inventory management), 2LIS_03_UM – Material Revaluations and

2LIS_03_BX were used to load data into Material movements infocube 0IC_C03.

Worked on job schedules by creating Process Chains to run periodic loads.

Created Multi providers to enhance the reporting base.

Created custom reports using Business Explorer(BEx) to give detailed level of information

from queries based on ODS Objects.

Used BEx analyzer to develop and facilitate data analysis using Filters, Navigational

attributes, Calculated and Restricted Key Figures.

Created Aggregates on InfoCubes to improve Query performance.

Generated data into Excel spreadsheets for reports using BEx Analyzer.

Created reports pertaining to stock movement form company warehouse to depots, dealers

and retailers

Involved in post – go live support as regards performance tuning; resolving loading issues.

ENTERPRISE (SAP) TRAINING SCHOOL, HOUSTON, TX 01/2004-05/2004

(Underwent a Technical Training in SAP BW 3.0)

Quantumn Financials Group 5/2003-08/2004

Financial Asistant II with/SAP BW

Underwent On-the-job training in SAP BW as an end-user

Created various financial reports and workbooks using the BeX analyzer function of BW

Assisted in gathering data to measure and monitor company’s performance

Generated data into Excel spreadsheets for reports using BW BEx Analyzer

Maintain SAP BW reporting standards and file maintenance

Aggregation of financial data from BW and non-BW systems into a single analytical report.

Working with SAP BW Technical team to standardized financial BW reports to be available

for company management on a routine basis

Ensure integrity and accuracy of financial databases and management reporting

Responsible for monthly financial reports including financial reconciliation and analysis as

well as financial statements for annual audit

Developed several drill-down reports on business areas within the FI (GL) module using BEx

analyzer.

Develop and perform various financial analysis including analysis and interpretation of

historical results and forecasts, Sales variance analysis and reconciliation.

Perform analysis of variances between budgeted and actual results, and communicate

findings.

Ensures the accuracy and timeliness of all financial record and reports for assigned areas of

responsibility

Interfaces and assist with outside and internal auditors as required.

Designed a query and executed it in the SAP (BW) BEx Analyzer using Condition criteria to

identify slow moving items according to Company’s specification.

Used the SAP (BW) BEx Analyzer to prepare various financial statements such as Balance

Sheet, Income Statement, Cash Flow statements.

Gabod Enterprises, LLC. 01/2003-5/2003

Accounting Assistant

Posting of journal entries

Accounts Payable/Receivable.

Invoiced; debited/credited accounts.

Bank Reconciliation

Payroll processing and time-sheets

Assisting with month end financial statement review

Maintenance of Petty cash treasury account

Monthly inventory stock taking for the division

Other duties as requested.

Relocated to the US 9/2002-12/2002

.

Golden Wallet Industries, Lagos, Nigeria 07/1995-9/2002

Accounts Manager.

Accounts Payable/Receivable.

Achieved 100% of quota by signing accounts and executing on contracts, training and

deliverables related to program rollout.

Invoiced; debited/credited accounts.

Retrieved and Consolidated Invoices and General Ledger.

Budgetary Planning and Controlling.

Capital Expenditure Reporting and Tracking.

Bank Reconciliation.

Prepared Profit and Loss Account on Quarterly basis.

Fund Management

o Accounts Finalization

o Reconciliation – Bank Accounts

o Salary

Workings Salary structure for employees

Pay slip preparation and dispersal.

Taxation viz. Income tax calculation for employees and guiding them in

Investments.

o Provident Fund related Record Maintenance & Filing.

o Tax Deducted at Source –Deductions of relevant TDS for Contracts, Rental &

Salaries

o Monthly, Quarterly & Annual Returns.

Cost Accountant

Profitability Analysis.

Material Labor and Overhead Variance Analysis.

Raw Material/Finished Goods costing.

Maintained the job order costing and standard cost system monitor by making improvements

to the work order system.

Provided financial analysis of cost reduction initiatives and other operational programs as

required.

Provided financial analysis of capital authorization requests. Developed and supported the

analysis of factory cycle time.

Provided ad hoc reporting and analysis for manufacturing as required. Initiate and lead

process improvement activities.

Assisted in the development of improved cost reports and assisted with the installation of and

conversion to a new financial system, which is still being used by the company.

T-cas (America) Inc., Lagos, Nigeria 1990 -1995

Admin/Personnel Manager

Recruiting and Hiring of Employees.

Liaised between Management and Employees. (Union environment).

Conduct Performance Appraisal/Evaluation Report of Employees.

Ensures Compliance with Policies and Procedures.

Represents Company at Community Programs.

Assures Legal Compliance with Government Legislation.

Supervised trained and evaluated subordinate management and supervisory staff; coordinated

and directed budget preparation for the company.

Monsoons Ventures Limited, Ibadan, Nigeria 1987 -1990

Warehouse Manager

Shipping/Receiving.

Inventory Control.

Production Supervisor

Manages Customer Orders

Maintain Balance of Inventory

Ensures timely Completion of Job Order

Product Quality Control

EDUCATION

Angelo State University, San Angelo, TX B.B.A. (Bus. Admin) 1986

Contact this candidate