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