Gicela Vargas - Portfolio

About Me

Hi, I'm Gicela, a Civil Engineer and Environmental Specialist with a strong background in infrastructure projects, focused on auditing technical, administrative, and financial compliance in construction.

I've worked on real-world systems such as water treatment plants and infrastructure projects, developing a strong foundation in structured problem-solving, decision-making, and process optimization.

Today, I combine that experience with skills in data analysis, AI systems, and automation, allowing me to design solutions that connect real-world engineering challenges with modern technology.

My work focuses on building structured, data-driven systems that improve decision-making and automate complex processes.

Technical Skills

Data & Analytics

Python, Pandas, Power BI, Looker Studio, Statistical Analysis

AI & Machine Learning

Scikit-learn, NLP, LLM Pipelines, Bias Detection, AI Evaluation

Systems & Automation

Modular Architecture, Workflow Design, Data Pipelines, Automation Systems

Engineering

Infrastructure Auditing, Compliance, Environmental Impact Assessment

Languages

Spanish (Native), English (Fluent)

Experience & Education

Civil Engineer & Environmental Specialist
Experience in infrastructure projects, including auditing technical, administrative, and financial compliance.

Data & AI Training
Hands-on experience in data analysis, machine learning, and AI systems (IBM SkillsBuild, Guayerd).

Software Development (Ongoing)
Currently training as a Full-Stack Java Developer focused on scalable systems.

Featured Projects

Construction Compliance Analyzer

Python Streamlit Scikit-learn Plotly

ML-based compliance risk prediction with interactive dashboards. Aligned with Colombian regulations (NSR-10, Resolution 2115).

⚠️ Challenge: Integrate Colombian construction regulations into a predictive ML model
✅ Solution: Designed a rule-based + ML hybrid approach aligned with NSR-10 and Resolution 2115

Code Demo

Aurelion – End-to-End Data System

Python Pandas Scikit-learn Statistical Analysis

End-to-end data pipeline (EDA → modeling → insights). Regression, classification, clustering, and automated documentation.

⚠️ Challenge: Organize a full data pipeline across multiple analytical stages
✅ Solution: Built a modular system separating EDA, modeling, and statistical analysis

Code

Potenciar Solidario – NGO Financial Dashboard

Looker Studio Data Visualization Financial Analytics

Comprehensive financial analysis dashboard for a Latin American NGO. Revenue/expense tracking, donor insights, and operational transparency across 1,138+ transactions.

⚠️ Challenge: Transform raw financial data into actionable insights for NGOs
✅ Solution: Designed interactive dashboards in Looker Studio for KPI tracking and decision-making

Code Demo

LLM LATAM Content Pipeline

Python NLP Bias Detection

Structured content generation and validation for ethical LLM training. Bilingual datasets (EN/ES) with quality assurance workflows.

Code Sample Output

Water Quality Monitoring Dashboard

Python Streamlit Plotly

Real-time monitoring system for water treatment processes. Automated alerts, compliance tracking, and engineering-based visualizations.

Code Demo

AI Systems & Automation

Python Modular Architecture Workflow Design

Structured automation systems for real-world workflows. Modular architecture, task pipelines, and AI workflow integration.

🔒 Private collaboration

Contact

Interested in collaborating or have questions? Feel free to reach out!

Email
Remote, Global

#DataAnalyst #AIEthics #Automation #SystemsDesign #CivilEngineer #LatinAmericaTech