I started my professional career as an accountant and developed many excel and access based systems which bridged the gaps in the finance systems. Over the years I was involved in implementing major system changes in many firms including a European Logistics System and a worldwide accounting System using by skills as a Business Analyst and VBA modeller.
Some of the systems include
- MASC (Mobile Automated Sales Control) is designed to eliminate manual delivery dockets and links to accounting systems, the system is written in Access and Satellite forms (Handheld Software).
- Freight bookings – Developed for a client this system is designed in Access linked to SQL Server and includes XML booking transfers, SMS confirmations and Supplier invoice matching.
- Sales order automation ; We developed an Sales Order import program in Microsoft Access that load an XML sales order ; validates the data and loads the order in Syspro using Syspro business objects.
- Invoice Mailing – Batch Emailing and Faxing of Sales Invoices or Statements using MS Access and linked to Sage Line 50.
- Database systems for Research reporting and Payroll budgeting
- Developing systems enhancement and reports for Sage Line 50, Intact Business Accounting and Syspro.
You can contact me by email pnjones@gmail.com