Anthony Jantjes
MIS Analyst
Roodepoort
Summary
Detail-oriented and self-motivated MIS Analyst with a proven track record in claims administration, data analytics, and data visualization. Expertise in transforming complex data into actionable insights, leveraging advanced analytical tools to drive business growth and efficiency. Recognized for delivering high-quality service with a strong customer focus, maintaining confidentiality, and managing boundaries effectively. Quick learner thriving under pressure, adept at prioritizing multiple tasks while fostering team collaboration to achieve results in dynamic environments.
Overview
37
37
years of professional experience
Work History
Independent Contractor
Lion of Africa Insurance Company
01.2023 - Current
- Provided exceptional service to customers, fostering relationships to secure future business opportunities.
- Maintained comprehensive records of project progress, expenses, and communications to ensure accurate invoicing and facilitate future reference.
- Adapted quickly to changing demands or unforeseen challenges within a project''s scope without compromising results.
- Maintained detailed records of project progress, expenses, and communications for accurate invoicing and future reference.
- Provide functions and services as a business intelligence analyst on behalf of the
Company. - Perform detailed data reconciliation and completeness checks for any inconsistency with Financial Management accounts on the Gross and Reinsurer’s share of premium and claim reserves
- Update and provide automated weekly reports reflecting claim estimate movements to gauge run-off performance
- Update and provided automated quarterly Reinsurance Treaty account for various Proportional and Non-Proportional Treaties
- Produced and distributed ad hoc, daily, weekly and monthly claim experience and productivity reports, based on stakeholder requirements
Actuarial Support, BI Analyst
TAU Underwriting Managers, Sandton
01.2021 - 12.2023
- Designed and automated dashboard reports to give analytical and quantitative insights to business to make improved operational and strategic decisions, by using sustainable Business Intelligence tools
- Analyzed complex datasets from multiple sources to evaluate data quality, perform data validation to ensure data accuracy, consistency and integrity is met
- Apply dimensional data modeling methods to bridge gaps between multiple data sources, to perform high-level data reconciliations to ensure data accuracy and completeness
- Conducted detailed data reconciliation and completeness checks to identify inconsistencies in Financial Management accounts related to Gross and Reinsurer’s share of premium and claim reserves
- Developed and automated dashboard reports to provide analytical and quantitative insights for improved operational and strategic decisions using sustainable Business Intelligence tools
- Consolidated monthly reports to calculate a rolling 12-month period for financial analysis.
- Provide monthly Reinsurance premium and claims experience reports to enable Reinsurance Team to monitor the run-off exercise
- Update and provided automated quarterly Reinsurance Treaty account for various Proportional and Non-Proportional Treaties.
- Created and distributed ad hoc, daily, weekly, and monthly claim experience and productivity reports tailored to stakeholder requirements
- Prepare and provide monthly ManCo, as well as quarterly Board Actuarial report packs
Claims Technician, Actuarial Support, BI Analyst
Lion of Africa Insurance, Sandton
04.2011 - 06.2013
- Prepared and processed data accurately to input into loss development triangles for the purpose of calculating the Technical Reserves by line of business
- Performed data processing activities and analytics to create the input into solvency model under SAM
- Prepared and processed data accurately to input into data spec and populated disclosure sheets on both annual and quarterly Prudential Authority SAM returns templates
- Prepared and provided quarterly Reinsurance Treaty account for various Proportional and Non-Proportional Treaties.
- Prepared and processed data for loss development triangles, enabling calculation of Technical Reserves by line of business
- Transform and format data, to calculate the premium and provision reserves used in the risk capital charge model
- Created monthly Exco/Opsco and quarterly Board Actuarial report packs
- Analyzed complex datasets from multiple sources to evaluate data quality, perform data validation and ensure data accuracy, consistency and integrity is met
- Designed and automated dashboard reports to provide analytical insights for informed operational and strategic decision-making
- Proactively provided recommendations on functional system specifications and enhancements to improve reporting efficiencies
- Produced and distributed ad hoc and regular claim experience and productivity reports to meet stakeholder requirements
- Participated in cross functional meetings with multi-disciplined teams to understand business requirements and needs for Management Information reports
Team Leader – Commercial Claims
GlenRand MIB, Randburg
07.2005 - 03.2011
- Created and presented detailed claims analysis reports on Client’s Aggregate Fund usage that form a basis on Fund Analysis & Risk Management
- Effectively communicated and negotiated relevant claims with both internal and external stakeholders
- Received, evaluated, processed and settled claims in accordance with the applicable Claims Department Standard Operating Procedures (SOPs)
- Communicated and negotiated relevant claims with internal and external stakeholders to ensure alignment and resolution
- Monitoring of Supplier repair timelines, penalties and total losses
- Recommended outsourcing call centre system specifications and enhancements to streamline reporting processes
- Provided recommendations on Outsourcing Call Centre system specifications and enhancements to improve reporting efficiencies
- Managed administrative tasks performed within claims team environment
Short Term Insurance Broker, Senior Claims Negotiator
Marsh (Pty) Ltd, Sandton
08.2000 - 06.2005
- Developed and presented detailed monthly claims analysis report on client aggregate fund usage to inform strategic decisions
- Administered Client’s Aggregate Fund and monitored Outsourcing Recovery Specialist
- Provided weekly productivity reports to management
- Received, evaluated, processed and settled claims in accordance to the applicable Claims Department SOPs
- Negotiated relevant claims with internal and external stakeholders, ensuring alignment and clarity on claims processes
- Implemented cost containment measures identified in claims management strategy to optimize resource allocation
- Applied the fraud diagnostic tools in the administration of claims
- Contributed to claims projects by assisting with diverse ad hoc tasks
Fleet & Insurance Department, Team Leader
First National Bank, Johannesburg
07.1989 - 07.2000
- Assisted Fleet Manager in maintaining fleet vehicles, enhancing operational knowledge and reliability
- Documented and communicated all claim activity in a timely and effective manner, with both internal and external stakeholders
- Assisted with annual budgets, monthly account reconciliations & compiling of reports
- Cultivated professional relationships with team members to facilitate swift resolution of issues and conflicts
- Tracked and reported all claim activity promptly to internal and external stakeholders, ensuring clear communication
- Established open and professional relationships with team members which helped resolve issues and conflicts quickly
Education
Certification/Qualification - Analysing data with PowerBI
Torque IT
Johannesburg, South Africa01-2018
Certification/Qualification - MSCA Querying SQL Server
MultiMedia Centre
Johannesburg, South Africa01-2016
Certification/Qualification - Information and Data Modelling
Faculty Training Institute
Johannesburg, South Africa01-2014
Certification/Qualification - Analysing data with PowerPivot
Karabina Academy
Johannesburg, South Africa01-2014
FAIS II - Insurance And Risk Management
UNISA
Johannesburg, South Africa 04.2001 -
FAIS I - Insurance And Risk Management
UNISA
Johannesburg, South Africa01-2004
Short Term Insurance II - Insurance And Risk Management
IISA
Johannesburg, South Africa01-2004
Short Term Insurance I - Insurance And Risk Management
IISA
Johannesburg, South Africa01-1999
High School Diploma -
Coronationville Senior Secondary School
Johannesburg, South Africa 04.2001 -
Skills
Claims Administration
Excel analysis
SQL Server knowledge
Analytical thinking
Data-driven decision making
Claims management
Data visualization development
Reserving techniques
Reinsurance oversight
Data modeling
Timeline
Independent Contractor
Lion of Africa Insurance Company
01.2023 - Current
Actuarial Support, BI Analyst
TAU Underwriting Managers, Sandton
01.2021 - 12.2023
Claims Technician, Actuarial Support, BI Analyst
Lion of Africa Insurance, Sandton
04.2011 - 06.2013
Team Leader – Commercial Claims
GlenRand MIB, Randburg
07.2005 - 03.2011
FAIS II - Insurance And Risk Management
UNISA
04.2001 -
High School Diploma -
Coronationville Senior Secondary School
04.2001 -
Short Term Insurance Broker, Senior Claims Negotiator
Marsh (Pty) Ltd, Sandton
08.2000 - 06.2005
Fleet & Insurance Department, Team Leader
First National Bank, Johannesburg
07.1989 - 07.2000
Certification/Qualification - Analysing data with PowerBI
Torque IT
Certification/Qualification - MSCA Querying SQL Server
MultiMedia Centre
Certification/Qualification - Information and Data Modelling
Faculty Training Institute
Certification/Qualification - Analysing data with PowerPivot
Karabina Academy
FAIS I - Insurance And Risk Management
UNISA
Short Term Insurance II - Insurance And Risk Management
IISA
Short Term Insurance I - Insurance And Risk Management
IISA