B2B Supplier Portal
Modernized an enterprise procurement platform for Sheng Siong Group and CMM, unifying purchase orders, pricing, rebates, and invoices across 100+ vendors into a single operational system.
The portal supported procurement and financial operations for more than 100 vendors. As transaction volume grew into millions of records, heavy data ingestion workloads introduced bottlenecks and slower workflows across procurement and finance teams. The system needed a full redesign built around how teams actually operated in production.
“Growing transaction volume exposed bottlenecks that needed a system rebuild, not a patch.”
Owned the full-stack implementation across database, backend services, and frontend, starting with researching the legacy system workflows through direct collaboration with operational stakeholders.
Unified procurement and finance workflows
Replaced fragmented vendor processes with a single dashboard covering purchase orders, pricing updates, rebates, and invoices used daily by vendor, procurement, and finance teams.
Built vendor pricing update submission system
Collaborated with stakeholders to define price change rules and built three submission flows covering permanent price changes, promotions, and advertising campaigns, each with product selection and price change document upload.
Built procurement data ingestion pipeline
Designed and built a dedicated backend service that reads, validates, and transforms CSV, Excel, and PDF procurement files into structured database records, stores Excel and PDF files in AWS S3, and sends email notifications with processing results.
Designed database schema and optimized integration performance
Designed the full database schema to normalize procurement data across vendors, products, and transactions, optimized query performance to handle over 1M records, and reduced integration latency by 30%.
Redesigned permission model to match team responsibilities
Designed and enforced a four-tier access model covering Admin, Supplier Admin, Finance, and PO roles to ensure each team only accessed procurement and financial data relevant to their responsibilities.
Automated vendor account provisioning
Built a vendor onboarding flow that detected new vendors from integrated procurement data, triggered signup emails, and guided them through account verification to access their orders and financial workflows.
Led production deployment and technical handover
Wrote deployment documentation for AWS EC2, S3, and RDS across UAT and production environments, then supported the client team through project setup, deployment, and production issue resolution during the handover process.
100+
Active Vendor Accounts
Vendors using the platform across procurement and finance workflows
1M+
Transaction Records
Records processed across purchase orders, invoices, pricing, and rebates
30%
Query Latency Reduced
Achieved through MySQL indexing redesign and query rewrites
100%
Workflow Coverage
Procurement, pricing, rebate, and invoice workflows unified into one system
- 1
Observe before system design. Researching legacy workflows with operational stakeholders before writing any code clarified real process dependencies and shaped the entire system architecture.
- 2
Decouple ingestion from core services. Isolating data ingestion into its own service kept large procurement integrations from affecting the API performance that vendor and finance teams depended on daily.
- 3
Data modeling drives scalability. Designing the schema correctly from the start made handling millions of procurement records and maintaining query performance significantly more manageable as data volume grew.
- 4
Align authorization with operational structure. Mapping role boundaries to how procurement and finance teams actually divided their work prevented teams from accessing data outside their responsibilities.
- 5
End-to-end integration work builds deep operational knowledge. Building this platform gave me a clear understanding of how B2B businesses manage their day-to-day supplier workflows and why timely data updates are critical to keeping procurement and finance operations running accurately.