Intelligent Automation For A Big 4 Consulting Firm
About the Client
The client is one of the Big 4 managing consulting firms in the world
Business Requirement
- Input files need be automated to capture data
- User acceptance testing (UAT) is required
- Download invoices from various sites for web automation
- Every user had to execute the application on their local machine with a specific configuration file
Our Solution
- Creation of reusable and configurable python script for web automation to read and write the file formats
- In Web automation, it involved downloading invoices then editing those invoices with the user requirements, and then re-uploading them
- Achieved Data extraction from file formats like PDF, xlsx, docx, pptx, Dupli, csv
- Successfully generated “Python Script” from other “Python Script” depending on the user requirements
Process Flow
Business Outcomes
- Saved around 5000 hours of manual work
- Monetary saving around $5 million
- 1000’s of PDFs and invoices were downloaded in a click