Oracle Technical Consultant &Hyperion Specialist
Nuqul Group
Total years of experience :15 years, 5 Months
• Build Oracle Hyperion Planning Application in Two Different way using Classic and EMPA .
• Build Oracle Hyperion Planning Dimensions Like Entity, Account, Version, Scenario, Periods, Years and Custom Dimensions .
• Apply Hyperion Application Security "Dimensions, Forms, Users, Groups" Levels .
• Loading 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 Application's Migration Process Between Hyperion Planning Application's
• Load Sales Budget Data from Hyperion Planning Application into Relational Database Using Using MDX Script Editor and Oracle Data Integrator (ODI) .
• Installed and Configured Oracle EPM System Products .
• Hyperion Calculation script’s Skills and troubleshooting and fixing it .
• Developed SQL and PL\SQL Scripts From oracle EBS R12 ( Financial, SCM, OPM ) modules .
• Developed SQL and PL\SQL Scripts (Financial Module) and load, migrate data into one data warehouse .
• Developed Sales Calculations like Rebate discounts and Out of the Books transactions in Custom Database .
• Migrated and loaded data into oracle EBS r12 database using API, Interfaces and SQL and PL\SQL Scripts .
• Installed and configure Oracle Repository Creation Utility “ RCU” .
• Installed Oracle Business intelligence 11g on windows and Unix Operating System .
• Develop an Integration between Oracle EBS R12 with Oracle Hyperion Planning .
• Develop an Integration between Oracle Dementra With Oracle Hyperion Planning .
• Good Exposure in Manufacturing, Sales business process flows, etc.
• 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 .
• Wrote a useful Documents like user manual application, user test acceptance, application extension
technical design and application extension functional design .
• Good In Oracle HRMS business Process flows, Polices ….etc.
• 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) .