BELLA / JINGBING HUANG

Live in Vancouver, BC, Canada · (+1)778-988-8174 · bellahuang1012@gmail.com

Dedicated data engineer with a passion for building data pipelines. Excited to leverage technical expertise in transforming raw data into valuable business solutions. Experienced in ETL / ELT processes, data warehousing, and cloud techniques.


Resume can be found here.


Experience

Data Warehouse Developer

BroadbandTV(BBTV), Vancouver, BC, Canada
  • Designed and implemented efficient ETL/ELT pipelines to process and transfer data from various sources to Snowflake.
  • Developed and maintained data marts, enabling streamlined access to critical business insights.
  • Successfully integrated and transformed JSON, Parquet, and XML data types in Snowflake, enabling streamlined analytics processes and improving query performance.
  • Leveraged Snowflake features such as window functions, virtual columns, task, stream and materialized view to enhance data performance.
  • Built reusable components to work with data in Google Drive using Docker and Python.
  • Collaborated with data analysts to create data visualization in Power BI.
  • Implemented data validation and data quality checks to ensure accurate and consistent data across systems.
  • Provided comprehensive guidance to new team members through clear and thorough documentation, fostering their growth and development.
    • Apr 2021 - Present

    Data Operations Specialist

    BroadbandTV(BBTV), Vancouver, BC, Canada
  • Developed a universal resolution in Python and Bash for migrating data from RDBMS to Snowflake.
  • Built a component to secure user login with MFA for the internal claiming tool using AWS Cognito and API Gateway.
  • Automated data extraction and transformation processes, enhancing operational efficiency with a 50% increase.
  • Offered data assistance and ad-hoc reporting to multiple departments across the company.
  • Participated in building a contextual search tool using ElasticSearch and Wikidata.
    • Jun 2019 - Mar 2021

    Data Analyst Intern

    BroadbandTV(BBTV), Vancouver, BC, Canada
  • Experienced in building applications around Youtube API and Google API.
  • Constructed a comprehensive data collection tool for YouTube videos and channels using AWS SQS and Lambda.
  • Utilized Amazon Kinesis Data Firehose to transform and enrich incoming data streams before delivering them to Amazon S3.
  • Build a Jenkins pipeline for the daily loading and transformation of gigabytes of data into Snowflake.
  • Designed and developed an event-driven application using AWS Lambda and API Gateway, enabling users to access and utilize gathered data via Slack.
    • Oct 2018 - May 2019

    IT Department Intern

    City of Sarnia, Sarnia, ON, Canada
  • Led a group of four to set up a video surveillance security system in Linux environment.
  • Figured out working mechanism of the IP cameras, RTSP stream and open-source recording system.
  • Created virtual machines and containers for multiple server testing in Proxmox.
  • Installed Zoneminder and Shinobi on different Ubuntu servers and configured them to consume RTSP stream from the IP camera.
  • Separated local database from recording software to a remote server and set up master-slave replication for Mysql.
  • Set up a scalable network filesystem with GlusterFS for data back-up.
  • Installed GitLab in a local ubuntu server and documented the project details in Markdown.
    • Apr 2018 - Jun 2018

    CO-OP student

    Sarnia-Lambton Youth Skills Connection, Sarnia, ON
  • Built IoT projects with Raspberry PI 3 and Python.
  • Hands-on experience in setting up an ubuntu server, installing LAMP server, hosting a personal website and a WordPress blog on it.
  • Created a weather application based on React and Bootstrap using Visual Studio Code
    • Jan 2018 - Mar 2018

    Education

    Data Engineering Nanodegree

    Online program in Udacity
    Learned to design data models, build data warehouses and data lakes, automate data pipelines, and work with masive datasets. Hands-on practices on Redshift, Spark and Airflow.

    Program Introduction
    Certificate of Completion
    Projects Repository
    Sep 2019 - Feb 2020

    Lambton College, Sarnia, ON, Canada

    Post-secondary program certificate
    Major in: Computer Software and Database Development

    GPA: 3.93/4.0

    Certificate Document
    Transcript Document
    Sep 2016 - Jun 2018

    Guangdong Pharmaceutical University, Guangzhou, Guangdong, China

    Bachelor’s degree
    Major in: Information Management and Information System

    GPA: 3.41/5.0

    Verification Report of Degree Certificate
    Verification Report of Academic Transcript
    Sep 2010 - Jun 2014

    Skills

    Programming Languages & Tools
    Data Pipelines Implementation
    • Collecting requirements
    • Understanding data sources
    • First Load then Transform
    • Ensure data integrity and set up data monitoring

    Interests

    I enjoy ice skating a lot in my spare time. Skating on ice not only keeps me physically active but also teaches me balance and perseverance. I enjoy challenging myself to improve techniques and explore new skills on the ice.

    Capturing moments through the lens has been a passion of mine. Photography allows me to see the world from different perspectives, and I enjoy experimenting with composition and lighting to convey unique stories through images.

    Feel free to visit my photo profile.

    Awards & Certifications

    Projects

    Data Engineering

    Android Application
    • Happy Travel App
      A travel information sharing app for articles posting, commenting, posts reading, etc.. Development tool is Xamarin and XML is applied to customize the styles and animation for UI elements. Back-end functions are generated in C#, and data are stored in JSON format using SQLite

    Database Design Report

    Cloud Computing in AWS

    Web development