SUMMARY:

• More than 7 years of top diversified Information Technology (technical and functional) using Oracle, Hyperion Fusion edition (11i - 11.1.2.X, 11.1.1.3), product include an extensive technical working experience.
• Hands on EPM Cloud - PBCS, FCS, Enterprise Performance Reporting Cloud and Data management, and integration with Oracle EBS and SAP ERP,
• Hands on “On Premises” of Hyperion 11i Fusion Edition, Hyperion Planning, HFM, FDMEE, Essbase, FR Studio, Smart View, Calculation, Script, ERP integrator and BI Tools
• Hyperion Planning and Financial Administrator Expert by Oracle
• I have Built over 200+ reports include complex reports which required special conditions, formulas, and formats in short period.
• Provide quick resolution to issues and work with servers, DBA, Finance and accounting users and network team to achieve results
• Core knowledge of Hyperion administrator and developer role, application management and deployment, security, and user maintenance, ETL load process, data import and cleansing, dimension library, Metadata synchronization, Data load, consolidation, Data Form, Rules, Calculation, Multi-Currency, dynamic reporting, Intercompany, Adjustments and Reports
• Possess excellent analytical and communication skills including the ability to train and mentor team and users, involve with users, provide user and system presentation to users
• Excellent skills in gathering requirements, working with End users, stakeholders, develop prototype, multi environments maintenance - DEV, UAT, TEST, PROD, involve users at all level, work with DBA for installation Patches, ERP integrate with Oracle General Ledger and other applications.

CORE COMPETENCIES:

• Oracle Hyperion 11i fusion edition
• Hyperion System 11i 11.1.2.4.x
• Hyperion FR Studio, WEB studio
• ETL and Data load
• Oracle EBS, BI
• System 9 upgrade to 11i

MAJOR ASSIGNMENTS:

Confidential, San Jose, California

Hyperion Consultant

Responsibilities:

• Assign to various assignments
• Responsible for multi - deployment of Oracle-Hyperion Financial Management 11i fusion 11.1.2.4.X, Oracle Cloud PBCS, FCC, FR WEB Studio, FUSION Reporting, and on premises, Data integration, FR Studio, FDMEE, ETL process, Reporting studio, BI and Essbase.
• Part of Hyperion team on several full life cycle implementation of Hyperion Financial management FR Reporting for Hyperion planning and Consolidation global projects
• Built over 250 reports include complex reports which required special conditions, formulas, and formats
• Created multiple books and batch schedule to load and run reports such as monthly quarterly and annual reports packages
• Designed various Forms for Planning and Budget activities.
• Gather requirements, documentation, developed prototype, setups, configuration, Application administration, Security, dimensions setups, Hierarchy solution, Elements, Metadata, Data Loading, Members properties setups, Journal, Build ETL for multiple sources, SAP adaptor and interfaces for FDMEE, Create Locations and Formats, Rules, Calculation, Dynamic reporting, Intercompany, Multi-currency, Exchange rate, Shared Service Models, Business Rules, Task, Data Forms, Page & POV, Web analysis, Financial reporting, SmartView, calc scripts and Menu
• Hands on FR studio, Create reports for Hyperion enterprise as well as ERP Fusion systems.
• Install and support user community for SmartView and FR reports
• Work with DBA for installation Patches, stabilized the application, integrate with Oracle General Ledger, Legacy systems, and file systems
• Design and implement corporate and enterprise reporting with dynamic POV

Confidential, Houston, TX

Hyperion Developer/ Analyst consultant

Responsibilities:

• Responsible for Hyperion Planning, HFM, FDMEE, and Essbase projects including Hyperion technical Financial reporting, Web forms, life cycle management, calculation manager and support for Hyperion Planning and Financial Management 11i fusion 11.1.2.X include EPM, Workspace, shared services deployment, ETL load process, bug fixing, applying patches with quick turn around
• Responsible for development and configuration of FR Studio, SmartView, FDMEE, and support PBCs, and HFM applications
• Provide Support to Hyperion team to finish open issues and provide best practice solution
• Install and support Reporting studio, web analysis, SmartView and configure EPMA application on multi-environments
• Provide best Reporting solution in the industry include design hierarchies, Dimensions, setup, user and successful implementation provide best solution
• Develop various load processes, prototype, setups, configuration, Application administration, dimensions setups, Mapping, data mapping, load, validate and transfer data from source to target, Hierarchy setup, Elements, Metadata, Data Loading, Members properties setups, Journal, Data Form, Rules, Calculation and formulas, Dynamic reporting, Task, Data Forms, Page & POV, Web analysis, Financial reporting, SmartView

Confidential, Cleveland, Ohio

Hyperion consultant

Responsibilities:

• Responsible for Hyperion Planning, Financial reporting, HFM, Essbase, calculation manager and support for Hyperion Financial Management 11i fusion 11.1.2 include EPM, Workspace, shared services deployment, ETL load process, fixing, applying patches with quick turn around
• Full life cycle implementation of Hyperion BPM, HMF, Essbase, SmartView and Oracle CRM - Sales and Marketing, HRMS & CPM. From proof of concept, scope to execution of entire project. Configuration the application according to the customer needs, Setups actual vs. budgets Cube, forecast, CAPEX budgets. Built many interface and integration with several source systems and import data into FDM include complex Business rules which required special conditions, mapping formats, locations, configuration, formulas, and formats
• Install and support Reporting studio, web analysis, SmartView and created over 200 reports including financial reports
• Develop various load processes, prototype, setups, configuration, Application administration, dimensions setups, Mapping, data mapping, load, validate and transfer data from source to target, Hierarchy setup, Elements, Metadata, Data Loading, Members properties setups, Journal, Data Form, Rules, Calculation and formulas, Dynamic reporting, Task, Data Forms, Page & POV, Web analysis, Financial reporting, SmartView

Confidential, New York, New York

Hyperion Developer

Responsibilities:

• Responsible for development and design of Financial reporting, FDM 11i, HFM, Essbase, SQL, calculation manager and support for Hyperion Financial Management 11i fusion 11.1.2 include EPM, Workspace, shared services deployment, ETL load process, bug fixing with quick turn around
• Provide Support to HFM team to finish open issues and provide best practice solution
• Install and support FDM, reporting studio, web analysis, SmartView and configure EPMA application on multi-environments
• Develop prototype, setups, configuration, Application administration, dimensions setups, Mapping, data mapping, load, validate and transfer data from source to target, Hierarchy setup, Elements, Metadata, Data Loading, Members properties setups, Journal, Data Form, Rules, Calculation and formulas, Dynamic reporting, Task, Data Forms, Page & POV, Web analysis, Financial reporting, SmartView
• Prepared documentations and provide
• Built over 50 reports include complex reports which required special conditions, formulas, and formats

Environment: Windows, UNIX, Client/server, Oracle eBusiness, Hyperion system11i, Hyperion, HFM, FDM, FR Studio, SmartView MS Office.