A software developer that specializes in the NetSuite platform.

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

NetSuite:
• SuiteScript 1.0, 2.0, and 2.1, including Suitelets, RESTlets, Portlets, Client Scripts, User Event Scripts, Map / Reduce Scripts, Mass Update Scripts, and Scheduled Scripts
• Advanced PDF / HTML Templates
• SuiteQL
• SuiteTalk

ERP, Accounting, ITSM, and MES Systems:
• Lawson
• NetSuite
• ServiceNow
• Solomon
• Tulip

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

Programming Languages and Technologies:
• ColdFusion
• ICSMxml
• JavaScript
• PHP
• SQL
• SuiteScript
• Swift
• T-SQL
• TVML / TVJS
• XML
• Xojo

Specialized Skills:
• Design and development of custom manufacturing apps using Tulip, a frontline operations platform.
• Design and development of specialized Web and mobile applications, NetSuite native apps, custom APIs / middleware, custom search engines, spiders / bots.
• Extensive experience with PromoStandards.
• Integration with payment processing systems, including PayPal, Authorize.net, Stripe, and CardConnect / CardPointe.
• Integration with FedEx and UPS shipping systems.
• Integrations with Tulip, Wrike, SEC EDGAR, CoinDesk's Bitcoin Price Index (XBP).
• Experience with Amazon Web Services (AWS), including Elastic Compute Cloud (EC2), Relational Database Service (RDS), S3 (Simple Storage Service), Lightsail, and Amazon Translate.
• Development of Apple TV apps using TVML, TVJS, TVMLKit, and Swift.

Professional Experience

Independent NetSuite Developer
Richmond, Virginia
October 2017 to Present

I develop solutions that enhance and extend NetSuite, including Web, desktop, and mobile apps, Web portals, Web APIs, Webhook listeners, and more.

Examples of my work include:
• Performed NetSuite ERP requirements gathering and analysis.
• Assisted with three NetSuite implementations for wholesale distribution companies.
• Implemented NetSuite for a startup in the promotional products industry.
• Developed a custom NetSuite / Stripe checkout integration solution.
• Developed a customer portal that integrates with NetSuite, PayFlow Pro, and Inksoft.
• Developed a custom NetSuite field service portal for a company that services medical equipment.
• Developed several custom Web APIs for various clients.
• Developed integrations between NetSuite and ServiceNow, FileMaker, Airtable, and other systems.
• Developed NetSuite / PromoStandards integration solutions.
• Developed a NetSuite / commonsku integration solution.
• Developed custom NetSuite / FileMaker Go-based mobile solutions for distributed sales and delivery teams.
• Developed a NetSuite / Onshape integration solution.
• Developed complex SuiteQL queries to assist with a NetSuite audit.
• Developed SuiteQL queries and applications to help improve the efficiency of a NetSuite client's warehouse team.
• Developed a custom NetSuite API for a client that outsourced their Accounts Receivable to a debt collection firm.
• Developed a custom portal that provides summarized financial information to the client's management team and private investors.

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.

Independent Software Developer
Richmond, Virginia
April 2008 to October 2017

Developed business software solutions with a strong focus on custom integrations and Web applications. My clients ranged 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.

Some project highlights include:
• Developed a custom legal case management system for the Library of Congress.
• Helped to implement, customize, and integrate NetSuite for a promotional products distributor.
• Developed several PromoStandards-based solutions for some of the promotional products industry's top suppliers and distributors.
• 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.

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.

SQL Server 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
Towson University
• Information Systems Concentration

Tulip Advanced App Building Certification
Tulip Interfaces
• Certificate No. aj8u63wisk93

Tulip Essentials Certification
Tulip Interfaces
• Certificate No. pe98r8wdfdcw

NetSuite Training
Oracle NetSuite
• Advanced PDF/HTML Templates: Customizing Printouts and Emails
• NetSuite Essentials
• SuiteAnalytics: Advanced Searches (v2)
• SuiteAnalytics: Reports and Searches
• SuiteBilling: Fundamentals
• SuiteCloud: Exploring the NetSuite Platform
• SuiteCommerce Advanced for Developers
• SuiteFlow: Workflow Fundamentals
• SuitePeople: Fundamentals
• SuiteQL: Essentials
• SuiteScript 2.0: Custom User Interface Development
• SuiteScript 2.0: Extend NetSuite with JavaScript
• SuiteTalk: Integrate Your Applications
• Using Accounts Payable
• Using Accounts Receivable
• Using Customer Relationship Management
• Using General Ledger
• Warehouse Management System (WMS): Fundamentals

Evernote Business Certified Consultant
Evernote Corporation

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

Microsoft SQL Server Certification
Northern Virginia Community College

Publications

Adding Language Translation to Your Xojo Apps
Xojo Blog
May 2019

Achieving Success As A Xojo Developer
Xojo Blog
March 2019

Beyond JSON: Develop APIs That Generate Barcodes, Charts, and More
xDev Magazine
January 2019

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

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

Open Source Solutions

FM EasySync
An award-winning, alternative, open source sync framework for the FileMaker platform.

NetSuite External ID Search Utility
A Suitelet that can be used to locate transactions, entities, and items based on an external ID.

NetSuite Saved Search API
A RESTlet that can be used to leverage Saved Searches in NetSuite integrations.

NetSuite SuiteAPI
An open source, alternative Web API for the NetSuite platform.

NetSuite SuiteFrame
A framework for developing NetSuite-native applications.

NetSuite SuiteQL Query API
A RESTlet that can be used to leverage SuiteQL in NetSuite integrations.

NetSuite SuiteQL Query Tool
A Suitelet that can be used to run SQL queries directly within a NetSuite instance.

NetSuite SuiteTransmit
A macOS / Windows desktop application that monitors files that a NetSuite developer is working on. When a file is changed, it is automatically uploaded to the File Cabinet. Developed with Xojo.

Organizations

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.

International Society of Automation (ISA)
ISA is a non-profit professional association of engineers, technicians, and management engaged in industrial automation.

PromoStandards Standards Committee
May 2018 to September 2020
PromoStandards is an organization committed to improving supply chain and transactional efficiencies in the promotional products industry. The Standards Committee is responsible for crafting standards and recommending changes to existing standards.

Awards

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

Presentations & Speaking Engagements

Webinar: Using Xojo to Develop NetSuite Solutions
August 2022
https://www.youtube.com/watch?v=K6nQzPbeW_g

Tulip Developers Meeting 2
July 2022
• Handlebars Custom Widget
• Xojo-Based Tulip Applications

Tulip Developers Meeting 1
June 2022
• jsExecute Custom Widget
• DataTable Custom Widget

Rocky Mountain NetSuite User Group
March 2022
• An Introduction to SuiteQL

Ontario NetSuite User Group
October 2021
• An Introduction to SuiteQL

PromoStandards Workshop 3.0.0
August 2019
• Presentation: Product Data 2.0
• Panel Discussion: Technical Infrastructure, Inventory, Order Status, Order Shipment Notification, Product Data, Product Media

Xojo Developer Conference 2019
May 2019
• Get Hooked on Webhooks
• Panel Discussion: The Future of Technology & What It Means For Software Development

PromoStandards Vegas 2.0.0
January 2019
• Leveraging Product Data & Media

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

References

Available upon request.

Contact Information

Location:
Richmond, Virginia USA

Web:
https://timdietrich.me

Email:
timdietrich@me.com