WEI ZHENG

Data Analyst at DataTech Services
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
CA

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Deep Learning Specialization
    Coursera
    Feb, 2020
    - Oct, 2024
  • Tableau Essential Training
    LinkedIn
    Dec, 2019
    - Oct, 2024
  • SQL Essential Training
    LinkedIn
    Nov, 2019
    - Oct, 2024

Experience

  • DataTech Services
    • Canada
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Data Analyst
      • Jul 2019 - Present

      Project 1: Database and End-to-End ETL Pipeline (VBA, Python, SQL) • Assisted with designing a database to store and manipulate data about clients, transactions, agents, referrers, etc., and building an end-to-end ETL pipeline to automatically read data from excel files and load data into MySQL database using Python • Performed a requirements analysis and designed a conceptual ER model and a physical data model using DB Designer • Generated unique ID for each transaction using VBA and referral ID using excel build-in functions • Communicated with business team to modify database schema and python codes in the development stage • Identified manually caused data errors in excel files and created daily data quality report for the business team using Python • Validated data integrity and consistency and created views from multiple tables using SQL queries in the staging environment Project 2: Business Analysis and Marketing Campaign (Python, SQL, Tableau) • Built an executive dashboard of overall performance with a date filter automatically updated to the latest using Tableau Desktop • Created calculated fields showing the percentage of annual growth and YTD settled amount and corresponding trend line in Tableau • Performed a descriptive analysis and a cluster analysis to segment clients using Python; Created an analytical report with valuable business insights and marketing strategies using PowerPoint and made a presentation to the project manager • Filtered out target clients based on different marketing strategies using SQL queries in MySQL and exported selected clients’ aggregated information as excel files; Wrote documentation to translate between codes and marketing strategies • Prepared customers’ data as excel files and implemented Gmail API to send emails with promotion code to target customers • Successfully help to increase the number of new customers and customers’ settled amount Show less

  • Nipissing University
    • Canada
    • Higher Education
    • 300 - 400 Employee
    • Research Assistant
      • Jul 2019 - Dec 2019

      • Conducted a literature review regarding the factors which influence menopausal symptoms and their related interventions. • Performed meta-analysis using CMA and Review Manager. • Drafted several project proposals based on the results of the review and the analysis. • Conducted a literature review regarding the factors which influence menopausal symptoms and their related interventions. • Performed meta-analysis using CMA and Review Manager. • Drafted several project proposals based on the results of the review and the analysis.

  • Toronto Western Hospital
    • Medical Practices
    • 200 - 300 Employee
    • Research Assistant
      • Sep 2019 - Oct 2019

      • Helped conduct a randomized control trial examining the effects of a physical activity prescription on physical activity (PA) and quality of life (QOL) post-bariatric surgery. • Processed data and performed descriptive data analysis in Excel and R. • Built a linear model to identify the background characteristics which had a significant effect on PA and QOL in R. • Illustrated the results of the analysis using a report. • Helped conduct a randomized control trial examining the effects of a physical activity prescription on physical activity (PA) and quality of life (QOL) post-bariatric surgery. • Processed data and performed descriptive data analysis in Excel and R. • Built a linear model to identify the background characteristics which had a significant effect on PA and QOL in R. • Illustrated the results of the analysis using a report.

  • Chinese Academy of Sciences
    • China
    • Research Services
    • 700 & Above Employee
    • Research Intern
      • Jul 2016 - Aug 2016

      • Identified factors which greatly affect users’ advertising impact on Facebook. • Communicated and presented analysis regarding the vulnerability and variability of the Facebook network structure. • Analyzed the merits and demerits of using three existing algorithms (greedy algorithm, sorting algorithm based on number of followers, and sorting algorithm based on the Independent Cascade Model). • Proposed a combined model to choose the micro-community with the greatest advertising impact using Facebook datasets. Show less

Education

  • University of Ottawa
    Master's degree, Mathematics and Statistics, Concentration in Statistics
    2017 - 2019
  • Fuzhou University
    Bachelor of Science - BS, Mathematics and Applied Mathematics
    2013 - 2017

Community

You need to have a working account to view this content. Click here to join now