Andrea Angiolini, Developer in New York, United States
Andrea is available for hire
Hire Andrea

Andrea Angiolini

Verified Expert  in Engineering

ETL Developer

New York, United States
Toptal Member Since
March 25, 2021

Andrea's been working in hospitality technology for over 20 years and has been involved in almost every aspect of it: database administration, SQL reports, database development (PL/SQL), product management, project management, design of new products, implementation, process automation, support, training, and senior management. Andrea has delivered several projects involving coordinating teams, including OTA-based integrations, full end-to-end solutions, and a full customer intelligence database.


Sapiamus LLC
Database Administration (DBA), Hospitality, Oracle PL/SQL, CRM APIs, MuleSoft...
Global Hotel Alliance
PL/SQL, SQL, Integration, MuleSoft, Database Administration (DBA), PL/SQL Tuning
Micros Systems, Inc.
PL/SQL, SQL, Database Administration (DBA), Oracle, Product Management...




Preferred Environment

Windows, Oracle SQL Developer, Anypoint Studio

The most amazing...

...recent achievement was architecting, coding, and implementing a robust data mart solution that powers one of the largest hospitality loyalty programs.

Work Experience

Hospitality Technology Consultant

2019 - PRESENT
Sapiamus LLC
  • Created several OTA-based integrations with major hospitality industry players for distribution and loyalty between cross-enterprise level central systems and hotel brands using Oracle PL/SQL, MuleSoft, OTA specs, XML, REST APIs, and JSON.
  • Designed, developed, and implemented a full customer intelligence database (along with web APIs) through the consolidation of all available data sources: stay information, reservations, web analytics, CRM analytics, and financial transactions on PL/SQL.
  • Oversaw the technology strategy (based on REST APIs, MuleSoft, Oracle PL/SQL) for the implementation of a complete redesign of a major loyalty program in the hospitality industry.
Technologies: Database Administration (DBA), Hospitality, Oracle PL/SQL, CRM APIs, MuleSoft, Integration

Head of Systems

2013 - 2019
Global Hotel Alliance
  • Defined, documented, and directed the implementation of the technology strategy for the Alliance, securing the support of C-Level executives of all participating brands.
  • Managed, customized, and evolved a complex 3-tier (hotel/brand/alliance) customer information system and distribution platform that supports a global loyalty program and the Alliance's website and mobile app.
  • Designed, coded, and implemented the full end-to-end solution for a member data mart and loyalty enterprise-level data warehouse. Exposed aggregated data with web APIs for cross-enterprise consumption.
  • Automated data quality processes (member profile merges, ETL data error management) using a purpose-built rule-based engine.
  • Implemented the full migration of a BI system to the cloud (OCI) and established data flows with different cloud environments (Azure, MuleSoft Anypoint, and Oracle Hospitality).
Technologies: PL/SQL, SQL, Integration, MuleSoft, Database Administration (DBA), PL/SQL Tuning

Director, Opera Hotel Suite, EMEA

2003 - 2013
Micros Systems, Inc.
  • Expanded and reorganized the team to remove single dependencies.
  • Actively participated in the creation and launch of a new business intelligence module based on Oracle PL/SQL and Oracle BI (OBIEE).
  • Created tools for the automated monitoring of GDS logs, Oracle performance logs, and team performance on support cases using Oracle PL/SQL and Oracle forms on an Oracle database.
Technologies: PL/SQL, SQL, Database Administration (DBA), Oracle, Product Management, Project Management System (PMS), Oracle Opera

Support Manager

2000 - 2003
GP Dati SpA
  • Increased customer satisfaction through extensive training, quality monitoring, and direct liaison with the development team.
  • Built a knowledge management repository with a database of solutions and troubleshooting templates.
  • Designed, developed (using Oracle PL/SQL and Oracle Forms), and implemented the automation of ticket processing through an integration between support and phone systems.
  • Alternated between emote support and on-site implementation projects to facilitate customer relationships and build field experience for the team members.
Technologies: Database Administration (DBA), App Support, Management, Hospitality, Oracle SQL, PL/SQL, Customer Service

ARI Integration

I designed, coded, and implemented a full OTA-based ARI integration between a popular hospitality central reservation system and a major channel manager.
The integration includes the exchange of reservations, rates, restrictions, and inventory.

Loyalty Integration

I designed, coded, and implemented a full OTA-based loyalty integration between a popular hospitality central reservation system and a major property management system. The integration included member profile lookup, enrollment, and synchronization.

Customer Data Mart

I architected, designed, developed, and implemented a data warehouse solution. This data warehouse consolidated customer information by aggregating all data into a simple, independent, transportable, and shareable database architecture (data mart), which provided single-source-of-truth access to customer intelligence for a diverse, cross-enterprise audience, globally.


SQL, XML, Snowflake, Excel VBA


Oracle, Windows Server, MuleSoft, Windows


PL/SQL, Oracle Opera, Oracle PL/SQL, Databases, RDBMS, Oracle RDBMS, JSON, Database Administration (DBA), Oracle SQL Developer, Oracle SQL


Hospitality, PL/SQL Tuning, SOAP, Product Management, Data Modeling, Data Warehousing, Data Engineering, Integration, Project Management System (PMS), App Support, Customer Service, CRM APIs, Data Warehouse Design


Anypoint Studio, Oracle Business Intelligence Enterprise Edition 11g (OBIEE)


Business Intelligence (BI), Management, Oracle Database Architecture, ETL



MAY 2020 - MAY 2024

MuleSoft Certified Developer - Level 1 (Mule 4)



Oracle Certified Professional