The Background :
One of Webuters Technologies’ US-based clients was looking for a solution to navigating and managing the corporate telecom expenses. The client had the huge data and he wanted an accurate and error-free report on a daily basis based on that data. The client was looking for a less labor intensive solution with zero error reports.
(a) The client used huge amount of data for the daily reports. The volume of data used for daily reports was about 4K-10K.
(b) In manual composing, the report creation task was error-prone and required a good amount of time and labor.
(c) The data required for the daily reports was so huge that generating an error-free daily report was not possible manually.
(d) With such a huge amount of data, finding out the error was as difficult as creating an error-free report. Hence there was no scope of error-free daily reports.
(e) If done manually it was really a time taking the process to generate the report and that too not accurate.
The Webuters Team Solution
(a) We provided the GUI to the client, with the help of which the they can link the file (CSV) column with DB column. It’s a one-time process and a time saver.
(b) They need to drop the CSV (the files that need to be processed) at one particular location only so that it can be accessed easily.
(c) Our solution enabled the client to upload the CSV in zip format as well.
(d) Our solution involves a script that runs and checks the mapping exists or not between the files. If it exists that means now the file will be processed, and both the success and failed records will be handled easily.
(e) In case of a failed record, another copy of record is saved and after rectifying and correcting the error, the record can be updated and uploaded easily without any data loss.
The solution helped our client achieve:
(a) Our solution eliminated the manual work of daily report generation.
(b) Now the client gets an error-free report in less time.
(c) The solution allows the client to feed more data to get accurate reports every time.
Team Size – 5