Open to opportunities

Fernando Ospina

@fernandoospina

Message

Data Analyst skilled in automated data workflows and analytics solutions.

Spain

Message

What I'm looking for

I seek a role that fosters growth, encourages innovation, and values data-driven decision-making.

I am a dedicated Data Analyst with proven experience in designing automated data workflows and analytics solutions across various sectors including air cargo, finance, and logistics. My expertise lies in advanced SQL and Python, where I build scalable ETL pipelines and implement anomaly detection models. I am passionate about transforming manual processes into high-impact, data-driven operations that enhance decision-making and operational efficiency.

During my tenure as a Data Analyst Intern at Vantage Point, I developed machine learning models to forecast stock price movements and built automated reporting systems to detect market anomalies. My role as a Data Analytics Fellow at the London School of Economics allowed me to design end-to-end ETL pipelines and deliver BI reporting workflows, applying dimensional modeling and data transformation techniques to real-world simulations. I thrive in multidisciplinary environments and enjoy collaborating with teams to drive impactful insights.

Experience

Work history, roles, and key accomplishments

Current

Operations Specialist

Current

ALAIRE

Nov 2023 - Present (1 year 8 months)

Analyzed and monitored logistics KPIs to support process improvements in air cargo logistics using Excel-based tracking systems. Built an AI-enhanced n8n automation to extract, enrich, and transform semi-structured data into an Access-compatible format, eliminating manual entry.

Data Analysis Excel SOP流程设计 Logistics KPI Tracking Automation Anomaly Detection Process Improvement

Data Analyst Intern

Vantage Point

Dec 2024 - Apr 2025 (4 months)

Developed machine learning models using financial and sentiment data to forecast stock price movements. Built trend forecasting pipelines and automated reporting systems to detect market anomalies and signal patterns, supporting experimentation logic and insight generation for strategic decision-making.

Snowflake SQL Tableau Python Machine Learning Data Modeling Anomaly Detection Financial Analysis Data Reporting

Data Analytics Fellow - LSE Career Accelerator

London School of Economics

Jun 2024 - Apr 2025 (10 months)

Designed and documented end-to-end ETL pipelines to ensure data quality, consistency, and traceability, supporting regulatory and institutional reporting with Snowflake and SQL. Developed optimized SQL queries and dashboards in Tableau to analyze digital campaign ROI and stakeholder performance metrics.

Python Tableau SQL ETL Data Quality Plotly

Education

Degrees, certifications, and relevant coursework

London School of Economics

Data Analytics Career Accelerator, Programming & Data Science

Certificate in applied data analytics, BI reporting, and stakeholder-ready project delivery (NHS, Marketing Optimization). Applied statistical techniques and BI reporting to inform real-world business strategies.