CHARLES BOIQUAYE SAP BI/BO
CONSULTANT
acch5u@r.postjobfree.com
Professional Summary
8+ years of IT experience with 7+ years of effective BI/BW/BO consulting committed to maintaining
cutting edge technical skills and up-to-date industry knowledge. Detail-oriented professional motivated to
drive projects from start to finish, independently and with a team.
Experience with Systems Analysis and Design methodologies, scheduling conversions and cutover.
Extensive experience in designing monitoring, and evaluating global SAP implementation infrastructure.
Involved in the implementation of multiple full life cycle BW projects
Technical expertise in developing and enhancing DSOs, Infocubes, MultiProviders, Extractors,
Datasources and complex transformations.
Comprehensively worked in the designing of performance optimization strategy for BW Data
warehouses.
Developed reports using reporting tools such as BEx Query Designer, Bex Analyzer for analysis and Web
reporting using BEx Web Publisher and BEx Web Application designer.
Hands on experience using Web Intelligence, Xcelsius and Crystal Report, Desktop tools for Dashboards
and BOBJ management console in report development.
Utilized Crystal Reports to create detailed financial reports using sub-reports and parameter based
reports.
Trained business users on how to use the Business Objects Web Intelligence tool to create reports
Experience integrating BW reports in SAP Portal
Maintenance, Installation and Enhancement of Business Content objects.
Involved in postproduction support, which required InfoCube management using Compression, Rollup,
Reconstruction, Indexes and Partitioning and performance tuning using Aggregates/Pre-
calculation/Multiproviders.
Data modeling implementing FIGL, Accounts Receivables and Accounts Payables, Cost Center
Accounting.
1
CHARLES BOIQUAYE SAP BI/BO
CONSULTANT
acch5u@r.postjobfree.com
Education:
BA Economics University of Ghana 08/2001-
05/2005 Certificate in SAP Business Warehouse Winpress Computer Inst., Ghana 01/1999-
07/2000
Certificate in Data warehouse Management Vision One Computer Inst., Ghana 03/1998- 08/1998
Skill Set:
Software MS Office, MS Project
SAP Environment SAP NetWeaver 7.3, 7.0 BW 3.5; SAP ECC 5.0, 6.0
Reporting Tools SAP BusinessObjects XI 3.1 (Web Intelligence, Desktop Intelligence
Universe Builder, CMC, InfoView, Crystal Reports, Xcelsius 2008)
Work Experience
Karl Storz Endovision (Charlton, Ma)
SAP BI/BO Consultant October 2011 –
June 2013
Analyzed the business requirements in daily meetings with the business users.
Created the high level documentation to present to the business users.
Customized and configured various areas of IMG activities including : G/L master records, AR/AP, Cash,
Profitability Analysis and integration with SD and MM.
Ensured entire Master Data Upload and Roll up for the relevant Company Codes.
Developed processes and standards for BW production support.
Analyzed and installed the required business content Objects.
2
CHARLES BOIQUAYE SAP BI/BO
CONSULTANT
acch5u@r.postjobfree.com
Created transformations, DTPs and error DTPs
Loaded Data on a Daily and Monthly basis, monitoring delta data loads, troubleshooting where necessary.
Created reports by using RRI (Report to Report Interface), exception, conditions, exception aggregation,
restricted and calculated key figures depending on 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.
Developed front-end queries and reports using Web reporting tool and Web Application designer.
Participated as a team member in discussion with business analysts and end users in achieving the most
suitable reports for various business evaluations.
Bose Corporation (Framingham, Ma)
SAP BI/BW Developer March 2011 –
Aug 2011
Participated as the architect in the analysis, design, development, delivery and support of SAP BI projects
for the data warehouse
Designed, implemented and supported complex extraction, transformation and loading operational setups
Interacted with users/functional teams to gather and interpret their documented reporting requirements for
various projects
Developed supporting business process logical data models using best practices for data capture, data
dictionary design, maintenance and overall data integrity
Provided detailed functional knowledge throughout the entire development process
Provided status reports, isolated and resolved problems and initiated system enhancements as required
Developed supporting business process procedures that allow for an automated data load.
Led the support of and consulting services for report developers and users, analysis and interpretation of
warehouse data including report design and creation using standard BI reporting tools
Performed lead role in various levels and aspects of BI development life cycle.
Bose Corporation (Framingham, Ma)
SAP BI/BO Developer December 2008 – February
2011
3
CHARLES BOIQUAYE SAP BI/BO
CONSULTANT
acch5u@r.postjobfree.com
Worked extensively on configuration using Administrator Workbench (RSA1). Customized Data Sources,
InfoObjects, InfoSources and InfoCubes. Created FI-GL InfoCube by generating Transfer Structure,
Extract Structure for FI-GL 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.
Developed AR aging report, created Invoice Layout and processed invoices.
Analyzed InfoCubes (via RSRV) created and maintained aggregates (RSDDV) to improve the
performance.
Worked extensively on BEx Analyzer (RRMX). Created queries using BW-Reporting Variables,
Navigational attributes and Filters and variables.
Customized and activated standard delivered BW business contents in the areas of FI-AP/AR and LO
extractors (LBWE).
Developed Core Universes based on the BEX queries.
Worked with SAP Portal team to publish BOBJ reports
Worked with Business users in filling gap analysis.
Created custom DSOs, InfoCubes, MultiProviders and Infosets based on SAP CRM Leads, Opportunities
and Activities.
Developed end routines and start routines to meet the specific user requirements
Created Info Packages, 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 Info providers for
reporting needs.
UNILEVER GHANA LTD (Tema, Ghana)
SAP BI/BW Developer September 2008 –
December 2008
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.
4
CHARLES BOIQUAYE SAP BI/BO
CONSULTANT
acch5u@r.postjobfree.com
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.
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 and 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.
Extensively worked on Design & Development of Custom Cubes, DSO/ODS Objects, Multiproviders
and Infosets; Enhancements on Accounts Receivables (AR) cube.
Delta Management.
Modeled Data targets according to the reporting requirements.
Developed various FI/CO and SD 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.
Spintex Ghana Ltd (Accra, Ghana)
SAP BW Developer January 2008 -
August 2008
Gathered user requirements for SAP BI Implementation
Involved in installation and configuration of SAP BI/BW
Involved in testing (Unit, Integration, Volume and Stress tests) during BI implementations.
Modeled, built and customized InfoObjects, InfoCubes, InfoSets and MultiProviders according to
functional specification requirements
Added functionality and enhancement to various Datasources
5
CHARLES BOIQUAYE SAP BI/BO
CONSULTANT
acch5u@r.postjobfree.com
Involved in Business Content Installation for Standard InfoObjects, InfoSources, InfoCubes related to
Sales & Distribution, Material Management and Finance.
Generated queries and embedded them into Workbooks using BEx Analyzer
Configured BEx Queries for Calculated and Restricted Key Figures, Free Characteristics Filters,
Variables and Exceptions
Performance Tuning of queries and data uploads: OLAP Caching, Aggregation and Compression
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.
ASHANTI GOLD COMPANY LTD (Kumasi, Ghana)
SAP Junior BW Developer March 2005 –
November 2007
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.
Activated Master Data objects. Performed and documented unit testing for all objects in Sandbox and
development system.
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 .
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 over all Sales Analysis.
Developed simple Routines in Update rules and Transfer Rules for the key figures of InfoCube Purchase
Data. InfoCube was used for Analysis of Material groups, Vendors, and Materials.
Monitored data extraction and created queries based on client’s requirement.
Configured BEx Queries for Free Characteristics, Calculated and Restricted Key Figures, Filters,
Variables and Exceptions
6
CHARLES BOIQUAYE SAP BI/BO
CONSULTANT
acch5u@r.postjobfree.com
7