Katherine W.

Katherine W. Email and Phone Number

Data and Reporting Analyst | Business Intelligence @ Constellation Brands New Zealand & Australia
auckland, auckland, new zealand
Katherine W.'s Location
Auckland, Auckland, New Zealand, New Zealand
About Katherine W.

As a highly motivated and results-driven data analyst with 2 years of BI-developing experience, I possess a blend of hands-on data analytics skills such as data mining, data wrangling, visualisation, statistical modelling, and programming languages. Proficient in identifying valuable patterns and trends to drive data-driven decision-making and operational efficiency. Skilled in data mining, integration, visualization, statistical modelling, and delivering insight BI reports. Experience using SSMS, SSIS, SSRS, Snowflake, advanced Excel (with MOS certificates), Power BI, Tableau, Python, R Studio, Mango DB, SPSS, API scraping and Microsoft 365.My academic journey is at a top-tier university, where I achieved high academic accolades, laid the foundation for my analytical skills and instilled in me a deep understanding of the financial sector. My career journey has been marked by a diverse career path, working across multiple industries and roles, enriching my analytical capabilities and sharpening my ability to communicate complex data-driven insights in a clear and impactful manner to stakeholders at all levels. This distinct combination of varied experiences and a deep enthusiasm for data positions me to contribute valuable analytics insights to a dynamic team, achieving significant results through insightful analysis and clear communication. I have a strong interest and passion in big data mining, data analysis, visualization, and storytelling. I continually develop technical and soft skills and domain knowledge through university and work. Aspiring to be a business or data analyst to empower my career pathway.

Katherine W.'s Current Company Details
Constellation Brands New Zealand & Australia

Constellation Brands New Zealand & Australia

View
Data and Reporting Analyst | Business Intelligence
auckland, auckland, new zealand
Employees:
56
Katherine W. Work Experience Details
  • Constellation Brands New Zealand & Australia
    Data And Reporting Analyst
    Constellation Brands New Zealand & Australia Nov 2024 - Present
    Auckland, New Zealand
  • Animates Vetcare Nz
    Data Analyst
    Animates Vetcare Nz Nov 2022 - Oct 2024
    Auckland, New Zealand
    • Leverage SQL (SSMS and Snowflake), Power BI, advanced Excel, API scrapers, and various toolsets to collect and transform data into actionable insights.• Contribute to web sourcing and data scraping efforts for collecting information from various organizations, and diligently solve the problem in weekly scraping report.• Design the dashboard and improve data visualization using Power BI for data intelligence and analysis.• Prepare data reports that interpret customer behaviour, sales overview, marketing results, trends, and opportunities. • Collaborate with other stakeholders, present the reports to CMO/CPO, and receive the positive feedback.• Delivery of over 100 pages of reports and dashboards; actively collaborate with colleagues, sharing insights.• Contribute to the data migration process, facilitating the transition from SSMS to Snowflake.• Proficiently handle multiple projects and tasks and work efficiently under time constraints.
  • Hd Education
    Accounting Tutor
    Hd Education Nov 2021 - Jul 2023
    Auckland, New Zealand
    • Tutored over 100 students in the university's accounting courses and received positive feedback.• Created and implemented the lesson plans; Prepared the courses’ material, including slides and exercise files. • Helped groups and one-on-one sessions in problem-solving; adjusted instruction based on feedback.
  • Tearfund New Zealand
    Finance And Operate Assistant
    Tearfund New Zealand Dec 2022 - Feb 2023
    Auckland, Auckland, New Zealand
    • Input and retrieved financial entries from Xero databases accurately and promptly.• Loaded invoices, created new bills in the Xero database, and prepared for payments.• Processed monthly batch payments accurately and on time. • Maintain confidential data and documents regarding payment, including banking information.
  • The University Of Auckland
    Teaching Assistant
    The University Of Auckland Jul 2022 - Nov 2022
    Auckland, New Zealand
    • Communicated with the lecturer and other colleagues to discuss the marking schedule.• Marked students' assignments and assisted in analysing students' results and data.
  • Kpmg New Zealand
    Analyst Intern (Micro-Internship)
    Kpmg New Zealand Jun 2022 - Jul 2022
    New Zealand
    • Provided research, analysis, insights and recommendations for New Zealand tourism. • Suggested business operating model in place to achieve the tourism goals after the Covid. • Collaborated with team members and delivered the reports and presentations within the time frame.
  • Shanghai Connext Data Technology
    Data Analyst Intern
    Shanghai Connext Data Technology Dec 2021 - Mar 2022
    Shanghai, China
    • Utilised the data software, including data bank and strategy centre, to capture different types of raw data.• Used advanced Microsoft Excel to optimise the data collection procedure, including data cleaning and integration.• Improved data visualization using PPT and Tableau to convert data into insights. • Tracked and analysed data and generated weekly and monthly data analysing reports.• Completed the tasks by clients and provided the recommendation of online advertisement to clients.
  • Bdo China-Shu Lun Pan Certified Public Accountants Llp
    Audit Intern
    Bdo China-Shu Lun Pan Certified Public Accountants Llp Oct 2021 - Dec 2021
    Beijing, China
    • Requested files from clients and associated companies and operated SAP systems to obtain financial information. • Checked audit vouchers to investigate the problems and produced spreadsheets detailing audit findings. • Proof some claims that are made by verifying totals, calculations and general accounts submitted throughout the audit.• Assessed inventory and non-current assets to verify the amount in journal and ledger entries.
  • China Construction Bank (New Zealand) Limited
    Investment Banking Intern (Micro-Internship)
    China Construction Bank (New Zealand) Limited Jun 2021 - Jul 2021
    New Zealand
    • Analysed “Public-Private Partnership”, including pros and cons with real-world examples.• Suggested strategies of investment and investing opportunities; assisted the client in decision-making. • Completed the report and presented the results of the analysis to China Construction Bank.
  • Grant Thornton New Zealand Ltd
    Accounting Intern (Micro-Internship)
    Grant Thornton New Zealand Ltd Jun 2020 - Jul 2020
    New Zealand
    • Assisted in the analysis of Air New Zealand’s fixed income.• Implemented international accounting standards (IFRS 15) to identify and calculate the exact amount of income.• Cooperated with team members and presented results of analysis and implications to senior management.

Katherine W. Education Details

Frequently Asked Questions about Katherine W.

What company does Katherine W. work for?

Katherine W. works for Constellation Brands New Zealand & Australia

What is Katherine W.'s role at the current company?

Katherine W.'s current role is Data and Reporting Analyst | Business Intelligence.

What schools did Katherine W. attend?

Katherine W. attended The University Of Auckland, The University Of Auckland, Acca, Western Springs College.

Who are Katherine W.'s colleagues?

Katherine W.'s colleagues are Alina Ogilvy, Swapnil Yadav, Siobhan Kenny-Allen, Greg Crosby, Rosella Dang, Kirsten Allen, Toby Dixon.

Not the Katherine W. you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.