Aviation Safety Data Analyst | Excel Specialist
Welcome to my professional portfolio. I’m Carlos, an aviation safety data analyst specializing in transforming complex datasets into actionable insights. With a strong command of Excel and a deep understanding of safety reporting systems, I help organizations elevate safety performance through data.
About Me
I’m passionate about aviation safety and data analysis. Over the years, I’ve developed a unique skill set that bridges the gap between operational safety and data science. My work revolves around automating data handling, identifying safety trends, and providing clear visual insights for decision-makers.
- Excel & VBA Automation
- Aviation Safety Management Systems (SMS)
- Safety Trend Dashboards
- Root Cause Analysis and Risk Classification
Skills & Tools
- Excel (Advanced, VBA Automation)
- Python
- Powerpoint & Word
- AI
- Coruson
- SMS framework knowledge
- Data Visualisation and Reporting
Projects
Report Requests and Debriefs Tool
Created an Excel-based tool using VBA to automate report requests and debriefs via Outlook and app notification to relevant crew members . Resulted in faster turnaround times and improved consistency in communication.
Safety Check Analysis Tool
Developed a system that analyzes safety checks conducted across the operation. It identifies recurring findings, trends linked to specific crew members or locations, and flags items that require follow-up action—supporting a proactive approach to compliance and risk management.
Query Assignment & Tracking Tool
Designed a tool to manage safety-related crew queries. It assigns incoming queries to the appropriate safety administrators, sets reminders, tracks status updates, and provides statistical overviews of query handling performance over time.
Coruson Data Processor for Weekly Reporting
Built a dynamic tool that retrieves Excel data extracted from Coruson, automatically cleans and adjusts the data structure, and prepares it for use in weekly management reports—reducing preparation time and improving accuracy.
Admin Activity Tracker & Log Search
Developed a comprehensive tracker that logs all actions taken by safety administrators. It includes a searchable interface allowing rapid filtering by crew ID, report number, flight number, or date, significantly improving traceability and internal auditing.