
Fatimah Farouk
Verified Expert in Engineering
Data Analytics Engineer and Developer
Cairo, Cairo Governorate, Egypt
Toptal member since February 6, 2024
Fatimah led growth analytics in four live fintech products in the Gulf area, including the Saudi model of Robinhood. She's generated $260+ million in revenue, implemented an event tracking system on iOS and Android apps, and continuously improved user funnels using analytics and statistical A/B testing. Fatimah uses advanced SQL, Python, CRM, and business intelligence technologies, among other tools, to achieve her project goals.
Portfolio
Experience
- SQL - 4 years
- Economics - 4 years
- Python - 3 years
- CleverTap - 2 years
- Metabase - 2 years
- Google Analytics 4 - 2 years
- Adjust - 1 year
- MongoDB - 1 year
Availability
Preferred Environment
SQL, Slack
The most amazing...
...thing I've built is an alert system that helps detect internal auditing activities and financial risks for Awaed, a fintech startup in the Gulf market.
Work Experience
Growth Data Analytics Engineer
Awaed
- Conducted frequent A/B tests in targeting campaigns to optimize North Star Metric (NSM) conversions, resulting in data-driven insights and continuous improvement to achieve better performance and desired outcomes.
- Developed over five weekly SQL and NoSQL queries for business ad hoc analysis and risk management dashboards, providing valuable insights and data-driven decision-making support.
- Led analytics projects across three different products, leveraging the team's capabilities to effectively track and complete the projects in an agile manner.
Machine Learning Engineer
Machinfy
- Headed the analytics team to secure third place in a business-driven competition, highlighting our exceptional analytical skills, strategic thinking, and ability to deliver impactful insights for business success.
- Implemented web scraping techniques to gather data from various sources and successfully consolidated it into a centralized database for easy access and analysis.
- Developed and implemented analytical and machine learning (ML) solutions to tackle complex business problems, employing three ML models to derive valuable insights and drive informed decision-making.
Economic Financial Analyst
Arabic Trader
- Analyzed financial data across the top four financial markets: forex, stocks, oil, crypto, and other core goods.
- Monitored site analytics and SEO plans using Semrush that successfully improved site traffic by 30%.
- Analyzed financial market trends and published +20 daily economic analysis articles accordingly.
Data Scientist
The Egyptian Center for Economic Studies (ECES)
- Utilized SciPy and TensorFlow frameworks to build natural language processing (NLP) and regression models, achieving an impressive accuracy rate of 95% for solving specific economic problems.
- Implemented web scraping techniques to gather data from various online sources, then stored and processed the data, applying wrangling techniques to ensure a dataset cleanliness level of 99%.
- Presented projects to stakeholders and key decision-makers in the economic landscape, showcasing the value and impact of the initiatives.
Experience
Optimizing KYC User Funnel
After building the funnel, I used the built funnel analysis to identify specific steps in the user journey where gaps or drop-offs occurred. Also, I collaborated with the UX team, sharing insights gained from the analysis to devise a new user-friendly approach for completing the KYC process.
I implemented the new KYC style, which yielded remarkable results, with an impressive 15.8% decrease in the exit rate, showcasing the effectiveness of the improved user experience and streamlined KYC process.
Developing an Alert Board
To accomplish this, I leveraged data from databases such as MySQL, PostgreSQL, and MongoDB to automate advanced SQL scripts that effectively flag relevant behaviors, enabling operations and support teams to take appropriate actions. Additionally, I utilized business intelligence (BI) tools like Metabase to integrate these alerts into automated notifications, ensuring timely communication in the event of any occurrence.
These measures proved instrumental in detecting fraudulent users and establishing a robust system to monitor the health of transactions, further strengthening our ability to proactively identify and prevent potential risks.
Customer Segmentation and Targeted Campaigns
Education
Bachelor's Degree in Economics
Cairo University - Cairo, Egypt
Certifications
MongoDB for SQL Experts
MongoDB University
Google Analytics Certification
SQL Expert
DataCamp
Data Analysis Professional Nanodegree Program
Udacity
Skills
Libraries/APIs
Pandas, NumPy, SciPy, TensorFlow
Tools
Slack, Qlik Sense, SQL Server BI
Languages
SQL, Python, Python 3
Paradigms
Business Intelligence (BI)
Platforms
CleverTap, Algolia, Firebase, Google Ads, Amazon
Storage
MySQL, MongoDB, Databases, PostgreSQL
Other
Metabase, Stock Trading, Adjust, Google Analytics 4, Economics, Growth Hacking, Funnel Analysis, Funnel Optimization, Analytics, UX Analysis, Data Analysis, Fintech, Marketing Analytics, Reporting, Database Analytics, Data, Data Manipulation, Data Wrangling, Information Systems, Econometrics, Statistics, Mathematics, Linear Regression, Logistic Regression, Predictive Modeling, Text Classification, Natural Language Processing (NLP), Machine Learning, DataFrames, Text Mining, Text Manipulation Algorithms, Sentiment Analysis, Fintech Consultant, Excel 365, Office 365
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring