Post Job Free
Sign in

Sap Project

Location:
8873
Posted:
April 23, 2010

Contact this candidate

Resume:

SAP BW/BI/BO TECHNOFUNCTIONAL CONSULTANT

SAP Netweaver/SAP BW/SAP BI/SEM BPS/ABAP/BusinessObjects

IBRAHIM BAKIR

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

Cell: 732-***-****

Location: Somerset, NJ

SAP Certified (Certificate ID: 000*******) Senior BI Consultant with a

verifiable track record of delivering complex SAP Business Warehouse

(BW/BI) & SAP Business Planning and Simulation (BPS) projects and exceeding

expectations. The hands-on BW/BI and BPS Solution Architect accomplished

primarily the architecture, requirement gathering, design, analysis and

development efforts of SAP's BW/BI and BPS. Played role as report developer

by using Business Explorer and Web Application Designer. Depending on the

size, complexity or specific needs of project roles included the following:

requirements gathering, analysis, design, design reviews, configuration,

development, testing, implementation, documentation and consulting support

to others.

. SAP Business Warehouse (BW/BI)

. SAP Finance (FI)

. SAP Advance Business Application Programming (ABAP)

. SAP Business Planning & Simulation (BPS)

. SAP Logistics (LO)

. BusinessObjects (BO)

Professional Experience

SAP Experience: 5 years of BW/BI experience, 1 year of BPS experience, 5

years of R/3 experience, 6 BW/BI Implementations, 1 year of BO experience

Clients: Johnson & Johnson, Rexam, WR Grace, ODFL, Ogilvy & Mather

Industry: Pharmaceuticals, Manufacturing, Chemicals, Logistics, Advertising

Industry Know-How: Sarbanes & Oxley Requirements

Business Process Know-How: Order-to-Cash, Invoice-to-Cash, Financial

Accounting, Controlling, Profitability Analysis, Accounts Receivable,

Accounts Payable, Logistics

Training: SAP BW/BI, SEM BPS, SAP B1, Crystal Reports, Web Intelligence,

Xcelsius

Education: M.A. in Economics (Rutgers University, NJ), B.A in Economics

(Bilkent University, Turkey)

SAP Experience

Business Warehouse (BW/BI): Data Warehouse Design, Administrator Workbench

Configuration, Front-End Configuration, Web Application Designer

SEM-BPS: SEM BPS Design and Configuration (Back-End and Front-End)

SAP Releases: SAP R/3 4.0B, 4.6B, 4.6C, 4.7, 5.0, 6.0; BW 3.0B, BW 3.5, BI

7.0; SEM 4.0

Upgrades: BW 3.0 to BI 7.0

Programming: ABAP

Project Experience Summary

Jun'09 - Dec'09 Johnson&Johnson (Bridgewater, NJ) [Pharmaceuticals]

SAP BI Lead Consultant

Business Information Warehouse Implementation

FIAP, Invoice Workflow

BI 7.0, ECC 6.0

Jan'09 - May'09 Johnson&Johnson (Bridgewater, NJ) [Pharmaceuticals]

SAP BI Lead Consultant

Business Information Warehouse Implementation

FIAP, FIAR, FIGL, Purchasing, Sales Orders

BI 7.0, ECC 6.0

May'08 - Nov'08 Johnson&Johnson (Bridgewater, NJ) [Pharmaceuticals]

SAP BI Lead Consultant

Business Information Warehouse Implementation

FIAP, FITX, Purchasing, Invoice Verification, Invoice Workflow

BI 7.0, ECC 6.0

Nov'07 - Apr'08 Johnson&Johnson (Bridgewater, NJ) [Pharmaceuticals]

SAP BI/BPS Consultant

BI Migration and Upgrade

BI Migration from DB2 to Oracle, Unicode Conversion, Upgrade from BW 3.0 to

BI 7.0

BW3.0, BI 7.0, ECC 6.0, EP 6.0, Crystal Reports

Sep'07 - Sep'07 Rexam (Chicago, IL) [Manufacturing]

SAP BW Trainer

Business Information Warehouse Training (BW 3.5) and Delta Training to BI

7.0

Data Warehousing, Modeling, Data Acquisition, Reporting, Delta BI 7.0

BW3.5, BI 7.0, SAP R/3 4.0B

May'07 - Aug'07 WR Grace (Columbia, MD) [Chemicals]

SAP BW Lead Consultant

Business Information Warehouse Production Support

Production Support in the areas of SD, FI, PP, MM, PUR, PCA, CO-PA

BW3.5, SAP ECC 5.0, EP 6.0

Nov'06 - Apr'07 WR Grace (Columbia, MD) [Chemicals]

SAP BW Consultant

Business Information Warehouse Implementation

Sales and Distribution, Sales Orders, Deliveries, Invoices

BW3.5, SAP ECC 5.0, EP 6.0

Jul'06 - Oct'06 ODFL (Thomasville, NC) [Logistics]

SAP BW Lead Consultant

BW Performance Analysis/Troubleshooting

Performance Analysis, Process Chains, Troubleshooting, Communication with

SAP

BW3.5, IBM AS/400

Oct'05 - Jun'06 Ogilvy & Mather (New York, NY) [Advertising]

SAP BW Consultant

Business Information Warehouse Implementation

FI-GL, FI-AP, FI-AR, CO-PA, MM-PUR, SD

BW 3.1, R/3 4.7

Projects Details (References may be provided upon request)

Johnson & Johnson (Bridgewater, NJ) Jun'09 -

Dec'09

Johnson & Johnson is a global American pharmaceutical, medical devices and

consumer packaged goods manufacturer founded in 1886. The corporation

includes some 250 subsidiary companies with operations in over 57

countries. Its products are sold in over 175 countries.

Project Abstract

The objective of this project was to create predefined reports and graphs

to measure AP financial performance.

Tasks and Responsibilities

. Requirement analysis for the following business areas: FIAP, Invoice

Workflow

. Gap analysis of the requirements and mapping with solution mediums

(SAP R3, ABAP, BI)

. Create functional specification (FSD) and technical design (TDD)

documents

. Enhance and develop of extract structures for FIAP and Invoice

Workflow

. Enhance standard business content objects (infocubes, update rules,

infosources, etc)

. Design BI security strategy and approach

. Architecture Plan - which extractors, mappings, ODSs, cubes will be

impacted

. Testing Strategy - for system testing, UAT test scripts

. Production Support Transition Plan

. Reconciliation Process design

Johnson & Johnson (Bridgewater, NJ) Jan'09 -

May'09

Project Abstract

As part of the Intercompany Process (WINGS), Business Warehouse project was

to provide Johnson & Johnson with analytical reporting solutions in the

areas of Purchasing, Sales Orders, Accounts Payable, Accounts Receivable

and General Ledger.

Tasks and Responsibilities

. Requirement analysis for whole business areas: Purchasing, Sales

Orders, FIAR, FIAP, FIGL

. Gap analysis of the requirements and mapping with solution mediums

(SAP R3, ABAP, BI)

. Prepare Blueprint for BI implementation

. Create functional specification (FSD) and technical design (TDD)

documents

. Design data architecture

. Enhance and develop of extract structures for Purchasing and Sales

Orders

. Enhance standard business content objects and build infocubes, update

rules, etc.

. Create transports to move the developments to QA and PRD environments

. Design BI security strategy and approach

Johnson & Johnson (Bridgewater, NJ) May'08 -

Nov'08

Project Abstract

As part of the US Purchasing & Accounts Payable Implementation Project

(Ap2ollo), Business Warehouse project was to provide Johnson & Johnson with

analytical reporting solutions in the areas of Purchasing and Accounts

Payable.

Tasks and Responsibilities

. Requirement analysis

. Gap analysis of the requirements and mapping with solution mediums

(SAP R3, ABAP, BI)

. Prepare Blueprint for BI implementation

. Create functional specification (FSD) and technical design (TDD)

documents

. Design data architecture

. Enhance and develop of extract structures for Purchasing

. Enhance standard business content objects and build infocubes, update

rules, etc.

. Develop 25 queries for related areas

. Develop web templates for portal integration of the reports

. Create Unit and Integration test scripts

. Design and create process chains for efficient data loading

. Performance Tuning of related developments

. Develop reconciliation report to reconcile data between BI and source

system

Johnson & Johnson (Bridgewater, NJ) Nov'07 -

Apr'08

Project Abstract

The focus of this project was to test\verify the migration from Mainframe

DB2 to HP UNIX with Oracle and SAP BW 3.0\BPS 3.5 upgrade to SAP BI

NetWeaver 2004s BI 7.0. The current functionality was tested in the new

environment using established and approved test scripts.

Tasks and Responsibilities

. Check system after technical Basis upgrade

. Investigate and find solutions for the issues

. Create SAP messages and implement suggested OSS notes

. Create technical design documents (TDD) for the solutions

. Test and implement solutions

. Implement the new BI statistics concept in 7.0 environment

. Test the new security concept in 7.0 environment

. Implement the new alternative unit of measure concept in 7.0

environment

. Check routines for Unicode compliance and fix the errors found

. Repair the corrupted delta management after the upgrade

. Test the new 7.x GUI compatibility with the 3.x GUI

. Create LoadRunner test scripts for the stress of the upgraded system

. Test BPS functionality after upgrade

. Crystal Reports on top of SAP BI queries

Rexam (Chicago, IL) Sep'07 -

Sep'07

Rexam is one of the world's leading consumer packaging groups and the

world's leading beverage can maker. They serve a number of markets

including the beverage, personal care, healthcare and food markets.

Project Abstract

This was a hands-on, BI training class offered to Rexam's functional and

technical employees from different application areas (FI, MM, SD, etc.).

Each topic was first explained in SAP BW 3.5 and then enhancements and

improvements in the new version (BI 7.0) were taught.

Tasks and Responsibilities

. Describe the architecture of SAP NetWeaver and BI and explain their

advantages

. Define various BI objects, InfoObjects, DataSources, InfoCubes,

DataStore objects.

. Create and use data transformations and Data Transfer Processes

. Schedule and monitor data loading processes within BI

. List techniques to enhance query performance and data acquisition

performance

. Describe how implement BI Statistics Technical Content

. Describe how the BI Accelerator can be used to improve query

performance

. 7.0 Delta Training

WR Grace (Columbia, MD) May'07 -

Aug'07

W. R. Grace and Co. is one of the world's leading specialty chemicals and

materials companies.

Products: Catalysts and chemical additives, Hydroprocessing catalysts,

Specialty catalysts, Silica-based and silica-alumina-based engineered

materials, Construction materials and systems, Packaging technologies

Project Abstract

Production Support in the areas of SD, FI, PP, MM, PUR, PCA, CO-PA.

Tasks and Responsibilities

. Query Performance improvement

. Analyze statistics to determine the reasons for poor performance

. Create aggregates for better query performance

. Analyze the cube designs for better performance

. Meet with the power users to discuss the production issues users are

facing

. Determine the reason for the issues and let users know options along

with risks and/or costs

. Fix the issues, test and transport to the production environment

. Search for OSS notes when necessary and implement OSS notes to fix the

issue

. Communicate with SAP if necessary and troubleshoot according to the

instructions given

WR Grace (Columbia, MD) Nov'06 -

Apr'07

Project Abstract

Business Warehouse project was to provide WR Grace with analytical

reporting solutions in the areas of Sales and Distribution.

Tasks and Responsibilities

. Develop Initial Sizing Estimates

. Create Technical Design Document

. Gather Business Requirements by conducting workshops

. Design the Infoproviders (infocubes, ODSs, rules)

. Design Reconciliation Process

. Configure BW according to design document

. Create BW Reports on the infoproviders created

. Perform Unit Testing, Integration Testing and UAT, Performance Testing

. Create Production Support Manual

ODFL (Thomasville, NC) Jul'06 -

Oct'06

Old Dominion Freight Line, Inc. is a leading national less-than-truckload

(LTL) carrier providing direct service to 47 states, including 37 states

with 100% full-state coverage.

Project Abstract

ODFL had AS/400 as their ERP system and they were experiencing problems

with the data loads from AS/400 system. They needed help on communication

with SAP to solve this problem. They also wanted to automate some of their

data loads with the use of process chains. Finally they had some issues

with their system performance. A system analysis had to be made to

determine the problems.

Tasks and Responsibilities

. Communicated with SAP for unsolved problems

. Analyzed OSS notes, created SAP messages

. Developed process chains for data loads from AS/400

. Developed event raise ABAP programs to be used in process chains

. Analyzed BW system performance

. Analyzed query response times and provided solutions to improve

performance

. Suggested solutions for better system performance (daily tasks,

infocube/query optimization)

. Activated and customized the SAP technical content to collect

reporting statistics

. Knowledge transfer to the administrators

Ogilvy & Mather (New York, NY) Oct'05 -

Jun'06

Ogilvy & Mather is an advertising agency headquartered in New York City.

Project Abstract

Ogilvy, one of the largest marketing communications networks in the world,

is conducting a systems implementation and reengineering program to cover

whole business processes across all NA companies.

Tasks and Responsibilities

. Requirement analysis

. Accounts Receivables & Accounts Payables, with Aging by Profit Center

. Financial Statement (B/S and P&L Reporting), P&L reports

. WIP Reporting - with FIFO Aging

. Spend Analysis

. Gap analysis of the requirements and mapping with solution mediums

(SAP R3, ABAP, BW)

. Preparing Blueprint for BW implementation

. Enhancements of standard business content objects and build of

infocubes, update rules, etc

. Development BeX reports for related areas

. Testing of all related developments

. Design and creation of process chains for efficient data loading



Contact this candidate