Hani Adel Omar - PMI - PMP - MTC Dynamics - MCSA - MCP

• Functional Consultant: A functional consultant in Dynamics 365 CE
projects is responsible for gathering and analyzing business
requirements, designing, and implementing functional solutions.
• Module Configuration: I am responsible for configuring and customizing
Dynamics 365 CE modules, including Sales, Project Operation,
Customer Service, Customer Voice, and Marketing, to align with the
organization's specific needs and processes.
• User Training and Support: I provide training and support to end-users
and team members, ensuring they can effectively use and navigate
the Dynamics 365 CE system for their respective roles.
• Workflow Automation: I design and implement workflow automation
solutions within Dynamics 365 CE, streamlining business processes and
reducing manual tasks to enhance efficiency.
• Customization and Extension: I customize and extend the functionality
of Dynamics 365 CE through the use of Power Apps, Power Automate,
and custom code when necessary, tailoring the system to meet unique
business requirements.
• Security and Access Control: I manage security roles and access
controls within Dynamics 365 CE, safeguarding sensitive data and
ensuring that users have appropriate levels of access.
• Quality Assurance: I conduct thorough testing and quality assurance to
ensure that system configurations and customizations work as
intended, identifying and resolving any issues promptly.
• Reporting and Analytics: I create and configure reports and
dashboards within Dynamics 365 CE, enabling users to track key
metrics, monitor performance, and make informed decisions.
• System Maintenance and Upgrades: I oversee routine system
maintenance, including applying updates and patches, to keep
Dynamics 365 CE running smoothly and securely.
• Performance Optimization: I continuously monitor system performance
and implement optimizations to ensure the system operates efficiently,
even as data volume and usage grow.
3 of 6
• Data Governance: I establish and enforce data governance policies
and best practices to maintain data accuracy, consistency, and
compliance with regulatory requirements.
• Collaboration with Stakeholders: I collaborate closely with business
stakeholders, including department heads and end-users, to gather
requirements, prioritize enhancements, and align system configurations
with business goals.
• Documentation: I maintain comprehensive documentation of system
configurations, customizations, and processes to ensure knowledge
transfer and support ongoing system management.
• Problem Resolution: I troubleshoot and resolve issues related to
Dynamics 365 CE configurations promptly, minimizing disruptions to
business operations.
• Report Development and KPI Integration: I am responsible for
developing comprehensive reports that encompass various elements,
including interactive dashboards, metrics, year-over-year analysis,
growth rates, win and loss rates, and essential sales performance
metrics, which includes KPIs. Additionally, I conduct budget vs. actual
analyses to compare actual revenue with budgeted revenue,
calculating profit margins to assess profitability.
• Data Visualization: I utilize Power BI, DAX, Tableau, SSRS and SSIS to
create visually appealing and interactive data visualizations, making it
easier for stakeholders to understand complex data.
• Scripting and Coding: Utilize scripting languages (e.g., DAX) and
programming languages (e.g., SQL) to automate data processes,
perform data analysis, and build data pipelines.
• Presentation Skills: In addition to report creation, I prepare and deliver
presentations to top-level executives, country managers, and
department managers, effectively communicating the findings and
insights derived from the reports.
• Data Analysis: My role involves analyzing the data to identify trends,
opportunities, and areas for improvement in sales performance.

• Customization and Development: In my role, I extensively customize
Microsoft CRM (4.0 - 2011 - 2013 - 2016 - 9.0) to align it with specific
business processes and user requirements. This involves tailoring entities,
forms, and views, developing custom workflows, and creating custom
entities, attributes, and relationships. Additionally, I implement clientside scripting using JavaScript to enhance the user interface (UI)
functionality, improving the overall user experience.
• C# Plugin Development: I have experience in developing and
deploying C# plugins within Microsoft CRM (4.0 - 2011 - 2013 - 2016 - 9.0)
to extend its functionality. These custom plugins enable the
incorporation of unique business logic and automation, providing
solutions for complex tasks. Additionally, I use C# plugins to integrate
Microsoft CRM (4.0 - 2011 - 2013 - 2016 - 9.0) with external systems and
services, allowing seamless data exchange through custom
interactions with external APIs and data sources.
• Web API Integration: Utilizing the Microsoft CRM (4.0 - 2011 - 2013 - 2016
- 9.0) Web API, I establish smooth integration with external applications.
This ensures efficient data exchange and process automation,
facilitating seamless communication between Microsoft CRM (4.0 -
2011 - 2013 - 2016 - 9.0) and other systems.
• Automated Workflows: I design and implement automated workflows
using tools like Power Automate. These workflows connect Microsoft
CRM (4.0 - 2011 - 2013 - 2016 - 9.0) with various applications and
automate processes such as data transfers and notifications. This not
only enhances efficiency but also improves data consistency and
reduces manual effort.
• Data Migration and Transformation: I am proficient in developing data
migration scripts and processes to facilitate the smooth transition of
data from legacy systems into Microsoft CRM (4.0 - 2011 - 2013 - 2016 -
9.0). Additionally, I implement data transformation and cleansing
procedures to maintain data quality and consistency during migration.
• Integration with External Systems: My expertise extends to integrating
Microsoft CRM (4.0 - 2011 - 2013 - 2016 - 9.0) with external systems,
databases, and contact center solutions.
• Advanced Reporting and Analytics: I create advanced reports and
dashboards using tools like Power BI to provide in-depth insights into
Microsoft CRM (4.0 - 2011 - 2013 - 2016 - 9.0) data. These reports are
customized to cater to specific business needs and requirements,
enabling informed decision-making..
• ETL Development: Create and maintain Extract, Transform, Load (ETL)
processes to extract data from various source systems, transform it into
a usable format, and load it into a centralized data warehouse. Ensure
that ETL processes are efficient, scalable, and maintain data quality
and consistency.
• Data Modeling: Design and develop data models, including star
schema and snowflake schema, to facilitate efficient data
organization and retrieval. Optimize database structures for both
performance and ease of use by data analysts and other stakeholders.
• Data Integration: Work with different types of databases (e.g., Microsoft
SQL) and data sources (e.g., APIs, flat files) to integrate data from
various systems into the data warehouse. This involves data mapping,
data profiling, and data transformation.
• Data Transformation: Apply various data transformation techniques,
such as data cleansing, aggregation, and enrichment, to make data
suitable for analysis and reporting.
• Data Visualization: Collaborate with data analysts and business users to
create meaningful data visualizations using tools like Power BI, Crystal
report, Pagination report, Tableau, SSRS, or others to facilitate datadriven decision-making.
• Scripting and Coding: Utilize scripting languages (e.g., DAX) and
programming languages (e.g., SQL) to automate data processes,
perform data analysis, and build data pipelines.

Design, develop, test, debug, and deploy solutions using Visual Studio, SQL Server, SSRS, SSIS &, and Power BI.

Update Microsoft CRM 3.0 to Microsoft CRM 4.0 and act as functional & Technical Consultant.

Develop technical specifications and full proficiency in crystal report design & coding.

Proficiently works with MS SQL Server, including the development and management of T-SQL scripts and stored procedures.

Fluency with RDBMS concepts such as hierarchical, relational, and multidimensional database modeling concepts. In-depth understanding of database management systems, online analytical processing (OLAP), and ETL (Extract, transform, load) framework.

Analyzes and understands various data models in depth; proactively defines data structure additions (views, distribution methods, intermediate tables, multidimensional cubes) that would improve performance or add value.

Develops, distributes, and provides support for reports and or dashboards in a timely manner, prioritizing multiple requests and maintaining a supportive relationship with all users.

Manages and monitors scheduled execution of routine processes and reports, diagnosing and fixing any report-related issues while maintaining excellent open communication internally and externally.

Works within established guidelines, standards and methodologies for creating BI solutions and documentation.

Responsible for system analyst and implementation of new technology for Talaat Mustafa Group.
End-to-end management including requirements gathering, scoping, gap and cost benefits analysis.
Analysis and identification and documentation requirements for data and work flow and logical operations and the environment of hardware, operating systems and other related regulations.
Audits and internal and external oversight and outputs.
Coordination and development of new data and to ensure consistency and good integration with existing systems, applications, analyze and assess the feasibility and costs of the new system and its compatibility with the business processes in place, the encoder (BOQ).
Gathering relevant information and mapping the existing business process concerned with material procurement storage and consumption.
Contracting relevant software suppliers and establishing contact with suppliers in preparation of client interviews.
Provide design of both physical and logical network.
Rebuilding the entire network infrastructure across four remote locations.
Supervise engineers and other staff in the design or implementation of network solutions
Evaluate network design to determine whether customer requirement are met efficiently and effectively
Develop recommend network security measures such as firewall, network security audits.
Prepare detailed network specification including diagrams, chart, equipment configuration, and recommended technology.
Monitor and analyze network performance and data input/output reports to detect problem, identify inefficient use of computer resources or perform capacity planning.
Coordinate network operation, maintenance, repairs, or upgrade.
Determine specify network hardware or software requirements, such as platform, interfaces, bandwidth, or routine schemas.
Connect some of the departments via the wireless antenna and also design Their Network that will tie their inventory with the departments of the project.
Provided pre-sales technical support as needed.
Prepare research plans and documented projects for all LAN and WAN based methods.
Develop budgetary and business based projects and administer implementation of multi-functional technology based action plans.
Prepare daily assessment reports for submission with the help of time management machinery for constant tracking.