SUMMARY:

• Hyperion Technical consultant with more than 14 years of experience in design, analysis, development and implementation of various applications in Client Server environment using Hyperion DRM, Essbase, Hyperion Planning, Financial Management (HFM), FDM, EAS, EIS, ODI, DIM, ESSCMD, MaxL, Hyperion Analyzer, Hyperion Financial Reporting, Web Analysis, Essbase Excel Add - in and Smart view under Windows and UNIX environment.
• 13+ years of hands-on Hyperion implementation experience in various industries including Financial Services, Career and Recruitment Data management, Telecommunication.
• Experience in Creation of Version and Hierarchies for chart of Accounts, Legal Entities, Cost Centers, and Management Entities Import/Blending and Automator.
• Participated to Automate the I/O processes using MDM connect, Autosys.
• Experience in creating business rules, manipulating and maintaining calculation scripts.
• Expertise knowledge in Memory analysis, cache tuning, Configuration settings tuning, Performance tuning, Optimization, Dense Sparse settings, partitioning, etc
• Experience in process automation using MaxL, ESSCMD, and Batch and UNIX scripts.
• Experience in optimization of Dimension building and Data loading
• Worked in various environments of Development, Production-Support and Maintenance projects with excellent result-oriented approach.
• Worked on Database Optimization, Database Partitioning, Database Backups, performance tuning of Essbase application Data Metadata processing, upgrading, testing and migrating of cubes in different environments.
• Expertise in building Financial Budgeting and Forecasting OLAP applications with ESSBASE and Planning.
• Extensive exposure to Hyperion Planning, web forms, business rules, Hyperion Financial Reports, Analyzer Web analysis
• Experience in creating collaterals for client data validation and using Essbase Excel add-in Hyperion Smart View.
• Excellent technical and communication skills coupled with firm commitment to quality and team spirit.
• Excellent accounting proficiency, problem solving skills and efficient in time management.
• Experience in providing support and maintenance for Hyperion DRM, Planning and Hyperion Essbase Systems including both client server level services and consulting.
• Familiar with Hyperion infrastructure maintenance activities.
• Experience leading teams from onsite and offshore.

TECHNICAL SKILLS:

OLAP and Hyperion Tools: Hyperion Essbase 9.x, 11x, Hyperion Planning 9x, 11.x, Hyperion Financial Reporting 9x, 11.x, Oracle Data Relationship Management (DRM), Financial Data Quality Management Enterprise Edition(FDMEE), Workspace, Shared Services, EPMA, Smart view

ELT/ETL: Oracle Data Integrator (ODI)

Operating Systems: Windows, Unix

Scripting Languages: MAXL, MDX, Batch, Shell Scripting

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Township, MI

Hyperion Lead Systems Analyst

Responsibilities:

• Designed and managed applications using Hyperion System 11x. Involved in installation and upgrading the Hyperion Planning, Essbase and Hyperion Reports.
• Implemented Hyperion Planning and multiple Essbase BSO and ASO cubes. Created complicated allocation process through partitions and xrefs in BSO and reports from ASO cubes.
• Worked on planning applications like Revenue, Budget, Consol and Analysis also called Financial Planning and Analytics (FP&A).
• Worked on Hyperion Application Link (HAL) routines to load data from PeopleSoft to Planning. HAL routines included metadata refresh, translation of metadata.
• Created Hyperion Business Rules (HBR), Calc Scripts, Report Scripts, Security for HBR’s—Global Security Filters and Web forms.
• Developed the reporting framework using for wide range of users as per the requirements using Excel Add-In Templates, Hyperion Reports and Hyperion Performance.
• Created working capital reports by looking at existing excel reports using Hyperion Financial Reporting Studio.
• Developed a Multi-Dimensional Database (MDDB) application using Hyperion Essbase that stored and maintained company's financial and marketing data and performed the loading and manipulation of data into the database using Build and Load Rules files.
• Administered Security, User creation with Native and External authentication, Filters, Dimensional level Security, Groups and assign the proper privileges.
• Used attribute dimensions to retrieve and analyze data in terms of characteristics of dimensions.
• Developed and maintained Calc Scripts for performing calculations and developed member formulas for dynamic calculations and SignFlip.
• Automated Hyperion Essbase Cubes to minimize manual entry through Batch File using ESSCMD/MaxL Scripts. Removed errors occurring during the nightly dimension build and data load processes by referring to Log files.
• Involved in Performance Tuning to minimize data load time using the Dense/Sparse settings, responsible for performance monitoring, backup and recovery of the cubes and also implemented various troubleshooting procedures to recover databases.
• Created linked and transparent partitions between source and target cubes.
• Interacted with the users to gather report requirements and there upon designed reports and also involved in troubleshooting the user issues with the Essbase Excel add-in.
• Provided daily back-ups of Essbase Database and Relational Database Reports, regular performance maintenance operations like eliminating fragmentation, disc and memory

Environment: Hyperion Essbase 11.x, Planning 11.x, HFM, Hyperion Financial Reports, SmartView 11.x,ODI

Senior Hyperion Developer

Responsibilities:

• Involved in Aggregate Storage (ASO) and Block Storage BSO) Cube development and maintenance
• Responsible for creating and modifying Essbase load rules, complex calculation scripts, report scripts, outline formulas, and MDX formulas for new requirements
• Optimization, performance tuning and maintenance of Hyperion Essbase, Planning and Finance applications
• Wrote number of Business Rules for Benefits application
• Responsible for creating partitions to improve performance
• Developed various MaxL and Shell Scripts to automate data loads and partitions
• Created Essbase outlines based on report specifications and schema delivered
• Performed member and data loads in Essbase Integration Services
• Created numerous reports in Financial Reporting Studio on Income Statement, Statistics, Net Revenue, Net Income and Expenses to calculate Budget and Actual: Summary and Detailed reports, Monthly and Quarterly reports, Consolidating and combined reports
• Extensively worked with Excel Add-In, Smart View, Hyperion Workspace, Hyperion Reports and Hyperion Analyzer

DRM Developer

Responsibilities:

• Identifications of Master Data values, Data Sources, Target Systems and Hierarchical Structures/Segments required to be maintained in DRM.
• Enforced versioning of metadata for all hierarchies of the businesses to enable comparative reporting and analysis for every reporting period.
• Set in place quarterly back-up process for the version.
• Formalized processes to control the entry, approval, validation, and commitment of master data changes to nodes, relationships, and property values using governance workflows in DRG. Build and retained consistence of enterprise chart of Account (COA) segments across entire company.
• Created versions and hierarchies in DRM. Define user metadata objects (queries, compares, imports, blenders, and exports). Set up and configure system metadata objects (domains, property definitions, validations, and node types)
• Automate the I/O processes using MDM connect, Autosys.
• Security designing using Node types, Node access groups.
• Developed Web forms & workflow process for the users to input data and route it to appropriate approval process before it gets added to DRM.
• Created business rules as per the business logic at workflow level and restricted user to input any wrong data, which minimized use of validation at DRM end and hence improving the tool performance.
• Mentor and transfer DRM technical knowledge and processes to other Client team and department personnel, as requested
• Creation of Export to Tables, Creation of Automated RECONCILIATION process between source and DRM.
• Creation of configuration and Batch script files to automate the complete process.
• Created single Configuration File for multiple Automator actions like Automate, Export and Book execution.
• Developed Procedures to do the Change Capture and Generations of the Automator Files from the source systems (Oracle GL and custom systems).
• Created an End-to-End process (Automated), which will capture and generate the files only when there is any ADD or UPDATE records

Environment: Hyperion Data Relationship Management, Autosys, Batch Scripting, Oracle.

Hyperion Developer

Responsibilities:

• Involved in full life cycle implementation of the project
• Used Migration utility to migrate applications
• Designed and developed the outlines for the applications based on the functional requirement documents. Utilized dynamic dimension build using Load Rules to build dimensions dynamically
• Extensively involved in clubbing dimensions to avoid excess Dimensions in Key Design Issues
• Created Attribute dimensions to avoid excess members and reduce the cost to the company
• Developed Load for loading the data into the cubes
• Created Report Scripts and Calculation Scripts to rollup the data and update the data in the cubes
• Validate calculated data with the help of Excel Add-In
• Developed ad-hoc reports in SmartView
• Developed MaxL scripts write back process to automate the whole Hyperion Essbase tasks
• Responsible for migrating reports into latest version
• Developed the Corporate financial reports using Financial Reporting Studio, Excel Add-In, SmartView

BO Planning Developer

Responsibilities:

• Creating and reviewing the Data Request forms that are required for data collection using Planning Tool.
• Creating and reviewing As Reported Reports which are useful for analysis using Planning XI.
• Creating and reviewing Commentary Reports which enable the facility to collect the comments from users using BO Planning.
• Optimizing the As Reported Reports as per the requirement.
• Supports key business process as Budgeting/Forecasting, Financial Reporting Quarter close/Year End.
• Maintain Schedule for data collection, archiving & timely backup during 22 consecutive collection cycles in a year.
• Document Test Cases & UAT’s before every collection period to avoid timeline failure.
• Analyzing reports and data for data mining and converting to relevant forms offering analysis as per the client requirements.
• Maintaining the Data in secure with all administration accesses and providing the data in converted format to the users as a when required.
• Assist & Help team support & trouble shoot problems during data collection period.

Environment: Hyperion system9x, 11x Planning and Essbase, Excel Add-In, Business Objects Planning.

Developer

Responsibilities:

• Involved in Production and design of Financial and Management Reporting application
• Involved in Consulting with users/clients on database enhancements, maintenance, analytics and reporting
• Involved in development of Legal Reporting/Management Reporting cubes
• Extensively involved in troubleshooting and managing 24/7 production support
• Performance tuning and optimization of cubes for satisfying the users reporting requirements
• Developed calculation scripts, outline formulas, Esscmd scripts and financial reports
• Error handling, troubleshooting, handling restructuring and server problems
• Involved in Migrations of databases from development servers to QA/Production servers

Developer

Responsibilities:

• Activating new logins through ISMS & BSCS with error free service.
• Assigning Inter lock code for CUG customers.
• Assigning Collection agencies codes for new customers.
• Changing the services as per Client request.
• Responsible for all Primary Documentation checking & CPV report checking and ensuring that all Activations to be done within timeframes.
• Preparing daily MIS Reports.

Executive

Responsibilities:

• Developed simple queries and reports for application users
• Automated the process for running batch jobs for database fetch
• Supported clients and customers and trained them
• Created stored procedures for batch report generation
• Responsible for maintaining Customers Relationship