Zomato Data Insights System

I need a data management system for Zomato's food delivery analytics using Python, SQL, and Streamlit. The system should help us understand and boost our operational efficiency.

Key Requirements:
- Design synthetic datasets for various operational metrics (e.g., order volume, cancellations, payment methods, delivery delays).
- Build a normalized relational database to manage and query these datasets.
- Develop an interactive Streamlit app for:
- Seamless data entry.
- Dynamic schema management.
- Supporting all CRUD operations.

The system should provide insights on:
- Order trends (e.g., peak order times, popular dishes, order frequency by location).
- Customer preferences.
- Delivery performance.
- Restaurant analytics.

The insights will be generated through SQL queries and Python-driven visualizations, focusing on:
- Peak times.
- Cancellations.
- Delivery delays.
- Order value.

Ideal Skills & Experience:
- Proficiency in Python, SQL, and Streamlit.
- Strong background in object-oriented programming.
- Experience in database design and management.
- Data visualization skills.
- Familiarity with food delivery logistics is a plus.

Looking for a freelancer who can deliver a robust and scalable solution.