Certified FileMaker Pro Consultant MICHAEL EDWARD KUPIETZ

PROFESSIONAL SUMMARY

Claris-certified FileMaker Prolow-code/no-code and full-stack web developerDeveloper and administrator with 20+ years of experience in IT support, custom enterprise solution development, integrating with legacy databases, modern web technologies, cloud infrastructure, as well as custom development for content management frameworks such as WordPress. Currently seeking reliable long-term, ongoing or permanent opportunities. 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 experience in systems administration and IT support, with server and network admin experience.

EMPLOYMENT HISTORY

REPRESENTATIVE PROJECTS

These are a representative sample of other successfully completed 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
• Enterprise FileMaker Pro Low-Code/No-Code Biotechnology Research Database 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 Low-Code/No-Code Small Business & Nonprofit Projects
  • Designed & Implemented iPad-based CRM app for retail using FileMaker Go
  • Designed & Implemented customer reservations, accounting, and office messaging apps for adventure travel company
  • Designed & ImplementedInventory and invoicing system for movie prop rental house
  • Designed & Implemented 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 (github.com/kupietools/mekphrame-automated-web-testing)
  • Grew tour operator’s website from 7 static HTML pages to 150 interactive pages including FileMaker database-generated schedules, and PERL customer testimonial boards, chat room, contact forms, and spam-prevention scripts
  • Developed complex jQuery-based Greasemonkey-compatible userscripts for sophisticated, generlized web content filtering (github.com/kupietools/webcooler-userscript) and functional enhancements to cryptocurrency research tools (github.com/kupietools/DYORassistant)
  • 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 (Currently demoed as a custom web fact-checking tool, github.com/kupietools/BS-Detector)
  • Authored javascript-based “retro computing”-style terminal emulator for browsing web via innovative command line interface front end (michaelkupietz.com/cli.html)
• 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 and page caching implementation using WP transients and object cache, leading to a 99% Google Pagespeed Performance score
  • Authored 15+ custom WordPress plugins (See Github repos at michaelkupietz.com/?p=29547)
  • Authored dynamic content generation 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
  • Administered Windows Amazon AWS EC2 instances hosting FileMaker Serverservers & backup systems for a broad variety of businesses
  • Solely set up and administered LAMP web server running on Debian 12 VMware Fusion VM for several years, including all server setup and maintenance, public-facing network connectivity, and uptime monitoring
  • 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 office for 15 years
  • Solely provided end-user support and maintained all hardware and network connectivity (wifi, ethernet, & internet) throughout 5,000 sq. ft. coworking space using Cisco Meraki cloud-managed routers & access points for 18 months
  • Provided as-needed technical support and IT consulting for a broad variety of businesses on an on-call basis

  Windows servers & backup systems for a variety of businesses

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
• Unqork Novice Configurator Unqork https://www.credly.com/badges/6110e683-a8c4-4ce1-bf4c-d956dc38285b/

ASSOCIATIONS & LEADERSHIP

• FileMaker ProLow-Code/No-Code Developer, Burning Man Festival Organization – Provided volunteer FileMaker development, support and training
• Group Discussion Leader, Berkeley Mac User Group’s FileMaker Pro Special Interest Group
• Actively involved in Indieweb Homebrew Website Club (events.indieweb.org/tag/hwc) developer groups on a regular ongoing basis, giving demos and participating in developer discussion sessions
• Active open-source developer on Github ( github.com/kupietools )
• Three semesters Electronic Music Studio Manager and Teaching Assistant to electronic music pioneer Prof. Joel Chadabe, managing and instructing students in new Mac-based MIDI system at North America’s first Electronic Music Studio at SUNY Albany

TECHNICAL EXPERTISE