Amr Sarhan 🇵🇸 Email and Phone Number

Full BI enterprise system implementation in Government logistic domain design system architecture and data flow pipeline with standard and high quality structure for all system layers (Data Stage, Data Catalog, DWH, Data Mart, ETL and BI catalog, Data Visualize), Implement Administration and Control Model to detect application problems and monitor status for BI System.  Ensure Tasks accomplishment on time, with quality that meeting business satisfaction. Develop architecture and strategies for data modeling, design and implementation to meet stated requirements for metadata management, operational data stores and ETL environments. Collaborate with internal and external personnel, including system architects, software developers, database administrators, design analysts and information modeling experts to determine project requirements and capabilities, and strategize development and implementation timeline. Data profiling evaluates and maintains the actual content, structure and Implement Data Quality Management and Error Handling Processes. Support database administrators, network designers and IT personnel to create effective and secure methods for data backup and recovery. Review existing data architectures to determine overall effectiveness and compliance with original objectives, develop comprehensive strategies for improving or replacing underperforming areas and present these plans to managers and executives. Create and maintain data and dashboard security mechanism with AD integration. Create and customize the Repository using OBIEE admin tool. Efficient BI System design and setup to build interactive and effective business management dashboard. Design the optimal data pipeline architecture, Code standards and testing methodologies.

 Analyze customer requirements & needs. Handle project planning & time schedule. Monitoring project life cycle. Ensure projects accomplishment on time, with quality as contracted,meeting customer satisfaction. Finalize & sign off the application. Occasionally support Sales activities & participate in projectmanagement coordination. Distributing tasks on team members. Periodic guidance & follow up on teams’ performance. Setting staff objectives. Solve or assistance in solving technical and administrative issues facingthe team members. Conduct knowledge transfer sessions to team members. Conduct team performance evaluation. Partially responsible for related projects revenue target. Conduct presentation at customer site. Assisting in any additional tasks requested by Direct or Unit Manager.

Considerable experience in implementing BI technologies, designing and developing Data Warehouse, BI Models, Reporting, Dashboards, Cubes, KPIs and Scorecards, as well as Data Analysis ,Data Mining and Business Process for customers in various sectors using Oracle Business Intelligence suite Analysis business requirements and design DWH objects. Data archeology (data profiling) evaluates and maintains the actual content, structure and quality of the data. Create and maintain dashboard and data security integrated with AD. Create and customize the Repository using OBIEE admin tool. Create and customize answers and reports. Build interactive dashboard. Install and configure DAC and Informatica for BIAPPS. Run Subject Area ETL using DAC. Install and configure Oracle Data Integrator (ODI). Create Interfaces and Scenario on ODI.

Provide implementing and technical support and development in the following topics: OBIEE, ODI, DAC, INFORMATICA and DWH.

Oracle E-Business R12 Internal project (GL, AR, AP, FA, CE, HR, Payroll, ECM and UCM): Create and Customize application forms using oracle form builder and Custom PLL. Migrating data from Legacy systems to Oracle apps using API and table interface. Maintain upgrade issues from R11 to R12 as forms or report migration and troubleshooting problems that caused when missing or changing the source objects.  Advanced Personalization. Create and Customize reports using different database tools (Oracle Reports – XML publisher – Discoverer). Create Alerts (Periodic – event ). Create and Customize oracle work flow using workflow builder (Account Generator). Create Repository using OBIEE admin tool. Create and customize answers and reports. Build interactive dashboard. Install and configure Informatica for BIAPPS Install and configure DAC. Run Subject Area ETL using DAC.

ß Responsible to Design and building customized reports for ERP using (Oracle report builder, XML Publisher).ß Responsible to implement forms personalization, workflow and alertß Integration between ERP and legacy systems using Financial Service Accounting Hub (FSAH).ß Presales Activities.

Oracle ERP Internal project (GL, AR, AP, FA and CE):+ Responsible for acting with key users to analyzing and developing reports requirements, to be implemented on the applications.+ Analyzing the gaps in Oracle applications specially financials to develop add-ons and custom modules to fill them.+ Build custom modules that improve business activity integration. + Install application server and administrate and mange the application plus deploying forms and report.Additional Responsibilities:+ Establish risk assessment analysis study for all company departments.+ Study and design IT activities to upgrade business cycle.+ Build miscellaneous program by MS Access as: • Help Disk and Inventory Management System • Contract Management System • Sales Management System