Sap Data

Bernard Boadu

SAP BI/BO Consultant

Professional Summary

. Implementation consultant with 7 years of IT experience: Multiple full

life cycle BW/BOBJ implementations (ASAP methodology and SDLC

methodology) Implementations.

. Extensive skill set in the areas of BI/BW Solution and Reporting

across multiple functional areas like FI/CO, SD, HR and MM covering

diverse work streams

. Experienced in dealing with multiple projects and cross-functional

teams, managing multiple tasks/assignments with staggered due dates

and deadlines through effective time management skills.

. Extensively worked in Data Extraction from Multiple SAP and Non SAP

(Legacy) Systems using Business Content, LO, LIS, CO-PA, HR, FI-SL,

Flat File, and Generic Extraction Methods for legacy data.

. Solid knowledge System Administration, SAP BW and Business objects

Security models, Data Loading (Full /Delta Up-Load), Scheduling, and

Monitoring

. Maintenance, installation and Enhancement of Business Content objects

and worked extensively with Process chain for Automation of process

and Better performance.

. Experienced in modifications/enhancements, Performance Tuning (Query

and Data Loading): Aggregates, Compression, Roll-Up, Indices, BW

Statistics

. Extensive experience in design and development of reports/queries with

BEx Analyzer, Report Designer, Query Designer, Web Application

Designer

. Experienced in developing and enhancing Datasource, DSOs, InfoCubes,

MultiProviders, and complex transformations, custom DTPs.

. Experienced in Extraction Lo-Cockpit - Inventory Management, SD, MM,

PM

. Solid knowledge of SAP BW Integration to Business Objects Enterprise

3x/4.0 .

. Experience with Xcelsius 2008 and Crystal reports 2008.

. Experienced in Universe designing, developing and generating

Dashboards, Reports, Business views, complex logical counts, and

averages.

. Ability to evaluate complex BW technical and functional problems and

provide solutions.

. Generating numerous reports using Restricted Key Figures, Calculated

Key Figures, Filters, Variables, Exceptions, and Conditions.

. Delta management and Performance Tuning with Aggregates, Rollups,

Compressions, Partitions and Indexing of infocubes.

. Excellent combination of technical skills (Configuration, Customizing,

Testing - Smoke Testing/User Acceptance Testing, Regression Testing)

and Functional skills (Client facing, Gap Analysis, and Documentation)

with expert level implementation skill.

. Experience in Organizational Change Management, Post Implementation

Support, End User Training and Data Conversion.

. Strong oral and written communication skills including presentation

(PowerPoint; Excel; Visio; MS project) and ability to work

independently and as a team player.

. Experienced in ABAP for data processing. Good understanding of object

oriented ABAP.

. Remained abreast of and researches industry technical trends and new

development to maintain current skills and remain current with

industry standards.

Technical Skills

Data Warehouse : SAP BI 7.0, SAP BW 3.5, SAP BO 3x,4.0

ERP Packages : ECC 6.0, SAP Net weaver BW, SAP R/3 4.7/4.0

ERP Integration : SAP R/3 LO, FI, CO, SD, MM, HR Modules

BI Reporting : BEX Analyzer, BEX Query Designer, Web

Application Designer

BO Tools : Crystal reports, BI Dashboards (Xcelsius), Web

Intelligence.

Professional Experience

Flash Global Logistics, NJ

Apr 2012 - Present

Business Object Administrator/Developer

Environment: SAP Business Objects XI 3x/ 4.0, Business Warehouse 7.0.

Responsibilities:

Assessment of SAP BW environment giving recommendations on performance

issues in preparation for SAP Business Objects Enterprise.

. Worked on Data extraction and Data modelling of SAP CRM opportunities and

Lead management:

0CRM_OPPT_H,0CRM_OPPT_I,0CRM_SALES_ACT_1,0CRM_LEAD_H,0CRM_LEADS_I,0SVY_ANS

WER_TEXT,0SVY_QSTNNR_TEXT

. Developed Master queries from SAP CRM infoproviders (Multiproviers,

Infosets and Infocubes) using Bex query designer, applied various

functions like filters and conditions.

. Developed Core Universes based on the BEX queries and implemented MDX

code

. Developed Summary and detailed reports and Charts based on SAP CRM Leads,

Opportunities, Gathered requirement from business users

. Installed BOBJ Enterprise XI 3.1 SP2 and SAP Integration Kit SP2 on BOBJ

Dev, QA and PRD systems.

. Configured single sign on using SAP Authentication and for Active

Directory

. Resolved SAP IK issues by applying various SAP Notes

. BOBJ Administration in CMC in Servers management, Events Handling and

Security of Users, Groups and Folder Access management

. Web Intelligence report development: Built user friendly reports that

have multiple display objects on a single page (tables and charts). 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 BICS to connect to BW Queries.

. Implemented Xcelsius Dashboards using data connectivity through QAAWS and

Live office

Worked with business users to define KPIs for Dashboard development such

as Net Sales, Revenue and Marketing (Xcelsius 2008 SP3) with drilldown to

Web Intelligence detailed reports

Universe design and developments on BEx queries (on FI, CO, MM, PM)

utilizing MDX code to effect customizations

. Worked on BEx query restrictions, created CKF'S, RKF'S and structures and

also Selection variables.

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

based on SAP BI Process chains

. Performance tuning on BOBJ and SAP BI 7.0.

. Responsible for using Lifecycle Manager to transport SAP BO Universes,

Reports to Quality and Production Environments

. Prepared training documents and provided end user training.

ARN, INDUSTRIES HOU Oct 2011 -April

2012

SAP BW & BOBJ

Objective:

. Installation, Configuration and Integration of Business Object XI R2 3.0

to SAP BW system.

. Set up BOE XI R2 3.0 Security.

. Set up Single Sign On functionality between SAP BW and Business Objects

using SAP Authentication and between BOE and Windows Active Directory.

. Extensive use of Business Object Enterprise XI reporting tools: Reporter,

Xcelcius, Designer, Infoview, Web Intelligence and Crystal Reports to

report off SAP BW system.

Responsible for creating and maintaining Universe classes, subclasses,

objects, conditions, joins, prompts reports and analytic solutions.

. Created dashboards using Xcelsius

. Analyzed the business requirements in daily meetings with the business

users.

. Developed new requirements for users based on FI/GL utilizing Hierarchies

for Financial Statements for Internal Earning Statements by Market,

Profit Center, Cost Center etc.

. Queries for FI statements

. Ensured entire Master Data Upload and Roll up for the relevant Company

Codes

. Develop processes and standards for BW production support.

. Analyzed and installed the required business content Objects

. Created transformations, DTP's and error DTP's

. Loaded Data on a Daily and Monthly basis, monitoring delta data loads,

troubleshooting where necessary.

. Worked extensively on the transaction data and master data User Exits on

R/3.

. Used the Business Content plan, budget and assigned values InfoCube

0IMFA_1, for over all Investment Management Analysis.

. Created reports by using RRI (Report to Report Interface), exception,

conditions, exception aggregation, restricted and calculated key figures

depending the requirements.

. Worked extensively with BEx Analyzer and created queries using BW-

Reporting Variables, Navigational attributes and Filters. Developed

workbooks, InfoSet Queries and used RRI jump queries to drill down to

other queries

Unilever, ATL January

2010 - Sept 2011

Business Object Developer

Responsibilities:

. Fulfilled Business Analyst requirements by completing the universe

development life cycle to prepare, analyze, plan, implement, test, and

maintain universes.

. Designed multiple repositories for each geographic region due to data

security and performance issues.

. Designed five universes under production department and three

universes under distribution department due to data size and number of

tables.

. Implemented SAP notes to solve drilldown functionality in Web

Intelligence.

. Fine-tuned universes by defining cardinalities, resolving loops,

chasms and fan traps using contexts and aliases.

. Created organizational structure hierarchies for multi-dimensional

analysis purposes.

. Designed ad hoc reports based on discussions with user groups and

created various objects using @prompt, @select, @where, and @aggregate

functions.

. Designed canned sales and production reports with built in prompts to

meet client's needs.

. Involved in writing scripts and creating aggregates to secure

pertinent data and improve performance.

. Created standard financial & budgeting reports and was part of

decision making group.

. Extensively used drill function, slice and dice and various

visualization tools to make informed decision.

. Published reports in power points and PDF for trainings and seminars

organized at the end of project.

Environment: SAP Business Objects XI 3.1/, Xcelsius 2008, Data Integrator &

Services, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW

7.0

Medtronic, MI Jul 2008 -

Dec 2009

BW/ Business Object Developer

Responsibilities:

. Designed custom infoObjects, infoCubes, data store objects and multi-

providers.

. Extensively worked on performance tuning for loading data and

improving query response time, using aggregates, InfoCube compression,

query monitoring, database partitioning, indexing, database

statistics, parallel loading of master & transaction data

. Worked on activation of the Business Content for Profit Center and

Cost Center.

. Data extraction from flat files for Master data and Transactional

data.

. Extensively used BEX analyzer, created queries with variables,

filters, formulas, restricted and calculated keyfigures. Used RRI to

jump between the queries.

. Designed Web Templates using various Web Items in WAD.

. Developed reports out of legacy database such as Microsoft Access.

. Created dynamic and static parameters based on report specifications.

. Developed various charts and graphs like bar chart, Line graphs, pie

charts etc. by using chart expert of Crystal Reports.

. Developed cross tab reports, sub reports by using crystal reports.

. Created On-Demand sub reports and hierarchical grouping.

Environment: SAP BW 3.5, BEx Queries, BEx Analyzer, Query Designer and Web

Application Designer (WAD), SAP Business Object XI 3.1.

Education

Masters in Engineering

Consultant's Profile

Consultant's Profile

Consultant's Profile

Contact this candidate