محمد مرعي

• Architected end-to-end ETL pipelines in Python (pandas, NumPy) to consolidate 8 Excel files with thousands of
records into a single, analysis-ready dataset.
• Engineered automated data cleaning solution using regular expressions and custom algorithms to standardize incon
sistent text entries, eliminating manual preparation work.
• Diagnosed and resolved critical data integrity bug caused by complex Excel formatting, implementing robust parsing
logic to guarantee accurate extraction and alignment.
• Developed and deployed 7 interactive dashboards using Plotly with drill-down capabilities, providing stakeholders
self-service access to real-time business metrics.
• Performed statistical analysis identifying key cost drivers, revealing 92% of cost increases concentrated in just 3
operational areas out of 50+.
• Delivered executive-level technical documentation and actionable recommendations that directly informed cost-reduction
strategy.

• Developed and maintained booking workflow modules and affiliate tracking features using Flask (Python), HTML/CSS,
and SQL databases.
• Implemented automated testing and code optimization to improve system reliability for daily operations.
• Collaborated with stakeholders to troubleshoot technical issues and deliver feature enhancements.

• Provided technical support, system administration, and automation scripting for recurring operational tasks.