MS and Oracle SQL
Ndabezinhle Ndlovu
Data And Analytics Professional
Johannesburg,GP
Summary
Profile Summary
Quality-driven Technical Lead well-versed in data and reporting best practices, project management requirements and support operations. Successful at building robust data and reporting solutions for changing business needs. Driven professional enthusiastic about meeting market challenges with scalable technologies.
Industries: Mining,Telecommunications, Banking, Retail, Technology and Government.
Overview
10
10
years of professional experience
12
12
years of post-secondary education
1
1
Language
Work History
Technical Lead – Power BI and Azure
SASOL
4 2023 - Current
- Directed and oversaw data model build process for quick retrieval and analysis of the data
- Orchestrated data and reports validations and investigations between the legacy source system and target cloud system
- Overseeing built data marts for accuracy of the logic replication and relevance to reports logic
- Orchestrated the replication of Master data from SAP BW systems in the Azure Synapse environment
- Reporting Hierarchy structure rebuilding in Azure and Power BI environment
- Directed the preparations and execution of reporting SIT and UAT test Scripts
- Acquired proficiency in designing AS-IS and TO-BE Power BI architecture design documents
- Designing and facilitating training for business users on using Power BI and Azure Synapse SQL
- Oversaw data quality concerns and resolutions to ensure accurate analysis and reporting
- Collaborated with a team of Azure data engineers, Architects and SAP BW consultants for issue resolution
- Key impact/highlight: Directed successful migration of 150+ reports and underlying business logic from SAP BW reporting tools to Power BI with a team of 4 junior developers and 1 senior developer in less than 12 months.
BI Hybrid Analyst & Developer (Big Data Advanced DataMart)
MTN
06.2022 - 04.2023
- Oversaw interpreting of data and results using statistical techniques and providing reports
- Acquired proficiency in acquiring data from source systems and maintaining datasets, identifying databases, data collection systems, data analytics and other strategies to optimize statistical efficiency and quality
- Facilitated interpretation of trends in data sets and monitoring of performance indicators
- Collaborated with the business project teams to prioritize data and information requirements
- Directed new data collection mechanisms and process improvement opportunities
- Designed and implemented big data solution, data flows and quality improvement processes
- Understanding of big data management frameworks and techniques
- Key impact/highlight: Accomplished reduced number of number of data and reports issues raised from different teams across the business from 10+ issues raised daily to less than 3 issues raised daily.
Data & Analytics Lead
SoluGrowth
05.2022 - 06.2022
- Directed AS-IS analysis of current data and analytics capabilities for one of the leaders in the financial sector for their new ERP requirement gathering
- Orchestrated and collaborated on gap analysis activities of the data and analytics ecosystem
- Acquired proficiency in designing and recommendation of future state data architecture and reporting requirements for the new ERP
- Carried out data management standards and frameworks to be adhered to on the new ERP.
Data Migration Consultant
Strategic Dimensions
10.2021 - 04.2022
- Directed data cleaning and preparation planning and execution activities for data migration
- Directed AS-IS analysis of existing data flows and challenges
- Acquired proficiency in designing data migration workflows for moving data from legacy system to the cloud version of the system
- Collaborated in data comparison between the legacy systems and the cloud version of the system
- Responsible for data quality improvement on gaps that were discovered on the migrated data
- Key impact/highlight: Successfully migrated at least 50 data objects from the on-premises environment solution to a cloud-based environment solution.
Independent Data Analyst Consultant
UpWork
07.2021 - 09.2021
- Orchestrated accurate and thorough analysis, weekly audits, reconciliations, and other ad hoc reporting of Human Resources/Contingent Labor data from multiple sources
- Collaborating with functional and technical staff to build and maintain dynamic and automated dashboards
- Designed and implemented scalable, repeatable reporting and data pipelines to meet business users’ needs
- Facilitated maintaining data integrity in systems by performing audits, running queries, and analyzing data
- As a member of the project team, I supported initiatives such as gathering business requirements and carrying out ad hoc reports as per different projects requirements.
Global Consulting Manager – HR Strategic Planning, Reporting & Analytics
MTN Group
05.2019 - 06.2021
- Directed and executed monthly and ad hoc group HR reports for the EXCO and senior leadership as per business requirements
- Directed data stewardship on all Group HR data related data requests which included: Employee Survey information, HR benchmarks, diversity and inclusion, budget planning and ad hoc data requests from all MTN 24 operations across Africa
- Directed data architecture for MTN Group HR Datawarehouse Project for centralizing and improving the quality of the data across all 24 countries
- Acquired proficiency in data analysis, data modeling, data quality improvement, data architecture and data visualization
- Collaborated in organizing and hosting recurring data quality sessions monthly for alignment and information on data quality improvement
- Facilitating high variances investigations on the provided reports for clarity and mutual understanding
- Projects: Group HR Datawarehouse Project (Jan 2020 – Jun 2021): Data Lead & Architect: The project aim was to centralize MTN Group HR data points of all 24 operations across Africa
- This includes Excel, HRIS and HCM data
- Global Sentimeter Survey Project (Nov 2020 – Jun 2021): Surveys Administrator: The project was aimed at getting employees feedback frequently at least 4 times a year
- Key impact/highlight: Leveraged Group HR diverse data sources to select the top 20 high performing females for leadership roles as part of the diversity and inclusion initiative.
Senior Associate – Big Data Analytics & Automation
PriceWaterhouseCoopers
04.2018 - 04.2019
- Collaborated on loading client big data to the virtual database and diagnosed the data loaded in the sandbox
- Collaborated for post diagnosis, cleaning the duplicates and junk big data transactions
- Directed in customizing the SQL logic based on the new rules provided by the business users
- Performed root cause analysis and investigated the anomalies observed and discussed this with the manager
- Adhering to the timelines and maintained the quality of work assigned
- Assisted and guided other team members to manage their work
- Collaborating with the data and analytics competency in solving society’s challenges
- Facilitated the preparation and distribution of the project leadership pack for progress updates for the project
- Projects: Reconciliation Project (Jun 2018 – Apr 2019): Senior Analyst & Project Manager Assistant: The project was about investigating transactions that were not allocated, transactions that were above the limit to FICA and flagging transactions that were not reported to FICA
- Procurement Spend Analysis Project (Jun 2018 – Sep 2018): Senior Analyst: The project was about data analysis of procurement spend data for a mining operator focused on high costs of raw materials that impact the procurement budget
- We categorized the costs by contractual and non-contractual and by suppliers to find the sources of high costs
- Perform Call Centre Employee Performance Diagnostic Project (Apr 2018 – May 2018): Data Lead: The project was a performance diagnostic initiative to use data to show variances on call center individuals’ performance and on teams’ performance, helping the leaders in the financial sector to realize opportunities for upskilling and more capacity in call centers
- Key impact/highlight: Contributed to a FICA reconciliation project which assisted leaders in banking for preventing penalties due to inefficiencies from their inaccurate reporting.
Associate Consultant – Big Data Analytics & Cloud
Oracle Consulting
04.2016 - 03.2018
- Collaborated resolving the issues within the given stipulated SLA time
- Facilitated prototyping sessions to evaluate software functionality to the business users for demonstration purposes
- Collaborated in providing production support and working closely with other team members to ensure availability, quality, and timely delivery Oracle Big Data/Cloud Solution
- Developed custom reports for meeting clients reporting requirements on the ERP system being implemented
- Facilitated training users on the usage of the new solution being implemented for productivity and new ways of working
- Projects: Big Data Upselling & Cross Selling Initiative (Jun 2017 – Jan 2018): Oracle Presales Big Data Consultant: The initiative was about integrating customer data into an Oracle Big Data Discovery platform and enabling the bank to find upselling and cross selling opportunities that exist within their customer data
- E.g.: with customers that had a credit card, based on how they used their credit card the bank was able to sell loans or other offerings based on their credit card data
- Master Data Management Project (Jan 2017 – Apr 2017): Oracle Data Quality Consultant: The project was about assisting SITA with building a golden record using the Oracle Enterprise Data Quality tool for data profiling, performing data checks, developing processes, and creating rules for building the Golden Record
- Key impact/highlight: Acquired competence in ensuring client reporting requirements are met through custom reports for reports that were not included in the original solution reporting capabilities.
Internal Auditing Trainee – Risk Management & Compliance
Massmart
01.2015 - 01.2016
- Identifying, evaluating, and analyzing both internal and external risks that could affect the organization's operations or reputation
- Maintaining Massmart and Walmart Group risk management policies and procedures across different stores Working with external vendors and stakeholders to ensure compliance with legal and regulatory requirements
- Developing and maintaining risk reports and dashboards for local and global leadership reporting
- Key impact/highlight: Enabled integrated reporting capabilities of all stores for senior management
- Previously different risk and compliance managers were sending/sharing siloed reports to senior management.
Education
High School Diploma -
Vukile High School
04.2001 -
Bcom Management Information Systems - Commerce And IT
University of Zululand
04.2001 - 04.2013
Postgraduate New Managers Programme - Business Administration And Management
Wits Business School
04.2001 -
No Degree - Strategic Management Certificate
University of Witwatersrand
04.2001 -
No Degree - Telecoms Mini MBA Certificate
Telecoms & Tech Academy
04.2001 -
No Degree - Data Science Advanced Training
MTN Data Science Academy
04.2001 -
No Degree - Microsoft Azure Data Fundamentals Training
Microsoft
04.2001 -
No Degree - Microsoft Planning And Deploying SAP On Azure
Microsoft
04.2001 -
No Degree - ACE Foundation Solution Architect Certificate
Wipro Architect Career Essentials
04.2001 -
No Degree - Microsoft Fabric Analytics Engineer Certificate
Microsoft
04.2001 -
No Degree - Microsoft Power BI Hands On Training
Microsoft
04.2001 -
Skills
Analytical Thinking
Customer-Oriented
Creative and Innovative
Effective Communication
Solution Architecture & Management
Technical mentoring & coaching
Software
Power BI
SAP Apps
Azure SQL
MS Excel
MS PowerPoint
Oracle Data Integrator
Oracle Enterprise Data Quality
MS Visio
Timeline
BI Hybrid Analyst & Developer (Big Data Advanced DataMart)
MTN
06.2022 - 04.2023
Data & Analytics Lead
SoluGrowth
05.2022 - 06.2022
Data Migration Consultant
Strategic Dimensions
10.2021 - 04.2022
Independent Data Analyst Consultant
UpWork
07.2021 - 09.2021
Global Consulting Manager – HR Strategic Planning, Reporting & Analytics
MTN Group
05.2019 - 06.2021
Senior Associate – Big Data Analytics & Automation
PriceWaterhouseCoopers
04.2018 - 04.2019
Associate Consultant – Big Data Analytics & Cloud
Oracle Consulting
04.2016 - 03.2018
Internal Auditing Trainee – Risk Management & Compliance
Massmart
01.2015 - 01.2016
High School Diploma -
Vukile High School
04.2001 -
Bcom Management Information Systems - Commerce And IT
University of Zululand
04.2001 - 04.2013
Postgraduate New Managers Programme - Business Administration And Management
Wits Business School
04.2001 -
No Degree - Strategic Management Certificate
University of Witwatersrand
04.2001 -
No Degree - Telecoms Mini MBA Certificate
Telecoms & Tech Academy
04.2001 -
No Degree - Data Science Advanced Training
MTN Data Science Academy
04.2001 -
No Degree - Microsoft Azure Data Fundamentals Training
Microsoft
04.2001 -
No Degree - Microsoft Planning And Deploying SAP On Azure
Microsoft
04.2001 -
No Degree - ACE Foundation Solution Architect Certificate
Wipro Architect Career Essentials
04.2001 -
No Degree - Microsoft Fabric Analytics Engineer Certificate
Microsoft
04.2001 -
No Degree - Microsoft Power BI Hands On Training
Microsoft
04.2001 -
Technical Lead – Power BI and Azure
SASOL
4 2023 - Current
Similar Profiles
Sibongiseni MasingaSibongiseni Masinga
Technician II Analyzer at SasolTechnician II Analyzer at Sasol
Thapelo Lee MafongoziThapelo Lee Mafongozi
Fabrication Shop Area Manager at SasolFabrication Shop Area Manager at Sasol
Alex PradeepAlex Pradeep
Sr. Solution Architect for Resource to Product workstream at SasolSr. Solution Architect for Resource to Product workstream at Sasol
Aaron ShuffAaron Shuff
Asset Integrity Instrument Specialist at SasolAsset Integrity Instrument Specialist at Sasol
Ben NgcoiBen Ngcoi
Senior Warehouse Supervisor at DSV SolutionsSenior Warehouse Supervisor at DSV Solutions