
Andrea Ferracci developed and enhanced data ingestion and API management workflows in the pagopa-infra and pagopa-ecommerce-helpdesk-service repositories. He built automated Azure Data Factory pipelines to move and transform GEC data from Cosmos DB to blob storage, using Terraform for infrastructure as code and API Management integration. Andrea also implemented event deletion features to improve data hygiene and fixed ingestion scripts to stabilize data pipelines. In the helpdesk service, he addressed transaction field nullability and expanded unit tests, using Java and Shell scripting. His work improved data reliability, operational efficiency, and governance, demonstrating depth in backend and cloud engineering.

February 2025 focused on stabilizing transaction data handling in the pagopa-ecommerce-helpdesk-service by addressing default value management and field nullability, complemented by expanded unit tests to ensure robust behavior. The changes reduce data integrity risks and improve reliability of downstream processing.
February 2025 focused on stabilizing transaction data handling in the pagopa-ecommerce-helpdesk-service by addressing default value management and field nullability, complemented by expanded unit tests to ensure robust behavior. The changes reduce data integrity risks and improve reliability of downstream processing.
December 2024 — pagopa-infra delivered two focused changes to strengthen Technical Support workflows: (1) API Management integration for the 'nodo per payment manager' API by associating the apim_nodo_per_pm_api_v1 module with the technical_support_api_product, enabling the support team to manage and monitor the API within the Technical Support product. (2) GEC script ingestion fix to ensure correct ingestion behavior in the GEC component, reducing ingestion failures and aligning with existing data pipelines. These changes were implemented with clear PQ tracking (PQ-247, PQ-253) and tied to PR references (#2639, #2650).
December 2024 — pagopa-infra delivered two focused changes to strengthen Technical Support workflows: (1) API Management integration for the 'nodo per payment manager' API by associating the apim_nodo_per_pm_api_v1 module with the technical_support_api_product, enabling the support team to manage and monitor the API within the Technical Support product. (2) GEC script ingestion fix to ensure correct ingestion behavior in the GEC component, reducing ingestion failures and aligning with existing data pipelines. These changes were implemented with clear PQ tracking (PQ-247, PQ-253) and tied to PR references (#2639, #2650).
Month: 2024-11 Key deliveries and outcomes: - GEC Ingestion via Azure Data Factory: Implemented new Data Factory objects to ingest bundles, cibundles, touchpoints, and paymenttypes from Cosmos DB to blob storage; includes data flows, datasets, pipelines, data transformations, and scheduled triggers. Commits: 3cdbe9bd0701230e4db133c7db968bc9aec17828; 7a1d4b4d15258338b21b020e6b24af015c15a7d9. - Biz Transaction Service integration with API Management: Added biz transaction service API and associated it with the technical_support_api product in API Management by configuring Terraform resources and updating product IDs. Commit: 6e473187b1b15d56b8dc88a48cd9879e6b81813f. - Delete Excluded Events functionality: Implements handling and deletion of events marked as excluded (PQ-233), enabling removal of excluded events from the system. Commit: 04f5b5e96f28dfb114d53bc08882792ea38f3c15. Overall impact and accomplishments: Delivered end-to-end data ingestion pipelines for GEC data with automated scheduling, strengthened data governance with API Management integration for Biz Transactions, and improved data hygiene by enabling deletion of excluded events. These deliverables collectively enhance data reliability, operational efficiency, and governance, supporting faster analytics and safer production operations. Technologies/skills demonstrated: Azure Data Factory, Cosmos DB, Azure Blob Storage, data flows, datasets, pipelines; Terraform for API Management resource provisioning and product associations; API governance via API Management; data lifecycle management and event handling.
Month: 2024-11 Key deliveries and outcomes: - GEC Ingestion via Azure Data Factory: Implemented new Data Factory objects to ingest bundles, cibundles, touchpoints, and paymenttypes from Cosmos DB to blob storage; includes data flows, datasets, pipelines, data transformations, and scheduled triggers. Commits: 3cdbe9bd0701230e4db133c7db968bc9aec17828; 7a1d4b4d15258338b21b020e6b24af015c15a7d9. - Biz Transaction Service integration with API Management: Added biz transaction service API and associated it with the technical_support_api product in API Management by configuring Terraform resources and updating product IDs. Commit: 6e473187b1b15d56b8dc88a48cd9879e6b81813f. - Delete Excluded Events functionality: Implements handling and deletion of events marked as excluded (PQ-233), enabling removal of excluded events from the system. Commit: 04f5b5e96f28dfb114d53bc08882792ea38f3c15. Overall impact and accomplishments: Delivered end-to-end data ingestion pipelines for GEC data with automated scheduling, strengthened data governance with API Management integration for Biz Transactions, and improved data hygiene by enabling deletion of excluded events. These deliverables collectively enhance data reliability, operational efficiency, and governance, supporting faster analytics and safer production operations. Technologies/skills demonstrated: Azure Data Factory, Cosmos DB, Azure Blob Storage, data flows, datasets, pipelines; Terraform for API Management resource provisioning and product associations; API governance via API Management; data lifecycle management and event handling.
Overview of all repositories you've contributed to across your timeline