Aiqing Lan

Data Crawling Engineer at SkyHive
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Burnaby, British Columbia, Canada, CA
Languages
  • Japanese Elementary proficiency
  • English Professional working proficiency
  • Chinese Native or bilingual proficiency

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.
You need to have a working account to view this content.

Experience

    • United States
    • Software Development
    • 1 - 100 Employee
    • Data Crawling Engineer
      • Jun 2022 - Present

    • Canada
    • Advertising Services
    • 1 - 100 Employee
    • Data Specialist, Digital Marketing
      • Jul 2021 - Present

      *Data expert in the company, collecting, processing, storing, querying, analyzing and visualizing digital marketing data (from ‘raw’ to database and from database to visualization)*Built ETL data pipelines including extracting data (using API or web scraping), cleaning data, creating tables in databases and loading data into databases.*Designing and building the company’s data warehouse from scratch in local server and cloud environment using MySQL/NoSQL*Used Excel, Tableau or Power BI to generate visualized report or interactive dashboard based on data queried from databases*Using machine learning technique to optimize the performance of digital campaigns*Amazon Merchant Service expert that provides consultation for amazon sellers of different backgrounds.

    • Data Engineer
      • Apr 2021 - Mar 2022

      *Wrote Python codes to improve the efficiency of data processing procedure in the ETL pipeline. It includes web scraping, language processing, image processing, and API.*Troubleshooting for Python codes written by external contractors*Did Search Engine Optimization research for consumer goods*Managed product data of more than 10 thousand products on E-commerce websites *Wrote Python codes to improve the efficiency of data processing procedure in the ETL pipeline. It includes web scraping, language processing, image processing, and API.*Troubleshooting for Python codes written by external contractors*Did Search Engine Optimization research for consumer goods*Managed product data of more than 10 thousand products on E-commerce websites

    • Canada
    • Non-profit Organizations
    • 1 - 100 Employee
    • Data Technician (Volunteer in Non-Profit)
      • Sep 2020 - Dec 2020

      *Used MS Office and Libre Office (Linux) to create electronic forms and process data for charity programs*Fixed Linux system issues in admin office of the store *Used MS Office and Libre Office (Linux) to create electronic forms and process data for charity programs*Fixed Linux system issues in admin office of the store

    • Canada
    • Higher Education
    • 700 & Above Employee
    • PHD Student/Candidate
      • Sep 2016 - Dec 2019

      *Data Modeling, Analysis and Visualization on Efficient Fast Refill of Compressed Natural Gas*System Design and Mathematical Calculation for a Novel Electronic Cooling Technique on Micro-structured Surfaces *Data Modeling, Analysis and Visualization on Efficient Fast Refill of Compressed Natural Gas*System Design and Mathematical Calculation for a Novel Electronic Cooling Technique on Micro-structured Surfaces

Education

  • The University of British Columbia
    Master's degree, Mechanical Engineering
    -
  • Xi'an Jiaotong University
    Master's degree, Power Engineering
    -
  • MIANYANG HIGH SCHOOL
    High School Diploma, Top 0.3% in National College Entrance Exam
    -
  • Xi'an Jiaotong University
    Bachelor's degree, Energy and Power Engineering & Automation
    -
  • National Tsing Hua University
    Visiting Student
    -

Community

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