Python, Java, ETL Pipeline, SQL, Nosql, Powerbi, Airflow, Git, S3
Resume:
Personal Profile
Tony Cui
Data Engineer /Mobile App Developer
Richmond, B.C., V6V 2T7
adjek7@r.postjobfree.com
A highly motivated and adaptable data engineer, experience with building stable ETL pipelines, data modeling, creating the data warehouse. Data exploration analysis and Data Visualization. Also have many years of experience in mobile app development. Familiar with the agile development environment.
COMPANY
FIND Innovation Labs Inc.
Vancouver. B.C
Oct. 2017 - Oct. 2020
WORK EXPERIENCE
Data Engineer
Projects : Build up the scheduled ETL data pipelines. Environment : Airflow, Python 3.x, MS SQL Server, MySQL, NoSQL MongoDB, Git, Bitbucket,
Key Role:
● Implemented Airflow Data Pipelines. Extra, Transform and upload the data to cloud data warehouse and AWS S3 Buckets. Reconciliation and investigation of data integrity issues
● Involved new customer onboarding. Provided the best data ingestion solution for historic and current data.
Projects : Setup Data Warehouse
Environment : Python 3.x, MS SQL Server, T_SQL
Key Role :
● Collaborated with data scientists, denormalized the schema and generated the training data.
● Data Modeling with fact and dimension tables, created the Index file, View, and Stored Procedure, generated the demo data for the marketing team or special projects.
Projects : Data Analyze (BI) and Visualization Data on Web App Environment : Power BI Desktop, App Service, DAX language Key Role :
● Aggregated and analyzed data for business performance, including sales trend, sell through, markdown, turnover, and forecast. also selected the appropriate visualization to present the KPIs or data flow.
● Supported frontend to embed the reports and dashboards on the web app.
Project : Mobile App e-receipts, White label app
Environment : Android Studio, Android 8.0, JAVA, Kotlin, giit, Bitbucket, Jenkins
Key Role :
● In charge of Android App Design, Development and Release
● Extracted the common code and built in a jar library for new projects, improved the development speed.
LM Micro Consulting
Company
Vancouver, B.C.
May 2017 - August 2017
Software Engineer
Project : Vehicle’s Pistons Control
Environment : Android Studio, Android 6.0, BLE 4.2 This project is a prototype used for the new type of rescue vehicle. It allows the driver to control the vehicle’s high status via changing piston pressure.
Key Role :
Designed and implemented a tablet app, allowing the driver to reset the height of the vehicle fast and safely via tablet GUI. The main features are including:
● Detect the vehicle’s tilt and pitch degrees on the vehicle.
● Transfer data between the vehicle and tablet via Bluetooth.
● Customized views for piston air pressure and vehicle’s rear steering control.
FusionPipe Software
Solutions Inc
Vancouver, BC
April 2014 to June 2016
Intermediate Software Engineer
Project : QuikID app
Environment : iOS 7, Android, XCode, Android Studio, Objective-C, Java, git, GitHub, Jenkins, Testflight, HockeyApp
QuikID is a convenient Bluetooth low energy app that allows users to securely lock & unlock their workstation, computer or Virtual Desktop. The introduction link is here: https://www.youtube.com/watch?v=BkqjGYz7nZk Key Role:
● The key developer of the project.
● Built and ran the Jenkins Continuous Integration (CI) Server to build the source code.
v
Linquet Technologies
Vancouver, BC
May 2012 to Dec. 2013
Android Software Developer
Project : Linquet app
Environment : Android, Eclipse, Java, git, Bluetooth 2.0, 4.0, git, Github Linquet is a cloud-based anti-lost app for the phone and valuables (keys, wallet, bag, pet, etc.) . The introduction link is here: http://www.youtube.com/watch?v=tQJVxk7ggK0
The Linquet app was selected as a GigaOM Mobilize Product finalist. http://gigaom.com/2013/09/16/meet-the-8-gigaom-mobilize-product-showcase-finalists/ Key Role:
● The key developer of the project.
● Published the application on Google Play Store.
● Designed the Linquet message API for clients and the RESTful server.
● Guided the new developer.
Access Information
Technologies Ltd
Vancouver, BC
Sept. 2011 to March 2012
Android Software Developer
Project : POS Ticketing system
Environment : Android, Eclipse, git, Java, SQLite
The project is a ticket sales system which is used by a local tour company. Key Role:
● Analyzed the requirement, created Data Model
● implemented and released the app
● Built the sales management reports with MS SQL Report Service 2008 M-way Information
Technology Co. Ltd
Beijing, China
May 2001 to Sep. 2003
Software Engineer
Project : Hong Kong Aircraft maintenance Facility Human Resource Management (subsystem of an ERP)
Environment : Windows, .Net, VB, SQL Server
Key Role:
● Responsible for analyzing and clarifying the HRM requirement
● Created the Use Case, Activity Diagram, Static Structure Diagram, Sequence Diagram with UML Tools.
● Designed data model and schema with SQL Database
● Implemented signed functions, and testing code.
HARD SKILLS
Programming
Python
JAVA,
SQL
Objective-C, SWIFT,Kotlin
EDUCATION
Java Programing Language (SL-275)
Sun Microsystems, Inc in Year 2002
Bachelor in Accounting
Lanzhou University of Finance and
Economics
June 1995 Lanzhou, China
SOFT SKILLS
Integrity
Teamwork, Adaptability,
Problem-solving,
Attention to Detail,
Willingness to learn
Contact this candidate