Jordan McCarthy

Integrating production AI into Claris FileMaker solutions for small and medium businesses. Built an OpenAI-compatible local inference service (MLX and Ollama on Apple Silicon) that drives FileMaker 2025’s native AI script steps — semantic find, RAG, and embeddings — so client solutions gain natural-language search, document Q&A, and AI-assisted data processing while all data stays on the client’s own hardware. Developed natural-language-to-SQL querying for FileMaker data, backed by an automated 24/7 pipeline that generates and scores model training data, plus evaluation harnesses used to select and validate production models.

Rebuilt a production FileMaker system as a standalone Next.js/PostgreSQL web platform. Built retrieval-augmented knowledge systems on PostgreSQL with pgvector, including a semantic index over two years of development history. Runs multi-agent AI development workflows (Claude Code) with autonomous overnight build-and-review loops, and operates the supporting infrastructure: Cloudflare Tunnel and Pages deployments, launchd-managed services, and automated backups.

Worked with an aviation media publishing company producing industry-leading magazines. Migrated their core business processes from a shared Excel spreadsheet system to a custom FileMaker-based solution. Built a quoting/invoicing module, extended to a Web Direct application allowing clients to confirm order details via web-based forms. Developed a “Master Placement” module for admin staff to manage customer ad placements across multiple publications. The system also replaced Simply Accounting for the client’s accounting requirements. The project included consolidation of 5 different contact databases (over 130,000 records) into the new FileMaker-based system.

The Support Group is one of the largest FileMaker-only premium partner development companies in the world with locations in Boston, New York, San Francisco and Los Angeles. As a Developer based in Boston, worked with many clients building new solutions, enhancing existing solutions, maintaining solutions and installing hardware/software. One of 3 developers who built solutions adhering to Google Inc’s “material design” process. Worked with two Fortune 500 companies, a high school, a firefighters union, bed and breakfast and others.

Responsible for developing from concept to production custom business solutions. Worked with clients such as “Camp Kirk” on a custom Customer Relations Management application hosted in the cloud. Features include the ability to send HTML emails directly from the application, Web Direct access and many custom reports/exports. Responsible for maintaining server software/hardware, ensuring daily cloud backups and installing any necessary security updates (SSL certificates).

Created appropriate solutions to meet current and future needs of Greenwood College School. With consultation from stakeholders, developed, implemented, integrated, automated, and connected data systems. Performed system and network modeling, analysis, and planning. Responsible for working with the IT team, researching, and documenting solutions to streamline data process and management of the school’s data systems. Continued development/administration and training of the school’s custom Student Information System (S.I.S.)

Working directly with the V.P. of curriculum, developed from concept to production a customized Student Information System (SIS) based on a FileMaker Pro 11 platform. SIS includes complete admissions, reporting, attendance, family demographics, parent-teacher interview booking, teacher/course evaluation, calendar, auto enrollment and OUAC/OnSIS integration. Utilized different training methods including in person, online, and video tutorials. Contributed to decision process on future technology solutions.

Instructor for AVIS 216 – Building Dynamic Web Pages. Topics included JavaScript scripting, JavaScript form validation, server-side scripting using PHP, server-side validation using PHP, introduction to SQL database design. The final project required students to build a PHP/MySQL content management system.

As head Administrator of PowerSchool, responsible for initial deployment (server/software), general administration and developing Ministry of Education required reports. Coordinated and performed training for Principals, Administrative Staff, Teachers, and Students. Platform based on SQL backend, Apache Web server and custom XML/HTML pages. Developed JavaScript-based validation scripts ensuring correctly formatted data entry.

Also developed database applications using FileMaker Pro, including an “Issue Tracker” application with FileMaker Pro Mobile for on-site technicians. Multi-user application allowed school board members to track and manage technical issues.

Developed e-commerce solutions built on Propel’s custom internet infrastructure platform. Developed all search components and order management areas. Responsible for conversion from traditional “JSP/Servlet 1.0 architecture” to the “Struts/Template” Framework. Worked directly with the Usability group and Core Engineers.

Co-developed ~ePortal services, an Internet application allowing clients to subscribe to modules such as e-commerce, message board, and Trading Post. Developed an issue tracker internet application for Nortel Networks. Lead programmer for web-based interactive projects.

Promoted to head network Administrator in January 1997. Supervised all technicians ensuring productivity and service levels. Implemented new Macintosh OS network system. Responsible for maintenance of a computer lab network running Windows NT 4.0 server and workstation.

Troubleshooting clients’ computers and determining solutions, repairing computer hardware and software, supporting clients on technical issues, answering Firstline support line and ordering service modules on Apple’s Aris network.