VIVIANE WANG
Summary
Data Analyst with expertise in web development, database design, and a strong business acumen. Proven ability to solve complex problems and translate data insights into actionable strategies. Skilled in optimizing processes and driving growth. Effective communicator experienced in collaborating with diverse teams and stakeholders, combining technical expertise with project management capabilities for delivering results in dynamic environments.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Senior Data Analyst
Xylem Inc.
Missisauga, ON
01.2020 - 09.2024
- Data Quality Analysis: Implemented Python validation scripts in the post-ETL stage, utilizing the Pandas library for statistical analyses, and generating automated reports to monitor data quality. Achieved a 12% decrease in data discrepancies, enhancing reliability for downstream analysis and predictive models.
- Data Integration and Cross-Source Analysis: Integrated multiple datasets (ultrasonic data with machine operational data) from cloud storage for data integration and cross-source analysis. Increased root cause analysis speed, enabling faster identification of underlying issues by the engineering team.
- Noise Reduction and Signal Processing: Supported Singapore government's water facility monitoring tender project by developing noise reduction algorithms to clean ultrasonic time-series data using Python. Successfully improved signal accuracy and minimized false-positive detection rates during testing demo.
- Performed trend analysis and predictive maintenance: Conducted trend analysis and predictive maintenance by querying and aggregating ultrasonic data using SQL to extract key metrics. Utilized Python to build predictive models for monitoring abnormal frequencies and potential facility failures from signal strength, resulting in a 17% improvement in failure prediction accuracy.
Sales Performance Analysis
Groupe Sante Esperance Inc.
11.2018 - 01.2021
- Built an e-commerce website with a database: Developed and maintained a fully operational skincare product e-commerce website, utilizing HTML/CSS, JavaScript, and SQL for inventory management and sales data analysis. Enhanced tracking of user behavior and sales funnel performance by integrating Google Analytics with the usage of Google Tag Manager for event tracking.
- Optimized Marketing with Data Analysis: Utilized Python and Pandas for data extraction, analysis, and trend analysis to improve marketing strategies and product listings. Boosted conversion rates by optimizing SEO and enhancing user experience based on data analysis.
- Automated Reporting and Boosted Sales: Developed an automated system for weekly sales reporting utilizing Google Data Studio and SQL, which provided an in-depth analysis of customer demographics, sales patterns, and sources of traffic.
Lab Manager
McGill University
Montreal, QC
11.2018 - 01.2020
- Managed team of 37 researchers, overseeing over $22 million in research funds and leading stakeholder engagement to address business problems.
- Took charge of finance reporting and dashboard creation to deliver accurate, high-quality, and timely fixed/ad-hoc reports supporting managerial decisions.
Data Analyst
Royal Dutch Shell
Calgary, AB
06.2009 - 09.2015
- Created high-quality subsurface visuals for petroleum and natural gas discovery through the processing of raw seismic data.
- Achieved improved signal precision through the utilization of Petrel, ProMAX, and SeisSpace tools for data scrubbing, noise decrease, and migration.
- Collaborated with geophysicists to produce accurate subsurface models, enhancing the ability to identify potential hydrocarbon reservoirs and improve drilling precision, consequently reducing the risk of dry wells.
Education
Information And Communication Technology
John Abbott College
Montréal, QC03-2022
Master of Science - Biomedical Engineering
McGill University
Montréal, QC04-2018
Master of Science - Geophysics
McGill University
Montréal, QC04-2009
Skills
- Data Cloud Platform: Google Cloud Platform (GCP) (BigQuery, Looker, Google Analytics), Amazon Web Services (AWS) (S3, QuickSight)
- Data visualization: Tableau, PowerBI, Looker
- Scripting Language: SQL, R, Python, SAS, Javascript (Nodejs)
- Project Management: Business Requirement Documentation, Software Development Lifecycle management, Risk management
Certification
- Project Management Institution Certificate (PMI), 2017 - Now
- SAS Certified Specialist, 2020 - Now
Personal Information
Title: DATA ANALYST, PMP
Languages
English
Full Professional
French
Professional
Chinese (Mandarin)
Native/ Bilingual
Timeline
Senior Data Analyst
Xylem Inc.
01.2020 - 09.2024
Sales Performance Analysis
Groupe Sante Esperance Inc.
11.2018 - 01.2021
Lab Manager
McGill University
11.2018 - 01.2020
Data Analyst
Royal Dutch Shell
06.2009 - 09.2015
Information And Communication Technology
John Abbott College
Master of Science - Biomedical Engineering
McGill University
Master of Science - Geophysics
McGill University
Similar Profiles
Anthony DawsonAnthony Dawson
In Shop Technician at Xylem Inc.In Shop Technician at Xylem Inc.
Hunter PrenticeHunter Prentice
Groundperson/Mower Operator at Xylem Inc.Groundperson/Mower Operator at Xylem Inc.
Jennifer QuiversJennifer Quivers
Service Center Specialist at Xylem Inc.Service Center Specialist at Xylem Inc.
Franchesca MarteFranchesca Marte
Machine Builder at Xylem Inc.Machine Builder at Xylem Inc.
Jonathon NanceJonathon Nance
Senior Data Analyst /Lead Data Analyst at Two Kings CasinoSenior Data Analyst /Lead Data Analyst at Two Kings Casino