Solutions Architect, Developer and Consultant
I resigned from Consilia Consult to pursue a company of my own in the IT industry.
Telamon Business Architecture was formed as a consulting firm to provide independent advice to companies regarding their IT systems architecture. A network of professional providers was established that could address many aspects of a company's needs.
- Understand the client's real business software application needs.
- Create and manage a rich, engaging relationship between the application vendor and the client.
- Facilitate a high return on investment for both vendor and client.
With a solid background of Enterprise Resource Planning systems, Business Process Management and Business Intelligence, the company is well positioned to provide valuable guidance to its clients that ensure the right solutions are professionally implemented.
My most significant work was for The Reclamation Group:
I was approached by the Reclamation Group to do their QlikView development on the new SAP Business One implementation that was in the process of rolling out to all their branches.
After negotiation with my previous employer it was agreed that I could do the work.
The QlikView project required a range of applications.
Time and Attendance Monitoring
This application retrieves information from a FireBird database that is populated by the biometric scanners throughout the head office building. Attendance, In/Out board and office hour trends is provided to reception and management staff.
Service Desk Monitoring
One of the side projects that I developed was a fully functional service desk built using ProcessMaker, a business process automation tool. QlikView is used to read the MySQL database and monitor the open cases, agent performance etc.
Integration and Reconciliation Dashboard
Each of Reclamation's 75 branches feeds information to head office via RepliWeb RMFT. At this point the XML files are processed by iBolt into SAP Business One.
The QlikView dashboard application provides two functions.
- To extract log information from iBolt to verify transaction integrity from a infrastructure perspective. The support team at head office constantly monitor this application to detect and fix any errors that occur.
- To provide a full reconciliation view of all transactions from a financial perspective. Information is traced from the Yard Management System and from SAP Business One. More than 30 error types are detected and reacted on.
This application has become indispensable with new functionality added regularly.
I have enhanced the dashboard with various Adobe Flex web pages and some business process automation interfaces that interact directly from QlikView. The solution detects any erroneous SAP transactions, notifies the responsible person and publishes the QlikView information to a secure web site from where problems can be easily viewed and then rectified.
The dashboard data is reloaded every 15 minutes by QlikView Server and then pushed to the agents. Users are not permitted to do manual reloads so that server loads can be predicted and managed.
This application provides a complete snapshot of the entire SAP Business One database. The QlikView security model and data reduction functions ensure that branch information remains confidential.
Branches access the application from the QlikView Access Point via their web browsers. Single sign-on is achieved by obtaining domain credentials so no additional passwords are required. To manage SAP and QlikView security from a central point, users' authorised branch list is obtained from a SAP security add-on module.
The financial application replaces all the SAP Business One financial reporting including Trial Balance, Balance Sheet, Income Statement, Ageing reports, purchasing and sales information. The application is also responsible for re-mapping all transactions to an alternative chart of accounts used by top management.
Both the Dashboard and the Financial Reporting applications form the pinnacle of my QlikView work to date. These two applications with their supporting systems required extensive planning and open minded thinking to accomplish.