Mbali Venessa Moyo

An experienced and responsible business intelligence analyst who has more than 15 years of expertise in delivering meaningful and actionable data to employers in order to promote profit development. Capable of filtering information in order to locate and emphasise important metrics and discoveries that shed light on the situation. Through the use of intelligence assets to forecast and expose the most effective business strategies, Keen contributes to the growth of businesses.

• First National Bank FNB, Banking, 06/2022 - Current, Business Intelligence Analyst, BI Development: Design, implement and maintain all phases of project development. Create and modify SQL (Oracle, MySQL and Microsoft) scripts to retrieve and consolidate data in the data warehouse. Troubleshoot high level issues to identify and resolve problems caused by the database, source data, ETL, or the Business Intelligence software. Organize data, perform updates on systems and ensure compliance. BI Analytics Develop dynamic dashboards, grids, graphs, scorecards, and statistical reporting utilizing MicroStrategy software. Implement report requirements in MicroStrategy or BI tool. Interacts with business teams to define dashboards and reporting solutions to meet diverse, complex business needs. Establish and maintain design and development best practices. Provide proactive production support for MicroStrategy and other BI/Analytics applications. Manage MicroStrategy Administration which can include user maintenance and security roles, report schedules, cube maintenance and monitoring of jobs. Create and update all necessary design documentation as per the project requirement. Produce Ad-Hoc queries and reports as needed along with providing on-going analytical support for these requests with metrics, attributes, relationship filters, and prompts to support reporting. Perform detailed data analysis, validation, and identify data quality issues to ensure consistency across all environments. Train users on how to efficiently run reports that have been predesigned as per business requirements. Develop and maintain ISO documents related to the BI life cycle. These documents include. Business Requirements Documents, Change Request Documents, User Guides, User Access Forms, UAT Scripts, User Disablement Forms and Logical Data Model Specification Quality assurance testing to ensure accuracy of data on reports that have been developed before deployment to production.
• Ithuba National Lottery, Gaming & Leisure, 10/2018 - Current, Business Intelligence Analyst, BI Development: Designing and maintaining application objects and schema objects using MicroStrategy Use the Warehouse Catalog to add and update tables in Microstrategy from multiple data sources. Create Parent/Child relationships and set up dynamic attributes. Create and modify SQL (Oracle, MySQL and Microsoft) scripts to retrieve and consolidate data in the data warehouse Use Oracle Data Integrator to transform and pass data from database to another. Troubleshoot high level issues to identify and resolve problems caused by the database, source data, ETL, or the Business Intelligence software (common examples: nulls in data causing joins to function incorrectly; ETLs failing; Microstrategy Objects not set up properly) BI Analytics Develop dynamic dashboards, grids, graphs, scorecards, and statistical reporting utilizing MicroStrategy software. Implement report requirements in MicroStrategy or BI tool. Interacts with business teams to define dashboards and reporting solutions to meet diverse, complex business needs. Establish and maintain design and development best practices. Provide proactive production support for MicroStrategy and other BI/Analytics applications. Manage MicroStrategy Administration which can include user maintenance and security roles, report schedules, cube maintenance and monitoring of jobs. Create and update all necessary design documentation as per the project requirement. Produce Ad-Hoc queries and reports as needed along with providing on-going analytical support for these requests with metrics, attributes, relationship filters, and prompts to support reporting. Perform detailed data analysis, validation, and identify data quality issues to ensure consistency across all environments. Decommission old reporting tool (SSRS) and transitioning over to Microstrategy by recreating all reports. Train users on how to efficiently run reports that have been predesigned as per business requirements. Develop and maintain ISO documents related to the BI life cycle. These documents include. Business Requirements Documents, Change Request Documents, User Guides, User Access Forms, UAT Scripts, User Disablement Forms and Logical Data Model Specification Quality assurance testing to ensure accuracy of data on reports that have been developed before deployment to production.
• Webber Wentzel, Legal Services, 08/2015 - 09/2018, CRM Data Analyst, Data Reporting & Customer/Client insight Research Extracting, Manipulating, Cleansing & Processing data for reporting using excel and other reporting tools. Support management teams’ requirements for business operational reports and analyses Performs ad-hoc, monthly, quarterly and annually data analysis and reporting. Understanding internal stakeholders needs and providing practical and relevant solutions to these needs. Create, research and analyse client/customer intelligence insights reports for distribution to relevant stakeholders. Scrutinising briefs and asking the right questions to ensure the right outcome or insights are reached. Creating structure from a mass of quantitative consumer, competitor and market data Work closely with client teams to help translate raw enterprise data into meaningful analyses and insights for consultation with clients and company leaders. Ensure that proper controls are in place so that reports are accurate and timely; resolve any issues/errors. Identify opportunities for new features or enhancements of documents and systems in place. Liaising with end-users and 3rd party suppliers Analysing raw data, drawing conclusions & developing recommendations Writing test cases and system testing Analysing data to identify patterns and correlations among the various data points. Promptly responds to service failures, resolves issues, and escalates concerns as appropriate. Initiate process changes and enhancements where necessary and see to successful implementation of systems and reports. Working closely with project teams on systems specific initiative that involves integration development. Making sure that solutions are compliant with design standards and aligned to business requirements. Making sure that SOPs are updated and up to date. Adherence to system policies, procedures and guidelines Follow up on work progress and identify stakeholder support needs through well managed meetings, using action plans and prioritizing for the key clients. Identify pitfalls and/or additional improvements in implementation and work out solutions with team and stakeholders. Change and improvement management by establishing a systematic process.
• Webber Wentzel, Legal Services, 08/2015 - 09/2017, Data Analyst, Manipulating, cleansing & processing data using excel Responsible for loading, extracting and validation of client data. Liaising with end-users and 3rd party suppliers Writing Test cases Data entry, data auditing, creating data reports & monitoring all data for accuracy. Bulk mailer system implementation, maintenance and management Newsletter formatting Maintain integrity of data and monitoring the compliance of the system data Provide second line admin support for CRM handling data capture and extraction report requests. Initiate process changes and enhancements where necessary and see to successful implementation. Making sure that SOPs are updated and up to date. Adherence to system policies, procedures and guidelines Customer satisfaction and root cause analysis identifies opportunities and gaps. Reason for leaving: Seeking new challenges & career growth
• FLSmidth, Engineering, 06/2013 - 07/2015, Sales Support & CRM Coordinator, Retrenchment & restructuring

• Date of Birth: 02/05/83
• Gender: Female
• Nationality: South African

Awards: Customer service award, efficiency awards, self-improvement award and Managerial Excellence Award