John Ross Email & Phone Number

Auckland, New Zealand

Auckland, New Zealand

Amsterdam Area, Netherlands

Designing and implementing PowerBI dashboards (management information reporting) for Risk and Compliance. KYC centre of expertise; FATCA/CRS.

Amsterdam Area, Netherlands

Data analyst and BI specialist linking business with technology. Expertise in Excel (macros), PowerBI, SQL and working knowledge of Qlikview/Qliksense and Python.

Amsterdam Area, Netherlands

• Project: Various Deloitte internal projects, in parallel to other projects.
• Reporting key insights (with commentary) to the core management team for their FY19 priorities.
• Facilitated Artificial Intelligence (AI) workshop/learning event.
• Created and facilitated Blockchain workshop to create a distributed app (dapp) on Ethereum.
• Created a multi-player stock trading game using Python and Django for a learning event.
• Internal expert in Excel (know most formulas, can create own VBA scripts etc.) - automated three internal processes e.g. reduced processing time from 4 hours to 30 minutes.Project: Data analyst for Solvency Capital.

Amsterdam Area, Netherlands

• Lead analyst for Trade Flow project module at a Dutch asset management company. Project planning, requirements gathering, short-listing order management systems, advising on target operating model and presenting.
• Implementation support (Agile). Testing, documentation and iteration on requirements and process changes.
• Created and implemented Excel VBA tools to automate imports by converting to XML.

Perth, Australia

• Developed Toyota Auto Parts’ analytics to gain insights from sales data. Segmented sales by category and built a forecasting model taking seasonality into account. Used to track business’ progress towards targets.
• Built capability for 27 dealers in Western Australia to visualise and compare performance against targets and benchmarks; analysed retail vs. commercial sales, costs, mark-up % and inventory management. Highlighted.

Auckland, New Zealand

• Created dashboards constituting insights and suggestions for retirement savings products and presented key figures and trends (e.g. FUM share of growth, competitor analysis etc.) to senior management.
• Substantially improved visibility of product performance and its drivers by gathering information/data across departmental silos and using activity based costing to present product profitability to management. Outcomes.
• Calculated and highlighted opportunity to cross-sell banking products to 40% of retirement product customers. Insights used to launch advertising campaign.Skills: advanced Excel, SQL, P&L, ABC, data visualisation.

Auckland, New Zealand

• Managed timely and accurate delivery of correspondence to bank's 1.5 million customers; working with mail house and ensuring cooperation of several departments.

Auckland, New Zealand

• Led a team of 9 engaged staff.
• Increased customer satisfaction (faster and more accurate service) through clearing a backlog of 2000 inter-bank superannuation transfers by focusing on job-design – matching skillsets to job tasks.
• Improved staff engagement by creating an incentive system (called Ross Points) to determine performance by allocating points to each task and coupling it to goals, rewards and feedback.Skills: leadership, resource.

Auckland, New Zealand

Pretoria Area, South Africa

• Implemented financial reporting used to drive business decisions.
• Expanded revenue by 30% by selling to a different market segment (fresh vs. frozen chicken). Skills: strategy, procurement, sales, corporate finance

Master Of Business Administration (Mba), Business Administration And Management, General, Top 10% Of Class

Activities and Societies: Consulting club, Australia and New Zealand club, Rugby club

Postgraduate Diploma, Business Administration, A-

Bachelor Of Commerce, Entrepreneurship/ Business Management