SAP Lead BW/BI HANA Consultant
Nigeria Petroleum Exchange – NipeX
Total des années d'expérience :10 years, 7 Mois
END - END Implementation of SAP BW/BI for SAP SRM PPS 7.0 & SAP ERP Record Management.
Perform Extraction Transformation and Loading (ETL) Process; Move Developed Object across the SAP
Landscape.
Generated the following Business process reports for Operational running of the contracting and
procurement in the subsidiary Using SAP SRM PPS 7.0.
Cumulative dormant tenders, Dormant tender, Approver’s activities report, Product by supplier
analysis, Opportunity analysis, Suppliers' activity analysis Reports, Top five buyers by transaction volume, Shopping cart analysis, Bid response report, Contract
status, Pending approval etc.
End-to-End Implementation of SAP BW for HCM Extraction, Modelling and Reporting.
Building of HCM Cubes and Scheduling Transport Request from DEV. -> QTY -> Prod. To be
moved
HR Cube, 0PA_C01 and Data source 0HR_PA_1, Headcount and Personnel Actions, Data source
0HR_PY_1 for HCM Payroll Analysis, HR BEX Reporting on both Personnel Actions and Payroll
Cubes.
End-to-End Implementation of SAP BW for SD Extraction, Modelling and Reporting. For;
o Domestic Crude Sale Report, Domestic Lifting Reports, Total Crude Report, Customer Credit
Status Report, Revenue Report, Revenue Report Summary of Crude
End-to-End Implementation of SAP BW for FICO Extraction, Modelling and Reporting. For;
Bank Payments Report, Trail Balance, Customer Balances in Local Currency( Accounts
Receivables), Performance Breakdown by Period CHQ (S_ALR_87013640), Financial Statement,
Cash Position/Bank Balance, Vendors Age Analysis Report, Account Receivable Customer Sales,
Customer Balances in Local Currency, OPEX Budget Performance CHQ, Performance
Breakdown by Period CHQ
Designed Universes, WEBI Reports and Dashboards, Developed Queries to Integrate with Xcelsius to
get the BO -Dashboards.
Developing Dashboards on Enterprise data using Live Office and QAAWS connections, Migration and
testing of Reports, Universes and dashboard.
Analyse the reporting requirements with the business users and come up with the Technical
specifications, created the WEBI Reports using various functionalities in the tool, trend Reports with
Charts and drill down.
Involved in resolving issues and trouble shooting, reviewing the changes handled by team members.
Comprehensive Explanation of Sybase NLS functionalities for Data archiving in BW and HANA, Explain
and Demo of DAP In the Warehouse, Explain and Demo NLS on Info providers
Setup NLS in the Administration Panel of BW, End-to-End Explanation of Sybase, BW-NLS setup and
Integration with SAP HANA, Explanation of NLS with BW Process Chain.
Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and
Calculation View.
Created HANA modelling scenarios and activities such as adding a system, creating schemas and
content models, attributes and measures, hierarchies.
Loading data into table definitions, suspending data loads, resuming data loads. Creating information
objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based).
Developed complex SQL scripts in Calculation views
SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0
Involved in SAP HANA Security including User Management, Roles, and Privileges
Reporting Accessing Analytical and Calculation views from EXCEL.
Involved in Information Design Tool - Creation of Data Foundation, Universe for HANA reporting.
Designed and executed migration plan to migrate data from existing SAP ECC and CRM servers to the
SAP HANA database. Configured SAP HANA Studio and BOBI reporting engine to prepare a POC for
subsequent use in customer projects and engagements.
Installed LO data-source and activate in ECC system and BI content Installation for Sales data in BW
system.
Created Info-cube, DSO and update rules and wrote ABAP code in start routine.
Created different reports in BEx Query Designer, Qlikview categorically for Sales application areas:
Primary, Secondary and Tertiary Sales while setting exception aggregation exceptional and Conditional
Reporting.
Fill set-up table for loading history.
Created Process Chains to automate the data load and data target administration and monitored the
processes.
Implementated End to End Tertiary Sales Application area using generic delta extractors, developed
numerious reports over Same.
Created Process Chain status mail alert to Different Users within the Enterprise.
Extensively worked over Routines(Start and Field Routine) and Data Source enhancements.
Created Numerious RKYF, KYF and KPIs using Customer Exit variables.
Monitored Delta Load DTP and Infopackages for Severals Data Sources.
• The project responsibilities involved Integration of SAP BI System with SAP R/3 thereby extracting data
using SAPI from SAP R/3 System.
• Performed LO-data extraction for the Sales Data sources 2LIS_11_VAHDR, 2LIS_11_VAITM,
2LIS_12_VCHDR, 2LIS_12_VCITM, 2LIS_13_VDITM, 2LIS_13_VDHDR.
• Created a Test case Scenario over Application Areas FIAR FIAP FIGL, getting Dataflow done for the same
and creating Queries for the Info Providers In concern.
Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas,
Multiproviders, Info Sources, Data Sources, and Info Packages.
Maintained Info Cube, Update Rules and Creation of Info Package and scheduling the data into the Data
Targets.
Uploaded Master Data and Transaction Data from R/3.
Designed and created Process Chains for master and transaction data loading .
Worked extensively on LO Cockpit. Loaded the data from R/3 to BW and used Initialization with Delta
Update and Full Update methods.
Involved in creation of infoset and multiprovider.
Created Process chains for different data flows. Manage data targets by having the correct data
analyzed the errors in the data loads while monitoring.
Designed Info cubes and set up extraction from both R/3 modules and from flat files.
Identifying Data sources, Installation of Data sources and editing as per requirement.
P.G.D. Information Technology NATIONAL OPEN UNIVERSITY OF NIGERIA (NOUN)
SAP Business Warehousing / Object - Professional Certification
NIIT - Calabar Centre, Cross River State
B.SC. CHEMISTRY 2008