About the Client
The client is one of the Big 4 managing consulting firms in the world
Business Requirements
- 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