Verified Expert in Engineering
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.
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.
Hospitality Technology Consultant
- 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.
Head of Systems
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).
Director, Opera Hotel Suite, EMEA
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.
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.
The integration includes the exchange of reservations, rates, restrictions, and inventory.
Customer Data Mart
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
MuleSoft Certified Developer - Level 1 (Mule 4)
Oracle Certified Professional