Standardize Data Format
We made a careful analysis of the data and its structure in the POS system. After that, we coordinated with the POS system vendor to convert the data generated by the system into text format and create a secure server location for the data in the server. This ensured proper data alignment across diverse POS and seamless data reconciliation thereby making way for single, consistent, and accurate version of data.
Develop an Intermediary Application
Since the POS systems and report generation were hosted on two different application, we built an intermediator application to link the two. The intermediary application facilitated syncing data from POS application with the report generating application. Built on .NET platform, this application is able to log into the secure SFTP server, access the saved data.
Modify and Compute
The application was designed to carry out all the necessary data format modifications like inserting the sales transaction details into multiple tables, and computing the overall sales. The client's reports system reads the data from here and displays the sales transaction details. Additionally the application saves sales transaction details in the client’s database.