SUMMARY:

• Oracle Planning and Budgeting Cloud Service (PBCS) Certified
• Oracle Business Intelligence Cloud Service (BICS) Certified
• Oracle Enterprise Performance Reporting Cloud Service (EPRCS) Certified
• Over 3 years of Technical & Functional experience in application architecture, design, analysis, development and administration of various financial applications in Client/Server environment using Hyperion Essbase, Hyperion Planning, Financial Reporting, Smart View.
• Skilled in Architecture design of Essbase Cubes ASO and BSO Cubes.
• Hands on Experience on meta - data management in Hyperion Planning.
• Hands on experience in running periodic budget and forecast reports in both Financial Reporting and Smart View in Oracle Essbase and Planning integrated environments.
• Solid knowledge of financial budgeting and forecasting, financial close and consolidation.
• Hands on data load experience with FDMEE.
• Personal You Tube channel with Hyperion Essbase, Planning and Financial Reporting Training Videos online.
• Provided Ticket Resolution Support to big companies such as Confidential and a dozen more to name.
• This wide spectrum of support provided me with the opportunity to experience and understand different financial consolidation, budgeting, forecasting and reporting models.
• Experienced and proficient in functional and technical development for Hyperion Planning 11 application involving budgeting, strategic planning, forecasting and workforce planning.
• Solid understanding of Planning architecture and solutions expected by client.
• Experience of 2 full migration and upgrade cycles of EPM system.
• Experienced in customizing Hyperion Planning application and integrating it with other systems.
• Skilled in automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating cubes in different environments.

TECHNICAL SKILLS

EPM Tools: Oracle Essbase 11.1.2.4x, Oracle Planning, 11.1.2.4x/ 11.1.1.3/9. x., Oracle Financial Reporting, Oracle Smart View, Financial Data Management Enterprise Edition (FDMEE), EPBCS

Dimensional Modeling: Star-Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Table Modeling, Physical and logical data modeling. Hyperion Analyzer, Hyperion Reports, MS-Excel Spread Sheet Add-in VBA and Crystal Reports 8.5..x, Hyperion Reports 9.x, Hyperion Enterprise Services, OBIEE, DRM.

ETL Tools: Oracle Data Integrator (ODI 11g)

Microsoft Tools: MS Office Suite, MS Visio, MS SharePoint

Databases & Tools: Oracle, SQL, PL/SQL, Toad 8.6, SQL Programmer

Environment: UNIX, Windows XP/Vista, Linux

Reporting Tools: Financial Reporting Studio, Web Analysis, Hyperion Reports, Hyperion Spreadsheet Add-in, Smart View

Project Management Tools: MS Project, Primavera Team Play Project Manager, Niku CA Clarity

PROFESSIONAL EXPERIENCE

Confidential, Arlington TX

EPM Support and Training Services Consultant

Responsibilities:

Currently working as a part of interRel's Support and Training Team, providing Support and Training Services to over 30 clients on Oracle Enterprise Performance Management (EPM), Business Intelligence (BI) and Reporting tools such as Oracle Essbase, Planning, Data Relationship Management (DRM), Oracle Data Integrator (ODI), Enterprise Performance Management Architect (EPMA), Financial Data Quality Management (FDMEE), Financial Reports (FR), Smart View (SV), Web Analysis and Essbase Excel Add-In. Our clients range from as health care and retail to manufacturing and banks, a great opportunity to get exposed to different infrastructures and environments and experience a variety of business models for financial consolidation budgeting and forecasting situations and get acquainted with reporting and optimization needs of different environments.

Technology/Platform: Oracle Essbase, Planning, ODI, Financial Reporting, Smart View, Data Relationship Management, HFM, OBIEE, ODI 11.1.1.5

Confidential, Baltimore, MD

Hyperion Financial Analyst

Responsibilities:

Maintained the Hyperion Suite Planning (Capex, workforce, Strategic finance) Essbase and Financial Reporting under Windows 2003/2008/NT4.0 environment. Worked with Client Installs/Issues with Excel add-in, Smart view and FR, Upgraded between different versions of Hyperion Suite, Worked and troubleshoot Apache Web Server, Migrated artifacts between environments using LCM, coordinated monthly accounting close processes, managed administration of the Hyperion System (Essbase, Planning) infrastructure to ensure a stable, optimized financial planning and reporting, managed applications, databases, took care of backups and restores; managed user security in Oracle Shared Services, ran and maintained background jobs through Batch Scripts, and took care of Essbase performance and optimization issues.

Technology/Platform: Hyperion planning, Essbase, Hyperion Smart View/Excel Add-In

Confidential

Data Analyst

Responsibilities:

Installed and Configured of Essbase Analytical Server, Administration Server and Administration Console, Essbase Excel Add-Ins and Hyperion Analyzer for development, tests and production environments, developed and tuned Essbase including Outline, Rule Files, Calc Scripts, Reports, database optimization, created batch files and Maxl Scripts to automate the data load process, dimension building, calculations and backups, created Calc Scripts and MaxL Script for process automation and database calculating, migrated artifacts and data to new production server and supported end user, planners for budgeting, daily and weekly back up process as well as Data loading job monitoring, created repository for Hyperion Planning Application, involved in loading data using data load utility and migrating Essbase and Planning applications on regular basis.

Technology/Platform: Hyperion Essbase 11.2.x.x, Hyperion planning 11.2.x.x, Shared Services, Hyperion Smart View, Excel Add-in, oracle 10g, Unix.