Senior Financial Systems Analyst

• Feb 2022 - Present

Financial Systems Analyst

• May 2018 - Mar 2022

Working as a systems administrator for the company's TechnologyOne platform, and contributing as a systems accountant to internal projects. Including -- Development of BI reporting and analytics with MSSQL- Developing automations, ETLs, and third party software integrations- RPA development using UIPath

Web Developer (Contract)

• Jan 2018 - Apr 2018

Web development work on the client results portal for this nationwide business supplying sports results for clubs and major sporting events across NZ. Web development work on the client results portal for this nationwide business supplying sports results for clubs and major sporting events across NZ.

Web Developer - Student

• Aug 2017 - Dec 2017

Graduated as a full-stack Web Developer. Highlights included - • Attended Wellington 2017 PacHack and developed a financial concept app for Auckland media freelance company 'No-Six', which was presented and received positively by MBIE. • Delivering a team graduation project that used Google speech-to-text technology & Youtube APIs • Experience building with JavaScript, React / Redux, Webpack, Node.js, Ruby on Rails, Webpacker, Vue.js, PHP, SQL, APIs, HTML, CSS, Github, Docker, Heroku deployment, and Now.sh • Exposure to Agile practices (eg standups, retrospectives, ticketing) • Design by wireframing and CSS frameworks such as Material Design Bootstrap 4, Bulma, Flexbox • Test-driven-development, object-oriented and functional programming Visit current projects at - https://github.com/richardjohns Show less

Business Analyst

• May 2014 - Sep 2017

Served as a financial consultant, partnering with senior managers within the Property, Building Resilience, and Strategic Asset Management business units. My role was to oversee and drive key financial processes for the business units including monthly reporting, annual budgeting, forecasting, and performance reporting. Highlights included - * advising on opex budgets (including investment property lease income of approx $12m/yr), and a combined capex programme of $12m/yr, and * delivered budgeting and the year-end accrual for the $20m/yr Council-wide facilities maintenance contract. In the role I provided financial advice that enabled business units to fulfil their annual plan strategies, including - * Delivering advice, performing due diligence, and confirming funding for the $14m St James Theatre earthquake strengthening programme. * Co-leading a key project to confirm the financial impact of a proposal to renegotiate Council’s facilities maintenance contract. Also my focus was to take initiative and drive through financial & business improvement projects such as - * Assisting with the development of a new business planning methodology used across Council's operating group, integrating learnings from Simon Sinek’s ‘Start with Why’. The project team received the CFO’s 2015 team innovation award. * Developing new financial processes to enable each business unit to transition from Oracle Peoplesoft over to the new TechnologyOne 'One Council' software platform. Show less

Consultant

• Jun 2012 - Apr 2014

The Whyte Group is a leading independent Tax and Corporate Advisory practice focused on providing expert advice to some of New Zealand’s most successful entrepreneurs. In this role I worked with high net-worth individuals to help them achieve their wealth goals, including: * Off-shore equity restructuring * investment portfolio compliance or analysis, * tax advisory (domestic & international) * Preparation of financial statements & tax returns for complex entities based on well-considered tax positions. Show less