Learn Data Skills
Beta
Vanessa Ip

Vanessa Ip

Data Specialist

Herschel Supply Co

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Course

Introduction to Python

Problem-solving virtuoso, decoding complexity with a data-driven approach.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to Python

course

Introduction to SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

Herschel Supply Co | May 2023 - Sep 2023

Data Specialist

-Fostered cross-functional team awareness of data quality and data management best practices by engaging with stakeholders across the company to validate and document the data life cycle and business processes across integrated enterprise resource planning (ERP) systems. -Enhanced the customer experience and revenue generation on the e-commerce platform through the resolution of data inconsistencies across software systems that involved investigations in multiple data sources using SQL -Designed and executed an organization-wide survey for data quality assessment. Cleaned and analyzed descriptive findings using Excel and presented actionable insights to the leadership to drive process enhancements and strategic resolution of data management challenges
Show More

Habanero Consulting Inc. | Jan 2022 - May 2022

Performance Reporting Analyst

Contracting for intranet analytics and insights.

Habanero Consulting Inc. | Mar 2020 - Dec 2021

Product Analyst

Project management and cross-functional collaboration : -Promoted to product analyst for leading the development of the intranet analytics program which resulted in all clients adopting the new data analytics tools and data-driven approach to problem-solving in B2B SaaS work environment -Coordinated with cross-functional teams in project delivery end-to-end, translating client requirements, documenting requests and bugs, facilitating proactive communication, and delivering user training. These actions resulted in timely deployment and successful customer adoption Data quality and analysis : -Executed data collection, cleaning, manipulation, validation and troubleshooting procedures to ensure optimal data quality for internal and external utilization, and to foster a culture for high data quality standards -Synthesized customer needs by using Excel / SQL / Google Analytics to analyze quantitative and qualitative data sets to identify insights and opportunities. This resulted in a streamlined product roadmap and improved efficiency for feature development and design by 10% Client engagement and product customization: -Customized and managed the analytical tools for 15+ customers, enabling them to leverage accurate metrics, segment audience targeting, perform cohort analysis and drive business results -Designed automated dashboards, saving clients 20 hours per quarter in generating reports -Regularly presented statistical and descriptive trends to senior executives, driving a 20 - 25% increase in employee engagement and a 15% increase in employee productivity through targeted recommendations -Demonstrated the impact of my work through multiple client feedback, indicating that the reporting of data insights enabled clients to deliver effective solutions and achieve business objectives

Habanero Consulting Inc. | Mar 2019 - Mar 2020

Product Support Specialist

-Led the support team to proactively refine customer services that delivered structured yet tailored user experiences, boosting customer satisfaction rates and maintaining 0% customer churn -Managed 15+ customer relationships and provided on-going support for Google Analytics, Google Tag Manager, Google Data Studio, Microsoft SharePoint Classic & Modern, Microsoft Office 365, Habanero’s SaaS web and mobile product -Collaborated with agile teams in product development, backlog prioritization, analytics measurement & reporting, quality assurance, A/B testing, solution upgrades and new hire training, achieving a 20% decrease in deployment time and errors, and an increase in sprint velocity -Initiated and led the migration to a new ticketing system, improving tracking of ticket metrics and enabling data-driven decision-making that enhanced customer service and operational efficiency

Fraser Health Authority | Nov 2018 - Mar 2019

Environmental Health Officer

-Worked in Canada: Vancouver Coastal Health, Northern Health, and Fraser Health. Worked in Australia: Queensland Fraser Coast Regional Council, and New South Wales Cumberland Council -Conducted 750+ annual regulatory inspections and complaint investigations covering food safety, drinking water quality, industrial camps, personal services, sewage systems, recreational pools, and communicable diseases, including an 85% increase of inspections in remote communities after taking over a new geographical district -Achieved an average 80% increase in re-inspection compliance rate through educating operators, implementing progressive enforcement measures, and recommending practical solutions to gain compliance with public health legislation and policies -Utilized critical thinking and sound judgment to evaluate environmental risks and mitigate potential health and safety hazards, contributing to improved population health outcomes and a reduced burden of disease

Cumberland Council | Mar 2018 - Aug 2018

Environmental Health Officer

N/A

Fraser Coast Regional Council | Oct 2017 - Mar 2018

Environmental Health Officer

N/A

Northern Health - BC | Oct 2015 - Jun 2017

Environmental Health Officer

N/A

Canda Six Fortune Enterprise Co. Ltd. | Jul 2014 - Oct 2015

Quality Assurance Specialist

-Evaluated and validated 1500+ imported products for the safety and quality compliance with food standard policies & regulations to provide actionable insights to stakeholders and recommend safe, reliable and cost-saving solutions

Vancouver Coastal Health | Mar 2013 - Jun 2013

Environmental Health Officer in training

N/A

My Education

Take a look at my formal education

Certificate in Business AnalyticsUniversity of Pennsylvania | 2023
Bachelor of Science in Technology in Environmental health inspectionBritish Columbia Institute of Technology | 2013
Bachelor of Science in Health and nutritionThe University of British Columbia / UBC | 2011

About Me

Vanessa Ip

Process-driven and detail-oriented data analyst with 3+ years of experience in data management, cleaning, analysis, visualizations and reporting that delivered actionable insights and enhanced client solutions in agile cross-functional projects

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free