Charles Caddy Email & Phone Number

Responsible for reporting, analytics and insights within Lending Services and the workflow of the fulfilment process of business and home lending:● Python and SAS to automate and improve report delivery reliability including introduction of quality checks and controls● Oracle SQL coding used as part of the ETL process to transform data into use case tables for both Tableau and Power BI● Reviewing and understanding data to provide insights on process including reviewing of volumes, timing and quality of tasks● Documentation and collaboration using Confluence and making use of GitHub for version control of all BAU scripts● Managed workflow, prioritisation and time management in an Agile environment using tools such as JIRA and Rally

Administering performance reporting and incentive schemes across ~6,000 employees and five schemes within Consumer & Wealth including:● Solutions development using tools such as Pentaho Kettle, Oracle SQL, Tableau, Excel and Access (including VBA): > ETL process for monthly performance reporting > Identifying, reviewing and correction of data quality issues > Pro-active identification of risks and development of risk management reporting > Modelling and analysis of current and proposed changes to schemes● Process documentation (technical & user), process mapping and decision trees● Identification and implementation of process improvements

Administering performance reporting and incentive schemes across ~6,500 employees and six schemes within Personal Bank including:● Reporting and providing insight at various levels: > Board Remuneration Committee half yearly scheme payment information > State and Business Unit summaries > Ad-hoc reporting for strategy and project teams > Branch/Area and Banker weekly reporting of product sales● Developing solutions using SQL (Oracle), Tableau, Excel and Access (including VBA): > Identifying data quality issues > Pro-active identification of risks > Modelling and analysis of current and proposed changes to schemes● Process documentation (technical & user), process mapping and decision trees● Identification and implementation of process improvements● Internal communications including intranet, e-mail, education packs and face-to-face training

Monthly and ad-hoc forecasting of resource requirements across ~750 retail branches including:● Solution development in Microsoft Excel, Access and Visual Studio (Visual Basic deployed to PDA devices)● Project Management of time and data collection studies across multiple branch types● Review of manually collected data within Minitab and Excel to determine forecasting variables● Auditing of Global Data Warehouse transaction and sales data using SQL (Oracle and SQL Server)● Creation of scenario models to report on resource saving expectations from internal project team proposals and alignment to Finance expectations

● Providing high quality customer experience, efficient processing of transactions and identification of customer needs and referral opportunities● Early stage complaint resolution and providing first point resolution● Adhering to internal operating policies and procedures as well as compliance standards

Bachelor Of Science (Bsc), Operations Research

● Stochastic modelling and simulation ● Optimisation problems: linear and dynamic programming ● Neural network and shortest path analysis.

Certificate Iii, Information Technology

● Database design and development ● Programming (C, Python, Visual Basic, Visual Studio) and Web (HTML, CSS) development ● Applications.