John Talaat
Data Analyst at freelancer
Shubra Alkhaymah, Qalubia, EgyptWork Experience
Data AnalystFull Time
freelancer
Oct 2020 - Present -4 yrs, 8 months
Egypt , Cairo
- Job Details:• Use suitable tools (python scripts – SQL Queries – Power Query) to collect, clean, and wrangle data from various resources (Data preprocessing). • Designed and maintained databases for several Inventory control projects. • Create an automated application for Inventory by SQL (Reorder-Point -Inventory Aging - Inventory Classification - Pricing - inventory replenishment) • Design and develop automated reports for decisions maker using advanced tools (Power BI & Dax – Excel power-pivot – Tableau – Google Data Studio)
Inventory Control SupervisorFull Time
GB Auto
Jan 2018 - Oct 2020 -2 yrs, 9 months
Egypt , Giza
- Job Details:• Prepare sales plan and stock plan • Decreasing inventory level - Decreasing Advanced to Supplier - Increasing Payables • Increase Fill rate and turn to overtake necessary Action to decrease overstock • Inventory control KPIs automated • Demand planning system
Education
Bachelor's Degree in commerce
MnofiaJan 2011
Skills
- Data Analysis
- Microsoft Excel
- Inventory Control
- Microsoft Powerpoint
- Planning
- Inventory Management
- Power BI
- Budget Monitoring
- Python
- Microsoft SQL Server
View More
Languages
Arabic
FluentEnglish
Advanced
Training & Certifications
Business Language Program
Sprints·2022Advanced Data Analysis
Udacity·2022SQL Advanced
Hackerrrank·2022Data Analysis Professional
UDACITY·2021SQL Intermediate
Hackerrrank·2021