Amr

Worked within a team in a project of Saudi Press Agency (SPA) to comply to NDMO requirements.
Prepared required technical and business metadata documents for SPA required from SDAIA GSB.
Conducted an in-depth analysis of business requirements and user needs to understand the key metrics and KPIs to be tracked on the dashboards.
Collaborated with stakeholders to identify data sources, define data granularity, and determine the level of interactivity and visualization.
Designed and implemented a robust data model that aligned with the identified business requirements.
Applied many ETL techniques using Informatica PowerCenter to wrangle data from various sources into a centralized data warehouse including data cleansing, aggregation, and transformation to ensure data accuracy and consistency.
Defined the key performance measures and metrics to be visualized on the dashboard.
Developed more than 80 dashboards using Power BI including interactive charts, graphs, and tables to present the measures in a clear and meaningful way with applying best practices in data visualization to enhance user understanding and facilitate data-driven decision-making.
Collaborated with stakeholders and users to gather feedback on the initial dashboard prototypes.
Incorporated their input to refine and enhance the visualizations, ensuring they were aligned with their needs and preferences.
Iteratively tested and adjusted the dashboard design to optimize usability and effectiveness.
Deployed the BI dashboard to Power BI service platform, ensuring accessibility and security.
Conducted user training sessions to educate stakeholders and end-users on how to navigate and interpret the dashboard effectively.
Provided ongoing support and addressed any questions or concerns.

- I worked withing a team in a project of Saudi Press Agency (SPA) to comply to NDMO requirements.
- Prepared required technical and business metadata documents for SPA required from SDAIA GSB.
- Conducted an in-depth analysis of business requirements and user needs to understand the key metrics and KPIs to be tracked on the dashboards.
- Collaborated with stakeholders to identify data sources, define data granularity, and determine the level of interactivity and visualization.
- Designed and implemented a robust data model that aligned with the identified business requirements.
- Applied many (ETL) techniques using Informatica PowerCenter to wrangle data from various sources into a centralized data warehouse including the processes of data cleansing, aggregation, and transformation to ensure data accuracy and consistency.
- Defined the key performance measures and metrics to be visualized on the dashboard. These measures were derived from the business requirements and represented critical indicators of business performance.
- Developed more than 80 dashboards using Power BI including interactive charts, graphs, and tables to present the measures in a clear and meaningful way with applying best practices in data visualization to enhance user understanding and facilitate data-driven decision-making.
- Collaborated with stakeholders and users to gather feedback on the initial dashboard prototypes. Incorporated their input to refine and enhance the visualizations, ensuring they were aligned with their needs and preferences. Iteratively tested and adjusted the dashboard design to optimize usability and effectiveness.
- Deployed the BI dashboard to Power BI service platform, ensuring accessibility and security.
- Conducted user training sessions to educate stakeholders and end-users on how to navigate and interpret the dashboard effectively providing ongoing support and addressed any questions or concerns

Worked within a team in the project of MEWA, collaborating closely with the client to understand their business objectives and requirements, translating them into actionable insights and solutions.
Worked with stakeholders to identify key business metrics and performance indicators, ensuring alignment with strategic objectives.
Utilized Power BI tool techniques to extract, transform, and analyze data, providing valuable insights and recommendations to the client in the domain of governmental procurement and inventories.
Developed and maintained robust data models to restructure data into visual abled model.
Developed more than 50 dashboards and reports to visualize and track key performance indicators (KPIs) and business metrics.
Conducted data validation and quality assurance to ensure accuracy and reliability of the outputs.
Collaborated with cross-functional teams to implement and deliver business intelligence solutions.
Facilitated meetings, workshops, and presentations to communicate findings, insights, and recommendations to the client's management and stakeholders.
Played a pivotal role in identifying opportunities for process improvement, cost reduction, and revenue enhancement through data analysis and business intelligence initiatives.

Led a technical team over Oracle EBS R12 applications to build data warehouse for Sales, Purchasing and Inventories processes.
Collaborated with stakeholders to gather requirements and translated them into technical specifications for data analytics and reporting solutions.
Applied data analytics techniques, such as data mining, statistical analysis, and predictive modeling, to uncover patterns, trends, and correlations in the data.
Used ODI to develop more than ETL techniques to load data into developed robust data models that worked as a data lake for different business processes measures.
Conducted data profiling, cleansing, and quality assurance to ensure accuracy, consistency, and reliability of data used for analytics.
Designed and maintained business intelligence solutions using OBIEE and Power BI including more than 120 dashboards, reports, and visualizations, to provide actionable insights and support data-driven decision-making.
Provided training and support to end-users, enabling them to effectively utilize and interpret the business intelligence tools outputs.
Actively monitored and optimized the performance of data analytics and business intelligence solutions, identifying areas for improvement and implementing enhancements.

Worked within a team on the project of implementing Oracle Supply Chain Management (SCM) R12 modules (Inventory, Order Management, Purchasing, Shipping Execution, WMS, BI).
Worked within a team in the project of implementing integration between Oracle SCM modules and inventory Auto-Store WMS system.
Led a technical team in the project of complying to MOH regulations of medicines aggregation reporting with Origin system for aggregation solutions.
Conducted requirement gathering sessions with clients to understand their business processes and translated them into functional specifications for system configuration and customization.
Configured Oracle SCM modules based on the client's requirements, ensuring alignment with industry best practices and Oracle's recommended standards.
Extracting, Reverse Engineering and uploading master data and opening balances using different APIs, Interface Tables, Data Loader and Excel Macro.
Designed and executed test cases, scenarios, and scripts to ensure the quality and functionality of the Oracle SCM system.
Conducted system integration testing (SIT) and user acceptance testing (UAT) to validate the implemented SCM solutions and ensure they met the client's business requirements aligned with integration with Oracle Financial modules.
Collaborated with cross-functional teams, including financial, HR, business users, developers, and project managers, to deliver Oracle SCM projects on time and within budget.
Provided functional and technical support to end-users, addressing their inquiries, troubleshooting issues, and resolving system defects.
Developed and delivered training materials and conducted training sessions for end-users to ensure their effective utilization of the Oracle SCM system.

Led the technical team in the project of upgrade from Oracle E-Business Suite (EBS) R11 into R12.
Worked closely with functional consultants and business users to understand and address technical issues, system defects, and data inconsistencies.
Developed customizations and extensions within Oracle EBS using tools such as Oracle Forms, Oracle Reports, Oracle Workflow and BI Publisher.
Conducted technical analysis, design, and coding to implement system enhancements, customizations, and integrations within Oracle EBS.
Implemented Oracle EBS configurations, setups, and personalizations to align the system with business requirements.
Shared in the system integration testing (SIT) to ensure the quality and functionality of developed solutions.
Provided technical expertise and guidance to cross-functional teams, including developers, database administrators, and project managers.
Assisted in the migration and upgrade of Oracle EBS applications, ensuring a smooth transition and minimal disruption to business processes.

Led a team of Oracle applications professionals, overseeing their daily activities, providing guidance, and fostering a collaborative and productive work environment.
Managed and prioritized project tasks and assignments, ensuring timely and successful delivery of Oracle Applications projects.
Collaborated with business stakeholders to understand their requirements, aligning project goals with business objectives.
Provided technical leadership and expertise in Oracle application products.
Coordinated with cross-functional teams, including functional consultants, developers, database administrators, and project managers, to ensure seamless integration and delivery of Oracle Applications solutions.
Assisted in the recruitment and onboarding of new team members, ensuring a strong and capable team to support Oracle Applications projects.

Worked within a team that developed and maintained Oracle database applications using SQL, PL/SQL, and Oracle development tools such as Oracle Forms, Oracle Reports, and Oracle Application Express (APEX).
Collaborated with business stakeholders to gather requirements and translate them into technical specifications for Oracle applications.
Designed and implemented database schemas, tables, views, and stored procedures to support application functionality and data management.
Created efficient and optimized SQL queries and PL/SQL code to retrieve, manipulate, and update data within Oracle databases.
Developed and customized Oracle Forms and Oracle Reports to create user-friendly interfaces and generate business-critical reports.

Supporting and enhancing University systems using Oracle 10g (SQL, PL/SQL, Forms, Reports).
Analyzing, designing and developing systems using Oracle 10g for Books Outlet, Library, University Clinics.
Creating and Customizing Different DB Objects to maintain business requirements like Procedures, Functions, Triggers and DB Policies.