FCCS expert
WILLIS TOWERS WATSON
Total years of experience :14 years, 5 Months
Technical Environment : FCSS, Data Management.
Responsibilities:
• Gathered business requirements and turned them into practical consolidations and reporting solutions.
• Collaborated with finance and accounting teams to gather and analyze financial consolidation and reporting requirements.
• Provided effective solutions in building complete FCCS solutions including metadata, Financial Reports, Web forms, SmartView, and security.
• Configured FCCS application components, including optimal dimension configuration, web forms / task list definition, Smart View templates in line with business, functional and performance requirement
• Provided support and troubleshooting for Oracle EPM applications, including identifying and resolving issues in a timely manner.
• Currently leading team of 3 people.
Technical Environment : FCCS, Data Management
Responsibilities:
• Worked on developing FCCS components
• Worked on maintaining metadata in FCCS
• Worked in security and process management
• Explored and implemented data locking process in FCCS
• Developed artifacts starting from Metadata creation/updates, designing web forms and data grids.
Technical Environment : HFM 11. 1.2.3, Smart View, Oracle, Windows
Responsibilities:
• Provided support services to Hyperion projects such as data loads and web analysis.
• Maintained project documentation and formulated functional requirements.
• Maintaining metadata, FDM maps and managing data transfers between applications including HFM
• Perform troubleshooting and root cause analysis of system issues, escalating to Oracle Support when necessary.
• Manage security both at the application level and Shared services level of the applications when required.
• Responsible for ensuring that all applications perform optimally at all times.
• Responsible for ongoing maintenance and production support activities of Hyperion System components including resolving production issues.
Technical Environment : Essbase 11. 1.2.3, Hyperion Planning 11. 1.2.3, HFR, Smart View, Oracle, Windows.
Responsibilities:
• Building of dimensions and hierarchies based on design documents.
• Creation of Outline, dimension build and Rule file according to the requirement.
• Involved in assigning Security for Hyperion Planning applications using Hyperion Shared Services.
• Created Web forms using Hyperion planning Web client.
• Created Menus, Smart List in Hyperion Planning.
• Worked on planning applications like Revenue, Budget and created and managed numerous data entry forms in Hyperion planning.
• Worked on support activities on Planning and Essbase Application.
Role : Hyperion Essbase Developer Environment : Hyperion Essbase 11. 1. 1.3, Hyperion Financial Reporting, Oracle, Windows.
Responsibilities:
• Involved in discussions with business users to derive requirements.
• Developed a multi-dimensional database (MDDB) application using Essbase that stored and maintained companys financial and marketing data and performed the loading and manipulating of data into the database using Load Rules Files.
• Developed Outlines based on the requirements specified.
• Loaded data into the outline developed for each data cube.
• Developed and implemented dimensions and member attributes.
• Involved in Outline modifications, optimization, building cubes.
• Creating users and groups in shared Services and assigning Roles and provisions.
• Assign the filters and users for groups in Shared Services.
• Optimized the database by configuring Sparse and dense dimensions.
• Maintained Outline Metadata and Member formulas as per Business requirements.
Hyperion Consultant role, working on Hyperion Planning and Essbase Applications.
Hyperion Essbase 11.1.2.3, Hyperion Planning 11.1.2.3,
Hyperion Financial Reporting, Smart View, Oracle, Windows
First Division