ERP Business Analyst

• May 2022 - Present

Key Accounts Manager - Data and Business Analyst

• Apr 2011 - Aug 2021

Breakdown of Duties: Data Analyst / Reporting / Processes / Campaigns: SMS/Email/Mail and Recall Campaign Management for major OEMs within South Africa Streaming Processes and producers for various OEM’s using MS Visio Simplex SQL Queries using workbench 44.0.0 tool to connect to Sales Force Dynamics database Dashboard design for a major OEM within South Africa using Sales Force Dynamics front end Reports Application Simplex Queries and creating Views using MS SQL Server Management Studio 2014 for Sage Evolution databases Creation of Microsoft Excel Dashboards / Reports using ODBC connection / macros and various formulas including v-lookup / h-lookup / nested-if etc. Database Management: Data Cleansing by means of exporting and importing data identified to be cleansed within Sage Evolution using SQL Server Management Studio and Sales Force Dynamics using Workbench 44.0.0 tools Data Projects – Telephonically cleaning data (Call Centre Agent Assistance) Database Management (backups / new user creation / security roles etc.) Mapping of different datasets to get desired outcome to use for Reports and Analysis Systems and Business Analyst Duties: Super User and Administrator - MS CRM 2011 (2011 – 2016) First Line Support / Business Analyst and part of CCB - Sales Force Dynamics (2016 – Current) Change Requests / UAT / Role out and training of new development to Business – Sales Force Dynamics (2016 – Current) Sage Evolution Database Administrator (2013 – Current) Part of CCB for Qlik Sense Reports Development Project – (Apr 2018 – Current) Show less

Real Estate Consultant and SME

• Aug 2010 - Mar 2011

Key responsibilities: Subject Matter Expert Real Estate Data Stream: Overall Management of Data Cleansing Stream: 15 Data Capturers, 1 document controller, 4 Quality Controllers, 2 Team Leaders and 2 Operation coordinators. Lead daily team meetings. Streamlining and Implemented effective and efficient process to cleanse scope defined by Deloitte and client. On-going Quality Control of data cleansing Stream and processes. On-going refinement of Data Cleansing Process (Trouble shooting of process). Daily feedback to Project Manager. Client liaison - Continuous interaction between client and Data Cleansing Team. Reports to illustrate overview of Data Cleansing Stream by applying best practice building blocks, as is and to be view of data cleansed. Additional Responsibilities: Subject Matter Expert Real Estate Database Solution (MIS) Report Objective presentations with client to discuss how reports will assist and ensure effective portfolio management and enhance data integrity using MS PowerPoint. User acceptance testing (UAT) of developed reports with client for sign off. Assistance to Process Stream Report mapping to Real Estate data matrix. Integration between Data Cleansing Stream / REDB Solution and Process stream. Assistance to Utilities Stream Assisted with implementation of solution to link account data from various sources to central data source. Show less

Data and Reports Analyst

• Sep 2007 - Feb 2010

Key Responsibilities: Daily, weekly, monthly and adhoc report writing using Business Intelligence tool Alchemex for several automotive clients. Writing Processes and producers to assist various departments. Alchemex report manager template design. Insuring link to databases on administrator module is in working condition. Training on Qlik View Business Intelligence application for dashboard development. Assist developers in improving the in-house reporting system to enhance daily processes within the business. Reason for leaving: Head Hunted - better opportunity offered by Deloitte Consulting Show less