Business Insights Sr. Lead / _VOIS - Smart Village, Giza.

May 2022 - Current

• Developed and maintaining a new desktop application for automating daily routine tasks, resulting in a 25% reduction in manual effort. Developed expertise in Python, PYQT6, Selenium, and Win32com API. Engaged with stakeholders to understand their needs and requirements, and designed and implemented a user-friendly and intuitive application.
• Act as the primary maintainer of multiple Power BI dashboards for Pre-sales, Demand and Utilization, and Work in Progress data. Ensure the accuracy and timeliness of the dashboards, and develop and implement best practices for data governance, quality, and security. Collaborat with cross-functional teams to integrate data and analytics into the business processes and systems.
• Support in the development and maintenance of an Oracle SQL Data Warehouse.
• Support in Data Migration to AWS Redshift and GCP Big Query.

Data Scientist / Atos - Nasr City, Cairo.

May 2021 - May 2022

• Design and implement predictive models and machine learning algorithms using Python, Scikit-learn, and TensorFlow to solve business problems and generate insights.
• Deploy models to production using Docker containers and Kubernetes for seamless integration with the production environment.
• Served as the technical lead for pre-sales activities related to Enterprise BI and data platforms projects. Demonstrated technical expertise and deep understanding of the capabilities and value proposition of the solutions. Contributed to the successful acquisition of new clients and the expansion of existing relationships.
• Implemented MongoDB as Infrastructure-as-a-Service (IaaS) on Microsoft Azure, enabling the deployment of scalable and resilient databases for multiple environments. Improved the performance and reliability of the data storage and management systems, facilitating the development and deployment of applications and services. Developed expertise in Azure, MongoDB, and related technologies and tools.
• Built an ECK cluster (Elastic Cloud on Kubernetes) on AKS, enabling monitoring of application resources in Azure.
• Updated a Python package to add authentication mechanisms with Azure, enabling secure access to on-premises and cloud resources. Improved the security of the system and facilitated seamless integration with Azure.
• Acted as the primary provider of reports and analysis services for the Microsoft Practice Team. Generated insightful and actionable analysis, contributing to the success of the team and the satisfaction of clients. Developed expertise in Microsoft tools and technologies, including Power BI, Excel, and SQL Server.

Senior Bi Developer / Coca-Cola - Nasr City, Cairo.

Dec 2020 - May 2021

• Created and maintained a set of dashboards for Sales, Finance, and HR using Power BI, improving their accuracy, timeliness, and usability.
• Managed the automation of the process of collecting budget, RE, and customer targets from the commercial team using Python and PostgreSQL. Improved the accuracy, timeliness, and reliability of the data, and facilitated the analysis and reporting of the target by Sales Office, Route, SKU, Day, etc. Developed expertise in Python, SQL, and data management.
• Conducted data analysis and visualization to support decision-making and strategic planning. Developed and maintained documentation and standards for the process and the data. Improved the efficiency and productivity of the team, and contributed to the success of the organization.
• Prepared paginated reports for sales using Microsoft Power Automate, enabling the delivery of timely and accurate information to the sales team.

Data analyst / Al Safy Group - Fifth settlement, New Cairo.

May 2018 - Dec 2020

• Created a sales dashboard using Excel Power Query, DAX functions, and VBA to analyze and compare the performance of the company branches. Facilitated the analysis and reporting of key performance indicators and trends.
• Created an Excel sheet for commission calculation and automated the process of gathering target, sales, and KPIs sheets using Excel Power Query and advanced formulas.
• Developed a set of SQL queries to extract sales transactions from the Microsoft Dynamics AX database, enabling the analysis and reporting of key performance indicators and trends.
• Developed an automated cheque-issuing process through an Excel sheet, handling cheque printing for several banks.
• Improved the efficiency and accuracy of the process, and facilitated the reconciliation and tracking of the payments.
• Designed new forms for all the documents in my department, including check cover, credit notes, and compensations. Improved the quality and consistency of the forms, and facilitated the processing and tracking of the documents.

Accounts Payable Supervisor / Master`s Food - Zmalek, Giza.

May 2014 - May 2018

Accountant / Al Fares Egyptian Co. (Cottonil) - Nozha, Cairo.

Feb 2013 - May 2014

Collector / The International Hospital for Urology and Nephrology - Mohandsin, Giza.

Jan 2009 - Feb 2013