Stoney Point Software

Situation: Manufacturing client Ironsmith had 15 years of business-critical data locked in a legacy Microsoft Access system with a complex, inconsistent schema.

Task: Migrate hundreds of thousands of rows—many with broken or outdated relationships—into a modern AWS-hosted PostgreSQL database.

Action: We built a migration pipeline to extract CSV data from Access, clean and reconstruct relationships, validate against a local PostgreSQL schema, and deploy with a one command script to AWS.

Result: Seamless launch of their new system with all historical data intact and cleanly structured—no downtime, no data loss.

Situation: Manufacturing client Ironsmith's previous agency left their modernization project incomplete, leaving critical gaps in business systems and no integration between their internal tools and customer website.

Task: Deliver an end-to-end solution: a custom business portal, an integrated WordPress site, a desktop app for on premise server file access, and a full migration from legacy systems.

Action: We built a cloud-based portal with complex quote workflows, developed a public-facing site synced to product data, created a desktop bridge app for opening server files in native programs, and migrated 15+ years of legacy data from Microsoft Access to PostgreSQL.

Result: Ironsmith now manages quotes, orders, and internal data seamlessly with full control over product presentation and file access on a new system that does not crash and has 24 hour support.

Situation: A home remodel company in Long Island used handwritten notes and manual spreadsheets to prepare quotes, often taking multiple days to finalize and send estimates to clients.

Task: Maintain the flexibility of Google Sheets but drastically reduce turnaround time and deliver polished, professional PDFs that matched the company's branding.

Action: We built a custom quoting system with all their product and pricing data, a script that auto-generates a filled out, branded PDF from the company's Google Sheet estimate, pulling in all data and line items seamlessly.

Result: What used to take days now takes just a from a few minutes to at most a couple hours. The company sends out professional estimates with a very budget friendly price tag.

Situation: Manufacturing client Ironsmith needed users to open project folders from their browser app into Windows File Explorer—just like their legacy Microsoft Access system.

Task: Create a seamless bridge between a modern web portal and an on-site file server without sacrificing cloud benefits.

Action: We built a lightweight Python desktop app using PyQT that could be triggered from the browser, enabling users to open local folders in File Explorer and launch native apps like AutoCAD.

Result: Users retained critical desktop file access while benefiting from all the advantages of a modern web-based system.

Situation: A contractor was juggling lead data between Angi, Facebook, Google Forms, and their quote creation software. Manual entry slowed down their team and introduced errors sometimes even causing them to miss incoming leads.

Task: Seamlessly integrate incoming leads from Google Forms and Angi into their CRM (Pipedrive), while ensuring all systems—including Slack and their custom quoting tool received the relevant data automatically.

Action: We built an integration pipeline that connects Google Forms and Angi's API to Pipedrive. From there, the data flows into their internal quote management system and triggers Slack notifications to the sales team.

Result: The sales team now gets real-time alerts and can track leads from intake to project without touching a spreadsheet. No more double entry or lost leads.

Situation: The client's interior design team used Excel based vision boards to show FF&E (furniture, fixtures, and equipment) selections to customers. Gathering approvals and processing purchases involved back and forth emails, purchase orders, and manual customer signoffs causing delays and friction.

Task: Create a streamlined, interactive shopping cart experience from Excel based vision boards that allows customers to review, approve, and pay for items directly—reducing revision cycles and manual processing time.

Action: We integrated GatherIt, an FF&E specification tool, with a custom frontend shopping cart. Designers could upload product selections from Excel, and customers could instantly give feedback, request changes, or proceed to checkout and payment, all in one place.

Result: The revision process was cut from weeks to days. Customers could easily approve or decline items, and designers could instantly update the cart. The checkout flow replaced traditional purchase orders and signatures, making the entire process smoother for their customers and staff.