The business refurbishes IT equipment in three key areas: PCs/Laptops, AV, and Networking.
The current FileMaker Pro system handles order intake (goods-in), tracks unit-level details (brand, model, serial, spec, upgrades), manages engineering workflow (notes, statuses, ready-to-ship), and records shipping info. It also stores commercial data (purchase & shipping prices ex-VAT), supports basic reporting (daily/weekly outputs), and provides user-facing screens to process stock quickly.
This project migrates to a cloud-hosted MS SQL database with a custom internal web app: React (Tailwind + chart library) front-end and a thin API (Node/.NET) that serves data and KPIs. The UI must match or improve current layouts and support core KPI dashboards.
This scope includes Sections 1–3 only. Section 4 (automation, real-time P&L, AI) is not to be implemented now; a separate Technical Backdrop describes groundwork. Sections 1–3 must be built with future expansion in mind.
Section 1 – Core Migration to MS SQL
Objective: Recreate FileMaker logic and data in a normalized, indexed MS SQL schema, ready for API consumption.
Deliverables
Cloud-hosted MS SQL setup with least-privilege access control.
Logical data model & ERD (from FileMaker exports/screenshots).
Normalized schema with PK/FK, key indexes, and core views.
Full data migration (cleansing, transformation notes, reconciliation).
Interactive Task Tracker Development Category: Android, Frontend Development, IPhone, JavaScript, Mobile App Development, PHP, React.js, UI / User Interface, UX / User Experience, Web Development Budget: $30 - $250 USD
02-Oct-2025 22:03 GMT
Seven-Day Charity Promotion Category: Content Creation, Content Strategy, Digital Marketing, Facebook Marketing, Fundraising, Instagram Marketing, Research Writing, Social Media Management, Social Media Marketing, Social Networking Budget: $10 - $30 CAD
Quick Webinar Highlight Reels Editor Category: Adobe Premiere Pro, After Effects, Comedy Writing, DaVinci Resolve, Final Cut Pro, Video Editing, Video Post Editing, Video Services Budget: $30 - $100 AUD
Comprehensive Social Media Management & Content Creation Category: Content Creation, Digital Marketing, Facebook Marketing, Graphic Design, Internet Marketing, SEO, Social Media Management, Social Media Marketing Budget: $250 - $750 USD
Fun Vlog Video Editing for my brand Category: Adobe Premiere Pro, After Effects, Animation, Audio Editing, DaVinci Resolve, Final Cut Pro, Sound Design, Video Editing, Video Post Editing, Video Production Budget: ₹600 - ₹1500 INR
