Complex Data Migration to new ERP
Learn how we helped a client migrate their large data to a new ERP system without losing the meaning and authenticity of the data
Client Profile
• A leading infrastructure company in Pune
Data Migration challenges
• They were using TALLY as their Accounting system for a long time
• They are now migrating to integrated financial accounting system in the new ERP
• Their accounting data has been downloaded in different excel sheets and has more than 11000 entries
• This data is not in single sheet but dependent data is in multiple excel sheets and to finalize it into the new ERP data upload template they have to refer to multiple excel sheets. This has following challenges.
• It is time consuming and Accounts team do not have bandwidth of dedicating people for that as they have lot of workload
• There could be manual errors while computing each row separately by referring to multiple excel sheets and then transferring final values to the template excel sheet
Our service
• We have programming expertise on variety of platforms including writing scripts in excel. Looking at the problem we decided to develop a program in Python
• The complex program took 3 days
• Testing and validation of sample data took one day
Our Value Addition
• The data was uploaded within minutes greatly saving their time and it was done with 100% accuracy