Experience

Chandoo.org

• New Zealand
• E-Learning Providers
• 1 - 100 Employee

• Chief Excel Officer

  • Jul 2004 - Present

  Wellington, Wellington Region, New Zealand At Chandoo.org, I help people to be awesome in Excel and Power BI. Don't take my word, just go to https://chandoo.org/wp/ and see it yourself.



Microsoft

• United States
• Software Development
• 700 & Above Employee

• Microsoft MVP

  • 2009 - Present

  Shared my Excel knowledge with thousands of users around the world.



Te Kawa Mataaho Public Service Commission

• New Zealand
• Government Administration
• 100 - 200 Employee

• Data Lead - Remuneration Modeling & Analytics

  • Aug 2022 - Jun 2023

  Wellington, Wellington Region, New Zealand Lead the data analytics side of Clerical & Admin Pay Equity claim spanning 40+ government agencies impacting 16,000+ claimants. ◉ Built data flows & pipelines to seamlessly collect, manage & store data submissions from 40+ sources ◉ Created remuneration analysis & undervaluation cost models using Power Pivot, Power Query & Microsoft Excel ◉ Set up processes & automations for various stages of claim - data collection, role mapping, contact list updations & cost modeling



Ministry of Business, Innovation and Employment

• Government Administration
• 700 & Above Employee

• Remuneration Analyst & Modeler

  • Oct 2018 - Aug 2022

  Wellington & Wairarapa, New Zealand I create costing models, automation and reporting systems for new Remuneration framework to be implemented at the ministry.



The Treasury - New Zealand

• New Zealand
• Government Administration
• 400 - 500 Employee

• Senior HR Reporting Analyst

  • Sep 2020 - May 2021

  Wellington Region, New Zealand Revamp existing reporting processes using Power Query and Excel. Develop best practice for working with data from Tech1 systems. Build dashboards to monitor Gender Pay Gap, HR metrics and Annual Rem Review. Use Power BI to derive insights from People & well-being data.



H2R Consulting

• New Zealand
• Human Resources Services
• 1 - 100 Employee

• Reporting Analyst

  • Nov 2016 - May 2021

  Wellington & Wairarapa, New Zealand



Tata Consultancy Services

• India
• IT Services and IT Consulting
• 700 & Above Employee

• Business Analyst

  • May 2006 - Apr 2010

  I help insurance companies around the world become more successful in their IT projects. I have worked with 10 Fortune 500 clients and another 10 International insurance companies in the last 3.5 years and helped them design better claim processing, underwriting, policy admin systems. I have extensive work experience in US, Europe and APAC insurance markets. I have consulted in South Korea, Hong Kong, Ireland, Sweden, Denmark, US and India since 2006.



Glenmark Pharmaceuticals

• India
• Pharmaceutical Manufacturing
• 700 & Above Employee

• Marketing Intern

  • Apr 2005 - Jun 2005

  As a marketing intern with Glenmark Pharma I have prepared an operational CRM framework for their dermatology division.



Xinthe Technologies

• India
• Information Technology & Services
• 1 - 100 Employee

• Software Engineer

  • May 2003 - Jun 2004

  As a software engineer at Xinthe technologies (http://xinthe.com) I have developed a Sales Force Automation application for Reebok International. It was deployed in Reebok France.