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




Vancouver, BC, Canada



Preferred Environment

Visual Studio, Git

The most amazing...

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


  • 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: C#, SQL, React, Azure, HTML, JavaScript
  • 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 pages to ensure fast delivery.
    Technologies: C#, ASP.NET Core, SQL, JavaScript, HTML, CSS
  • Back-end Developer

    2016 - 2018
    • Built a REST API with C# under 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: C#, SQL, React, JavaScript, HTML, CSS, Azure
  • 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: C#, .NET MVC, SQL, Knockout.js, HTML, JavaScript, CSS
  • Database Automated Test Developer

    2013 - 2014
    China Software Testing & Evaluation Center
    • Built automated tests for database performance testing.
    • Developed an ETL module for loading the data into the testing database.
    • Created an interface to support multiple databases in different platforms.
    • Established error handling and detailed logging for the automated testing tool.
    • Evaluated the performance of various databases and different schema settings.
    Technologies: SQL, C#


  • Diagnostic Questions (Development)

    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)

    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)

    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.


  • Languages

    C#, JavaScript, SQL, HTML, HTML5, Java 9, CSS
  • Libraries/APIs

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

    Azure, Visual Studio Code, Azure PaaS, Google Cloud Platform (GCP)
  • 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, Authorization, APIs, Async/Await, Data Warehousing
  • Frameworks

    .NET, ASP.NET MVC, MVC Razor, .NET Core, Redux, ASP.NET Core
  • Tools

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

    Agile, Kanban, Scrum, Unit Testing, REST, Business Intelligence (BI)


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


  • 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