SUMMARY

• Having 7 years of experience in analysis, design, development and implementation of various applications using Hyperion Essbase, Hyperion Planning, Financial Reporting,Hyperion Financial Data Quality Management (FDQM), ERPi, Web Analysis Reports, MAXL, ESSCMD, Smart view and Essbase Spreadsheet Services (Excel Addin) in Windows environment
• As a Hyperion Essbase/Planning Consultant, Experience in interacting closely with clients, gathering requirements, doing GAP analysis, analyzing functional business requirements and translating them to technical modules, design application & integrate with source systems, develop business rules, reports as per requirements
• Has exposure and working experience on latest Oracle EPM Suite 11.1.2.2 and 11.1.2.3
• Expertise in handling Hyperion projects independently as well as in team, end to end.
• Expertise in automation process by developing MAXL scripts and batch scripts
• Quick adaptability to new technologies and zeal to improve new skills continuously
• Excellent analytical, logical, communication skills, familiar with the SDLC methodology of system development
• Having knowledge in Databases Oracle, SQL Server, MS Access

TECHNICAL SKILLS

Operating Systems: Windows XP, Windows server 2003/2008/2012 , Linux

Database: Oracle 10g/11g, Essbase, SQL Server 2000/2005/2008/2012

Office Tools: MS Word, MS Excel, Power Point, MS Access

Web Servers: IIS 6.0/7.0, Apache Tomcat, Oracle HTTP Server

Application Servers: Web Logic Server

Hyperion Tools Skill Set: Hyperion System 9.x / Hyperion EPM 11.x (11.1.1.1 - 11.1.2.4 ) Essbase, Planning, HFR, Smart View, HFM, FDM/FDMEE, Shared Services, Workspace

PROFESSIONAL EXPERIENCE

Confidential -Buffalo Grove, IL

Sr. Hyperion Essbase/Planning Consultant

Responsibilities:

• Gather requirements and provide technically feasible design
• Understanding cash flow model, funds flow model, revenue and cost model, expense models and creating business rules.
• Working closely with business users, identify key areas of improvement and automation by understanding existing pain areas with Hyperion implementation
• Developed functional as well as technical documentation of the existing Essbase cubes and financial reports to transfer knowledge for users, for administration and support
• Involved in all aspects of Hyperion Planning and Consolidation Design, Development: Dimension build, load rules, data load, Calculation scripts, business rules, data forms, data grids, task lists, process management and workflow
• Involved in writing complex Essbase calculations scripts, automation of Essbase Cubes using MaxL and MDX
• Developed Excel VBA code using macros and formulas to model and create financial reports to be used with Essbase.
• Used Hyperion Essbase Excel Add-In and Smart View for data manipulation and report creation
• Regular Daily maintenance activities, support and enhancement activities both Essbase BSO and ASO applications
• Assessment of existing system, Optimization and performance tuning of Planning and Essbase application data/metadata processing, upgrading, testing and migration of cubes across different environments
• Actively involved in taking daily requests (Ad-hocs) from users and fixing them.
• Daily Backup of Hyperion Planning, Essbase applications and restore applications from prior backup as required.
• Data refresh as per users demand, data transfer to another Essbase Cubes/other Hyperion Systems.
• Performing weekly, monthly and yearly activities such as archiving, monthly actuals load, user training, resolving issues through Sales Force (ticketing System)
• Creating groups, assigning access in Shared services, creating filters to provide cell level security and block level security.
• Backup and Recovery of Hyperion applications. Scheduling daily backups.
• Experience with Change/Incident/Problem Management.
• 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.
• Decisive with strong leadership qualities and flexible in work schedules.
• Responsible for Migration of application from One Environment to other.
• Responsible for looking into the performance issues, Disc space.
• Responsible for applying the needed Patches.
• Knowledge of Change management for the System/Infrastructure Changes.
• Server Administration, installing latest patches, automated backup and restoring application from backup as required.

Environment: Hyperion Essbase 11.1.2.3, Shared Services 11.1.2.3, ASO & BSO, Smart View For office, Spread sheet add-in, Interactive reporting,Financial Reporting, Oracle 10g

Confidential -Rochester, NY

Sr. Hyperion EssbaseConsultant

Responsibilities:

• Hands-on experience in Hyperion Essbase, Hyperion Financial Reports/Web Analysis and HyperionPlanning in Windows and Linux environment.
• Experience in both Waterfall&Agile development methodologies.
• Involved in the Hyperion suite installation, Multi server environment configuration, Clustering and Load Balancing.
• Configured SSL Hyperion Products and user directory connection to MSAD
• Involved in requirement gathering, estimation and impact analysis for new development of cubes, reports and backend process.
• Involved in creating, modifying calc scripts, web forms, batch scripts using MAXL/ESSCMD as per the business requirements to solve production issues.
• Automate data load process with MAXL scriptsand scheduled to run Calc scripts after every data load.
• Created multiple cubeswith BSO technology and with multiple databases under each application to support partition and data mapping between databases to achieve corporate level reporting.
• Created and Managed Filters onEssbase cubes to restrict the access to the data for various intersections based on user privilege.
• Performed tuning by using the Dense/Sparse settings and developed the required alternate rollups for reports.
• Created Multiple Hyperion Financial Reports, Web Analysis Dashboards, based on the requirement.
• Created Multiple Template’sof Smart View and Excel Addin for every day analysis of the user.
• Created the metadata for applications, considering future enhancements and current scope.
• Created alternative hierarchies to meet the reporting needs.
• Created the Security Matrix and implemented the complete security for various set of applications.
• Responsible for writing allocation logics, Data loading activities, Building forms and reports on to meet the business requirements.
• Participatedin testing with end user, created test cases for individual data intersections and executed test cases and recorded results to compare with originals.
• Implemented a complete maintenance sequence using VB Scripts, Batch clients, Maxl commands through which the applications performance has been enhanced.
• Involved in setting up the Production environment, Server side Performance tuning.
• Involved in the migration activities - from UAT to Production as a part of Go-Live activity.
• Involved in creating Batch files that will sync the newly added metadata from Master library to the respective applications in EPMA.
• Entire budgeting cycle was completed as a part of Warranty support, did the currency translation for those required entities and delivered flawless reports as expected.

Environment: Hyperion Essbase 11.1.2.3, Shared Services 11.1.2.3, ASO & BSO, Smart View For office, Spread sheet add-in, Interactive reporting,Financial Reporting, Oracle 10g.

Confidential -San Antonio, TX

Sr. Hyperion EssbasePlanning

Responsibilities:

• Created and managed planning applications using Classic and EPMA.
• Created and managed applications and Databases - BSO, ASO,Multi currencyand reporting applications.
• Import /export metadata and data using outline load utility, planning import and export, FDMEE, EPMA etc.
• Worked on financial statements - Income Statement/ P&L account, Balance sheet, Cash flow, Revenue.
• Setup Dimension Build Files to load dimensions to Essbase.Setup load rule files to load data from data warehouse into Essbase Cube.
• Create calculation scripts to generate quarter end financial metrics and future scenarios
• Proficient working with Data forms -Simple, Composite, Master composite form, adhoc grid etc.
• Create, manage and launching calculation scripts and business rules in planning as per the business requirements.
• Familiar with Project finance, Operational planning and expenses, Forecasting module experience.
• Used Smart view - To view, import, manipulate, distribute, and share data in MS Excel interfaces.
• Maintain the planning security system-User management, security file, control access using filters& groups.
• Hyperion planning administration activities - Maintain and optimize planning.
• Hyperion lifecycle management administration (migration to & from DEV, UAT & PROD).
• Version adjustment and copy version setup & procedures.
• Expense allocation modeling, enhancements and modification.
• Familiar with planning infrastructure activities - Installation, Configuration, Backup, Restore, Migration, planning services, High availability etc.

Environment: Hyperion Planning 11.1.2.3, Shared Services11.1.2.3, Excel Smart View, Report Scripts.

Confidential - Blue Bell, PA

Hyperion Essbase Developer

Responsibilities:

• Coordinated with business analysts / clients to understand and develop an optimized Essbase cube.
• Gathered requirements and developed a project plan.
• Prepared an optimized data source.
• Developed aggregate storage cubes (ASO) using Essbase.
• Developed a transparent partition with ASO / BSO cubes to leverage advantages of both technologies.
• Developed rule files for loading data and for dimension build.
• Implemented robust data-access security and user management.
• Automating of cube refresh through MaxLand UNIX Scripts.
• Optimized data loads and calculation scripts and maintained existing Essbase cubes.
• Optimized the applications to reduce runtime.
• Retrieved reports using Excel Add-in and generated batch reports using Hyperion reports.
• Maintained the OLAP application and took regular backups.
• Provided technical guidance and support to end-users by developing appropriate documentation.

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

Confidential

Hyperion Technical Analyst

Responsibilities:

• Involved in installation of Hyperion on a new environment and applied all patches.
• Designed BSO Cube as per the requirement.
• Setup Dimension Build Files to load dimensions from Oracle Database to Essbase.
• Setup load rule files to load data from data warehouse into Essbase Cube.
• Developed the application, batch scripts to do automation i.e., dimension build and data load.
• Created Maxl script to automate the dimension update and data load process.
• Created calculation scripts to calculate the key financial metrics.
• Created calculation scripts to generate quarter end financial metrics.
• Setup allocation rules to run allocations.
• Define Smart Slices in smart view and grant it to the users.
• Build standard financial reports and operational reports using Financial Reporting tool.
• Involved in the automation process for data load, tuning, backups and adhoc reports too.
• Migrated the application from Development to QA to Production.
• Created Daily Brief Report by looking at the existing Excel reports using Hyperion IR studio.
• Worked on Validation Reports to verify the conversion of Databases. Validating the Source and Destination Schemas.
• Developed various scripts like Date for the reports to run automatically in the specified time period like Monthly, Weekly, and Daily.
• Provided 24/7 on call Production support.

Environment: Hyperion Planning, Hyperion Essbase System 9, Hyperion Financial Reports,Hyperion Planning System 9, Oracle 9i & Windows 2003.

Confidential

PL/SQL Developer

Responsibilities:

• Actively involved in interacting with front end users and gathered User Requirement and Online System Specification.
• Created number of database objects like tables, views, indexes, synonyms and materialized views using SQL Loader.
• Involved in creating procedures, functions, packages and triggers to facilitate functionality in different modules.
• Created data mapping files for the data coming from different web services.
• Developed ad-hoc Reports (SQL or PL/SQL scripts running in Unix System) to extract data from database and deliver to user in Excel format.
• Created audit tables and implemented complex business logic using triggers.
• Used cursors, for cursors and Ref Cursor (dynamic SQL) for fetching data and processing it.
• Avoided Mutating table errors by using different methods like pragma autonomous transaction, statement level trigger and multiple triggers.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Developed ETL sessions for initial full loading and incremental loading.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Developed ETL sessions for initial full loading and incremental loading.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Monitoring nightly ETL batch flow and resolving the issues and directing it to concerned person.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on requirement analysis, coding and testing various modules in a software development life cycle.

Environment: Oracle Database 9i, Toad, SQL*Plus, SQL* Navigator, SQL*LOADER, UNIX, Forms Builder 6iReports Builder 6i.

Confidential

PL/SQL Developer

Responsibilities:

• Interacted with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• For complex business queries involving multiple tables from different databases used Joins, correlated and non-correlated sub-queries
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of requirements.
• Enforced business rules via checks and constraints.
• Developed SQL queries to fetch data as per the business requirements with proper tuning techniques.
• Developed and tested extraction, transformation, and load (ETL) processes
• Analyzed the requirements and framed the business logic for the ETL process.
• Created checks and constraints to maintain data integrity across the data in the database.
• Created Stored Procedures to generate various Drill-through reports and functions to support efficient data storage and manipulation.
• Migrated actuate code of data extract to PL/SQL equivalent and Created PL/SQL functions, packages, procedures and joins.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Worked on various back-end Procedures and Functions using PL/SQL.
• Wrote necessary PL/SQL API scripts for successful running of the programs.
• Monitoring nightly ETL batch flow and resolving the issues and directing it to concerned person.
• Created required technical documents, technical specifications, and test results.
• Scheduled SQL Server Agent Jobs to run every day to update changes in the base tables.
• Used Exception Handling for handling errors of programs, scripts and procedures

Environment: Oracle 9i, SQL*Loader, SQL, PL/SQL, TOAD, UNIX, Windows XP.