Andrea is available for hire

Andrea Angiolini

Verified Expert in Engineering

ETL Developer

Location

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.

PL/SQL SQL Oracle Databases RDBMS Oracle Opera SOAP Data Modeling Data Warehousing Data Engineering Windows Server XML Snowflake Business Intelligence (BI)Oracle Business Intelligence Enterprise Edition 11g (OBIEE)

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 years PL/SQL - 20 years Oracle - 20 years Hospitality - 20 years Oracle Opera - 18 years PL/SQL Tuning - 10 years Integration - 3 years MuleSoft - 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

Experience

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.

Skills

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

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

Tools

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

Paradigms

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

Libraries/APIs

REST APIs

Certifications

MAY 2020 - MAY 2024

MuleSoft Certified Developer - Level 1 (Mule 4)

MuleSoft

NOVEMBER 2005 - PRESENT

Oracle Certified Professional

Oracle

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.

Share your needs

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

Choose your talent

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

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