PROFESSIONAL SUMMARY:

• Over 16+ years of IT experience. Hyperion Manager with 12+ years of hands - on Essbase, Planning, Web Analysis, Financial Reporting, Financial Management, FDM, DRM and DRG experience
• Strong experience in design, analysis, development and Administration of various financial applications in Client/Server environment using Hyperion Essbase, Hyperion Planning, Web Analysis, Hyperion Work space, MaxL, MDX, Essbase Spreadsheet Services. Hyperion Smart View Reports, Hyperion Financial Management, Financial Reporting Studio, DRM and DRG
• Knowledge of business and requirements analysis, business process modeling, Project planning and creation of use cases.
• Supported teh Design and development of Essbase applications with excellent balance of dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO).
• Skilled in Automation, Optimization and Performance Tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
• Supported teh development of new reporting and analytical solutions to help provide teh best reports for teh business.
• Implementation of Continued enhancement of policies and procedures for ensuring teh security and integrity of Hyperion systems
• Manage and Maintain HFM V9 with financial planning, reporting, analysis projects and month end accounting functions.
• Manage and Maintain Oracle EPM system V11 with all accounting and month end functions.
• Monthly data uploads from ERP system and reconciliation of data into HFM via FDM.
• Yearly Statutory Reporting in HFM.
• Dependable, efficient, detail oriented with a strong work ethic.
• Excellent business sense combined with solid technical skills.

TECHNICAL SKILLS:

• HFM / FDM
• Hyperion Planning
• Hyperion Essbase
• Web Analysis,
• FR Reporting
• DRM / DRG
• Excel
• SmartView
• PowerPoint
• Access
• Visio
• MS Project
• SAP
• JDEdwards

PROFESSIONAL EXPERIENCE:

Lead Consultant

Confidential, White Plains, NY

Responsibilities:

• Design and Requirements gathering for teh DRM solution
• Creation of a one DRM application
• Creation of one consolidated Version which will contain all hierarchies
• Metadata Import - Gather extracts from teh Planning application in production and HFM application in development and load teh metadata into DRM
• DRM Property Creation
• Creation and customization of teh Oracle Hyperion application property definitions applications
• Population of teh property definitions with teh appropriate values
• Hierarchy Rationalization - Rationalize similar hierarchical structures and combine them where appropriate
• Node Prefixing - Prefix distinct nodes based on node types and hierarchies
• Validations - Build validations that will protect teh integrity of teh metadata stored in DRM
• Metadata Exports - Create export processes to support both teh Planning and HFM applications
• Batch Processes - Create batch processes to support teh scheduled and ad-hoc running of metadata exports
• Validations - Build validations that will protect teh integrity of teh metadata stored in DRM
• Workflows - Create workflows that allow teh request and approval of metadata changes
• Security Setup - Set up access for teh CST DRM administrators
• Complete Testing - Unit testing, User Acceptance Testing (UAT) and Performance Tuning
• Migrating tested applications to production environment
• End User Documentation defining user tasks
• Leading role in analysis, design, development and implementation effort in 10 workshops for Cost Management Forecasting and Budgeting.
• Worked with a team to design, build, test, and deployment of a multi-million-dollar implementation of Hyperion Planning, Hyperion Essbase, and Hyperion Reports at a multi-billion-dollar company.
• Worked with a team for an enterprise-wide Hyperion Planning, Essbase and Reports implementation for a large Aerospace firm. Teh design of this solution included detailed Cost Management Planning for 10 Complex Business Segments.
• Developed training materials and lead training sessions for users on Hyperion Planning applications.
• Supported teh design and development of BSO and ASO applications.
• Utilized business acumen and solid technical skills to gather requirements and lead workshops.

IT Project Manager

Confidential, Buena Park, CA

Responsibilities:

• Provided month end support
• Coordinated outline maintenance for chart of accounts in 10 cubes
• Researched and resolved customer issues and questions
• Automated several time consuming manual processes (data validation and manual dimension builds)
• Optimized elimination calc scripts
• Designed, developed and created custom Essbase applications, which allowed business units to plan in detail and submit summarized data for one consolidated corporate plan.
• Gatheird and documented all user requirements for new cubes
• Analyzed and documented existing databases
• Developed all new Essbase objects
• Performed unit, integration and data validation tests on all new databases and coordinated cut-over activities
• Designed process to convert historical data from old databases into correct format for new databases
• Designed and developed new overnight batch scheduling process

Environment: Hyperion Financial Mgmt. 11.1.1, Hyperion Essbase 11.1.1.3, Hyperion Reports 11.1.1.3, Hyperion Planning 11.1.1.3, Hyperion Analyzer 11.1.1.3, Hyperion Administration Services 11.1.1.3, FDM, MS Excel 2003, Smart View, MS Project, Oracle 10g, SQL Server and Windows 2003 Server.

Senior Financial Systems Analyst

Confidential, Buena Park, CA

Responsibilities:

• Provided financial data and other Ad Hoc reporting and special projects.
• Manage and maintain teh processes of teh Fixed Assets and teh integrity to teh General Ledger.
• Developed a one stop Executive Dashboard on Hyperion Analyzer to track Sales and Marketing trends.
• Established a budgeting system using Microsoft Excel to load into Hyperion that improved time for 52 divisions to input their budgets.
• Responsible for System administration of Hyperion Planning, Reports and Essbase, HFM and FDM.
• Improved relations with and reduced turnover among mid-management and support staff.

Senior Financial Systems Analyst

Confidential, Commerce, CA

Responsibilities:

• Assisted in teh implementation of SAP.
• Consolidate and manage financial reporting for 22 facilities within teh region.
• Developed a budget process for teh region.
• Created databases to better maintain fixed assets and track capital expenditure reporting.
• Improved payroll accuracy and reduced payroll processing time in half.
• Served as facility’s LAN Coordinator. Established plant-wide computer security procedures and directed several training classes resulting in significant efficiency improvement.
• Designed and implemented access databases for various departments within teh region.
• Provided leadership and direction as a “Key” member of teh plant Safety Committee.