SUMMARY:

• Extensive experience of 8+ years in Analysis, Design, Development and Implementation of various Hyperion applications using Essbase and Planning modules along with expertise in ODI, Essbase Integration Services, Financial Reporting, Excel Add - In, Smart View, Web Analysis, MAXL, MDX Query and ESSCMD on Windows, UNIX and LINUX environments.
• Involved in the Entire Life Cycle of Hyperion projects, from Requirement gathering, Design, Development, Testing, Migration and Administration of Hyperion Planning and Essbase applications.
• Expertise in configuring the Hyperion security, creating the users, groups and in providing the access to the applications for users, groups by using the shared services and EAS console.
• Extensively usedEssbaseShared Services as centralized framework to create and maintain users for managing user security including external authentication using Lightweight Directory Access Protocol (LDAP)
• Expertise in migrating Essbase and Planning applications along with their artifacts from one environment to another environment using Life Cycle Management, Export and Import Utilities including Business Rules, Calculation Scripts, Data Forms, Rules Files, supporting details, security.
• Experience with Hyperion System 9 Planning, for planning and budget, metadata and rules maintenance, reporting and security.
• Expertise in creating data forms (web forms) for the business users to input the data and workflows.
• Hands-on expertise creating reports using Essbase Excel Add-In and Smart View Add-In.
• Experience in creating reports using Financial Reporting Studio, Web Analysis, Interactive Reporting
• Extensive knowledge in both Star Schema and Snow-Flake Schema data modeling techniques.
• Strong database development and business intelligence modeling capabilities such asEssbase calculation script and configuration settings.
• Good knowledge on Hyperion planning to create EAS applications, EAS security filters, modify existing and develop new database outlines, setting up dimensions, users, user groups and their security rights.
• Extensive experience on Software Systems analysis/ design/ development/ testing/ performance optimization and documentation.
• Experience and proficiency in functional and technical development for Hyperion Planning 9 application involving budgeting, strategic planning, forecasting and workforce planning. Experience in application implementation in different industry sectors. Solid understanding of Planning architecture and solutions expected by client.
• Strong experience in working with installation and configuration of Oracle Business Analytics ( EPM) versions
• Experience in integrating the development and implementation of Essbase with Hyperion Planning for organizational financial consolidation, strategic budgeting and planning, and advanced forecasting abilities.
• Experience and proficiency in multiple Oracle Hyperion installations, configurations for V7, V9, and V 11.1.2.x for Shared Services, Essbase, Planning, Financial Data Quality Management (FDM), Strategic Finance (SF), Interactive and Financial Reporting.
• Responsible for initiating Data Quality Management (DQM) through setting standards for Data Quality, Data profiling, Data augmentation and overall Data Integration.
• Experience in working through all phases of Software Development Life Cycle (SLDC) including the design, development, implementation, and maintenance of financial applications.
• Thorough knowledge of Hyperion Architecture, especially with client and server n-tier architecture, configuration management on Windows and UNIX based environments.
• Proficiency in Database Administration (DBA) such as enhancing security, database tuning, backup and recovery on different servers, platforms and operating systems.
• Experience and expertise in managing and administering numerous Essbase applications and cubes (Block Storage and Aggregate Storage), forms, reports, and books.
• Strong problem-solving, communication, interpersonal,, and presentation skills: over 60 presentations delivered especially in assisting end-users with developing complex reports using Essbase to meet analytical requirements and effective forecasting.

TECHNICAL SKILLS:

Software/Hardware: Hyperion Financial Reports - version 11.1.2.3/9. x, Hyperion Planning 11.1.2.3/9. x, Hyperion BI+, OBIEE version 10, Hyperion Enterprise v6.x, Hyperion EPM/BI, Hyperion System 9, Hyperion Web Analysis 11.1.1, Hyperion Essbase 11/9.x/7.X, EIS 6.X/7.X, MaxL, EssCMD, Hyperion Application Builder, Hyperion Reports 11/9.x/7, Brio 6.5, SQR, Hyperion Spreadsheet Add In Micro Strategy Web, Hyperion Analyzer, Essbase, Oracle 10i, DB2, MS SQL Server 2012/2008/2005, MS Access 7.0/2.0

PROFESSIONAL EXPERIENCE:

Confidential, Deere Field, FL

Hyperion Developer/Admin

Responsibilities:

• Involved in the Entire Life Cycle from Requirement gathering, Design, Development, Testing, Migration and Administration of Hyperion Planning and Essbase reporting applications.
• Responsible for the development of security for Planning and Essbase applications.
• Involved in the development of data flow process from various data sources in to Hyperion system
• Developed and maintained numerous business rules using Calculation manager for the Planning applications, MDX scripts for the Reporting applications and Rule files.
• Automated the metadata update process from SQL Server to all Hyperion Planning and Essbase applications using Oracle Data Integrator scheduler (ODI).
• Migrated the Planning, and Essbase reporting applications with their artifacts including data from one environment to other environment using Life cycle management, Import and export utilities.
• Automated the applications, database and data load process and security backups.
• Developed dynamic process for dimension and data loads using rule files for all the applications.
• Developed and maintained numerous Reports using Hyperion Financial Reporting Studio.
• Assigned filters for Planning and Essbase Applications through EAS and by using Shared Services.
• Automated the data loads, execution of calculation scripts, database backup process using MAXL.
• Developed test cases for the business users to for the easy testing of data in the applications.
• Migrated all the applications including Business Rules, Calculation Scripts, Data Forms, Rules Files, supporting details, security from development environment to production environment using LCM and import/export utilities.
• Tuned the existing applications for better performance by identifying the issues on priority basis and by modifying the server, application and database wise settings.
• Worked on Backup, recovery of the databases and their artifacts of the Hyperion applications.
• Updated the Initial design document and maintenance documents for the future purpose.
• Involved in Knowledge Transfer and of the business users about the new environment.
• Worked with Hyperion / Oracle support team to resolve Oracle EPM product related issues

Environment: Oracle EPM 11.1.2.3 (EPMA Environment), Planning, Essbase, Shared Services, Oracle Hyperion Smartview, Oracle Data Integrator(ODI), Financial Reporting studio, SQL Server 2008, Windows 2008.

Confidential, Alpharetta, GA

Hyperion Developer/Admin

Responsibilities:

• Developed a Multi-Dimensional Database (MDDB) application using Hyperion Essbase that stored and maintained company's financial and marketing data and performed the loading and manipulation of data into the database using Build and Load Rules files.
• Developed and maintainedCalc Scriptsforperforming calculations and developed member formulas for dynamic calculations and SignFlip
• Automated Hyperion Essbase Cubes to minimize manual entry through Batch File using ESSCMD/MaxLScripts. Removed errors occurring during the nightly dimension build and data load processes by referring to Log files.
• Involved in creating ASO Cubes for better performance, migrated BSO Cubes to ASO Cubes and also changed Calc Scripts to MDX.
• Involved in Performance Tuning to minimize data load time using the Dense/Sparse settings, responsible for performance monitoring, backup and recovery of the cubes and also implemented various troubleshooting procedures to recover databases.
• Responsible for new database design and implementation
• BAU support for both BSO planning applications and ASO reporting cubes.
• As a part of monthly forecasting activities validated the monthly hierarchy changes and validated the data loadedfrom upstream systems, seeding activities, validating the correct scenarios and substitution variables before opening the system for end users.
• Changed Calculation scripts, Business rules and data forms as per the change requests from Business.
• Extended support during the Metadata system transition from Microsoft MDM to Hyperion DRM.
• Maintained and changed report scripts with the changing hierarchy.
• Helped with Month end actuals close cycle and archiving activities.
• Worked with designing aggregations for faster report retrievals for new and existing reports.
• Helped with tuning multiple ASO applications for faster SmartView report retrieval performance.
• Involved in developing and fine-tuning existing MDX formula’s on Account members and variance scenariomembers in ASO reporting applications.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

Environment: Hyperion Essbase 11.x, Hyperion Planning 11.x,Hyperion Financial Reporting, Tableau Server 9.x/8.x, Tableau Desktop, Smart View, Essbase Excel Add-in, Hyperion Interactive Reporting,SQL Server 2005/2000, SQL Integration Services,SQL Server Reporting Services 2005, MS SharePoint Server 2007,MS SharePoint Designer, Crystal Reports XI, MS Access 2003,Oracle 9i

Confidential, Alpharetta, GA

Hyperion Developer/Admin

Responsibilities:

• Worked with Business Analysts to get the business requirements and to prepare the project plan.
• Created Essbase Aggregate and Block Storage Cubes.
• Designed General Ledger, Cost Center Accounting, Retail, Marketing, Subscriber Essbase applications.
• Developed load rules, calculations scripts, mdx formulae up to required detail for business reporting.
• Optimized cubes for faster loads, calculations and retrievals.
• Developed Windows batch scripts and Tidal scheduler scripts to automate the load process for the cubes through MAXL scripts.
• Created filters for maintaining various group level security for Finance teams.
• Prepared application document for new applications to train users.
• Developed various reports templates in Essbase Add-in for end users.
• Created reports and dashboards in Interactive Reporting on Oracle databases and Essbase applications.
• Provided Production support and maintenance of daily tasks on cubes.
• Assisted in system installation, configuration and software upgrades from Essbase version 7.1.6 to Hyperion System 9.3.1.
• Created test cases to test the new environment and existing applications
• Worked with Hyperion on configuring the odbc driver connection which pulls data from Teradata to Essbase.(sql interface)
• Worked with Hyperion configuring the Shared services.
• Created Classic Hyperion Planning application to leverage budgeting and forecasting for finance team.
• Developed Business rules for all the account metrics and aggregations.
• Created various Webforms for all the finance users to enter their budget data.
• Maintained dimensional level security on the groups and assigned respective Webforms for users.
• Acted as the point of contact for the users to help with their technical needs.
• Created automated scripts in MAXL to load actual data into Planning cubes.
• Responsible for new database design and implementation

Environment: Hyperion Essbase 9.3.1, Hyperion Planning 9.3.1 SQL Server 2005/2000, SQL Integration Services, SQL Server Reporting Services 2005, MS SharePoint Server 2007,MS SharePoint Designer, Crystal Reports XI, MS Access 2003, Oracle 9i

Confidential, Atlanta, GA

Hyperion Planning Admin

Responsibilities:

• Was responsible for complete Planning and HFM management of the project including security and provisioning.
• Was responsible for designingHyperion Planning applications for Planning, budgeting and Forecasting (PBF), Hyperion FDM, Hyperion Financial Reports, and web forms for planning users in the role of Hyperion Architect for financial systems.
• Was responsible for the UAT testing of applications.
• Involved in the installation, upgrade and migration of Hyperion Essbase version 9.x to version 11x.
• Created applications in version 11 as appear in the 9.3 for migration.
• Created users, groups and given provision according to their roles using shared services.
• Involved extensively in creating web forms for Hyperion Planning applications.
• Implemented highly formatted complex reports to produce charts and pivot tables using Hyperion System 9 Interactive Reporting.
• Implemented Interactive Reports by developingcustom dashboard using JavaScript and SQL.
• Implemented Hyperion System 9 Interactive Reporting row level security in Workspace for maintaining user security profiles.
• Created dashboards, gauges using interactive reporting.
• Was On-call person 24/7 for maintenance of Hyperion module
• Extensively worked on calculation, consolidation and allocation of HFM application data from General Ledger using Hyperion FDM.
• Involved in modifying and maintaining business rules for HFM applications.
• Custom Business Rules and custom dimensions formulated.
• Provided knowledge transfers/ of various Hyperion modules to technical engineers.
• Was responsible for performance tuning of Hyperion Planning and HFM applications.
• Worked closely with Hyperion Technical support to resolve Hyperion application and server issues.
• Designedmulti-dimensional database (MDDB) applications using Essbase that stored and maintained company's financial and marketing data.
• Designed Essbase databases using Hyperion Planning application to meet financial requirements.
• Used Supporting Detail feature to calculate aggregate values to build bottom-up values in Hyperion Planning.
• Generated annual reports, income statement and variance reports using SQR reporting.
• Created complex reports for analyzing financial date using different data sources in SQR reporting studio.
• Created Allocation Calc scripts using the Calc script editor for performing calculations.
• Automated theEssbase Cubesusing Esscmds and Batch Scripts.
• Weekly back-ups and monthly consolidations of data and automated monthly/quarterly/annual report generation developed Excel Templates for user interface in Essbase database.
• Smart view setups and designing the reports layout in the smart view.
• Involved in installation and administration of OBIEE version 10, Apache Tomcat and WebLogic.
• Coordinated with Change Management & Release team for OBIEE and WebLogic.

Environment: EPM,HFM 11/9.x, FDM 11/9.x, OBIEE version 10, HAL, Hyperion Financial Reports - version 9.x/7.x, Hyperion Web Analysis, BRIO, Hyperion Interactive Reporting version 9, Hyperion Planning 11.1.1/9.x Hyperion Essbase 11/9.x, Hyperion SmartView, Hyperion Shared Services 9.x,Essbase Integration Services 7.X, Oracle 10g/9i, Teradata, Unix (HP-UX 12)/ Solaris 9, Windows Server 2003.

Confidential

Hyperion techno Functional Consultant

Responsibilities:

• Developed batch scripts and rules files to upload dimensions and data from legacy systems to Essbase cubes, and developed rules for multi-dimensional databases.
• Created Planning application for forecast application for the titles.
• Created business rules based on the client requirements.
• Was responsible for creating capital expense plans and submitting them for approval in CAPX Planning.
• Integrated CAPEX Planning with Oracle Hyperion Planning, Fusion Edition data for reconciliation, forecasting, and reporting.
• Support complete project go-live and post go-live support including the new enhancements and loading data.
• Loaded data from the data source to a staging table using ETL tool Informatica
• Created Metadata outlines for cubes using integration services.Implemented Hyperion System 9 Interactive Reporting row level security in Workspace for maintaining user security profiles.
• Created actual vs. variance dashboards across the titles over the forecasted year using Interactive Also define Dimension rules and data load rules in FDQM-ERPI for loading COA and Actual.Done integration part (Source to target), configured the FDM, ODI, ERP adapters.
• Created Import Groups, Import Scripts and Integration Scripts for importing data into FDM Locations.
• Created logical schema, physical schema, work repository and master repository in ODI (Oracle Data Integrator).
• Created interface tables for metadata loading and loaded dimensions (Cost Centers) into shared library.
• Also worked on integration of ODI with FDQM-ERPI, like creating work repositories and Master repositories.
• Good understanding of legacy systems and their functionality.
• Involved in developing web forms applications, AssigningSecurity, Workflow procedures and developed several Essbase Planning applications which suit the business and for best performance.
• Developed report in Pivots, Charts, Reports, Dashboards, Financial reports.
• Developed Amortization, calendarization and variance reports for individual titles in financial reporting.
• Automated the cubes for data loading and dimension loading using HAL process and max scripts.
• Analyzed, designed and optimized the load rules to improve the Dynamic database updates and to optimize the Essbase database cubes performing the calculation scripts in order to calculate the data present in the Essbase cubes, Forecasting and to calculate Dynamic Time Series data.
• Developed MaxL scripts to automate daily backup and consolidations of monthly data.
• Created ESSCMD scripts to update outlines in batch, load data and execute calc scripts, during maintenance.
• Created VB scripts for excel-add in.
• Involved in administrative activities such as installation and upgrade of software products including ESSBASE, setting up users, security groups and access filters to set the security policy and to ensure maximum security.
• Automated the backup process using batch scripts.
• Experience in writing test cases and test scripts using Mercury Quality center(HP Quality center)

Environment: Hyperion Essbase7x/ 9.x, Hyperion Planning 3.5/9.x, Hyperion Interactive Reporting, IS-Integration services, Hyperion Financial reporting 9.x/7.x, Hyperion Web analyzer 9.x, Hyperion Application Link, Hyperion Planning, Oracle, SQL, PL/SQL,MS Excel Add-in, Outlook soft, Hyperion Essbase Spreadsheet Add-In, SQL Server 2005, Windows 2000, Unix.

Confidential

SQL Business Intelligence developer / Essbase Developer

Responsibilities:

• Worked extensively on detailed system analysis, design and development of the system lifecycle.
• Used ERD models for modeling designed logical and physical database architecture.
• Used Data Modelers before implementing the data model, giving inputs about the required indexes, constraints, foreign key relationships.
• Worked on Oracle and SQL Server databases.
• Worked on PL/SQL for writing Stored Procedures, Packages, Functions and Database Triggers.
• Developed PL/SQL scripts for back end validation/ updates.
• Used ASP and Developer 2000 for designing the client server applications.
• Developed Manual Test Scripts for unit testing.
• Performed Integration testing simulating a real time production environment.
• Developed reports using Crystal Reports.
• Created outlines for the Essbase cubes.
• Building ASO and BSO cubes.
• Developed Batch Scripts through Esscmd.
• Designed, developed, modified and enhanced the database structures and database objects
• Created different type of reports with charts
• Created Stored Procedures, views in SQL Server using T-SQL to collect data for the crystal reports
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports
• Created Packages to group logically related column types and to transfer data
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash

Environment: Oracle 7.x, Win2000, PL/SQ, SQL SERVER REPORTING SERVICES 2005, SQL Analysis Services, SQL Server 2005/2000, SSIS,DTS, BCP, SharePoint Sever 2003, Visual Source Safe 2005