We provide IT Staff Augmentation Services!

Oracle Hyperion Financial Architect Resume

St Louis, MO

SUMMARY:

  • 10+ years of extensive experience in Multi - dimensional Database, Relational Database. Involved in complete SDLC including architecture, analysis, design, development, testing, implementation & maintenance of application software in the Client/Server and web-based environments,
  • Highly knowledgeable, expert-level experience in Cloud and other EPM Applications, Reporting tools, and Scripting Languages
  • Experience implementing, developing, Migration applications using Oracle Hyperion EPM System 11.x, 9.x, 7.x and 6.x
  • Expertised in Implementing Hyperion Cloud Applications and On-Premise Application have successfully Implemented Hyperion Essbase, Oracle Analytic Cloud OAC Essbase Administration Services, Hyperion Planning, EPBCS, Oracle Data Integrator (ODI), Hyperion Financial Reporting, Smart View, Hyperion Financial Reporting ESSCMD, MaxL, Essbase Excel Add-in, Calc scripts, Hyperion business rules, Dimension build rules, Partitioning, Data load rules and report scripts.
  • Experience in creating cubes using BSO (Block Storage) and ASO (Aggregation Storage) options
  • Extensive Experience designing/building Reports using various Hyperion Reporting Tools (Smart View, Financial Reporting and EPRCS)
  • Expertise in Design, Build, Installing and Migrating Application between On premises Environment and Cloud Environment.
  • Provide status and issue reports to the Stack holders on a regular basis
  • Provide assessment of current state architecture and recommendation of future state architecture
  • Cloud Architecture Development
  • Provide roadmap and migration methodology and identify quick wins
  • Provide detailed sizing and associated justification
  • Good design skills and architectural skills in the technical area
  • Develop statements of work and/or client proposals
  • Develop and manage vendor relationships
  • Provide oversight support to the design, development and QA teams
  • Client Management: Manage day to day interactions with executive clients and sponsors
  • Provide production support and full solution handover to the client or delivery/application maintenance centers
  • Organize, execute and supervise Hyperion Development Phases and user acceptance tests
  • Expertise in Identify functionality gaps and develop solutions to them
  • Experience in Performance/UAT testing of Hyperion Applications.
  • Experience in the installation/upgrading/implementation of Oracle Hyperion Planning and Financial Management modules.
  • Experience working on IIS, WebSphere, Tomcat and WebLogic servers
  • Comprehensive experience developing scripts using MaxL, ESSCMD and EPM Automate.
  • Created and managed Hyperion users, user groups, and setting their privileges by utilizing Hyperion Essbase Security filters and Shared Services.
  • Improved performance and stability of the Hyperion server by adjusting configuration file and application settings.
  • Used Web analysis to write financial reports with ability to drill-through feature to ERP Systems.
  • Designed and modified Essbase database outlines, dynamic calculations, calculation scripts using the Calc Script Editor, and rules files for dynamic dimension building and data loading.
  • Experienced with Oracle development, Oracle Database administration, and PL/SQL.
  • Proficient in creating financial reports (Forecast vs Budget, Balance Sheet, and P&L Statement)
  • Querying multidimensional databases using the Query Designer.
  • Have used Outline Editor to restructure and modify existing dimensions, dimension members, attribute dimensions and member properties.
  • Responsible for Installing and Configuring IBM WebSphere MQSeries V5.3, V6.0 creating local queues, remote queues, creating channels, listeners and installed client software on AIX, Solaris and Windows Platforms.
  • Experienced in analyzing, designing, reorganizing, and developing with relational databases such as MS SQL server 2005, Oracle 8i, 9i, & 10g and MySQL.
  • Ability to work in a team environment as well as independently.
  • Good experience in full lifecycle implementations and extensive experience in support/Maintenance of production environments.
  • Hands on experience with data integration from multiple data sources to Hyperion Planning and Essbase through Oracle Data Integrator (ODI)
  • Experience setting up WebSphere Global Security for access to the admin console.
  • Excellent oral & written communication and analytical skills.

TECHNICAL SKILLS:

Oracle Hyperion: Hyperion Essbase & Administration Services 11.x,9x,7x/4x, Hyperion Financial Management 11x, 9x, 7x, Hyperion Strategic Financial 11x, Hyperion Planning 11x,9x, 7x, Financial Data Quality Enterprise Edition FDMEE/FDQM, Hyperion Foundation Workspace Shared Services 11x, Data Relationship Management 11x

Oracle Cloud: Oracle Enterprise Planning Budgeting Cloud Services (EPBCS), Oracle Analytical Cloud Services(OAC), Oracle Financial Consolidation & Close Service (FCCS), Oracle Enterprise Reporting Cloud Services (EPRCS), Oracle Fusion Cloud (AR, AP, Inventory, Cash Management Modules)

Databases: Relational Database Management System (RDBMS) databases, Oracle 10g (SQL, PL/SQL, SQL*plus, Oracle Reporting tool), MS SQL server 2005, MS Access and MySQL, Attunity.

Operating Systems: Microsoft Windows NT/2003/XP/2012 Enterprise Edition, Red Hat Linux and Solaris

Testing Tools: Win runner, Load Runner, Quick Test Professional QTP

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Oracle Hyperion Financial Architect

Responsibilities:

  • Implemented Planning Budgeting Cloud Services, Oracle Analytical Cloud & Financial Consolidation & Close Cloud
  • Involved in writing functional specification and Business solution document.
  • Co-ordinated with Key stack holders to finalize design and confirm requirements.
  • Set-up PBCS Environment for New Instance, create planning application and setup reporting cube.
  • Configured SSO Authentication, set-up user/group and assigned security filters
  • Configured Metadata with Dimension Properties and Load Metadata using Data Management Cloud Services
  • Created member formulas and Business rules based on business requirements created two new dimensions to their existing planning application based on Business requirement and re-designed the data load and dimension build using Data Management cloud services
  • Created Direct Integration/ Drill thru to Oracle Fusion GL Ledger balances using Data Management
  • Created Service Requests to Oracle to resolve Bugs
  • Created Integrations between on premise NAS Drive and Cloud Application using EPM Automate Utility
  • Performed daily back-up to archive nightly artifact snapshots from Oracle using EPM Automate Utlity
  • Set-up batch scripts to automate the application back-up process and upgrade scripts for EPM Automate utility
  • Documented detailed design and Integration rules, Import formats as part of Knowledge Transfer.
  • Identified and Co-ordinated with Various teams to Establish and configure the connection between OAC and Datawarehouse
  • Migrated on-premise Essbase Application to Oracle Analytical cloud using command line utility
  • Configured data-base connection between OAC and Data Warehousing and successfully refreshed Essbase outline
  • Remediated Essbase outlines adaptable to New Chart of Accounts.
  • Established Direct Integration between Oracle Fusion and Oracle planning Budgeting cloud Services
  • Configured connection between Account Reconciliation cloud services and Oracle Fusion thru Data Management
  • Created/Modified various reports in Financial Consolidation & Close Cloud.
  • Enabled drill thru feature between PBCS and Oracle Fusion thru Data Management
  • Experience in performing Migration of applications and its artifacts between different Environments using Lifecycle Management Utility (LCM) utility.
  • Experience in Import formats, Data Load Mapping, Data load Rules and integration between ARCS and Oracle Fusion in Data Management Cloud.
  • Worked on Automation of loading source data into Account Reconciliation management (ARCS) and hands-on experience on creation of Profiles and Tasks
  • Identified the Data Loads and Automated using Windows scheduler by creating Batch Scripts, PowerShell & EPM Automate
  • Conducted End User to get familiarize with Cloud Environment Post Implementation.

Confidential, Chesterfield, MO

Oracle Hyperion Financial Architect

Responsibilities:

  • Served as a primary day-to-day technical contact for users in the NA region and provide assistance as required for EMEA and APAC users as required
  • Isolate, debug and correct key systems issues, coordinating with our IT infrastructure partner and / or the application vendor if necessary
  • Collaborate with functional support teams to understand and help document end user requirements
  • Perform technical requirements gathering and analysis, providing time estimates and work plans for required systems changes
  • Perform unit testing and support/coordinate end user acceptance testing activities
  • Manage and prioritize tasks such that they are completed on a timely basis and to user's satisfaction
  • Maintained and Monitored Hyperion applications including Planning, Essbase, HFM, HSF and FDMEE
  • Assist in building financial reports for Senior Management
  • Assist with financial models for budgeting, forecasting and ad hoc analysis in support of the business using information from various ERP Systems and Hyperion Enterprise
  • Automated data loads from SAP ERP System to Hyperion Financial Management using Financial Data Management Enterprise Edition
  • Configured Drill thru capabilities to various Financial Modules like AR, AP, Cash Management, Supply chain Management etc
  • Assist in roll-out of new HFM, FDM Applications, problem fixes, and enhancements of software
  • Managed Metadata for HFM, HSF, Essbase Application
  • Identified the pain points with the existing landscape and proposed new landscape to overcome the pain points and successfully implemented it with a team of Two resource
  • Managed security both at the application level and Shared services level of the applications
  • Responsible for Managing HFM forms and Created new as per Business requirement
  • Enhanced Application performance for HFM Application by changing Application setting as per Oracle recommendations
  • Responsible for Maintaining applications and update dimensions, configure application settings, load data and conversion tables, administer and monitor security, maintain rules and member list files, manage mapping files, develop reports and analytics, perform data extracts and loads, and ensure integrity of backups
  • Configured Single Sign on with site minder
  • Proposed POC for automating the provisioning process which is currently handled manually.
  • Proposed RFP for Integration of HANA with FDMEE with the release of recent FDMEE Patch 11.1.2.4.400
  • Implemented and Provided support for Hyperion Strategic finance, Hyperion Essbase
  • Maintained security across Hyperion Application.
  • Worked with Strategic Finance team in creating data model in HSF and creating template in HSF
  • Created reports tabs in HSF and help business in optimizing the reports
  • Customized security in HSF by creating groups and limiting the access to HSF users.
  • Helped building mapping between HSF and other Hyperion products like HFM and Essbase
  • Designed and Developed Hyperion Financial Management Application
  • Developed financial reports through Financial Reporting Studio
  • Implemented Oracle User Productivity Tool to produce multiple outputs through a single recording session.
  • Written financial reports such as Income Statement and Balance Sheet with the drill-through feature where users can drill-down to journal entry level data
  • Performed documentation on any changes to the Essbase cubes, data files, rules files and calculation scripts based on end-users’ requests.
  • Worked with Financial team to gather business requirements and convert those requirements to design Essbase applications.
  • Restructure components in Essbase cubes in order to optimize overall database performance, calculations, and data retrieval.
  • Designed several pivots, charts, tables and graphs
  • Monitoring the Job and health Check of Report for correct data.
  • Generated Scorecards using System 9 Interactive Reporting Studio
  • Performed Disaster Recovery Drill every quarter in case of any disaster.
  • Created batch scripting to restart the servers at times of Maintenance Window.
  • Worked on Tivoli Scheduling & Event scheduler.

Confidential, NYC, NY

Oracle Hyperion Financial Architect

Responsibilities:

  • Involved in project case study by interacting with the Business users and Data Warehouse Team
  • Member of Hyperion Essbase development team, duties involve creating, redesigning, testing, documenting, reporting, protecting, supporting and administering the full life cycle of multidimensional database development using the Hyperion EPM suite.
  • Dynamically designed database outlines in the Hyperion Essbase platform.
  • Developed and executed calculation scripts and member formulas.
  • Performed automation of the process of adding members to an existing outline using ESSCMD commands.
  • Used Hyperion Reports tool to retrieve data from Hyperion Essbase and present them graphically (charts), also have modified existing reports within Hyperion Reports upon business tactics.
  • Perform backup/ recovery on various database cubes in Hyperion Essbase system.
  • Used Hyperion Analyzer to develop and maintain various traditional and non-traditional financial reports.
  • Adjusted and reconstructed the Essbase database outlines in order to optimize data loading time, database performance, and database size. To reduce calculation time, Intelligent Calculation was utilized. wrote SQL statements to extract data from MS SQL server.
  • Written financial reports such as Income Statement and Balance Sheet with the drill-through feature where users can drill-down to journal entry level data.
  • Substitution variables and UDAs were used for formatting and automating process monthly reports.
  • Formulas and Functions were used to drive data requested by financial team and to give multi-dimensional view.
  • Performed usability evaluation and user acceptances test on all the Hyperion Financial Reports.
  • Dashboards were created to help novice and technologically challenged users to carry out their daily tasks.
  • Proposed a business plan to implement Hyperion System 9BI +
  • Installed Smart View and integrated with Microsoft products (Excel and Word)

Confidential, NYC, NY

Oracle Hyperion Financial Architect

Responsibilities:

  • Involved in implementing the Essbase 9x and Oracle Data Integrator
  • Installation and Configuration of Oracle Data Integrator Server
  • Designed data integration using Oracle Data Integrator (ODI) by setting up sources and targets using ODI Topology Manager, creating Designer models, developing integration interfaces and additional components
  • Used Operator GUI to schedule and automate data load processes through ODI
  • Used ODI to load data into Essbase and Planning from various data source
  • Monitoring the Job and health Check of Report for correct data
  • Created Planning applications using workspace
  • Performed documentation on creating project and models in Topology and interfaces in designer and execution steps in Operator
  • Analyzed business/user requirements to design and develop new Essbase applications.
  • Developed multidimensional database (MDDB) applications using Essbase that stored and maintained company’s private data.
  • Designed and developed cubes using both kind of storage options ASO and BSO.
  • Extensively involved in designing, developing and modifying outlines by grouping and positioning.
  • Developed rules file for building dimensions using different build methods and data loading.
  • Retrieved data using Excel Add-in to analyze cube outline for data integrity.
  • Created and examined all the Standard and Attribute dimensions and members in the outline for the optimization.
  • Designed and developed monthly, quarterly and yearly profit and loss cubes.
  • Involved in installation and up-gradation of Hyperion Essbase family products.
  • Designed and developed number of applications with balance of dense and sparse dimensions arranged in hour glass fashion.
  • Automated Essbase operations by using MaxL and ESSCMD scripts to run period-to-date balance sheets and ledgers.
  • Retrieved data using Excel spread sheet add-in to analyze the data.
  • For generating reports, used Substitution Variables and also created Report Scripts for analysis.
  • Created various filters as per user requirements.
  • Responsible for granting user access based on their specific needs and assigned them to specific groups to provide security for confidential data.
  • Presented detailed analytical reports to the higher administrative people using Hyperion Reports and Analyzer
  • Involved in finalizing the dimensions for cubes along with the analysis of user requirements.
  • Translated user requirements into application design specification
  • Developed SQL and PL/SQL scripts to extract and transform data into the data warehouse system.
  • Extensively involved in designing and modifying outlines for Essbase cubes
  • Responsible for modifying and optimizing the existing outlines
  • Responsible for performance tuning, regular backup and recovery of cubes
  • Responsible for identifying problems, resolutions and documentation
  • Created new users and groups, assigned existing users to those groups and granted access to the users and groups as per their specific needs to access the cubes.
  • Used Filters to control the access of those users and groups to individual data within the database to provide security at the detailed level.

Confidential

Oracle Hyperion Financial Architect

Responsibilities:

  • Mastered high level trouble shooting of all the infrastructural activities related to Hyperion products (Hyperion Essbase, Planning, EAS, Reports, Analyzer, Hyperroll, HAL)
  • Individually handled many outages (planned as well as unplanned) like reboot of all the servers which happens on every third fiscal week, day light savings, os patches etc.
  • Pioneer (in the team) in preparing proper SOP’s for all the Hyperion infrastructural activities (migrations, DR process, access related issues, automations using Appworx)
  • Played a pivotal role in installation and upgradation of Hyperion Essbase, Reports, HAL between different environments for CFA, CAPSOL, CSE business.
  • Handled migration of applications (all data and level 0) between different environments.
  • Played a vital role in resolution of infrastructural issues on server-side before going-live in production.
  • Installed Essbase on Linux, Planning on Windows 2003, Reports on UNIX, Planning Web
  • Automated the backup process for all the applications of all environments using Appworx tool.
  • Took the lead in Disaster Recovery process when all the production servers went down.
  • Trained new Associates joining the team.
  • Hands-On experience in writing queries in database and shell scripts in UNIX.
  • Good hold of UNIX commands and Appworx tool which involves creating and trouble shooting chains.
  • Found out the root cause (RCCA) of application corruption due to signal 11 crash in Essbase 6542 version. Implemented the fix in all the environments (prod, qa and dev). Was involved in coming up with a permanent fix to all the issues, which were repeating.
  • Worked closely with Hyperion Support (USA, Aus and Europe) Analyst’s for unresolved issues faced during troubleshooting Hyperion products.
  • Applying RCCAs (Root cause corrective action) for repeated issues
  • Creation of Applications in System9 environment.
  • Handled migrations (both Essbase and Planning), adding user and groups in System9 environment
  • Involved in documenting all the RCCA’s, RFP's and More
  • Supported more than 30 applications in production both functionally and technically.
  • Involved in setting up users, disk space, servers and prerequisites creations for new Installations.
  • Performed Essbase Upgrades/Migrations from version 6.5.4 to 7.1.5 for all business.
  • Played a key role in the performance testing of planning and closing applications before being deployed to production.
  • Troubleshooting issues during 7 version installation/Application migrations.
  • Involved in Creation, Deletion and Managing of Users and groups and troubleshooting access related issues.

Hire Now