John Kagina

Duties & Responsibilities
• Formulate Enterprise Analytics Strategy to fully leverage SAP Data-warehousing and BI Tools.
• Formulate BW Solution implementation standards based on best practise LSA framework
• QA BW solution designs developed by team members
• Manage delivery of all SAP BI solutions across business streams
• Formulate approach towards knowledge sharing within the team to guarantee sustainability of BI delivery
• End-to-End implementation of BI Solutions.

Mar 13 - Present: Britehouse Specialist SAP Division - South Africa
Web: www.britehouse.co.za/
Title: Senior SAP-BI/BW Consultant

Duties & Responsibilities
• Develop Technical Design Documents based on the Functional Design Specifications
• End-to-End BW Solution design using LSA design framework.
• Implement a set of reports on cross-functional Multi-providers layer covering Sales, Billing, Deliveries, Stocks and Purchasing
• Build LSA data and dataflow models based on IS-Media-specific extractors.

Jan 13 - Feb 2013: AVI Limited - South Africa
Web: http://www.avi.co.za/
Title: Senior SAP-BI Consultant

Duties & Responsibilities
• Design and implementation of enhancements in data and dataflow models.
• Creation and enhancement of Bex Queries and Workbooks.

March 12 - Dec 12: UCS Solutions - South Africa
Web: http://www.ucs-solutions.co.za/
Title: Senior SAP-BW Consultant

Duties & Responsibilities
• Design and implementation of functional enhancements in BI Applications across modules including SAP-CRM.
• Support to select clients in the retail industry
• General end-to-end solution performance optimization.
• Analyse all aspects of BW solution implementation against SAP's best practice with a focus on creating gap analysis documents with accompanying recommendations.

July 11 - Sep 11: City of Cape Town - South Africa (RSA)
Web: www.capetown.gov.za/
Title: SAP-BI Consultant

Duties & Responsibilities
• Analyse and validate existing user requirements.
• Propose and document recommendations on migrating BI reporting from a legacy system to SAP BW.
• Create a Power-User Training manual on a select BW Frontend Tools: Bex Query Designer and Bex Analyzer
• Application performance optimisation

Dec 07 - May 11: British American Tobacco (BAT) - South Africa (RSA)
Web: http://www.batsa.co.za/
Title: SAP-BI Consultant

Duties & Responsibilities
• Lead in the Design, Build, Test and Deployment of BI solutions that source data from heterogeneous source systems.
• Ensure the designs of the regional BI solutions are fit-for-travel (FFT) and therefore can be replicated in other regional BW instances, which collectively should create a platform for Global BI solutions for the Organisation
• Create Organisation's standardised BI solution templates to augment SAP BW/BI standard content.
• Continuously enhance the BW Architectural Guidelines and Design principles for the Organisation's BI solutions
• Controlling user access to sensitive data using BW Authorization Concepts.
• Application performance optimisation
• End-User training

Mar 01- Nov 07: Engen Petroleum Ltd. (RSA)
Web: www.engen.co.za/
Title: Senior Knowledge Worker

Duties & Responsibilities
• Understand the operational business processes and key success factors of various departments within the Organisation.
• Assist in aligning management information needs with the strategic direction of the company.
• Specify in liaison with the business, key performance metrics, analytical structures, business rules and data requirements for query reporting and analysis
• Whilst making use of the existing data, integrate new data and information flows into the Data Warehouse through well-configured dimension models and ETL design on the available BI platforms.
• Exploit existing Business Intelligence toolkit, methods and technologies to provide high quality information that underpins quick and informed decision making
• Supporting business and data analysts and the wider Data Warehouse user fraternity
• Enabling, administering and managing routine production, reporting and information provision.
• Creating complex ad-hoc Queries/Reports using both BW Bex Toolset as well as SAS Base.
• Report-performance tuning across Business Intelligence (BI) platforms