The Customer is a company that provides a centralized database of US college profiles, admission details, scholarships, etc. It helps bringing students and colleges together, so that students could compare college offerings and find the most suitable options for them.
The Customer didn’t have a centralized system for storing and managing data about colleges. They received college data from colleges in various formats and processed it in Excel to unify before uploading to the database. So, the Customer wanted a product information management solution that would support data export from external sources and import of file formats compatible with Excel, such as .csv and .xlsx. A large data storage, flexibility for integrating with third-party software and automated reporting were also required. What’s more, the solution was to handle the load of at least 100 concurrent users.
After carefully analyzing the Customer’s needs, ScienceSoft’s team started implementing a product information management (PIM) solution in the cloud. Our team deployed the PIM solution in Amazon Web Services (AWS).
The project took 3 months. Our team started the work with implementing a data model that supported storing entities with an overall number of attributes of around 1,000. This was needed to allow the PIM solution to store large amounts of data.
To fulfill the Customer’s requirement on the solution’s ability to handle the load of 100 concurrent users, ScienceSoft’s specialists carried out testing of the solution under load and decided on its optimal configuration based on the testing results.
Besides, our team enabled the PIM solution to support data exchange in Excel-supported file formats and automated reporting on the collected college data. Also, the team made possible the integration of the PIM solution with third-party software like catalog or content management solutions by using RESTful API.
The PIM solution deployed in AWS enabled the Customer to arrange the centralized storing and effective managing of college data received from many sources and in various formats. The solution was in line with the Customer’s storage and load requirements. Also, the product information management solution was integration-friendly.
Technologies and Tools
Linux, Nginx, PHP, MySQL, Docker, PHPUnit, git.