SUMMARY:

• IT professional with 7+ years of experience with emphasis on Hyperion application development using Hyperion financial management, Hyperion Financial Data Quality Management, Hyperion Planning, Essbase, Oracle Data Integrator (ODI), DRM/DRG and Hyperion Financial Reporting.
• Worked on End to End implementations of Hyperion projects (HFM, Essbase and Planning)
• Have strong experience in installing Hyperion 11.1.2.4, Hyperion foundation services, EPMA, Essbase server, EAS, APS, Hyperion Financial Reporting and Analysis, Planning, HFM, FDM.
• Strong experience in Hyperion Planning 11.1.2/11.1.1.3/9.3.1/4. x,Hyperion Essbase 11.1.2 /11.1.1/9.3.1/7. x, Hyperion Financial Reporting, Hyperion Web Analysis (Web Analyzer).
• Experience in working through all phases of Software Development Life Cycle (SLDC) including the design, development, implementation, and maintenance of financial applications
• Strong experience in creating data grids and web data forms to load data and Posting, scheduling the journals to adjust data.
• Designed complex security model for HFM, Planning, and Essbase applications as per client requirements.
• Created various complex HFM rules for the consolidation applications
• Administration of Hyperion Planning, Hyperion Financial Management (HFM), Hyperion Financial Data Quality Management (FDM), Hyperion Reporting, Hyperion Strategic Finance.
• Developed numerous Essbase Multi - Dimensional Database cubes and various OLAP application models using Hyperion Essbase 9.x and 11.x.
• Solid understanding of multidimensional and relational database architecture; Extensive knowledge of planning, budgeting, and forecasting procedures.
• Expertise in providing security for Planning & Essbase applications and ability to create user and group profiles for assigning proper privileges using both User provisioning, Native security and Shared services modes.
• Experience working with ERPI, Oracle Data Integrator (ODI) adaptors and ODBC Connectors for Essbase, Planning, and HFM creating knowledge modules, packages and interfaces for metadata and data loads.
• Experience in integrating EBS, JD Edwards, oracle GL, BO, and other ERP systems with Hyperion using ODI, ERPI and FDM.
• Expertise in issue resolving and in optimizing the performance of HFM and Planning applications.
• Expertise in designing Business Rules, Complex Web forms, Work Flow, Task List, and smart list, planning units.
• Expertise in developing Essbase Rules Files, Calculation Scripts, Member formula and Report Scripts. Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers)
• Designed required ETL process for BI applications from various data sources such as Flat Files, Oracle, Teradata and SQL server, Netezza.
• Expertise in Financial Statement Analysis, Data Analysis, Gap Analysis and understanding of ROI Analysis, P&L Analysis, Impact Analysis and Cost-Benefit Analysis.
• Direct management experience with technology, people and processes. Well-versed in Business Problem analysis and design/development/implementation of analytical solutions.
• Expert in forming and maintaining positive and productive working relationships in teams
• Created documentation for maintenance and support for Hyperion products.
• Expertise in trouble shooting, Knowledge transfer, technical document and trained clients.
• Provided 24x7 server support Hyperion services and day to day production job.

TECHNICAL EXPERTISE:

Operating Systems: Windows XP, Windows Server 2003/2008, Unix; Solaris, AIX, and Linux

BI Tools: Hyperion Financial Management 11.x/9.x, Hyperion Planning 11.x/9.x/4.x/3.x, Essbase 11.x/9.x/7.x/6.x, Oracle Business Intelligence Suite, Financial Reporting, Hyperion Interactive Reporting (BRIO) 11.x/9.x/8.x/6.x, Hyperion Strategic Finance (HSF), Smart View, Essbase Administration Services (EAS), Hyperion Workspace, Hyperion Shared Services, Hyperion Reports 9.x/7.x/2.x, Excel Add-in, Essbase Studio.

Multidimensional Databases: Oracle EPM 11.1.2.2, 11.1.1.3, Hyperion System 9.3.1, 9.2 Hyperion Essbase 7.1 and 6.5

Relational Database: Oracle 10g/11g, SQL Server 2005/2008, Teradata V2R6, DB2,Netezza

ERP System: Oracle E Business Suite, SAP, People Soft

Reporting Tools: Financial Reporting, Web analysis, Hyperion Smart View, Excel Add-In, Interactive Reporting

Domains: Banking, Financial, Brokerage, Telecom services.

ETL Tools: Oracle Data Integrator (ODI), DRM, Outline Load Utility, Informatica 8.1/7.1, Data Stage 8.x/7.x

WORK EXPERIENCE:

Confidential, Boston, MA

Sr. Hyperion Financial Management Developer/Admin

Responsibilities:

• Excellent communication and interpersonal skills and outstanding team player with an aptitude to learn.
• Performed end-to-end implementation Hyperion financial consolidation applications from requirement gathering to production deployment.
• Designed Business requirements documents based on the analysis of the current business model.
• Installed and configured Essbase, Shared Services, Planning, Financial Reporting, Smart View and Financial Data Quality Management on multi server environments.
• Installed FCM and SOA components in a cluster environment
• Created applications in EPMA leveraging Shared members within Dimension library.
• Worked with SME/Finance Teams to gather the consolidation application requirements.
• Designed Technical design document as per the business requirements.
• Developed and deployed EPMA and classic HFM applications used for consolidation purposes.
• Configured the source and target adapters in HFM from FDM and created the machine profiles.
• Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load Monthly data in HFM Application.
• Managed the monthly close process financial close management (FCM) and completed all account reconciliations.
• Automated Data loads from different departments into HFM using FDM Task Manager.
• Modified and Designed HFM rules to perform various functions (Consolidation, Calculation, Currency Translation etc.)
• Created financial statements in Hyperion Financial reporting (HFR) Studio
• Created financial reports such as Revenue report by product, operating expenses reports by Operating units, budget vs. actual variance reports using financial reporting studio.
• Created Member Lists, Data Grids, Data forms and Security file,
• Performed Set up of Journal Entries, Intercompany Transactions, Eliminations, Exchange rate conversion.
• 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 admin, super user and user groups and assigned necessary roles for FCM provisioning
• Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
• Created and assigned Provisioning for all the appropriate Users/Groups in the Shared Services
• Used LCM to migrate applications from one environment to other (Dev to Test and from Test to prod)
• Updated Hierarchies and performed data loading using Oracle Data Integrator
• Involved in Knowledge transfer and development transition to the other team members and to production team (onshore and offshore)
• On time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Provided documentation related to administration of the HFM applications.
• Worked on imports for one time build in DRM. Further, Creating Hierarchies and version from the import file from stage Area.
• Integrated ODI mappings and translations with Oracle Data Relationship Management (DRM) web services to support meta-data management approach to maintaining account and entity hierarchies.
• Created the hierarchies using oracle DRM.
• Created versions in DRM with different hierarchies and blended the data.
• Export/Import data from DRM using the DRM migration modules.
• Implementing security using tool internal ability and external authentication in DRM.

Environment: Hyperion financial management 11.1.2, Hyperion FDQM 11.1.2, Hyperion Essbase 11.1.2, Hyperion Planning 11.1.2, Hyperion Financial Reporting (HFR) 11.1.2, Hyperion Shared Services, Oracle data integrator 10.1.3, Excel Spreadsheet Add-In, LCM, FDQM, VB Script, Smart View, Window Server 2003/2008 R1, Oracle SQL Developer 2.1.1.64, Oracle 10.204

Confidential, Saint Louis, MO

Sr. Hyperion Financial Management Developer/Admin

Responsibilities:

• Designed and developed consolidation application using business requirement document
• Managing Metadata and defining attributes and creation of application profile.
• Created HFM application on both desktop and web-based client and created data grids and data forms to view and enter the data.
• Created database schemas and tables for SOA and FCM using Repository creation utility
• Proper setting of POV (Point of View) and Set up security, including users, groups, security classes, and access rights.
• Configured Foundation and FCM components
• Involved in changing the Metadata whenever needed. Extracted, loaded the Metadata whenever metadata changes occur.
• Created the Journals as per the client requirement. Manage the financial review cycle using Process Management. Running consolidation after loading the data.
• Performed full charge Account Payable, Month -End Close (FCM), and weekly bank reconciliations.
• Generation of Financial Statements through HFR for business users. Involved in year and month end processes (FCM) and all close cycles
• Handled HFM\FR critical, medium and normal tickets involving interactions with users and solving issues.
• Loaded, reconciled and consolidated key financial data with Hyperion using FDQM (Financial Data Quality Manager) and HFM consolidation.
• Involved in the preparation of detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability Reports.
• Involved in Data Loads and CALC Scripts optimization. Automated the Cube building through MaxL & shell scripts and scheduled them.
• Created various filters as per user requirement in EIS. Involved in the installations and configurations of ODI 11.1.1.5
• Tuned the existing applications for better performance by identifying the issues on priority basis and by modifying the server, application and database settings.
• Involved in Knowledge Transfer and training of the business users about the new environment.
• Worked with Hyperion / Oracle support team to resolve product related issues.

Environment: Hyperion Financial Management 9.x/11.1.2.3, Hyperion Essbase 9.3/11.1.2, Hyperion Planning 9.3, Hyperion Workspace 9.3, Hyperion Workforce Planning 9.3, ODI 10.1.3, Hyperion Financial Reporting 9.3, Excel Spreadsheet Add-In, VB Script, Smart View, Window Server 2003 and UNIX Servers, Oracle SQL Developer 2.1, Oracle 10.2

Confidential

Financial Analyst

Responsibilities:

• Involved in the creation of dimensions and members in Essbase Outline. Involved in the complete Software Development Life Cycle of the applications
• Designed and developed complex Essbase applications with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Optimized the Hyperion application to balance the calculation and retrieval performance.
• Developed the reports as for given client templates in Hyperion analyzer.
• Performed dynamic calculations, loaded data from various database using Rules files, developed, reviewed, and optimized report queries in Microsoft Excel.
• Created security for the cubes (created users/Groups). Developed the Security Filters for Essbase applications
• Built ETL process to load data and build dimensions in Essbase applications in Nightly mode.
• Worked on day to day production supports for Essbase and ETL applications.
• Worked with SME and business analysts to gather and analyze requirements and built and POC for initial sign off.
• Expertise knowledge in Design and architecture of Essbase and Planning applications.
• Hyperion Planning is used to build the Planning and Budget application from the scratch to meet the business functional requirement and to map the data from the external sources application.
• Developed numerous simple to complex Business Rules for planning and calc scripts for Essbase applications as per end user requirements
• Created the Planning applications with the plan type for Revenue, expenses, capex and workforce modules.
• Involved in data tie-out for performing OLAP cubes using a simple variable substitution mechanism, to ensure that data is the same in both system.
• Implemented the Dense/Sparse dimensional architecture with Attribute dimensions, Smart lists based on the requirement and easy to use and update in future.
• Created HAL7.3 (Hyperion Application Link) jobs for dimension build and data loads.
• Project within budgeting, planning, forecasting, OLAP and reporting solution and manage security of Hyperion apps.
• Used VBA for the creation of a template system where the field actually inputs data into an excel workbook that then sends the numbers to Essbase and initiates a calc script via VBA automations resulting in consolidated financials.
• Used VBA as a very powerful spreadsheet toolkit for automating Essbase/Excel retrieval task.
• Optimizing Aggregate Storage Option and Block Storage Option outline.
• Improved the performance i.e., optimized the Planning, Essbase system by changing the dimension order and working on configuration file including cache design technique.
• Used Hyperion Financial Management (HFM) for financial analysis and reporting and also created and modified numerous reports in Financial Reporting studio.

Environment: Hyperion Planning system 11 and 9.3/7.x, Oracle Data Integrator (ODI), Hyperion Shared Services 9.3/7.x, Hyperion Workspace, Essbase 9.x/7.x, HAL 4.x, Hyperion Interactive Reporting Studio 9.3/7.x, Hyperion Financial Management (HFM), Essbase Excel Add-in 7.X, Oracle 11g/10g, Ms Excel 2003/2007, Windows/Linux. OLAP Data Warehousing using Hyperion Essbase 7.0, Hyperion Planning 7.0, Essbase Excel Add-In, MS-Excel, Oracle & Windows 2000/SUN Solaris.