Elitha Beaulah Soqele
About
Detail
Senior BI Consultant
Western Cape, South Africa
Résumé
Jobs
verified_user
0% verified
- FSenior Business Intelligence (BI) ConsultantFluidAug 2019 - Current (6 years 9 months)Duties Jembi Health Systems, National Department of Health, Home Choice BI Consultant - Data Visualisation * Requirements gathering: Interact with clients to understand requirements and business needs. Gather, document and design data integration and data visualisation requirements * Data Analysis: Identify, analyse, and understand supporting data to propose solid solutions * ETL: Extract, transform & load data from an extremely wide field of data sources into staging datasets & ultimately into visualisation tools. * Data visualisation: Use visualisation tools (Power BI, Tableau) to understand and manipulate complex datasets in a simple and intuitive format, to rapidly generate impactful, interactive visualisations. Apply leading
Business Intelligence (BI) ConsultantPrescient Business TechnologiesMar 2019 - Jul 2019 (5 months)- Consultant to Woolworths Financial Services Duties Woolworths Financial Services (Customer Value Management) Senior Data Analyst * Manage implementation of project and production schedules. Project management. * Marketing data business analysis and customer insights analysis. * Take ownership of client's marketing leads generation process, ensuring that automation is delivered accurately and on-time. * Data extractions, scrubbing, transformation, and presentation of data while ensuring integrity and accuracy of ad-hoc queries. SAS Code changes, debugging and version control. * Data quality assurance checks. * Adjusting and maintaining templates according to client requirements. * Engage in regular interaction with clients, to- Business Intelligence (BI) ConsultantPrescient Business TechnologiesNov 2018 - Mar 2019 (5 months)- Consultant to Santam Duties Santam (MSA) Business Intelligence Developer * Build and maintain QlikView models (model back end design). * Code changes, debugging and version control. * Data and application integration. * Data extractions, scrubbing, transformation and presentation of data while ensuring integrity and accuracy of ad-hoc queries. * Data analysis & data quality assurance checks. * Manage client requirements and assist with optimising performance of applications. * Change documentation preparation.
- Business Intelligence (BI) ConsultantPrescient Business TechnologiesMay 2017 - Oct 2018 (1 year 6 months)- Consultant to Medscheme Duties Medscheme - Health Intelligence Unit (HIU) SAS Cube Developer * Build and maintain SAS cubes (SAS 9 OLAP Cube Studio & SAS Enterprise Guide). * Updating SAS Code (Base SAS) changes and version control on cube builds. * Maintain the logical design model of the data used by the HIU team in their flagship reports. * Data analysis. * Data extractions, scrubbing, transformation and presentation of data while ensuring integrity and accuracy of ad-hoc queries. Review & optimise SAS scripts. * Data quality assurance checks. * Updating excel report structure, aesthetics and data flows (VBA & MDX). * Ensure that production flaws are effectively and timeously addressed. * Collaborating with system architec
- Business Intelligence (BI) ConsultantPrescient Business TechnologiesNov 2016 - Apr 2017 (6 months)- Consultant to Old Mutual Master Data Management Duties Old Mutual Data Management Data Acquisitions Analyst * Ensure delivery of business related project specifications to support business objectives and department of home affairs project. * Identify and manage any risks introduced by process changes. * Identify inefficiencies and champion continuous improvement on the system. * Ensure that production flaws are effectively and timeously addressed. * Collaborating with system architects to define processes to support automated reporting structures. * Liaise with the business users and developers regarding requirements for new and/or improved functionality. * Communication of priorities and progress of delivery. * Coordination
- Business Intelligence (BI) ConsultantPrescient Business TechnologiesJan 2016 - Nov 2016 (11 months)- Consultant to Woolworths Food Division Duties Woolworths: Foods Division Price & Promotions Analyst * Data analysis and visual representation: Product & price performance monitoring and, foods promotions analysis. * Data exploration (SQL) to drive foods promotions profitability. * Continuous pricing and volume analysis on a regional, product, channel and customer basis * Understanding and analysing promotional spend. * Research competitor product prices and perform analysis of research findings. * Keep abreast with the changes in the pricing environment and economy. * Liaise with Marketing and Sales department when developing attractive and fair pricing strategies for large deals or proposals. * Tableau Specialist: Data extrac
- Business Intelligence (BI) ConsultantPrescient Business TechnologiesMay 2015 - Dec 2015 (8 months)- Consultant to Old Mutual CRU Duties Old Mutual Customer Engagement: Customer Retention unit (CRU) Marketing Data Analyst * Analysis of financial and non-financial data sources utilizing SQL, SAS and excel. * Contact center operational data analysis and reporting. * Through collaboration with various business units (e.g. Corporate Affairs, Master Data Management, Analytics, etc.), gain an understanding of different data sources, document data flows, determine desired reporting needs and draw customer insights. Worked with key stakeholders to develop and refine reporting requirements across the CRU business. * Use good practices in business intelligence and analytics to better understand campaign performance and develop campaign d
- Business Intelligence (BI) ConsultantPrescient Business TechnologiesAug 2014 - May 2015 (10 months)- Consultant to Old Mutual Master Data Management Duties Old Mutual Customer Engagement: Master Data Management Data Acquisitions Analyst * Work with various vendors to develop, identify, locate, support, acquire, and manage country-specific data requirements. Conduct due diligence for new data sources and establish degree of credibility with potential vendors and clients. Ensure master data consistency and adherence to master data policies. * Develop, edit, and update Standard Operating Procedures and process documentation. * Perform data quality assessments for Corporate Division and African countries to establish potential data sources within the organisation. Identify, analyse, and interpret trends or patterns in complex data s
- Business Intelligence (BI) ConsultantPrescient Business TechnologiesApr 2014 - Aug 2014 (5 months)- Consultant to Old Mutual Analytics Duties Old Mutual Customer Engagement: Analytics Business Intelligence Manager * Data analysis and visual representation: Product performance monitoring and, supporting stakeholders with sales trends and customer retention strategies. * Data exploration to support campaigns team with marketing initiatives. * Data extractions, scrubbing, transformation and presentation (SAS software & Tableau used) of data while ensuring integrity and accuracy. * High focus of visual data representation to enable data interpretation & explanation to management. * Monthly MIS Reports: Report design, maintenance and improvement. * Data quality assurance checks. * Assisting juniors with data acquisition projects, m
- Business Intelligence (BI) ConsultantPrescient Business TechnologiesAug 2012 - Mar 2014 (1 year 8 months)- Consultant to Old Mutual Retail Affluent Duties Old Mutual Retail Affluent MIS (Management Information System) Specialist * Data extractions, scrubbing, transformation and presentation using SAS while ensuring data integrity and accuracy. * Data analysis, reporting analysis & performance tracking. * Business intelligence support to the distribution channels of Old Mutual. * MIS Reports: Report design, maintenance and improvement. * Data quality assurance checks. * Relational database structures, tables, views and stored procedures. * Report migration from SAS platform to Microsoft Reporting platform.
- BI & Data Mart AnalystWoolworthsFeb 2009 - Jul 2012 (3 years 6 months)Duties Process & stakeholder management * End-to-end campaign process management of product cross-sell space across the retail store card, personal loans, credit card & short-term insurance products. * Managing stakeholder expectations and monitoring client targets. * Maintaining client relationships across all business units key to the cross-sell space. Data analysis & Performance tracking * Data extractions, scrubbing, transformation and manipulation using SAS while ensuring data integrity and accuracy. * Compiling reports for Product and Marketing business units for use in campaign design strategies and for Value Management team to use for growth strategy development. * Advanced knowledge of MS Office including Excel, PowerPoi
Education
verified_user
0% verified
- Bcom- STATISTICS & FINANCEStellenbosch University/Universiteit StellenboschJan 2005 - Dec 2008 (4 years)
Awards
verified_user
0% verified
- SSoft skills training re-enforced the following vital people skills: leadership, self-actualisation
- ccommunication, problem-solving & conflict resolution
- SStrong communication, interpersonal skills and leadership skills
- TTeam player and possess information sharing ethic. Highly capable of working on my own
- AAdvanced analytical skills. I also have programming experience in SAS, SQL, R, VBA and MDX
- PProcess-, operations- & stakeholder management skills (acquired via Business Intelligence consultant role)
- SStrong ability to effectively manage projects and meet deadlines, even when under pressure
- WWillingness to learn and highly driven
- EEnergetic, passionate and professional
- DData visualisation specialist