Summary
Overview
Work History
Education
Skills
Timeline
Generic

Miguel Eduardo Lopez Fernandez

Barrie,ON

Summary

Analytical and detail-oriented Data Analyst with strong experience in data management, visualization, and reporting. Skilled in transforming complex datasets into actionable insights that support strategic decision-making. Proficient in Power BI (DAX, Power Query), SQL, Excel, and Python, with expertise in data modeling, ETL processes, and dashboard development. Proven ability to collaborate with stakeholders, identify trends, and deliver solutions that improve efficiency and business performance.

Overview

4
4
years of professional experience
2
2
Languages

Work History

DATA ANALYST

Tiba Colombia
Bogota, Colombia
02.2023 - 04.2024
  • Developed interactive Power BI dashboards and reports using Power Query and DAX, enabling data-driven decision-making.
  • Performed advanced SQL queries to extract, transform, and analyze large datasets.
  • Built and optimized data models and ETL processes, improving reporting accuracy and efficiency.
  • Managed PRE and PRO environments, ensuring reliable deployment and system performance.

POWER BI CONSULTANT

OnBusiness Consulting
Bogota, Colombia
02.2022 - 02.2023
  • Designed and developed Power BI dashboards, data models, and DAX formulas, delivering customized visualizations aligned with client requirements.
  • Collaborated with stakeholders to gather business needs and validated data accuracy using Azure cloud architectures.
  • Executed full cycle of development, analysis, testing, debugging, documentation, and implementation for reports supporting Enterprise Data Warehouse (EDW) applications.
  • Conducted testing across Development, QA, and Production environments, ensuring quality delivery for key clients including Ecopetrol, Isagen, and Ramo.

DATA ANALYSIS SPECIALIST

Santander Consumer
Bogota, Colombia
06.2021 - 02.2022
  • Managed and analyzed large datasets related to vehicle and B&S credit portfolios, ensuring data accuracy and compliance.
  • Generated daily and monthly performance reports and prepared executive presentations for the Board of Directors.
  • Monitored and evaluated the performance of third-party collection agencies, providing insights to improve recovery strategies.
  • Utilized Power BI and Excel to create dashboards, visualizations, and advanced financial models.
  • Developed specialized reporting on judicialized credits, enhancing risk assessment and decision-making processes.

BILLING SYSTEMS OPERATION ANALYST

Bambu BPO
Bogota, Colombia
04.2021 - 06.2021
  • Managed and analyzed accounting and billing information, ensuring accuracy and timely reconciliation of transactions.
  • Processed and monitored unapplied payments within the billing system, reducing discrepancies and improving financial reporting.
  • Created and maintained documentation of integrations and process flowcharts, enhancing operational transparency and efficiency.
  • Oversaw and backed up the billing email system for Peru operations, ensuring data integrity and compliance.

ASSISTANT

Kpmg
Bogota, Colombia
01.2020 - 03.2021
  • Managed and processed large volumes of multi-client data, supporting the development of analytical processes and reporting solutions.
  • Executed data validation routines to identify fraud risks and unauthorized access, ensuring data security and regulatory compliance.
  • Developed and maintained procedures to improve data quality, integrity, and governance, enabling more reliable decision-making.

Education

General English as a Second Language -

Georgian College
Barrie, Ontario
08.2024

Systems Engineer -

Universitaria De Colombia
Bogota
07.2022

Skills

  • Data Analysis & Cleaning

  • Data Visualization & Reporting

  • Databases & Querying

  • Data Modeling & ETL

  • Programming & Tools

  • Core Competencies

Timeline

DATA ANALYST

Tiba Colombia
02.2023 - 04.2024

POWER BI CONSULTANT

OnBusiness Consulting
02.2022 - 02.2023

DATA ANALYSIS SPECIALIST

Santander Consumer
06.2021 - 02.2022

BILLING SYSTEMS OPERATION ANALYST

Bambu BPO
04.2021 - 06.2021

ASSISTANT

Kpmg
01.2020 - 03.2021

General English as a Second Language -

Georgian College

Systems Engineer -

Universitaria De Colombia
Miguel Eduardo Lopez Fernandez