Utilities, Class Libraries, Integrations
These are some of the projects I have worked on, either as part of my job or in my spare time. They include utilities, class libraries, and integrations with various systems. I have a strong focus on automation and efficiency, and I enjoy working with different technologies to solve complex problems.
Please note I am not the sole author for some of the projects listed here. I have worked with various individuals to deliver these projects, and I am grateful for their contributions.
This utility is designed to check the completeness of database tables. It helps ensure that sufficient data is present and correctly formatted for the success of a project, reducing errors and increasing success in automation projects. The main barrier for a successful automation project is nearly always clean and consistent data.
This class library is available as a DLL for various capture tools (IRISXtract, ABBYY FlexiCapture), as well as a REST API for use with other applications. It provides an extremely sophisticated set of rules for normalising invoice and order/receipt data, and matching these two datasets together using various modes.
This class library is available as a DLL for ABBYY FlexiCapture. It's a very small class library that allows the user to separate documents based on a set of rules. It can be used to split documents into multiple files, or to combine multiple files into a single document.
This application sits on local servers and allows the user to configure and extend Therefore™ workflows in the cloud. It is designed to be a simple, easy-to-use interface for implementation specialists who want to extend workflow functionality without having to create publicly accessible APIs within local infrastructure.
This utility is designed to read data from a SQL database and create flat files of result sets. It allows the user to configure connection strings, commands, delimiters, qualifiers, headers, and methods. As of right now, it can export CSV and XML representations of results to either the local file system or an SFTP server.
This utility is designed to read data from a flat file and create relevant SQL tables with records. It allows the user to configure connection strings, input files, and table names. As of right now, it can import XML files.
As an integration specialist, I have worked on various projects that involve integrating different systems and applications. This includes working with APIs, databases, and other technologies to ensure seamless communication and data exchange between systems.
This class library reads information from Therefore™ and creates the relevant document(s) within Sage200. It uses the Therefore™ API to read data from Therefore™, and the Sage200 API to create invoices, credit notes, sales orders, and projects.
This class library reads information from Therefore™ and creates the relevant document(s) within Infor Syteline. The Therefore™ API is used to read data and it is written into local staging tables. Syteline IDOs handle the creation of invoices and credit notes from the staging tables.
This set of SQL stored procedures reads information from Therefore™ and creates the relevant document(s) within Microsoft GP. It reads data from a Therefore™ database in SQL to get transactional data, and uses pre-built stored procedures within Microsoft GP to create invoices and credit notes.
This class library reads information from Therefore™ and creates the relevant document(s) within Microsoft Exchequer. It uses the Therefore™ API to read data from Therefore™, and the Exchequer Enterprise Toolkit API to create invoices and credit notes.
This class library reads information from Therefore™ and creates the relevant document(s) within Xero. It uses the Therefore™ API to read data from Therefore™, and the Xero API to create invoices.