Joachim Kuhn

Developed C# programs to maintain the accounting system, post to the accounts, maintain articles, create offers, order confirmations, delivery notes, and invoices, and create all statutory reports. Used ERIC API to submit advance VAT return and balance sheet.

A SharePoint-based portal for the acquisition of investment applications. I created several lists to control the workflows and avoid modifying the workflow when approving managers changed. The form to enter the data was implemented with InfoPath and the workflow with Nintex.

A C#-based application for maintaining asset data, such as issuer or prices, and libraries for calculating the monthly rating. A large amount of data from providers is imported every month through SSIS packages. I added the import of new important indicators (ESG and SRI), optimized the database, and created a new tool for ad-hoc data analysis.

A SharePoint-based portal to store documents of a German bank. I created all necessary concepts, websites, libraries, and templates for every department and documentation area. I created the system documentation and trained all employees to use the portal. For migration of existing data, I created VBA macros in Excel to use the REST API of SharePoint.

SharePoint-based approval portals for vacation, travel, and CapEx. Analyzed the paper-based forms and approval processes, and then I created InfoPath forms and control lists for approval with Nintex Workflow.

A C# program to enter and update metadata (classification) of decor and image files. This data was uploaded to SharePoint for metadata search. Another C# program used RabbitMQ to transfer decor and images to other offices worldwide for surface production.

I replaced the complete DOS-based application environment for order processing with my accounting and order processing software, implemented the data transfer from osCommerce into the order processing system, created a module to transfer the shipping data to DHL Easylog, and made tracking data available for the shipped orders.