Custom Software Development · Web Application · UI/UX Design · Database Architecture · API Development
Built a bespoke CRM platform for an OOH advertising agency to manage campaigns, inventory, and client relations.
• Designing a complex MySQL database schema to manage multifaceted data, including ad space locations, availability calendars, pricing tiers, and campaign-specific assets.
• Creating a highly functional and intuitive UI with Next.js and Material-UI that allows staff to search, filter, and visualize inventory, including map views.
• Building a secure, efficient backend API for client management, contract generation, and inventory booking.
• Developing a comprehensive dashboard for real-time visibility into campaign status, revenue, and inventory utilization.
• Engineered a scalable Node.js/Express backend with REST APIs over a carefully modeled MySQL database.
• Built a modern web app frontend with Next.js, React, and Material-UI to deliver a desktop-like experience in the browser.
• Prototyped flows in Figma to validate complex workflows before implementation; used Postman for API testing.
• Deployed on AWS/Vercel; used cPanel for auxiliary services such as company email.
• Frontend: Next.js, React, Material-UI for fast UI and data-heavy views.
• Backend: Node.js/Express with MySQL for inventory, booking, and reporting.
• Process: Figma prototypes, Postman-tested APIs, CI-friendly deployment to AWS/Vercel.
• Capabilities: inventory management, campaign scheduling, contracts, and analytics dashboards.
Book a 20-minute discovery call. You leave with a clear map of what the right architecture can do for your business.
Book the discovery call ↗