Katherine W. Email and Phone Number
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.
Constellation Brands New Zealand & Australia
View- Website:
- constellationnz.com
- Employees:
- 56
-
Data And Reporting AnalystConstellation Brands New Zealand & Australia Nov 2024 - PresentAuckland, New Zealand -
Data AnalystAnimates Vetcare Nz Nov 2022 - Oct 2024Auckland, 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. -
Accounting TutorHd Education Nov 2021 - Jul 2023Auckland, 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. -
Finance And Operate AssistantTearfund New Zealand Dec 2022 - Feb 2023Auckland, 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. -
Teaching AssistantThe University Of Auckland Jul 2022 - Nov 2022Auckland, 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. -
Analyst Intern (Micro-Internship)Kpmg New Zealand Jun 2022 - Jul 2022New 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. -
Data Analyst InternShanghai Connext Data Technology Dec 2021 - Mar 2022Shanghai, 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.
-
Audit InternBdo China-Shu Lun Pan Certified Public Accountants Llp Oct 2021 - Dec 2021Beijing, 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. -
Investment Banking Intern (Micro-Internship)China Construction Bank (New Zealand) Limited Jun 2021 - Jul 2021New 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. -
Accounting Intern (Micro-Internship)Grant Thornton New Zealand Ltd Jun 2020 - Jul 2020New 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
-
Fintech -
Gpa: 8/9 -
Top Student
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?
-
Katherine W.
Los Angeles, Ca -
-
Katherine W
United States4gmail.com, outsideopen.com, outsideopen.com, atm.com1 (805) 3XXXXXXX
-
2gmail.com, efworld.org
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial