tonygu

tonygu

Data Analyst
Canada

About Me

Tony is an inquisitive data analyst with a solid background in Chemical Engineering and strong technical skills. Tony is passionate about data mining, data ETL, data analysis, data pipeline, predictive analytics, and dat…

Experience

Data Analyst

Lions Digital Solutions
Dec 2022 - Present · 3 years 7 months

● Integrated varied CRM data sources into Google Sheets using Zapier 's automated processes
● Utilized Google Cloud BigQuery for intricate SQL analysis of Google Ads Campaign data, designed data warehouse schema
for raw table and pdt views, created conceptual-level SQL queries to perform the exploratory data analysis
● Administered and analyzed extensive sales data within the relational database, effectively handling large datasets
● Managed Power BI data flows, employing DAX and M language, extracted and cleaned raw data from BigQuery
● Designed and built interactive Power BI dashboards to continuously track omnichannel marketing campaign performance,
including conversions, CTR, ROAS(return on ad spending), sales, commissions, etc
● Automated reporting workflow by scripting and APIs, delivering weekly marketing dashboard to support management decision
● Creating SQL store procedures and functions to perform data quality checks, applying data governance using Collibra

Data Analyst

Lions Digital Solutions
Jan 1970 - Jan 1970

Integrated varied CRM data sources into Google Sheets using Zapier's automated processes.
Utilized Google Cloud BigQuery for intricate SQL analysis of Google Ads Campaign data.
Designed data warehouse schema for raw table and pdt views.
Created conceptual level SQL queries to perform exploratory data analysis.
Administered and analyzed extensive sales data within the relational database.
Effectively handled large datasets.
Managed Power BI data flows, employing DAX and M language.
Extracted and cleaned raw data from BigQuery.
Designed and built interactive Power BI dashboards to continuously track omnichannel marketing campaign performance, including conversions, CTR, ROAS, sales, commissions, etc.
Automated reporting workflow by scripting and APIs.
Delivered weekly marketing dashboard to support management decision.
Created SQL store procedures and functions to perform data quality checks.
Applied data governance using Collibra.

Data Analyst

360 PowerDent Inc
Jan 1970 - Jan 1970

Built the data platform and reporting infrastructure from zero for various dental practice management software.
Used Power BI desktop and SQL Server.
Developed operational reporting in Power BI and Excel to streamline client base growth and self-serve data management.
Reduced 20 hours of workload per client per month.
Managed clients' Microsoft 365 credentials.
Established data connections such as on-premises data gateway.
Collected ad-hoc business requirements from clients in bi-weekly meetings.
Delivered valuable data insights.
Provided technical consultations on business opportunities.
Recommended improvement strategies to workflow processes for clients.
Performed data accuracy testing of developed reports to enhance data quality and usability.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Data Representation Data Analysis Skills Power BI Python SQL DAX PowerQuery/M HTML Tableau Looker Studio matplotlib seaborn plotly Google Analytics pandas numpy scikit-learn imblearn Google BigQuery Azure SQL MySQL SQL Server PostgreSQL SQLite Google Cloud Platform Microsoft Azure Cloud Platform Zapier APIs Collibra Excel Microsoft 365 on-premises data gateway A/B testing ETL Flask JavaScript D3
Report this Profile?