SUMMARY

• 10+ years of expertise in the area of Data Warehouse and OLAP software systems design and implementation.
• Strong Technical and Functional experience in application architecture, design, analysis, development and administration of various budgeting and reporting applications using Oracle EPM 11, Hyperion Essbase, Hyperion Planning, Hyperion Financial Management(HFM),Financial Data Management(FDM), WorkForce and CapEx modules, Hyperion Financial Reporting, Oracle Data Integrator(ODI) and Data Relationship Manager(DRM).
• Expertise in implementing full lifecycle projects starting from requirement analysis, design, development, unit testing, integration testing, user acceptance testing and deploying to Production.
• Expertise in developing ASO and BSO cubes in Essbase based on different reporting structures like PnL, GAAP, Balance Sheet etc.
• Expertise in designing metadata structure, create data forms, menus, user variables and task lists for Hyperion Planning applications.
• Expertise in creating complex calculation scripts and business rules for Essbase and Planning applications.
• Expertise in configuring Shared Services for managing user security across all Oracle Hyperion modules including external authentication using Lightweight Directory Access Protocol (LDAP), NTLM (NT LAN Manager) and Microsoft Active Directory (MSAD).
• Optimizations and performance tunings of Essbase, Planning and HFM applications.
• Experience in creating reports using Essbase Excel Add - In, Hyperion Financial Reporting Studio and Smart view.
• Experience in administration activities of Hyperion applications including software installations, system upgrades, server maintenance, data back-ups and security. Also migration and synchronization of applications between different environments.
• Expertise in developing ODI tool to extract data and metadata from various sources and automate the process for Hyperion application.

TECHNICAL SKILLS

OLAP: Oracle EPM System 11, Essbase, Planning(Workforce and Capex), Financial Management, Financial Data management, Data Relationship Management, Oracle Data Integrator and Smart View

Reporting Tools: Hyperion Financial Reporting, Excel Add-in and Smart View.

Languages: VB Script, JavaScript, XML, C, C++, Java and HTML.

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Sr. Oracle Hyperion Architect

Responsibilities:

• Install and Configure Oracle Hyperion EPM 11.1.2.3 including Public Sector Planning and Budgeting, Essbase, Financial Data Quality Management(FDMEE), ODI, Financial Reporting on SPARC Solaris 11 environment.
• Upgrade Hyperion EPM 11.1.2.3 to 11.1.2.3.500 and 11.1.2.3.700 and apply patches and bug fixes.
• Designed and created System Architecture, Virtual Local Area Network (VLAN) configuration, Communication Ports and Protocol and Services.
• Setup Production environment and configure Virtual IP (VIP).
• Created clustering for load balancing and availability.
• Promote artifacts through Change Management system from Development to UAT and Production.
• Integrate PeopleSoft 9.1 and tools 8.52 with Planning application using FDMEE to drill though to the GL of the source system.
• Setup ODI repositories, topology, Procedures and automate dimension build from PeopleSoft to Hyperion Planning applications.
• Created data forms, menus and task lists for Planning and design Budget Formulation and Execution process.
• Created calculation scripts and Business rules to perform Aggregations
• Setup security for users/groups, Planning dimensions and Financial Reports.
• Setup Workflow module and create Planning unit hierarchies and assign owners and reviewers.
• Create shell scripts for several automation such as file system backups, Essbase level-0 backups, LCM backups, nightly batch calculations and FDMEE daily and weekly actual and budget clear and load procedures.
• Provide production support to House Budget Point of Contacts(BPOC), Financial Systems support staff and work with functional teams, database and system administrators, and developers.
• Created System Security Plan (SSP) as per requirement of the Office of Management and Budget (OMB)
• Support Phase 1 and Phase 2 functional design, build, integration, development and test activities.
• Load test Hyperion Planning application including Data Forms and Business Rules using HP LoadRunner.
• Created documentation for administration process and security.

Confidential, Washington DC

Sr. Oracle Hyperion Consultant

Responsibilities:

• Provide Production support for Hyperion Planning, Essbase, Financial Reports and Oracle Data Integrator deployed on Oracle Planning and Budgeting Cloud Services (PBCS).
• Created service requests (SR), Request for Changes (RFC) with Oracle to start or stop services and for maintenance.
• Troubleshoot critical issues in calculations and modify the calculations as per the guidance from Confidential Managers.
• Trouble shoot issues with batch script for loading metadata and data using Oracle Data Integrator.
• Created a new application in development to add a new dimension, modify all artifacts such as outline, data forms, calculation scripts and migrated the application to Production using Life Cycle Manager.
• Troubleshoot issue with custom salary pusher tool and business rules to calculate benefits.
• Provide support, training and documentation for new and existing users.

Confidential, Washington DC

Sr. Oracle Hyperion Essbase / Planning Developer Lead

Responsibilities:

• Capture business requirements and provide solutions for tools to be used.
• Integrated PeopleSoft accounts and metadata with Hyperion budgeting and customized WorkForce modules based on PeopleSoft HR inputs. Integrated Capex module with accounts from JD Edwards.
• Created Planning application and initialized Workforce and Capex modules.
• Setup Workforce module and streamline based on client requirements by eliminating unused functionalities.
• Created load procedures to extract data and metadata from PeopleSoft and load to Planning applications through ODI.
• Created ODI interfaces and procedures to load files from DRM into Planning.
• Created data forms, menus and task lists for Planning.
• Created calculation scripts and Business rules to perform Aggregations, Allocations and Intercompany Eliminations, calculate payroll, manage employees, calculate depreciation and manage Assets.
• Introduced Edge method for aggregation as opposed to standard AGG commands.
• Created block operation tracking solution to track data changes by stamping data blocks with the operation performed on them.
• Customized Capex module to manage existing and new projects and also to calculate depreciation.
• Created User Acceptance Test (UAT) scripts and provided training to business users on Planning web client and Smart view.

Confidential, Dallas TX

Sr. Oracle Hyperion Essbase / Planning Developer Lead

Responsibilities:

• Gather business requirements by conducting regular meetings with the client and created design document.
• Export Meta data from existing Essbase application, format the load files and load the meta data into planning application.
• Created data forms to enable business users and managers to input data from Planning web client and Smartview.
• Created Dynamic variables and enabled them in the data forms to filter down the list of members.
• Designed Composite forms to group data forms based on similar chart of accounts and enable tabbed browsing.
• Developed business Rule for Allocations and multicurrency calculations.
• Created DRM process to extract data from Oracle and loading it into Planning.
• Created Versions, Hierarchies and set Properties in DRM.
• Optimized the Planning application by providing recommendations on form designs.
• Created macros in Visual Basic for power users to enable data load using excel add-in.
• Optimized the Essbase cube by setting up caches, preventing and reducing defragmentation, outline order, dense-sparse setting, optimize calculations and faster report retrievals.
• Created version management machinery which is the set of business rules and web forms that are used transport data to and from version members within the Hyperion Planning solution.
• Provided solution on security structure to minimize cost on licensing for Planning.
• Created batch and MaxLscript to export data from Planning cube to Reporting Essbase cube.
• Migrate the Planning Application across different environment and build procedures to keep them in sync.

Confidential, Lake Forest CA

Oracle Hyperion Essbase / Planning / HFM consultant

Responsibilities:

• Gather requirements and design Hyperion Planning application.
• Create Planning application and load Meta data and data using text files.
• Create web forms, menus and task lists in Planning.
• Create/Maintain automation scripts, and maintain responsibility for creating and updating system documentation.
• Identify, implement and test patches and upgrades and maintain up-to-date documentation of Hyperion-related configuration.
• Investigate issues in reports or cubes and provide root cause analysis.
• Set up, Manage and maintain user security through Shared Services.
• Migrate Planning and Essbase applications from one environment to other.
• Develop Interfaces and Packages in ODI to load data into Essbase and Planning applications.
• Recommend corrective actions for technical systems issues, taking into account user needs and IT resources.
• Import and manipulate data from multiple disparate systems Flat files, Essbase, Oracle and Excel sheets.
• Monitor application performance, availability, and utilization.
• Maintain Accounting structure and outline metadata for online reporting.
• Provide user support, security and other ad hoc requests.

Confidential, Hopewell NJ

Oracle Hyperion Essbase/Planning Consultant

Responsibilities:

• Install Hyperion Foundation Services, Essbase, Reporting and Analysis and Planning.
• Patch and configure all five environments with latest Hyperion 9.3.3 release update to support Windows 7 and IE8.
• Integrated client data into Hyperion Cubes and was involved in development as well as administration of Hyperion Planning application, Financial Reporting and Essbase applications.
• Full life cycle development with Hyperion Planning in creating applications, managing the application security and system users.
• Developed Business rules and attached to the input forms to calculate data on save Option
• Removed Fragmentation from Essbase cubes, recommended settings in Essbase.cfg file on Production server for optimal usage of resources.
• Developed custom VB script for automation of meta data load/refresh, start and stop of the services.
• Administered user groups and privileges in Shared Services.
• Created Backup Scripts to backup data files and logs files, created and performed Daily, Weekly and Monthly backup.
• Used CSSImport/Export and OpenLDAP backup utility to backup and restore Shared Services provisioning information and OpenLDAP.
• Implemented Weblogic cluster to perform load balance between planning servers.
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications.
• Involved in database and security refreshes in Hyperion Planning.
• Created and scheduled batch jobs for complete automation processes for nights and weekends application backup.

Confidential, Victor NY

Oracle Hyperion Planning/ODI Consultant

Responsibilities:

• Full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users.
• Loaded the metadata into the Planning Applications using the Interfaces, Procedures, and Packages and ran preload Business Rules using Oracle Data Integrator.
• Developed MaxL scripts and rules files to work with all database objects including outlines, formulas, caches, and security profiles; also designed calculation scripts, and batch files to automate data load and other maintenance procedures like outline modifications.
• Involved in database and security refreshes in Hyperion Planning.
• Participate in developing and implementing process improvements involving the corporate financial reporting process
• Created load rules, windows batch, EssCmd and MaxLscripts.
• Application development using Hyperion Planning and creating Web Forms and Business Rules.
• Optimized the applications to bring down the runtime considerably.
• Automated the execution of Packages for loading data into the Essbase cubes according to the version, period and Fiscal Year.

Confidential

Hyperion Developer

Responsibilities:

• Involved in writing ESSCMD, MaxL,API for total automation of the process
• Actively involved in writing calc scripts and reduced the calc times.
• Involved in optimizing and fine-tuning the Essbase applications for build times. Responsible for creating and maintaining users, groups using shared services.
• Responsible for creating filters using Essbase.
• Define the load rules (Hierarchies), functions and dynamic calculations for the Essbase cube build.
• Involved in tuning the applications for better performance by modifying the server side, application, and database settings.
• Communicated with all Levels of Management for ongoing report development& support.
• Worked on Essbase deployment plan (moving cubes and data from Development to Production environment).
• Involved in full life cycle development with Hyperion Planning, in creating applications, managing the application security and system users.
• Implemented and maintained Hyperion PlanningSuite 3.0 and assisted the integration of financial reporting along with streamlining of process/method improvement for data collection and the administration consolidation of monthly financial information.
• Involved in generating various reports in Hyperion Planning.
• Extensively involved in Excel-Add in for developing the upload template for the Essbase applications
• Delivered a presentation on outline optimization to the Essbase core team and identified possible anomalies in the cube outlines.
• Design and develop Web Analysis for the purpose of accessing the on line reports by the users.
• Train and help the users to access the online Web Analysis.