Project Overview

We revamped the existing data entry system for rental stores and enabled tenants to enter data directly. The new system consolidated the collection and processing of business data—such as sales and utility costs—significantly reducing manual work on the lessor’s side. For stores integrated with smart meters, we implemented monthly automatic retrieval of electricity usage, cutting input errors and processing time.

Technology Stack & Tools

• Programming Languages: C# 13, JavaScript, HTML, CSS
• Front-end Frameworks: Bootstrap 5.3.3, Alpine.js 3
• Back-end Frameworks: ASP.NET Core 9.0 (MVC), Entity Framework Core
• Database: Aurora PostgreSQL 14.6
• Cloud/Server/Infrastructure: AWS
• Task Management: Backlog
• Communication Tools: Backlog, Teams
• Other Tools: Serilog

Client Challenges

Because the lessor had been manually entering data based on each store’s reports, the following issues had surfaced:

• Increasing data entry workload
• High susceptibility to human errors
• Delays in aggregation and reporting, pushing back decision-making

Client Requirements

• Full replacement of the existing system
• Mechanism for tenant-side direct data entry
• Registration of routine data such as sales and electricity/water costs
• Automated monthly electricity data collection via smart meters (where applicable)
• Support for multiple report outputs
• Stable operation across multiple browsers, resolutions, and devices
• End-to-end ownership by our team: detailed design, implementation, unit testing, and integration testing

Our Proposal & Approach

• Closely read the requirements and visualized gaps to reflect them in design: We designed the information architecture to align with client intent and clarified input items, permissions, and workflows.
• Designed UI/UX to balance input efficiency and readability: We adopted lightweight interactions with Bootstrap and Alpine.js, and optimized responsiveness to ensure smooth operation on PCs, tablets, and smartphones.
• Built a robust server-side design: We implemented domain logic and data access with ASP.NET Core 9.0 (MVC) and Entity Framework Core, and normalized schemas on Aurora PostgreSQL 14.6 with attention to analytical query performance.
• Eliminated manual entry via smart meter automation: We set up scheduled jobs to fetch and validate monthly electricity usage, reducing copy-and-paste work.
• Accelerated issue isolation with structured logging and monitoring: Using Serilog with correlation IDs, we shortened the time to trace input errors and external integration incidents.
• Ensured stable operation through multi-browser and multi-device testing: We tested across major browsers (Chromium/Firefox/WebKit) and multiple resolutions/devices to remove layout and compatibility issues early.
• Delivered end-to-end from detailed design to integration testing: We handled detailed design, implementation, unit tests, and integration tests seamlessly, and prepared migration steps and training materials.