Q3's global sourcing model gives the maximum benefit to customers in terms of cost savings, improved quality, access to highly talented professionals, flexibility of operations and reduced time to market.
The client is engaged in the manufacturing, wholesaling and export business of gemstones, gold and diamond jewelry. The company manufactures precious stones including emeralds, blue & yellow sapphires, rubies. The company is also involved in cutting and polishing of these gems.
Client needed a system that should track all the transactions related to gem stone processing right from the rough to finished state enabling the management to effectively monitor their business by tracking day to day transactions and checking the stock of gem stones at various stages of production & analyzing the operational health of the business regularly.
It was required to customize the predefined stages in the system and add new stages in the production cycle & enable the user to define different gemstones that needed to be manufactured with their cut, shape, size and grade along with the production schedule.
It was required to support the breaking lots into sub-lots and issue it to different workers for processing & matching every receipt with the issue. The objective was to check for the difference in weights after taking into account the expected loss of percentage during processing, the weight of the processed material along with the unprocessed, rejected and waste material and to reduce the scope for pilferage.
It was also required to provide Item Performance Reports- Top selling; most profitable etc. which were to support the Import/export orders and invoices between multiple companies.
It was also required to track the losses throughout the system; identify the stages where the loss percentage was increasing and take necessary actions to reduce the loss. It had to support sending the rejected goods back to earlier stages for re-processing & allowing reallocation of workers to different stages whenever deviations in the plans were observed. It also had to also calculate the worker wages automatically considering the standard labor rate, worker’s rate and the TDS defined at the system level.
The client also wanted that it should handle the different units of weight like Carats, Grams, Kilograms and Milligrams & allow automatic conversion between different units of weights during transactions. It should then transfer the finished gemstones to an inventory of gemstones automatically & generate a Lot-wise profitability and a variety of other powerful reports with different views to analyze the operational health of the production process.
The application required by the client should be such that it should run on any platform and could be accessed from any location without installation process.
There were many challenges that were faced in the development of this application. The most difficult and challenging part of the application development was to migrate the source code of their existing application. The current application was however built in VB.net but the application overall business was written in stored procedures. So, the difficulty was to take out the business logic from the existing stored procedures and fit them in the business layer.
The second challenge was the selections of UI that would sort their purpose of installation at once and could be accessed from anywhere and yet give desktop experience. Silverlight was selected but then report was also required to be implemented into the same.
Q3 always emphasize the importance of building the application in a technology that helped its clients to manage the application. To meet all client requirements, Q3 came up with a team of dedicated developers and proposed the N-Tier SOA based architecture with Unity Framework, WCF Services, Silverlight 4.0, and Entity ORM Framework. The whole vast ERP application consisted of various modules which interacted with each other at every stage of transaction. So, the GMS System was organized into four main modules. These modules in combination would answer how a user can set the application settings, manage employees, do the workflow in production, create reports and make use of the utilities. It would describe all the operations that a user could perform using the system. For the Silverlight application, reporting tools were used to display the reports in the Silverlight environment.
|Target Deployment OS||
In this difficult economic environment, Symfo decided to outsource one of its most critical developments to Q3 Tech. We were definitely reluctant doing so at the beginning of the project. But rapidly we understood that Q3 had the necessary skills and professionalism to bring the project to a successful realization. It was not always easy primarily because of the differences of culture. However once we understood each other, things went much better. We also understood that such a difficult project needed intense communications between Q3 and our company. Our company works on two time zones (Europe and East Coast North America) and we were amazed by the availability of the Project Manager and his team. It really contributed improving communications between us.
Phase I of our product is now ready and we are quite happy with it. We are definitely ready to start Phase II with Q3 and we highly recommend them.