SUMMARY:

• Industry savvy professional with 11+ years of experience which includes experience in Analysis, Design, Development and Testing of applications using Oracle Hyperion Planning, Essbase, Hyperion Financial Reporting, Oracle PBCS, DRM and FDM
• Extensive hands on technical experience as a Technical Architect / Hyperion Developer / Administrator / Project Lead
• Experience in Project Management & Execution, Implementation and Transitioning of large complex projects across domains and geographies
• Expert in Hyperion Financial Reporting and Worked on complex Financial reporting requirements
• Experience in developing both ASO and BSO Applications
• Experience in Hyperion Financial Reporting, Hyperion Web Analysis, Smart View and Spreadsheet Add - In.
• Strong experience in developing Web forms and Business Rules.
• Experience in various Hyperion Essbase related activities which include Dimension Building, Data Loading, writing Calc Scripts, Report Scripts, writing formulas, consolidation and Optimization.
• Worked Extensively on Performance tuning and Optimization, MaxL scripts
• Involved in software upgradation and migration of cubes/artifacts from one environment to another environment
• Involved in data loads to Hyperion systems using FDM
• Experience in metadata maintenance using DRM
• Experience in Data validation and Analyzing/Resolving Data variance between various systems
• Worked extensively on Hyperion Security
• Experience in using ETL Tool- SSIS.
• Experience in Batch scripting, UNIX Shell scripting, SQL, Software Installation, system upgrade and server maintenance, application and data back-ups and security.
• Experience in production supporting activities

TECHNICAL SKILLS:

OLAP:: Oracle Hyperion Planning 11.1.2.4, Oracle Hyperion Essbase 11.1.2.4, Hyperion Financial Reporting, Oracle PBCS, DRM, FDM, SQL, SSIS, Oracle UPK, Hyperion Web Analysis

RDBMS: MS SQL Server, Oracle

Operating Systems: UNIX, Windows

Tools: MS - Project

PROFESSIONAL EXPERIENCE:

Confidential

Technical Architect

Responsibilities:

• Led Solution design and delivery of Quarterly enhancements
• Develop/Modify various artefacts including Web forms, Calculation scripts & Business rules
• Provided recommendations to optimize the cube performance and creating innovative Data extraction mechanisms
• Managed Migration of Hyperion applications from 11.1.2.2 to 11.1.2.4 and troubleshooting issues
• Responsible for Detailed Planning, Effort Estimation and Execution of the activities as per the project timelines.
• Analyzing/Resolving Data variance and Data validation
• Risk management and Mitigation
• Resolve support /operational issues by coordinating between Offshore and Onsite support teams.

Environment:: Hyperion Essbase 11.1.2.2/11.1.2.4, People Soft, Microsoft SQL Server, SSIS, Essbase Studio, OBIEE, Control-M, Smart view, HP Service Now.

Sr Hyperion Consultant

Responsibilities:

• Led/Managed the application maintenance and delivery of enhancements for Payroll Planning application
• Developed complex financial reports using Hyperion Financial Reporting Studio
• Develop/Modify various artefacts including Outline(EPMA), Web forms, Calculation scripts & Business rules
• Responsible for Release-2 and Release-3 enhancements
• Implemented Test and QA strategies and created Deployment plans
• Involved in Month/Period end Close activities
• Processing of Payroll loads into Hyperion systems and resolving Data variance issues.

Environment:: Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, Hyperion Financial Reports, ODI, Smart View, Oracle E-Business Suite

Project Lead

Responsibilities:

• Involved in Build and Test efforts of P&L, Balance Sheet cubes
• Developed various artefacts which include Outline, Webforms, Business rules, Test plans and Test scripts
• Performance tuning of Hyperion application
• Designed Security matrix and implemented Security
• Developed Financial reports using Hyperion Financial reporting studio
• Unit Testing/validation of Business rules

Environment:: Oracle PBCS, FDM, Hyperion Financial Reports, Smart View

Senior Consultant

Responsibilities:

• Led the Design, Build, and Test efforts of P&L, Balance Sheet and Cash flow cubes
• Formulated the best fit solution based on the current and projected requirements
• Developed various artefacts which include Outline, Webforms, Business rules, Tasklists, Test plans and Test scripts
• Troubleshooting and resolving Data variance issues.
• UAT lead for Hyperion Planning Implementation.

Environment:: Hyperion Planning 11.1.2.3, Hyperion Essbase 11.1.2.3, EBSGL, Smart View

Project lead/Migration lead

Responsibilities:

• Led the Design, Build, and Test efforts of Essbase cube (Dimensional Profitability)
• Designed and developed calculation scripts for the currency conversion module
• Involved in design, build, and test efforts of Hyperion Financial Reporting solution
• Ensured technical feasibility of the work products
• Managed the Migration/Testing of Hyperion Planning /Essbase applications from 11.1.1.3 to 11.1.2.3
• High level project planning, estimates and identification of key milestones

Environment:: Hyperion Planning 11.1.2.3, Hyperion Essbase 11.1.2.3, Hyperion Financial Reports, FDQM, HFM, Smart View

Senior Hyperion Consultant / Data migration lead

Responsibilities:

• Data migration lead / Hyperion Consultant for Wave-2 and Wave-3 Oracle Hyperion Planning implementations
• Performance tuning of Planning/Essbase applications
• Resolving data variance issues between Hyperion applications and various Legacy systems
• Hypercare SPOC for Wave-3 Hyperion Planning implementation
• Involved in design and development of metadata and hierarchy management using DRM
• Created the hierarchies/versions using Oracle DRM
• Stakeholder management/ High level project planning
• UAT lead for Wave-3 Hyperion Planning implementation

Environment:: Hyperion Planning 11.1.2.1, Hyperion Essbase 11.1.2.1, Oracle Database 11g R2, Smart View, FDM, DRM, HFM, HPQC

Senior Consultant

Responsibilities:

• Analyzed the current financial Planning, Budgeting & Forecasting process
• Analyzed the business functionality of existing applications and infrastructure
• Identified potential system and process solutions
• Provided recommendations which targeted at improving efficiency and effectiveness of the budgeting process.
• Reducing the process cycle time for budgeting

Environment: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Smart View, Hyperion Financial Reports

Project Lead

Responsibilities:

• Successfully led a team of about 11 people during knowledge transfer and helped the project move to a steady state.
• Created Calculation scripts and Business rules for enhancements.
• Provided recommendations to optimize the cube performance
• Analyzed the new business requirements, Existing applications/infrastructure and develop proof of concept for enhancements.
• Stakeholder management/ Incident resolution/ Defect prevention

Environment:: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Smart View, FDM

Hyperion Consultant

Responsibilities:

• Solution design and development of 3 Hyperion applications P&L, Product Gross Margin and Sales forecast.
• Analyzed new requirements and developed proof of concept for enhancements
• Using DRM for metadata maintenance.
• Led/Managed Release-2 enhancements
• Played a key role in various project management activities

Environment:: Hyperion Planning 11.1.1.3, Hyperion Essbase 11.1.1.3, Smart View, Hyperion DRM

Hyperion Consultant

Responsibilities:

• Led the design, build, and test efforts of the Hyperion Financial Reporting Solution
• Developed standardized, web-enabled and excel compatible repository of pixel-perfect reports which allowed efficient and timely distribution of the latest forecast and plan data in pre-defined views.
• Defined security requirements and setup security

Hyperion Consultant

Responsibilities:

• Mentored in-house project team and helped the project move to steady state
• Led/Managed the application maintenance and solution delivery of enhancements for 4 lines of Business.
• Develop/Modify various artefacts including Outline, Web forms, Calculation scripts & Business rules
• Resolved support / operational issues by coordinating between client, onshore and offshore technical support teams.

Environment:: Hyperion Planning 9.3.0, Hyperion Essbase 9.3.0

Hyperion Consultant

Responsibilities:

• Analyzed the current financial Planning, Budgeting & Forecasting process
• Analyzed the business requirements, existing applications and infrastructure
• Conduct Gap/Fit Analysis
• Developed Action plans and built Outline, Web forms, calculation scripts based on Action plans
• Developed Test scripts, Test cases and Test execution reports.

Environment:: Hyperion Planning 9.3.1, Hyperion Essbase 9.3.1

Learning & Knowledge Lead

Responsibilities:

• Identified Business requirements for Education development, Education delivery, Assessment, Sharenet, Asset reuse, Community building
• Advised and guided FMS Leadership on successfully accessing L&K funding and assistance.
• Maintained a close working relationship with Global and Geo counterparts to ensure adoption of best practices within FMS GD India

Hyperion Consultant

Responsibilities:

• Analyzed the business requirements and Conducted Gap/Fit Analysis
• Designed, Developed and Modified the Outline according to business requirements
• Developed Calc Scripts, Load rules for building the dimensions and loading the data
• Involved in the SIT and UAT of the system, data validations with the operations team to ensure correctness of the reports generated

Environment:: Hyperion Essbase 7.1.6

Hyperion Framework Analyst

Responsibilities:

• Created a baseline Work break down structure, phases, activities, tasks for each module
• Created Technique papers, sign-off templates for each phase, accelerators and sample deliverables
• Created a snapshot in Knowledge view/Practitioners’ portal

Financial Management Consultant

Responsibilities:

• Gathered banking metrics, identified their purpose, sources, Position of the Stakeholder interested in the metric
• Mapped high-level business process with the metric
• Identified value drivers of the metrics and catalogued them