Andy Plunket Email & Phone Number

Auckland, Nz

Auckland, New Zealand

Melbourne, Victoria, Australia

Auckland, New Zealand

- Managing ASB’s data insight and visualisation team of 11 people. The team and I produced insight to help explain ASB’s customers including segmentation and acquisition / defection using SQL, R and Python.- Working with senior leaders across the bank to prioritise insight work delivered by the team.- Lead strategy in the wider data analyst team on skills for the future to enable our cloud migration and having the right skillsets to allow the business to make informed decisions.-… Show more - Managing ASB’s data insight and visualisation team of 11 people. The team and I produced insight to help explain ASB’s customers including segmentation and acquisition / defection using SQL, R and Python.- Working with senior leaders across the bank to prioritise insight work delivered by the team.- Lead strategy in the wider data analyst team on skills for the future to enable our cloud migration and having the right skillsets to allow the business to make informed decisions.- Developed data visualisation style guidelines to provide consistency in how our analysts display the analysis they prepare for the business.- Developed process to enable analysts to use R in their roles and training the team on how to use it to produce more advanced analytics and machine learning.- Coaching and upskilling members of team in both technical and soft skills to enable them to progress their data careers. Show less

Auckland, New Zealand

- Developed customer facing data visualisation to allow our relationship managers to have better customer conversations. Initial proof of concept was built in R and then the full version was built in React / D3.- Leading investigations into Westpac's cloud analytics platform for data insights.- Created Westpac branded visualisation templates to enable our analysts to move from doing reporting in SAS to insights in R / Python within AWS.- Developed data visualisation style guidelines… Show more - Developed customer facing data visualisation to allow our relationship managers to have better customer conversations. Initial proof of concept was built in R and then the full version was built in React / D3.- Leading investigations into Westpac's cloud analytics platform for data insights.- Created Westpac branded visualisation templates to enable our analysts to move from doing reporting in SAS to insights in R / Python within AWS.- Developed data visualisation style guidelines for how analysts at Westpac design visualisations to show insights in a global best practice way. Show less

Auckland, New Zealand

- Responsible for managing analysts in the Business Experience Hub from a craft development point of view and expanded the analytics team in the Business Experience Hub from 6 to 11 staff over 18 months. - Produced insights on how Westpac’s business customers were impacted by COVID for the business as well as well delivering information to RBNZ and government agencies under tight timeframes. Received great feedback from senior management about impact of this work and my insights were sent… Show more - Responsible for managing analysts in the Business Experience Hub from a craft development point of view and expanded the analytics team in the Business Experience Hub from 6 to 11 staff over 18 months. - Produced insights on how Westpac’s business customers were impacted by COVID for the business as well as well delivering information to RBNZ and government agencies under tight timeframes. Received great feedback from senior management about impact of this work and my insights were sent to the Westpac NZ board on a weekly basis.- Developed a pattern for how analysts can use R Markdown (and R / Python code) to share insights similar to data journalism including creating a R package to automatically format everything in Westpac brand.- Helped run regular chapter area development sessions to upskill analysts in R / Python.- Providing reporting and insights for the business lending product portfolio.- Managed the chapter through the uncertainty of the COVID lockdowns and first time working from home for some of team. Show less

Auckland, New Zealand

- Managing the relationship between the Business Lending / Merchant Acquiring Products teams and Analytics.- Provided analysis to prove the value of accepting contactless payments for the banks merchant customers using transactional data on new Databricks platform (Spark) using Python and SQL.- Replaced all excel based reports with automated Power BI dashboards for both Business Lending and Merchant Acquiring.- Improved the merchant acquiring profitability model to allow the… Show more - Managing the relationship between the Business Lending / Merchant Acquiring Products teams and Analytics.- Provided analysis to prove the value of accepting contactless payments for the banks merchant customers using transactional data on new Databricks platform (Spark) using Python and SQL.- Replaced all excel based reports with automated Power BI dashboards for both Business Lending and Merchant Acquiring.- Improved the merchant acquiring profitability model to allow the business to see a more accurate representation of a merchant customer’s profitability. - Within 6 months of starting the role I was awarded a Quarterly Legend Award for managing a change to the system that rolled the interest rates on short term Business Lending. This change allowed the bank to automatically change the base rates on loans on the interest rate roll date rather than having to manually change all the loans individually. Show less

London, United Kingdom

- Developed new global corporate sales regional and sector based reporting combining financial performance and pipeline data.- Developed a database to show how deals have moved through the pipeline over time. This has provided the team with the ability to do analysis of how deals are trending through the pipeline which was previously not available.- Producing individual monthly financial performance scorecards for all sales managers in GLCM globally.- Improved the process around… Show more - Developed new global corporate sales regional and sector based reporting combining financial performance and pipeline data.- Developed a database to show how deals have moved through the pipeline over time. This has provided the team with the ability to do analysis of how deals are trending through the pipeline which was previously not available.- Producing individual monthly financial performance scorecards for all sales managers in GLCM globally.- Improved the process around producing the individual financial scorecards to significantly reduce the time taken to produce the scorecards each month for the sales managers and increase the accuracy of the reports.- Further automated the regular monthly pipeline reporting through Excel, VBA and SQL (COGNOS Report Studio). This increased the accuracy and the speed at which we were able to produce the monthly pipeline reporting for senior management within GLCM. Show less

Auckland, New Zealand

- Produced insights around payment cycles for the dairy industry, the major industry for Agri customers in New Zealand, and the education industry. These were used to improve forecasting of movements in ANZ’s balance sheet after receiving these payments.- Developed a new tool that produced customer summaries for frontline staff to take on customer visits for both lending and transactional banking by automatically pulling information from the bank’s SQL databases. These tools saved the… Show more - Produced insights around payment cycles for the dairy industry, the major industry for Agri customers in New Zealand, and the education industry. These were used to improve forecasting of movements in ANZ’s balance sheet after receiving these payments.- Developed a new tool that produced customer summaries for frontline staff to take on customer visits for both lending and transactional banking by automatically pulling information from the bank’s SQL databases. These tools saved the frontline staff significant time as they previously had to manually create a summary from information in the core banking systems while also making the summaries far more professional looking.- Provided SQL and SAS training for the analysts within the New Zealand Products team.- Developed performance reporting for the Commercial, Agri and Business Banking Products team to help the team to better manage the suite of products. - Selected for a secondment to help the Corporate and Commercial Sales Execution team in ANZ Australia create new frontline performance dashboards using SQL and SSRS. The secondment lasted four weeks in Melbourne, Australia.- Successfully designed, developed and implemented a new pricing tool for the Commercial & Agri division. The new pricing tool was very well received and significantly decreased the time for frontline staff to price customers while making the important information around margins and revenue clearer. This work won an award from the Commercial & Agri leadership team. Show less

Hamilton, New Zealand

Auckland, New Zealand

- Developed individual dashboards for all frontline relationship staff and created a system for automatically creating each managers dashboard using VBA and Excel. This allowed the staff to how they were tracking to their KPI targets without having to look at a number of different reports.- Developed financial league tables for the Commercial & Agri leadership team to allow them to compare their direct reports regions and the relationship staff in their regions.- In 2012 I won a Stand… Show more - Developed individual dashboards for all frontline relationship staff and created a system for automatically creating each managers dashboard using VBA and Excel. This allowed the staff to how they were tracking to their KPI targets without having to look at a number of different reports.- Developed financial league tables for the Commercial & Agri leadership team to allow them to compare their direct reports regions and the relationship staff in their regions.- In 2012 I won a Stand Out award from the New Zealand Commercial & Agri division (top 12 performers in the Commercial & Agri) and was a runner up in the global ANZ Finance Stand Out awards (top eight in the Finance division globally and the top performer from New Zealand Finance).- Automated a large proportion of the scheduled monthly and weekly reports using a combination of VBA, SQL and SAS to allow more time to do ad hoc analysis.- Preparation and reporting of various sales pipeline data across the Commercial & Agri division. Show less

Tauranga, New Zealand