Promo Select & Operators Edge

This is the very first project that I did for this client. The client wanted a programs that tracks all the box movement for Canada's biggest confectionery and food product distributor ITWALL. Imagine every chocolate bar you have eaten or you have seen went though this system. The amount of data handled by this system is enormous. The existing system hosts all pre-processed PDF file for the regional disturbers to download. The job is to create a flexible system to handle such a workflow:

-> Import data from a existing MS-SQL server to MySQL server.

-> Provide an interface for regional disturbers to view their own data and generate printable/downloadable custom reports.

-> Based on the data the custom reports return, generate dynamic graphs that shows the sales trend.

-> support both English and French. For this I created a dictionary system that allows the system dynamically load the language based on the user's language setting.

-> Dynamic theme based on the data set chosen for the theme has to match the current print material in use.

This project took months to build but it won't be everything it is today without the assistant a team of smart professionals.