2016_JD_backend_develpment

JD.com is a leading e-commerce platform in China. The JD convenience store BI project aims to provide data services for offline stores integrated with JD. In this project, I mainly played a role as a backend developer, performing the following tasks:

• Data Warehouse Construction: Using HiveSQL, I constructed the fact layer and dimension layer involving tables for orders, inventory, stores, and staff. Additionally, an aggregation layer was established to optimize data query performance. Using Sqoop, data was regularly synchronized to MySQL, ensuring real-time accuracy.
• Permission System & Retail Store BI Backend Development: Leveraged Spring Boot and MyBatisPlus to set up the project framework, simplifying database operations. Integrated with Spring Security, fine-grained permission management and core business logic were realized to meet customized requirements. To enhance query speed, a Redis caching strategy was implemented to optimize frequently queried data.