ahmed mirza, Senior Business Analyst

ahmed mirza

Senior Business Analyst

DAL GROUP - Sayga Investment Company Ltd

Location
Egypt - Cairo
Education
Master's degree, Information Technology /Business Intellegence
Experience
14 years, 7 Months

Share My Profile

Block User


Work Experience

Total years of experience :14 years, 7 Months

Senior Business Analyst at DAL GROUP - Sayga Investment Company Ltd
  • Sudan - Khartoum
  • My current job since January 2017

Responsible for designing, planning, Implementing strategic sales and distribution programs across multiple businesses such as Coca-Cola, DAL Dairy Factory and SAYGA Flour Mills and providing ongoing support for a variety of strategic programs and projects related to the sales organization, the training of all sales organization, determine the process Gaps, and strategic data analysis. Manage sales system implementation projects through all phases of project life cycle
• Cross-functional Communications: Proactively worked cross-functionally and cross-departmentally to catalog, prioritize, and activate complex and strategic projects, serving as the point of contact for 6 departmental information systems directors.
• Creative Problem Solving / Strategic Thinking: Led the development of trip planning and truck optimization system and oversaw the design, planning, and resource allocation necessary to solve complex problems impacting six business units inside DAL FOOD.
• Business Process Automation and Improvement: Designed and implemented multiple operational upgrades with a focus on IT systems and on workflow design. Continuous improvement of sales processes (Retail execution, merchandising, promotion planning, sales accounting), while advising the business on the latest trend and IT .E.g. reduced customer response times to 24 hours from 48 hours+ by improving the Firm’s service design and communication systems
• Working with and Analyzing Data: Manage, cleanse sales data and provide a require information to each one in the sales Org by Implementing Sales Data Mart to meet all Sales Requirements and to be in touch with business requirements. Responsible for overall development and delivery of analysis, reports, KPIs to different business units (Marketing, Finance, Sales, and Strategy).

Supply Chain Data Lead at DAL GROUP - Sayga Investment Company Ltd
  • Sudan - Khartoum
  • January 2016 to December 2016

Supply Chain Data Lead (Data Quality)
Led Data Management work stream in supply chain area for three division (Coca-Cola, DAL DAIRY FACTORY and SAYGA) to help define Master Data Management Strategy and Roadmap in order to have access to accurate, consistent, complete and high quality data in a timely manner. Master Data governance processes that used to ensure that data is accessed by authorized users in a timely manner thus enabling the business to make informed decisions based on accurate data.
• Interpreting and Presenting Results: Regularly drafted results of findings and progress reports for the BU’s, working with more than 10 Department to collect key metrics, summarize findings and prepare documents and memos prior to their transmission to counterparts across BU’s
• Leadership and Teambuilding: Successfully managed a staff of 6. Led the preparation of regular performance reviews, participated in the hiring of additional staff, and proactively cultivated a culture of teamwork and individual accountability.

GEO-Marketing System Admin at DAL GROUP
  • Sudan - Khartoum
  • January 2013 to December 2015

Geo-Marketing System Admin
Served as a liaison between the business community and the IT organization to provide technical software to meet user needs .Led a range of projects across more than 15 different department related to IT enablement (e.g. POS, Route Optimization, Merchandising, Demographic analysis and others), Coordinate with the system provider in case of database failure or any customization needed.
• Working with and Analyzing Data: Manage and implement database, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality. E.g. Implement Spatial (Demographic) Report to enhance reports Visualization.
• Corporate Project Manager: Successfully manage a Dynamic Routing improvement project and applying lean six sigma methodologies to reduce cost of transportation and time. After the end of this project the transportation cost has being decreased by %20.

Geo-Marketing Specialist at DAL GROUP - Sayga Investment Company Ltd
  • Sudan - Khartoum
  • November 2010 to December 2012

Assist to developed the unit’s vision, mission, objectives and existing/ foreseen activities.by conducting a study on Geo marketing department to outline the gaps & develop the improvement plan
• Process Management Documentation and Improvement: Produce, analyze, validate and Document blue print after gathering requirement, applying gap analyses and provide a solution design of business and system processes. E.g. established a process mapping for Geo marketing Business unit to determine process gaps and Improved Geo marketing Business operation Model. By validate and measure the process effectiveness, efficiency and adaptability. To determine CTQs and develop solution plan
• Interpreting and Presenting Results :Consult and support marketing decision makers for better positioning of diverse range of brands & products by performing spatial analysis on regional level, Engage with and Utilize the internal stakeholder sources to update all Geo-marketing map layers, including coverage prediction, data
Warehouse information, Sales channel POS and KPIs, etc. to continuously provide direction and analysis

teacher assistant at University Of Khartoum
  • Sudan - Khartoum
  • October 2008 to October 2009

working as a teacher assistant in university of khatoum teachig ORACLE

Education

Master's degree, Information Technology /Business Intellegence
  • at University of Khartoum
  • June 2014
Bachelor's degree, school of mathematical sciences (information technolog department)
  • at Universuty Of Khartoum
  • October 2008

graduated from school of mathematical sciences (information technology department) wit honors second class

Specialties & Skills

Business Analysis
Application Performance Management
Oracle RAC
oracle DBA
Business Process
Business Analysis

Languages

Arabic
Native Speaker
English
Expert

Training and Certifications

Geographic Information System ArcGIS software ESRI (Training)
Training Institute:
ESTDAMA energy and mining training center
Date Attended:
December 2012
PMP preparation Course (Training)
Training Institute:
AXON Training Center
Date Attended:
December 2012
LEAN SIX SIGMA BLACK BELT (Certificate)
Date Attended:
November 2016
SOLARIS 10 SYSTEM ADMIN 1 (Training)
Training Institute:
GATE WAY
ORACLE RAC '1Z0-048 Oracle Database 10g Real Application Cluster R2' (Certificate)
Date Attended:
August 2010
Oracle Certified Professional ('1Z0-043' Oracle Database 10g: Administration II) (Certificate)
Date Attended:
July 2010
Oracle Certified Associate '1Z0-042' Oracle Database 10g: Administration I. (Certificate)
Date Attended:
July 2010