Muhammad Farouk's Resume

Web-Based Application Developer

Personal Project | Jan 2023 - Present View More

Developed a fully functional e-commerce web application using Python Flask, deployed on Render.com (temporary link: mist-app.onrender.com).
Integrated Paymob API for secure online card payments, enabling seamless client transactions.
Implemented Google OAuth for user authentication and Google Mail integration for automated communication.
Provided a full online store experience, including:
- Clients can view all products, add items to their cart, place orders, and make payments online.
- Admins can manage the entire business through the app, including products, orders, client accounts, and financial reports.
Key features for clients:
- Browse products with filtering by categories, sizes, and preferences.
- View order history, apply promo codes, and track real-time updates on order status.
- Secure payment options, including card payments through Paymob and cash on delivery.
Key features for admins:
- Manage products (add, update, and remove) with multilingual data support (English and Arabic).
- Oversee client accounts, handle orders, and manage refunds or adjustments.
- Track bank transactions and generate detailed sales reports, including order histories and promo code analytics.
- Download and manage all database files, ensuring business continuity and scalability.
Database: Used PostgreSQL to manage a database of 1,357 products, orders, transactions, and clients with optimized query performance.
Performance Optimizations:
- Lazy loading for product images to enhance loading speed.
- Translation caching for multilingual UI rendering (English and Arabic with RTL and LTR support).
Security Enhancements:
- Implemented CSRF protection and strict input validation for secure form submissions.
- Encrypted sensitive data and ensured secure API endpoints.
Built a responsive and mobile-first front-end using HTML, CSS, and JavaScript, ensuring accessibility and user-friendliness.
Deployed a robust admin dashboard for managing all sales, transactions, and business operations efficiently.

Content Management and Automation Specialist

Nagwa, Cairo, Egypt | Oct 2023 - Present View More

Spearheaded the automation of tasks and data processing within the content teams, enhancing operational efficiency.
Developed and implemented strategies using Python, Excel, and Google Apps Script for streamlined data management.
Led initiatives for data-driven decision-making, contributing to the team's ability to meet strategic goals effectively.
Utilized Python, Excel, and Google Apps Script for data management and analysis, driving informed decision-making.
Orchestrated a large-scale migration process for over 600,000 JSON files containing educational content questions.
Designed and developed Python scripts to handle all stages of the migration process, including:
- Grouping JSON files into categories based on shared criteria for systematic processing.
- Replacing SVG elements in JSON files with equivalent LaTeX elements extracted from their associated XML files.
- Transforming LaTeX commands into MathLive math-field coding to align with the transition from LaTeX to MathLive.
- Creating a comprehensive YML replacement file to manage regex patterns for automated and accurate replacements.
- Developing smart, sensitive functions to handle special cases and ensure exceptional accuracy in edge scenarios.
- Ensuring all photo references were updated with correct dimensions, maintaining visual consistency and accuracy across content.
- Optimizing scripts for efficiency and scalability to process large datasets seamlessly.
Made extensive use of automation scripts to handle repetitive tasks, significantly saving time, reducing manpower requirements, and lowering operational costs. Examples include Python scripts for automating file management for educational sessions.
Shared selected Python automation scripts as public repositories on GitHub, available at github.com/mofasuhu?tab=repositories.
Ensured the accuracy and consistency of migrated data through rigorous testing, debugging, and validation techniques.
Contributed to enhancing the interactivity and usability of the educational content by implementing modern standards with MathLive.