Omar Ahmed

Nowpay

• Senior Data AnalystFull Time

  Jan 2025 - Present -5 months

  Egypt , Cairo

  • Job Details:1.Business Analytics & Growth Optimization Financial Forecasting: Built analytics models (Python) using historical data for disbursement/collection projections, improving accuracy by 25%. Automated daily cash flow reports using SQL/Python pipelines, reducing planning cycle time by 30%. Fee Simulation & Optimization: Created simulation models to compare different fee structures with real-time models, optimizing revenue generation (+20%). Customer & Product Analysis: Implemented RFM analysis (Python) to identify high-value users, increasing disbursements by 10%. Designed behavioral cohorts (SQL) that boosted new user retention by 14%. New Feature Analysis & Recommendations: Evaluated impact of feature rollouts on key metrics, optimizing product decisions. Transaction & User Approval Cycle Analysis: Identified bottlenecks in approval processes, reducing user approval time to 7 days on average (was 35), and boosted new user approval rate by 40%. Risk & Collections: Developed scorecard models (Python) to flag high-risk accounts, reducing defaults by 12%. Optimized collection prioritization logic (SQL), cutting average delay to <1 day. Collection Workflow Optimization: Analyzed collections data to refine strategies, reducing overdue accounts. Call Center & Operations Analytics: Analyzed call center performance, reducing drop rate and improving first-call resolution (FCR) and average handling time (AHT). Optimized wait time strategies, enhancing customer experience. 2.Data Automation & Engineering Operational Tools: Created Flask app (Python/HTML/CSS) automating: Growth plan generation Target-setting workflows Create Collection/Disbursement forecast Account Managers Management Field team visit Management Marketing SMS efficiency tracking Impact: Reduced manual effort by 90% Growth Workflow & Operations Process Optimization: Streamlined end-to-end workflows, improving efficiency. 3.ETL Pipelines & Firebase Integration: Optimizing SQL queries (Window Functions, CTEs), reducing runtime by 40%. Designed ETL pipelines (Python/SQL), improving data processing speed by 60%. Automated reporting workflows eliminating manual errors. Integrated Firebase for automated user segmentation and push notifications. 4.Business Intelligence & Stakeholder Impact Reporting & Dashboards: Built 500+ MetaBase dashboards for team members, managers, and C-level executives. Standardized 20+ KPIs across departments using SQL-driven metrics. Created 5,000+ SQL queries, reducing ad-hoc data requests by 90%. Training & Enablement: Conducted 3 company training cycles for 50+ employees (Finance, Ops, Customer Service) covering: Excel fundamentals (PivotTables, Functions) MetaBase dashboard usage Results: 50% reduction in departmental dependency on analysts Employees gained new skills and now apply them in daily task and reporting
• Data AnalystFull Time

  Aug 2021 - Dec 2024 -3 yrs, 4 months

  Egypt , Cairo

  • Job Details:1.Business Analytics & Growth Optimization Financial Forecasting: Built analytics models (Python) using historical data for disbursement/collection projections, improving accuracy by 25%. Automated daily cash flow reports using SQL/Python pipelines, reducing planning cycle time by 30%. Fee Simulation & Optimization: Created simulation models to compare different fee structures with real-time models, optimizing revenue generation (+20%). Customer & Product Analysis: Implemented RFM analysis (Python) to identify high-value users, increasing disbursements by 10%. Designed behavioral cohorts (SQL) that boosted new user retention by 14%. New Feature Analysis & Recommendations: Evaluated impact of feature rollouts on key metrics, optimizing product decisions. Transaction & User Approval Cycle Analysis: Identified bottlenecks in approval processes, reducing user approval time to 7 days on average (was 35), and boosted new user approval rate by 40%. Risk & Collections: Developed scorecard models (Python) to flag high-risk accounts, reducing defaults by 12%. Optimized collection prioritization logic (SQL), cutting average delay to <1 day. Collection Workflow Optimization: Analyzed collections data to refine strategies, reducing overdue accounts. Call Center & Operations Analytics: Analyzed call center performance, reducing drop rate and improving first-call resolution (FCR) and average handling time (AHT). Optimized wait time strategies, enhancing customer experience. 2.Data Automation & Engineering Operational Tools: Created Flask app (Python/HTML/CSS) automating: Growth plan generation Target-setting workflows Create Collection/Disbursement forecast Account Managers Management Field team visit Management Marketing SMS efficiency tracking Impact: Reduced manual effort by 90% Growth Workflow & Operations Process Optimization: Streamlined end-to-end workflows, improving efficiency. 3.ETL Pipelines & Firebase Integration: Optimizing SQL queries (Window Functions, CTEs), reducing runtime by 40%. Designed ETL pipelines (Python/SQL), improving data processing speed by 60%. Automated reporting workflows eliminating manual errors. Integrated Firebase for automated user segmentation and push notifications. 4.Business Intelligence & Stakeholder Impact Reporting & Dashboards: Built 500+ MetaBase dashboards for team members, managers, and C-level executives. Standardized 20+ KPIs across departments using SQL-driven metrics. Created 5,000+ SQL queries, reducing ad-hoc data requests by 90%. Training & Enablement: Conducted 3 company training cycles for 50+ employees (Finance, Ops, Customer Service) covering: Excel fundamentals (PivotTables, Functions) MetaBase dashboard usage Results: 50% reduction in departmental dependency on analysts Employees gained new skills and now apply them in daily task and reporting