Lawrence Sher Email & Phone Number

Johannesburg, Gp, Za

• Reporting Specialist for ABSA on in the group risk area in Tableau, Hadoop and CCRS feeding off SQL Server• Consult to Discovery for an independent review to ensure all processes have been completed regarding implementation and corrective action for data investigation. • Audit Manager for ABSA data engineering on Teradata and Hadoop consolidation in Spyder• Consult to MTN and Climate Fund Managers on IFRS 16 lease reporting efficiencies• Consult to Standard Bank on cost specialist recovery optimisations:o Build costing models with data driven estimations o Analyse changes in process to calculate effects on overall costs

Johannesburg, Gauteng, South Africa

• Identify gaps and opportunities in the South African Market using Capital IQ• Do deep dive analysis for duel listed stocks through Salesforce• Build a Power BI dashboard tracking all listed funds for future strategies• Create graphical representation of data for decision making purposes• Consolidate data into Excel for strategic business overview

Johannesburg, Gauteng, South Africa

• Update Sales dashboard using queries for Avroy Shlain (Subsidiary of Tupperware Brands Group Jan20-Mar20) and provide reporting commentary.• Built a dashboard for Marsh African business with visualizations using advanced Excel functions (Apr20)• Designed a tracking tool for Riskonet allowing business to maximize efficiency with resources. (Apr20)

Johannesburg Area, South Africa

• Develop innovative modelling techniques for complex problems.• Use Qlik Sense daily for dashboard visualizations, commercial presentations and business analytical requests to find ways to understand complex data.• Assist Europe with budgets and reporting performance. • Produce clear, considered and insightful analytical reports for presentation to Regional and Commercial managers across Europe, Middle East, Africa and South Asia. • Creation, analysis of monthly revenue performance reports to Qantas appointed General Sales Agents (GSAs).• Review existing processes, performance of business segments to determine the impact on Qantas revenue streams and pricing.• Assist with incentive performance targets and agreements across regions. • Test and find solutions to new software implementation for Africa and the Middle East.• Review and approve Middle East reporting requirements.• Reporting alignment, strategizing of Middle East, Africa South Asia and Europe. Investigation and resolution within Qantas revenue reporting systems.

Johannesburg Area, South Africa

•Built a model which generates forecasts through weightings into a daily sales and margin deconstruction.•Created a template which is used for budgeting•Forecasted and balance regions in Africa using different currencies on a monthly basis.•Designed a weather vs sales trend analysis model.•Built a dashboard analysing time vs margin and sales using SAP BI.

Johannesburg Area, South Africa

•Set up a workbook in Excel to calculate foreign dividends, interest, capital gains or losses, foreign withholding taxes, fees, charges, portfolio values, cash balances and liabilities of all accounts till the 28th of February 2014.•Analysing the accounts and report findings to the CEO.

Johannesburg Area, South Africa

• Extract and clean data from financial statements using filters, then take the data and put it into a model which I have built.• Data capturing knowledge, insight into financial statements.• Determine risk through calculating and analysing industry averages.• Use Pivot tables and Pivot charts to separate the current, acid and gearing ratios which I integrate sections into reports I have drawn up.• Calculate the Risk Bearing Capacity (RBC) and the Catastrophic Risk Bearing Capacity (CatRBC) for listed JSE companies.• Phone banks to get analyst forecasts to ensure the model is up to date. • Email board members of various companies to publicise my findings.• Analyse claims and use tools to make the data understandable.• Calculate the mean foreign exchange rates and extract market indicators.• Build an invoicing model taking into account the budgeted vs actual.• Calculate the DFA (Dynamic Financial Analysis) and draw up reports.• Work with Marsh department directors on phases of the project.