SUMMARY

• 12+ years of diverse experience in Information Technology with 11 + years of experience on OLAP tools.
• Well acquainted with Financial terms as per IFRS standards & good expertise with Excel functions.
• Recommended in building the server for Hyperion Installation and performed the prerequisites setup for new installation.
• Performed Confidential installation and configuration of different Hyperion products.
• Performed patch’s as required per client needs.
• Design the Essbase backup process and automated using the batch script.
• Worked on performance tuning and optimization of Essbase cubes.
• Created multiple SmartView Template using SmartView function and trained users on using the SmartView as an replacement to Essbase Excel Add in.
• Converted Essbase Excel Addin template to Smart View Template
• Extensively worked on Hyperion Financial Management, Hyperion Financial Data Quality Management (FDM), Hyperion Essbase, Hyperion Planning, Hyperion Financial Reporting, Hyperion Interactive Reporting, DRM/MDM, Smart View and ODI (Oracle Data Integrator).
• Analysed & proposed in designing the Application, Database and outline, writing custom Essbase calculations scripts.
• Created transparent, replicated partitions on ASO and BSO applications.
• Designed several Planning webforms for Cash flow, Revenue, Balance sheet templates in order to eliminate Excel Templates.
• Created Business & Calculation rules & sequences for auto - calculation on data submissions.
• Designed Security matrix for Essbase, Planning & HFM applications.
• Performed 24/7 support to production environment & critical UAT phase.
• Prepared RFP (Request for Proposal), Estimation & Responsibility Matrix for Development & Maintenance projects.
• Experience in SDLC that include testing the Application and delivering in UAT (User Acceptance Testing) and migration from development to UAT then to production environment.
• Interpersonal skills with excellent analytical and problem solving and easily cop up with the changing business needs.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in the work environment.

TECHNICAL SKILLS

Data Warehousing Tools: Hyperion Financial Management 9.x/11.x, Hyperion FDM 9.x/11.x, Oracle Essbase 9.x / 11.x, Interactive Reporting 9.x / 11.xOracle Financial Reporting 11.x & 9.x, Hyperion Planning 3.5, Hyperion Planning 9.x, Confidential Planning 11.x, Oracle Data Integrator 10.3.1, Hyperion MDM & DRM 9.3/11.x, HPCM 9.3/11.x

Scripting Languages: ESSCMD, MAXL, Shell Scripting, Batch Scripting.

Databases: MS-Access, Oracle 9i/10g/11g, SQL Server 2005.

PROFESSIONAL EXPERIENCE

Confidential

Oracle EPM Consultant

Responsibilities:

• Understanding the client's business needs and assisting them to fit those need in Hyperion
• Develop and maintain detailed project schedules and responsible for requirement collection, design, development and testing of software projects in the environment
• Financial modeling and valuation, advanced excel with pivot tables, v lookups and regression analysis, financial statement analysis.
• Analyzing the customer's requirements for Development, Modification, Enhancement of existing Reports and Application.
• Work on various interfaces for downstream application (JAAMS, PRISM & Oracle Database tables)
• Having good knowledge of interfacing with Finance modules such as Accounts payable (AP), Accounts Receivable (AR) and General Ledger (GL) with the Sales & Distribution
• Provided expert data design and consulting for integration with data management systems
• Provided support with timely and accurate accounting, financial reporting, general ledger activity, and monthly close process for assigned business units.
• Recommended in building the server and performed setup with prerequisites for Hyperion installation.
• Performed Installation and configuration of Hyperion Environment in distributed architecture for Development, Test and Production instance.
• Design the architecture for Hyperion installation in distributed environment.
• Performed frequent migration from development to test to production.
• Develop blue print and finalize the design.
• Develop Hyperion Planning data-forms to replace excel spreadsheet
• Developed rule files to load the actual data into Essbase & planning application.
• Develop calculation scripts and Calculation rules.
• Loaded the data using ERPi adapter to Hyperion Planning and performed drilled back to the source EBS
• Automate the CBJ and OMB submission document using Smart View Functions.
• Develop Test Scripts for Business Users.
• Managed Planning hierarchies using Outline Load Utility.
• Trained End users in accessing the Web forms.
• Build key reports using Hyperion Financial reporting.
• As Proof of concept, I have created an application on PBCS and moving artifacts from on-prem to cloud and performing testing
• Created Hyperion planning dataforms in PBCS
• Created SmartList and used to PBCS Smart Push to push the data into ASO appilication
• Created Valid intersection and performed selection using valid intersection in PBCS

Oracle EPM Consultant

Confidential

Responsibilities:

• Prepared Security matrix and Maintained security model for users in HFM and did provisioning in Shared services
• Performed maintenance to accounts and entities hierarchies during the month end close
• Maintained Security and supported the HFM users during month end close
• Validated and Imported data into HFM from FDM
• Ran and review FDM validation reports and investigated differences.
• Consolidated to top level of Legal hierarchy during data loads, after Journal loading and Reclass.
• Supported monthly end close and ledger adjustment postings and maintenance of New accounts and Entity changes. Did division, legal and market segment mappings
• Metadata, Member lists, Data, Final load files and HFM format, Journals, Rules and Reports Security
• Worked on change requests to make changes to Balance sheet and IS and cash flow reports and maintained the security for HFM reports in Work Space.
• Maintained the Reports like Income Statements, Balance Sheets, Consolidated Package, GL Trial Balance TieOut, and Cash Flows.
• Troubleshoot, restore and backup the HFM application in Test and prod and dev environments during failure. Start and stop procedures of HFM server, Clusters, Workspace, Shared services and FDM server.
• Maintained data forms and data grids.
• Prepared SOX Compliance reports.

Oracle EPM Consultant

Confidential

Responsibilities:

• Interacted with FP&A, Controllership and Regulatory teams to understand the requirement and finalize the Business critical requirements for project.
• Developed POC to demonstrate & agree upon the design.
• Documented the design approach and finalized the requirement to kick off the build phase.
• Coordinated with the Business, Client for various stages of project.
• Design and development of Hyperion Planning & Essbase application.
• Converted the BSO Hyperroll application to supported ASO application.
• Developed rule files to load the actual data into Essbase & planning application.
• Designed the process for the data movement to downstream applications.
• Revamped the data gathering schedules to meet federal standards.
• Frequently discussed with FP&A teams for conversions of their data gathering excel templates to centralized Hyperion Planning data forms.
• Worked closely with FP&A and controllership teams in identifying the “Un-used” hierarchies and deleted those unwanted hierarchies to provide better Essbase application.
• Managed Planning hierarchies using ODI (Oracle Data Integrator).
• Created users and user groups in HSS for planning applications and assigned security to web forms.
• Trained End users in accessing the Web forms.
• Resolved issues during the UAT.
• Documented each & every stage of project and provide the required transition to the support team for maintenance.
• Developed the Hyperion Planning Model to simply the data collections during the FP&A planning session.
• Build key reports using Hyperion Financial reporting.
• Created Accounts, Entities & Types hierarchies in DRM.
• Creating properties, Property Category as per the requirement.
• Creating imports for one time build in DRM. Further, Creating Heirarchies and version from the import file from stage Area.
• Creating standard exports and automating the process of export generation and transferring it to target systems.
• Development of Automators, import, Blend, exports, system & property categories in Hyperion DRM (Data Relationship Management)
• Designed Validation & verification rules in DRM to auto-validated checks.
• Automated the hierarchy build, data loads and execution of calculation scripts using the Maxl scripting.
• Automated the data submission between Confidential Capital applications avoiding the manual submission during the Q’close and FP&A planning sessions