I am Ronnie Serr
I am a web technologist –
- Database Designer
- Front-End Web Developer
- API Integrator
- Web Platform Consultant
My goal is to create, improve and maintain data systems.
Phone +1-323-939-1669
Email ronnie@alphabethouse.com
The data structure of a solution is its foundation. FileMaker Pro, MySQL, SQL Server, MongoDB. I'm comfortable around Unix, Mac and Windows servers, shell programming, repository management and code sharing Github.
In the age of mobile computing, Single Page Applications offer the best performance and most elegant interfaces. HTML, CSS, JavaScript. API integration. I'm planning to dive into Progressive Web Applications.
API First approach enables a data infrastructure that allows for flexibility, scalability and performance. Zapier, Zoho Flow offer useful automation flows. Previously, I built API servers from scratch in PHP. I have worked in Node.js, Node RED. Integrated Twilio, payment and shipment systems.
Migration of local data systems to the cloud presents multiple challenges in data structure, data integrity, data hygiene, workflow efficiency and future integrations. I have spent much time migrating legacy data systems to Zendesk and to Zoho CRM and Zoho Finance.
Create custom apps, workflows and extensions to integrated solutions. Zendesk Apps and custom forms. Zoho CRM, Zoho Creator, Zoho Flow. In the past, I have worked extensively in Wordpress, Drupal and Joomla, including plugin development.
Breaking down assignments into manageable and testable chunks. Converting confusion and data chaos into more order and clarity. Representing complexity visually through charts. Bridging between managers, administrators and technical experts to make for better team interactions.
Can take a loosely defined projects and run with them independently.
Happy to collaborate with multiple team members on specific tasks.
Love to understand how things work at the root.
Can master a platform's documentation and apply it.
Invest in discovery, background and objectives.
Focus always on the main objective.
Committed to the project at hand.
Value simple decency and productive teamwork.
I spend a day or two per week to keeping updated in many areas.
Currently exploring IoT, cloud computing especially serverless functions, blockchain technology and conversational bots.
Verbal and written communication fluency.
Focused on clarity, precision and usability.
Fascinated by under the hood intricacies.
Presenting complexity in a simple and comprehensible way.
Intrigued by the complexity and inner connections of data flows
Serving accounts for many years:
Specified Technology -- 18 years, DuMOL -- 12 years, Sauer Properties -- 12 years.
2016 - 2018
Served as a Technical Lead on a migration from a home-grown FileMaker solution, to Zoho CRM, Zoho Finance and VineSpring eCommerce platform.
Specialized Technologies (STI Firestop)
2015 - 2016
Migrated a proprietary support management system into Zendesk.
Specialized Technologies (STI Firestop)
2000 - 2006, 2014 - 2017
The UL-System search provides a progressive system. The Submittal Builder lets the users select a number of UL Systems with data and safety sheets into one PDF document.
Specialized Technologies (STI Firestop)
2015 - 2017
A company-wide user entry and dashboard, including internal authentication of employees via LDAP, instant, daily and weekly notifications for sales and regional managers, submittal history and Zendesk ticket integration.
2013 -
Help restructure data entities on FileMaker Pro database solution that runs the business. Improve input screens, income and expense reports. Automate billing and renter communication via Twilio messaging.
FileMaker Discussion Group of Southern California
2013 - 2018
Presentations on FileMaker-related topics, including
2016 - 2017
Set up webhook listeners for automatically recording medical test results in FileMaker. Using SOAP Webservices and PHP.
2016
Set up broadcast SMS services for a summer camp to update parents with bus schedules through CDyne. Web service integrated with FileMaker.
Association for the Accreditation of Surgical Facilities
Development work: 2009 - 2011
Software Development Lead @ Specified Technologies
"Many of the web applications that are found on our website (www.stifirestop.com) have been projects that Ronnie has been the developer... Ronnie has produced a solution that gives the user the ability to sort through thousands of published designs and narrow it down to the exact one that is needed... We have been involved with many external developers, but Ronnie has been with us the longest due to his work ethic, attention to detail, high level of support, and ability to work within a team. We would highly recommend him to anyone seeking to add value and expertise to their development team." Full Text.
Owner @ Sauer Properties
"Ronnie and I worked together in developing a Property Management System for Sauer Properties. We manage 1250 apartments. Our system is the reason for our success... Ronnie’s expertise and creativity has made our operation so efficient that we have grown painlessly every year. All of our work orders, phone and text communication, renter information and accounting are managed and backed up in the cloud. This all works seamlessly together thanks to Ronnie." Full Text.
Executive Vice President @ Specified Technologies
"Ronnie has also produced a number of web-based tools designed to allow our customers to easily determine the amounts of various products required for their projects... We value Ronnie as an important part of our development team. He has always been responsive to our needs. His insight and work ethic are unmatched, providing solutions that our competition envies. We consider Ronnie to be part of the STI family and would highly recommend him to anyone seeking to add value to their development team." Full Text.
Director of Technology and Courseware Development @ Cengage Learning
"Ronnie is a take-charge person who has gained a solid understanding of our business over the years. When developing new solutions for us, he always uses his knowledge of our business to come up with an acceptable business solution, instead of merely a technical solution. He is also able to clearly present his ideas to business stakeholders as well as communicate the benefits... I highly recommend Ronnie for any contract development work specific to his areas of expertise. He is a team player and would make a great asset to any organization." Full Text.
Site Producer @ Sunlight Productions
"Ronnie joined our team during a transition period when we moved from a Drupal site to Ruby on Rails. Effortlessly adapting into our work environment, Ronnie was successfully able to work within existing code, understand an extremely complicated network, and provide solutions to help us move forward. He did a great job documenting his work and ensuring that everyone involved with the project could stay well informed. There is no doubt that had we not brought Ronnie on, this transition would not have been as seamless." Full Text.
Director of Operations @ USC Shoah Foundation Institute
"Ronnie is a very skilled and experienced web developer. He also has great responsibility and is easy to work with. Even though, Ronnie was hired to work on a project that was left unfinished (and poorly built) by another vendor, he was able to turn it around. Ronnie took the time to analyze the issues and explained them to us and also proposed the correct course of action. He then continued to work on the website in a very quick and efficient matter and his (programming) work is of high quality. Ronnie also did a great job at documenting his work and reporting progress, so everyone involved in the project stayed informed." Full Text.
STI Firestop are innovators in the fire protection industry. Firestop systems are tested sets of attributes of products and their use properties. This intelligent system search considered by many the best in the industry.
Stack HTML, CSS, Bootstrap, Javascript, PHP, MongoDB, MS SQL, PowerShell
Date 2014 - 2017
A Single Sign On system that lets users access a company dashboard with reports and resources.
Stack HTML, CSS, Bootstrap, Javascript, PHP, MongoDB, MS SQL, PowerShell
Date 2015 - 2017
An offline product and systems editor that prepares JSON system and menu files for the online System Search & Submittal Builder.
Stack FileMaker Pro
Date 2014 - 2017
Helped to enhance a FileMaker system that runs the business. Add interactive website, FileMaker workflows, integrated SMS services for payment, service and notification, automated payments, etc.
Stack FileMaker, PHP, HTML, CSS, Bootstrap, Javascript, Twilio
Date 2016
This Node RED application receives customer and order webhooks from the eCommerce solution, stores them, and then sends them to the Zoho CRM in a rate that it can received.
Stack Node.js, Node RED, HTML, CSS, Angular, Javascript, MongoDB
Date 2018
These charts describe the data elements in the migration target.
Stack OmniGraffle, Google Drawings
Date 2017 - 2018
Charts for planning PHP classes that automate the integration between STI and Zendesk.
Stack OmniGraffle
Date 2016 - 2017
A series of presentations at the Los Angeles FileMaker user group FMDiSC on a variety of topics. The series "FileMaker talks Cloud" featured presentations on IoT integration, webhooks, consuming API's and Blockchain technologies.
Stack FileMaker, PowerPoint, PHP
Date 2014 - 2018
