Daniel Portero Carrasco

2017 → Present

Experience

  1. – Present

    BI consultant

    Freelance · Large beverage company

    Power BI reports and semantic models on data prepared in Azure Databricks.

    • Designed and built Power BI reports from scratch and reused corporate semantic models, keeping relational integrity and avoiding duplicates.
    • Extracted data with Power Query from Databricks and SharePoint, using parameterised models that make support and future changes easier.
    • Azure Databricks notebooks on Silver and Gold tables governed with Unity Catalog, within a Medallion architecture.
    • Row-level security (RLS) to restrict access to each report's data.
    • Reworked the logic of a daily sales report to address the root cause, with a custom calendar for day-by-day comparison against the previous year. The client explicitly recognised the result.
    • Direct liaison with the business to gather requirements and validate deliverables.

    Technologies

    • Power BI
    • DAX
    • Power Query
    • Azure Databricks
    • Unity Catalog
    • Medallion
    • SQL

  2. –

    BI analyst

    Aubay · Security company

    Power BI and SAP BusinessObjects reports, and involvement in a corporate data centralisation project.

    • Process improvement, loading new data, creating and maintaining procedures and resolving incidents, working with a range of stakeholders.
    • Development and maintenance of large stored procedures (over 8,000 lines) in T-SQL and PL/SQL on SQL Server and Oracle: loops, variables, parameters, WITH clauses and window functions.
    • Reports in Power BI and SAP BusinessObjects; data preparation and cleansing with Power Query and advanced DAX.
    • Involvement in a corporate data centralisation and migration project, moving data from sources such as SAP IQ, Oracle or SQL Server to Snowflake.
    • Agile (Scrum) environment with Jira and Confluence.

    Technologies

    • Power BI
    • DAX
    • Power Query
    • SAP BusinessObjects
    • SAP Data Services
    • T-SQL
    • PL/SQL
    • Data modelling
    • Jira

  3. –

    Senior SAP BusinessObjects consultant

    SEIDOR · Banking, insurance and retail

    Domestic and international BI projects on SAP BusinessObjects, from requirements to delivery.

    • Maintenance, management of development and production environments, new developments and migrations.
    • Almost two-year project (the first at SEIDOR) producing the P&L of a large financial institution end to end: centralising the data of four external managers, ETL with SAP Data Services, modelling in SAP Information Design Tool and Web Intelligence reports, including a process for manual adjustments after the monthly close.
    • End-to-end projects with prioritisation, progress tracking and stakeholder coordination. Led a team of 3 on one of them, managing its planning and delivery.
    • Training for domestic and international clients on Web Intelligence, SAP Analytics Cloud and SAP BusinessObjects administration (4.2 and 4.3).
    • SAP Certified Application Associate in SAP BusinessObjects BI Platform 4.3 (July 2022).

    Technologies

    • SAP BusinessObjects
    • SAP Analytics Cloud
    • SAP Data Services
    • SAP HANA
    • Power BI
    • SQL Server
    • Oracle
    • SAP IQ
    • T-SQL
    • PL/SQL
    • Data modelling

  4. –

    BI analyst

    Fujitsu · Education and banking

    Database maintenance and dashboards in QlikView and OBIEE.

    • Maintained and optimised the databases of educational institutions with PL/SQL, Toad and OBIEE.
    • Developed and maintained dashboards and reports in QlikView for a banking institution, including the ETL processes for data integration and transformation.

    Technologies

    • PL/SQL
    • SQL
    • Toad
    • OBIEE
    • QlikView