SUSMITHA

Professional Summary:

Hyperion Essbase, Planning and HFM consultant with 7 years of strong experience and a very Hands-on ability in managing large scale ERP/Financial/Business Intelligence Implementation projects with multiple global teams. Expert in Oracle and Hyperion Technologies.

Proficiency and experience in a range of Hyperion products including Essbase, Hyperion Planning, Hyperion Financial Management, Hyperion Financial reporting, Smart View and Excel Add-In.

Experience working on Hyperion Financial Management (HFM), FDM Consulting, Financial Modeling/Analysis, Budgeting, and Client Management. Experienced in leading teams of varied types/sizes and possesses excellent analytical, problem solving, communication and interpersonal skills.

Have strong command on the chart of accounts and I have complete knowledge of all financial statements worked on fulfilling all the client consolidation requirements

Involved in ground up implementations of Hyperion Products

Designed and developed numerous MDDB (Multidimensional database) applications with excellent balance of dense and sparse dimensions.

Functional experience in design, analysis, development and implementation of various applications in Client/Server environments using Hyperion Essbase, Essbase Integration Server (EIS), Hyperion Financial Reports, Hyperion Analyzer, Hyperion Planning, HFM, DRM,FDM, HAL, ESSCMD, MaxL, Essbase Spreadsheet Add-in, Essbase Query Designer. Hyperion Data Integration management (DIM)

Worked on Upgrade Projects related to HFM/Planning/Essbase from 7.x/9.x to 11.x and 9.x to 11.x.

Extensive knowledge in HFM classic and EPMA applications, Hyperion FDQM and financial reporting.

Excellent proficiency in both Star Schema and Snow-Flake Schema data modeling techniques.

Experience in creation and maintenance of numerous applications with excellent balance of dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO) Essbase kernels.

Expertise in writing custom Essbase calculations scripts, MDX scripts, automated the Essbase Cubes using MaxL, Esscmds and Batch Scripts.

Experienced in dynamically building Dimensions, Attributes and Shared Members using Rules files in an Essbase outline by means of several build methods such as generation, level, and parent-child references.

Experience with Hyperion System Planning, for planning and budget, metadata and rules maintenance, reporting and security.

Experienced in data loading through Free-Form Loading, Rules files and Excel lock and send techniques.

Broad understanding of database calculations such as implementing Formulas on dimension members, order of calculations in terms of Dense and Sparse dimensions, Dynamic Calculations.

Worked extensively on Hyperion Shared Services and Created numerous users, groups and provided them different privileges.

Expertise in writing ESSCMD and MaxL Commands and experienced in writing ESSCMD for total automation of the process, calc scripts, report scripts, MaxL scripts. Strong at making automation script and scheduling using windows schedulers (batch files).

Meet with clients to understand business processes and to gather system requirements with subsequent application design and implementation using best practice implementation techniques Extensive Hands-On experience in design, Development and tuning Essbase database.

Experienced in optimizing the cube by tuning the Cache settings for Index cache, Data file cache, Data cache, and buffer I/O values.

Proficient in software documentation, technical report writing, decisive with strong leadership qualities, flexible in work schedules.

Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.

Educational Qualifications:

Bachelor of Technology in Computer Science and Engineering.

Technical Skills:

OLAP Tools

Hyperion Essbase, Planning11.x /9.x/7.x, MaxL, ESSCMD,

Hyperion Financial Reporting, Web Analysis

Databases

Oracle 8i/9i, MS SQL Server 2000, MS-Access.

Dimension Modeling

LAP Star-Schema Modeling, Snowflake Modeling Fact and Dimensions Tables.

Reporting Tools

Hyperion Planning Web Analysis, Hyperion Financial

Web Related

HTML, DHTML,Java Script.

Operating Systems

Windows NT/2000/2003 Server/XP, Linux, Unix

BAXTER Healthcare, Deerfield, IL

Hyperion Admin May 2014 – Till Date

Responsibilities:

Installation and configuration of Oracle Enterprise Performance Management Suite 11.1.2.3

Participated in Installation for Oracle Hyperion Financial Management 11.1.2.3, DRM 11.1.2.3, FDM 11.1.2.3

Created end to end property definitions and categories to define the Hyperion planning metadata structure feed from DRM for Location hierarchy.

Developed numerous custom export processes in DRM as per the requirements by the target systems - EBS, HFM, HP inventory and HP Planning/Budgeting applications.

Worked on End to End implementation of HFM projects from requirement gathering to production deployment.

Developed and deployed EPMA and classic HFM applications used for consolidation purposes.

Created and Loaded Metadata for HFM consolidation Actual and Budget using EPMA to generate variance reports.

Configured the source and target adapters in HFM from FDM and created the machine profiles.

Automated Data loads from different departments into HFM using FDM Task Manager.

Create business rule by VB scripting to automate business process.

Modified HFM rules to perform various functions (Consolidation, Calculation, Currency Translation etc.)

Integrated EBS test instance with DRM test instance, by creating external connection to the database tables.

Created Member Lists, Data Grids, Data forms and Security file.

Worked with Finance Analysts to customize application for generating Financial Statements.

Performed Set up of Journal Entries, Intercompany Transactions, Eliminations, Exchange rate conversion.

Entered Foreign Exchange Rates grids and their entries for Balance Sheet and Income Statement.

Assisted in HFM/FDM annual SOX, IFRS, and GAAP audits by providing documents, data and reports to internal/external auditors.

As part of maintenance took back up for metadata, business rules, journals and security files.

Prepared templates for achieving quarterly forecasts, annual budget, ad-hoc reporting and management reporting by working with the business managers

Responsible for security provisioning using shared services across the entire Hyperion environment.

Created groups and users for different business segments and then assigned security and filters to define HFM privileges on them.

Created and assigned Provisioning for all the appropriate Users/Groups in the Shared Services

Created reports based on the business user requirement using Hyperion Financial Reporting and Smart View

Used life cycle management to migrate applications from development to test and from test to production.

Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load Monthly data in HFM Application.

Updated hierarchies and performed data loading using FDM

Day to day manual exports have been extracted for testing purposes from the System exports in DRM web client.

Migrated all the property definitions, system preferences, export import processes, blenders and queries from Production instance to the Disaster recovery instances using DRM migration client.

Done troubleshooting DRM server configuration and enabled API adapter hosts to resolve the connection error from DRM web client to the server.

Configured the WSDL URL and API adapter URL while enabling the EBS - DRM interface.

Provided end to end testing strategy and the test scripts for Hyperion Planning structure feed from DRM for Location hierarchy.

Prepared the Backup plan, implementation plan, testing plan, and fallout plan for the DRM enhancements.

Prepared the design document for DRM alternate department hierarchy and DRM location feed update.

Involved in Knowledge transfer and development transition to the other team members and to production team both onshore and offshore.

On time completion of all assigned tasks and desirables meeting the business expectations and timelines.

Environment: Hyperion DRM 11.1.2.3.303, Hyperion financial management 9.3.1/11.1.2, Financial Data Management 11.1.2.3, Hyperion Essbase 9.3/11.1.2,Hyperion Planning 9.3/11.1.2,(HFR)Hyperion Financial Reporting, 9.3.1/11.1.2,Hyperion Web Analysis 9.3.1/11.1.2,Hyperion Shared Services, ODI 10.1.3, Excel Spreadsheet Add-In, VB Script, Smart View, Window Server 2003/2008 R1, Oracle SQL Developer 2.1.1.64, Oracle 10.204

Pernod Ricard, Purchase NY April 2013 to April 2014

Hyperion Planning Developer

Oracle Hyperion Planning replacing the existing excels based planning process. Actual data will flow from the PeopleSoft GL, HCM to the Hyperion Planning applications

Responsibilities:

Designed BSO application for the purpose of Gross Margin and Commissions planning and a separate ASO application for regulatory reporting, variance analysis and archiving process. These applications supports annual budget.

Designed dimension and outline using Outline Load Utility and Oracle Data Integrator.

Configured master and work repositories, defined the physical & logical architectures and contexts in ODI.

Managed Essbase, Planning, FR, IR, HFM and FDM applications on 11.1.1.3

Integrated various source system Oracle GL, Oracle HR and capital expenditure sources to Hyperion Planning using ODI (Oracle Data Integrator) by creating and complex Interfaces.

Loaded, reconciled and consolidated key financial data with Hyperion using FDQM(Financial Data Quality Manager) and HFM consolidation

Designed metadata and data automations through ODI and scheduling scenarios

Established a workflow process to keep track of the plan, review the plan, and change the ownership and status of the planning unit.

Designed Data forms/Web forms, Menus and Smartlists to allow users to key in the data for the drivers that business requires, Also attached business rules with these data forms to calculate several accounts

Automated Task Lists to guide the planning users through a several sets of webforms, calculations, business rules, etc. required to complete the plan cycle.

Designed a Replicated partition to transfer a portion of data from one cube to another, which significantly increase the performance for the excel-retrievals.

Assisted users in using Hyperion Smartview and Excel-Addin to perform the drill-downs and ad-hoc reporting.

Designed Rules Files for the purpose of loading data from flat files to the dimensions in outline using several build/load methods such as generation, level and parent-child references.

Created MaxL and batch scripts to automate process of updating cubes on a daily basis.

Performed regular Backups of the cube and archiving it.

Performed daily and monthly refresh processes, which involve opening and closing of the monthly forecast, loading actuals, updating variables, archiving, data validation etc.

Created Data export calcs and Report Scripts for the purpose of exporting specific set of data from the cubes.

Created customized Financial Reports using Hyperion Financial Reporting Studio according to the finance users’ requirements. These reports included Budget vs. Actual, Budget vs Forecast and Forecast vs. Actual reporting capabilities. Also, automated the entire process of pushing reports by sending them automatically on a particular business day.

Supported existing P&L application (consisting of Balance Sheet, Consolidated and Workforce databases) to plan several employee related expenses like salaries, bonuses, vacation days, vacant and filled positions, report Net income, Net Sales, Profit and Loss, etc.

Resolved tickets that are opened by the end-users to support the Hyperion products.

Creating documentation for functional requirements of the project which included entire end-to-end development, testing and go-live.

Environment: Hyperion Essbase 11.1.1.3, Oracle EPM, ODI 11.x, Hyperion Essbase, Hyperion Planning, Financial reporting studio, Hyperion smart view, Essbase excel add in, Oracle 11g, PL/SQL, TOAD, Windows

VANGUARD, Jersey City, NJ / India Jan 2012 – March 2013

Hyperion Essbase Developer

Responsibilities:

Realized Complex Technical Upgrade of Essbase from v7.1.3 to V11.1.2.1 across more than 20 production applications and 25 historical applications.

Migrate applications using migration utility and validation of the objects and data in v11.This required validation and remediation of existing calc scripts, load rules, report scripts and also creation of reconciliation templates to verify the data.

Reformed and optimized the entire automation process of data loads, running of scripts and nightly backups to suit the new server landscape. This required in-depth understanding of the business processes and functionality.

Suggested different security migration options for moving complete security from V7 to v11

Migrated native essbase security/groups/privileges/filters via MaxL.

Requirements were gathered and Products were split between Grocery Co. and Snacks Co. Calculations, formulas, load rules and reports were remediated as needed w.r.t split

Essbase VB api based reports upgraded and made compatible with the target version of Hyperion Essbase

Upgraded and modified the Custom Toolbar used in Excel Add-in according to target version of Hyperion Essbase with minimal documentation.

Involved in User training, UAT and Application Support

Environment: Hyperion Essbase 11.1.1.3/11.1.2.2, EAS, Hyperion Planning 11.1.1.3/11.1.2.2, Hyperion workspace 11.1.1.3/11.1.2.2,Essbase Deployment Services and VB Script.

Circuit City, Houston, TX / India Oct 2010- Dec 2011

Essbase Developer & Support Engineer

Description: This Company is the second biggest providers of consumer electronics with over 600 stores. The objective was to provide flexibility and analytical capability to budget forecast profitability ratios, buying trends and sales performance of various products in all of their markets.

Responsibilities:

Analysis of the specifications/requirements provided by the client.

Created rule for outline Meta structure using dynamic dimension build.

Developed a MDDB application using Essbase that stored data and performed the loading and manipulation of data into the database using Load Rules files.

Created standard and attribute dimensions in the outline editor to modify the cube for quick retrieval time and optimization

Creating reports through Excel spreadsheet add-in.

Developed various Calc Scripts to solve business logic.

Automated data loading, creating dimensions, performing calculations, using MaxL and ESSCMD with the help of batch scripts.

Checking Log File for Dimension build as well as data load for Error Handling.

Generated financial reports using Hyperion Financial Reporting.

Developed automation scripts for back up and Refresh of all Cubes.

Created various filters as per user requirement and Involved in restructuring of Outline.

Performed various optimization techniques.

Provided support & training for end users with documentation.

Managed Monthly Close Activities.

Resolved issues raised by users.

Environment: Hyperion Essbase 9.3.1,Hyperion Financial Reporting, Web Analysis, Spreadsheet-AddIn, Oracle

HCL Technologies, August 2009- Sep 2010

Jr. Software Engineer

This System Expense Process System was developed as part of the Internal Application Development to manage the entire expense process, form creation and submission through reimbursement. This System helped to streamline the Hcl Software Division’s Expense Management System.

Roles & Responsibilities:

Involved in gathering requirements and developing a project plan.

Involved in development of Applications and cubes as per the business requirement.

Involved in gathering data and supervising data load.

Involved in creating Rule files and batch files to automate the data load process.

Responsible for Maintenance & Testing the cubes.

Optimized Data Loads and Calc Scripts.

Extensively used MaxL, ESSCMDS to run calculation scripts and report scripts.

Responsible for maintaining users and security.

Developed Excel Templates for user interface in Essbase database.

Provided technical guidance and support to end-users by developing the documentation required.

Environment: Hyperion Essbase 6.5, Hyperion Reports, Excel Add in, Windows 2003, UNIX.

RWD Technologies, Hyderabad, India Aug 2008 to July 2009

Intern / Analyst

Description: RWD Technologies is a privately held, U.S.-based corporation focused on increasing worker productivity, product quality, and bottom-line financial performance. RWD has built a strong reputation by delivering technology and training solutions that help operational efficiency and reduce costs by streamlining processes and procedures

Responsibilities:

Developed many load rules for loading specific type of data files and for dimension build.

Involved in retrieving the data, Oracle in the form of text files and then loaded the data into EssBase using load rules files.

Checking Err File for Dimension build as well as data load.

Designed and implemented batch scripts for loading data from the financial system’s database to Essbase cube through data files and rule files.

Involved in checking Block size and page file to improve performance.

Optimized the applications to bring down calc runtime and database size considerably.

Designed users input capability to the applications maintained by Filters.

Involved in replication partitions.

Involved in Backup and Recovery process.

Granted access to other users based on their specific needs and assigned them to specific groups. Set filters to restrict access to users based on the authority they have.

Reconciliation of loaded data

Environment: Hyperion Essbase 7.x, Hyperion analyzer, Hyperion Essbase Spreadsheet Add-In, MS Excel, Windows 2003, Oracle.

Contact this candidate