Omar Ahmed

● Led migration to Microsoft Azure, designing architecture for PostgreSQL Flexible Server, Blob Storage, and Key Vault integration. ● Developed a custom internal sales portal using Node.js, JavaScript, HTML, and CSS for managing dashboards, client records, and non-relational data. ● Built and deployed ETL pipelines using Apache Airflow with custom operators, Docker environments, and automated logging/alerting. ● Designed scalable dbt models with staging layers, documentation, and tests... also improved pipeline quality and auditability across Azure, PostgreSQL, and Databricks environments. ● Optimized SQL performance (35% faster) through advanced queries (CTEs, window functions, recursion), schema tuning, and strategic PostgreSQL indexing. ● Built interactive Power BI dashboards featuring custom KPIs, drill-through, map visuals, and real-time filtering to support executive decision-making. ● Automated workflows using Python, Google Apps Script, and Airflow, and implemented CI/CD via GitHub Actions for testing, docs, and deployments.

● Developed Python pipelines for extracting and merging data from REST APIs (GA4, SEMrush, Similarweb) with full error handling. ● Created Power BI dashboards with user-friendly filters and real-time data views tailored for operations and marketing. ● Conducted market trend analysis and competitor audits, helping drive a 15% engagement boost and 12% reduction in booking cancellations. ● Delivered analytical reports integrating KPIs, traffic behavior, and conversion insights to guide decision-making. ● Automated weekly reporting flows using Python and Apps Script, ensuring consistency across multiple sources and teams.