Skip to content
View Osc2405's full-sized avatar

Block or report Osc2405

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Osc2405/README.md

πŸ‘‹ Hi, I'm Oscar Rosero

Analytics Engineer | BI Developer | Data Automation Specialist

I design and build data solutions that turn complex, disconnected data into reliable insights and automated workflows.

3+ years developing ETL pipelines, BI dashboards, and data automation tools for private sector clients across manufacturing, retail, and healthcare β€” including global accounts.

Background: Biomedical Engineer Β· Big Data Specialization Β· Team Lead Β· Technical Mentor


πŸ› οΈ Tech Stack

Data Engineering & Automation Python SQL SSIS ETL/ELT Azure Microsoft Fabric REST APIs

BI & Analytics Power BI Qlik Sense DAX Data Modeling Data Warehousing

Databases SQL Server PostgreSQL MySQL MongoDB

Libraries & Tools Pandas NumPy Git Jupyter


πŸš€ Current Focus

  • πŸ”§ Building a reusable Power BI documentation toolkit for automated metadata extraction
  • πŸ—οΈ Developing an automated sales ETL pipeline (Python + SQL Server) as a production-ready template
  • πŸ“Š Creating operational KPI dashboards for industrial and healthcare SMEs
  • ☁️ Expanding into cloud-native data architectures with Azure

πŸ“‚ Featured Projects

πŸ› οΈ pbi-docs

Python tool that automatically extracts and documents Power BI data models β€” tables, measures, relationships and DAX expressions. Solves a real gap in BI documentation workflows. Python Power BI Automation Data Engineering

πŸ”„ Automated Sales ETL Pipeline (in progress)

End-to-end pipeline that ingests raw multi-source sales data, standardizes formats, validates quality and loads into SQL Server. Python Pandas SQL Server SSIS

πŸ“Š Operational KPI Dashboard (in progress)

Power BI dashboard template for manufacturing and healthcare SMEs with documented DAX measures and data model. Power BI DAX Data Modeling


πŸ“« Let's Connect

πŸ“§ orosero2405@gmail.com πŸ’Ό LinkedIn πŸ“ Colombia Β· Open to remote opportunities & freelance projects

Pinned Loading

  1. plot2llm plot2llm Public

    Jupyter Notebook 1

  2. pbi-context pbi-context Public

    AI context engine for Power BI models β€” turns .pbit/.pbip (TMDL) into indexed, queryable context for LLM agents (MCP server, CLI, docs). Zero dependencies.

    Python 15 2