Certified FileMaker Pro Consultant MICHAEL EDWARD KUPIETZ

PROFESSIONAL SUMMARY

Claris-certified FileMaker Pro developer with 20+ years of experience in custom enterprise solution development, integrating with legacy databases, modern web technologies, and cloud infrastructure. Excels both as a lead developer and collaborative team member on multi-year projects for enterprise clients, managing production environments that process over 100,000 transactions monthly with 99.9% uptime. Agile learner known for creative problem-solving, excellent communication with nontechnical stakeholders, plus robust skills in systems administration and IT support. Currently seeking a permanent ongoing position or relationship.

TECHNICAL EXPERTISE

EXPERIENCE

Other Representative Long-term/Recurring Relationships:

• 3D Media Group (2002-Present) On-call Filemaker database and web development including event registration system supporting 800+ daily participants, office database development, and PHP template-based online website catalog
• Smith, Hampton & Devlin (1998-2015) On-call FileMaker database improvements and technical support for core business systems of staffing company
• Pacific Digital Image (full-time onsite 2002, on-call upgrades and maintenance 2003-2009) Authored and maintained FileMaker job ticketing system in 24/7 use at 50-workstation digital prepress house
• Liberation Prison Project (2006-2009) On-call FileMaker MIS development and support for nonprofit providing educational programs to incarcerated populace

REPRESENTATIVE PROJECTS

A comprehensive unabridged project history, broken down by type and business sector, is available on my website at https://www.kupietz.com/project-history/ .

Selected Database and Data Science , Modeling, and Automation Projects & Achievements:

• Advanced FileMaker Pro Stock & Options Trade Analysis & Management Platform
  • Architected sophisticated FileMaker-based trading system integrating multiple brokerage and financial analytical platforms
  • Developed original FileMaker-based oAuth implementation for stockbroker API authentication
  • Created automated risk management system handling position sizes up to $50K
  • Built interactive options risk visualization tools using custom JavaScript library integration with FileMaker webviewer
• FileMaker Pro Biotechnology Research Integrations
  • Developed automated PDF data extraction and collation for FDA-complaint pharmacovigilance reporting system processing 50+ monthly CIOMS forms for human cancer research trials
  • Created integrated scientific study data management platform and biotech research lab management systems, supporting development of a patent that later sold for $1B
  • Developed database for organizing and tracking stored human cell line samples in nitrogen-cooled freezers for cancer medication research & development
• FileMaker Pro Small Business & Nonprofit Projects
  • Designed & Implemented iPad-based CRM app for retail using FileMaker Go
  • Developed customer reservations, accounting, and office communications systems for adventure travel company
  • Inventory and invoicing system for movie prop rental house
  • Student placement system for nationwide non-profit exchange program
• Other Data Science, Modeling, and Automation (Files hosted at https://github.com/kupietools )
  • Liquidity Pool Simulator Microsoft Excel decentralized finance model simulating a Uniswap AMM liquidity pool, using exact calculations from Uniswap Core contracts. Observe pricing, slippage, liquidity pool token issuance, and impermanent loss transaction-by-transaction. Github Repo
  • Motley Fool Recommendations Performance Analyzer A Microsoft Excel financial model that allows you to analyze the track record of Motley Fool stock recommendations by varying execution parameters, to model the results of imperfect trade execution under real-world conditions Github Repo
  • Format FM Calc Automator Workflow A MacOS Automator wrapper for a classic BASH script to visually format FileMaker Pro calculations for easy readability, in any app in the system, even outside of FileMaker, using a system service Github Repo
• Other Data Science, Modeling, and Automation Projects & Achievements (These projects and others are available at https://github.com/kupietools )
  • Liquidity Pool Simulator Excel decentralized finance model simulating a Uniswap AMM liquidity pool, using exact calculations from Uniswap Core contracts. Observe pricing, slippage, liquidity pool token issuance, and impermanent loss transaction-by-transaction.
  • Motley Fool Recommendations Performance Analyzer An Excel financial model that allows you to analyze the track record of Motley Fool stock recommendations, to model the results of imperfect trade execution under real-world conditions
  • Home Assistant Lighting YAML-generator A card for the Home Assistant home automation server’s interface displaying the YAML config code for all current lights for easy scene creastion
  • Filtaquilla Mailbox Opener JS A Javascript Action filter action for use in Thunderbird’s Filtaquilla plugin to open folders in new windows when they receive new incoming mail
  • OS X Security Lock A context-aware BASH script to manage securely locking a MacOS user session, designed to be triggered by an environment monitoring utility
  • Terminal-Notifier Bridge for Thunderbird a MacOS BASH script to receive information from Thunderbird plugins and use it to display customizable notifications for incoming emails via terminal-notifier.app
  • Format FM Calc Automator Workflow A MacOS Automator wrapper for a classic BASH script to visually format FileMaker Pro calculations for easy readability, in any app in the system, even outside of FileMaker, using a system service

Selected Web Development and Server/Network Admin Projects & Achievements:

• Enterprise and Front-End Web Development
  • Authored node.js self-documenting automated Selenium WebDriver QA unit testing framework
  • Grew tour operator’s website from 7 static HTML pages to 150 interactive pages database-generated schedules and PERL customer testimonial boards, chat room, contact forms, and spam-prevention scripts
  • Developed jQuery-based Greasemonkey-compatible userscripts for complex web content filtering and functional enhancements to cryptocurrency research tools
  • Developed custom PHP webhooks for Twilio/FileMaker integration handling 1000+ monthly SMS communications
  • Created original PHP single-purpose web app framework for portable media asset management and integration with Google search
• WordPress Development
  • Developed extensive custom front-end functionality in PHP, HTML, CSS, and jQuery, receiving 100% Google Pagespeed Best Practices and Accessibility scores
  • Authored custom PHP function caching implementation using WP transients and object cache, leading to a 99% Google Pagespeed Performance score
  • Authored dynamic content generation plugins and shortcodes including complex media gallery customizations, custom permalink modification and redirects, and dynamic menu generation from category tree, and user-selectable content embedding templates via URL parameters which respect Content Security Policies via .htaccess rules
  • Authored complex back-end Admin UI modifications in PHP including automatic logging of updates to theme and plugin files and in-place renaming and downloading of PHP files from theme and plugin editor screens
• Server/Network Administration
  • Managed Windows Amazon AWS EC2 instances hosting FileMaker Server
  • Maintained in-house LAMP web server on Debian 12 VMware Fusion VM
  • Configured and managed SSL certificates, DNS, Cloudflare and Quic.cloud CDN integration
  • Managed & administered all hardware, software, & IT operations (computers, server, backups, & connectivity) for 13-workstation travel company
  • Maintained network connectivity (wifi, ethernet, & internet) throughout 5,000 sq. ft. coworking space using Cisco Meraki cloud-managed routers & access points

PROFESSIONAL CERTIFICATIONS

• Certified Expert FileMaker Pro App Developer Claris https://www.credly.com/badges/4946b237-c15f-44f7-a5bf-81763e61d506/public_url
• Certified Associate FileMaker Pro Server Administrator (top available FM Server certification) Claris https://www.credly.com/badges/2f913976-6607-4877-b2b4-ef3caeafc28a/public_url
• Certified Javascript Algorithms And Data Structures Developer FreeCodeCamp https://www.freecodecamp.org/certification/Kupietz/javascript-algorithms-and-data-structures-v8

ASSOCIATIONS & LEADERSHIP

• FileMaker Developer, Burning Man Festival Organization – Provided volunteer FileMaker support and training
• Group Discussion Leader, Berkeley Mac User Group’s FileMaker Pro Special Interest Group
• Teaching Assistant to electronic music pioneer Prof. Joel Chadabe, managing North America’s first Electronic Music Studio at SUNY Albany
• Active open-source developer on Github ( github.com/kupietools )