Oracle Developer Resume
SUMMARY
- An Oracle Hyperion Planning(Cloud/On - Prem) and Essbase certified with more than 14 years of extensive experience in Oracle EPM Hyperion Suite.
- Extensive experience in BI & Data warehouse, using technologies like Hyperion Planning, Hyperion Financial Management, Essbase, HFR, FDMEE, DRM, OBIEE, Oracle & UNIX.
- Involved in Implementation, Production Support and Maintenance, Upgrade, Automations and Enhancements of different Hyperion platform applications.
- Experience in Administration, Design and development of Hyperion Planning Application, Essbase.
- Developed Essbase Cubes (ASO/BSO), HFR, FDMEE/FDQM rules, ODI mappings.
- Build Hyperion Business Rules, Calc Scripts, Planning Forms, other Hyperion Objects.
- Involved in PBCS/EPBCS in-house training and POC’s.
- Expert in developing application security process, creating users/groups, security profiles and application access to different groups using filters.
- Skilled in optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environments.
- Experienced in administration, maintenance, troubleshooting and enhancements of several Hyperion Planning, HFM and Essbase applications.
- Proactively involved with Presales team in preparing Request for Proposals, designed and developed POC and presenting Hyperion capabilities to the potential clients
TECHNICAL SKILLS
OLAP Tools & Technologies: Oracle Hyperion EPM (v7.5 to v11.1.2.4) - Hyperion Planning, Essbase, Hyperion Financial Management (HFM), Hyperion Financial Reports, FDMEE, DRM & Smart View
Cloud: PBCS and EPBCS
Database: Oracle 10/11g (SQL, PL/SQL), SQL Server
Tools: /Utilities: Toad, SQL Developer, Putty, HPSM, Remedy, Quality center, Service Now, Control-M, Bridge ClarifyETL: Informatica 8.x, ODI 11.x, DM Express 6.XOperating System: UNIX HP-UX - B.11.11, WINDOWS 9x/2000/NT, Solaris
PROFESSIONAL EXPERIENCE
Confidential
Oracle Developer
Responsibilities:
- Managing end-to-end Tiffany Hyperion applications including production support and enhancement of Hyperion planning, financial Consolidations and reporting applications.
- Actively involved with Project team to implement EPBCS Financial Module.
- Handling entire Hyperion infra and admin activities.
- Analysis and performance tuning of existing Planning objects and BSO applications.
Confidential
Oracle DeveloperTools: HFM 11.1.2.4, Hyperion Planning 11.1.2.4, EPBCS, Essbase, FDMEE 11.1.2.4 and HFR.
Responsibilities:
- Technical Lead for Hyperion team and providing efficient and quality Techno-Functional support to business users and processes.
- Providing end-to-end production support and enhancement to existing Hyperion, financial planning, financial Consolidations and reporting applications.
- Involved in close activities for actual consolidation, smooth functionality of Planning process which involved closing of actual month, opening/closing of forecast cycle and other planning process.
- Leading enhancement and development for existing/new Hyperion applications.
- Involved in successful completion of Disaster Recovery (DR) Drill since last 2 years.
Confidential
Oracle DeveloperTools: Hyperion Planning 11.1.2.4, Essbase 11.1.2.4, HFM 11.1.2.4, FDMEE 11.1.2.4, DRM, HFR.
Responsibilities:
- Provided end-to-end production support and enhancement to existing financial reporting and planning applications.
- I was handling technical Hyperion team and providing efficient and quality Techno-Functional support to business users.
- Involved in smooth functionality of Planning process which involved closing of actual month, opening/closing of forecast cycle and other planning process.
- Involved in quarterly enhancement which required requirement gathering, designing and development of Planning and Essbase objects.
Confidential
Oracle Developer
Tools: Hyperion Planning 11.1.2.4, Essbase 11.1.2.4, FDMEE 11.1.2.4, OBIEE 11g, Oracle 11g.
Responsibilities:
- Created new Planning Forms and updated existing Business rules
- Designed and Developed new ASO reporting application, MDX formulas and other Essbase objects.
- Analysis and performance tuning of existing Planning objects and BSO applications.
- Build Hyperion Forms, Business rules, calc scripts and data load rule files.
- Involved in administration activity of hyperion planning and ASO applications.
- Automation of metadata build and data load in reporting application.
- Integration of OBIEE with Essbase reporting application where OBIEE sit on top of ASO Essbase application.