Emari L.

Bi/Etl Developer

310 dollar

My experience

-January 2018 - Present

More

Distell, Stellenbosch, South AfricaMay 2017 - August 2018

BPC Embedded / BW-IP Implementation and BW Systems Analyst
Projects
● On Development team for SAP BPC 10.1 Embedded Planning Solution
● On BW team for BW development of business requirements and routine maintenance
Responsibilities
● SAP BW IP (Integrated Planning)
o Creating planning filters, functions and sequences in SAP IP
o Building plannable Input Templates and Reports using SAP BEx Query designer
o Creating Analysis for Office Workbooks, Input Templates and Reports
o VBA functions integrated with Excel and Analysis for Office
o Building data extractors from SAP ECC and all ETL (also from non-SAP systems) of Master Data and Transactional Data
● SAP BW (Business Warehouse) Developer
o Responsible for incorporating all new master data requirements for Planning Project to live production environment
o SAP ABAP code for start and end routines in BW transformations for master data and transactional data
o Building and monitoring daily process chains for business requirements
● Experience with SAP BPC & BW project methodologies, data and master data management within SAP ECC, BW & BPC and change control processes
More

Independent Contractor with EOHOctober 2016 - April 2017

BPC / BW-IP Implementation Team Lead
Projects
● SAP BPC 10.1 Embedded Budgeting and Forecasting Planning Solution at Media 24
Responsibilities
● End-to-end implementation of SAP BPC Planning solution – (Team Lead)
o Solution design and implementationo Building plannable Input Templates and Reports using SAP BEx Query designer
o Analysis for Office: Workbooks, Input Templates and Reports
o Fox code editing – planning functions and sequences
o BW Master data maintenance and collaboration for automation from ECC and HR Payroll
o SAP BW Security Set-Up
o Training Material and knowledge transfer to business users and SAP BW support team
More

CQS Performance Solutions, South AfricaJanuary 2011 - September 2016

BPC Implementations
Projects
● Support: SAP BPC 10.1 NW Budgeting Solution at The Foschini Group (TFG) (Current)
● Upgrade Project: SAP BPC 10.1 on Hana NW Consolidation solution at Shoprite (2016)
● Implementation of SAP BPC 10.0 NW Planning solution at Distell (2014 – 2015)
● Implementation of SAP BPC 10.0 NW Budgeting solution at Anglo American Platinum (2013)
● Implementation of SAP BPC MS 7.5 Budgeting (Capex) solution at AfriSam (2013)
● Implementation of SAP BPC MS 7.5 Long Term Planning solution at Anglo American Platinum (2013)
● Implementation of SAP BPC MS 7.5 Budgeting solution at Distell (2013)
● Implementation of SAP BPC MS 7.5 Denomination Change solution at Shoprite (2013)
● Implementation of SAP BPC 10 NW Budgeting solution at City of Cape Town (2012)
● Implementation of SAP BPC MS 7.5 Budgeting solution at Shoprite (2012)
● Implementation of SAP BPC MS 7.5 Consolidation solution at Pioneer Foods (2011)
Responsibilities
End-to-end implementation of SAP BPC Planning and Consolidation solutions: Application/Model Build, Master Data ETL / Automation from BW, Input Templates and Reports, Analysis and Reporting, Advanced Script Logic, Visual Basic Development, Business Rules, Data Manager Packages, Member Formulas, Controls, Business Process Flows, SQL Stored Procedures, Security Set-Up, Work Status, Audit Trail, Maintaining Parameters in BW, Transports, Back-End Set-Up & Implementing SAP Notes, User & Administrator Training Material, Knowledge Transfer to Team, Users and System Administrators. User & System Support.
More

Contractor for 8th Man Consulting (now Ernst & Young/EY)June 2009 - January 2010

HFM Implementation
Project
Consolidation Implementation Hyperion Financial Management System 11.1.1.3 for MWeb Africa.
Responsibilities
End-to-End Implementation of HFM. (Creating Application, Importing Metadata, Creating Web Forms, Data Grids, Journal Management, SmartView Reporting, Ad Hoc Analysis, Hyperion Financial Reporting, Data Management using FDM, Security set-up using Shared services). User and System Administrator Training Material & Knowledge transfer. User support.

My stack

Languages

Visual Basic, C++, ABAP, Excel Macro (VB macro), SQL, Matlab

Business Intelligence

HFM, Business Intelligence, SAP Business Information Warehouse, OLAP, Hyperion, ETL, Data Warehouse, Business Objects

Others

Quality control, Business Analysis, Project Management, Problem Solving, Business Strategy, Business Process

Other

Shared Services, Creating planning, Microsoft Office, SAP-netweaver- Master Data, SAP ABAP, SAP OFFICE, Data Modeling, Visual Basic for Applications, Forecasting Planning, Business Planning, SAP BPC, Microsoft Windows 10, SAP HR PY, Data management, SAP-netweaver- Business, SAP SAP NetWeaver, SAP-netweaver- BW, Essbase, SAP HR, Back End, Budgets & Budgeting, SAP ECC, Zulu, Microsoft Windows, SAP IS M, SAP-NETWEAVER- Business Warehouse, SAP Systems Analyst, Integrated Planning, Creating Analysis, Dynamic Data, SAP-FI- reporting

Databases

Microsoft SQL Server

Computer Tools

MS Excel, EPM, Microsoft Excel

ERP&CRM

SAP, ERP

IT Infrastructure

Windows, Unix, Linux

Embedded and Telecom

FDM

Analysis methods and tools

Requirements Analysis

My education and trainings

Certificate level. Operational level: P1 – Performance Operations - Chartered Institute for Management Accounting (CIMA)2010 - 2010

Hyperion Essbase Analytics 9.3 Developer Certification - Oracle2009 - 2009

Master of Science, Physics - University of Stellenbosch, Cape Town2000 - 2000

B.Sc. Honours in Radiation Physics - University of Stellenbosch1998 - 1998

Bachelor of Science, Physics - University of Stellenbosch1995 - 1997