Mohammed Fawzy

• Cultivated Data-Driven Culture: Successfully implemented a data-driven culture, leading to significant improvements in eficiency and data-driven decision-making across the organization.
• Delivered Strategic Data Solutions: Led a cross-functional team to develop and implement data-driven solutions that addressed critical business needs.
• Generative AI: Development of a database chatbot utilizing OpenAIs LLM model and Langchain to understand user queries and translate them into natural language results to leverage AI capability to business users.
• Enhanced Data Integration: the integration of CRM, HR, and e-commerce applications with the Microsoft Dynamics AX ERP system using Boomi, a cloud-based Integration as a Service (iPaaS) platform. This streamlined data flow, improved data accuracy, facilitated comprehensive business insights, and reduced data silos.
• ERP Database Management: Managed a high-availability Microsoft Dynamics AX 2012 database cluster to ensure optimal performance and data integrity for critical business processes. Additionally, managed the database for retail Point-of-Sale (POS) transactions, ensuring real-time data availability and transaction processing.
• Actionable Insights: Led data analysis efforts to identify trends, patterns, and opportunities for growth. Presented actionable insights to stakeholders to inform strategic decision-making.
• Predictive Analytics Expertise: Developed and implemented predictive models to forecast future trends, enabling proactive business planning.
• Data-Driven Foundation: Built and maintained a robust data warehouse architecture, ensuring data accuracy, integrity, and accessibility for analysis.
• Communication & Collaboration: Thrive in team environments and effectively communicate with stakeholders to understand business needs and deliver data-driven solutions.
• Designed and maintained data pipelines using SQL, Azure Data Factory (ADF), SSIS, and Python.
• Managed data disaster recovery, availability, backup, and recovery processes.
• Oversaw data quality control and implemented data cleansing efforts.

Advanced Analytics Solutions:
○ Operational Eficiency: Optimized inventory levels through data-driven solutions, leading to reduced carrying costs by 20% on aging stock.Implemented a data-driven inventory segmentation model based on sales velocity and lead time to prevent stockouts, improve inventory turnover, and optimize safety stock and reorder point calculations.
○ Financial Performance Analysis: Developed reports and dashboards for financial health, including trial balances, financial statements, receivable aging, and collection management. This empowered informed decision-making.
○ Sales & Customer Growth: Implemented customer segmentation (RFM), customer churn analysis, and customer lifetime value (CLV) models to identify high-value customers and optimize sales strategies, Marketing campaigns, and loyalty programs.
○ Predictive Modeling: Leveraged ML demand forecasting model to anticipate future requirements and ensure on-time product availability for customers. ○ Project Management: Utilized data analytics to track project sales pipelines, enabling proactive management and improved success rates, ○ Logistics & Operations: Developed logistics tracking report to improve supply chain visibility and optimize delivery routes.

• Conceptualization to Completion: Possess a proven track record of leading data warehouse projects from initial concept to successful implementation.
• Database Management: Skilled in managing high-availability database clusters, including Microsoft Dynamics AX (2012) and retail POS database systems.
• Technical Expertise: Skilled in data modeling (Kimball, Inmon), ETL processes, data mining, and data analysis to ensure eficient data integration and actionable insights.
• Database Mastery: Expert in utilizing SQL, Oracle, and various database technologies to design, develop, and maintain secure, reliable, and scalable data warehouses.
• Data Visualization Prowess: Create compelling and insightful dashboards and reports using Power BI, Cognos, and Tableau to communicate data stories effectively to stakeholders across all levels.
• Strategic Visionary: Develop and implement data warehouse strategies and roadmaps to align with evolving business needs.
• Disaster Recovery & Security: Managed data disaster recovery, availability, backup, and recovery processes to guarantee data security and accessibility.
• Stakeholder Collaboration: Adept at collaborating with stakeholders to identify data requirements and translate them into data-driven solutions.
• Data Storage & Access: Designed and maintained data storage and access systems to facilitate eficient data utilization.

As a Senior Database Administrator and Business Intelligence (BI) developer, I have extensive experience in managing and optimizing large-scale, complex database systems. My expertise includes troubleshooting, performance tuning, and security management. I have hands-on experience with various RDBMS such as Oracle, MySQL, and SQL Server. I also have experience in using BI tools like SSRS, and Power BI to create and maintain data warehouses, data marts and reporting/analytics tools. My strong skills in SQL, ETL processes and data modeling, made me proficient in delivering efficient BI solutions. I have experience working in team environments and communicating with stakeholders, which enabled me to understand business needs and deliver solutions accordingly.

As a System Administrator, I am responsible for the installation, configuration, maintenance, and troubleshooting of computer systems and networks. My experience includes setting up and maintaining servers, storage devices, and network equipment, as well as performing software and security updates. I also have experience with monitoring and performance tuning of systems, and I am proficient in using troubleshooting and diagnostic tools. My strong communication and problem-solving skills make me an asset to any organization.

As an IT Specialist, I have experience in providing technical support to users, troubleshoot and resolve hardware and software issues, installation and maintenance of computer systems and networks. I am proficient in various operating systems and have experience in managing and maintaining servers, storage devices and network equipment. My expertise in IT security and data protection has enabled me to identify and mitigate potential threats and vulnerabilities. I have a track record of delivering projects on time and providing efficient support to users. My strong analytical and problem-solving skills make me an asset to any organization.

As an IT Specialist, I have experience in providing technical support to users, troubleshoot and resolve hardware and software issues, installation and maintenance of computer systems and networks. I am proficient in various operating systems and have experience in managing and maintaining servers, storage devices and network equipment. My expertise in IT security and data protection has enabled me to identify and mitigate potential threats and vulnerabilities. I have a track record of delivering projects on time and providing efficient support to users. My strong analytical and problem-solving skills make me an asset to any organization.

Technical Support For ERP application Business Key client side
Support for Office Pcs, and servers.
Tester For Application