Amged Hamed

Product Analyst

• Job Details:Conducting ad-hoc analytics to answer business questions and reveal data patterns using Python and SQL. Constructing real-time dashboards utilizing SQL and Apache Superset charts. Tracking customer behavior in the Paymob mobile app by creating events for key app triggers and monitoring their performance using Amplitude funnels and trend analyses. Creating tailored dashboards that cater to KPIs in Amplitude and CleverTap to analyze user behavior and identify drop-offs using conversion funnels and trends. Created and tracked the events for 4 major features in the Paymob app & developed documentation with a comprehensive naming convention for events creation to streamline the process.

Data AnalystPart Time

• Job Details:Developing and automating dynamic reports and dashboards using Power BI and Google Looker Studio, providing actionable insights on the company’s products. Gathering, cleaning, and storing data in spreadsheets (G-sheets & Excel) or Postgres databases for high-quality visualization, ensuring data integrity and accuracy. Leading a sub-product 'Alpha Insights' through planning the sprints, organizing backlogs, writing user stories and ensuring continuous workflow with the team.

Analytics Engineer

• Job Details:Developed a data model to process CSV inputs from the sustainability team, facilitating accurate reconstruction and analysis. Implemented a pipeline for a calculation algorithm to generate user scores based on backend/frontend inputs, mapping inputs to a database, and then converting outputs to JSON for backend integration. Automated scraping and reconstructing raw data using Pandas and Scrapy, ensuring efficient database storage and retrieval. Conducted detailed market research and analysis to inform strategic decision-making.