khaled mahmoud Hanfey

Sales Technology Section HeadFull Time

• Job Details:Train the sales force team on using technology tools & systems. Provide second line support for different SFA users (Finance, Sales, Operations, Warehouse… etc.). Troubleshoot system, diagnose and solve HH software problems. Configure and maintain the handheld devices and related equipment. Provide support and training for sales supervisors, territory development managers and sales managers. Communicate with third party to develop printed layout and SFA performance according to business needs. Manage SFA server and DB. Create and manage SFA users and user privileges. Provide sales and finance team with SFA related reports. Create and manage (items and customers) discount plan throw SFA system. Create special and additional sales promotions. Manage and handle master files and integration between ERP (ISCALA) and SFA (Sales Buzz) Conduct and issue the different HH Key Performance Indicators (KPI’s) reports. Issue monthly HH performance reports and system scorecards. Responsible for implementation HH solution for Meat sector in Corona Company. Generate and create reports using (SQL, O-Data feed, Power Bi) Test changes on UAT environment and make sure that meet our business needs before apply it on production environment. Communicate with third party to provide them with our business needs and change requests. Diagnose and troubleshoot any issue related to data integration (ERP ISCALA - Sales Buzz) and synchronization (HH devices – Sales Buzz). Responsible for all agreements and deals with sales force vendors (SLA, maintenance, mobility) Train users for how to use and design financial reports using built in Power BI tool (financial reports, Sales reports). Clean and update master data for materials and customers. Follow-up, review business technology team tasks and performance. Assist SalesBuzz and HHD team in their projects and technical advice. Support all Sales buzz daily in 2nd level (24h/7days) to keep business continuity. Attend daily, weekly, monthly with India GTM team to discuss business issues and tracker

Section Head Sales Automation & Business intelligence managerFull Time

• Job Details:Provide operation support for IT applications Report respond and resolve issues customer requests and problems. Ensuring the integration of all systems components e.g. procedures databases, policies, software, and hardware. Assuring software and systems quality and functionality. Writing and maintaining documentation. Monitoring systems resources including performance capacity, availability, and recoverability. Ensuring systems availability, functionality integrity, and efficiency Maintaining systems configuration. Diagnosing and resolving problems in response to customer reported incidents whenever possible. Maintaining problem tracking and resolution databases. Applying customer support policies procedures, and standards. Identify and resolve issues and problems whenever possible. Carry on all routine tasks that assure proper and healthy applications utilization Assure users have the right access to the authorized applications/modules in regular basis. Assure the right versions.

Business Intelligence DeveloperFull Time

• Job Details:Innovative Information Technology, data analysis, and understanding of Object Oriented Programming and application development utilizing database structures and programming languages such as MS SQL/Access, C#, VB.net and ASP.net. Seeking opportunities to incorporate diverse technical knowledge and broad formal education to benefit an organization in a leadership capacity. PepsiCo  May 2014 to present Reporting and Interface Analyst  Oct 2013- Apr 2014 Hand Held Admin (CFI)  DC Admin (lactel) Jul 2010- Sep 2013 Reporting and Interface Analyst – PepsiCo (CFI,PCE) May2014-Prsent  Developed advanced Microsoft SQL Server queries, stored procedures, and functions on Sales Buzz, CFI and PCE databases.  Create and implement table and query optimization solutions to improve overall SQL server performance and reduce execution times.  Administrated Microsoft SQL Server Reporting Services including design, composition and actualization of detailed Sales, financial, WH and Capability reports for personnel and senior management staff utilizing Microsoft Analysis Services on Sales Buzz, CFI and PCE databases.  Responsible for the design, development and on-going support of reporting & analytical solutions for In House DCs and Distributors.  Use range of technologies to make data easy accessible to business users through building Self-BI reporting environment and Dashboards.  Developed and Published web based application “HR & Payroll System” for distributors.  Enabling & ensuring reliability of technologies that saves time & money like Developed and published Crystal Report reports on Sales Buzz system.  Design and developing all business required reports for Distributors, CFI and PCE.  SAP BI Training and Support for business colleagues (CFI, PCE).  Responsible for SAP maintenance (Hierarchy, Items, Target, AOP, Forecast).  Responsible for annual Cooler System count.  Developed reports for Automated Stock collection for WS customers & pricing impact project.  Creating and implementing rerouting plan using Roadnet (UPS Territory Planner).  Binding any overlaps between salesmen routes using Roadnet.