SUMMARY

• Around 15 years of experience in Hyperion and Business Intelligence and worked on Hyperion implementation and development, Application support and Infrastructure areas.
• A versatile, high energy professional with the distinction of executing prestigious projects of large magnitude for global clients with in strict time schedule. expertise in designing and development of Essbase, Planning, HFM,DRM,FDM,FCM,HSF, HPCM applications
• Analyzed existing system captured all the important information. Identified gaps and provided assessment report to fill the gaps.
• Worked with users from various parts of the world in requirement gathering phase and documented all the details.
• Designed multi - currency application to support global transactions and converted into local currency.
• Worked on 2 different versions of HFM at a same time and part of migration team from 9.x,11.1.2.0 to 11.1.2.3.
• Hands on experience in Calculation Script, Business rules and Batch scripts in DRM
• Developed financials models in Hyperion strategic finance
• Expertise in developing mappings between HSF and HFM applications.
• Good experience in Reports scripts development to export data for downstream systems and data movements
• Expertise in creating Data grids and Data forms
• Expertise in creating Hierarchies and versions in DRM
• Created Classic & EPMA Planning Applications
• Dimensions loading into Planning using Outline Load Utility
• Involved in Security of Planning application and migration using Security Utility
• Defined and created necessary unit test case documents as part of Testing
• Business Rules development in Data Movements
• Developed Smart View, Financial Reporting and web analysis reports based on requirement
• Expertise in Hyperion Infrastructure administration of Hyperion Essbase, Planning, HFM,HSF, FDM/FDMEE, HPCM,FCM and DRM
• Expertise in installation and configuration of EPM Hyperion Suite (9.3.1/ 11.1.2.1/11.1.2.2/11.1.2.3 & 11.1.2.4) on Windows and UNIX Environments
• Hands on experience on Hyperion patching and expert in support of other environments necessary patching(Network, Windows, database, NAS, LDAP/MSAD and UNIX)
• Worked with Active directory team to configure external directories to Hyperion Suite
• Expertise in up gradation of Hyperion environments and applications
• Expertise in trouble shooting infra issues and create necessary RCA docs
• Hands on experience on deploy necessary monitor to alert Infra admins on Hyperion Environments health status
• Defined and created Disaster recovery environment as per new trends of Hyperion Infra setups
• Worked with Oracle support to implement work around on Hyperion open bugs as part of new releases
• Expertise in Hyperion Financial Management, Planning, Essbase, FDM/FDMEE,DRM,HSF and FCM Application support
• Managed Security in Hyperion Shared Services as per the IDM(Identity Management) requests
• Installed Hyperion clients on new users machines
• Migrated Hyperion Applications from DEV to QA and QA to PROD and vice versa
• Hands on experience in cloning Hyperion Applications using LCM
• Trouble shooting of Smart View, Hyperion Services issues
• Created alternative hierarchies as per the reporting requirements
• Defined and created application backups using LCM and other necessary Hyperion utilities based on Hyperion App types
• Performance tuning of applications
• Generating of security reports as per the business requirement
• Implementing Database management to copy data from once scenario to another
• Responsible for effective communication between the project team and the business
• Prepared the Technical Documents by evaluating the mappings in BODI in DRM
• Developed the mappings, sessions and workflows in DRM
• Tested individual modules of the software against the Unit test cases in DRM
• Monthly update to the DRM Servers when new product and department Hierarchy comes from the people soft
• Created user securities in DRM and expertise in Environment backups in DRM
• Fixing of user access issues and also application issues during the month end process.
• 5 years of experience as a senior group project manager and program manager.
• Expertise in vendor management and Client management
• Strong experience in team management.
• Strong experience in process management and transformations with in the environment.
• Strong experience in Strategic management and key management.
• Expertise in Change request management and ITIL process management.
• Strong experience in delivery management and Account management

TECHNICAL SKILLS

OLAP Tools: Hyperion Essbase, Planning, HFM, HSF, HPCM,FCM,SAP HANA

ETL Tools: Informatica, FDM/FDMEE

Master Data Management Tools: Hyperion Data Relationship Management (DRM)

OLAP Reporting Tools: Hyperion Financial Reporting/Hyperion Reports, Web Analysis/Web Analyzer Interactive Reporting, Smart View, Excel Add-In, Cognos

Utilities: MS-Office, TOAD, PL/SQL developer, DB Designers SQL Navigator, Putty, Win SCP

Programming Languages: HTML DHTML,VB script, SQL,PL/SQL, C.

Databases: ORACLE 7.X/8i/9i/10g/11g, MS-Access, MS-SQL SERVER 2000

Operating Systems: MS-DOS, Windows 2000/2003/2008 R2, UNIX

Dimensional Modeling Tools: Erwin 4.0

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Solution Architect

Responsibilities:

• Worked as Hyperion senior resource on this project with different responsibilities right from beginning of the project.
• Responsible for requirements gathering, installation, setups, automation and migration.
• Analyzed existing system captured all the important information. Identified gaps and provided assessment report to fill the gaps.
• Worked with users from various parts of the world in requirement gathering phase and documented all the details.
• Implementing Database management to copy data from once scenario to another
• Responsible for effective communication between the project team and the business
• Generated Security reports
• Involved in disaster recovery setup
• Involved in backup and performance tuning of applications.
• Providing 24/7 Support and implementing all the activities for all the Days

Confidential, Parsippany, NJ/Richmond,VA

Senior Consultant

Responsibilities:

• Worked as Hyperion senior resource on this project with different responsibilities right from beginning of the project.
• Responsible for requirements gathering, installation, setups, automation and migration.
• Worked as HFM functional resource in the beginning of the project and documented all the requirements.
• Designed the data flow from ERP applications to the Hyperion application using FDQM as the ETL tool
• Set up locations, category mapping, periodic mapping and import formats for FDQM
• Configured users and access rights in FDQM
• Performed automation of Batch Execution for both single period and multi-period data loads by creating Batch Definitions. Created advance level Multi Dimension mappings FDQM
• Analyzed existing system captured all the important information. Identified gaps and provided assessment report to fill the gaps.
• Designed multi-currency application to support global transactions and converted into local currency.
• Worked on 2 different versions of HFM at a same time and part of migration team from 9.x,11.1.2.0 to 11.1.2.3.
• Implementing Database management to copy data from once scenario to another
• Responsible for effective communication between the project team and the business
• Involved in production support to manage critical activities for the HFM and FDQM/FDM Applications.
• Updating Metadata and Security to HFM Application based on the business urgency.
• Updating the security for HFM production and staging applications when the new request comes for entities and business.
• Generated Security reports
• Involved in disaster recovery setup
• Involved in backup and performance tuning of applications.
• Involved in migration of applications between the environments using copy of utility and LCM
• Resolved excel add in and Smart view issues.
• Providing 24/7 Support and implementing all the activities for all the Days
• Created member lists, alternate hierarchies in applications as per the requirement
• Hyperion server maintenances on weekly and monthly bases
• Fortnight update to the HFM mappings through FDQM tool.
• Created DRM application in DRM console. developed Hierarchies in DRM application.
• Prepared the Technical Documents by evaluating the mappings in BODI in DRM
• As scope for the DRM is to feed the metadata objects migration from one environment to another using Migration Utility
• Developed the mappings, sessions and workflows in DRM
• Tested individual modules of the software against the Unit test cases in DRM
• Monthly update to the DRM Servers when new product and department Hierarchy comes from the people soft
• Created user securities in DRM and expertise in Environment backups in DRM
• Providing 24/7 Support and implementing all the activities for all the Days.
• To provide secure view, read, write access to users using Node access Groups.
• Fixed most of the DRM Batch issues.
• Using Import Task creating Hierarchies and using Export Task exporting the data to downstream.
• System should allow for users to designate required\non-required fields.
• To develop code for new Change Requests. worked on Defects and migrated to Test Environment.
• Examine & verify financial documents as well as reports ensure approved initiatives are accurately incorporated into budgets
• Installed and configured the HSF and FCM applications within the environment
• Developed financial models in HSF application.
• Created Dimensions in HSF application
• Developed mappings between HSF and HFM applications created tasks, templates in FCM integrated FCM with LDAP servers
• Involved in editing, managing tasks, templates and also scheduling the tasks in FCM.
• Liaison with the internal accounting staff as well as the financial analysts to make sure that the territories plus department meet monthly closing and reporting deadlines to the us for actual budgets forecasts.
• Manage actual results compared to budget/forecast throughout the year
• Provide technical assistance as well as training to local finance functions (both in-house plus outsourced) to make sure consistency of accounting and reporting practices corporate standards requirements
• Perform complex analytical activities as well as translate analysis into useful management tools executive summaries
• Backup and restore of DB providing user securities

Environment:, HFM,FDQM,DRM,HSF,FCM &ARM windows,SQL2005,JDE,EBS,SAP,People Soft

Confidential, CA

Hyperion Consultant

Responsibilities:

• Requirement gathering, Scoping, High level design & Project documentation and Application Supporting.
• Developed dimension libraries containing large Account and custom dimensions in EPMA using Relational/SQL Tables and flat files.
• Created and deployed Application Views in EPMA for HFM Applications.
• Automated the process of updating the dimensions and deploying the Applications by creating task flows in EPMA.
• Responsible for HFM metadata design, build and test from Enterprise & SAP CoA including Product, Geo and Functional Area reporting using smart dimensionality.
• Associated attributes and UDAs with the members in the dimensions.
• Involved in design, development and implementation of HFM application that can be used for analyzing P&L, Balance Sheet and Cash Flow by brand.
• Developed VB Scripts for data calculations, allocations and consolidations.
• Translate user requirement into formal requirement and design documents, establish specific solutions, and leading the efforts including developing and testing that cumulate in client acceptance of the results
• Sharing data using data synchronization and examining data using Smart View

Environment: HFM, Planning, HAL, Essbase, FDQM,DRM, windows, SQL Server, ODI,HAL,SAP, EBS

Confidential

Senior Consultant

Responsibilities:

• Involved in setting up BI applications like Cognos planning and Hyperion (Planning & HFM).
• Built offshore team for Cognos application.
• Involved in Hyperion infrastructure planning and deployment.
• System configuration for Unit Testing, CRP, ICRP and Production.
• Unit Testing & Simulation
• User training
• Data migrations
• Go-Live Support and preparation
• Post-implementation support

Confidential

Project Lead / On sit Co-Ordinator

Responsibilities:

• As an Admin, provided Level4 Support in trouble shooting the issues.
• Involved in disaster recovery between the environments
• Involved in creating application profile and managing meta data
• Involved in creating data grids and data forms
• Involved in data loading
• Involved in HFM migration projects.
• Involved in HFM infrastructure set up and also services packs and updates related
• Involved in setting up testing team for CITI AML project at Offshore.
• Involved in writing and executing the test cases
• Trained the team as per the project requirement

Confidential

Sr. software engineer /software engineer

Responsibilities:

• Participating in the ETL process to load data from flat file and Oracle into target Oracle database by applying business logic on transformation mapping for inserting and updating records when loaded
• Working on Informatica tool including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer
• Participating in the designing of mappings by translating the business requirements
• Performing various data manipulations using transformations such as expression, filter, aggregate, rank, joiner, lookup, and update strategy
• Using Power Center Workflow Manager to schedule and monitor different sessions and loading
• Loading of sample data in source system using Informatica 6.1 for unit testing
• Enabling tuning at the source of transformation, target, and at session-level
• Creating sessions and batches to run sequentially

Confidential

Software engineer

Responsibilities:

• Review the Client Requirements and functionalities.
• Review and execute the SQL scripts
• Preparing test cases and executing them.
• Preparing Bug Report.
• Involved in Regression testing.
• Involved in Functional testing.