Phil Adebiyi

SAP BW/BI/HANA Business Analyst / Architect / Senior Developer

+1-832-***-**** Email – acqrjp@r.postjobfree.com

** ***** ** **/** experience with 8 years of SAP BW experience, 4 years of SAP BOBJ/BI experience, 2 years of SAP HANA experience which includes 6 full cycle

Experience techno-functional consultant in various industry business process in the area of SAP OTC, SAP P2P, SAP R2R, SAP MM, SAP PP, SAP FICO, SAP APO, SAP VIM, SAP SD, SAP PS etc

Lead the Development/Enhancement of the BI/HANA architecture by modeling, designing, developing, testing and implementing the appropriate back end (Extractors, Data Sources, DSOs, Cubes, Programs/Function Modules, InfoSets, MultiProviders, OpenHub,Attribute view, Calculated view and BW Process Chains) and front-end (BEx Query Designer, Web App Designer, Business Explorer Suite) structures needed to meet business reporting requirements. This includes the creation and enforcement of SAP BW/BOBJ/HANA development standards in accordance with SAP BW/BOBJ/HANA recommended practices.

End to End HANA Implementations with SAP BW 7.4 and SAP HANA Sidecar and SAP HANA /BW mixed scenario implementation experience.

Dashboard development and deployment using SAP BO information Design tools

Advance knowledge in SAP analytical tools e.g SAP BW APD, SAP Hana Decision tree and SAP BO Lumira.

Strong ability to create and support complex, high volume data architecture. Data Warehouse data modeling tool evaluation and selection experience.

In-depth experience as a SAP MM, SAP TM and SAP SCM functional consultant and ability to configure Enterprise SAP deployment in the area of SAP MM and SAP TM.

In-depth experiences with Enterprise BI Data Presentation Strategy and implementation, ad hoc Reports.

Collected business requirements and defined functional and Technical specs for development of SAP HANA information models (Schemas) for Inventory and SCM reporting

Proficient in Data staging using ODS/DSO before transferring the ODS/DSO contents to the Infocube

Built Multi Providers, Multi Cubes and Info Sets as per the requirement

Improved data load and query performance by using performance tuning techniques like Compression, Aggregates,Partitioning, Rollup, Collapse Indexing of InfoCubes and Repartition

Expertise in front-end Business Warehouse BEx components like Queries, Web reporting, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Workbooks.

Extensive experience with Roles, User Authorization, Profiles and User groups

Experience in ABAP/4 programming techniques including development of Reports, Data Dictionary objects (Tables, Views, Structures, Data Elements and Domains), Job scheduling and Job monitoring.

Extensive hands-on experience in Data Extraction from SAP R/3 using Generic Extraction, LIS Extraction, LO

Extraction, CO-PA Extraction and Data Loading (Full/Delta Upload).

HANA Data provisioning of SCM data from ECC using SLT

Creation of Attribute views, Analytic views to support the SCM reporting solution.

HANA Administration including managing schemas, data model objects and import/export content as needed

Good Understanding and hands on Working Experience with Webi, Crystal and Dashboard Designer, OLAP Analysis.

Hands On knowledge for Business Objects tools. Lumira, Business Explorer, OLAP for Analysis, Office Analysis for BOBJ.

Certifications

Certified SAP Netweaver Business Warehouse 7.0 Consultant (2008)

Certified SAP HANA Associate Solution Consultant (2012)

Certified SAP BW 7.4 on Hana SP8 Consultant (2014)

Certified Supply Chain Management Associate Consultant – Procurement (2015)

BI 4.0/ 4.1 Product Suite:

Good Understanding and hands on Working Experience with Webi, Crystal and Dashboard Designer, OLAP Analysis.

Connectivity options with HANA, BW and ECC.

Connection setup on CMC for OLAP analysis for Adhoc Query using SLT on HANA.

Hands On knowledge for Business Objects tools. Lumira, Business Explorer, OLAP for Analysis, Office Analysis for BOBJ.

Performance tuning of BOE Reports in conjunction with BW backend.

Worked on .UNX universe with IDT tool built OLAP and Relational Connections for Reporting, published connections to secure Business repository, Managed authorizations.

Worked with Webi advance formulas, Hierarchy Member selections in report.

Expertise in building BI information delivery solutions leveraging BO XI 3.1,4.0,

SAP Project Experience

Cameron International, Houston,Tx, USA (March 2015 – Present)

BW/BI/HANA Analyst/Developer

Environment: SAP BI 7.3, SAP BO 4.1, BEx Suite, ECC6

Responsibilities include

Requirement gathering with the business community and all the SCM business analyst

Designing and developing the Technical specification document based on the functional specification document.

Enhance most of the 2LIS 02, 2LI_03, 2LIS_05 annd other related Logistic datasource in ECC based on the Technical specification requirement.

Datasource extraction optimization

Build custom Function module based generic extractor for SAP Vendor Invoice management and replicated these datasource into BW

Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements

Populated various data targets like Infoobjects, ODS and Infocubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA).

Open Hub interface to transfer data from BI to Flat Files to load to an external system.

Worked with Datamarts, Myself source, Generate export Datasource and Replication

Created DTPs, Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data

Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, attribute change run etc.,

Performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems

Debugging the Extractor checker, Start routines and End routines

Performance Tuning - Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.

Developed Queries to access data from various BW Infoproviders like DSO, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer

Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures

Created various interfaces from BW to various non-SAP systems using APD and OPEN HUB.

Reporting Strategy for business objects. Designed Self Service Model for Adhoc Reporting.

Designed Training Material for User Adoption for BI tools.

Debugging the Extractor checker, Start routines and End routines using ABAP

Performance Tuning - Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.

Open Hub interface to transfer data from BI to Flat Files to load to an external system.

Created DTPs, Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data

Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,

Performed huge data loads into DSO and Infocubes from ECC as well as the legacy systems

Developed Queries to access data from various BW Infoproviders like DSO, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer

Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures

Cameron International, Houston,Tx, USA (December 2014 – March 2015)

BW/BI/HANA Analyst/Developer

Environment: SAP BI 7.4, SAP BO 4.1, SAP HANA SP8

Enhancement of HANA live reports and hybrid scerios in SAP BW

In- Memory content activation for BW on HANA. DSO, In Memory cubes and Composite providers, Hybrid providers for Reporting and analysis.

Built Hybrid scenario in BW based on SAP HANA for Cameron international

Built attribute view on MARA, MARC and MAKT tables to support operational report.

Consumed BW Models in HANA for BOBJ Reporting. Global Spend reporting rolled out on Business Explorer.

Built analytical views and consumed in BW via Operation ODS,designed Virtual Data marts

Cameron International, Houston,Tx, USA (August 2013 – December 2014)

BW/BI/HANA Analyst/Developer

Environment: SAP BI 7.3, SAP BO 4.0

Involved in Project full life cycle including, Development, testing and Production go live and Support.

End to end implementation of SAP SCM (SAP MM, SAP VIM, SAP APO and other SCM modules ) using SAP BW/BI 7.3 and BO 4.0

Provided Bex and BO 4.0 Training to the Business Users

Created Infocubes, DSOs, Transformations, DTPS and Custom Datasources to meet Business Requirement

Created different Bex Queries

Created Process Chains and automated the loading process

Created different Dashboards using BO Dashboard 4.0 to meet business requirements.

Created OLAP Analysis Report to meet business requirements.

Created WEBI Reports

Created some Reports using Live Office and using different connections eg. Crystal, WEBI, etc.

Creating and managing dataflow using DTP, transformations and info packages

Data Source Enhancement according to customer requirement.

Experience in writing programs using ABAP, written start routines and characteristic routines.

Designed and developed queries to generate reports in BEx Analyzer.

Worked extensively on query designer.

Involved with performance tuning of queries by compression, repartitioning of info cubes

Created aggregates for InfoCubes to improve query performance.

Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from SAP ECC to SAP BI and used initialization update and delta update

Created custom InfoObjects, DSO, DTPs and InfoCubes-sales data, Contract Data, Billing Plan and Financial Data.

Schedules DTP for loading Transactional Data from PSA to Info Provider using process chains.

Involved in the transportation of BI objects from development to quality and production.

Worked extensively on BEx query Designer and Developed flexible queries using navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information. Created custom queries using variables and structures.

Extensively used Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula, exceptions and conditions. Worked on report-to-report interface (RRI), to enhance the reporting features in BEx analyzer.

Perkin Elmer, Shelton, CT, USA (Sept 2012 – July 2013)

SAP BI/BO Consultant

Environment: SAP BI 7.0, SAP BI 7.3, SAP BO 4.0, BEx Suite, ECC6

End to End implementation in the area of SAP QM, QA and P2P

Migration of all BW objects from SAP 7.0 dataflow to SAP 7.3 dataflow using RSMIGRATE

Conversion of all BO 3.1 universe to BO 4.0 version

Involve in redesign of some infoprovider from SAP BW 7.0 to SAP 7.3 format for better performance.

Activation of all QM and P2P datasource in ECC and installation of the business content in SAP BI e.g 2LI_05_QE1, 2LIS_11_QE2 and other Notification Datasource.

Creation of Generic datasource for the Batch master data and replication of the Batch master datasource in SAP BI

Creation of a View to join more than 5 tables and creating a generic datasource on the view and replicating the structure in BW

Appending all the P2P and QM datasource and populating the structure using user exits

Enhanced data sources of Master data such as 0Customer, 0Material and 0Vendor to meet Client reporting requirements

Involve in an Oracle PeopleSoft conversion project and loading historical file into BW using ABAP attribute lookup to SAP master data files (texts and attributes).

Creating and customizing Data store object and Infocube in the dataflow.

Created the custom InfoObjects, DataStore Objects, InfoCubes, MultiCubes, and Transformations, Data Transfer Process with Full and Delta loads.

Creating reports in SAP business explorer using Variables and free characteristic, restricted key figure and calculated key figure

Creating a BICS connection to the BEX report and exporting the connection to the repository so that BO 4.0 WEBII ( web intelligence) can be able to report on it.

Validated Data for quality comparing the ECC data with the BW Data at different levels.

Created custom cubes like ZSD_C15 (Discount for Customers Cube), ZFIAR_C01 (A/R Invoices Cube),

Customer Credit History & Payment History cubes etc. and loaded the data from ECC in BW to facilitate the reporting requirements

Created MultiProviders on A/R and Billing cubes for reports combining the A/c Receivables & invoice information.

Query performance tuning and dataload tuning

Developed Customized DataSources, and created custom InfoCubes such as ZZ_SD_C01, ZZ_SD_C02, ZZ_SD_C03 to meet the user requirements

Enhanced data sources of Master data such as 0Customer, 0Material and 0Vendor to meet custom reporting requirements

Created Process Chains to regular clean-up of PSA and Compression.

Created Open Hub Interfaces to extract data into files for 3rd party applications for further reporting.

Exit Variables, User entry Variables in the Query Designer to develop reports.

Tyco Flow International, Houston, TX ( May/2010 – August/2012)

SAP Business Analyst (Front End and Backend), Support services

Responsibilities:

Working with the Global Business user community and IT Business Analysts to analyze business needs, document requirements, develop technical designs and to deliver technical solutions

Responsible for delivering the Business Intelligence solutions to the end user with in a structured framework based around the SAP Business Objects BI and SAP Business warehouse BW platform.

Responsible for implementation of global business process for OTC (order to cash), P2P (procure to pay),P2M (procure to Manufacture), Inventory, HR etc in the Business Warehouse and business intelligence environment

Perform analyses, development and evaluation of data mining in a data warehouse environment which includes data design, database architecture, metadata and repository creation; using data mining and data analysis tools

Creating various Sales Analysis and other KPI’s report used by business

User support and responsible for conducting user training.

Responsible for weekly and monthly Validation and recon activity using Microsoft SQL in order to make sure that data in BI report and database match

Review and validate data loaded into the data warehouse for accuracy and at the same time, interacts with user community to produce reporting requirements.

Optimised queries run time by creating queries with Variables [User Exits, Replacement variables and Manual input].

Integration of SAP BW and SAP BO using SAP integration Kit

Business Object Universe design

Involved in various kinds of Unit testing, Integrated Testing, Acceptance testing and Regression testing of the developed objects, reports and checking the data quality and the functionality of the objects as per the requirements.

Implemented various Performance Tuning activities to increase the performance of Queries by Creating Aggregates, Partitioning and Compression of infocubes.

Responsible for Identifying Business Requirements from end-users.

Installed Business Content, Modeling various objects like Info Object, Info Source, Info Cubes and DSO Object.

Tested the new features of BW 7.0 which includes new data flow, re-modeling, Real-time Data Acquisition, enhanced features of Process Chains etc.

Responsible for the creation of Naming Convention document and other Documents for Infocubes, DSO Objects, Info Sources, Info Objects.

Worked extensively on Logistics Cockpit and extracted data. The data included Sales Order, Delivery, Shipment, Billing, Purchase, Goods Movement, and Stock Revaluation.

Extended the Business Content Data sources using Enhancements and populated the appended fields using User Exits. Created custom Info Source/Data Source, ODS, and Info Cubes for Data extraction, transformation and loading from SAP R/3 system to SAP BW

Inspection lot cube, notifications item DSO, Notification Activities Cube, Plant maintenance: Equipment Dismantling, Maintenance orders Cubes. Purchasing, Production Planning and Controlling.

Involved in the design, development and extraction of the data from R/3 system and flat files in to BW system from SD and MM modules using LO Cockpit extraction.

Analyzed the InfoCubes and ODS objects to meet the reporting needs of the client.

Loading of transaction data to the business content InfoCube from InfoSources like 2LIS_11_VASCL, 2LIS_11VAHDR for sales, 2LIS_13_VDHDR, 2LIS_13_VDITM for billing, 2LIS_12_VCHDR for order

Experience in the creation of the setup tables for the LO Cockpit extraction.

Enhanced the business content datasources like 2LIS_03_SCL, 2LIS_03_ITM and 2LIS_03_BF by appending structures and populated the fields using user exits.

Created process chains for periodic upload of the master data as well as the transactional data

Involved in the monitoring data transfers from source systems into BW using PSA

Developed reports on the MM cubes to check the price variance for materials from different vendors.

Created reports on SD cubes for displaying sales figures and incoming orders

Generated reports using BEx with conditions, exceptions, Restricted Key Figures and Calculated Key Figures

Environment: SAP BI 7.0, SAP R/3 4.7, ECC 6.0 SD, MM, FI/CO, SAP BEx Analyzer, BEx Analyser, BOE XI 3.1, Microsoft SQL 2008 server, Oracle ERP, Oracle Hyperion data extract, SAP Solution Manager

LSA Ltd, London, UK

(Feb, 2007 – May, 2010).

Position: SAP BW/BI Consultant

Responsibilities:

Understand design documentation including the high-level data model and understand the complexity and dependencies and plan the timelines for development based on the resource availability.

Interpret functional requirements based on the design document and support the Technical Development Specifications for SAP BW database and reporting objects.

Creation of Generic Datasource using Tables/Views, Functional modules and customizing the Business content Datasource through User Exit in SAP R/3 and ECC6.0.

Developing various kinds of reporting objects including the Queries, query variables, Variable exits, workbooks, RRI. Exceptions, conditions etc.

Customizing of standard BW objects as per the client requirements and extraction and loading of data from ECC.

Used RRI interfaces, filtering, conditions, variables, currency conversions, jump queries and navigational attributes. Exception handling through SAP Mail, batch printing and alert monitor.

Created Aggregates for Info Cubes to improve query performance.

Develop SAP BW Reports in support of Functional and Technical specifications and document the design and development of the Database objects and reports.

Transportation of BW Objects from Development system across the landscape through Transport Connection.

Maintaining Reconciliation to verify the data in SAP R/3 and SAP BW are same or not after the data loads.

Monitoring of data loads and analyzing the reasons for frequent failures of info packages.

Involved in solving tickets regarding Extractions, Performance Issues and also Load Failures.

Created Reports using Calculated Key figures, restricted key figures, Formulae, Conditions and Variables and Developed Drilldown Reports Using RRI

Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.

Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.

Maintain list of all the activities for all the tickets until it is closed down.

Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.

Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.

Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.

Monitoring of info packages and analyzing the reasons for frequent failures of infopackage.

Education

Certified SAP Netweaver Solution consultant

South Bank University

MSc Petroleum Engineering GPA = 3.6/4

Kingston University, London, UK

BEng (Hons) Mechanical Engineering with Geology GPA = 3.4 /4

Reference available upon request

Contact this candidate