Sebastián Pons

Sole senior technical consultant and primary client-facing technical lead for international engagements, owning requirements, architecture, data modeling, ETL/ELT, and dashboard delivery. Delivered end-to-end Microsoft BI and data platform solutions under Agile/Scrum.

Migrated Power BI dashboards from the legacy CDS connector to OData Feed and remapped calculated measures to restructured CRM fields. Completed FOIPPA privacy compliance certification (Canada) during the engagement.

Built the central dataset and semantic model as a single source for reporting and delivered dashboards across multiple areas and Power BI workspaces. Implemented dynamic RLS connected to Dynamics 365 CRM and Dataverse via OData Feed.

Delivered Power BI dashboards for cases, client surveys, job assignments, and training-institute metrics. Built a DirectQuery model over CRM entities to provide real-time daily availability for appointment scheduling.

Implemented a corporate data warehouse and dashboards integrating computer/user inventory and license data from Active Directory, Office 365, and legacy hardware inventory systems.

Migrated legacy Reporting Services reports to Power BI, and later developed Dataflows and Datamarts as an ETL layer feeding Power Apps and organizational reporting. Delivered work through the consulting partner Larios.

Built data models, reports, and dashboards for the corporate data warehouse as part of a 6–7 consultant team. Worked across the Uruguay and Chile context during a multi-year program.

Delivered full-cycle data warehouse implementations from ETL design to reporting front-end across multiple industries. Worked with a multi-vendor BI stack including Pentaho, IBM Cognos, TM1, MicroStrategy, ODI, Hyperion Essbase, and Oracle/SQL Server/PostgreSQL/DB2.

Migrated a ministry data warehouse consolidating statistics from 8 public organizations, including fact tables exceeding 50 million records per year. Delivered dashboards using Report Designer and Saiku Cubes.

Rebuilt Hyperion Essbase ETLs and cubes and adapted ETL processes to a redefined Canadian Chart of Accounts. Delivered a new Essbase cube for the engagement phases.

Delivered corporate data warehouse ETLs and reporting for the gas and oil organization. Worked on the project using IBM Cognos 10.1, TM1, and Data Manager.

Built corporate data warehouses and multi-platform BI reporting solutions for large enterprises. Participated in high-volume, multi-organizational consolidation projects.

Implemented corporate data warehouse and reporting using Oracle BI EE components for answers, dashboards, and publishing. Reused Oracle BI EE capabilities across the engagement.

Developed reports for the banking engagement using Cognos and DB2. Built reporting components during the specified phase.

Worked on corporate data warehouse ETLs and reports for the telecommunications organization. Delivered using Cognos 8.4, DTS, and DB2.

Supported data warehouse delivery for a large retail group (~50 companies).

Delivered end-to-end corporate data warehouse work using MicroStrategy for the reporting layer.

Worked on automation for a government open-data portal.

Studied Information Technology at ORT University in Montevideo, Uruguay.

Completed 3 years of engineering studies at Universidad de la República in Uruguay.