Andrea Lopera
Hi! I’m Andrea, a data scientist with a background in industrial production, education analytics, and process optimization. I specialize in transforming messy systems into streamlined, data-informed workflows that drive operational clarity and performance. My portfolio blends machine learning, business intelligence, and operations strategy—centered on real-world impact across sectors like manufacturing, energy, and education.
View the Project on GitHub andrea-lopera/portfolio.github.io
Core Skills
Python (Pandas, NumPy, Scikit-learn, PyTorch) • SQL • Power BI • Tableau • SPSS • Excel • Geospatial Analytics • Data Modeling • Workflow Automation • Dashboards • ERP & QMS Systems • Lean Manufacturing
Projects
Production & Operations Analytics
Production Line Intelligence Dashboard | Tableau, Python, SQL | 2025
An end-to-end analytics solution to track KPIs, root causes of downtime, and rework in a simulated manufacturing line.
- Built SQL queries and Python scripts to preprocess operations data
- Designed a Tableau dashboard to visualize trends and highlight bottlenecks
- Emphasized decision support for production managers and process engineers
Used Car Price Prediction | Regression Models, Python | 2023
Built and evaluated nine machine learning models to estimate used car prices with over 90% accuracy.
- Combined regression (Linear, Ridge, Lasso) with tree-based methods (RF, KNN)
- Enhanced model performance using feature engineering and external datasets
- Proposed XGBoost-based strategy to improve real-time predictive accuracy
Geospatial & Public Sector Analytics
Mapping Water Bodies for Drought Relief | Python, Power BI, Folium | 2025
Created a geospatial analytics tool to support drought response using NASA & USGS satellite data.
- Mapped nearby water sources to drought regions using spatial joins and clustering
- Delivered insights via Power BI dashboards and interactive Folium maps
- Empowered environmental planners with data-driven visibility into critical areas
- The black line represents the actual NDWI trend, indicating real water conditions in the region.
- The blue dashed line shows predictions from SARIMA.
- The green lines shows improved predictions.
AI & Computer Vision
Facial Recognition System | PCA, LDA, Python | 2024
Built a facial recognition system using classical techniques (Eigenfaces, PCA/LDA).
- Applied transfer learning, face alignment, and reconstruction evaluation
- Improved classification accuracy by 43.7% over the baseline
- Combined dimensionality reduction and clustering to optimize predictions
Image Classification with CNNs | ResNet-18, PyTorch, Transfer Learning | 2024
Trained deep learning models from scratch and via transfer learning.
- Achieved 93.4% accuracy with fine-tuned ResNet
- Used PyTorch Lightning for reproducibility and early stopping
- Documented results with metric analysis and visual tracking
Experience Highlights
Production Supervisor – Siemens Smart Infrastructure, TX (2024)
Supported switchgear production for EV/energy sector clients.
- Analyzed material flow and KPIs to uncover throughput blockers
- Participated in lean initiatives and floor coordination
- Left early to complete M.S. in Data Science
GTA & Research Analyst – Texas Christian University (2021–2022)
Improved student success reporting and education research.
- Built Excel dashboards for course performance trends
- Analyzed survey and assessment data for departmental use
- Standardized workflows for longitudinal reporting
Data & Ops Intern – M3 Glass Technologies (2019, 2021)
Designed Power BI dashboards and integrated ERP datasets.
- Monitored rework, delays, and resource usage
- Applied lean methods to reduce waste in production planning
Production / Quality Roles – Laminaire, Soinco, Termofijo (2010–2014)
Led ERP-based production planning, ISO 9001 QMS implementation, and international logistics coordination.
- Streamlined workflows across packaging, thermoforming, and export operations
- Built quality dashboards and conducted internal audits
- Spearheaded supply chain coordination across borders
Education & Training
- M.S. Data Science – UT Arlington (2025)
- M.Ed. Mathematics – Texas Christian University (2022)
- B.A. Education – UT Arlington (2020)
- Production Engineering – EAFIT University, Colombia (2016)
- Quality Assurance Tech. – ITM University, Colombia (2009)
Certifications & Training
- MIT Applied Data Science Program (2023)
- NASA ARSET: Machine Learning for Space Exploration (2023)
Let’s Connect
If you’re seeking someone who brings operational insight + data fluency, I’d love to connect. Whether it’s improving manufacturing workflows, optimizing public service delivery, or designing analytics for learning systems—I bring both structure and strategy to the table.
andrealopera.github.io • LinkedIn • ✉️ Email Me