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

Andrea Angiolini

Verified Expert  in Engineering

Bio

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.

Portfolio

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

Experience

SQL - 20 yearsPL/SQL - 20 yearsOracle - 20 yearsHospitality - 20 yearsOracle Opera - 18 yearsPL/SQL Tuning - 10 yearsIntegration - 3 yearsMuleSoft - 3 years

Availability

Part-time

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.
MAY 2020 - MAY 2024

MuleSoft Certified Developer - Level 1 (Mule 4)

MuleSoft

NOVEMBER 2005 - PRESENT

Oracle Certified Professional

Oracle

Libraries/APIs

REST APIs

Tools

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

Languages

SQL, XML, Snowflake, Excel VBA

Platforms

Oracle, Windows Server, MuleSoft, Windows

Storage

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

Paradigms

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

Other

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

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring