SUMMARY

• Over 6+ years of IT experience in design, development and implementation of OBIEE11g, Oracle Hyperion Financial Management and Hyperion Enterprise
• Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist
• Oracle Hyperion Financial Management 11 Certified Implementation specialist
• Full life cycle conversion, implementation and post production support experience
• Hand - on expertise in collecting, managing and documenting business and functional requirements and ability to create, translate and transform business requirements into functional requirements.
• Strong knowledge of software development life cycle (SDLC) including Waterfall, Agile Methodology, RUP having understanding of various phases like requirement, design, development and testing.
• Experience with various analysis methodologies, documentation processes, and project management tools includes: SDLC; Agile; Short-Cycle Iterations; Daily "Stand-Up" Meetings; Use Cases; UAT; MS-Project; SharePoint; eRoom; Visual Source Safe; etc.
• Defining test cases, creating test scripts, analyzing bug, and interacting with testing & developing teams in fixing errors.
• Expertise in preparing required documents for Computer System Validation (CSV) lifecycle, including Validation Master Plan (VMP), Installation Qualification (IQ), Operational Qualification (OQ), Performance Qualification (PQ) and Validation Summary Report (VSR).
• Performed Gap Analysis, understanding disparate Functional Processes, ability to identify and mitigate Risks and develop remediation plan.
• Experience in Corrective Action Prevention Action (CAPA), Change Control Process, Training, Investigations and Document Management Process.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository (.rpd) using Oracle BI Administration Tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
• Experience and proficiency in functional and technical development for Oracle Hyperion Financial Management application involving statutory and management consolidation. Experience in application implementation in different industry sectors. Solid understanding of consolidation architecture and solutions expected by client.
• Experience in integrating the development and implementation of Oracle Financial Data Quality Management with Hyperion Financial Management for data conversion and validation to ensure data integrity.
• Expertise in conversion of multiple source data for Oracle Hyperion Financial Management application.
• Experience working with on-shore, offshore, on-site and off-site individuals and teams. Extensive Competency in writing, reviewing and executing Validation Protocols as per federal regulations.
• Excellent Communication, Interpersonal, Analytical skills and strong ability to work with minimal supervision as well as a part of team.

TECHNICAL SKILLS

Enterprise Performance Management (EPM): Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist, 2014 Certified Oracle Hyperion Financial Management 11 Implementation Specialist, 2013 Oracle Hyperion Financial Management 11 Sales & Pre Sales Specialist, 2012 Oracle Hyperion Financial Management 11 Support Specialist, 2012

ETL Tool: Hyperion FDQM

Reporting Tool: Smart view, Hyperion Financial reporting

Operating Systems: Mac OS, Window 7/Vista/XP/2000, Linux

Other Tools: MS Office Suite, MS Project, SQL scripting

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Hyperion Financial Analyst

Responsibilities:

• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Performed gap analysis and feasibility study for the given requirement.
• Created mockup reports and dashboards for review by the business users.
• Responsible for System Requirement Specification (SRS) document.
• Metadata design, build from existing Enterprise hierarchy for entity, account and custom dimensions.
• Developing group chart of accounts (COA) and mapping group COA to individual entities COA
• Designed data model for rules like percentage of ownership calculation, Minority Interest, Dilution, Goodwill, Sale of Asset and Rollforward
• Used the security settings to setup users, Groups and Access privileges.
• Performed Data Validation of data in the reports
• Documented the design for intuitive understanding and future reference.
• Performed Go Live support for the project.

Confidential, Chicago, IL

Hyperion Financial Analyst

Responsibilities:

• Part of the core project team responsible for the implementation and Go Live of the project
• Requirement study of Entity Structure, Chart of Accounts, Business Logics for the design and built of applications
• Preparation and circulation of the Minutes of Meeting during the requirement gathering phase and all subsequent meeting to all project stakeholders
• Preparation of System Requirement Specification document
• Design of Metadata - Entity structure, chart of accounts, Intercompany, Journals, currency conversion.
• Design of multiple entity structure for statutory, management consolidation and one structure to hold the last 10 years of historical data.
• Development of calculation rule for various calculations like intercompany elimination, goodwill, currency conversions.
• Data analysis and data conversion for the data to represent the new set of entities
• FDQM design, import formats, location setup, security, custom scripting for GL integration from multiple source systems.
• Built over 200+ Smart view reports for Statutory and Management Reporting
• Testing of Application during various phases of development and coordinate with Customer Project Manager
• Preparation of Test Scripts for client testing and compilation of test scripts for all test results and changes to be incorporated.
• Preparation of User Training Material
• Provided multiple training sessions for Management users and business users of 22 legal entities
• Recruiting and training consultant for application support after Implementation and Go Live
• Loading of Exchange rates for conversion of local currencies to consolidating/parent currency
• Opening of Period in Financial Data Quality Management for entities to load their GL
• Generation of FDM status report for the management to ensure all the entities have completed the four fish process
• Parent consolidation of Statutory and Management entity structure
• Locking of the period in FDM and Entities in Hyperion Enterprise after the consolidation of the period.

Confidential, Dallas, TX

Hyperion Financial Analyst

Responsibilities:

• Assessed business priorities, and advised business units on risks, and costs versus benefits analysis, and ROI.
• Participated in all phases of the systems development life cycle, with emphasis on planning, requirements development and management, validation, and training.
• Developed and maintained document repositories, published communication plans, status reports, risk plans, issues logs, and schedules.
• Authored Test Cases and Test Scripts for User Acceptance Testing (UAT) and conducted various project management functions to plan as well as manage UAT.

Confidential, Philippines Manila, Philippines

Hyperion Financial Analyst

Responsibilities:

• Part of the core project team responsible for Requirement Gathering & Study, Implementation and Go Live of Management Consolidation
• Responsible for System Requirement Specification (SRS) document.
• Metadata design, build from existing Enterprise hierarchy for entity, account and custom dimensions.
• Developing group chart of accounts (COA) and mapping group COA to individual entities COA
• Designed data model for rules like percentage of ownership calculation, Minority Interest, Dilution, Goodwill, Sale of Asset and Rollforward
• FDM design, test, migration, import formats, location setup, security for data loading to HFM
• Complete setup of all Webforms and system reports (Rollforward, IC Matching, Journals).
• Managed client reconciliation of all Historical and Actual data using data forms, Smartview excel sheets, and ad-hoc analysis.
• Created all Income Statement, Balance Sheet, Financial Reporting Package templates and reports in FR and Smartview.
• Part of the Project Steering Committee and Responsible for preparing presentation to present of the Status of the project, tasks completed and the tasks lined for the coming week to the CFO, COO, Risk Manager, Consolidation Manager and Internal Auditors of the Client
• Responsible for working with Earnest&young for the Audit of the Application
• Preparation of System Requirement Specification document
• Testing of Application during various phases of development and coordinate with Customer Project Manager
• Preparation of User Training Material on Financial Data Quality Management and Hyperion Financial Management Application.
• Provided multiple training sessions for Management users and business users
• Financial Data Management Training included opening of a period, the four fish process of Import, Export, Validate and Check and generation of FDM Check report.
• Hyperion Financial Management training includes initial revalidation of data using data forms, posting of journals, consolidating of entity and submitting for review
• Consolidation Manager training include consolidating of all entities and locking the entity structure for the period

Confidential

Hyperion Financial Analyst

Responsibilities:

• Developed understanding of business requirements while working with business partners, subject matter experts (SME), enterprise architects, and application developers.
• Facilitated collection of functional requirements from system users, and prepared business and technical requirement specification documents.
• Review and approve qualification/validation protocols and reports (design & operations).
• Create Change Controls and managing change controls and create Validation Scripts.
• Served as liaison for various business units to gather requirements and resolve issues for the upgrade of existing ERP system.
• Performed planning and developed detailed schedules for all the projects; use MS Project Server to update and manage the schedule on a day-to-day basis and used it for reporting to client and upper management.
• Created all the required project deliverables as per standards and procedures. Met with client groups to convert user requirements into business requirements and user and functional requirement specification.