SUMMARY

• Having 8+ years of IT Experiences in Design, Analysis, Development and Administration of various EPM system components.
• Experience in design, analysis, development and implementation of various applications in Client/Server environment using Hyperion HFM/FDM 9.X, 11.X in Windows servers.
• Strong ability to work with corporate finance units to formulate business and data requirements, good understanding of distributed architecture.
• Experience in implementing, supporting and enhancing consolidation systems using HFM (Hyperion Financial Management) and its suite of products
• Expertise in designing security for workspace, HFM, HFR through Shared Services and managing the Groups and members for the applications.
• Extensive Knowledge of end user tool Smartview and design Smartview templates
• Experience in working with Oracle to patch, upgrade and troubleshoot Oracle EPM environment.
• Knowledge and experience with Hyperion product Family (Reports, DRM, and Essbase) and have hands on experience in using additional utilities delivered by Oracle.
• Experience in support and administration of various applications in Client/Server OLAP environment.
• Experience in Application modules to create application profile, Metadata, Member list.
• Experience in creating data grids, web entry forms, ICP, Member List and journal templates for posting adjustment in HFM
• Extensive knowledge and understanding of all the phases involved in Software Development Life Cycle (SDLC).
• Strong analytical and organizational skills with an ability to deliver on agreed timescales. Demonstrated experience of working in team.
• Have good experience working in onsite - offshore model and coordinating with multiple vendors to get the work done.
• Highly motivated Team player, self-starter with excellent verbal and written communication and presentation skills. proven leadership skills, Responsible and accountable for internal control performance within own area of responsibility, outstanding problem solving and analytical abilities.
• Ability to learn new systems, practices, and software quickly and effectively. Sophisticated professional with demonstrated ability to present and communicate to senior executives.

TECHNICAL SKILLS

Hyperion: EPM 11.1.2.4/11.1.2.3/11. x/9.x

ETL: HAL, DIM, ODI

Programming Languages: SQL, MAXL, ESSCMD, UNIX, PEARL

RDBMS: Oracle 10g/11g/12g, MS SQL Server 2005/2008

GUI &Reporting Tools: Hyperion Financial Reports and Web Analysis

IDE: EAS, FR Studio, Toad

Internet Tool: HTML, DHTML, XML

Operating Systems: Windows 2003/2008, XP/Vista, UNIX, LINUX

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

HFM/FDM Administration and support

Responsibilities:

• Manage monthly financial consolidation process and coordinate data submission/load process from ERP.
• Setting up dimensions members (Metadata), loading data/Metadata, and provisioning security access to users and ensure consolidations run.
• Creating Locations in FDM and provide financial control access to users based on the Reviewer or Submitter roles for certification process.
• Assign and maintain all security roles and systems access within HFM.
• Provide day-to-day support to the various users of HFM and support to the global HFM user community
• Developing Grids, Data Forms, ICP and Journal templates for much statutory reporting geography.
• Create HFM user manuals and training materials, as well as provide training to the global HFM user community.
• Work with other IT teams in ensuring efficient operation of HFM application.
• Ensuring that internal controls are in place and appropriately designed within the application and operating effectively in compliance with Sarbanes-Oxley (SOX).
• Providing technical and functional support to the users in the areas of HFM, FDM, HFR and Smartview
• Data migration from Prod to stage after Qtly reports published.
• Preventive maintenance activities like Removal of data/task audit logs, shrinking of audit and error logs tables in database, restart of HFM services etc.
• Analyzed Issues in 11.1.2.2 and apply needed Patch sets.
• Installation and configurations of EMP suite of products in 11.1.2.2 in Windows 2008R2
• Knowledge of Improving Performance Tuning for all the Hyperion Products.
• Worked Closely with Oracle Support team and close the issues we faced by raising Oracle SR.
• Worked Closely with Hyperion support Development team in fixing the Issues.
• Supporting the End users on Client install issues, Tracking the issues with Incident management tickets.
• Responsible for Migrations from Development to QA and QA to Production.
• Performance tuning and Optimization of the Applications for the fast data loads, better consolidation times and fast retrieval of the reports
• Infrastructure Support - Server Maintenance like File system Space Management, moving Backups to staging server, Exports and OS as well as Hyperion Patches.
• Maintenance of user security and troubleshooting user access issues as they arise.
• Monitoring the current Production environment servers for performance and stability.
• Maintenance and Support for HFM, HFR and FDM Applications and Other Hyperion Products.
• Participated in the application testing, while monitoring the system performance, thereby reporting any anomalies in the application.
• Defined and documented the steps to migrate applications in the HFM and FDM between Prod, QA, and Dev environments.

Environment: EPM Suite 11.1.2.2, Oracle Web Logic 10.3.x, IIS Admin, Windows 2008 server, Toad, Putty, Smart view, Excel Add-In, Linux.

HFM Developer/Tester/Support Specialist

Confidential, New York

Responsibilities:

• Designed and developed complex reporting system, provide user, system production support and administration to Corporate Finance IT group.
• Responsible for creating Web entry forms, Data grid, Creating journal templates, Creating task flows, Creating users groups, users and providing access
• Testing activities include metadata testing, Rules, Data load Validations, Web entry form, grids, Journals, ICP, FDM and FR functionality testing.
• Maintenance and Support activities include task automation, process management, Data load through FDM, Journal load, Running consolidation, User access, addressing user issues, Loading mapping filed in FDM, analysis, and statistics monitoring activities operations.
• Worked closely with multiple levels of the organization including management teams to support key systems, implement infrastructure improvements and ensured business units are able to operate efficiently and effectively.
• Demonstrated experience interfacing and collaborating with peers, management, vendors, and other departments.
• Communicating status and vision to management and stakeholders.
• Change management, Version Control and training for a successful deployment of the new process and system.
• Taking the lead in gathering business requirements for new enhancement of applications and coordinating the delivery of multiple projects using Off-Shore and On-Site peers.

Environment: EPM Suite 11.1.3.3, Oracle Web Logic 10.3.x, IIS Admin, Windows 2008 server, Smart view, Excel Add-In.

HFM Administrator / Support Specialist

Confidential, Rockleigh, New Jersey

Responsibilities:

• Lead the Offshore team for any on-going tasks on all Hyperion System projects /enhancement /support activities.
• Providing L2 Support - Resolving tickets/Issues rose through various channels like Phone, Email, and Service Desk tool.
• User Management & Provisioning through Hyperion Shared Services
• Metadata Management & Maintenance as per changes in the Business environment
• Providing technical support to end users who have problem in the areas of Hyperion Workspace, Hyperion Smart view for office
• Resolving all HFM infrastructure related issues
• Reconfiguring HFM based on changes in the Prod/QA/Dev environment
• Resolving all data integration(SAP and HFM) issues
• Preventive maintenance activities like Removal of data/task audit logs, Shrinking of audit and error logs tables in database, restart of HFM services etc
• Gathering new requirements, collaboratively with clients and my onsite counterparts and leading the offshore team to get the deliverable on time.
• Improved performance of HFM, Researched workarounds to optimize the application.
• Trained and supported HFM users.

Environment: EPM Suite 9.3.3,/ 11.1.3.3, IIS Admin, Windows 2003/2008 server

HFM Administrator / Support Specialist

Confidential, New York

Responsibilities:

• Update Metadata as per the change request from business on monthly basis.
• Testing the changes made to metadata and rule fie using grids.
• Conduct check out with the business and technical support team for finalizing the changes made to the metadata.
• Restarting service before Actual reporting starts to avoid performance issue.
• Administered security, created users and groups and provisioned them with specific roles and assigned HFM security classes in user management console.
• Extract/load metadata whenever metadata changes occur.
• Scheduling Consolidations and translations using job scheduler for Actual, Budget, Forecast and Business Plan as per Business requirement on daily basis.
• Handling tickets raised by users.
• Involved in creating various POC’s for presenting to the customer.
• Conducted HFM training to end users.
• Created SOP’s for troubleshooting and created presentations for HFM Demo.
• Coordinate with the source system team to load data to HFM

Environment: EPM Suite 9.3.3, IIS Admin, Windows 2008 server, Smart view, Excel Add-In.

HFM Developer

Confidential, New York

Responsibilities:

• Gathering and analyzing the requirement from the Client.
• Create and deploy applications and designing metadata.
• Build metadata for Accounts, entities, Scenario and custom dimension.
• Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.
• Managing POV in the explore data setting.
• Updating Rules as per client requirement and creating Translational function as per the Business requirement.
• Posting inter-company transactions and make adjustments using journals.
• Creating Journals Templates for adjustments.
• Involved extensively in generating MIS Reports using Hyperion Financial Reports.

Environment: EPM Suite 9.3.3, IIS Admin, Windows 2008 server, Smart view, Excel Add-In.