1. Know-How & Impact/

Data Warehouse Architect

Download PDF | LinkedIn Profile

Professional Profile #

Data Warehouse Architect and IT professional with nearly 30 years of experience in designing, implementing, and managing complex, high-performing DWH solutions in Oracle and PostgreSQL environments. Expert in multidimensional data modeling methodologies (Kimball, Inmon) and in optimizing ETL/ELT processes and SQL queries on datasets ranging from hundreds of millions to billions of rows. Proven ability to lead end-to-end DWH projects — from requirements analysis to production deployment — ensuring data integrity, quality, and availability to support business decisions. Technical leadership and problem-solving mindset in international and full-remote contexts.

Technical Skills #

  • DWH Methodologies: Multidimensional Data Modeling (Kimball, Inmon), Star Schema, Snowflake Schema, Slowly Changing Dimensions (SCD Type 1/2/3), Bus Matrix design.
  • Oracle Databases: Oracle Database (8i through 21c), Oracle Exadata, Oracle RAC, Oracle Data Guard, Oracle Autonomous Database (ADB), Performance Tuning (AWR, ADDM, SQL Tuning Advisor), Storage Management (ASM), Backup & Recovery (RMAN), Oracle TDE.
  • PostgreSQL: PostgreSQL (14+), Query Optimization, Table Partitioning, pg_stat_statements, PgBouncer, Logical Replication, VACUUM/Autovacuum tuning.
  • Cloud Platforms: Oracle Cloud Infrastructure (OCI).
  • ETL/ELT Tools: PL/SQL-based ETL pipelines, Unix Shell Scripting, Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB, legacy projects).
  • Business Intelligence & Reporting: Oracle Analytics Cloud (OAC) — Semantic Model Designer, Reports, Dashboards.
  • Programming & Scripting Languages: SQL (advanced), PL/SQL, Unix Shell Scripting.
  • Operating Systems: Linux (RHEL, CentOS, Oracle Linux), Unix, Windows Server.
  • Other: Project Management (Agile/Scrum), Team Leadership (up to 7 people), Technical Training.

Work Experience #

IDEA DB CONSULTING S.R.L. — Rome, Italy (Full Remote Europe) #

Data Warehouse Architect | Oracle & PostgreSQL Expert | Sole Director | 2021 – Present

  • DWH Architect (for ATRADIUS) | 2022 – 2026:

    • Designed the Surety division Data Warehouse to consolidate data from Italy, Spain, France, and Northern European countries.
    • Integrated heterogeneous sources — Oracle databases, Microsoft SQL Server, and flat files from external systems — into a unified Oracle-based DWH.
    • Modeled core business domains: client portfolio, policies, contracts, billing, claims, and claims transactions.
    • Developed the entire data model and ETL layer — over 60K lines of PL/SQL code — with a real-time load monitoring system. Full daily ingestion from all three sources completes in under 2 hours.

  • DWH Architect (for FAI SERVICE) | 2021 – 2023:

    • Designed a Snowflake Schema data model on Oracle Analytics Cloud with ETL processes running on Oracle 19c in OCI.
    • Developed dashboards and reports on OAC for billing statistics, customer segmentation, client portfolio analysis, and cost/revenue tracking.

  • DWH Design and Architecture (Banking, Telepass, and other clients):

    • Defined and implemented Data Warehouse architectures for clients in the banking sector and Telepass partners, following Kimball and Inmon methodologies.
    • Applied multidimensional data modeling (Star Schema, Snowflake) to optimize analysis and reporting across datasets exceeding 2 billion rows.
    • Designed and developed ETL/ELT flows for integrating data from 15+ heterogeneous sources.
    • Designed and implemented DWH solutions on PostgreSQL as cost-effective alternatives to Oracle-based architectures, including partitioning strategies and query performance optimization.

  • Oracle Database Management and Optimization:

    • Advanced administration, tuning, and performance optimization of Oracle databases, including OCI and Autonomous Database environments.
    • Optimization of complex SQL queries — reduced batch processing times from 4 hours to under 30 minutes on critical analytical workloads.

  • Leadership and Consulting:

    • Technical guidance and training for internal teams and clients on DWH and Oracle/PostgreSQL best practices.
    • Installation and patching of Oracle databases, Oracle OEM and RMAN management.
    • Development of reports and dashboards with Oracle Analytics Cloud (OAC).

NIMIS CONSULTING S.R.L. — Rome, Italy (Full Remote) #

Oracle DBA | DWH Architect | Oracle Performance & Tuning Expert (for TIM / HUAWEI) | 2020 – 2022

  • DWH/DBA Project Administration:

    • Management and administration of over 30 critical Oracle databases (70+ instances) on Oracle Exadata clusters (3 and 5 nodes) for a major telecom client.
    • Responsible for 24/7 on-call availability of database systems supporting 20M+ prepaid mobile subscribers.
    • Managed fact tables ingesting up to 800M phone traffic records per day, requiring advanced partitioning and compression strategies.

  • Advanced Performance Tuning:

    • In-depth performance analysis via AWR, ADDM, and proactive tuning to ensure SLAs under 500ms response time on critical queries.
    • Implementation of indexing, partitioning, and compression strategies to enhance DWH system performance.
    • Data security management with Oracle TDE (Transparent Data Encryption).

IDEA DB CONSULTING S.R.L. — Rome, Italy (Full Remote) #

PL/SQL Expert | Oracle DBA & Tuning Expert (for FINWAVE S.p.A.) | 2020 – 2022

  • Advanced PL/SQL development and query optimization for financial applications processing millions of daily transactions.
  • Consulting on Oracle architectures and performance tuning best practices.

FREELANCE / INDEPENDENT CONSULTANT — Rome, Italy (Full Remote Europe) #

Oracle DBA | Oracle Performance & Tuning Expert | DWH Architect | 2013 – 2020

  • Design and development of Data Warehouses for various clients across banking, insurance, and telecom sectors, applying Kimball/Inmon methodologies on Oracle and PostgreSQL platforms.
  • Development of ETL/ELT processes for DWH data loading — built pipelines handling 500M+ rows per load cycle.
  • Specialized consultancy on Oracle and PostgreSQL databases, SQL performance tuning, DWH architectures, PL/SQL, and ETL design.
  • Team leadership (teams of 3–7 people) in multicultural contexts, managing tasks and priorities using Agile methodology.
  • Created reports and performed data analysis with Oracle Analytics Cloud (OAC).

AUSELDA AED GROUP S.P.A. — Rome, Italy #

Data Warehouse Architect | Performance & Tuning Expert | Oracle Project DBA (for Public Administration) | 2009 – 2013

  • Data Warehouse design and modeling (Kimball/Inmon) for Public Administration entities.
  • Development of ETL/ELT processes and optimization of complex SQL queries.
  • Oracle Warehouse Builder (OWB) product specialist.
  • Technical management of DWH projects and user training.

ORACLE ITALIA S.R.L. — Various Locations, Italy & Madrid, Spain #

Data Warehouse Architect | Oracle DBA | DWH Designer | SQL & PL/SQL Developer | Training Specialist | 1999 – 2009

  • DWH Architectural and Development Roles (2001-2009):

    • Design and development of Data Warehouses for leading clients in Telco (TIM, Vodafone, TRE), Finance (Banca d’Italia, Generali, RAS), Pharmaceutical (Menarini), and other sectors.
    • Implementation of data models (Kimball/Inmon) and ETL/ELT processes with Oracle Warehouse Builder.
    • Consultancy on SQL Performance & Tuning, PL/SQL, BI Reports (Oracle Discoverer, HTMLDB), Oracle OLAP.
    • International engagement with Vodafone Spain (Madrid).

  • Training Specialist (2000-2001):

    • Delivered Oracle courses: SQL (Basic and Advanced), PL/SQL (Basic and Advanced), Oracle Database Administration, Performance and Tuning, Oracle Discoverer, Forms, Reports.

  • Web Developer | Oracle SQL & PL/SQL Developer (ETNOTEAM S.P.A. - 1999): Web portal and client-server application development.

S.EL.DAT. S.P.A. — Rome, Italy #

Software Developer (for Telecom, Rover Italia) | 1997 – 1999

  • Client-server application development, Junior Oracle DBA, DB monitoring.

Education and Training #

  • Faculty of Computer Engineering (Software Engineering) | University of Rome Tre, Rome | 1994 – 2000
  • Scientific High School Diploma (EQF Level 4) | Liceo Scientifico Isacco Newton / Manieri Copernico, Rome | 1988 – 1993
  • Advanced English (C1/C2) | The British Council (Level 4A), Rome | 2003 – 2004

Selected Training and Continuing Education Courses:

  • Scrum Agile — Randstad/Forma.temp (May 2024)
  • Project Management — Randstad/Forma.temp (May 2024)
  • Data Wrangling, Analysis and AB Testing with SQL — Coursera, University of California Davis (April 2021)
  • Data Science on Google Cloud Platform: Designing Data Warehouses — LinkedIn Learning (September 2020)
  • Multiple Oracle 12c specialization courses (Administration, Security, Backup and Recovery, Advanced SQL, Performance Optimization) — LinkedIn Learning (2020)
  • MySQL Installation and Configuration — LinkedIn Learning (August 2020)
  • Learning Git and GitHub — LinkedIn Learning (August 2020)

Languages #

  • Italian: Native
  • English: C1/C2 (Fluent, professional)
  • Spanish: C1 (Fluent)
  • Romanian: C1 (Fluent)
  • French: A1/A2 (Basic)

Soft Skills #

  • Analytical and Creative Problem Solving
  • Teamwork and Collaboration in International Contexts
  • Project Management (Requirements definition, Prioritization, Gantt charts, ERD)
  • Effective Communication and Stakeholder Engagement

I consent to the processing of my personal data pursuant to Art. 13 of EU Regulation 2016/679 (GDPR).

Rome, March 2026

Download PDF | LinkedIn Profile | Back to previous page