SUMMARY

• Over 9 years of experience in planning, developing, and implementing state of the art information solutions with Hyperion suite of tools.
• Strategic thinking: Provided project leadership to Hyperion consultants and Hyperion Support team and established “Best practices” for Hyperion solutions
• Innovation and Creativity: Championed use of Hyperion Applications, many of which are now used company wide
• Risk Taking and Risk Management: Met all target goals by identifying and tracking high-risk areas by implement risk mitigation early and contingency plans as needed, through proof of concepts technical and architectural prototyping, and by maintaining constant communication with project stakeholders
• Results Orientation: Met and exceeded all goals and objectives in timely manner.
• Coaching and Mentoring: Provided technical training to technical team and business users.

TECHNICAL SKILLS:

Hyperion System 9.2:Hyperion Master Data Management, Hyperion Analytic Server, Hyperion Analytic Administrative Services, Hyperion Planning, Hyperion Shared Services, Hyperion Smart View, Hyperion Business Rules, Hyperion BI Plus, and Hyperion Application Link

Data Warehousing:OLAP, ROLAP, MOLAP, Star Schema, Snowflake Schema

Databases:Oracle 9i/8i/8.0/7.0, MS SQL Server 2000/7.0/7.0, MS Access 7.0/97/2000

Business Intelligence:Hyperion Reports 7.2/6.5, Hyperion spreadsheet Add In, Hyperion Analyzer 7.2/6.5, Executive Viewer 5.x, Clarity Performance Management, Cognos

Programming:SQL, PL/SQL, SQL*Plus 3.3/8.0, HTML, DHTML, C, C++, Unix Shell Scripting

Environment:HP-UX, Sun Solaris, Win 2000/ 2003/ NT 4.0, MS DOS

PROFESSIONAL EXPERIENCE:

Confidential (Hoboken, NJ)
Hyperion Solutions Architect Aug 2012 – Present
Business Challenge:

• Managed a global team of 9 consultants.
• Managed 4 HFM applications and 7 Planning Applications
• Improved existing Monthly Planning processes.

Environment: Oracle Hyperion EPMA- Hyperion Essbase 11.1.2, Hyperion Planning 11.1.2, Hyperion Financial Management 11.1.2, Hyperion BI Plus: Hyperion Web Analysis 11.1.2, Hyperion Financial Reporting 11.1.2, Hyperion Smart View 11.1.2, Oracle Financials, Linux, Windows 2003.

Confidential (New Orleans, LA)
Hyperion Solutions Architect Jun 2012 – Aug 2012
Business Challenge:

• Confidential used Marsy to report their financials on monthly basis. The performance of Marsy reporting system was very slow and the tool itself was outdated and out of market. There was no support available from the vendor company.
• Confidential did not have any EPM tool to forecast and budget their financials, they used excel extensively for it.

Solution:

• Implemented Hyperion Essbase solution to replace existing reporting system – Marsy.
• Implemented Hyperion Planning solution to do driver based Balance Sheet Planning.

Environment: Oracle Hyperion EPMA- Hyperion Essbase 11.1.2, Hyperion Planning 11.1.2, Hyperion Financial Management 11.1.2, Hyperion Shared Services 11.1.2,, Hyperion BI Plus: Hyperion Web Analysis 11.1.2, Hyperion Financial Reporting 11.1.2, Hyperion Smart View 11.1.2, SQL Server, Windows 2003.

Confidential (Los Angeles, CA)
Hyperion Solutions Architect Mar 2012 – Jun 2012
Business Challenge:

• Implement Hyperion Planning solution to replace existing SRC forecasting and budgeting system.
• Forecast and Budget at custom Entity and Chart of Account levels: many to one RCs and COAs.
• Create a new allocation methodology to push Income, expenses, assets, and liability within RC groups based on historical trending.
• Automate Forecasting with default and alternative spread methods for NII and NIE accounts.

Solution:

• Created alternate hierarchies for Entity and Chart of Accounts to facilitate forecasting for many to one scenario
• Created business rules to do the push down allocations and NII and NIE accounts spread.

Role:

• Used @Xrefs in business rules to fetch data from the main Balance sheet planning app
• Developed an initialization calc script to copy aggregated actual, forecast data from group level COA and Entities to the base level of alternate hierarchies, clear base level members of those group level COA and Entities and then consolidate them.
• Developed business rules to do rent allocation, liability insurance allocation, risk allocation, Incentive allocation, Performance Center Allocations, Expense allocation, and Push down allocations.
• Developed business rules to do budget overlay, segment offset, controller Eliminations, Tail End Eliminations.
• Developed business rules to forecast NII and NIE accounts based on methods like "Last Month Actual", "Last Three Month Actual Average", "Last Three Month Rolling Actual Average", "Last Twelve Month Actual Average", "Last Year Actual Average", "Copy forecast from scenario and version"
• Developed numerous web forms, composite forms, menus, smart list.
• Implemented formula rows, row level validation in few web forms

Environment: Hyperion Essbase 11.1.2, Hyperion Planning 11.1.2, Hyperion Shared Services 11.1.2, Hyperion BI Plus: Hyperion Web Analysis 11.1.2, Hyperion Financial Reporting 11.1.2, Hyperion Smart View 11.1.2, OFSA, Unix AIX.

Confidential (New York, NY)
Hyperion Solutions Architect Jun 2011 – Dec 2011
Business Challenge:

• Manual Planning and Consolidations process: Excel and Access
• Manual and tedious calculations for Expenses, Average Assets, Frictional Cost of Capital, MRP, Internal Fees, etc
• Manual Reporting using excel
• A number of disparate IT systems used to generate Assets reporting causing reconciliations
• Improve the efficiency, effectiveness and control over the reporting process and reduce overall efforts for it.
• Add two dimensions to existing Planning application.

Solution:

• Developed an Essbase application to do assets allocations and Pillar reporting
• Developed an Essbase Application to reconcile data daily among disparate data sources
• Redesign the planning application.

Role:

• Designed Data rules to build twelve dimensions
• Developed Calculation scripts to allocate MRP, FCC, Expenses based on Average Assets
• Developed Calculation Scripts to calculate Swiss Re’s fee for managing clients assets
• Developed calculation scripts to calculate taxes for Swiss Re Clients
• Designed the application refresh process using MaxL script.
• Trained business users on Hyperion Smart View functionality
• Designed Reconciliation and variance reports

Environment: Hyperion Essbase 9.3, Hyperion Planning 9.3, Hyperion Application Link 9.3, Hyperion Shared Services 9.3, Hyperion BI Plus: Hyperion Web Analysis 9.3, Hyperion Financial Reporting 9.3, Hyperion Smart View 9.3, Oracle, Unix AIX.

Confidential. (Richmond, VA)
Hyperion Solutions Architect Feb 2011 – Jun 2011
Business Challenge:

• “Excel-hell”: an inefficient principal interface to perform forecasting and planning.
• This process was cumbersome and did not facilitate the iterative needs of these area’s dynamic businesses.
• This process did not allow for different rollups of the organization that would facilitate clear accountability of results to management.

Role:

• Designed the metadata process for three different Essbase applications and integrated them with each other to facilitate data integrations
• Integrated all three Essbase applications using replicated partitions and export calc scripts
• Designed calc script on spread methods to generate forecast instead of user data inputs
• Designed VBA with Essbase and Hyperion Smart View VB functions to execute a calc script on a user selected line of business.
• Managed system and unit testing on all development

Environment: Hyperion Essbase 11.1.13/9.3, Hyperion Planning 9.3, Hyperion Shared Services 11.x/9.3, Hyperion BI Plus: Hyperion Web Analysis 9.2.0.2, Hyperion Financial Reporting 9.2.0.2, SQL Server 2000, AIX.

Confidential (Washington D.C.) Mar 2010 – Jan 2011
Hyperion Solutions Architect
Project Summary:
The Project is to replace the Intermediate workforce Forecast Tool with the workforce expense Planning Application. The planning application focuses on workforce planning, business segment reporting module, and Integration to Fannie Mae Sub systems. Managed integration architecture of different data sources (PeopleSoft and Oracle database) with Hyperion Applications, Development of Hyperion applications, Financial Reporting packages and Dashboards.

Significant Achievements:

• Learnt and implemented solutions in ODI to replace all existing HAL routines.
• Implemented Hyperion Smart View throughout Fannie Mae
• Reduced application refresh time from 4 hours to 30 minutes.

Roles and Responsibilities:
HAL Routines to ODI Routines:

• Designed and replaced existing HAL routines to ODI.
• Developed ODI packages, interfaces, variables, and updated knowledge modules
• Developed ODI dimension build interfaces for different sources (flat file, PeopleSoft, Oracle, etc)
• Developed ODI interfaces to load data into Essbase
• Developed ODI Interfaces to mail Support and Development teams on control totals (variance between PS and Essbase)
• Developed extract processes for different planning dimensions
• Customized error handling in ODI packages to notify users about number of rows processed, successful, updates, errors, etc

Budget 2011:

• Designed and Developed Fannie Mae’s budget for fiscal year 2011
• Designed a process to mass transfers FTEs and Contractors
• Developed business rules to facilitate mass transfer of employees and contractors
• Developed business rules to transfer non compensation accounts from CC to another
• Implemented Hyperion Smart View across fannies user base as a data input tool
• Redesigned 2010 budget forms for data input
• Trained business administrators on Hyperion Smart View

Business Segment Allocation:

• Lead, architected, and directed team in design and development of Business Segment Reporting
• Saved 2 hours of Hyperion maintenance work daily
• Developed HAL Routines to automate the metadata updates
• Developed Load Rules to load data into the planning app
• Migrated the hp app from Dev to Acceptance and Prod environments
• Did performance analysis on outline, calc scripts, data loads, HAL routines, better metadata management

Environment: Hyperion Essbase 9.3, Hyperion Financial Management 9.3, Hyperion Shared Services 9.3, Hyperion Application Link, Hyperion BI Plus: Hyperion Web Analysis 9.2.0.2, Hyperion Financial Reporting 9.2.0.2, SQL Server 2000, Windows XP/2003.

ConfidentialAug 2005 – Oct 2006
Sr. Hyperion Administrator/Developer
Project Summary
Confidential has wide variety of clients in Financial, Insurance, Manufacturing, Retail, Pharmaceutical, Entertainment, and communication sectors. This project is to provide their clients with OLAP and BI applications based on their corporations, projects, and line of business requirements to business users to help them to analyze the business forecast, budget analysis by integrations of different tools into one common tool.

Project Summary
The aim of the Finance cube was to plan and forecast the budget for the year 2006 and provide data to the end users across the world. The application provides information about the expense, Interest earned, revenues, Consolidated Profit and loss, etc.

• Masters in Mechanical Engineering- Confidential University
• Bachelor in Mechanical Engineering