Emad El Din Mohamed Zedaan

Sales analyst

Helwan, Cairo, Egypt

Jul 2011 - May 2013 -1 yr, 10 months

Egypt , Cairo

Job Details:- Create, Design and develop business report in pivot tables using Excel and VBA code. - Monitor all business transaction (Sales, return, representative counter, Area sales values) and highlight business weakness point. - Create daily, weekly, campaign reports. - Analyze local and regional incentive program. - Prepares Business Cases for the motivational competitions and programs for the Sales department to maximize profit margin. - Recommends changes to current sales techniques. - Providing the analytical support for the company in order to emphasize the strength & weakness points in the organization. - Sustain the company growth in wider areas. - Receives requests for sales analyses, prepare the sales analyses as requested and gives them to those that solicited them. - Assist in creating and maintaining the company plan and Field Forecast on annual basis to support the field in delivering their objectives. - Participates in the process of creating the rules of the motivational competitions and programs for the Sales Department. - Creates all analysis for any projects of the sales department. - Monitors the competitions and promotions for representatives, Sales Leaders, Area Sales Managers.

Ministry of Trade and Industry

Jun 2005 - Jun 2011 -6 yrs

Egypt , Cairo

Job Details:- Create, Design and develop Quarterly review form in Excel format using VBA code. - Create periodical reports and company profiles Excel & PDF format. - Establish and enhance periodical data updates process and follow up. - Design an archive system and data warehouse. - Prepare data set and validate it to transform it to data using several techniques and good knowledge for date mining. - Analyzing data and make different reports and graphs to present it to decision maker by using Microsoft office programs and study Knowledge. - Generate simple and complete graphs and charts to illustrate the overall figure. - Prepare Different reports & Graphs using Microsoft office programs. - Preparing professional presentation. - Browse SQL Server database tables and prepare query using Excel & Access. - Design useful and efficiency report using SQL server report Services tools. - Managing and planning work flow, timing and schedules. - Providing technical Assistant to Implement data Statistic and companies profile and data Analysis for exports and imports products during quarters and publish it on our web site. - Implementing technical support and Solutions to companies. - Supervising Auditing team. - Developing technical Solution and resolving companies’ problems. - Participant in QIZ Unit web site. - Administrating & Programming Database.

Global Delegation Authority Training
SAI Global·2013
Introduction to the foreign corrupt practices act
Avon Global Compliance Training Program·2012
Personal Effectiveness
Quest·2012
Business Writing
Avon Egypt·2012
Data Privacy
Avon Global Compliance Training Program·2012
Understanding Record Retention
Avon Global Compliance Training Program·2012
Information Security
Avon Global Compliance Training Program·2011
Microsoft Office
Synergy professional service·2011
Database
IT Egypt Corp·2010
English business and commercial corresponds
Foreign Trade Training Center (FTTC).·2010
Leadership training for Managers (LTM)
Dale Carnegie Egypt ·2009
Project Management Professional (PMP)
Regional IT Institute (RITI).·2008
Time & Stress Management
AB Associates management consultants·2008
Negotiation Skills
AB Associates management consultants·2008
Emotional intelligence & Interpersonal skills
AB Associates management consultants·2008
Presentation skills
SYMBIOS Consulting·2006
Database
Synergy professional service.·2006