Skip to content
View ayorick23's full-sized avatar
:octocat:
:octocat:

Block or report ayorick23

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
ayorick23/README.md

Hi there, I'm Dereck Mendez

Data Analyst focused on Business Intelligence & Data Automation

👨‍💻 About Me

Data Analyst with hands-on experience transforming HR data into actionable insights and automated reporting solutions. I specialize in using Python (Pandas, NumPy) and SQL to clean, process, and analyze data, as well as building dashboards in Power BI and Looker Studio to support decision-making.

I have developed data pipelines to automate reporting processes, improving efficiency and data reliability. My focus is on solving business problems through data, particularly in areas like workforce analytics, performance tracking, and operational efficiency.

📌 Featured Projects

LMS Reporting Pipeline
Automated ETL pipeline that processes multiple Excel reports, cleans and transforms data using Python (Pandas), and consolidates it for analysis.

Notion Data Pipeline
Data pipeline that extracts data from the Notion API, transforms it, and generates structured datasets for reporting and analysis.

HR Data Analysis & Dashboards
Development of dashboards in Power BI and Looker Studio to track KPIs, recruitment metrics, and workforce data.

Tech Stack

📊 Data Analysis & Business Intelligence

power-bi-2021looker-studiopandasnumpymatplotlib

💾 Databases

Programming Languages sqlserver

🖥️ Programming Languages

Programming Languages

🔧 Tools & Technologies

Tools & Technologies jupyter-notebook

🧮 Extras

Extras

🕹️ What Drives Me

I am driven by the ability to turn raw data into meaningful insights that support better business decisions. I enjoy identifying inefficiencies, automating processes, and building data solutions that create real impact.

I am especially interested in leveraging data to improve organizational performance, optimize workflows, and support strategic decision-making.

🚀 Professional Focus

I am currently focused on Data Analyst and Business Intelligence roles where I can apply my experience in data analysis, automation, and visualization.

I bring a strong combination of technical skills and business understanding, especially in HR data, and I am ready to contribute by building efficient, data-driven solutions.

📩 Let's Connect!

LinkedIn Gmail GitHub Kaggle

Pinned Loading

  1. data-science-salaries-analysis data-science-salaries-analysis Public

    End-to-end Data Analysis project exploring global Data Science salaries using Python, SQL, and Power BI, including ETL, EDA, and interactive dashboarding.

    Jupyter Notebook 1

  2. lms-reporting-pipeline lms-reporting-pipeline Public

    ETL pipeline in Python that processes multiple LMS Excel reports, cleans and transforms data, and consolidates it into a single dataset for Power BI analysis.

    Python 1

  3. lms-users-sync lms-users-sync Public

    Python automation script that compares employee and LMS user datasets to identify users to create, update, or delete, generating actionable reports and logs.

    Python 1

  4. notion-data-pipeline notion-data-pipeline Public

    Python data pipeline that extracts data from Notion API, transforms it with Pandas, and generates automated Excel reports for Power BI dashboards.

    Python 1

  5. employee-report-automation employee-report-automation Public

    Automatización de reportes mensuales de empleados con Python. Este proyecto facilita la lectura de datos, limpieza, transformación y exportación de reportes consolidados en Excel, optimizando el ti…

    Jupyter Notebook