Alejandro Melchor

Designed and implemented ETL data preparation workflows using Tableau Prep and advanced SQL queries to feed centralized executive dashboards in Tableau Cloud. Automated operational and financial processes via Python scripts, transforming manual workflows into real-time decision-support systems.

Defined and monitored the performance indicator matrix (KPIs) in collaboration with department leads to align data analysis with strategic corporate goals. Developed dynamic analytical dashboards in Tableau, Python, and Excel to identify business trends and support executive decision-making.

Analyzed and identified innovation opportunities through market research and data analysis using Python and Tableau to support new product developments. Coordinated prototype manufacturing and product iterations with direct supplier collaboration, optimizing costs and ensuring quality standards.

Designed, created, and optimized SQL data tables and infrastructure in Google BigQuery to structure the BI department's storage framework. Developed Python scripts for automated extraction, cleaning, and transformation of data from multiple operational units.

B.S. in Engineering Physics with specialization in Neural Networks, Pattern Recognition, and Energy Conversion.

Completed courses on Introduction to Data Analysis, Data Preparation and Modeling with Power BI, Using DAX in Semantic Models, Designing Effective Reports, and Power BI Administration and Protection.