Amr Ali Abdel Aziz
Commercial Intelligence Manager
Maadi, Cairo, EgyptWork Experience
Sales Technology ManagerFull Time
May 2018 - Present -7 yrs, 2 months
Egypt , Giza
- Job Details:Committed Analysis & Development with 6+ years of experience serving as primary analytic support and developing processes to track and monitor sales. Skilled at creating efficient reporting & tools to support effective business decision making at all levels of the sales force. presentation skills; proven ability to deliver recommendations in a way that drives fosters company-wide adoption and continuous improvement ,and that by using Very Advanced tools:- - Expert Knowledge in Hand Held & Sales Automation System & their Process - Microsoft (Power BI Tools) - Handle reports with Use BI Tools in Share Point site - MS Access & SQL Database - Map info & good knowledge for ARC GIS / ARC GIS (Online) • Create/ implement Sales Systems, Processes and tools that aid sales teams in efficient and effective delivery of BU Sales strategies and targets • Assure we have the right Sales operations (including trade terms principles, policies and guidelines) • Manages and implementing system enhancements & processes, KPIs tracking, field force incentive scheme management, geo-mapping analytics and routing optimization • Manages planning for the different RTM enhancements and initiatives (eg. Retail modelling) while ensuring delivery in timely and high quality manner. • Ensures timely and accurate delivery of all report / ad-hoc information requests through distributors’ Sales Coordinators/Sales Analysts. • Manages evolving/enhancing performance measurement reports covering 3 categories: • Coverage Effectiveness/Route Productivity Reports: measuring the effectiveness of our outlet selection, routes efficiency and field force compliance to routes. • Trade Marketing & Market research Reports: measuring POS deployment, productivity, questioner / surveys. • Manages analyzing output from Productivity Reports, recommending solutions and following through corrective actions agreed with field sales management.
Sales Analysis & Route Planning System LeadFull Time
Nov 2016 - Jun 2018 -1 yr, 7 months
Egypt , Giza
- Job Details:-Lead a geographic & Sales analysis by using a new & very creative business intelligence tools (Microsoft Power BI) to make the follow up reports more flexibility & efficiency -Apply & create advanced & creative techniques & features on our sales automation system & (Hand Held ) to increase Sales opportunity & productivity & organize the process -Lead a team to create & support Analysis reports ,AD HOCK reports ,track the sales KPI performance & productivity , incentives followup , stock availability vs sales vs plan, & recommending solutions with field sales management -Lead a team of Route Planning & Geo Marketing Analysis & maintain and update customers database & sales routes & apply visits frequency according to the customers sales trend (retail module) -Lead Reports for Marketing & Trade Marketing - supporting them by Ac Nielsen retail audit reads & by our routs & sales analysis
Sales & Development AnalystFull Time
AJE Group For Beverage
Apr 2015 - Oct 2016 -1 yr, 6 months
Egypt , Cairo
- Job Details:Track key metrics such as sales pipeline and monthly results to help business leads interpret how sales team is tracking against goals • Formulate quarterly global sales action planning and reporting through Sales force; coordinate sales action planning for new product launches and report on results • Partner with Marketing and Product teams to build, update and maintain effective sales collateral, develop case studies, formalize proposals and other sales materials -Reviewed territory and market results, making recommendations for adjustments to resource alignment • Collected, analyzed, evaluated, and reported sales results and workflow to identify steps to increase sales productivity & results - Analyze The Stock Share VS Sales Volume To Know the Reasons of Gaps if It Out Of Stock Or Performance - Analyze The Routs Of Customers Sales Trend, Time Motion Study ,Visits and Effective Calls - Evaluate the Customers In Routs to handle the Frequency of Visits By Quarts • Communicated sales needs back to business leaders and product team, assisting in pricing analysis to ensure products relative to one another and in combination are priced correctly • Worked closely with internal teams to strategically drive company-wide goals and improve operational sales process • Generated ad hoc reporting for Sales, Marketing, Finance, Business Development and Product Strategy • Performed complex analysis such as trend analysis, what- if analysis, and forecasting • Provided recommendations and suggestions and provide thorough, succinct data to support suggestions
Sales Analyst - Sales Development Department Full Time
- Job Details:Providing sales and administrative support involving efficient handling of top and confidential agreements. •Supporting the sales team in attaining sales targets. •Communicating with regional sales team for status of order and position of sales. •Supporting sales planning and general reporting activities to inform sales management of performance •Preparing monthly, weekly or daily sales & KPI analysis. •Analyze The Stock Share VS Sales Volume To Know the Reasons of Gaps if It Out Of Stock Or Performance •Analyze The Routs OF Customers Sales Trend, Time Motion Study ,Visits and Effective Calls •evaluate the Customers In Routs to The handle the Frequency of Visits By Quarts •Collecting, analyzing, evaluating and accounting the information in order to increase productivity of sales & KPI •Monitoring the trends and evaluating the performance assessed against monthly sales & KPI goals. •Preparing proposals, agreements, sales & KPI reports, and presentations. •Assisting in the implementation of sales strategy as prepared by the Sales Development manager
Admin AssistantFull Time
Medical Insurance Company Medicare
Jan 2009 - Nov 2012 -3 yrs, 10 months
Egypt , Cairo
- Job Details:•I preparing Reports note and reviewing it to deliver this note to accounting department without faults For the completion of the audit. •when I start working in Medicare (The first position As Admin Assistant), there was a lot of manual work and the most difficult thing is to review lists continue more than 50000 filed like the client name, gender, type of health program in manual way i tried to turn this transaction to an easy, simple and faster way in reviewing by making it with electronic system using access data base. I always look forward to find smart and easy way to do my work in time with high accuracy.
Education
BA in Law
Cairo University (CU)Jan 2003 - Jan 2007 - 4 yr
Skills
- Sales Analyst
- Microsoft Excel
- Microsoft Powerpoint
- Microsoft Access
- Development Analysis
- Data Analysis
- Power Pivot Table
- Power map
- Power view
- Power query
View More
Languages
Arabic
FluentEnglish
Intermediate
Training & Certifications
Data Analysis Track - 2
UDACITY·2019Data Analysis Track
UDACITY·2019Data Analysis Track - 1
UDACITY·2019Excel 2010 – Track 3
New Horizons ·2013(BBSA) PLUS Customer Service Program
America-Mideast Educational and Training Services(AMIDEAST),(New Horizons) Sponsored by Future Generation Foundation·2008Basic Business Skills Acquisition (BBSA)
America-Mideast Educational and Training Services(AMIDEAST),(New Horizons) Sponsored by Future Generation Foundation·2008