Address: *th Maleeka St, Maleeka Square, Faisal. Giza, Yasmeen Building Flat 17, Floor 6
Mobile: +2-010-********
E-Mail: *********@*****.***
Summary
Managing Retail & FMCG projects from business and IT software perspective. Microsoft Dynamics Retail Management System (RMS) and Microsoft Dynamics Great Plains (GP)
and Visual Dolphin ERP
* MCTS (70-432): SQL Server 2008, Implementation and Maintenance.
* MCITP (70-450): Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008.
* MCTS (70-433): SQL Server 2008, Database Development.
* MCITP (70-451): Designing Database Solutions and Data Access using Microsoft SQL Server 2008.
Language
Arabic: Mother Tongue.
English: Good read, written, and spoken (TOEFL: 457).
Education
-B.Sc. of Commerce Benha University, Faculty of Commerce,
-Accounting Department (2008).
Experience:
Database Administrator
Dina Farms Markets (July 2014 till now Dokki)
• Installing, configuring and maintaining SQL Server (Attendance – Non Attendance)
• Monitoring the server’s healthy, ability, and performance.
• Monitoring and auditing the server’s activity.
• Maintaining and Optimizing Server.
• Writing complexes queries.
• Create and maintain SQL Server various database objects, including SPs, UDFs and Triggers.
• Responsible for the performance, integrity and security of a database.
• Automating Administrator Tasks by creating jobs, alerts, operators and notifications.
• Troubleshooting application and database problems.
• Catching and troubleshooting related OS problems.
• Implementing, and maintaining High Availability.( Cluster- Log-Shipping – Replication – Mirroring)
• Responsible for the 24/7 support of SQL database services to ensure the highest standards of availability, flexibility, integrity, security and performance required by the business systems.
Applications that I’ve managed:
1-AMIS System
2-Microsoft Dynamics Retail Management System ( RMS )
3-Microsoft Dynamics Great Plains ( GP )
4-Visual Dolphin ERP
Report Designer
Dina Farms Markets
Design custom reports like:-
• Sending Hourly Sales report automatically via email
• Hourly sales reports.
• Returns for purchase orders reports by items.
• Item Price History.
• Customer Classifications Report
• Visa Transactions report.
• Awfar Report
• Kit Information Report
• Supplier Cost.
• Multi Delivery item in Same Invoice.
• Duplicate ShipVia.
• Inventory Evaluation.
• Home Delivery performance.
• Monthly waste reports
• Monthly promotion sales
• Supplier purchases by items
• Last updated of sales.
• Duplicate Items in same purchase order
•Supplier purchases by item
•Open purchase orders by item
•Price Item Monitor
•Wastage by item
Managing technical team in RMS project
Design some reports with Power BI for Qalaa Holdings
Spiceworks implementation
Database Administrator & Application Developer.
PARC Company (April 2013 – July 2014 (1 year 4 months)
• Installing, configuring and maintaining SQL Server
• Monitoring the server’s healthy, ability, and performance.
• Monitoring and auditing the server’s activity.
• Maintaining and Optimizing Server.
• Writing complexes queries.
• Create and maintain SQL Server various database objects, including SPs, UDFs and Triggers.
• Responsible for the performance, integrity and security of a database.
• Automating Administrator Tasks by creating jobs, alerts, operators and notifications.
• Troubleshooting application and database problems.
• Implementing, and maintaining High Availability.( Log-Shipping – Replication – Mirroring)
Application Development
• Upgrading a VB Client application to Dot.net
• Automating generating reports using external sources like Excel
• Data analysis with Nipo Diana and other Nipo Software Products.
• Programming CATI surveys in Nipo Script Language.
Training and Certificates
CCNA Routing & Switching ( in progress)
MCSE 2012 – MCITP Enterprise 2008
PMP
Emotional Intelligence
Leadership Skills
ITIL V3 Foundation.
Oracle Database 11g Administration.
Ministry of communications and information technology scholarship ( MCIT 9 Months Scholarship ) (Database Development and Administration track).
Advanced Programming Diploma
Course in studying Internal and External Markets.
Course in studying Accounting with Excel.
Personal Skills
-Leader / Responsible / Team Member character.
-Ability to work in a group or individual.
-Ability to work under stress and abroad.
-Self-motivated, ambitious, innovative.
-Very good research abilities.
-Thinking and development talent.
-Interactive and fast enough to learn new technologies and sciences, researching information.
Basic Knowledge:
-Networking Basics.
-Software and Hardware Maintenance.
Managerial and Soft Skills Courses
-Advanced Interpersonal Communication.
-Effective Presentations.
-Time Management.
-Stress Management.
-Business English w/Business Communication.
-Advanced English for IT.
-Technical and Business writing.
Availability
I will be available upon your request within a month.
Personal information
Birth Date
15-July-1987.
Gender
Male.
Religion
Muslim.
Marital State
Single.
Nationality
Egyptian.
Military Service
Completed.