Basic Info

Ahmed Mohamed

5 years

Alexandria, Egypt

Bachelor's Degree

Experienced

Work Experience

Database Instructor at New Horizons Computer Learning Centers

Experience Details

Database Instructor

Training/Instructor, IT/Software Development, Education/Teaching

Experienced (Non-Manager)

* Delivering more than 2000 Hours for the following Courses :-

- Querying Microsoft SQL Server 2008R2, 2012, 2014, 2016 .
- Developing Microsoft SQL Server 2008R2, 2012, 2014, 2016 .
- Administering Microsoft SQL Server 2008R2, 2012, 2014, 2016 .
- Developing Microsoft SQL Server SSIS, SSRS, SSAS
Solutions 2008R2, 2012, 2014, 2016 .
- Microsoft SQL Server Database Performance Tuning .
- Database Systems Design & Analysis .
- Web Development (HTML5,CSS3,JavaScript) Fundamentals.
- Programming With C# Fundamentals .
- Cloud Computing Fundamentals.
- Network Fundamentals.
- Windows Server Fundamentals.
- Office 365 Administration.

* Delivering Pool Groups Courses for Non-Egyptian Clients ( Sudanese, Libyan ) .

* Delivering Onside Courses & Consultant for Companies Examples :-
Abu Qir Petroleum Alexandria, Alexandria Container & Cargo Handling CO .


Company Details

New Horizons Computer Learning Centers (multinational)

Alexandria, Egypt

101-500 employees

Education, Information Technology Services

https://www.microsoft.com/ar-eg/

Sep 2013 to present (4 years 1 month)
Data Engineer & Database Administrator at Andalusia Group for Medical Services

Experience Details

Data Engineer & Database Administrator

IT/Software Development, Education/Teaching

Experienced (Non-Manager)

* Transfer Multidimensional Analysis Cubes to Tabular Analysis Using VertiPaq Engine (In-Memory) & DAX Language for Maximum Performance For MS Power BI & Excel Power View & Excel Pivot Table .

* Developing Revenue Growth Drivers project ( Price, Volume, Utilization, NewServices, UnusedServices, ReactivatedServices ) from design DWH Star schema & build OLTP T-SQL Queries & schedule ETL Solution & Process to Tabular Analysis Services.

* Developing Patients Clinics Reservation Project (Patients Reservations Throw Andalusia Web & Mobile App And Call Center Agents Confirmation ) From Design DWH Snowflake Schema to Build T-SQL & MySQL Queries to Schedule ETL Solution & Process Fact Partitions Every Minute for Real-Time Analysis .

* Administering 11 Servers (6 Servers At Egypt Data center, 5 Servers At KSA Data center) With More Than 15 DBMS Instances (SQL SERVER, MySQL, Oracle) .

* Working with data visualization for reporting & Self reporting Like ( Power BI , SSRS , Excel Pivot Table , Excel Pivot Chart , Excel Power View ) .

* Developing ETL solutions for extracting data from Andalusia OLTP databases business units (About 7 OLTP Databases) to Staging for transformations Then loading to our final Data Warehouse (DWH) .

* Install, configure and upgrade database engines , Automated Administrative tasks using OS batches & Engine Jobs and Alerts , Monitoring and optimizing the performance of the database .

* Designing and plan BI solutions based on customer requirement analysis to develop Cubes with MDX , DAX Calculations & Company KPI’s .

* Creating Master Data Services (MDS) Models to gather missing data from business customers and their planning for next months .

* Managing Users Permissions On DWH Database Objects & SSAS Cubes & SSRS Reports & Power BI Dashboards & Master Data Services (MDS) Models & Entities .

* Training My Team on New Technologies Ex ( SSAS Tabular ) , Advanced Topics (Advanced SQL) . .


Company Details

Andalusia Group for Medical Services (multinational)

Alexandria, Egypt

More than 1000 employees

Healthcare and Medical Services, Information Technology Services

http://www.andalusiagroup.net

Mar 2016 to present (1 year 7 months)
Technical Instructor at Microsoft Partners In Learning Egypt

Experience Details

Technical Instructor

Training/Instructor, IT/Software Development, Education/Teaching

Experienced (Non-Manager)

* Delivering more than 800 Hours of total sessions for about 2000 (Students , Professors ,Teaching Assistants) at the following Universities :-
- MUST-Misr University for Science & Technology
- Sadat Academy for Management Sciences
- Mansoura College Academy
- Helwan University
- Menoufia University
- Tanta University
- Benha University

* Delivering more than 900 Hours of total sessions for more than 1000 Teachers at Experimental Language Schools In (Cairo, Giza, Alexandria, Damanhour, Port-said, Ismailia, Matrouh) .

* Camping for a week at Microsoft Education Camp February 2016 - Mubarak Educational City - 6 October City with the best Students over Egypt .

* Camping for a week at Microsoft Education Camp March 2017 - Mubarak Educational City with the best Mathematics Teachers over Egypt


Company Details

Microsoft Partners In Learning Egypt (multinational)

Egypt

More than 1000 employees

Computer Software

https://www.microsoft.com/ar-eg/

Jan 2014 to Mar 2017 (3 years 2 months)

Achievements


* 4+ years of experience in Da

Education

BS in Accounting

Education Details

BS

Accounting, Information Technology

Alexandria University, Egypt

B / Very Good / 75 - 85%

N/A

N/A

Alexandria University
2009 - 2013
High School - Thanaweya Amma

High School Details

Thanaweya Amma

Al ramel

Egypt

2009

A / Excellent / 85 -100%

N/A

Al ramel
2009

Certifications

Certificate details

Microsoft Data Management and Analytics (*Charter) 2016

Nov 2016

N/A

https://mcp.microsoft.com/Anonymous//Transcript/Validate

Transcript ID (1144675) Access Code (AhmedAli)

Microsoft

REFERENCES

https://mcp.microsoft.com/Anonymous//Transcript/Validate

Transcript ID (1144675)

Access Code (AhmedAli)

Certificate details

Microsoft Certified Solutions Expert (MCSE) SQL Server

Jul 2014

N/A

https://mcp.microsoft.com/Anonymous//Transcript/Validate

Transcript ID (1144675) Access Code (AhmedAli)

Microsoft

N/A

Certificate details

Microsoft Certified Solutions Associate (MCSA) SQL Server

Apr 2014

N/A

https://mcp.microsoft.com/Anonymous//Transcript/Validate

Transcript ID (1144675) Access Code (AhmedAli)

Microsoft

N/A

Training and Courses

Training/Course Details

SQL SERVER

Jun 2014

newhorizons

N/A

Training/Course Details

Windows Server

Apr 2014

newhorizons

N/A

Training/Course Details

Soft Skills

Jan 2014

newhorizons

N/A

Training/Course Details

Office 365

May 2014

newhorizons

N/A

This profile is fresh!
Last update 11 days ago.

Jobseeker photo

Profile Skills and Keywords

AccountingAndalusia Group For Medical ServicesArabicComputer SoftwareData Engineer & Database AdministratorDatabaseDatabase InstructorEducationEnglishExecutorFootballHandles StressHard WorkerHealthcare And Medical ServicesITInformation TechnologyInformation Technology ServicesInstructorMicrosoft Certified Solutions Associate (MCSA) SQL ServerMicrosoft Certified Solutions Expert (MCSE) SQL ServerMicrosoft Data Management And Analytics (*Charter) 2016Microsoft Partners In Learning EgyptMicrosoft SQL ServerMicrosoft Visual StudioNew Horizons Computer Learning CentersOFFICE 365Problem SolverSQLSQL SERVERSoft SkillsSoftware DevelopmentTeam PlayerTechnical InstructorTrainingWeb DevelopingWindows Server

Self-assesed Skills

Languages

Arabic

Arabic

: Fluent

: Fluent

: Fluent

: Fluent

English

English

: Advanced

: Advanced

: Fluent

: Advanced

Tools and Technologies

Microsoft SQL Server

Microsoft SQL Server

: Expert

: Extreme - I love it!

:

5-7 years

SQL

SQL

: Expert

: Extreme - I love it!

:

5-7 years

OFFICE 365

OFFICE 365

: Advanced

: High

:

3-5 years

Windows Server

Windows Server

: Advanced

: High

:

3-5 years

Microsoft Visual Studio

Microsoft Visual Studio

: Advanced

: Extreme - I love it!

:

3-5 years

Fields of Expertise

Instructor

Instructor

: Expert

: Extreme - I love it!

:

5-7 years

Training

Training

: Expert

: Extreme - I love it!

:

3-5 years

IT

IT

: Expert

: Extreme - I love it!

:

3-5 years

Database

Database

: Expert

: Extreme - I love it!

:

5-7 years

Web Developing

Web Developing

: Beginner

: Medium

:

Less than 1 year

Key Skills

Executor, Hard worker, Problem Solver, Handles Stress, Team Player

Online Presence

https://www.linkedin.com/in/ahmedalimohamedresume/https://www.facebook.com/Eng.Ahmed.Ali.Mohammed

Like Ahmed`s profile? Share it!

Get Your own Wuzzuf Profile Now !

Employer? If you're representing an organization or an enterprise, Signup here for FREE to see Ahmed's full profile and find more great talent and professionals to join your team.