
Process Automation and Reports with Google Cloud Platform and Airflow
Solution: Agile Squad
Category: Process Automation
Area: Finance
Company: Aerospace
Technology used: GCP, Python, Java and Airflow
About the customer
The company is a leading Brazilian conglomerate in the manufacture of a wide variety of commercial, executive, agricultural and military aircraft, as well as aerospace parts and related services. The company stands out as the third largest manufacturer of commercial jets in the world, especially in the segment of up to 130 seats. With impressive net revenue in 2016 and a prominent position in the global market.
Challenge
The leading aerospace company needed to make corporate decisions quickly. The processing of this information came from various sources such as SAP, management bases and business rules, with a manual procedure and taking two weeks to prepare a report.
Solution
We standardize data in Datalake, implement integrated management and data governance, promote information reuse, adopt Google Cloud Platform (GCP) and Airflow to orchestrate processes. A user interface was developed using microservices. The process dealt with the company's sensitive financial information, confidentiality and information security were priorities.


Time reduction
preparation and validation of reports, allowing for faster decision-making.