A brief summary of Finance-IT projects

I always had a great interest in the area between Finance and IT.
And when you show this interest to the right people you are invited to participate and contribute from the financial corner.

During below projects I learned a lot about (financial) databases in general, how they are build, links between datatables, how interfaces work etc.
To use this knowledge I have followed a number of courses in using specific software that enables me to extract data directly from the source and show it in a report.

MediaBoss

In 2000 I was involved with the in-house development of a media administration system in an Oracle database.
I was responsible for the design of the journal entries and the tables of debtors and suppliers needed for those journal entries.
GL, AP and AR were in Exact CS and invoice-, client- and supplier information were filled from MediaBoss to Exact via interfaces.
During this project I learned a lot about database structures in general.
All reports were created using SAP Crystal Reports.

Oracle E-Business Suite Financials

Late 2005 it was decided that the Netherlands should change from Exact CS to Oracle Financials (international implementation) per 1 January 2006.
We managed a complete new setup, including interfaces with MediaBoss within 3 months.
Manuel journal entries were imported through Oracle ADI.
The reports from Oracle Financials were done with SAP Crystal Reports.

Raet Payroll Direct

When Raet launched Payroll Direct in 2008 I designed the export / import journal entries from Payroll Direct into Oracle Financials.

Symsys

In 2009 we switched to Symsys, a standard in the advertising and media industry where media and financial administration are integrated.
Through export MediaBoss / import Symsys all relevant data were transferred.
I modified the Payroll Direct export file in a way it could be imported in Symsys.
For Havas WorldWide I made a report containing all financial data that could be used for import into SAP FiCo.

Oracle E-Business Suite HR

In 2011 I implemented Oracle HR as the Spanish HQ wanted basic information of what happened in terms of staff.
During the implementation all data was imported.
Updates must be filled manually.

ADP Autoline and Carwise

In 2011 I started with the implementation of SAP Crystal Reports to increase efficiency in reporting.
Next to that I changed a lot of settings to lower the number of errors during the import of Carwise into ADP Autoline.

Exact Globe

To be able to have 1 payroll import file from 5 seperate Exact Globe databases (with different setups) I modified it in a way this became possible.
The data was collected with SAP Crystal Reports in a format ready for import in Symsys.