Ernesto Suguer

Played an integral role during the biggest data migration ever performed at Airbnb. It included building new data sources, integration to Airbnb infrastructure, data cleansing, and setting up a new Tableau Server.

At Luxury Retreats, leadership had visibility through basic reports and CSV data dumps. As a consultant, I met with all the stakeholders and modeled the Data Warehouse. I worked with engineering on data requirements, IT for setting up the infrastructure for data and reporting, and with all the business leaders to model the data warehouse around the business needs. After building the DW there was consistency in the numbers, data was clean and accessible across the organization.

I worked with controllers to set many of the Federal Reserve regulatory reporting (Y12, FR-Y11, and FR-2314) through a series of cubes and data entry tools like IBM Clarity. I was part of the team that set up the Basel 3 requirements.

At Expedia, I was part of the connectivity team that managed the connections from chains and hotels to the Expedia database. I built a connectivity data mart that hosted most of the systems used by hotels across the globe. This data mart was the only one in the world with this kind of information.

I conducted data analysis to understand the demographic of potential students for the school in the Montreal market. The project involved data acquisition and analysis, and the output was the number of families the school could potentially target by each of the markets in the Montreal region.