An IT Services Contractor for a Government Department Saves over 1000 manual hours a year on handling personnel work history through automated data extraction
Customer Company Size
Large Corporate
Region
- America
Country
- United States
Product
- Astera ReportMiner
Tech Stack
- Microsoft Dynamics CRM
- SQL
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Cost Savings
Technology Category
- Analytics & Modeling - Data-as-a-Service
Applicable Functions
- Human Resources
Services
- Data Science Services
About The Customer
The customer is a trusted contractor for government departments and many commercial companies, offering logistics, IT, and training services for various specialized fields. Among other IT services, the company manages critical personnel data of government employees and processes it for reporting and analyses. The company is tasked with extracting and feeding information into the personnel CRM system while ensuring data accuracy and integrity. The government hires hundreds of employees monthly in various units. The IT contractor handles the work history records of these personnel, which it procures in PDF format from the government's main database system.
The Challenge
The IT contractor company was tasked with managing critical personnel data of government employees and processing it for reporting and analyses. The company had to manually download lengthy PDFs containing personnel information, sift through the entire document to extract key data fields, and pass it through SQL queries before transferring it to the personnel CRM system. This process was time-consuming and prone to errors, leading to bad data quality. It took an IT officer more than three hours to process a single personnel document, leading to delays and risk of bad data for analytics.
The Solution
The contractor company implemented Astera ReportMiner to automate data extraction from PDFs containing personnel information, and structure it to create SQL views to be used by subsequent integration and CRM tools. After implementing Astera ReportMiner, the contractor enjoyed an extremely simplified process with minimal manual work involved. Now, when a new personnel record is added to the customer's main database system, all the IT officer has to do is download the PDF and drop it into a folder from where ReportMiner automatically picks up the file. It takes about 10 minutes to complete these steps, but the minute it is done, everything is automated from thereon. The solution has prebuilt report models in place, allowing it to quickly read the PDFs, map all the fields, and pull out the required data from the key sections.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
