Otimização de processos e indicadores através de VBA e SAP Script, orientados a Agile e Lean

• Autor(a) principal: Gabriel Silva, João Vítor
• Data de Publicação: 2021
• Tipo de documento: Trabalho de conclusão de curso
• Idioma: por
• Título da fonte: Repositório Institucional da UFU
• Texto Completo: https://repositorio.ufu.br/handle/123456789/32330
• topic: Automação de processos; Process Automation; Programação SAP e VBA; SAP and VBA Programming; Indicadores de Gestão da Qualidade; Quality Management Indicators; Entregas/Releases incrementais de valor; Incremental Valuable Releases; MVP; CNPQ::OUTROS::ENGENHARIA MECATRONICA

This work presents as mainly purpose to provide a detailed vision of the automation strategies and management tools development using VBA language, applied in the case study of various process from the quality sector of an agricultural vehicle manufacturing industry which employs the SAP system. More specifically, it broaches the set composed by task automatization, quality management indicators creation, VBA-SAP communication and user interface, responsible for productivity gains in the different addressed steps. Finally, the project development was consolidated with Agile and Lean principles and guidelines, resulting in the gain of value maximization and consistency in the development and planning decision taking. Therefore, the project was structured with incremental and frequent releases, combined to necessity prioritization through factors as context and impact. At the end of the five releases of the main project and the two releases of the parallel opportunities, it was possible to reduce time invested in the activities estimated annually in 50 hours in Laboratory’s reports generation, 792 hours in Non-Conformance Bench task and 196 hours in the management of the Non-Conformance Items Warehouse, as well as quality improvement on management decisions through developed indicators and available data augment.