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).
Create c-suite LinkedIn Profile Category: Article Writing, Business Writing, Content Writing, Copywriting, Creative Writing, Digital Marketing, Lead Generation, Marketing Strategy, SEO Writing, Social Media Management Budget: $10 - $30 CAD
Instagram Reels Video Editor Category: Adobe Premiere Pro, After Effects, DaVinci Resolve, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: €8 - €30 EUR
17-Jan-2026 11:00 GMT
Dental Ad & Landing Page Design Category: Advertising, Branding, Digital Marketing, Graphic Design, Logo Design, Photoshop, Web Design Budget: £20 - £250 GBP
17-Jan-2026 11:00 GMT
College Hoodie Artwork Design Category: Adobe Illustrator, Graphic Design, Illustration, Logo Design, Photoshop, Print Design, T Shirts, Vector Design Budget: ₹1500 - ₹12500 INR
17-Jan-2026 10:58 GMT
Orthodontic Aligner System Branding Category: Advertising, Branding, Digital Marketing, Graphic Design, Illustration, Logo Design, Web Design Budget: £20 - £250 GBP
Traditional Wedding Photography Needed Category: Album Design, Graphic Design, Image Processing, Lighting Design, Photo Editing, Photoshop, Social Media Marketing, Video Editing Budget: ₹12500 - ₹37500 INR
17-Jan-2026 10:55 GMT
Single-Story Extension Plans Category: 3D Design, Architectural Rendering, AutoCAD, Building Architecture, Drafting, Home Design, Interior Design Budget: €250 - €750 EUR
17-Jan-2026 10:55 GMT
Google Sheets Finance Templates Builder Category: Data Analysis, Data Entry, Data Visualization, Excel, Financial Analysis, Google Sheets, PHP, Visual Basic Budget: €250 - €750 EUR
