Data Analyst portfolio showcasing projects focused on Python, SQL, ETL pipelines, automation, Power BI dashboards and business insights.
- Python
- SQL / MySQL
- Power BI
- ETL / ELT
- Data Analysis
- Data Visualization
- Pandas / NumPy / scikit-learn
- Git / GitHub
- Automation & Reporting
- Business Intelligence
Interactive Power BI dashboard focused on marketplace analytics and KPI visualization.
🔗 Power BI Marketplace Dashboard
Design and implementation of an ETL pipeline integrating sales and inventory data into MySQL databases and Power BI dashboards.
Data modeling project focused on relational database design, SQL schema creation, normalization and analytical query optimization for business-oriented data structures.
🔗 View SQL Data Modeling Project
Collection of Python-based mini applications developed in Jupyter Notebook, focused on solving practical business and data-related problems through automation, logic implementation and analytical thinking.
🔗 View Python Project Notebook
Machine Learning project developed as part of the IBM Artificial Intelligence program, applying classification models such as Random Forest and Support Vector Machines (SVM) for predictive analysis of Credit Card fraud and model evaluation using Python and scikit-learn.
Business-oriented Data Analyst with experience transforming operational and business data into actionable insights. Strong analytical mindset combined with previous experience in management, finance, operations and strategic decision-making.
- LinkedIn: linkedin.com/in/roger-defez
- GitHub: github.com/rogerloop
- Email: companera.bastante_7z@icloud.com