Summary
Overview
Work History
Education
Skills
Accomplishments
LANGUAGES
References
Certification
Work Availability
Timeline
Generic
Francis Sumbulero

Francis Sumbulero

Blantyre

Summary

I am a seasoned Data Analyst with over five years of experience, specializing in supporting regional audit teams through the adept extraction, manipulation, and integration of client data into Deloitte's advanced analytics platform. My expertise encompasses managing intricate data sets from various accounting systems and performing thorough financial analyses for a wide range of clients, including high-profile multinational companies. I am passionate about applying my knowledge and skills to improve the audit process's quality and efficiency, contributing to the success of Deloitte and its valued clients. My professional journey is characterized by proactive involvement, adaptability, technical proficiency, meticulous attention to detail, and strong leadership qualities. I am committed to further refining my data analytics expertise and aspiring to reach new professional heights in this ever-evolving field.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Senior Data Analytics Consultant

Deloitte
04.2019 - Current
  • Engineered an algorithm that significantly reduced revenue leakage in banking and telecom systems, achieving a near-complete minimization of revenue loss for clients.
  • Automated routine audit processes using UiPath, enhancing operational efficiency and accuracy.
  • Led and mentored a team of seven junior data analysts, fostering their professional growth and contributing to successful audit projects.
  • Conducted in-depth data analysis on new products and services, providing key insights to inform strategies across various departments.
  • Established and maintained a data and reporting infrastructure using Microsoft Power BI and SQL, enabling real-time business intelligence on key performance indicators and marketing effectiveness.
  • Played a pivotal role as the inaugural data specialist in developing SQL scripts for the revenue assurance process, directly supporting clients in the banking and telecommunications sectors.
  • Applied advanced data analytics techniques to audit support, identifying high-risk areas and significantly improving audit accuracy and reliability.
  • Oversaw the training and professional development of junior analysts, building a highly effective analytics team.
  • Monitored performance metrics diligently to identify and capitalize on opportunities for process improvements.
  • Kept up-to-date with industry trends and advancements in data analytics and big data technologies, ensuring the adoption of best practices.
  • Presented comprehensive findings and strategic recommendations to senior management and stakeholders, influencing key business decisions.
  • Worked closely with IT to ensure data integrity and the seamless operation of data analytics tools and systems.
  • Designed and implemented robust data analytics frameworks, supporting and enhancing business decision-making processes.
  • Led cross-functional teams in analyzing complex datasets, delivering actionable insights that drove business initiatives.

Junior Business Analyst

NICO Insurance Company
04.2016 - 02.2019
  • Assisted in the development and preparation of client presentations, ensuring clear communication and professional delivery.
  • Participated actively in client meetings, contributing valuable insights and suggestions to discussions.
  • Managed the cleaning and consolidation of pension remittance data, supporting the accuracy and efficiency of the actuarial review process.

Education

BSc. - Mathematical Sciences

University of Malawi - The Polytechnic
Blantyre,Malawi
01.2015

Skills

  • Information systems assessment
  • Revenue optimization
  • Alteryx visualization solutions
  • Pandas data manipulation
  • Proficient in Microsoft SQL Server
  • Expertise in Microsoft Power BI
  • Reconciliation of general ledgers
  • Data interpretation skills
  • Experience with Audit Command Language
  • Workflow automation in ETL using Apache Airflow and SSIS
  • Advanced Excel modeling
  • Proficient in automating processes

Accomplishments

    RPA-Process Automation using Uipath-Beginner to Expert

LANGUAGES

English

References

  • Carol, Nyirenda, Senior Manager-Audit and Assurance, cnyirenda@deloitte.co.mw, +265999876356, Deloitte
  • Boniface Matola,Senior Examiner,bmatola@rbm.mw,+265885614651,Reserve Bank of Malawi,
  • Gerald Kalampa, Manager-Audit and Assurance,gkalampa@deloitte.co.mw,+265999640828, Deloitte

Certification

  • Microsoft Power BI Data Associate
  • RPA-Process Automation using Uipath-Beginner to Expert
  • ACL for Audit, Data analysis and Visualization
  • Alteryx Bootcamp
  • The Advanced SQL Server Masterclass for Data Analysis
  • Data Analysis with Pandas and Python

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Senior Data Analytics Consultant

Deloitte
04.2019 - Current

Junior Business Analyst

NICO Insurance Company
04.2016 - 02.2019

BSc. - Mathematical Sciences

University of Malawi - The Polytechnic
Francis Sumbulero