Neo Makopo

• Enjoy using data to gain an in-depth understanding of business objectives, the development of solutions to translate new business acquiring, to strategic objectives (This starts with setting risk appetite and stretches all the way to setting limits that we should offer at a competitive interest rate.)
• Manage Bad Debt and Losses – contribute to the management of bad debt and losses on the VW portfolio through:

a) Credit Appetite monitoring.
b) Monthly Portfolio Monitoring pack
c) Ad hoc deep dives unpacks.
d) Risk Strategy initiatives.

• Manage book growth for VW portfolio:

a) Identifying Growth Strategy Initiatives
b) Better understanding and interaction with Pricing
c) Policy Review (E.g. LTV, Balloon etc)
d) Present and motivate proposed ideas
e) Credit Appetite Reviews – VW
Statements
Prudential limits adjustment.

• Conceptualization, planning and execution of strategy implementation projects:

a) SAS Code simplification and maintenance

b) Maintain reporting or PowerBI tool

• Change management process:

a) DEV testing, User Acceptance Testing

b) Maintain Scorecard Specification document

• Coaching, mentoring and development of junior data scientists on SAS and data mining techniques.
• Involvement in Credit portfolio management presentations where required.
• Discovering stories told by data to present information to scientists and business managers.
• Creating scenario testing models to stress test identified growth opportunities.
• Utilise advanced querying, visualisation and analytics tools to analyse and process complex data sets.

I thoroughly enjoyed finding solutions to new challenges.

• Used SQL to join tables to centralise credit card fee reversal data which is used to track goodwill for Credit Card Division.
• Ran daily queries that consolidate closing accounts, limit increase accounts and new accounts to prepare for our NPS measurement using Python for automation.
• Analysed NPS data from our campaigns to measure client satisfaction with the Transactional and Credit Card Accounts.
• Created insightful NPS monthly reports using Power BI for data visualisation.
• Urgently Prepared and sourced SMS campaign data and using this to send SMSs to clients for fixing any fee related issues within CPT where necessary.
• Maintained Safe Custody database data by updating the master table and the Power BI report.
• Provided support to the compliance team for SARB audits, CTR reporting and compliance investigations.
• Served the Customer Management team with any data related requests as and when required.

I took pride in providing structure and figuring out efficient ways of executing tasks.

• Introduced a tick box form and process that reduced the number of irrelevant CIS queries coming through to Credit Card.
• Successfully formed relationships with the RRB Data Management Organization and facilitated some collaboration between Card departments to ensure that Data Governance is implemented within Card.
• Continuously trained the CIS Helpdesk about the Credit Card Construct to reduce CIS errors and CIS orphans.
• I provided reports and insights for Card911 escalated queries to highlight trends.
• Used data to provide continuous insights and research for the CPT Client Experience Team on pressing Credit Card escalations.
• Ensured data quality standards are met for Group Risk AML, CFT & SANCTIONS MONITORING
• Participated in Customer Experience Forums and data teams within the bank for collaboration.
• Executed Card strategy and business processes required to create, maintain, and enhance Nedbank Card's data.
• Cleaned data, created and enhanced existing data definitions and created process documentation.
• Continuously tested card data to ensure that it complies with SARS requirements for IT3B Statements submission.
  

I worked hard to be at my best for the people I worked with and served. I helped those I worked with succeed, and I helped

the people I served go home happy.

• Collected insurance and investment product sales data from a database using SQL and exporting this to a usable csv format.
• Applied business rules to the data in order to analyse the data at hand correctly.
• Imported csv files into either excel or QlikView to analyse sales trends for the Momentum Distribution Sales Channels and Broker Force.
• Compiled insightful reports by applying numerical and statistical analysis.
• Generated ad-hoc reports as the business required by understanding the client's requirements.
• Supported ongoing Actuarial Research by developing methodologies such as Seasonality Investigation to analyse and interpret data.
• Optimised current reports where possible and automated multiple reports using Excel VBA.
• Improved decision-making processes with accurate data analysis and visualization techniques.

I showed up everyday to make a positive difference in the lives of others. I was able to bring important issues to light and spark

staff involvement around those issues.

• Developed a simple VBA model that improves the speed at which Claims experience analysis was done as part of pricing funeral cover schemes.
• Assisted with Statutory reporting and product development initiatives.
• Initiated Product Training Tuesdays for Sales Reps and Staff so that they could understand products and give better client experience.
• Assisted with methodologies for pricing funeral cover for corporate schemes and individuals.
• Generated quotes on Improved policy benefits; continuously evaluated claims ratios and the profitability of SAFRICAN Schemes.

I was able to assist the Sales Team meet some of their sales targets and got a real kick with making their jobs easier by giving data driven insights on where the casinos are spending money (acquiring new gambling machines).

• Administration, mining and capturing of casino customer data onto a central database using SAS and Microsoft Access.
• Using SQL queries to extract data from the Microsoft Access database to create reports which will then be used internally by both Marketing and Sales as well as externally by customers.
• Compiling periodic reports (using SAS and excel) for local and global use i.e. Regional performance data, international performance data, market share as well as other ad hoc reports.
• Producing ongoing competitor analysis reports of the Gaming Industry to provide insights for the Sales and Marketing Team.
• Liaising with other departments within the company to ensure that any product related decisions are based on statistical analysis.
• Researching new innovative ways, the Sales and Marketing Team can continue to increase market share in the Gaming Industry.
• Adhering to a strict time schedule in terms of report output.
• Providing ongoing support to Sales and Marketing by assisting with Ad Hoc queries when required.
• Utilised advanced statistical techniques to uncover hidden trends in complex marketing datasets.

I thoroughly enjoyed interacting with multiple teams, growing and understanding different people so I can effectively communicate with non technical staff .

• Participated as part of the Product Development team innovating products for Momentum Investments.
• Provided ongoing support to Business Analysts about new product innovations for them to create new system requirements.
• Provided support to the Service Area, Marketing and Compliance by assisting with queries when required.
• Liaising and managing expectations with Marketing Advisors and Brokers concerning making exceptions for below minimum investments and then making decisions for accepting below minimum investment amounts to Momentum Investments accordingly where possible.
• Making decisions for the types of funds to be added to Momentum Platform and liaising with Management and Marketing Advisors.
• Regularly liaising with the Marketing Team compiling research and doing competitor analysis in order to keep improving Momentum Products.
• MIS/Data Analyst role preparing ad hoc/daily/weekly/monthly reports for the Momentum Wealth Management team to assist in making business decisions.
• Ad hoc Data extraction from Oracle using SQL coding for other departments.
• Data manipulation in excel using basic excel coding.
• Analysis of data and PowerPoint presentations of findings.
• Doing ad hoc Presentation of Findings when necessary.

I was grateful to learn where Actuaries fit in the Life Insurance Industry. I developed excel skills and practical methods for understanding data, testing for accuracy and interpreting information.

• Calculating surrender, maturity and death claim values for clients.
• Calculation illustrative surrender, maturity, death, paid up values for clients.
• Servicing clients via telephone when necessary.
• Doing data audit and analysis making necessary alterations to ensure allocation of units to different portfolios are correct.
• Using excel for all functions.
• Calculating values to be reversed for incorrect paid-up charges made to the client.
• Calculating the reduction in premium for all the Liberty Life policies that were in force between 01/01/2001 to 31/07/2007 using excel.
• Calculating withdrawal charges that were supposed to be made to clients in order to be compliant with the Statement of Intent from the LOA (Association of Life Long-term Insurers).