Sales Sap

SAP BI/BO CONSULTANT

EMMANUEL ODARKWEI LAMPTEY

Phone: 832-***-****

*******@*****.***

Professional Summary

7+ years of effective SAP BI/BO experience focusing on successful Enterprise

•

implementations at a global level with a proven ability to quickly learn new

technologies and has business acumen.

• Hands-on SAP BW technical expertise in developing and e nhancing

D SOs, I nfocubes, M ultiP roviders, Ext ractors, Datasource and

complex t ransformations .

Excellent experience in Extraction Lo-Cockpit - Inventory Management, SD, MM,

•

PM, etc

• Solid knowledge in S ystem Administration, Data Ext raction, Data

L oading (Full /Delta Up-Load), ET L, Scheduling, Monitoring and

D ata Modeling .

• Maintenance, Installation and Enhancement of Business Content objects.

• Experience in P rocess chains and Info packages to lay connectivity into

various Data Targets.

• Performance T uning (Query and Data Loading): Aggregates,

Compression, Roll-Up, I ndices, Statistics etc., and also the tools

available in BI/BW

• M ultiple full-life cycle projects ( ASAP methodology)

I mplementations.

Excellent experience in Extraction (Lo-Cockpit, FI/CO, HCM, SD, CRM, MM,

•

GTS) of Master data and transactional data and Performance tuning

Experience with legacy system integration with SAP BI

•

Experience with Systems Analysis and Design methodologies

•

Post Production Support - Technical, Functional and System Administration.

•

BW 3.5 – BI 7 Upgrade experience and Testing, System Refresh, Production

•

Releases, and Transportation of Objects from Development box – QA – Production.

Involved in the implementation of multiple full life cycle BW projects

•

Extensively worked in the designing of performance optimization strategy for BW

•

Data warehouses.

Extensive knowledge of BEx Analyzer, and BEx Query Designer for developing

•

reports, analysis and Web reporting using BEx Web Publisher and BEx Web

Application designer.

Strong analytical, conceptual and problem solving skills to evaluate complex BW

•

technical and functional problems and apply knowledge to identify appropriate

solutions.

knowledge in Business Objects client tools; Designer, Universe Builder, Crystal

•

Reports and Xcelsius Enterprise 2008.

Expert in Administration, Business Objects, Designer, BOBJ (Desktop/WebI

•

Intelligence), CMC and InfoView. Hands on experience in Installation,

configuration & deployment of Business objects. Setting up Testing, QA and

Production Servers Environment

Experience with Non-SAP source of data extraction using Universal Data Connect

•

(UD Connect)

Experience with SAP BI Accelerator (BIA) setup and index creating..

•

Knowledge in best business practices and technology to optimally drive client

•

business processes.

Excellent communication skills and ability to manage both team and multiple

•

assignments simultaneously.

Ability to train and mentor clients in Data Warehousing and Reporting Analytics.

•

Effective in communicating complex technical information to both top-level

•

management and end-users. Flexible and resourceful, applying strong

organizational, time-management and planning skills to deliver projects on

time/budget, in pressure and aggressive timelines.

• E NV I RO N M E N TS : R/3 4.6c, 4.7 ECC 5.0, 6.0 SR1 Oracle 9.2.0.7, 10g

BW 3.0, 3.1, 3.5 NW04S BI (BI 7.0) Outlook soft 5.0, SAP BPC 5.1.

•

• SAP B I/BW TRA I N I NG H IG H L IG H TS:

•

• Trained client on Enterprise data warehousing concept, data modeling

concepts and performance tuning techniques. This covered BW310, BW330

and BW360; trained technical team on migration process from SAP BW

3.5 to Netweaver 7.0

•

•

Client: BRIDGESTONE, NASHVILE, TN

Capacity: SAP BI/BO Consultant(January 2011 - PRESENT)

Involved in a fresh BW implementation. Activated all Datasources in RSA5 and

•

checked extractors in RSA6 and then RSA3. I also documented short dumps and

faulty extractors.

Created many custom InfoObjects documented to satisfy requirements for

•

connectivity with Legacy systems.

Created Infopackages in Development system and tested new InfoObjects data

•

loads. Checked PSA for errors involving invalid characters. Took screen shots and

documented all unit testing required.

Enhanced the different Transactional DataSources with new fields and added

•

functionality to populate them.

Modeling, building and customizing InfoCubes, ODS (DSO), Info Objects, Infosets

•

and MultiProviders as per the functional specifications.

Involved in Installing Business Content for Standard InfoObjects, InfoSources,

•

InfoCubes related to Sales & Distribution, Material Management and Finance.

Used the Business Content Sales Overview InfoCube 0SD_CO3, for overall Sales

•

Analysis.

Developed simple Routines in Update rules and Transfer Rules for the key figures

•

of InfoCube Purchase Data 0PUR_CO1. InfoCube was used for Analyses of

Material groups, Vendors, and Materials.

Excellent experience in Extraction (Lo-Cockpit, FI/CO, HCM, SD, CRM, MM,

•

GTS) of Master data and transactional data and Performance tuning

Monitored data extraction and created queries based on client’s requirement.

•

Performance Tuning of queries and data uploads: OLAP Caching, Aggregation

•

and Compression

Implemented BW statistics to monitor BW system performance.

•

Liaised with SAP Basis Team regarding BW Transport requests.

•

Worked extensively in creating reports like Balance Sheet, P&L, Cash, Gross

•

Margin, Monthly Sales, Open Orders, Back Orders, Overdue, Daily Sales

Reports, Payment History, etc. using structures, formulas and Cell definitions.

Worked with BEx Analyzer to generate Queries and embedding them into

•

Workbooks.

Configured BEx Queries for Free Characteristics, Calculated and Restricted Key

•

Figures, Filters, Variables and Exceptions

Created Queries by defining rows, columns and free characteristics providing drill

•

down functionality in reporting

Knowledge in Business Objects client tools; WebI, DeskI, Designer, Universe

•

Builder, Crystal Reports and Xcelsius Enterprise 2008.

Worked with SAP BI team in requirement gathering from business users

•

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

•

Marketing

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

•

objects.

Developed WEBI Reports based on Bex Queries on top of Info cubes for FICO,

•

MM and PM Modules

Environment: SAP BW 3.5, 7.0,SAP R/3, Logistic cockpit, BEX Analyzer,

•

Query designer, Business Objects 4.0, Designer, BOBJ, Xcelsius, InfoView,

CMC, Crystal Reports

Client: Tremco, Beachwood, OH

Capacity: SAP BI/BW Consultant(August 2009 – October20 10)

Worked extensively on configuration using Administrator Workbench (RSA1).

•

Customized Data Sources, InfoObjects, InfoSources and InfoCubes. Created FI-SL

InfoCube by generating Transfer Structure, Extract Structure for FI-SL Totals table,

and defined and assigned data source for a ledger.

Created Accounts Payable (AP) and Accounts Receivable (AR) Cubes based on

•

the reporting requirements.

Involved in uploading the Master data and transactional data from SAP R/3 and also

•

from flat files into BW via Data Staging to PSA, InfoCubes and ODS.

Excellent experience in Extraction (Lo-Cockpit, FI/CO, HCM, SD, CRM, MM,

•

GTS) of Master data and transactional data and Performance tuning

Developed AR aging report, created Invoice Layout and processed invoices.

•

Analyzed InfoCubes (via RSRV), created and maintained aggregates (RSDDV) to

•

improve the performance. Worked on CO-PA Extraction to SAP-BW. .

Heavily involved in customizing and activating standard delivered BW business

•

contents in the areas of FI-AP/AR and LO extractors (LBWE).

Worked with Business users in filling gap analysis.

•

Created InfoPackages, DTP’s and Process Chains and worked on scheduling and

•

Monitoring of data loads.

Involved in testing and training of end users.

•

Developed new extractors for new client requirements and built new targets and

•

Infoproviders for reporting needs.

Built reports that have multiple display objects on a single page (tables and charts)

•

in Web Intelligence for user friendly analysis of data.

Involved in Migration of Canned Reports/Universe/Personal Documents/Inbox.

•

Implemented Row level/Column Level/Report Level/ Security. Involved in

Identifying Reports Complexity. Worked on creating and maintaining Business

Objects & web Intelligence reports.

Coordinated with business to understand the requirements and modifying universe,

•

report specifications. Involved in creating users/user groups in CMC

(Administration module).Good experience in trouble shootings issues.

Created web intelligence reports, graphs and charts facilitating drill down,

•

Created, modified/maintained Universe. Created Hierarchies to facilitate drill

down. Worked on Adding/creating complex objects to the universe to enhance the

report functionality.

• Performed data validation by creating ad hoc reports.

Created interactive Executive Dashboards, Charts and Graphs using XCelsius.

•

• I nstalled Xcelsius Ente rp r ise, configured QAAWS and L ive Office

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.

Environment: SAP BI/BW 3.5, 7.0, FI, MM, SD, SAP CRM

•

Business Objects XI 3.1, SAP CRM, Web Intelligence, Xcelsius, InfoView,

CMC, Crystal Reports

Client: E-Logic Inc, Glenwood Springs, CO {electronics}

Capacity: SAP BI/BW Architect (January 2008 – June 2009)

Involved in complete life cycle implementation of SAP BW using ASAP

•

methodology as a team member, converting Functional Specifications into

Technical Specifications and then to realization.

Analyzed the requirements and identified the suitable business content for SD,

•

FI/CO and had the standard infocubes, ODS’s, Multicubes and various other

relevant objects installed and activated.

Used full features of BI 7.0 (DTP, Transformations, and DSO).

•

Developed BW Queries, Testing and transporting through landscape.

•

Involved in testing extractors, data loads and reports before transporting into

•

production.

Excellent experience in Extraction (Lo-Cockpit, FI/CO, HCM, SD, CRM, MM,

•

GTS) of Master data and transactional data and Performance tuning

Enhanced extract structures by adding new fields and populating them with the

•

user/function exits in CMOD.

Created the process chains to automate the data loads for transaction, master,

•

text, hierarchies,

Performed standard, application specific and generic extractions such as LO

•

Cockpit, LIS,and FI/GL extractions.

Extensively worked with PSA in Monitoring the Data Transfer from Source

•

Systems into BW.

Extensive work on Design & Development of Custom Cubes, DSO/ODS Objects,

•

Multiproviders and Infosets; Enhancements on Accounts Receivables (AR) cube

0FIAR_CO2.

Developed various FI/CO andSD reports such as DSO Analysis Current Period,

•

Days overdue Analysis, Customer Sales Trend, Actual Contribution margin in

Sales, Incoming Orders Analysis and Product Profitability Analysis in SD.

Worked with SAP Open Hub service for sending the data from BW to External

•

Systems.

Provided complete end user training and knowledge transfer to permanent staff.

•

Developed BEx Queries on top of InfoCubes for FICO, MM and PM Modules.

•

Environment: SAP BI 3.5, 7.0, FI, MM, PM and SD modules.

Client: SIEW GLOBAL NET, ACCRA, GHANA

Capacity: SAP BI/BW Architect(July 2006– October 2007)

Worked with SAP BI team in requirement gathering from business users .

•

Worked on BEx Query restrictions, created Characteristic KF’S, Restricted

•

KF’S and structures and also Selection variables.

Worked on Scheduling of reports using SAP BI Process chains

•

Prepared training documents and provided end user training.

•

Extensively did Performance tuning to ensure Data load and Query performance.

•

On-call support for escalated production problems.

•

Developed BW Queries, Testing and transporting through landscape.

•

Involved in testing extractors, data loads and reports before transporting into

•

production.

Created the process chains to automate the data loads for transaction, master,

•

text, hierarchies,

Performed standard, application specific and generic extractions such as LO

•

Cockpit, LIS,and FI/GL extractions.

Extensively worked with PSA in Monitoring the Data Transfer from Source

•

Systems into BW.

Extensive work on Design & Development of Custom Cubes, DSO/ODS Objects,

•

Multiproviders and Infosets; Enhancements on Accounts Receivables (AR) cube

0FIAR_CO2.

Performance Optimization by Tailoring Transfer Structures, Communication

•

Structures, and Update Rules using routines and Start Routines.

Environment: SAP BI 3.0, 3.5, R/3 4.6C, SAP BW 3.0B, 3.5,

Education : Bachelor’s degree in Information Systems

Contact this candidate