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