Basic Info

Mohamed ahmed

2 years

Cairo, Egypt

Bachelor's Degree

Entry level

Work Experience

Data Analyst - SME & SOHO segment at Orange Telecommunications

Experience Details

Data Analyst - SME & SOHO segment

Sales/Retail, Operations/Management, Marketing/PR/Advertising

Entry Level

1-Develop new reporting tools for the Retail, TAM & Franchise Agents for to ensure accuracy of the submitted figures and to minimize time consumption.
2-Maintain the relationships between the databases, solve any identified issues. Maintain claims database using SQL program working with large databases.
3-Maintain & secure the database by reducing the risk of missing suspicious activities.
3-Provide the necessary information about how to deal with the Access tool to the SIRA team to submit their reports successfully without any discrepancies.
4-Try to implement continuous auditing & backups to protect the database environment to ensure complete visibility across the databases.
5-Designing forms & queries for the SIRA team on the MS Access tool to facilitate the data entry.
6-Validate and handle Gross Adds KPI in the quarterly sales incentives plan for the SOHO segment.
7-Submit the franchise monthly achievements and calculate the relevant commission on all levels (Authorized agents, Shop Managers, representatives).
8-Responsible for providing a periodic global KPIs analysis to the segment management.
9-Collect, analyze, validate & issue the Acquisition KPI for sales incentive plan (SIP) for the SOHO segment sales employees.
10-Providing the retail and franchise team with the weekly achievements that they attained to keep them on track with their figures.
11-Daily tasks involved extensive use of MS Excel and MS Access.
12-Maintain database quality through periodic revisiting of all discrepancies identified by extracted reports to ensure accurate payout to sales staff as well as the franchises commissions.
13-Act as the interface with the data base teams to provide the required reports for the SOHO segment in addition to the quarterly SIP inputs.
14-Presenting weekly and monthly sales reports, with a focus on KPI targeting and trending analysis, to the board of manager and head of the sales development.


Company Details

Orange Telecommunications (multinational)

Cairo, Egypt

More than 1000 employees

Telecommunications, Internet/E-commerce

Www.Orange.com

Jan 2015 to present (2 years)
Trainee at the National Bank Of Abu Dhabi (intern) at National Bank Of Abu Dhabi

Experience Details

Trainee at the National Bank Of Abu Dhabi (intern)

Banking

Entry Level

I worked as a customer service, and i was reviewing the daily sheet of the output and input for customers.


Company Details

National Bank Of Abu Dhabi (multinational)

Cairo, Egypt

501-1000 employees

Banking, Financial Services, Insurance

www.nbad.com

Jul 2011 to Aug 2011 (1 month)

Achievements


I have achievements in work as i updated the reporting system, in a consisely instead of collecting data on excel sheets that the representitives sending their weekly achievements with a large amonut of data and taking much of of time to validate, So i designed a Database management system on microsoft access through a shared folder that save time waste and easily to collect and every rep. have an access to enter his data in a accurate way. I have achieved in sport specificly in Judo, i have won the bronze medal on the republic championship in 2009 and also the silver in 2010.

Education

BA in Commerce

Education Details

BA

Commerce

Ain Shams University, Egypt

B / Very Good / 75 - 85%

Accounting,management, finance and economics.

N/A

Ain Shams University
2009 - 2013
High School - Thanaweya Amma

High School Details

Thanaweya Amma

El Rowad Language School

Egypt

2008

B / Very Good / 75 - 85%

N/A

El Rowad Language School
2008

Training and Courses

Training/Course Details

English

Jul 2013

British council

I took english language course and conversation course at the british council. And also i took spanish language course at cervantes.

Icdl at Yat
Feb 2014

Training/Course Details

Icdl

Feb 2014

Yat

N/A

Training/Course Details

Banking

Sep 2012

National bank of abu dhabi

I was a trainee at the national bank of abu dhabi, i was revising the daily balance sheet about customers.

Training/Course Details

Master excel

Nov 2014

Yat learning center

Master excel 2010 core , advanced

Training/Course Details

Master Access

Jan 2016

Yat Learning Center

N/A

This profile is not updated!
Last update more than 1 months ago.

Jobseeker photo

Profile Skills and Keywords

200 Days Around The WorldAnalyticalBankingBusiness DevelopmentCommerceData Analyst - SME & SOHO SegmentE-commerceEnglishFinancial ServicesFootballHard WorkerHow To Be A LeaderIcdlInsuranceInternetJudoManagementMarketingMaster AccessMaster ExcelNational Bank Of Abu DhabiOrange TelecommunicationsPlannerRetailSalesSocialSpanishSupportiveSwimmingTelecommunicationsThe SecretTrainee At The National Bank Of Abu Dhabi

Self-assesed Skills

Languages

English

English

: Fluent

: Fluent

: Advanced

: Advanced

Spanish

Spanish

: Beginner

: Beginner

: Beginner

: Beginner

Key Skills

Analytical, Planner, Hard worker, Social, Supportive

mohamed is looking for a new career opportunity. Please help by sharing…

Get Your own Wuzzuf Profile Now !

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