Semiconductor Manufacturing - RPA for IIoT Analysis report

Inspiration

Semiconductor manufacturing consists of sophisticated, state of the art, 1000s of equipment. A multitude of IIoT sensors provides information about the equipment performance, which are analyzed using control charts. Daily review of these charts is essential to maintain high-quality standards of products. There are 200+ charts to be captured every day, doing this manually needs 5000+ annual hours. Due to time constraints very few critical charts were captured.

What it does

FDC system (Fault Detection and Classification) gets data from IIoT sensors of equipment and plots Charts. FDC Database has the list of Chart IDs that have spiked or exceeded above-set limits
RPA gets the list of Chart IDs that are out of control from FDC Database
RPA logs in to FDC UI, enters Chart ID and Date range
RPA takes snapshot of the chart that appears in the UI and saves the image to specified folder
Saved Images are then appended to PowerPoint File for review of Engineering Team. This File helps the team provide quick corrective actions to avoid equipment downtime and any degradation in product quality

How we built it

We gathered the pain points of Equipment Engineers in creating the report of OOC (Out Of Control) charts
Detailed Requirement Analysis was done. Hybrid solution of RPA and python was suggested. RPA to take the OOC charts’ screenshots and python to collate the image files into PowerPoint.
Bot account access was obtained for FDC Database and Front End
Bot used Database Commands to extract list of Chart IDs
Bot used Object Cloning commands for front end operations of FDC