Summary
Skills
Work History
Certification
Hobbies
Overview
SoftwareDeveloper
Martin Schoeman

Martin Schoeman

Johannesburg

Summary

Current Job Description:

Highly skilled professional with over 10 years of extensive experience in the fields of MI and BI. Proficient in developing and implementing innovative solutions for data collection, analysis, and reporting. Expert in utilizing data warehousing, data mining, and data visualization tools to transform complex data sets into meaningful insights. Proven track record of driving business growth and improving organizational performance by providing accurate and actionable information to stakeholders at all levels. Strong analytical skills and attention to detail with excellent problem-solving abilities. Effective communicator and collaborator, able to work collaboratively with cross-functional teams to achieve common goals.


Managing Others: Take responsibility for the effective management of others.

Business Management: To provide specialist advice and support in assisting to manage and deliver on business initiatives, ensure that timelines are met, manage the team in such a way that deadlines are met.

Dealing with Stakeholders: Taking responsibility for managing the expectations of stakeholders.

Skills

  • SQL Management & Visual Studio
  • Python
  • Qlik Sense
  • QlikView
  • Power BI
  • Microsoft Excel and VBA macros
  • Coupa Analytics & Reporting
  • Fiori - SAP S4 Hanna Reporting
  • SAP & SAP/BW
  • Jira
  • SharePoint
  • Data Literacy – Power Level

Work History

MI & BI Consultant

Absa
08.2013 - Current

Current Job Type : Permanent

Current Job Level: AVP - Permanent Assistant Vice President in the Banking sector Johannesburg, South Africa (Gauteng)

Current Remuneration: R 665 000.00

Medical Aid, Pension Fund, Profit Share

Highest Education: Junior Diploma: Bookkeeping


Competencies:

  • Excellent work ethic and precise attention to detail.
  • Analytical and logical personality type.
  • Time management skills with the ability to prioritize deliverables and manage stakeholder expectations, multitask, and perform well under pressure.
  • Ability to take initiative and to take ownership of projects.
  • Ability to work independently with minimal supervision.
  • Ability to communicate simply and effectively and work well in a team.
  • Ability to share ideas, listen and take on board others' ideas.
  • Adapting and responding to change.
  • Fast learner who takes pride in my work with willingness and desire to learn and grow.
  • Administration.
  • Customer Excellence.
  • Digital familiarity.
  • Enabling team success.
  • Leading People.
  • Openness to change.
  • Planning and organizing.


Knowledge & Skills:


  • Analysis & streamlining of existing MI processes.
  • Enhance existing reporting and provide new reporting to identify issues that may result in risks or operational incidents.
  • Transforming data into meaningful MI for analysis & effective decision making.
  • Identify new and utilize existing reporting tools to enhance and improve MI delivery.
  • Provisioning data to work towards end-to-end automated reporting.
  • Document process flows for alO MI processes.
  • Automation of processes that support BAU and reporting.
  • SQL & SSIS knowledge share, mentorship, collaboration & enhance teamwork.
  • Address ad hoc requests as required.
  • Develop monitoring solutions to identify gaps within existing reporting and data feeds.
  • Maintain data tables SQL environment, best practices, and standards to ensure new projects are built towards optimization, automation and user-friendly standards.
  • Be the single point of reference / provider for all stakeholder MI requirements.
  • Automation & Handover of all BAU run activities to the Run Team.
  • Deliver BAU within SLA.
  • Understand all MI requests communicated. Update Jira Kanban dashboard with all the tasks & requirements on a weekly basis to ensure the tasks are available for the weekly prioritisation sessions to be prioritised.
  • Be aware of and agree stakeholder priorities, communicate, and agree priority with the stakeholder to make sure that developers have capacity to deliver the solution according to the agreed time.
  • Proactive communication on progress and completion of MI requests.
  • Exco / Manco representation.
  • Prepare accurate and quality MI business performance packs.
  • Understand the link between business outputs and key performance drivers.
  • Utilise management information (MI) innovatively.
  • Analyse performance of the business and deliver only relevant information.
  • Compile monthly, weekly, and ad hoc reports as agreed with the stakeholder.
  • Ensure availability of information to support the business objectives & ensure delivery to the high standards expected from the business.
  • Provide MI for audit requests.
  • Communication and presentation skills.
  • Ability to deal with senior colleagues.
  • Develop and maintain the SBU MI plans.
  • Check all existing and new reports for accuracy and data integrity.
  • Provide guidance to the team on methods to achieve world class standards of efficiency and service, continually striving to enhance existing processes.
  • Support key initiatives and deliver results through an Agile workflow.
  • Establish working relationships with a variety of stakeholders.
  • Network internally and externally to better understand market trends.
  • Analytical, numerical skills and a keen eye for detail.
  • Planning and organisational skills.
  • Ability to understand broader business issues.
  • Invest time and effort in own development – through performance development process, training, networking, and seeking feedback.

Administrator (Management Reporting)

Finance at Absa Bank
10.2006 - 07.2013

Permanent Administrator Level Position in the Financial (Accounting) sector in Johannesburg, South Africa (Gauteng)


Knowledge & Skills:


  • Engage with critical business stakeholders and determine their requirements, how often they require it, and the relevance of the required information.
  • Review SBU requests for ad hoc and productionalised reports as well as pricing calculators.
  • Perform detailed calculations on profitability of cluster products, segments, and funds.
  • Prepare accurate and quality MI business performance packs.
  • Understand the link between business outputs and key performance drivers.
  • Consolidate completed submissions received from the business and communicate the consolidation.
  • Take ownership of the end-to-end delivery of the Revised Annual Forecast (RAF).
  • Engage with business partners to understand the drivers.
  • Ensure that the information that is needed for reporting Fiduciary's performance is reviewed.
  • Act as the entry point for all Medium-Term Planning (MTP) priorities, ensuring that all priorities are tracked and monitored monthly.
  • Guidance and provide specialist advice to the business if they are of target, guide Fiduciary business.
  • Communicate financial and non-financial product trend analysis in a timely manner.
  • Analyse performance results and interpret it against industry and competitor Performance and provide analysis to management.
  • Conceptualise solutions to drive the optimal development of the business.
  • Utilise management information (MI) innovatively.
  • Analyse performance of the business and deliver only relevant information.
  • Analyse and interpret financial information and forecasting as well as the measurement.
  • Monitor and review business performance.
  • Provide monthly financial or management reporting to Fiduciary Exco and assist with detailed context.
  • Monitor business performance and advise of deviations and recommend actions.
  • Compile monthly ad hoc financial reports as agreed with CFO.
  • Ensure availability of information to support the business objectives.
  • Develop and maintain the SBU MI plans.
  • Provide consultative advice to the Finance Executive on MI deployment or requirements.
  • Ensure that the design solutions on MI reporting support the business stakeholder's requirements.
  • Present key finding of information or reports produced to the Finance Executive and align them to integrated planning processes.
  • Establish working relationships with a variety of stakeholders.
  • Network internally and externally to better understand market trends.


Other duties included:


ABSA Consultants and Actuaries (ACA)

  • SAP statements – correct allocations.
  • Payments.
  • Petty cash.
  • Branch queries.
  • Month end processes.
  • Sap queries.
  • Customer Invoices.
  • Vendor Invoices.
  • Bank Recon – weekly.
  • Travel payments.
  • Follow up on outstanding recon items.


ABSA Healthcare Consultants (AHCC)

  • AHCC commission statements and the system update.
  • Recons.
  • Scorecard information.
  • Journal files + Book.
  • Splits on Corporate Cards.
  • Mandates.
  • Weekly Financial Review.
  • Commission Payments.
  • GL dumps AHCC.
  • Accrued Interest Journals.
  • Preparation (Balancing Report) + Regional Financial statements.
  • AFS Region Income statement (SAP) Month end balancing.
  • Preparing of Debtors & Creditors Recons.
  • Top ten Clients per Region sheet.
  • Rental journals.
  • Actuarial Debtors Invoicing and Journal.
  • Income – AMD (AHCC).
  • Month end Group Creditor Payment calculation + Transfer + Journals + Verification.

Certification

Damelin College: Junior Bookkeeping Diploma

Microsoft Excel 2007 Data Analysis

Microsoft Excel 2007 Advanced Formulas

QlikView

Qlik Sense

Querying Data with Transact-SQL

Implementing a Data Warehouse with Microsoft SQL

White Belt

Get Fluent in Technology



Hobbies

Gym

Mountain Biking

Specimen Carp Fishing

Crossbow Hunting

Overview

17
17
years of professional experience
1
1
Certificate
Martin Schoeman