Ernesto Suguer

Business Intelligence Expert

Ernesto Suguer

Former data analyst at Morgan Stanley.

Ernesto Suguer is a data analyst with over 15 years of experience in business intelligence and analytics fields. He is the director of analytics at Reef Technology and former data scientist and business intelligence specialist at Airbnb Canada. At Morgan Stanley, he served as a data analyst who designed BI applications using Oracle Essbase and regulatory reports and templates using the Clarity visualization tool. Ernesto also worked for Expedia, Intel, and Future Electronics.

Data AnalyticsData AnalysisBusiness IntelligenceData ScienceData MigrationData VisualizationData InsightsData WarehousingMS SQL ServerTableauPrestoPythonData IntegrationCompetitive IntelligenceOracle EssbaseMicrosoft SQL SSAS

Ernesto isAvailablefor projects

Work with Ernesto

Ernesto isAvailable

Hire

Employment Highlights

Director of Analytics

Reef Technology

August 2020 - Present (5 years 8 months)

Data Scientist & Business Intelligence Specialist

Airbnb

August 2019 - May 2020 (9 months)

Business Intelligence Director

Luxury Retreats & Airbnb

January 2013 - July 2019 (6 years 6 months)

Data Analyst

Morgan Stanley

July 2010 - January 2013 (2 years 6 months)

Business Intelligence Consultant

Luxury Retreats

May 2012 - January 2013 (8 months)

Data Analyst

Expedia Inc

May 2006 - April 2010 (3 years 11 months)

Education Highlights

MBA, Finance

Universidad del CEMA

January 2000 - December 2001 (1 year 11 months)

Electronics Engineering, -

Universidad Tecnológica Nacional

September 1991 - June 1997 (5 years 9 months)

Resume

Director of Analytics

Reef Technology

August 2020 - Present (5 years 8 months)

  • Managed the analytics infrastructure and logistics team.
  • Oversaw all activities and ensured alignment with the business's vision and objectives.

Data Scientist & Business Intelligence Specialist

Airbnb

August 2019 - May 2020 (9 months)

  • Managed the Lux Data foundation.
  • 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.
  • Worked hand in hand with product managers to provide data support and analysis for product launches and product enhancements.
  • Developed all the Lux certified metrics using Airbnb internal framework.
  • Taught regular SQL, Tableau and data classes (Airbnb Data University).
  • Performed regular data studies and analyses on Luxury Retreats sales performance.
  • Collaborated with the research team on finding data insights.

Business Intelligence Director

Luxury Retreats & Airbnb

January 2013 - July 2019 (6 years 6 months)

  • Reported to the vice president finance and operations.
  • Built the business intelligence (BI) department at Luxury Retreats (medium size company with over 300 employees).
  • Designed and implemented the BI department mission and vision from ground up.
  • Played a key role to position the BI department as the hub of knowledge and data that provides meaningful insights that drive more-informed decisions across the organization.
  • Designed the strategy and the roadmap of data and BI at Luxury Retreats.
  • Led the data transition and integration from Luxury Retreats to Airbnb.
  • Transformed the company from an intuition based to a fact-driven decision-making culture.
  • Provided competitive intelligence and actionable insights to all departments.
  • Coached and mentored a team of BI developers, statisticians and programmers.
  • Administered the Tableau Server of LRI.
  • Created complex reports and dashboards in Tableau Desktop.
  • Trained users of different departments to implement a self-service BI strategy.
  • Performed predicting modelling using SPSSS.

Data Analyst

Morgan Stanley

July 2010 - January 2013 (2 years 6 months)

  • Designed BI applications using Oracle Essbase.
  • Created regulatory reports and templates (Y12, non-consolidated reporting, FR-Y11, FR-2314) using Clarity visualization tool.
  • Designed reports using Microsoft Reporting Services, T-SQL, mxl and mdx.

Business Intelligence Consultant

Luxury Retreats

May 2012 - January 2013 (8 months)

  • Modelled a data warehouse using MS SQL Server applications.
  • Created ETLs using BIDS.
  • Implemented Tableau Server and Desktop and delivered departmental dashboards and reports.
  • Ran ad-hoc complex SQL queries to meet reporting needs.

Data Analyst

Expedia Inc

May 2006 - April 2010 (3 years 11 months)

  • Created and administered different SQL server databases and data marts aimed to support the product and account management department.
  • Developed different data marts adapting them to the business needs.
  • Designed reports using Microsoft Reporting Services, T-SQL, Excel, MS-Access, BO and Dundas data visualization software.
  • Developed and automated DTS packages (ETL) in SQL Server Business Development Studio to update the information of all the databases.
  • Analyzed information and made recommendations.
  • Provided SQL Server training to different departments across Expedia (Montreal, Arlington, TX, and London, England).
  • Administered a Microsoft Reporting Services Server and posted reports in it.
  • Wrote complex SQL scripts.
  • Created graphs, dashboards, and maps using Dundas Data Visualization package for MS Reporting Services.
  • Managed a group of people that map information into the databases.
  • Helped with long-term product planning and strategy.

Education

MBA, Finance

Universidad del CEMA

January 2000 - December 2001 (1 year 11 months)

Electronics Engineering, -

Universidad Tecnológica Nacional

September 1991 - June 1997 (5 years 9 months)