ShipWorks to Microsoft Dynamics GP integration- Monday November 12, 2018
Built background processing system for sales orders between ShipWorks and Microsoft Dynamics GP. The orders coming into ShipWorks from Amazon, BigCommerce and eBay are picked up and sent to GP as new orders.
|
Implemented CyberSource credit card payment system- Wednesday September 05, 2018
Implemented CyberSource credit card payment system on customer's ecommerce web sites. The interfaces were build using C#, .Net and the CyberSource web services SDKs.
|
Microsoft Dynamics GP data integration- Thursday August 02, 2018
Built data import for Quickbooks customers, vendors, parts and sales orders to Microsoft Dynamics GP. The processes were built using a combination of C#, QB SDK, GP Connect and direct database updates. The processes were used to assist customer with conversion of QB data from new unit of the company.
|
Magento sales order import to Infor/Visual Manufacturing- Friday April 20, 2018
Automated the importing of sales orders from web site running Magento to customer's internal ERP system running Infor/Visual Manufacturing. Tools used were C# and direct database queries and updates in both systems.
|
Google Analytics - Reporting with distribution of trends reports- Monday June 12, 2017
Built reporting interface to Google Analytics system using their restful
API interface. The collected data was then used in daily emailed
reports with charts showing trends.
|
CallRail - Call center reporting/charting- Tuesday May 23, 2017
Built reporting interface to CallRail system using their restful API interface. The collected data was then used in daily emailed reports with charts showing trends.
|
Data load of 2000+ parts to new OpenCart system- Tuesday May 16, 2017
Built data load program to assist in the go live of a new OpenCart ecommerce system for a forensics customer with a large variety of products. Conversion included the migration and processing of existing product images.
|
Agility Multichannel PIM- Wednesday March 01, 2017
Assisted with initial data population of Agility Multichannel database and built two-way data sync processes between Agility and NetSuite. Inventory Items, Assembly and Kit parts are synced to NetSuite and NetSuite inventory levels and pricing information is reported back out to Agility and external web sites. Processes built using SuiteTalk web services and OpenAccess/SuiteAnalytics
|
Royal Mail shipping and label printing integration- Tuesday November 15, 2016
Implemented Royal Mail shipping and label printing for large UK based
engine parts company using the Royal Mail Shipping API V2 (SOAP)
interfaces and ASP.NET/C#. Shipping API V2 provides the functionality for customers to take a shipping transaction from creation to collection. It is a service offered via Royal Mail to request for the creation, update, cancellation of a shipment, printing of a label, printing of international Customs documents, requesting 2D barcode.
|
Worldpay credit card payments in Sage MAS 500- Friday August 12, 2016
Worldpay credit card payments in Sage MAS 500. The interface
was built using the Worldpay RESTful APIs with C#.
|
Authorize.Net credit card payments in Sage MAS 500- Sunday July 10, 2016
Authorize.Net credit card payments in Sage MAS 500. The interface
was built using the Authorize.Net web services SDK version 1.9.0 with C#.
|
Connecting Kardex to Visual Manufacturing- Sunday April 03, 2016
Connected Kardex to Infor's Visual Manufacturing, creating the necessary
interfaces to communicate with the Kardex robotic inventory system.
Received parts were staged for input into the robotic system and demand
from customer orders, ibt orders and work orders were satisfied via
requests to Kardex via prioritized parts picklists.
|
Built browser based front end to order entry for Sage MAS 500 system- Friday August 15, 2014
Built browser based front end to order entry for Sage MAS 500 system. Interface used to simplify and speed up user access to customer order
entry. System supports multiple currencies, sales tax calculations, shipping options, payment methods, ship to address selection/maintenance, discounts, etc
|
Easy Projects data bridge to QuickBooks- Saturday August 02, 2014
Easy Projects data bridge to QuickBooks utility to import customers from
QuickBooks and create QuickBooks invoices based on Easy Projects
timesheet entries. The QBXMLRP2 XML API interface was used to
communicate with QuickBooks. End user interface was web based and built
using ASP.NET using C#.
|
PayPal Payflow Pro credit card payments in Sage MAS 500- Thursday July 31, 2014
PayPal Payflow Pro credit card payments in Sage MAS 500. The interface
was built using the PayPal Payflow_dotNET API/libraries with C#. The
use of the Classic API SDKs was necessary due to a desire to be
compatible with other components of the customer's credit card
processing.
|
Goldmine CRM contacts sync with Sage MAS 500- Tuesday June 10, 2014
Built a set of synchronization processes to populate Goldmine contact records from Sage MAS 500 data using the Goldmine GMXMAPI interfaces.
|
UPS address validation using XAVService web services- Saturday April 12, 2014
Implemented an order entry address validation interface using the UPS web services. A browser popup is presented for address selection when UPS returns multiple possible address candidates.
|
Sage Accounting Migration- Sunday November 03, 2013
Migrated reporting and external web site interfaces to Sage MAS500
for a large farm and construction machinery company. The interfaces
included an automatic sales order creation feed from their public web site
to their internal Sage system. Sales orders are created using MAS500's built in sales order staging tables and stored procedures (no 3rd party packages needed).
|
Automated sales order creation in Netsuite- Friday August 16, 2013
Built bridge between customer's retail AspDotNetStorefront web site an their Netsuite accounting system. New sales orders are automatically created in Netsuite via a scheduled task. Data is being added to NetSuite using the SuiteTalk web services using C#.
|
Roof repair management company implements dashboard- Friday June 01, 2012
Roof repair management company implements dashboard application for clients. Lets them view jobs/activities at a glance and quickly focus on tasks needing attention. Solution implemented using SQL Server, ASP.Net and C#.
|
Parts dealer goes live with new AspDotNetStorefront shopping cart system- Sunday October 30, 2011
Parts dealer goes live with new AspDotNetStorefront web site. The web site automatically
synchronizes itself daily with up to date information out of the
customers QuickBooks POS database (parts, prices, descriptions, attributes,
pictures, etc).
|
Heavy-Duty Filters- Friday July 29, 2011
Implemented the new launch site for a global company specializing in
filtration products for hard working farm and construction machinery. Site included dealer login and administration, order history and product catalog search functionality.
|
Inventory data sync using Intuit Quickbooks SDK- Thursday May 12, 2011
Implemented a daily inventory sync process of Quickbooks data to a resellers external database using the Intuit Quickbooks SDK. New processes use .Net/C# and reduced the processing time of the nightly task from 2-3 hours to less than 2 minutes.
|
Purchase Order Receipts System- Tuesday March 08, 2011
Implemented a custom purchase order receipts and work order material issuing system for a North Carolina manufacturing company. The part of the implementation runs on wireless handheld computers from Symbol and allows the customer to handle purchase order receipts, work order issuing, issue returns and location to location material transfers. The system was an add-on to Infor's Visual Manufacturing.
|
Converted AS400 membership system to ASP.Net- Monday January 31, 2011
Converted a large AS400 membership tracking accounting system to ASP.NET for a Florida based organization. The new system is connected to a SQL Server database and components are built using C#. It provides enhanced versions of reports previously available and gives the system's end users greater flexibility in the management of the data and reduces operating costs.
|
Content management system for pool plaster company- Monday December 27, 2010
Implemented a content management system for a Florida based pool plaster company. The company is able to self manage the variety of plasters offered and work examples via a browser based management interface added to the newly developed web site.
|
Connecting Hänel to Visual Manufacturing- Monday November 01, 2010
Connected Hänel to Infor's Visual Manufacturing, creating the necessary
interfaces to communicate with the Hänel robotic inventory system. Received parts were staged for input into the robotic system and demand from customer orders, ibt orders and work orders were satisfied via requests to Hänel via prioritized parts picklists.
|
Dealer portal web site for Florida based solar company- Sunday August 15, 2010
Created a dealer portal web site for a Florida based solar energy company. The portal interacted with their in house Peachtree accounting system for parts, dealer info. Intranet system was also developed to tie together the 3 different operating units into a unified view of the company and its accounts.
|
Parts dealer web site connected to QuickBooks POS- Tuesday August 03, 2010
Parts dealer web site connected to QuickBooks POS built for a Kentucky based company. The web site automatically
synchronizes itself daily with up to date information out of the
customers QuickBooks POS database (parts, prices, descriptions, attributes,
pictures, etc). The web site is using AspDotNetStorefront.
|
Document linking with Infor Visual Manufacturing- Wednesday July 14, 2010
Built a user friendly document linking interface to Infor's Visual Manufacturing ERP system for a North Carolina manufacturing company. It allowed end users to simply drag-drop documents into predefined folders for those documents to be associated with customer orders, purchase orders, parts etc in the ERP system.
|
Creating work orders for laser cutting system- Monday June 07, 2010
Created front end and processes necessary for a metal laser cutting
system to interact with and create work orders in an Infor Visual
Manufacturing system for a South Carolina manufacturing company.
|
UPS address validation- Monday May 24, 2010
Built a custom macro to validate customer order ship to addresses using
the UPS web services on top of Infor Visual Manufacturing for an Iowa
manufacturing company. The system lists recommended addresses when exact matches are not found and lets the customer override what UPS returns.
|
Time and attendance fingerprint scanning system- Wednesday May 12, 2010
Implemented a time and attendance fingerprint scanning system using DigitalPersona's U.are.U 4500 fingerprint readers for a Florida based manufacturing company. The system was built to interact with Infor's Visual Manufacturing ERP system, capturing fingerprints and matching them to registered employees.
|
EDI system for exchange with Chrysler- Monday February 08, 2010
Enabled a North Carolina transportation company to exchange order information with Chrysler using EDI. A set of custom programs were created to receive and send EDI transaction sets (856, 810, 866). The incoming EDI orders were added to their Infor Visual Manufacturing system and their ERP system would trigger the delivery of advanced shipment notifications and invoices.
|
Distributor web site connected to Activant Prophet 21- Tuesday September 01, 2009
Distributor web site connected to Activant Prophet 21 built for a Florida based parts distributor. The web site automatically synchronizes itself daily with up to date information out of the customers Prophet 21 database (parts, prices, descriptions, attributes, pictures, etc). The web site is using ASP.Net and C#.
|