Integrations

Created a web service with specific operations exposed by RESTful calls and a JSON body.

An AI called Amelia interacts with a front-end user via a chat dialogue. Amelia is able to ask questions and continue to pry for specific answers by connecting to the web service operations while communicating with the user. When all her required data is valid, she submits it to the web service where the information is transformed into a recorded incident.

For example, an employee lost their security badge, spoke with Amelia, and both a Lost & Found and Security report were submitted in a system on behalf the employee.

  • ASP.NET
  • C#
  • LINQ
  • REST
  • JSON

A two-way integration between an incident management system and an operational excellence platform. The IM system triggers requests to the OE platform's API using RESTful calls with a JSON body.

Created a web service for the IM system with explicit operations, whose URIs are sent to the API as pre-defined Webhooks.

New records and updates from the OE platform are transmitted by webhook to the IM system. New records and updates from the IM system are transmitted to the API for a near real-time synchronization between both systems.

  • ASP.NET
  • C#
  • LINQ
  • REST
  • JSON
  • Webhooks

Connect to a Cvent API on a schedule to pull all new events of a certain type - such as an offsite company meeting or a speech with the city's mayor - that require a safety review and risk assessment.

For example, will all attendees be over the legal drinking age; Will EMT personnel be in attendance; Is the country hosting the event at a low risk of terrorism.

Convert the events that are scored over a certain value into inspections that require review before the event may be held - cancelled otherwise. Data is gathered from the API using SOAP, logging faults and errors.

  • ASP.NET
  • C#
  • LINQ
  • SOAP
EAM Work Orders

A two-way integration, where data in one system is queued to transmit to the Enterprise Application Management system when conditions are met. Data is transferred by CSV flat files over SFTP.

The process kicks off a work order in the EAM. Records from the originating system cannot be closed out until the work order in the EAM is completed. As the work order progresses and has updates applied, the updates are shared with the originating system.

  • ASP.NET
  • C#
  • SQL
  • CSV
  • SFTP
Task Tracker

A two-way integration between two systems that manage tasks employees are assigned to and expected to complete by a certain date.

Tasks created in any system will be transmitted to the other. Updates in one system will mirror the update in the other.

  • ASP.NET
  • C#
  • LINQ
  • REST
  • JSON
Learning Management System

Created a web service with many operations available for use. RESTful calls with a JSON array body will move data from a Learning Management System and into a Training Management System.

Expecting hundreds of thousands of objects within the body at a given time.

  • ASP.NET
  • C#
  • LINQ
  • REST
  • JSON
Data Mining

On a schedule, deliver CSV flat files with large data sets to an external location using SFTP. Connect to the SQL AG read-only mirror for substantially quicker delivery.

  • ASP.NET
  • C#
  • CSV
  • SFTP
  • SQL

A one-way integration to consume the contracting company information and contractor details from a contractor information management system.

Convert the data contained in CSV output and transmitted over SFTP into their designated objects and data types in the receiving system.

  • ASP.NET
  • C#
  • LINQ
  • CSV
  • SFTP
Insurance Claims/Workers' Comp

Created the triggers that pull, convert, encrypt and post sensitive data over SFTP to a provider's secure location, in their required formats and types. The data is always secure and encrypted, be it at rest, landed or in transit.

Abides by HIPAA and GDPR regulations. Applied Transparent Data Encryption on SQL databases, PGP encryption on flat files, and BitLocker disc drive encryption.

  • ASP.NET
  • C#
  • LINQ
  • CSV/TXT
  • SFTP
  • PGP
  • TDE

F.A.Q.

  • ASP.NET
  • C#
  • LINQ
  • SQL
  • JSON
  • GraphQL
  • XML
  • REST
  • Web-Queue-Worker
  • Microservices
  • Event Driven
  • HIPAA
  • GDPR
  • CCPA
  • Privacy Shield
  • PIPEDA
  • SOC 2
  • OWASP