Projects

Millennium (Since 2013)

UNIT4 CODA Upgrades and Installations

• I have installed and upgraded 10 customers from CODA (10.1, 11.1, 11.2, 11.3, 12.0) to CODA 13.0
The features included are Databases, Application Servers, Web Server, Print Formatter, Workflow, Distributed Transaction, Single Sign On, User Extensions Print formatter, CODA Audit Trail, CODA-XL, Sngle Sign On.

• I have also installed and upgraded 9 customers from CODA (10.0, 10.1, 11.1, 11.2, 11.3) to CODA 12.0
This included Databases, Application Servers, Web Server, Print Formatter, Workflow, Distributed Transactions, Apache Tomcat, User Extensions Print Formatter, CODA Audit Trail, CODA-XL.

Automation of CODA Live Backup/Restore into CODA Test/Dev

We have created very special scripts to

• Backup Coda live database
• Stop Coda services
• Restore Backup into TEST or DEV
• Restart Coda services

The whole process runs overnight and the next day the test/dev environment is updated.

CODA XMLI bespoke interfaces and extracts

• 1 Java interface to post documents (Ezpenses) to CODA using table Link or XMLI 13.0
• 1 Java user extension for input using external references lookup CODA 12.0
• 1 Java interface to post documents to CODA Financials using CODA XMLI version 10.1
• 1 Java interface to post elements to CODA using CODA XMLI Version 10.1
• 1 Java interface to post LRN to CODA Invoice Matching using CODA XMLI version 12.0
• 1 Java interface to post purchase invoices to Coda Invoice MAtching using CODA XMLI version 12.0
• 1 Java interface to post LRN to CODA Invoice Matching using CODA XMLI version 11.3
• 1 Java interface to post purchase invoices to CODA Invoice Matching using CODA XMLI version 11.3
• 1 Java interface to post documents to CODA Financials using CODA XMLI version 12.0
• 1 Java interface to reconcile invoices and payments read from EXCEL files
• 1 Java interface to read EXCEL files and validate accounts
• 1 EXCEL VB to automatically validate CODA accounts
• 1 Java interface to automatically maintain CODA periods overnight
• 1 Java interface to automatically run XMLI Background matching overnight
• 1 Java interface to automatically run XMLI Inter-company overnight
• 1 CODA XMLI Training
• 1 Java interface to post GRN to CODA Procurement using CODA XMLI version 12.0
• 1 Java interface to post purchase orders to CODA Procurement using CODA XMLI version 12.0
• etc...

Alliance Healthcare and Boots (6 months)

Factoring Group Extracts. Optimised oracle stored procedure to run overnight and extract:

• Day Book
• Cash Submission
• Aged Debt
• Bank Reconciliation

Intesa Factoring Group Extracts. Optimised oracle stored procedure to run overnight and extract:

• Pre-Assignments
• Pre-Collections
• Assignments
• Collections

Java interfaces to upload factoring credit limit and amend customer user extension

Oracle triggers to validate factoring codes and credit limits

Other Companies

• 1 Java interface to post Transactions to CODA using Table Link CODA XMLI Version 12.0
• 1 Java interface to post LRN to CODA Invoice Matching using CODA XMLI version 11.3
• 1 Java interface to post purchase invoices to Coda Invoice Matching using CODA XMLI version 11.3
• 1 Java user extension to validate Input Transaction 11.2



HMBK Software Solutions Ltd. Registered in England and Wales. No. 08403167
Director Hamid Khendek, BSC Software Engineering, MA IT, PhD