Patience Muserere
Birmingham,West Midlands
Summary
Experienced Data Analyst with expertise in data cleansing, wrangling, and preparation for historical and predictive analysis. Skilled in developing internal KPI dashboards to drive data-driven decision-making and identifying growth opportunities to optimize sales performance. Proficient in exploratory data analysis (EDA), data cleaning (e.g., imputing missing values, capping outliers, removing duplicates), and ensuring data integrity and normalization. Experienced in processing confidential data in compliance with guidelines, particularly for forensic audits.
Strong command of SQL for query writing, reporting, and script optimization, as well as Python for data transformation and validation. Adept at presenting data insights through visualizations (Power BI, Tableau) to executive leadership, effectively communicating trends, patterns, and actionable predictions. Expertise in performing audits on data for business development purposes and defining new data collection and analysis processes to support organizational goals.
Overview
11
11
years of professional experience
7
7
years of post-secondary education
1
1
Certification
Work history
Assistant Manager - Technology Risk Assurance
BDO LLP UK
Birmingham
2022.09 - Current
- Interpreting financial audit impact of IT risks and control weaknesses and Integrating Data Analytics testing into an external audit approach
- Reporting on data analytics procedures, processes and results to financial audit teams for further investigation of irregularities and anomalies
- Performing data wrangling and manipulation using automated workflow tools such as MS SQL scripting, Azure Data Bricks, Python, R
- Scoping and planning data-enabled audit approaches to address audit risks in the most effective way
- Providing audit assurance through re-performance and analysis of data using data analytics tools ( Azure data bricks ,Microsoft SQL, Python, R)
- Performing Audit of revenue , verifying company's reported revenues using data analytics tools.
- Performing analytics of data from Enterprise Resource Planning (ERP) systems such SAP , Oracle, Microsoft Navision, Microsoft Dynamics
- Performing data analytics on process mining of Order to Cash processes, Procure to Purchase processes and Revenue to cash analytics
- Utilising Power Bi data visualisation to create interactive dashboards for identifying and assessing risks throughout all stages of audit
- Developing high quality efficient audit strategies that are data focused
- Providing on-going support and training to junior and newer members of the team, and ensuring high quality audit standards are maintained
Data Analyst
Deloitte
Harare
2019.07 - 2022.08
- Performed heavy data cleansing, wrangling and preparation for historical and predictive analysis
- Developed internal KPI dashboards to drive analytic based decision making
- Identified potential growth opportunities and optimize sales performance
- Developed EDA and data cleaning processes such as imputed missing values, caped outliers, removed duplicated observations
- Provided quality assurance of imported data
- Supported initiatives for data integrity and normalization
- Processed confidential data and information according to guidelines e.g., on Forensic audits
- Prepared reports for executive leadership that effectively communicates trends, patterns, and predictions using relevant data
- Developed data analytics scripts using SQL and Python
- Presented data in the form of charts, graphs and tables for immediate reference
- Identified patterns and trends in data for audit engagements
- Performed audits on all data for the purpose of business development resolution
- Qualified all collected data before categorizing as useful information
- Used high visualisation tools like Power Bi and Tableau to report results
- Defined new data collection and analysis processes
Information Communications Technology Officer
Women and Law In Southern Africa - Zimbabwe
2015.03 - 2019.06
- Managed and maintained the NGO’s IT systems, including computers, networks, software, and internet connectivity
- Provided day-to-day technical support to staff (hardware, software, email, printers, and basic troubleshooting)
- Ensured data security, backups, and proper use of antivirus and cybersecurity practices
- Maintained databases, digital records, and cloud-based tools used for programs, finance, and reporting
- Supported and updated the NGO’s website, email systems, and basic digital communication tools
- Assisted in the procurement, setup, and inventory of IT equipment and software licenses
- Trained staff on basic IT usage, digital tools, and data protection best practices
- Liaised with external IT service providers and vendors when specialized support was required
Education
Master of Science - Data Analytics
Chinhoyi University of Technology
Zimbabwe 2018.01 - 2021.10
Bachelor of Science - Information Sytems
Women's University In Africa
Zimbabwe 2012.03 - 2015.10
Skills
- Strong experience of data visualization using Power BI
- Experience in data Extraction Transformation and Loading (ETL)
- Audit analytics
- Developing Machine learning models in Python and Microsoft Azure
- Data analytics using SQL
- Data analytics using T_SQL
- Azure Databricks
- Azure blob Storage explorer
- Azure storage explorer
- Python programming
- Leadership skills
- Sales analytics
- Advanced audit analytics for ERPs specifically SAP ,Oracle, Microsoft Navision, Microsoft Dyanamics/365, Business Central
- Creative problem solving
- Excel proficiency
- Data cleaning
Certification
Microsoft Certified Data Analyst Associate - Microsoft Issued Jun 2021
Certificate number - H872-3130
Timeline
Assistant Manager - Technology Risk Assurance
BDO LLP UK
2022.09 - Current
Data Analyst
Deloitte
2019.07 - 2022.08
Master of Science - Data Analytics
Chinhoyi University of Technology
2018.01 - 2021.10
Information Communications Technology Officer
Women and Law In Southern Africa - Zimbabwe
2015.03 - 2019.06
Bachelor of Science - Information Sytems
Women's University In Africa
2012.03 - 2015.10