SUMMARY

• Over 8 years of Experience in Information technology with efficient, result - oriented, design & development of OLAP and decision support systems with focus on Oracle Hyperion Suite of Technology.
• Profound working experience with ESSbase, Hyperion Planning, Hyperion Financial Management, Hyperion Financial reporting, Smart View and Excel Add - In.
• Worked on end - to - end implementations of Hyperion projects (HFM, Essbase, and Planning).
• Strong expertise in OLAP design, analysis, architecture, development, implementation, reporting, administration, and migration of various applications in client/server environment using Oracle Hyperion Financial Management, Oracle Financial Data Quality Management, Oracle Hyperion Essbase, Hyperion Planning, Essbase Integration Services, Hyperion Reports, Essbase Spread Sheet Add - in, and Essbase Query Designer under Windows and UNIX environments.
• Worked on upgrade projects for HFM/Planning/Essbase from 7.x/9.x to 11.x, 9.x, 11.1.x to 11.1.2.x Strong expertise in developing reports using Financial Reporting Studio, Web Analysis and Smart View.
• Strong expertise in development, production support and administration oriented tasks for Hyperion EPM products.
• Strong expertise in creating and deploying HFM and Planning applications in classic and EPMA mode used for budgeting and forecasting purpose.
• Strong expertise in creating data grids and web data forms to load and post data, and also scheduling the journals to adjust data.
• Page 2 of 7
• Designed complex security model for HFM, Planning, and Essbase applications as per client requirements.
• Created various complex HFM rules for the consolidation applications.
• Migrated applications across environments using LCM process and copy application utilities.
• Designed Dashboards and drill down capabilities using global and filtered settings, and security setups.
• Strong experience in building of custom Dimensions, Smart Lists, and Substitution Variables.
• Designed the ETL process of HFM applications using FDM as the ETL tool.
• Automated production jobs after application go - live. Used Autosys, Tidal, Windows scheduler for automation purposes.
• Designed backup and recovery process for Hyperion Financial Management and FDM applications.
• Strong understanding of multidimensional and relational database architecture; extensive knowledge of planning, budgeting, and forecasting procedures.
• Strong expertise in creating, maintaining, and supporting all application objects including Outlines, Calculation Scripts, Rules files for Dimension builds and data loads, Transparent partitions, and Security objects through both Essbase Administration Services (EAS) and Maxl scripts; also involved in automation of these procedures using batch scripts.
• Strong expertise in issue resolving and in optimizing the performance of HFM and Planning applications.
• Strong expertise in designing Business Rules, Complex Web forms, Work Flow, Task List, and smart list, planning units.
• Strong expertise in developing Essbase Rules Files, Calculation Scripts, Member Formula and Report Scripts.
• Experienced 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, and Netezza.
• Created documentation for maintenance and support for Hyperion products.
• Strong expertise in trouble shooting, Knowledge transfer, preparing technical document and training the clients.
• Provided 24x7 server support Hyperion services and day to day production job.

TECHNICAL SKILLS

Applications: Hyperion Financial Management (HFM), Financial Data Quality Management (FDM), Hyperion Planning, Hyperion Essbase, Essbase Administrative Services (EAS), Workforce Planning, Hyperion Analyzer, Hyperion Integration Services (EIS), EPMA

OLAP: Hyperion Essbase System 11.1.x/ 9.x/ 7.1.6/6.5.4.2

Reporting Tools: Hyperion Financial Reporting 11x, 9.3, Smart View, Excel Add In, Visual Explorer, Crystal Reports, Cognos.

Languages: MDX, MaxL, Calculation Script, PL/SQL,XML, C/C++, Java .

Databases: Essbase, Oracle 12c/11g/10g/9i, MS SQL Server 2008/2005/2000

Operating Systems: Windows XP, Windows Server 2008/2015 R2, Unix/Linux, Solaris, AIX

MS Office Tools: MS Word, Excel, PowerPoint and Visio

Utilities: Toad, SQL Navigator, SQL*Plus, Hyperion Financial Reports, Hyperion Web Analysis, Web Analysis, Hyperion Interactive Reporting Studio, Hyperion Smart View, Essbase, Spreadsheet Add - In, Oracle Data Integrator (ODI), DRM, Outline Load Utility, Informatica, Data Stage, MS Office (Excel, Work, PowerPoint)

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

Senior Hyperion Developer Consultant

Responsibilities:

• Providing analytical and technical expertise end - to - end implementation of Hyperion applications including Planning, Financial consolidations, strategic finance from requirement gathering to production deployment
• Designed foot print and sizing for EPM upgrade infrastructure.
• Installed and configured Oracle EPM suite 11.1.2.4
• Performed patching for various modules in Hyperion suite.
• Performed integrations between different source systems to target Hyperion systems.
• Performed SAP integration with FDMEE to target HFM application in 11.1.2.4 leveraging custom built bristlecone adapter.
• Migrated Planning, HFM, HSF, DRM, FDQM/ERPI (FDMEE), HSS applications from 11.1.2.1.600 to 11.1.2.4
• Build hybrid Essbase for planning application that is being for Income statement.
• Performed tuning and optimizing planning/ESSbase applications as per the environment.
• Build report and smart view templates that leverages HSget functions to pull the data.
• Automated the daily admin activities and enabled the functionality of monitoring the process through emails.
• Developed business requirements documents based on the analysis of the current business model.
• Used LCM to migrate applications across environments (Dev to Test, Test to prod, etc.).
• Updated hierarchies and performed data loading using Oracle Data Integrator and Data Relationship management.
• Provided knowledge transfer and development transition to other team members and to production team (onshore and offshore).
• Contributed to on time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Provided documentation related to administration of the Hyperion applications.

Confidential, Dallas, TX

Senior Hyperion Financial Management Consultant

Responsibilities:

• Providing analytical and technical expertise end - to - end implementation of Hyperion financial consolidation applications from requirement gathering to production deployment
• Developed 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.
• 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.
• Created and loaded Metadata for HFM consolidation Budget and Actuals using EPMA to generate variance reports.
• 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.
• Page 4 of 7
• Automated data loads from different departments into HFM using FDM Task Manager.
• Designed and modified HFM rules to perform various functions
• (consolidation, calculation, currency translation, etc.) Created financial statements in Financial Reporting 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 files.
• Performed set up of journal entries, intercompany transactions, eliminations, exchange rate conversions.
• Entered foreign exchange rates grids and their entries for balance sheet and income statements.
• Assisted in HFM/FDM annual SOX audits by providing documents, data and reports to internal/external auditors.
• Performed maintenance backups 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 Essbase privileges on them.
• Created and assigned provisioning for all the appropriate Users/Groups in the Shared Services
• Used LCM to migrate applications across environments (Dev to Test, Test to prod, etc.).
• Updated hierarchies and performed data loading using Oracle Data Integrator.
• Provided knowledge transfer and development transition to other team members and to production team (onshore and offshore).
• Contributed to on time completion of all assigned tasks and desirables meeting the business expectations and timelines.
• Provided documentation related to administration of the HFM applications.

Confidential, Iselin, NJ

Senior Hyperion Financial Management Consultant

Responsibilities:

• Designed and developed Hyperion consolidation application based on business requirements.
• Managing Metadata and defining attributes and creation of application profile.
• Created HFM applications for desktop and web - based clients.
• Loaded data and created data grids and data forms for viewing.
• Completed proper settings for POV (Point of View) and set up security users, groups, security classes, and access rights).
• Extracted, loaded, and modified Metadata whenever changes occurred.
• Created the Journals according to business requirements.
• Managed the financial review cycle using Process Management.
• Ran consolidation process after loading the data.
• Generated financial statements using HFR for business users.
• Heavily involved in year and month end close processing 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 Financial Data Quality Manager and HFM consolidation.
• Involved in the preparation of Detail Unit Cost, Price and Volume Trends, Expense Variances and Profitability reports.
• Performed data loads and Calc Script optimizations.
• Automated and scheduled cube building using MaxL and Shell scripts.
• Created various filters according to business requirement in EIS.
• Involved in the installations and configurations of ODI 11.1.1.5
• Fine–tuned existing applications for better performance by identifying issues on a priority basis and by modifying server, application, and database settings.
• Provided knowledge transfer and training of the business users about the new environment.
• Worked with Hyperion and Oracle support teams to resolve product related issues.

Confidential, Malvern, PA

Hyperion HFM/FDM/Essbase Analyst

Responsibilities:

• Provided analytical and technical expertise for Hyperion Financial Data Management and Financial Data Quality Management modules.
• Interacted with business users for gathering requirements and converted them into technical specifications.
• Worked closely with ETL and SAP teams for source data.
• Created, configured and maintained HFM and FDM Applications.
• Involved in design and development of Account, Entity, ICP and other dimensions in HFM and FDM Applications.
• Created database outlines according to business requirements.
• Designed and implemented data load processes.
• Developed and implemented dimension and member attributes dynamically.
• Modified and fine-tuned Essbase applications and databases.
• Designed and developed OLAP cubes.
• Involved in creating databases, outlines, and applications. Developed Calc scripts, created test environments, and restored databases from backups to repair corrupt database.
• Optimized database outlines by arranging the dimensions.
• Designed and implemented FDM data load processes.
• Creating data grids and data forms.
• Responsible for financial reports, developing new reports and modifying existing reports.
• Created rules and testing and loading into application.
• Integrated FDM Applications with HFM Applications by creating mappings between FDM and HFM Applications for loading data.
• Created validation rules in FDM for ensuring data integrity between source and target systems.
• Worked on reconciliation and loading on operational financial data and extensive use of FDM and HFM.
• Extensively used Workspace for performing general HFM Web and Reporting activities.
• Extensively used Smart View for data verifications during User Acceptance Testing (UAT) and post go–live maintenance.
• Created financial reports for external and internal reporting.
• Trained end users on Workspace, FDM Web, and financial reporting.
• Applied security levels to users for Application Objects and Locations within FDM.
• Maintained users and security for FDM and HFM Applications using Shared Services.
• Performed detailed documentation of tasks, processes and optimization requirements based on run times during data load and application builds.

Confidential

Business Analyst

Responsibilities:

• Provided analytical and technical expertise for Hyperion Planning and Essbase.
• Identified new customer requirements and developed design specifications for the system.
• Presented analysis and system design specifications to the senior management and worked with the product development team to develop the application.
• Led the design and development phase for the automation framework of the product.
• Deployed the framework at the end user location and used it to analyze system risks and mitigate them.
• Managed a team for design and maintenance of framework for cross–platform software; efforts resulted in 30% improvement in number of defects found in given period and in reduction of the operation cost for the client
• Analyzed customer requirements and created the design specifications for the development team.
• Performed gap analysis and developed and deployed the software at the end–user location and signed off the product after UAT.
• Led the client’s team at the end user workplace and led daily customer team meetings and led the acceptance testing team for product deployment at the client location.
• Awarded the annual Best Team Award.
• Involved in defects review and resolution meeting with the development team.
• Initiated business analysis for optimizing technology solutions and convinced customer to accept critical changes which led to 40% improvement in operational performance.
• Developed and define the quality assurance process for the product and executed use case scenarios.
• Analyzed the product through the complete Software Development Life Cycle (SDLC) including development, deployment and future releases of the product and worked on identifying and mitigating the risks in the product.