John Lito

Professional Summary & Career Background

Data Analyst with a strong academic and practical foundation in Food and Industrial Engineering, bridging traditional manufacturing domain expertise with modern data analytics. Over the past few years, my work has heavily focused on industrial data collection, productivity analysis, and manufacturing costing. I am now fully committed to a professional transition into data analytics, specializing in transforming complex operational data into actionable business insights. My technical stack includes Python, SQL, Power BI and Advanced Excel, enabling me to build end-to-end data pipelines, predictive models, and executive dashboards.

Key Achievements & Projects

• Industrial Absence Management App (Python/Streamlit): Engineered and deployed an interactive executive dashboard for monitoring direct labor indicators, featuring dynamic timeline filters, Pareto analysis, and advanced time-delta calculations.

• Building Management & Energy Efficiency Dashboard (Power BI): Developed a multilevel analytical dashboard monitoring 500 buildings across Portugal, integrating Azure Maps geolocalization, custom DAX measures for ESG metrics, and lifecycle renovation risk analysis.

• VFFS Film Waste Reduction Model (Advanced Excel): Created a flat relational model and automated operational control dashboard using Power Query and Power Pivot to monitor equipment degradation cycles and reduce plastic film waste in packaging lines.

• Machine Learning Attrition Prediction (Scikit-Learn): Built and evaluated classification models (Logistic Regression, Decision Tree, Random Forest) to tackle employee churn, prioritizing Recall and business cost-effectiveness.

Interests & Personal Approach

I approach technical challenges with an analytical engineering mindset, focusing heavily on meticulous data profiling, strict data cleansing, and selecting evaluation metrics that reflect real-world business outcomes. Outside of data analytics, I am an avid practitioner of electric guitar, focusing on rhythm techniques and complex structural problem-solving—a hobby that mirrors my structured, execution-oriented approach to coding and data architecture.

Now I'm looking for, Remote or flexible data analyst roles with international companies, particularly where an established background in industrial operations, manufacturing, or supply chain provides strong functional industry alignment.