Order management tool
Faurecia Autositze GmbH
Faurecia Autositze in Neuburg an der Donau is a manufacturing company that assembles seats exclusively for an Audi factory located in the nearby town of Ingolstadt. In this company I worked as part of the IT team tasked in helping the R&D department.
Due to organization confidentiality, some information has been removed from the images.
Skills used
Project purpose and goal
The R&D department relied on Excel sheets to keep control of the orders received by the company, they received orders through many different types of documents, and an employee had to fill up all the data on a very large Excel table that would then be shared with the other departments. Excel was not the right tool for the job being done, and an alternative was proposed, this alternative had to solve all the complications of the old system, optimizing the creation and reading of entries and allowing multiple users to read the data, these users would need credentials provided by an admin user.
Creation of a document with user expectations for the new solution. Based on meetings with the R&D department.
Creation of proofs-of-concept to analyze different technologies.
Mockups.
Prototype programming on the selected technology.
Database design and creation.
Client meetings for satisfaction assessment and feedback gathering.
Documentation.
After initial meetings with the R&D department along with other IT team members, I was left with the tasks of finding the best technology to serve the client's needs, booking following meetings with the R&D team and designing and coding a prototype for the solution, alongside its database.
My tasks
Development
The technology chosen for the solution was an application written on the .NET platform, the argument for choosing it was that it was the only one of the considered solutions that could satisfy every necessity from the client, and also most of the IT team members had experience with it already, as well as with ASP.NET. Within .Net, Razor Pages was the framework that would be used. .NET 6 also left very clear that SQL Server was the database solution to choose.
Application prototype with working creation, edition and deletion of entries, and user management system.
Lessons learned and future work
The goal of the project was to develop an application that would replace the old, inefficient solution, streamlining the process of order management. The result was an application that yielded well performing results, but still needed improvements.
Having the opportunity to do the research and develop the solution from scratch taught me about the project management methods from start to finish, I improved in knowledge of the .NET environment and was able to deliver a working prototype that, with little work could be transformed into a full-blown solution for the R&D department.