Automation of Report Generation and Data Maintenance leveraging RPA
About the Client
Client is an Indian lifestyle retailer for beauty, wellness, and fashion products. The client has multiple platforms and touch points ranging from web to mobile platforms.
Challenges
- Dealing with multiple files and huge volumes of data generated on a daily & monthly basis.
- Multiple variations for report generation and data updation added criticality to the process.
- Pre-condition check prior to report generation and change of process flow based on pre-condition decisions.
- Extracting multiple reports from multiple sources and consolidating files dynamically.
Solutions
- For report generation, a software bot was scheduled to launch a dedicated URL and log in to the portal.
- Post logging into the portal, the bot would navigate various tabs to select reports in scope.
- The bot would then generate the required reports, perform various validations, downloads and consolidate them.
- Post consolidation the reports to be sent to the key stakeholders as email attachments.
Result
- Turnaround Time Reduction – Turn around time of report generation was reduced by 80%.
- Accuracy – Bot acted exactly as per the business rules with all the actions with 100% accuracy.
- Cost and Resource Optimization – Software bots helped in reducing manual intervention as well as cost savings. Efforts saved ~1000+ manhours in a week.
