EXCEEDS logo
Exceeds
Andrea Ferracci

PROFILE

Andrea Ferracci

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.

Overall Statistics

Feature vs Bugs

67%Features

Repository Contributions

7Total
Bugs
2
Commits
7
Features
4
Lines of code
1,768
Activity Months3

Work History

February 2025

1 Commits

Feb 1, 2025

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

2 Commits • 1 Features

Dec 1, 2024

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).

November 2024

4 Commits • 3 Features

Nov 1, 2024

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.

Activity

Loading activity data...

Quality Metrics

Correctness82.8%
Maintainability82.8%
Architecture80.0%
Performance74.2%
AI Usage20.0%

Skills & Technologies

Programming Languages

HCLJavaKotlinShellTerraform

Technical Skills

API ManagementAzure Data FactoryBackend DevelopmentCloudData EngineeringData ModelingDevOpsInfrastructure ManagementInfrastructure as CodeJava DevelopmentTerraformUnit Testing

Repositories Contributed To

2 repos

Overview of all repositories you've contributed to across your timeline

pagopa/pagopa-infra

Nov 2024 Dec 2024
2 Months active

Languages Used

HCLJavaTerraformShell

Technical Skills

API ManagementAzure Data FactoryBackend DevelopmentCloudData EngineeringInfrastructure as Code

pagopa/pagopa-ecommerce-helpdesk-service

Feb 2025 Feb 2025
1 Month active

Languages Used

Kotlin

Technical Skills

Backend DevelopmentData ModelingUnit Testing

Generated by Exceeds AIThis report is designed for sharing and indexing