EXPERIENCE SUMMARY:

• Oracle Hyperion Consultant with strong experience in implementation, enhancement and support for various Oracle Hyperion Planning and Essbase applications. Currently supporting Oracle EPBCS application after successful implementation.
• Over 14 years’ of project execution experience in Oracle Hyperion Essbase (ASO & BSO), Hyperion Planning (with different module like Workforce & CAPEX) Hyperion Financial Reporting, Smart view and Spreadsheet Add - In. Also have good experience in Hyperion EPMA, Oracle Data Integrator (ODI), Hyperion Web Analysis and OBIEE with teams located in different geographical locations with Offshore-Onsite and shared services model.
• Expertise in Calculation Scripts, Maxl, MDX Querying, Esscmd, Report Scripting, Performance tuning, utilize the functionalities thorough understanding of Essbase data mining framework. Also have good knowledge in Java, Visual Basic, PowerShell, Python, Jython, Perl scripting to automate Import/Export data and metadata.
• Expertise in Development of Budgeting & Forecasting process, Business rules, Web forms, Task List, Smart List, Workflow Process and user/group level security building in Hyperion Planning.
• Have experience on Upgrade Hyperion product like EPMA, Essbase, Planning and Financial Reporting higher version and Migration Hyperion Planning and Essbase application from one environment to other environment.
• Proficiency in Data Warehousing techniques, building Relational Databases using SQL Server and Oracle with SQL and PL/SQL coding, Essbase cube integration with OBIEE, Report and Dashboard building using OBIEE, Hyperion Financial Report and Smart view and end-user training.
• Having experience to direct interaction with client and execute the Hyperion and OBIEE project in different domain like Media & Entertainment, Insurance, Investment Banking, Finance, Information Technology, Oil & Gas, Supply Chain etc.
• Specialties include Hyperion & OBIEE PoC Development, Effort Estimation, Requirement gathering, Design, Build and Implementation of Hyperion & OBIEE Systems, Testing and Managing Hyperion & OBIEE Systems Production Support Activities along with Team management activities.
• Certifies on Oracle Planning and Budgeting Cloud Service Specialist Assessment.
• Excellent oral and written communication skills, strong interpersonal, problem solving and presentation Skills.
• A good team player, with high self-motivation, sincerity and commitment.

SKILLS SUMMARY:

Domain: Insurance, Manufacturing, Retail, Banking, Information Technology, Telecom, Oil & Gas, Supply Chain and Media & Entertainment.

Programming Languages: Java, SQL, PL/SQL, Visual Basic, Maxl, Mdx, PowerShell, Python, Jython and Perl script.

Operating System / ERP Version: Microsoft Windows, Linux.

Tools: Oracle EPBCS, Oracle EPM, Hyperion Essbase, Hyperion Planning, Financial Data Quality Management, Hyperion Web Analysis, Hyperion, Hyperion Financial Reporting Studio, Hyperion DRM, ODI, OBIEE (version - 10g, 11g), MS SQL Server, Oracle Database .NET framework, Control-M, Cognos Command Center, Microsoft Office 2013, Maxl Script, MDX query, Powershell, Python and Jython script.

Hardware Platforms: Intel.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Project Lead

Responsibilities:

• Develop and migrate Planning applications in EPBCS
• Create Business rule and other Planning artifacts
• Develop FR reports and Planning Web forms in EPBCS
• Involve to develop various automation scripts (Python, PowerShell etc.) to integrate the EPBCS with backend ETL and other process
• Support & Enhancement Oracle EPBCS application.

Tools: Oracle EPBCS, Smartview, Oracle Database, Flink.

Confidential, New Jersey

Project Lead

Responsibilities:

• Upgrade Hyperion component
• Create Testing scripts
• Involve in Unit testing, System Integration testing and User Acceptance testing
• Develop Java API to extract metadata from HFM system and load into relational database
• Development & Enhancement activities
• Production Support

Tools: Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, Hyperion Financial Reporting 11.1.2.4, Hyperion EPMA 11.1.2.4, Essbase Excel-Addin, Smartview 11.1.2.5.610 , Oracle Database 12c, Flink.

Confidential

Project Lead

Responsibilities:

• Requirement Gathering
• Application build using Oracle EPM, Profile creation, Business rules, Webforms, Task list, Smart List, Workflow and Security building
• Essbase calculation script, rule file, maxl script writing
• Hyperion FR and Smartview macro enable report building
• Database designing using SQL Server 2008
• Extract, Load and Transform Data, Metadata using ODI
• Job scheduling using Cognos Command Center
• Create Test scripts and involve in different kind of testing, like: Unit testing, System Integration testing, User Acceptance testing etc.
• End-User training
• Project documentation

Tools: Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3, Hyperion FR 11.1.2.3, Financial Data Quality Management Enterprise Edition (FDQMEE), ODI 11g, Essbase Excel-Addin, Smartview, SQL Server 2008, Cognos Command Center 10.2.1

Confidential

Project Lead

Responsibilities:

• Essbase configuration file and cache setting changes
• PL/SQL Stored Procedure changes
• Maxl script writing for parallel data loading
• VBA code and batch script writing for automate the Metadata and Data loading process and generate Smartview reports
• Java and JSP code writing and deploy into Web Logic
• Create Test scripts and involve in different kind of testing, like: Unit testing, System Integration testing, User Acceptance testing etc.
• End-User training
• Project documentation

Tools: Hyperion Essbase 11.1.2.2, Hyperion Financial Reporting 11.1.2.2, Smartview, SQL Server 2008, Cognos Command Center 10.2.1, WebLogic 10.3.6, Core Java, JSP

Confidential

Project Lead

Responsibilities:

• Data warehouse dimensional modeling
• Repository and Report development and deployment
• Hyperion - OBIEE connectivity
• Hyperion cube maintaining
• Hyperion Calculation script, Rule file writing and Data loading
• OBIEE reports and dashboard designing
• Writing PL/SQL code for creating stored procedure
• Preparation UAT and production environment for OBIEE and Hyperion
• Project Support
• End-User Training
• Project documentation

Tools: Microsoft Windows 2003 Server, OBIEE 11g, Hyperion Essbase 11.1.1, BI Publisher, SQL Server 2008, IIS, Control-M

Confidential

Responsibilities:

• Data warehouse dimensional modeling
• OBIEE Repository and Report development and deployment
• Hyperion - OBIEE connectivity
• Hyperion cube building
• Hyperion Calculation script, Rule file writing and Data loading
• OBIEE report and dashboard designing
• Report design using BI Publisher
• SQL and PL/SQL coding
• Preparation UAT and production environment for OBIEE and Hyperion
• Project Support
• End-User Training
• Project documentation

Tools: Microsoft Windows 2003 Server, OBIEE 11g, Hyperion Essbase 11.1.1, BI Publisher, SQL Server 2008, IIS

Confidential

Responsibilities:

• Requirement Gathering
• Planning Application creation, Business rule, Task List, Smart List, Web form design
• Metadata and security loading using Hyperion Planning utility
• Report design using Financial Report and Smart view
• Essbase rule file designing for data loading and maxl script writing for automation
• Create Test scripts and involve in different kind of testing, like: Unit testing, System Integration testing etc.
• End-User Training
• Project documentation

Tools: Hyperion Essbase 11.1.1.3, Hyperion Planning 11.1.1.3, Smartview, Oracle 10g, Control-M

Confidential

Responsibilities:

• Requirement Gathering
• Establish connection with Oracle databases and Hyperion Essbase cubes
• Data warehouse dimensional modeling
• OBIEE Repository and Report development and deployment
• SQL and PL/SQL cosing
• Create Test scripts and involve in different kind of testing, like: Unit testing, System Integration testing etc.
• End-User Training
• Project documentation

Tools: OBIEE 10.3.4, Oracle Database, Hyperion Essbase 9.3, Control-M