Tim Dietrich

I'm an experienced information technology professional that is currently specializing in the promotional products industry. I help distributors and suppliers innovate and grow by implementing PromoStandards, integrating their systems, developing highly customized software solutions, and more.

Summary of Qualifications

• More than 20 years of Information Technology experience serving as a software developer, consultant, and developer evangelist.
• Bachelor's Degree in Computer Science, with a concentration in Information Systems.
• Exceptional database-related skills, including design, development, administration, security and authorization, backup and recovery, installation, and maintenance.
• Proven ability to document work, and to provide clear and professional technical evaluations and specifications.
• Ability to understand complex business requirements and translate them into technical designs.
• Published author, with excellent written and oral communication skills.

Technical Skills

Database Systems:
• Airtable
• Amazon Aurora
• DB2
• FileMaker
• MySQL
• Oracle
• SQL Server

Programming Languages:
• ColdFusion
• CSS
• HTML
• JavaScript
• PHP
• SQL
• SuiteScript
• Swift
• T-SQL
• TVML / TVJS
• Xojo

ERP & Accounting & Systems:
• Lawson
• NetSuite
• Solomon

Specialized Skills:
• Extensive experience with PromoStandards.
• Development of Apple TV apps using TVML, TVJS, TVMLKit, and Swift.
• Experience with Amazon Web Services (AWS), including Elastic Compute Cloud (EC2), Relational Database Service (RDS), and S3 (Simple Storage Service).
• Design and development of specialized Web applications, including APIs, custom search engines, spiders / bots.
• Integration with payment processing systems, including PayPal, Authorize.net, and Stripe.
• Integration with FedEx and UPS shipping systems.

Professional Experience

Founder / Developer
Promo.zone
Richmond, Virginia
July 2018 to Present

I developed Promo.zone to serve as an example of what developers can create using PromoStandards. It's a search engine that provides fast, easy access to detailed information on thousands of promotional products. The site was built with and is maintained using PromoStandards services from some of the industry's leading suppliers. Promo.zone also provides services that help distributors and suppliers put PromoStandards to work.

Independent Software Developer
Richmond, Virginia
April 2008 to Present

I develop custom software and commercial applications. My clients range from small businesses to government agencies to Fortune 50 organizations, and include the Library of Congress, Siemens, CarMax, the University of Virginia, and many more.

• Developed PromoStandards-based services for a promotional products supplier provide that integrates with their FileMaker-based inventory and fulfillment system.
• Helped to implement, customize, and integrate NetSuite for a promotional products distributor.
• Developed a custom e-commerce solution for a promotional products distributor that is used to sell and manage marketing services for Virginia welcome centers and rest areas.
• Developed a custom legal / medical case management system for a medical funding solution provider.
• Developed a custom time tracking and project management system for the creative services department of Dominion Energy.
• Developed a custom mobile application for Siemens Industry (Building Technologies) that is used by technicians to inspect and repair large HVAC systems.
• Developed a custom internship management system for the University of Virginia's internship program.
• Developed a custom project management system for Carmax's creative services team.
• Developed a custom logistics system for a company that manages the construction of cruise ships.
• Developed a custom legal case management system for the Library of Congress.

Developer Evangelist
Airtable
Richmond, Virginia and San Francisco, California
June 2015 to May 2016

Briefly served as the Developer Evangelist for Airtable, a cloud collaboration service headquartered in San Francisco. Helped developers use Airtable's API, created technical content for the company's blog and community forum, hosted webinars, developed demo applications that use Airtable's API, assisted users, and more.

Senior Developer
Target Marketing
Richmond, Virginia
November 2006 to April 2008

Designed and developed custom database and Web solutions for this value-added promotional products company. Solutions developed included fulfillment and inventory control systems, project and job management tools, a custom contact system, highly specialized e-commerce solutions, and more.

• Developed a custom fulfillment and inventory control system in FileMaker.
• Developed various custom Web-based solutions that integrate with FileMaker and MySQL.
• Integrated FileMaker-based applications with the company's SQL Server-based e-commerce system ("Nova") and accounting system ("Solomon").
• Helped to maintain the company's multiple FileMaker Server instances. Responsibilities included server monitoring, backup scheduling, etc.
• Maintained legacy applications developed in FileMaker Pro 5 and 6.
• Managed large scale SQL Server 2000 to SQL Server 2005 upgrade project.

Contract Database Consultant / Developer
Dulles, Virginia
August 2006 to November 2006

Migrated a complex FileMaker Pro-based inventory management system from the FileMaker 7 platform to the FileMaker 8 platform. The project involved redesigning the application to take full advantage of the latest FileMaker technology and feature set, as well as consolidating the original multi-file solution into fewer physical files, and implementing a data separation model.

Contract SQL Developer
Sprint / DHSoft Inc.
Herndon, Virginia
May 2006 to August 2006

Worked with a team of developers and business analysts to support databases that distribute targeted customer data to a number of CRM applications. This data was used to deliver and track the effectiveness of proactive, reactive, and cross-sell promotional offers.

• Automated the load, validation, and processing of customer response data from external vendors.
• Developed SQL jobs to migrate data from production servers to development and testing environments.
• Worked with large SQL databases (millions of records), in a multi-database (SQL Server and Oracle) environment.
• Helped establish database standards and best practices for the SQL Server development team.

Founder / Database Consultant
Xgravity
Dulles, Virginia
May 2000 to April 2006

Developed custom database solutions for clients in a wide variety of industries. Services provided included database design (requirements analysis, data modeling, normalization), database development (scripting, stored procedures, triggers, user-defined functions, and complex queries), database administration (performance tuning and optimization, security and authorization, backup and recovery, installation, and maintenance), web application development, and related services.

• Developed a lead generation and processing system for a marketing firm that services the mortgage industry. The database included detailed personal and financial information on more that 8 million homeowners.
• Developed a custom Web content management system for a prestigious private university.
• Developed a custom inventory management system for a jewelry wholesale company.
• Developed a custom business system for a skilled labor employment agency.
• Developed a custom telemarketing solution used to track sales, prospects, and employee compensation for a call center operation.
• Developed a system used by a large manufacturer of automotive products to manage their employee incentive program.

Senior Analyst
Bell Industries, Inc.
Richmond, Virginia
August 1999 to May 2000

Developed and implemented a comprehensive, integrated e-commerce strategy for this multi-regional, multi-industry corporation. Bell's primary business is Bell Tech.logix, a provider of integrated technology solutions for large and medium-sized organizations.

• Designed, developed, documented, and implemented various browser-based applications, including sales, quoting, management, and reporting tools. Applications were developed using FileMaker Pro, ColdFusion, Microsoft SQL Server, and DB2/400.
• Developed a browser-based reporting system that integrated with the corporate ERP system.
• Developed a data archiving system to provide authorized corporate users with access to historic sales and financial data previously stored in the corporation's mainframe system.
• Managed a team of web developers and designers, and established coding and documentation standards, workflow procedures, etc.

Software Engineer
Xperts, Inc.
Richmond, Virginia
February 1999 to August 1999

Developed custom database solutions for clients in various industries. Xperts is a Richmond-based computer consulting firm.

• Developed a ColdFusion-based project management tool for The Weather Channel.
• Developed a FileMaker-based product catalog for the lighting division of General Electric.
• Assisted Web development team with database-related issues, including modifications to database schemas and development of SQL scripts, stored procedures, queries, etc.

Web Developer / Integrator
Outpost.com
Kent, Connecticut
September 1998 to February 1999

Developed e-commerce solutions and Web-based applications for this high profile computer products company. Outpost.com (formerly "Cyberian Outpost") is a global Internet retailer of computer products. Work included:

• Used Broadvision One-To-One application system to build dynamic Web pages that were personalized to correspond to a user's profile.
• Developed client-side Javascript to validate forms and enhance the user's overall experience.
• Developed complex SQL queries to integrate data from Oracle databases.
• Designed and developed a FileMaker / browser-based project management and bug tracking system for use by the development and creative services teams.

Education & Certifications

Bachelor of Science / Computer Science
Information Systems Concentration
Towson University

Evernote Business Certified Consultant
Evernote Corporation

FileMaker Certified Developer
Versions 9, 10, 11, 12, 13
FileMaker, Inc.

Microsoft SQL Server Certification
Northern Virginia Community College

Publications

2017 ICD-10-CM Code Reference Guide for Mental, Behavioral and Neurodevelopmental Disorders: Codes F01 thru F99
Self-Published
July 2016

ICD-10-CM Code Reference Guide: Books 1 - 21
Self-Published
March 2015

FileMaker Pro 13 Absolute Beginner's Guide
Que Publishing
December 2014
ISBN-10: 0789748843
ISBN-13: 978-0789748843

The NeXT Computer
Association for Computing Machinery
ACM SIGSMALL/PC Notes, Volume 15 Issue 3
August 1989

Commercial Solutions & Applications

Keplr TV
An Apple TV app that provides access to classic science fiction movies.

The Unlikely Story
An Apple TV app that tells the story of artist William Girven, and his journey from homelessness to prominence.

Carbon Leaf
An Apple TV app for Richmond, Virginia-based indie-rock band Carbon Leaf. The app includes videos of the band's live performances, interviews with band members, music, and more.

ICD-10 Research
An iPhone app that makes it easy for healthcare professionals to locate ICD-10-CM (diagnosis) codes.

Mandala Meditations
An Apple TV app that provides access to mandala animations set to music. The app is used as a means of relaxing mind and body.

Full Disclosure
An iPhone app that provides access to the public disclosures that have been filed with the U.S. Securities and Exchange Commission (SEC).

Gov Opps
An iPhone app that helps users discover employment opportunities that are available with federal, state, and local government agencies across the United States.

Open Source Solutions

Aloe Express
Aloe Express is a powerful, easy-to-use, open source Xojo Web server module. Build APIs, microservices, Web sites, and more.

Aloe Express Airtable Add-On Module
Provides easy access to databases created with the popular cloud-based database service of the same name. The module provides you with classes that can be used to retrieve, create, update, and delete records in Airtable bases.

Aloe Express Key-Value Store Add-On Module
Provides developers with an extremely fast in-memory key-value API. It's ideal for caching, managing sessions, and rapid development. With this module, you can quickly and easily generate a RESTful API based on a JSON file, save the KVS to disk, and more.

Aloe Express Luna Express Add-On Module
Luna Express is a redesigned version of the original Luna API framework that has been specifically designed for use with Aloe Express. It accelerates the creation of RESTful APIs for SQL databases by simplifying the development of endpoints for CRUD operations. Luna Express supports several popular database types, including MySQL, SQLite, Amazon Aurora, and more.

Aloe Express XFM Add-On Module
With the XFM module, developers can easily integrate your apps with hosted FileMaker databases. This version includes support for containers, and is now fully unlocked.

Temper
Temper is a Xojo-based Web API framework for hosted FileMaker databases. With Temper, you can make API calls to create, read, update, and delete records, run scripts, work with containers, and more.

fm.swift
fm.swift is a class that maps commonly used FileMaker functions to Apple's Swift programming language.

FM Authenticator
FM Authenticator is an open source two-factor authentication (2FA) solution for the FileMaker platform. It helps developers enhance the security of their FileMaker solutions.

FM Containers
FMContainers is a Web application that makes it easy to serve up files that are stored in FileMaker containers.

FM EasyAPI
FM EasyAPI is a PHP-based Web application makes it easy to setup simple, REST APIs for databases hosted with FileMaker Server.

FM EasyAudit
FM EasyAudit is an open source auditing solution for the FileMaker platform. With EasyAudit, you can easily log changes that are being made to data in your FileMaker databases.

FM EasyBarcodes
FM EasyBarcodes is an open source solution that can be used to create barcodes in FileMaker solutions. Most of the more popular barcode types can be generated, as well as QR codes. EasyBarcodes requires no plugins, and no internet connection.

FM EasyCalendar
FM EasyCalendar is a solution for generating data-driven calendars within FileMaker databases. It has been designed to be easy to install and customize, giving developers complete control over how calendars are presented. It also supports business rules, private and shared calendars, and more.

FM EasyCanvas
With FM EasyCanvas, you can create and modify drawings directly from within your FileMaker databases. Using familiar drawing tools (pencil, eraser, line, text, etc), you can create new drawings from scratch, or markup existing drawings or photos taken with your mobile device.

FM EasyHTML
FM EasyHTML is an open source HTML / Text Editor for use in FileMaker databases. With EasyHTML you can provide users with a WYSIWYG tool for editing HTML content.

FM EasyMaps
FM EasyMaps is an open source solution that can be used to create data-driven maps using the Google Maps API. Drop pins / markers with detailed information about the location, and more.

FM EasySignature
FM EasySignature is an open source solution for capturing signatures in FileMaker databases. It is a technique for capturing signatures and optionally storing them in container fields. It's ideal for solutions that require signature capture, such as delivery receipts, contracts and agreements, etc.

FM EasySync
EasySync is an award-winning, alternative, open source sync framework for the FileMaker platform. It's native, simple, transactional, fast, and flexible.

FM EasyWeb
With EasyWeb, you can quickly and easily publish data in your FileMaker databases to the Web, without needing to write any code. Simply install EasyWeb on a Web server, point it at your database, create a few layouts, and you're ready to go.

FM Foo
A Wufoo-to-FileMaker bridge, making it easy to collect info from online forms and save it in a FileMaker database.

FMLuna
A special version of Luna (a Xojo-based framework for creating RESTful APIs) that supports FileMaker databases.

FM Stripe
With fmStripe, you can easily receive credit card payments and store them in a FileMaker database.

FM WebFrame
FM WebFrame is an open source extension to the FileMaker API for PHP. It makes it easier to develop advanced Web solutions that integrate with FileMaker databases.

Organizations

PromoStandards Standards Committee
May 2018 to Present
The Standards Committee is responsible for crafting standards and recommending changes to existing standards.

Association for Computing Machinery (ACM)
ACM is the world's largest scientific and educational computing society.

Institute of Electrical and Electronics Engineers (IEEE)
IEEE is the world's largest technical professional organization dedicated to advancing technology for the benefit of humanity.

Awards

FileMaker Excellence Award
2014 FBA Development of the Year
FileMaker, Inc. An Apple Subsidiary.

Presentations & Speaking Engagements

PromoStandards Workshop 2.0.0
August 2018
• Panel Discussion: New to PromoStandards: Dos & Don'ts

Webinar: Using Temper API with FileMaker
June 2018
https://www.youtube.com/watch?v=NEpg36-8gjs

Xojo Developer Conference 2018
April 2018
• Introducing Aloe Express: Develop Web APIs, Microservices, and More with Xojo

Webinar: FileMaker Web Publishing With Xojo and Aloe
November 2017
https://www.youtube.com/watch?v=qtSd_IZOPsw

Xojo Developer Conference 2016
October 2016
• Xojo’s Role in the API Economy
• Powering Apple TV Apps With Xojo
• Panel Discussion: Xojo Consulting

REST Fest
September 2016
APIs That Meet the Needs of Citizen Developers
API Assistant

Webinar: Xojo Q&A for FileMaker Developers
December 2015
https://www.youtube.com/watch?v=kHlhtKaEVYc

Webinar: Develop Native iOS Apps That Integrate With FileMaker
August 2015
https://www.youtube.com/watch?v=e1Z4nafufIs

Webinar: Using Xojo with Airtable
August 2015
https://www.youtube.com/watch?v=AD1k3BcxCbE

Testimonials & References

References are available upon request.

For a list of organizations that I've worked with, as well as a few client testimonials, click here.

Contact Information

Location:
Richmond, Virginia USA

Web:
https://timdietrich.me

Email:
timdietrich@me.com

Phone:
(703) 975-0490