أنس سلامة

Implement oracle Hyperion planning and Budgeting application & PBCS for SBM Projects.
• Gather business requirements and prepare main documents that meet client expectations about project.
• Conduct a major meetings with clients like CRP1, CRP2, and Users Training to be aligned with the Hyperion application .
• Design and build financial and workforce planning applications using forms and calculation scripts with well-designed ESSBASE cubes to get high performance and availability for both planning and reporting budgeting application with actuals data .
• Help and advice ERP oracle Developers to develop the requirements that should be available for Hyperion application like actuals data and dimensions metadata.
• Prepare security matrix report to apply it on application on forms and dimensions metadata levels .
• Prepare the final financial statements for the project like P&L, Balance Sheet and Cash flow .
• Develop and design the excepted reports from application using oracle financial reporting studio.
• Follow up application installations and configurations processes, application and data backups with the DBA’s.
• Very strong knowledge in relational database, ODI that help to prepare actuals data from ERP to Hyperion planning application .
• Design and develop Hyperion planning approval process

• Build Oracle Hyperion planning & budgeting application using EPMA and classing mode .
• Build and design dimensions Like Entity, Account, Version, Scenario, Periods, Years and Custom Dimensions
• Apply Hyperion Application Security on "Dimensions, Forms, Users, Groups" Levels .
• Load metadata and actual data From transactional application’s Like Oracle EBS R12 into Oracle Hyperion application using Interface Tables, Rules Files, SQL and PL/SQL Scripts and Oracle Data Integrator.
• Create and manage Oracle Hyperion Planning data Forms .
• Develop calculation script’s to get user business requirements .
• Develop and design the excepted reports from application using oracle financial reporting studio
• Design and develop Hyperion planning approval process.
• Develop application's migration process between Hyperion planning application's
Anas Salameh + 966 (0) 5 626 50 180 \[salameh.anas86@hotmail.com\]
Page 2
• Load Sales Budget and COGS Data from Hyperion planning application into Relational Database Using MDX Script Editor and Oracle Data Integrator (ODI) .
• develop oracle EBS R12 SQL and PL\SQL Scripts (Financial, SCM, OPM) and load, migrate data into one data warehouse .
• Excellent Exposure in Manufacturing, Sales business process flows and Financial reporting analysis etc.
• Build a complex calculations for whole group like COGS (Cost of Good Sold ) and Sales calculation using oracle Database procedures and load the data into BI DW .
• Develop Integration between Oracle EBS R12 with Oracle Hyperion Planning.
• The Champion for Business inelegance balance score cards project.
• Create oracle BI application using OBIEE, BI repositories and OBIEE Dashboards and analysis.

.• Integrations and Interfacings between applications mainly Oracle EBS R12 with another Application like
➢ EDMS ( Electronic Documents Management System ) .
➢ Health Insurance Application .
➢ Financial Core Banking System .
• Developed Custom’s Application in Oracle EBS R12 like health Insurance and time Attendance Applications
• Migrated and Uploaded Data using oracle EBS R12 API’s, interfaces and SQL, PL/SQL scripts .
• Developed reports in oracle EBS R12 using oracle report Builder and XML publisher .
• Designed a useful Documents like user manual application, user test acceptance, application extension
technical design and application extension functional design .

• Member of development team for Financial and Special Business packages including almost 20 modules form HR packages to GL and material Package’s, continues maintainces, debugging and improvement of the system and development of forms / reports/programs units (procedures, functions, triggers ) using oracle Database(6i, 10g) and oracle form developer and report developer(6i, 10g) .
• Main player in putting the template and main standardization of system called (wise ERP) .