Trainer
World Food Programme
Total years of experience :11 years, 9 months
directly with KPMG project Team and the customer to insure that the HANA-based Analytics solution meets the customer’s requirement and need.
•Reviewed, identified and documented issues, risks (or potential risks) with the new BW/HANA solution before go-live
•Ascertain the health and performance of the SAP BWonHANA system (including queries, info-providers, transformations, data sources, etc.)
•Discussed finding and made necessary recommendations to enhance performance and eliminate risks within the solution
•Ascertained conformance of solution/build approach to SAP Best Practice and recommendations
Technical Environment: HANA DB, S /4HANA, BOBJ 4.2, Success Factors
Technical Environment: AWS Redshift,
operational requirements and identified KPIs and Measures required for effective tracking of Inventory usage across location and time, monitoring of inventory costs and profits through multiple layers of information, and tracking of slowly moving inventory
•Developed a multi-dimensional data model required for inventory performance management.
•Developed ETL processes to Extract, transform and load data from SAP MM, PP and PR modules into the Data Mart
•Created several reports for Inventory performance Management
and jointly configured BPC environment, including dimensions, models, data access profiles and other security settings
•Developed complex ETL processes using SSIS to extract, transform and load data from several sources (ERP, files, databases) into a central cube
•Set up audit and security reports
•Developed data manager packages using SSIS
•Assisted in developing technical documentations for the administrative user tasks
for the end-to-end planning, installation and implementation of SAP BW 7.4
•Worked closely with the various business users and stakeholders of the 7 subsidiaries of UACN (CAP, UFL, SWAN, UPDC, UACR, GCL, and MDS) to identify KPIs and Measures and reporting and analytics requirement
•Designed, created, customized and configured required models and artifacts for a data warehouse (custom extraction structures, data sources, Info Objects, Basis Info Cubes, Remote Cubes, Transactional Cubes, Virtual cubes, Multi Providers, Info sets, ODS/DSO objects, Advanced DSO and Composite Provider)
•Developed ETL processes to load data from source systems to the data warehouse.
•Created several BI reports (using Tableau and WEBI) for the following departments: Sales, Procurement, Cost and FI management, Profitability Reporting, Manufacturing and Managerial Management
•Developed various technical documents to support and communicate design, data mapping, Functional and Technical specifications
•Created Performance Management and Analytical Dashboards for the top management
Technical Environment: SAP ECC (module: FI/CO, MM, PP, COPA, SD) BOBJ 4.1, SQL Server
and analyzed requirements (including data and KPIs) for carbon footprint accounting and carbon performance in-line with the university’s sustainability plan and DEFRA guidelines for carbon accounting.
•Developed Complex ETL solution to extract data from several data sources (Web services, XML, Metering System, etc) into a data warehouse developed using SSAS.
•Developed a Dashboard and a Reporting system (using Tableau 7) suitable for monitoring and reporting carbon emission activities, such as heating, use of electricity, waste recycling, business travels and stationary combustion.
UNICEF, FRANCE
Performance Management Dashboard
Role:
extensive data cleaning and transformation prior to generating and analyzing specific KPIs, trend patterns and relations
•Developed two different dashboards (using Xcelcius and Visual Intelligence) that render intelligence and insight generated from the given dataset with the aim of enhancing decision making towards efficiency and effectiveness of marketing and fund raising activities.
•Key emphasis were on keeping existing donors (Retention), increasing donations from current pledge donors (Enhancement) and increasing the number of people who donate (Growth)
for Business intelligence /MIS development and support
•Jointly led the realization of a 24 hours FormM and RAR processing timeline -achieved by optimizing SGS NG’s business processes
•Worked closely with the stakeholders from the Nigerian Customs Service (NCS), Standard Organisation of Nigeria (SON) and CBN to implement and support Nigeria Trade and Risk management initiatives (Asucuda++ and EFASS) for trade facilitation
•Developed tools to effectively manage and monitor electronic information interchange between SGS global trade system and the Nigerian Customer Trade system (Asycuda++)
•Responsible for analyzing, evaluating and documenting business and system requirements.
•Jointly developed and managed operational and management reports and BI dashboards
•Developed IT Procedure and Business Continuity Plan (BCP) for reliable quality of service and IT management
for database development and query optimization
Computer Science & Mathematics , Nigeria