PROFESSIONAL SUMMARY:

• Having around 12+ yearsof experience in Hyperion Essbase, Planning, Smart View, Financial Management, Financial Reporting (HFM & HFR),Financial Data Management Enterprise Edition(FDMEE),ODI and understanding of OneStream.
• Skilled in analyzing needs and developing solutions to support the requirements of a diverse. Customer base. A productive team player, focused on creating outcomes that lead to quality, customer satisfaction, and profitable results.
• Worked on optimization and simplification of Essbase projects to increase the efficiency and reducing the throughput
• Strong expertise and worked on various Hyperion Tools like Essbase (BSO & ASO), Planning, Financial Reporting, Smart view, Oracle Data Integrator (ODI) associated with the client GE Baker Capital as an Oracle EPM Consultant
• Conceptual knowledge of Data Warehouse Working experience on Business Intelligence practices and OLAP Tool.
• Exposure to Financial Planning & Analysis and supported planning cycles for GE Capital Applications
• Excellent working experience in developing and maintaining BI solutions using Hyperion Financial Management and Reporting.
• Strong working background in creating and deploying financial consolidation and analysis using Hyperion System Financial Management and Reporting solutions.
• Trained and very good understanding of OneStream \CPM functionality
• Exposure to OneStream concepts like oneplace, application, administration
• Have good knowledge of new OneStream features like cube extensibility, dimension library, workflow and dashboards
• Excellent problem - solving skills with a technical background and good interpersonal skills.
• Knowledge in Tuning, Optimization of cubes, MaxL, Batch scripts and complex calc scripts
• Involved in project proposals, RFP, WBS, Costing and resource alignment
• Good understanding with Consolidation process (Balance Statement, Income Statement, Cash Flow Statement, Rollforwards, CTA), rolling forecast
• Trained associates in Essbase, Planning and conducted various technical sessions

TECHNICAL SKILLS:

OLAP Tool\BI Tools: Hyperion Financial Management, FCCS, PBCS/EPBCSEssbase 9.3.1/11.1.1.3/11.1.2 . 4. EIS StudioHyperion Planning 9.3.1/11.1.1.3/11.1.2 . xOracle Data Integrator (ODI),FDMEE, DRMHyperion Shared Services 9.3.1/11.1.2. xSmart View 9.3.1/11.1.1.3/11.1.2 . x

Reporting Tools: Hyperion Financial Reporting 9.3.1/11.1.1.3/11.1.2, Profix

RDBMS: Oracle, MySQL and PL/ SQL

PROFESSIONAL EXPERIENCE:

Confidential

System Specialist

Responsibilities:

• Monthly metadata updates in EPMA and COA deployments in stage and production environments
• Coordinating with FDG committee and business users on new hierarchy requests
• Supporting and monitoring of Essbase, planning, HFM,HFR and ODI tools
• Monthly system prep for forecast and outlook cycles, seeding process and Finalization working on new automations and optimizations as required
• Creating/updating the different type of HFR Reports based on requirement
• Drill through reporting support using Essbase integration studio
• Working and coordinating with global support team and handover of activities
• Having complete ownership of daily and monthly close activities
• Proactive communications for business approvals and chatter posts for downtime and outages
• Working and coordinating with scrum and product teams on upcoming releases and accordingly setting up the stage environment for UAT’s
• Taking care of monthly pathing activity and coordinating with different database, infrastructure and application teams across business technology.
• Coordinating with different business stakeholders on monthly data loads, validations and processing the files to different cubes.
• Working and updating essbasecalculation scripts for new allocation, head count related requests
• Complete security and provisioning management of all the Hyperion applications through support forcerequest
• Generating quarterly user access QAR reports, SOP and working with application owners and compliance team audit reviews and SOX controls
• E2E scheduling, system monitoring creating and updating SOP for existing and new processes

Confidential

Onsite Lead

Responsibilities:

• Develop/Modify HFM Rules Sub-routines, calculation, currency translation, intercompany elimination and consolidating the data
• Creating and updating data web data forms, grids for budget, forecast and commentary,
• Work with multiple downstream system OBIEE, ARM and Data Lake owners to ensure data flows from Hyperion into their respective systems without any issues
• Created multiple Hierarchical Rollups for both Entities and Accounts based on business requirement
• Creating/updating the different type of HFR Reports like Beg Bal EC, DR13, IBS, OOB, TB with Elim, Intercompany, USDRQ and Mars
• Generating user specific reports using the SQL based on HFM EA extract
• 1/1 rollover process and data validation par of year end close
• Setting up locations in FDMEE to accommodate new Coco’s and security provisioning to loaders/mappers. Importing, validating and exporting to the target applications.
• Initializing and setting up of ERP sub ledger within FDMEE and enabling entity group for new ledgers
• Creating task list for data forms and data grids to restrict the users based on the assigned access and Journal
• User Interface development to facilitate end users in getting transformed Enterprise standard COA for given local ERP. This includes coding to transform local CoA to ES CoA for multiple ERPs which includes EBS, CCL, Fusion
• Developed drill through invoice, cash applied, days to collect report in EIS Essbase ASO cube setting up of new Automic Jobs for HFM, FDMEE and ODI data loads, consolidations, EA extracts and generating financial reports.
• Build APIs to facilitate easy access of data to business users.
• Metadata setup for data transformation in DRM. Data from local ERPs along with the transformed mappings are loaded to HFM through FDMEE for reporting purpose.
• Updating and enhancing the HFM rules based on the new requirement
• Creating event and custom script using Jython scripting for validation and data load.
• Develop/ Modify /Automate scripts for loading data and Metadata
• Working with external audit team and generating required reports for data reconciliation
• Quarterly user on FDMEE/HFM/SmartView functionality

Confidential

Onsite Lead

Responsibilities:

• Meta data imports to EPM environment from Dev, Stage and Prod interfaces
• Creating import profiles and dimension mapping between interfaces and EPM and executing the profiles
• Metadata validations, EPM to classic application Deployments and post validations
• Clearing invalid records
• Implementing the new HFM rule release from ESHFM, validating edit checks, control balances, Rollfowards and cashflow balances.
• Creating task list for data forms and data grids to restrict the users based on the assigned access and Journal templates modules to post the MJE’S and LJE’S during the LCD cutoff
• Working with support central user request during the month and Quarter close and supporting the business thus by meeting the SLA.
• HFM data load through FDMEE using the ODI from ERP Source Systems,
• Updating new FDMEE mappings monthly to support Month end close process.
• User Interface development to facilitate end users in getting transformed Enterprise standard COA for given local ERP. This includes coding to transform local CoA to ES CoA for multiple ERPs which includes PASCAL, CCL, OGL &
• Creating new Automic Jobs for HFM, FDMEE and ODI data loads, consolidations, EA extracts and generating financial reports.
• Coding Forward & Reverse mappings includes considering multiple scenarios like many to one mapping, Primary & Stat Ledger code setup for Company, Mapping of new ES CoA members to default if they do not exist in local CoA
• Work on the new interface design of R2R implementation which enables users to get the Enterprise standard Chart of Accounts for the local ERP Chart of Accounts.
• This includes extensive coding to fetch information from multiple legacy and local ERP CoA which includes PASCAL, CCL, OGL, Fusion and legacy transform them to ES CoA by executing sequence of processes. This interface enables users to fetch ES CoA mappings for individual segment as for the concatenated segments.
• Metadata setup for data transformation in DRM. Data from local ERPs along with the transformed mappings are loaded to HFM through FDMEE for reporting purpose.
• Develop code for Translations, Roll forwards, Eliminations as per business requirement.
• Set up FDMEE to ODI adapters for data loading. Create Jython scripts for data load.
• Develop/ Modify /Automate scripts for loading data and Metadata

Confidential

Onsite Lead

Responsibilities:

• Meeting with Clients on a regular basis on new requirement\projects
• Setting up the BP1, BP2, stress test and end year planning sessions
• Taking up new enhancements during the Q close
• Hyperion related to users, whenever necessary.
• Setting up the environment for publishing the GAP\MOR rates
• Delegating and closely working with off-shore teams.
• Monitoring of Automated Jobs.
• Supporting users during Month Close and financial closes.
• Activities related to Forecasting and Budgeting per user instructions.

Confidential

Consultant/Onsite Lead

Responsibilities:

• Understanding the Business Requirement Documents and come up with Technical Design.
• Designing and Building of the ASO cube. Recasting the Historical data and validations with the Existing
• Finalizing the ASO cube Hierarchies and send it to DRM team for building the Hierarchies.
• Resolving data mismatch issues.
• Building a reporting cube which pulls the data from ASO and planning cube and setting up transparent
• Parallel working on the design and build of Consolidation cube in Hyperion Planning.
• Creating webforms and creating complex calculation scripts.
• Attending daily call with business on updating the project status and also the call with the Client IT Team
• End user support during Finance Forecasting phases in corporate for smooth turn around.
• Performed Dynamic Dimension Building and Data Loading using Rules Files.
• Created Excel-sheet reports for clients through Essbase Excel Add-In & Smart View.
• Optimize Essbase application and database process.
• Created and Optimized Planning Cubes and involved in the full life cycle.
• Created and maintained data forms in Hyperion Planning 11.1.2
• Creating and editing corporate Business Rules/Calc scripts using AAS in Hyperion System 11.1.2
• Created and executed data loads.
• Assisted end-users through direct communication
• Security Maintenance and updates using Shared Services in system 11.1.2
• Maintenance and security filtering on data forms in Hyperion Planning
• Creation and maintenance of data forms in Hyperion Planning.
• Modifying and editing the outline using (Analytic Administrative Services) 11.1.2
• Attaching Business Rules to Data Forms and performing Tests to ensure proper execution of Business Rules
• Performed regular Data retrieval tasks to test data load and aggregation.
• Metadata Changes and updates in the outline and planning.Involved in implementation, testing, production rollout, documentation, and on-going

Confidential

Hyperion Functional Support

Responsibilities:

• Created free form reports by using Essbase Data Source
• Developed Estimate reports for components for different accounts and Scenarios
• Ad hoc retrieval options for zoom in and out retrieving data from application for different POV using POV manager created different types of summary reports based on requirement connecting to application using connection manager format members and data cells