PROFESSIONAL SUMMARY:

• IT professional with 8 years of experience with emphasis on Oracle Hyperion Business Intelligence Application Development, Deployment and Support.
• Experience in OLAP design, Analysis, Architecture, Development, Implementation, Reporting, Administration, and Migration of various applications in client/server environment using 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 End to End Hyperion Planning and Essbase Implementations from requirement gathering to production deployment.
• Configured the source and target adapters in HFM from FDM and created the machine profiles
• Extensive knowledge in Hyperion Business Rules (HBR), Oracle Data Integrator (ODI), and Essbase Calculation scripts, Essbase Commands and Essbase functions.
• Experience in Working with Aggregate Storage Cubes and Block Storage Cubes. .
• Expertise in administrative tasks of Essbase: managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, MaxL, MDX Querying, Report Scripting, thorough understanding of Essbase data mining framework.
• Proficient as Essbase Administrator in maintaining Essbase, managing database settings, optimizations, thorough understanding of ASO and BSO cube architecture, Essbase Cache settings, optimizing calculations, attributes, and storage security, optimizing reports.
• Designed and developed numerous cubes and Multi-dimensional databases both ASO and BSO in Essbase with excellent balance of dense and sparse dimensions allocation strategy, developing various OLAP Models and Meta-Outline.
• Worked on Hyperion Planning to create applications, security filters, modify existing and develop new database outlines, business rules, setting up dimensions, users, user groups and their security rights.
• Experience and expertise in managing and administering numerous Essbase applications and cubes (Block Storage and Aggregate Storage), forms, reports, and books.
• Extensive knowledge in writing SQL for data analysis and query various data sources.
• Created Queries & Answers, Pivots, Charts, Dashboards in the Oracle Business Intelligence (OBIEE)
• Created complex and simple reports from relational/ Multi-dimensional databases using OBIEE
• Worked on the EPMA as well as Classic applications for the Planning applications.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Experienced in Oracle Data Integrator (ODI) and Financial Data Quality Management (FDQM) to load both metadata and data and extracting data using outline data extractor.
• Substantial experience in creating, maintaining, and supporting all application objects including outlines, calculation scripts, rules files for dimension building and data loading, creation and optimization of transparent partitions, and security objects through Essbase Administrative Services (EAS), MaxL, MDX queries, and ESSCMDs.
• Solid understanding of Multidimensional and Relational database architecture; Extensive knowledge of planning, budgeting, and forecasting procedures.
• Experience 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.
• Excellent experience in debugging procedures by developing and implementing test cases.
• Created documentation for Development applications and provided end user training.
• Excellent communication, organizational and interpersonal skills.

TECHNICAL SKILLS:

OLAP Tools: Hyperion Essbase 11.x/9.x/7.x/6.x, Excel Add-In, Essbase Integration services 9.x/7.x, Essbase Studio 11.x, ESSCMD, Maxl, Essbase administration services 11.x/9.x/7.x, Hyperion Enterprise performance suite 11.x, Hyperion Interactive Reporting 11.x/9.x/8.x.

GUI: Visual Basic 6.0/5.0, TOAD, Application Manager, SQL Developer

Business Intelligence Tools: Hyperion Planning 11.x/9.x, Hyperion Financial Management Suite (HFM) 11.x/9.x, OBIEE 11g/10g

Reporting Tools: Hyperion BI+ (Web Analysis 9.x, Financial Reporting 11.x/9.x) Hyperion Reports 7.x/9.x,Hyperion Analyzer 7.x, Hyperion Excel Add-in, OBIEE 10g/11g, Smart View.

Scripting Languages: Unix shell, Maxl, PERL, ESSCMD, MDX.

ETL Tools: Informatica 8.x,6.x,7.x, Data Integration Manager

Dimensional Modeling: Star: Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables, Physical and logical data modeling

Programming Languages: PL/SQL, C, C++, JAVA, HTML, DHTML, XML

Databases: Essbase, Oracle 11i/10g/9i,SQL SQL Server 2005/2008/2012 , DB2, Netezza, Sybase 12.5

Operating Systems: MS: DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Senior Hyperion Essbase HFM/Admin

Responsibilities:

• Worked from End to End implementation from requirement gathering to production deployment as part of this application development.
• Design, develop, and implement enterprise-wide budgeting, forecasting, and financial reporting cubes.
• Conduct project requirement gathering sessions, document project requirements, define tasks, estimate timeline and identify resource requirements.
• Used FDM in building Workflows, Mappings, Locations, Import Formats, Control tables to load Monthly data in HFM Application.
• Automated Data loads from different departments into HFM using FDM Task Manager
• Assisted in HFM/FDM annual SOX audits by providing documents, data and reports to internal/external auditors
• Involved in 60% Development (HFM, FDM, Hyperion Planning, Essbase, and Interactive & Financial Reports) and 40% Administration (Upgrades, Migration and Installations of Hyperion products
• Worked on the installations of EPM 11.1.2 versions and migrated applications from 9.x to 11.1.2
• Efficiently manage project timeline and deliverables to ensure integrity of project scope and costs to meet project deadlines and deliver on time and on or under budget.
• Developed Oracle / Hyperion Planning and Essbase solutions - specializing in Workforce Planning, Capital Expenditure and also have extensive experience building Revenue, Capital, Income Statement, Balance Sheet, and Cash Flow statements using planning applications.
• Created EPMA and classic applications for the planning development purposes.
• Created .ads files for building the application dimensions using EPMA file generator.
• Used ODI as the ELT tools for the metadata maintenance of classic and Essbase BSO/ASO applications.
• Performed daily and weekly back up process as well as Data loads using Maxl and ODI processes.
• Created complex and simple reports using Excel Smart view, Hyperion Reporting.
• Wrote new, and optimized existing calculation scripts, batch commands and scripts in MaxL
• Modified Business Rules to cater to the changing business requirements
• Maintained security for Planning, Business Rules and Essbase.
• Wrote custom SQL to retrieve data from various data sources and integrated the result sets as a feed to Essbase applications.
• Provide detailed documentation and knowledge transfer to enable the client to manage the solutions created for them.
• Created reports from relational/multi-dimensional databases using OBIEE for various reporting purposes.
• Conduct training sessions for clients to demonstrate Oracle/Hyperion Planning product enhancements and best practices.
• Installed ODI as a Service in DEV, UAT and PRODUCTION environments.
• Designed ETL using ODI to integrate various source system data to Hyperion applications.
• Create UNIX backup scripts for ODI and involved in designing the Master and Work Repositories as well as security.
• Maintained all three Hyperion Essbase platforms, namely Development, UAT and Production.
• Migrated applications and security from one environment to other using Hyperion LCM process.
• Created Hyperion applications Security matrix and Hyperion Financial Reports as per client's request.

Environment: Oracle Essbase 9.x/11.x, Hyperion Planning 9.x/11.x,Financial Reporting, FDM, Web Analysis, Essbase Admin Services (EAS), Essbase Integration Services, Autosys, MAXL, Excel Add-In, Unix Shell scripts, MDM, Hyperion Application Link/ODI, Oracle 11i, SQL Server 2008, MS Excel Add-in, Unix.

Confidential, East providence, RI

Hyperion Essbase Planning/Admin

Responsibilities:

• Migrated Hyperion Planning/Essbase applications from 9.3 v to 11.1.2 v
• Installed EPM Version 11.1.2 Version on all environments and configured all the services related to Hyperion.
• Validated Metadata and Data related to Planning and Essbase applications after application migration.
• Created Import Groups, Import Scripts and Integration Scripts for importing data to the Locations in FDM.
• 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
• Configured users and access rights in FDM.
• Applied security levels to users for Application Objects and Locations within FDM
• Build rule files, calculation scripts, report scripts, substitution variables for the BSO cubes
• 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.
• Developed Maxl scripts and Batch scripts for scheduling dimension building and data loading.
• Involved in testing the performance of the scripts in UAT and preparing test cases and results.
• Created a transparent partition for the ASO cubes as target for BSO source cubes to enhance reporting.
• Created a replication partitions from all LOB (Lines of Business) applications BSO to Reporting BSO application to refresh Summary level data.
• Created groups and users for different business segments and then assigned security and filters to define Essbase privileges on them.
• Extensively used calculation commands and functions to improve the performance of applications. Developed Calc Scripts for complex calculations and optimized them.
• Involved in migrating applications and it’s artifacts from Dev to Test and from UAT to Prod on UNIX.
• Loaded data into the cubes from text files, CSV files and used SQL Interface
• Created and assigned Provisioning for all the appropriate Users/Groups in the Shared Services
• Created reports based on the business user requirement using Hyperion Financial Reporting and Smart View
• Created around 50 Business Rules as per the complex business requirements
• Created multiple Task Lists, Menus, Smart List and 40 web forms as per the client requirements.
• Performed Optimization and Performance tuning of the ASO and BSO cubes.
• 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.

Environment: Hyperion Essbase 9.3/11.1.2, Hyperion Planning 9.3/11.1.2, Hyperion Financial Reporting 9.3.1/11.1.2 (HFR),FDM, Hyperion Web Analysis 9.3.1/11.1.2 , Hyperion Shared Services, ODI 10.1.3, Excel Spreadsheet Add-In, VB Script, Smart View, Window Server 2003/2008 R1, Oracle SQL Developer 2.1.1.64, Oracle 10.204

Confidential, Herndon, VA

Hyperion Planning/HFM Consultant

Responsibilities:

• Created, configured, designed, and implemented new HFM and Planning applications in 9.3.1
• Created, configured, designed applications in FDQM and ODI.
• Loaded metadata into HFM application by creating load metadata file. And also created Application profile and assigned its frequencies and number of years.
• Loaded data into HFM application by using ODI AND FDQM.
• Maintained users and security for FDM and HFM Applications using Shared Services
• Registered HFM application with shared services and also assigned security class.
• Managed metadata by defining Dimension and its attributes, Application settings, Account types, consolidation methods, currencies, Intercompany transactions.
• Also Managed Member list, journals, Rules using Rules editor and Data forms.
• Created data forms in HFM application using form builder for users to input the data. Also created data grids in HFM application for consolidating financial data. And used consolidation and forced consolidation method for consolidation method in HFM application.
• Applied FDQM for imports, validations, exports, and checks on data with Hyperion Planning 9, HFM 9.3.1. Developed Planning data forms, involved in initiation of budgeting process, setup of Planning calendar, setup of currencies and exchange rates, customization of reports, and development of alias tables.
• Applied Hyperion Financial Reporting to design specific financial reports to serve management requirements.
• Developed security management (user management) on Hyperion Financial Data Quality Management (FDQM).
• Done all Data Modeling using FDQM, like importing source data, validating source data, exporting data to target systems and consolidating target systems.
• Combined Intercompany and Accounts dimensions on HFM to view intercompany transactions. Ran intercompany matching financial reports for the same.
• Involved in creation of Calc scripts, Rules for Hyperion Essbase Database and Application
• Performed Essbase calc script tuning and debugging as well as enhancements.

Environment: Oracle/Hyperion System 9.3.1, EAS 9.3.1, Excel Spreadsheet Add-In, Hyperion Planning 9.x, Web Analysis, Interactive Reporting, MaxL, Oracle 10g,, HFM,FDM, Workspace, Shared Services

Confidential

Software Tester

Responsibilities:

• Writing test cases to compare the data between source and target databases.
• Maintaining test cases in HP Quality Center and also logging defects.
• Writing complex SQL queries to check the Views built on the source tables and to compare data between source and target
• Testing the source data for data completeness and data correctness.
• Checking the PL/SQL procedures that load data into the target database from standard tables.
• Testing flat file data in Unix environment by using complex Unix commands
• Coordinating with offshore team for testing purposes on daily basis and help them in understanding the requirements and also escalating their issues.
• Testing the various ETL processes that were developed.
• Preparing various test scenarios and share across the offshore team.
• Testing the XML messages generated by the DVL in SOAP UI.
• Attending daily scrum meetings and updating QA tasks.
• Testing the data in front end vs. backend database.
• Writing different test scenarios and executing them.
• Reporting issues to developers and tracking them to closure.
• Performing Functional testing, System testing, Integration testing, Retesting, Regression tests and Sanity testing.
• Planning all the QA tasks and User stories for a given sprint
• Participated in Go - No Go meetings when the product is ready to go into production..
• Worked closely with DSO team to analyze the mapping document and also to help clean the source data.

Environment: SQL, HP QC, XML, Informatica, UNIX, PL/SQL