Pilot build management system for pre-launch
We were required to take the existing system, processes & reporting that were used to run the 'Pilot Build' process foe each launch and model year face lift of the Vauxhall Astra within the U.K.
The end solution was Microsoft Access based a front end with integrated Microsoft Excel for external Analysis and sat on Microsoft SQL server as a database engine and db server. Oracle was integrated as this housed the 'Global Quality Tracking System' for the parts available through the network as this was a key part to running through the pilot process.
MS SQL reporting services was also used to gain a wider level of understanding of what was achieved during this phase of launching a new car/face lift.
Barcode scanning and printing played a big part in the Kanban process and the end solution reduced the amount of time to just under 10% allowing Vauxhalls to complete additional 'dry runs' before main production.
The system was so successful that is was also implemented and supported in Poland, Houston and Germany.