Lu Gan, Software Developer in Vancouver, BC, Canada
Lu Gan

Software Developer in Vancouver, BC, Canada

Member since May 13, 2018
Along with being passionate about self-learning and problem solving, Gan is an experienced software engineer with a solid background in software engineering fundamentals. The bulk of his work has been building business logic and Web APIs with the .NET framework, managing, optimizing, and developing with the SQL server, improving performance with a multi-layered cache, and deploying, monitoring, and maintaining services based on Microsoft Azure.
Lu is now available for hire

Portfolio

Experience

Location

Vancouver, BC, Canada

Availability

Part-time

Preferred Environment

Git, Visual Studio

The most amazing...

...thing I've coded is using approximate dynamic programming (reinforcement learning) to solve a housing allocation problem.

Employment

  • Full-stack Developer

    2018 - PRESENT
    Trader Corporation
    • Built a RESTful API to support a vehicle showroom with .NET.
    • Created an ETL process to support inventory management.
    • Developed a highly responsive single-page application with React to enhance a dealer platform.
    • Created a multilayered cache to ensure good API performance.
    • Manipulated inventory data and vehicle attributes from multiple sources and made them visible.
    • Deployed, monitored, and maintained web apps, storage systems, and SQL databases based on Azure.
    Technologies: JavaScript, HTML, Azure, React, SQL, C#
  • Full-stack Developer

    2019 - 2020
    Riboli Family Wines
    • Developed two eCommerce platforms based on SQL Server, ASP.NET Core, and React/TypeScript.
    • Managed QA and production environment as well as setting up continuous integration and continuous deployment.
    • Integrated the system with multiple third-party services for tax calculation, order syncing, shipping management, newsletter subscription, and so on.
    Technologies: TypeScript, React, SQL Server DBA, ASP.NET Core
  • Full-stack Developer (Part-time)

    2017 - 2019
    Jianyi Food, Ltd.
    • Built from scratch a management system for different aspects of this snack wholesale business.
    • Constructed an access control management system that supports access control over any Boolean algebra expression in two control dimensions.
    • Designed and implemented a database schema to support business need including inventory management, dealer management, order management, marketing activity management, task management, user management, and sales management.
    • Established an ETL procedure to connect the database with different other sources to achieve sales management.
    • Developed a highly interactive single-page application for task management with Knockout.js.
    • Used ASP.NET Web Forms for most of the pages to ensure fast delivery.
    Technologies: CSS, HTML, JavaScript, SQL, ASP.NET Core, C#
  • Back-end Developer

    2016 - 2018
    EEDI
    • Built a REST API with C# under the Scrum methodology to enable fast and reliable delivery.
    • Constructed and optimized queries for SQL Server and Azure SQL database to provide highly concurrent services.
    • Provided data exchange and interaction logic for highly interactive pages in the front end with React and Redux.
    • Monitored and maintained applications on Azure including web app, database, workers, and Redis cache.
    • Monitored and maintained the web app and the database system based on Azure.
    Technologies: Azure, CSS, HTML, JavaScript, React, SQL, C#
  • Full-stack Developer

    2014 - 2016
    Barton Woodhead Education Limited
    • Built a web app used by more than 100,000 students from scratch.
    • Developed a database service layer with SQL Server.
    • Created a data access layer with .Net Entity Framework.
    • Constructed a business logic layer with C#.
    • Developed the front end with ASP.NET MVC, JavaScrip, HTML, and CSS.
    • Built some highly interactive pages with Knockout.js.
    • Provided visual data support for growth hacking analysis using Google Analytics, SQL, and Power BI.
    Technologies: CSS, JavaScript, HTML, Knockout.js, SQL, Model View Controller (MVC), ASP.NET MVC, .NET, C#

Experience

  • Diagnostic Questions (Development)
    https://diagnosticquestions.com/

    With a friend, I built an online assessment platform. It was just two of us developing the whole site from head to toe and we gained more than 100,000 users within two years.

  • Motorcycle Showroom for Customers to Check Detailed Specifications (Development)
    https://www.autotrader.ca/motorcycle-research/

    I built these motorcycle showroom pages to display all detailed specifications for all models available. The data comes from one of our partners. I built an automatic ETL process to get the data in, tweak the data to the desired format, and then service the data with a RESTful API.

  • Management Information System for a Wholesale Business (Development)

    I developed a management system for different aspects of a snack wholesale business, including inventory management, dealer management, order management, marketing activity management, task management, user management, sales management, and data analysis.

    It's an internal management system so it can't be shared.

  • Expert Level Bridge Player (Other amazing things)
    https://live.acbl.org/player-results/7184891

    Other than programming, bridge (a card game) is another passion of mine. I am an expert level bridge player who owns the title of life master in China. I also play many tournaments in Canada and the US and have won quite a bit of price.

    Talk to me if you also love bridge!

  • Winner of Mathematical Olympiad in China (Other amazing things)

    I won the Mathematical Olympiad in China in 2007 when I was in high school. This award means at mathematics; I was in the top 100 students (close to my age) in China.

Skills

  • Languages

    C#.NET, C#, JavaScript, SQL, TypeScript, HTML, HTML5, Java 9, CSS
  • Frameworks

    ASP.NET, .NET, ASP.NET MVC, MVC Razor, Knockout.js, .NET Core, Redux, ASP.NET Core
  • Libraries/APIs

    Entity Framework, LINQ, jQuery, React-JSS, React
  • Platforms

    Azure, Visual Studio Code, Azure PaaS, Google Cloud Platform (GCP), Amazon Web Services (AWS)
  • Storage

    SQL Server DBA, Microsoft SQL Server, Azure Cache, Azure SQL, Redis Cache, Azure Tables, Database Modeling, Azure Cosmos DB
  • Other

    Data, Software Development, Data Modeling, Data Architecture, AWS, Data Warehouse Design, Authorization, APIs, Async/Await, Data Warehousing
  • Tools

    Visual Studio, Google Analytics, SQL Server BI, Git
  • Paradigms

    Agile, Kanban, Scrum, Unit Testing, REST, Model View Controller (MVC), Business Intelligence (BI)

Education

  • Master's degree in Software Engineering
    2011 - 2014
    Tsinghua University - Beijing, China
  • Bachelor's degree in Software Engineering
    2007 - 2011
    Tsinghua University - Beijing, China

Certifications

  • Google Cloud Certified — Associate Cloud Engineer
    DECEMBER 2019 - DECEMBER 2021
    Google Cloud
  • Team Kanban Practitioner
    APRIL 2019 - PRESENT
    Lean Kanban University Certified Kanban Training Program

To view more profiles

Join Toptal
Share it with others