MUHAMMAD's CV
MUHAMMAD ABDULLAH MUHAMMAD MUSA
Data Analyst & BI
Profile summary
Data Analyst and BI professional with experience across 6 organizations. Confident in ability to build ETL pipelines, design Power BI dashboards, and execute profitability audits. Committed to data-driven decision making and financial metric analysis.
Career highlights
ETL Pipeline Engineering: Built an ETL pipeline from the Dubai Land Department API using OAuth2 and delta-loading into a MySQL star-schema warehouse, reducing daily sync time from 60 minutes to under 5 seconds.
Revenue and Margin Analysis: Consolidated 4 source datasets into a star-schema Power BI model with a custom DAX calendar table to analyze 400M+ AED in annual revenue, identifying a 34.05% gross margin.
ECommerce Budget Optimization: Identified $108k in marketing budget to reallocate away from underperforming campaigns, representing 20% of total spend, by applying a cumulative-spend window function.
Customer Segmentation Modeling: Built a MySQL ELT pipeline to process 540,000+ rows of e-commerce data, cleaning 135,000+ null customer IDs and applying window functions to score customer segments.
Key skills
Professional experience
Manages analytics and reporting workflows, overseeing data integration pipelines and visualization systems. Responsibilities include building database architectures, implementing data quality validation methods, and designing executive business intelligence interfaces.
- Builds an ETL pipeline from the Dubai Land Department API using OAuth2 and delta-loading into a MySQL star-schema warehouse, reducing daily sync time from 60 minutes to under 5 seconds.
- Applies statistical data quality checks including IQR outlier capping and proximity-based imputation across a 52-week transaction dataset.
- Develops a Power BI dashboard featuring DAX measures to track 10,000+ monthly transactions, month-over-month growth, and geographic trends.
Coordinates cross-departmental reporting processes and stakeholder requests for data analysis, focusing on revenue streams and sales channels. Builds analytical models and tracks financial metrics to support business decision making.
- Consolidated 4 source datasets into a star-schema Power BI model with a custom DAX calendar table for MTD, YTD, and MoM time intelligence.
- Analyzed 400M+ AED in annual revenue, identifying a 34.05% gross margin above a 32% target and no cannibalization between retail and e-commerce channels.
- Surfaced a 351M vs. 57M AED revenue gap between Expat and National customers to inform marketing allocation.
Conducts profitability audits across 8 product categories and 4 sales channels, determining net margins through structured calculation of revenue, shipping, transaction, and platform fees.
- Modeled audit results as reusable SQL views using window functions and conditional aggregation.
- Identified $108k in marketing budget to reallocate away from underperforming campaigns, representing 20% of total spend, by applying a cumulative-spend window function.
Develops analytical models and customer segmentation frameworks, overseeing data cleaning and budget optimization initiatives for retail datasets. Focuses on identifying margin risks, structuring database pipelines, and translating score-based customer groupings into targeted financial strategies.
- Built a MySQL ELT pipeline to process 540,000+ rows of e-commerce data, cleaning 135,000+ null customer IDs and standardizing text dates.
- Applied NTILE(5) window functions and CTEs to score customers 1-5 across Recency, Frequency, and Monetary dimensions.
- Created CASE WHEN logic to map scores into personas, recommending a three-tier budget allocation to prevent a 30% discount over-subsidization risk.
- Writes dual SQL and Pandas implementations for 90+ programming problems covering window functions, CTEs, joins, and hierarchical queries.
- Designed mathematics curriculum frameworks for 6th, 7th, and 8th-grade students by translating complex quantitative concepts into accessible steps.
- Evaluated student performance through structured data and assessments, adapting instructional methods to improve foundational problem-solving skills.
Education
- Relevant coursework: Linear Algebra, Probability & Statistics, Numerical Analysis, Calculus