Fatimah Farouk, Developer in Cairo, Cairo Governorate, Egypt
Fatimah is available for hire
Hire Fatimah

Fatimah Farouk

Verified Expert  in Engineering

Data Analytics Engineer and Developer

Cairo, Cairo Governorate, Egypt

Toptal member since February 6, 2024

Bio

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

Awaed
SQL, Metabase, Qlik Sense, MySQL, MongoDB, Stock Trading, Python, CleverTap...
Machinfy
Machine Learning, SQL, Python, DataFrames, Amazon, Text Mining...
Arabic Trader
Economics, Fintech, SQL, Excel 365, Office 365

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

Full-time

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

2022 - PRESENT
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.
Technologies: SQL, Metabase, Qlik Sense, MySQL, MongoDB, Stock Trading, Python, CleverTap, Adjust, Algolia, Firebase, Google Analytics 4, Google Ads

Machine Learning Engineer

2022 - 2023
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.
Technologies: Machine Learning, SQL, Python, DataFrames, Amazon, Text Mining, Text Manipulation Algorithms, Sentiment Analysis, Data Analysis

Economic Financial Analyst

2021 - 2022
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.
Technologies: Economics, Fintech, SQL, Excel 365, Office 365

Data Scientist

2021 - 2022
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.
Technologies: Python 3, Linear Regression, Logistic Regression, Predictive Modeling, SciPy, TensorFlow, Pandas, Text Classification, Natural Language Processing (NLP)

Experience

Optimizing KYC User Funnel

I developed a comprehensive funnel analysis encompassing all user steps necessary to complete the Know Your Customer (KYC) process and proceed with their first investment in our fintech platform.

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

As a data analytics engineer overseeing growth analytics for three distinct products in a fintech company, my primary task was identifying potential financial risks through robust internal auditing activities to mitigate suspicious and fraudulent behaviors.

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

I utilized users' data to build a segmentation map that identifies distinct customer groups based on demographics, investment behavior, risk tolerance, and financial goals. My insights helped UX, marketing, and product teams to make tailored decisions like targeted campaigns that improved their ROI by more than 30%.

Education

2015 - 2019

Bachelor's Degree in Economics

Cairo University - Cairo, Egypt

Certifications

NOVEMBER 2023 - PRESENT

MongoDB for SQL Experts

MongoDB University

OCTOBER 2023 - PRESENT

Google Analytics Certification

Google

OCTOBER 2022 - PRESENT

SQL Expert

DataCamp

JANUARY 2021 - PRESENT

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

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring