Subcon Report Automation

Abstract

This project consists of the automation of a report that is done manually on a daily basis at the Finance Department of an aerospace company in Aguadilla, Puerto Rico. By automating the report generation, it is expected to save effort from dedicated resources and allocate those to other tasks. The automation was done through software, being the final product an application which allows the user to input source files and generate the report needed. The development used is based on the Agile methodology to ensure a streamlined process on which available resources can be maximized and the total workload needed for completion can be evenly distributed throughout time, as well as correcting deviations from the final goal by involving constant feedback from the customer. Additionally, the process implements several Design for Six Sigma (DFSS) tools to aid the completion of the automation. Final product was delivered to the customer once completion of requirements was met. Key Terms ⎯ Agile, automation, DFSS, software.