The client collects large volume of data daily from multiple plants located across multiple regions in North America and Central America for all the three shifts. Each manufacturing plant has multiple work-units, where they perform operations like body sealing, rubber extruding, etc. These working units are categorized into two different categories, Automated and Manual.
Operators enter Count Point Paper Work (CPPW) as they manufacture parts and submit it to supervisors. Supervisors besides monitoring have the responsibility to enter all data entered in CPPW in to the “production line report” for each shift (i.e., an excel file, which has large number of spreadsheets and of sizes above 20MB). These spreadsheets store operational level data for both the automated and manual working units.
