My personal website repository as an open source
This portfolio represents my skills and dedication to data analytics, engineering, and web development. The website was designed and coded by me using NodeJS, ExpressJS, EJS and Tailwind CSS. Feel free to explore, and don’t hesitate to reach out if you have any questions or would like to collaborate.
Data analytics final project at Coursera
Coursera helped me to jump into the Data world when I finished the Data Analytics career. This repository represents the Data analytics final project at Coursera. It has the intention of analyze a big data set related to human health. It was a long time ago, so it’s not my best work for sure, but I am totally proud of it.
Dashboard in PowerBI: Employees KPIS
Project completed for a U.S.-based client, specifically for the Human Resources department, aimed at analyzing employee-related data. The analysis focused on key metrics such as salaries, age ranges, gender distribution, employee evaluations, and employees by department, among others. This dashboard does not represent the final product delivered to the client but serves as a demo to illustrate the approach and insights provided.
Dashboard in PowerBI: Expenses VS Incomes
Work completed for a client who requested key performance indicators (KPIs) related to incomes and expenses, enabling comparisons against goals and budgets. The purpose was to provide insights into whether the allocated budget was sufficient to achieve the predetermined objectives. This dashboard does not represent the final product delivered to the client but serves as a demo for showcasing the approach and analysis performed.
Developed over 50 Looker reports and comprehensive LookML ecosystems for a major client
With extensive expertise in Looker and LookML, I designed and developed numerous dashboards and reports tailored to meet complex client needs. My work involved modeling complete LookML ecosystems while adhering to best practices to ensure scalability, efficiency, and maintainability. Please note that due to client confidentiality agreements, the repository and specific Looker content for this project remain private.
Data quality checker for CSV files
CSV Data Quality Validator is a Python-based tool that checks the integrity of CSV files by detecting duplicate primary keys, missing values, special characters, and duplicate column names. It helps ensure data consistency and quality before further processing or analysis.
Monthly Credit Card Statement Reader
Reads various files such as PDFs or .xlsx and extracts the values of each expense into a CSV for further data analysis and dashboard creation.
GitHub action for LookML content validator
For Looker users, this repository will help you to validate if a new pull request will break content in production. This GitHub action compares the content in development with the content in production. If changes from the new pull request break content, the GitHub action will fail and a label will be required to merge.
Dataform ecosystem with Slack alert integration
I assisted in the migration from BigQuery to Dataform to enhance control and flexibility over data tables. My contributions included creating validations, tables, SCD2 functions, and reusable functions that streamline project-wide updates by modifying only the function itself. Additionally, I implemented assertions, tags, and other features to improve data governance and workflow efficiency. I also supported the integration with Slack to enable real-time alerts for table assertions and validations, ensuring proactive monitoring and issue resolution. Please note that due to client confidentiality agreements, the repository and specific Looker content for this project remain private.
