Personal details
Joseph A.
Summary
*** 30+ Years developing in FileMaker (started with FileMaker 3.0) Extensive experience working with a wide variety of industries including law, education, banking, retail, transportation, and real estate. ***
⢠Certified Developer (11,12) - Currently working on getting certified with new certificate program.
⢠Certified FileMaker Trainer by attending the âTrain the Trainerâ at the "Wedge" FileMaker (Santa Clara CA)
⢠Expert integrating FileMaker with Enterprise Level SQL based applications (MSSQL) interchanging data streams with SQL via ODBC, and using "Shadow Tables".
â˘Â Data import via Micro-services, JSON / RESTful API.
⢠Extensive experience importing exporting data via XML, XSLT, CSV, Excel, SQL
⢠Powershell integration via Troi-File plug-in.
⢠Experience working with a variety of External Plug-ins to communicate with QB and other resources (full list upon request)
⢠SOX and Agile development methodologies (DEV, BETA, UAT, PROD) via FM Data Migration tool and 360Works Deploy utility.
â˘Â JIRA, MS DevOps, Freshdesk for tracking projects. LastPass for storing passwords
â˘Â Security / Authentication via OKTA, Duo to AD
â˘Â Utilized FM "EAR" (Encryption At Rest) and secure all traffic with Certificates and SSL
⢠Heavily practice âAnchor-Buoyâ methodology to ensure code is standardized, and code is concise and legible.
â˘Â Strong understanding of writing and reverse engineering all sorts of FM solutions including custom functions
⢠Proficient working with plug-ins and extend FM capabilities.
â˘Â Practice Modular scripting and "re-usable" code.
I have a Portfolio showing interface and data architectural design upon request.
Work Experience
Continue the development of existing FM database that tracks Warner Media shows. Duties include support, develop, and expand existing FileMaker 19 solutions across multiple servers on East and West Coast.Practicing production, development and quality assurance environments (DEV, BETA, UAT, PROD). Tasks include: Developing new Tables, Layouts/UI Design, Scripts, Column fields and formulas using FMP19.x. Develop new and update existing reports. Exporting to PDFâs, Excel, CSV and XML/XSLT. Participate in daily and weekly âScrumâ style meetings. Using JIRA to track and manage tasks and progress. Reverse engineering sub-par written code and normalize structure to Anchor-Buoy methodology. Create software version and track releases. Produce and enhance documentation of solutions. Maintain âlivingâ document of changes and releases. Validate user reported bugs, reverse engineer, and implement âfixâ with releases. Provide enhancements to existing solutions and expand with new features. Provide direction and advise on new development with focus on scalable solutions. Using FMData Migration tool to promote files to each environment with latest data from PROD. Create emails with embedded âSnapShotâ link files to recipients for review. FileMaker Server Management - Schedules - Backup Routines (Clone/Verify) - Server Side Script Management - SSL Certificate removal/renewal and installation Secure data traffic and access using SSL Cert Encryption with AD and OKTA for file access and authentication within VPN tunnel.
Continue the development of an existing FM database that tracks real estate property loans. Utilizing Troi-File plug-in and BaseElements to extend the functionality of the solution. SQL data transfer / import / export with Enterprise Internal solutions.Integrated FileMaker database to utilize MSSQL Server 17 as a backend to FileMaker as a front end. Data integration of MSSQL utilizing ODBC driver and construct complex SQL Queries to update data in SQL Server tables utilizing UPDATE, INSERT SQL commands. Civic is owned by Pacific West Bank and must comply with SDLC and SOX. Yearly audits are conducted to ensure development, approval, and release of software is in compliance with SOX policies utilizing MS DevOPS to create, track PBIâs, and software releases through the different environments DEV, QA, UAT, and PROD. Utilize 360Deploy to migrate data through the different environments of DEV, QA, UAT, and PROD. Civic was sold to a private entity and laid off 150 people of the 200 employees.