Full-stack Developer2018 - PRESENTTrader Corporation
Technologies: C#, SQL, React, Azure, HTML, CSS
- 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.
Full-stack Developer (Part-time)2017 - 2019Jianyi 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.
Back-end Developer2016 - 2018EEDI
- 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.
Full-stack Developer2014 - 2016Barton 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.
Database Automated Test Developer2013 - 2014China Software Testing & Evaluation Center
Technologies: SQL, C#
- 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.