SUMMARY:

• Over 7 years of diverse experience in designing, testing, implementing, and managing Planning/Budgeting/ Forecasting, and Reporting application using Hyperion Planning/Essbase/FRS, DRM, and ODI tools.
• Strong analytical and business operations skills.
• Expert in building budgeting, forecasting and reporting solutions in Hyperion Planning/Essbase/FRS applications.
• Proficient in using ODI, FDM, FDMEE, and DRM for managing data and Metadata from various resources.
• Accurate, precise and highly ethical - able to immediately contribute to corporate financial goals and objectives
• Fast learner with high energy and drive to exceed expectations.

TECHNICAL SKILLS:

OLAP Development Tools: Hyperion Planning, Hyperion Shared Services, Hyperion Workspace

Reporting Tools: Hyperion Financial Reporting Studio, Smart View, Excel Add-In, MS- Excel

Metadata Management Tool: Hyperion EPMA, Oracle DRM

ETL Tools: ODI, FDMEE

Databases: SQL Server, Oracle, Hyperion Essbase, MS-Access

WORK EXPERIENCE:

Senior Hyperion Developer

Confidential

Responsibilities:

• Created Planning Applications for budgeting/forecasting financials and Workforce
• Performed metadata/artifacts migration between environments using Life Cycle Management utility
• Created and deployed Business Rules for Planning applications
• Provided security for Planning/Essbase applications, and created users and group profiles for assigning proper privileges
• Developed Multi-Dimensional ASO/BSO applications using Essbase
• Loaded Metadata and Data into Essbase applications using rule files
• Created MaxL and batch scripts to automate the movement of metadata and data.
• Created rule files to build outline and load dimensions in Essbase.
• Created new calculation scripts for data manipulation, and updated existing Calc scripts to add new functionalities.
• Involved in upgrading and migrating Hyperion Planning/Essbase application and Financial Reporting Studio reports from EPMA 11.1.2 to EPMA 11.1.2.4
• Developed easily understandable technical documents for change migration team
• Monitored and resolved nightly INTG, QA, and Production batch issues.
• Migrated data/metadata/artifacts between environments for monthly/quarterly/annually consolidation, and report generation per business need
• Provided expertise in Hyperion Planning/Essbase related to outlines, calculations, load rules, Web Forms, Smart View, Security, and application validation
• Tested and validated data movement using SmartView, and documented the findings
• Responsible for monitoring performance, security, and backup and recovery of the cube
• Designed and managed new hierarchies in DRM for new and existing planning applications
• Created versions in DRM with different hierarchies to blend data
• Created Properties, Property Definitions and Property Categories per business requirement
• Converted ADS files and import metadata from ADS file into DRM
• Utilized DRM migration modules in exporting/Importing data
• Managed User, User groups, and objects security using DRM internal ability and external authentication

Hyperion Consultant

Confidential

Responsibilities:

• Prepared ETL approach design document.
• Utilized Oracle data integrator for extracting, transforming, and loading data to EPMA.
• Created Master/Work repositories, Physical/Logical schemas, Agents, and Context for various systems into ODI Topology Manager.
• Created SQL scripts to retrieve employee data from database tables and views.
• Created SQL scripts for data manipulation and validation.
• Created interfaces, packages and scenarios to load Metadata in EPMA shared library and data in Hyperion Essbase cubes.
• Setup FDMEE to load data, and created source and target applications, import formats, data load rules, and dimension mappings.

Hyperion Consultant

Confidential

Responsibilities:

• Collaborated with the Finance team in creating Planning Application for planning/bugeting process
• Developed enhancements to the current application, including setup of new custom dimensions to capture additional information to improve business analysis and reporting
• Provisioned new users to respective groups to provide appropriate access to Hyperion Planning and Essbase applications.
• Migrated planning application artifacts from Dev to QA and finaly to Production environment using LCM.
• Developed Web Forms for planners to enter budget/forecast data.
• Created and deployed Business rules for allocation and planning/budgeting calculation.
• Developed load rules to build dimensions and load data into Essbase databases
• Increased performance of Essbase application by optimizing outline and calculation scipts
• Involved in database and security refreshes in Hyperion Planning.
• Performed testing by creating testing strategy documents and test scripts for new versions of the application
• Created admin guide to document maintenance procedures.
• Addressed issues related to data and metadata enhancements, and assisted business users in performing ad-hoc analysis and data validation using Smart View

Hyperion Administrator/ Consultant

Confidential

Responsibilities:

• Established system user-roles and security, including access, provisioning, and system maintenance
• Performed system administrator tasks such as month-end closed procedures
• Created and maintained financial reports in Hyperion Financial Reporting Studio
• Created Reports with Multiple Database Connections.
• Used Conditional Suppression functionality to suppress the rows/columns to display dynamically based on Prompts, User POV & grid POV.
• Developed weekly, monthly forecast, budget and quarterly year to date (YTD) reports
• Created Books from financial reports.
• Created templates to standardize reporting
• Assisted financial users in using Smart view Excel-Add in to view data, and the basic concepts of drill down into multidimensional database.
• Maintained and updated metadata in all Essbase applications.
• Ran testing sessions by creating testing strategy documents and test scripts for new versions of the application.
• Maintained substitution variables, and ran ad-hoc aggregations.
• Created new member formulas in Essbase for variance analysis and updated existing formulas according to the financial user needs.
• Extracted and loaded data into databases and ran aggregations.
• Migrated applications between environments using LCM

Hyperion Financial Analyst

Confidential

Responsibilities:

• Provided periodic and ad hoc reporting by understanding financial and Textile industry metrics and reporting methodology.
• Performed month-end closing functions.
• Assisted Finance department in replacing an aging Excel based reporting system with Hyperion Essbase and Financial Reporting system
• Served as liaison between Acounting, Finance and IT department to improve financial reporting.
• Created new and modified existing Trend and Varience reports to meet business needs.
• Created standards templates for report to miantain consistency across the organization
• Assisted Corporate Controller with maintaining the global Chart of Account.
• Analyzed reports to ensure financial information has been recorded accurately.
• Managed system change requests and metadata maintenance
• Provided functional support for user acceptance and performance testing
• Ran testing sessions by creating testing strategy documents and test scripts for new versions of the application