SUMMARY:

• Well - qualified IT professional having 10 years of experience with sound technical skills, and a passion for resolving complex problems or business challenges through innovation. Adept at maintaining focus on achieving bottom-line results while formulating and implementing advanced technology and business solutions to meet a diversity of needs.
• Experience in design, analysis, development, implementation and support of Hyperion Planning, Hyperion Essbase, Hyperion Financial Management, EPMA, HFR, Shared Services, FDMEE, ODI Integration and Smart view.
• Involved in Installation and Configuration of Hyperion Products.
• Involved in developing the Applications, calculation rules, business rules, the webforms in Hyperion Planning, Essbase and HFM.
• Experienced in Disaster Recovery (DR), High Availability (HA), Load Balancing (LB).
• Integrated ERP systems (Oracle EBS) in order to extract and load data into the target HFM applications using FDMEE.
• Good work experience in BSO cubes & Knowledge in ASO cubes.
• Expertise on SSL configuration and Active Directory configuration.
• Provide 24/7 support to the Hyperion applications during month end and quarter end close periods.
• Skilled in Automation, Optimization and Performance Tuning of Hyperion financial management, Essbase application, upgrading, testing and migrating of cubes in different environment.
• Experienced in all stages of SDLC that includes duties like providing documentation on design, testing and migration from development to production.
• Excellent team player with good interpersonal, multitasking and Communication skills along with hardworking, fast learning and prioritizing capabilities.
• Flexibility to change/leverage with any new technology.
• Knowledge on SQL
• Having Knowledge on python.

TECHNICAL SKILLS:

Tools: Hyperion Financial Management 11.1.x/ 9.x, Planning 11.1.x/9.X/, Hyperion Essbase 11.1.x/9.x, FDM 11.1.x, DRM, EPM, FDMEE, Tally

Database: Oracle 8.2/9.1/10/11 g, DB2 7.1/8.1, MS-SQL Server 7.0, SQL, PL/SQL

OS: UNIX, Linux, Windows 2008,2012 R2

Web Server / Application server: Microsoft IIS, IHS, OHS, WebLogic, WebSphere

Reporting Tools: Hyperion Financial Reporting, Smart View, Web analysis

WORK EXPERIENCE:

Confidential, Atlanta, GA

Hyperion Consultant

Responsibilities:

• Performed installation, configuration, Patching, Performance tuning and upgrade of Hyperion products (Hyperion Essbase, Planning, HFM, ODI, FDMEE, EPMA, HFR) 11.1.2.x to 11.1.2.4.
• Responsible for migration / LCM of Hyperion Essbase, Planning, Hyperion Financial Management to 11.1.2.4.
• Troubleshooting critical issues in timely manner to- ensure the SLAs (Service level agreement) are met.
• Build Disaster recovery for Hyperion system
• Perform security analysis and deploy latest patches (Hyperion, Java patch, OHS, and WebLogic) to address security issues.
• Involved in performance testing for Hyperion application.
• Experience in Setup full SSL (OHS, IIS, WebLogic) and MSAD configuration
• Performed Defragmentation in QA/ Production environment to improve the performance of the application.
• Provided 24/7 Support for Hyperion applications and SmartView related issues.
• Integrated source systems to HFM, Planning, and Essbase applications using FDMEE.
• Performed Security update by Provisioning and refreshing users/groups and recreating security filters Hyperion application in QA/ Production environments upon the request.
• Optimize Essbase application, Hyperion Planning and database process
• Involved HFM, planning and Essbase application development.
• Developed Automated reboot server script, Maxl script, logs backup, Data and Task audit scripts.
• Developed calc scripts, Data forms, Task list as per business requirement

Environment: Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, HFM, FDMEE, DRM, Windows 2012 R2, ODI, HFR, Oracle DB, Smart view, BMC Remedy.

Confidential

Senior Technical Consultant

Responsibilities:

• Responsible for Performance Tuning and Optimization recommendations for Confidential .
• Provided Infrastructure Support for Oracle Hyperion Products.
• Performed installation, configuration, Patching and upgrade Hyperion suite 11.1.x
• Worked on Service Requests with 4 different severity levels. Attended Recovery Calls as a part of Severity 1 issues within the project.
• Worked on providing Root Cause Analysis documents for the common issues in SIL environment. Also involved in Migrations using LCM utility.
• Part of a team assisting Oracle customers in resolving issues related to Hyperion applications.
• Perform security analysis and deploy latest patches to address security issues.
• Having experience on SSO configuration.

Environment: Hyperion Essbase 11.1.2.4, Hyperion Planning 11.1.2.4, HFM, FDMEE, Windows 2008/2012 R2, ODI, HFR, Linux, Oracle DB, SQL Server, Smart view, SOA, FCM/ ARM.

Confidential

Senior Software Engineer

Responsibilities:

• Performed installation, configuration, Patching and upgrade Hyperion suite 9.3.x to 11.1.1.3 to 11.1.2.3
• Performed Defragmentation in QA/ Production environment to improve the performance of the application.
• Provided 24/7 support for the Hyperion applications during Financial close periods, Month end and Quarter end close periods
• Setup full SSL (OHS, IIS, WebLogic)
• Setup Disaster Recovery (DR), High Availability (HA), Load Balancing (LB).
• Automation of Housekeeping keeping task (Bounce scripts, Data and Task Audit, Logs rotation)
• Installed HFM, HFR, SmartView clients in Citrix servers
• Experience on Development and Maintenance of Hyperion Financial Management Application.
• Involved in creation of journals, Metadata changes, Data Entry Forms, Grids, Consolidation etc., and Resolving day to day issues of HFM and Smart view.
• Worked on adapters, mappings, locations, imports, exports, reports using financial data management.
• Integrated People Soft, Oracle ERP Applications using FDMEE to integrate data related to financial applications.
• Created reports Using Hyperion Financial Reporting and SmartView.
• Involved in Performance test.

Environment: Hyperion Essbase 11.x, Hyperion Planning 11.x, Excel add in, PeopleSoft, Oracle Data Integrator, Financial Reporting, FDM, FDMEE, Smart view, Oracle 11g, DB2, Hyperion Financial Management 11.x., EPM, BMC remedy.

Confidential

Senior Application Consultant

Responsibilities:

• Streamlined reporting processes in HFM Build and modify reporting systems and create reports for global users.
• Created Journal Entry templates, Data Forms and Data Grids for users.
• HFM design and development of various components E.g. Metadata, Member lists, Rules etc.
• Worked Involved in requirement gathering and created reports using Financial Reports from HFM applications.
• Created Project, Application in Hyperion Shared Services and provision users and groups for (HFM) Hyperion Financial Management.
• Validated the source data against mapping table to optimize the design, to increase the performance and troubleshooting with workflow process.
• Troubleshoot and resolve HFM and FDM user questions and issues where possible.
• Monitoring and maintaining Essbase security settings during different cycles.
• Created Users and Groups and assigned privileges to them. Applied security on the application by creating filters on its dimension members
• Responsible for running periodical backups
• Ability to write, modify, monitor, maintain Hyperion Financial Reports, Hyperion Smart View Reports.
• Developed batch scripts for automating and scheduling month end backup process
• Effective Reporting and SLA Reporting for the services provided.

Environment: Hyperion Financial Reporting, Smart view, Hyperion Financial Management 9.3.x & 11.x., EPM.

Confidential

Software engineer

Responsibilities:

• Designing metadata.
• Responsible to maintain the security through shared services.
• Designing Member lists by using VB Script.
• Involved in creation of Data Entry Forms and Grids by using Web Applications as per requirement.
• Resolving day to day issues in HFM and Smart view.
• Adding new Entity structure.
• Managing POV in the explore data setting.
• Creating Journals Templates.
• Extracted and loaded the metadata whenever metadata changes occur.
• Maintenance of metadata entity and accounts hierarchy and application security.
• Maintaining User Security.

Environment: Hyperion Financial management v 9.3.1, Hyperion Reporting 9.3.1, Smart View, Hyperion Analyzer, server 2000.