SUMMARY

• Over 4 years of IT industry experience in retail, banking and insurance sectors with a strong background in finance and accounting coupled with Finance Systems Implementations.
• Experienced in Hyperion Planning,Essbase, Financial Management (HFM), Data Relationship Management (DRM), Financial Data Quality Management Enterprise Edition (FDM EE), Oracle Data Integrator (ODI) and Oracle Business Intelligence Enterprise Edition (OBIEE) Implementation projects for various clients
• Worked on integrations involving Oracle E - Business Suite, PeopleSoft and Oracle Fusion Applications
• Experience in installation, configuration, server settings, backups and client installations of Hyperion products such as Essbase Studio, Essbase Administration Services (EAS), HFM, Essbase Integration Services, Analyzer and Hyperion Reports on both Windows and UNIX environments
• Worked on end-to-end Hyperion project implementations designing the application and developing,
• Apart from end-to-end implementations for planning and consolidations, also worked on enhancement projects involving optimization of calculation and retrieval times, improving application performance for long range planning and cascading processes, modifying reports to meet business requirements
• Proficient in usage of Excel Add-in, Hyperion Smart View, Financial Reporting Studio, Interactive Reporting Studio.
• Strong communication, organizational and interpersonal competencies along with detail oriented and problem solving skills in the technology arena

TECHNICAL SKILLS

OLAP: Oracle Application R12/11i/11.03, Oracle EPM System v.11.1.1.4.X/11.1.2.1, Hyperion Planning v.11.1/v.9.3.1/3/v.4.x, Essbasev.11.1/v.9.3.1/v.7.1, Essbase Administration Services (EAS), Hyperion Enterprise V4.4, BI server

Script Lang: MAXL, Calculation scripts, Business Rules, MDX scripts

Databases: Oracle (9i, 10g), MS SQL Server (2003, 2005), DB2, MS Access

Server: UNIX, Windows

BI Reporting Tools: Excel Add-in with VBA, Smart view, Hyperion Web Analysis, Hyperion Financial Reporting (FR).

Application Software: MS-Office suite (Excel, PowerPoint, Word Outlook).

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas, NV

HFM Consultant

Responsibilities:

• Worked in a team to implement HFM application and setup of Financial Reporting belonging to the Data Tier of Planning Architecture.
• Installation of HFM Fusion edition 11, implementation of HFM 11.1.2, also responsible for upgrade and patching works for HFM application.
• Active member in creating, configuring, designing, and implementing new HFM Fusion 11 applications.
• Creating dimensions and loading metadata into HFM application, creating Application profile and assigning its frequencies.
• Creating exports for data migration.
• Exporting the hierarchies and loading them into HFM for building metadata.
• Managing metadata by defining Dimension and its attributes, Application settings, Account types, consolidation methods, currencies, Intercompany transactions.
• Creating data forms in HFM application by using Form Builder for users to input the data. Also, creating data grids in HFM application for consolidating financial data.
• Experienced with user provisioning in shared services by using native directory and external authentication directory.
• Generating Ad hoc reports, Daily reports and Ending monthly balance reports from HFM application.
• Responsible to develop, implement and test Shared Services security management systems across HFM and Hyperion Financial Reporting. Used Shared Services for implementing HFM Process Management activities.
• Solving several issues in HFM architecture and end-user level based on business, budgeting, financial and accounting department requirements.
• Connecting FDQM with HFM. Responsible for setting FDQM security standards and administration of FDQM roles across the company.
• Worked with import formats in FDMEE, by creating import groups, assigning import format, and creating import scripts and integration scripts. Used both explicit and wildcard mapping for Data mapping in FDQM.
• Done all Data Modelling using FDMEE, like importing source data, validating source data, exporting data to target systems and consolidating target systems.
• Managing metadata by defining Dimension and its attributes, Application settings, Account types, consolidation methods, currencies, Intercompany transactions in HFM.
• Managing Member list, journals, Rules using Rules editor and Data forms.

Environment: Oracle EPM 11.1.4 Planning using EPMA, Shared services, Workspace, Hyperion Essbase 11.1.4, ODI, Hyperion Financial Reporting Studio, Hyperion Web Analyzer, Smart view, Essbase Spread sheet, Financial Data Quality Management (FDM), Oracle 10g, Windows server.

Confidential, Philadelphia, PA

Planning and Allocation Support

Responsibilities:

• Created Planning applications and Essbase applications for Budgeting based on position and Employee.
• Created the Web forms to get the budget data entered into the database by giving the access levels to the business users.
• Working closely with Infrastructure and DBA team to configure the system and troubleshoot performance issues related to Hyperion applications.
• Working with Hyperion Planning users and DBAs to diagnose and solve application errors.
• Production support issues resolved for the server issues, security issues, Data issues and the Performance optimization issues.
• Involvement in administration tasks such as Data Loading, Batch Jobs, Backup and Recovery.
• Security provisioning based on the business user level, and create the planners and interactive user’s groups.
• Integration with Oracle EBS system to pull the data like GL, sub Ledger, Discounts, Depreciation data. And to the HRMS.
• Installed the Hyperion version 11.1.2.1 on a distributed environment and upgraded to the new release of 11.1.2.3.
• Worked on Shared services User/Group maintenance.
• LCM migration process is used to Migrate the Elements/objects.
• Used the EPMA to maintain the library of Application, dimension library, Calculation manager, Rules & Rule sets.
• Also, used DRM/MDM to maintain the libraries of Applications/Dimensions modification history and deploy.
• Created the Meta data in Planning (Outline loader, ODI), EPMA (Data synchronization, ADS file import).
• Data loading process is developed, to retrieve data form EBS (Oracle applications) and to load into EPMA, Planning, Essbase data bases directly.
• Architected framework for automation of cubes using Batch scripts/shell scripts and MAXL for refresh of development with production data.
• Developed MAXL scripts to build and load data into ESSBASE database using Rule files.
• Handled weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation
• Created the Workforce and Non-Workforce application for all Expenses and Revenues including the Project allocated expenses.
• Documenting functional and technical specs and different methods of cube loading processes.
• Implemented the Dense/sparse dimensional architecture with Attribute dimensions, Smart lists based on the requirement and easy to use and update in future.

Environment: Hyperion Essbase 11.1.2.1&3, Hyperion Planning 11.1.2.1&3, Shared Services, EPMA 11.1.2, LCM, DRM, MDM, Oracle 11gR2 &12c, Unix, Toad, Smart view.

Confidential

GET Hyperion Support

Responsibilities:

• Work closely with the Finance department to ensure timely Hyperion Applications support during the close and non-close periods.
• Single point of contact for the Business System Analysts and End users for gathering all requirements for Implementation of Oracle EBS (AR, AP, I-Procurement and I-Receivables).
• Integration with Oracle EBS ERP system to pull the data from Oracle GL- sub Ledger, discounts, depreciation data and the details on major and minor projects from Oracle FA along with employee information from Oracle HR tables for building the end-to-end budgeting applications.
• Manage ad-hoc user requests and assist in the coordination of team activities on Hyperion projects.
• Provide ongoing operation support for Hyperion systems & HFM.
• Extract and load miscellaneous data in HFM and Essbase.
• Setup journals, task lists, member lists and web forms as per the functional requirements for the HFM application along with the consolidation and approval processes for monthly closing of fiscal periods.
• Maintain HFM Business Rules, Scripts, Variables, Input Grids, Data Forms, Reports and Journals.
• Support Hyperion FDMEE to support business users during the monthly close process and updating FDMEE load templates as needed.
• Maintain load scripts and mapping tables for legacy ERP loads in FDMEE.
• Developed the interfaces usingODI to achieve the Metadata and Data to meet the requirements.
• Assist in designing, developing, and deploying Hyperion DRM applications.
• Build multi-dimensional models by using Essbase Studio
• Perform all Essbase Studio tasks, including deploys cubes and executing drill-through reports
• Created Web based Data form to allow the end users to enter Actual data as per the Month wise period close process.
• Maintaining documentation for installation and troubleshooting procedures of the application.
• Installation of HFM Fusion edition 11, implementation of HFM 11.1.2, also responsible for upgrade and patching works for HFM application.
• Work closely with End-User community and any internal support groups to troubleshoot and solve technical issues adhering to pre-defined SLAs.
• Discussing with reporting management to schedule UAT user role, testing scenario for each identified user and develop user guide that include UAT activities.
• Be responsible to do testing in UAT before release of any changes in production environment.
• Involved in upgrade between releases and migration from one environment to another using Life Cycle Management (LCM) utility.
• Scheduling the Batches for running the reports using Hyperion Financial Reporting.
• Responsible for creating Multiple Templates of Smart View and Excel Addin for every day analysis of the user.
• Meta data is developed in Hyperion Planning for the actual or Budget data and loading the data through HAL, ODI.
• Support/maintenance of scheduled and ad-hoc jobs
• Performance monitoring and tuning
• Provide primary support to the users in solving day-today issues.
• Involved in maintaining and creating new data servers, connections for different data sources through the Topology manager. Created data servers for sources that included Flat files and SQL Server sources.
• Responsible for Migration of application from One Environment to other.
• Developing new reports in Hyperion Financial Reporting and Smart View, and making changes to the existing Report views when requested.
• Created and Managed Filters on Essbase cubes to restrict the access to the data for various intersections based on user privilege.
• Developed numerous Financial Reports like Profit & Loss Reports, Income statement Reports, Expense Reports & Revenue Reports using Hyperion Reports Tool.

Environment: Oracle EBS 11i, Hyperion Essbase 11.1.2.4, Shared Services 11.1.2.4, ASO & BSO, ODI, DRM, Essbase Studio, Smart View for office, spread sheet add-in, Interactive reporting, Financial Reporting, Oracle 10g

Confidential

Hyperion Technical Analyst

Responsibilities:

• Involved in systeminstallation,configurationand softwareupgradesof Hyperion Essbase, planning.
• Involved in developing design specifications of Essbase cube with Customers.
• Developed Aggregate Storage Cubes (A.S.O) cubes using Essbase.
• Extensively involved in designing and modifying the outlines for Essbase cubes.
• Developed Calc Scripts, Rule files and Report Scripts for data loads and dimension builds.
• Developed batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube.
• Developed OLAP Models and outlines using Essbase Integration Services from star schema in relational databases.
• Involved in installation of Hyperion Planning on Windows environment.
• Create Data Source Configuration through Hyperion Configuration Utility 9.3 in Hyperion System 9 Foundation. Created and registered Planning applications in Hyperion System 9 Workspace.
• Created Dashboard Reports using Interactive Reporting.
• Developed and created Web forms for users to input the data into Essbase cube through Hyperion Planning.
• Worked extensively on Budget process and Budget Administrative tasks
• Involved in Structure changes and creating Alternate Roll up’s in Web Forms

Environment: Essbase 11.1.1.3, Excel Smart View, Hyperion Planning 11.1.3, Hyperion Shared Services, Report Scripts, ODI, HFR (Hyperion Financial Reporting).

Confidential

Reporting Analyst

Responsibilities:

• Used Hyperion Essbase Admin Console to modify existing and develop new database Outline Files, Load Rule Files, Calc Scripts, Reports Script
• Developed many load rules for loading specific type of data files and for dimension builds.
• Created batch scripts using Esscmds and developed rule files to load the data into Essbase.
• Involved in Essbase server optimization and tuning to considerably lower the calculation time.
• Involved in Essbase server optimization by creating partitions for load distribution for reducing response time.
• Developed various financial reports on MS Excel add-in using Essbase Query Designer for analyzing the data at different levels.
• Developed reports using prompt, conditional format, aggregate functions of Hyperion Reports as per the user requirements.
• Developed customized and ad hoc reports based on the user requirements.
• Extensively involved in documentation and end user training.
• Created business rules and workflow approval process for Hyperion Planning Application
• Maintained the security and assign access to users for planning application
• Developed report scripts to populate data, which was fed to the other cube.
• Involved in doing automation using MaxL and writing Calc scripts.
• Support existing cubes, problem identification, resolution and documentation.

Environment: Hyperion Essbase 9.3.1, Hyperion Planning, Hyperion Essbase Spreadsheet add-in, Oracle, DB2, Windows 2003, MAXL and ESSCMD