Objective:

Seeking a position where I can leverage my broad knowledge of business intelligence, EPM, financial reporting and software development to lead and plan the analysis, architecture and development of software solutions to answer business challenges

Experience summary:

• Hyperion Certified Consultant (HCC), Oracle DB Certified Professional with around 8 years of IT experience in Analysis, Design, Development, Implementation, Administration and maintenance of various applications in Client/Server environment using Business Intelligence (OLAP) and Oracle EPM Product suits(Hyperion Essbase, Hyperion Planning, Oracle Data Integrator, MDM/DRM, EIS,Hyperion Financial Management, FDQM, OBIEE) including all phases of Software Development Life Cycle (SDLC) with different role as a Lead Developer, Business Analyst ,Techno Functional Analyst.
• Strong application development experience using different Oracle EPM Products Hyperion Essbase, Hyperion Planning including Workforce and CapEx Planning,ODI,MDM/DRM, OBIEE Answer,Dashboard,Publisher, EPM 11.1.x,Hyperion System 9 BI+ Interactive Reporting, Web Analysis, SQR Production Reporting, Financial Reporting, Work Space, Clarity Performance Management, VBA MACROS, ESSCMD, MAXL SCRIPTS, Shell Script API programming, Report Script.
• Exposure on cash flow Statements, Balance Sheets, Income statement, Key Metrics, Operating and Admin Expenses, and basic knowledge on accounts, GAAP & IFRS.
• Solid experience on Hyperion development, infrastructure and administration activates on Hyperion suite (foundation services, FM application (HFM, HSF, and HDFM), Data management application, BI + reporting services, planning, DRM.
• In depth knowledge and experience on Installation and configuration of Hyperion EPM Suite (system 9, 11.1.1.3, 11.1.2.2) on windows, UNIX and performance tuning expertise on several Hyperion components.
• Sound experience on migration, up gradation projects of Hyperion suite (system 9, 11.1.1.3, 11.1.2.2). Independently worked upon migration activates (DEV to UAT, PROD) and upgrading projects (system 9, 11.1.1.3.500 to 11.1.2.2.300 ) for fortune 500 customers.
• Possess excellent analytical, logical, communication skills, familiar with the SDLC methodology of system development.

SKILL SET

Software:

Hyperion BI+, Hyperion Essbase, Planning, Data Relationship Manager(DRM), Financial Reports (FR), Web Analyzer, Business Rules, Designer (Performance Suite 8.3), Brio Intelligence 6.6.4, Interactive Reporting, Workspace, Shared Services, EPMA, Excel Add In, Smart View, Test Director (Mercury Quality Center), SQL and exposure to Hyperion Financial Management (HFM), Financial Data Management (FDM), Oracle Data Integrator (ODI), Rational Clear Quest. Have worked in versions of Hyperion including 6x, 7x, 9.2, 9.3.1, 11.1.1.3 and 11.1.2x. Exposed to OBIEE(10g), Business Objects and Informatica as well.

Databases:

Advanced knowledge of Relational Database Management System (RDBMS) databases, Oracle 10g

Operating Systems:

Microsoft Windows NT/ 98/2008/2003/ XP and Linux/Unix

Domain:

Telecom, Banking, Finance & Insurance, Travel and Hospitality, Media and Information Services, Manufacturing, Energy & Utilities and Data storage devices.

FUNCTIONAL

• Implementing project plans with in preset budgets and deadlines. Handling resource allocations and setting up of communication channels across the various horizons of the organization structure.
• Business Analysis: Understanding business need and designing a road map for ongoing improvement.
• Architecting and Solution Designing for projects
• Mapping business requirements (As Is & To Be Analysis) and GAP Analysis during development and delivery
• Tracking progress and holding meetings to monitor project deliverables per schedule / budgets.
• Monitoring and ensuring smooth customer delivery during the transition and handover period.

Projects details

Confidential, Santa Clara, CA

FACTICO (Current project)

Sr. Team Lead Hyperion Consultant

DRM Implementation:

• Designed and implemented key finance hierarchies in DRM: Cost Center, Legal Entity, Account, and Product hierarchies for Oracle GL, Fusion HUB, HFM, and Planning.
• As per business requirements for monthly maintenance, Involved in changing the Metadata and mapping with source (PSGL accounts) and target account (HP, HFM, FDM) in DRM and created new version for every month.
• Security Administration Design. Design Node Types, Node Access Groups, and Security for downstream users to allow for mapping reconciliation.
• Design for Mapping of metadata and dollars from Planning to FCS (GL) and OFSA (reporting) Designed the Mapping solution for dollar uploads, eliminations, intercompany transactions, etc. to facilitate the upload of dollars for Budget from Planning back to OFSA and the General Ledger, FCS.
• Master Data Dictionary, incl. source, integration target, properties/metadata, list of values, business owner.
• Solution/Design Document DRM build, including source data model for data sources to data targets.
• Involved in every business meeting and translated all business requirements into technical specs and then advised to team create dynamic hierarchies and derived properties.
• Extensively worked on validations, Action scripts, blenders, formulas, derived properties.

Planning implementation:

• Involved in requirement analysis and documentation leading to an effective Hyperion solution incorporating user needs of converting Excel based Budgeting and Forecasting Process to Hyperion Planning in order to increase efficiency.
• Gathered user requirements and then transformed them into Dimensions, Attributes and Members for Budgeting, Forecasting and Planning implementations.
• Created business rules that replicate the functionality of complex formulas existing in excel.
• Developed Dynamic Web forms for various users with POVs and Pages and designed the overall workflow of the budgeting and forecasting process with kick off, reviews and approval states.
• Maintained and supported Hyperion Planning applications also implemented application security process, created users/groups, security profiles and application access to different groups using filters.
• Assisted to team to create and managing the project schedules and plans for Cube build and calc script development, General Expense/Allocation model, Balance Sheet budgeting, P& L Budgeting, Workforce Planning and CapEx Planning.

EPM, DRM, WDK, ERP infrastructure setup:

• Building all Proof of Concept EPM and DRM environments for customers.
• Designing and implementing EPM and DRM environment on customer sites as per expectations.
• Liaising with customer technical departments on best use of resource, infrastructure etc.
• Participated Building POC for EPM up gradation and migrations for couple customers.
• Reviewed couple of customer s existing infrastructure model and addressed the bottlenecks, performance issue and tuned the parameters at different Layers.
• Implemented SSO for DRM applications for one customer with minimum downtime.
• Suggested High Availability technologies to build in fault tolerance at the core system level.
• Setup Internal EPM server and integrated with ERP and DRM module and implemented SSO.
• Participated various EPM COE activates and training session.

Environment: Hyperion EPM 11.1.2.2.300 , Hyperion Planning, Hyperion DRM,HFM,FDMEE,Hyperion essbase , MaxL scripts, Hyperion Financial Reports, Oracle Database 11GR2

Confidential, San Francisco, CA, USA

Lead Hyperion Consultant

Responsibilities:

• As a technical lead, I am responsible for various aspects of application and infrastructure architecture set up: project planning, requirements gathering, scope management, change control, execution oversight, issue management, and risk mitigation for all on demand customers.
• Involved in every aspect of on demand life cycle management, including requirements gathering for workflows and change management and incident management.
• Directly responsible for outlining the technical architecture of the EPM system, including the Sandbox, Development, System Test, Production, Training and Disaster Recovery environments and Utilized High Availability technologies to build in fault tolerance at the core system level.
• Principal designer for the EPM systems Disaster Recovery Plan ( DRP ). The DRP is designed to minimize the time required to cut over to the DRP site while ensuring that data and productivity loss is minimal.
• Extensively involved and work with US, APAC customer for new Hyperion ENV setup as per on demand standards and Enforced database standards, best practices, methodologies, processes and procedures.
• Almost 20 new customer, we have set up new Hyperion ENV as per on demands standards and involved in every aspect of infrastructure set up for all customer including installation & configuration, migration activities for fortune 500 customers.
• Extensively worked on troubleshooting and performance tuning activates on EPM suite (Foundation services, FM application, data management application).
• Responsible for Change management and incident management for prod environment and extensively worked on backup and restoration activates, Managing Hyperion Services for up to time, managed outages.
• Responsible for developing the security plan which was used to set up company security for all EPM suite as per on demand standards and Enforced database standards, best practices, methodologies, processes and procedures.
• Responsible for making sure all work is completed on time and Ability to motivate and lead team members to reach organization goals and objectives.

Environment: Hyperion ver 11.1.2x HFM, FDQM, DRM, HSF,Workspace, Smart View, FRs, Shared Services, Planning, EPMA, Essbase, Excel AddIn and Service Now.

Confidential, Tulsa, Ok, USA

Senior Hyperion Consultant

• Worked with senior management and end users to define scope of the requirements for new systems and enhancements and issues.
• Maintained the system continuously to perform maximum efficiency.
• Proactively supported for BAU activates and implemented the same without failure.
• Extensively worked with business users for every month BAU release to run smooth and implemented the same as per business requirements like Metadata maintenance in DRM, FDM, and HFM.
• Designed and implemented key finance hierarchies in DRM: Cost Center, Legal Entity, Account, and Product HFM, Planning.
• As per business requirements for monthly maintenance, Involved in changing the Metadata and mapping with source (PSGL accounts) and target account (HP, HFM, FDM) in DRM and created new version for every month.
• Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.
• Managing POV in the explore data setting.
• Set up security, including users, groups, security classes, and access rights.
• As per the business requirements, modified existing rules, Re created, implemented new rules to fulfill business requirements.
• Effectively implemented HFM best practices on existing application to improve performance and high availability for end user.
• Implemented performance tuning and oracle recommendations on different Hyperion applications like shares services, workspace, HFM application to give more band width to the end users.
• Extensively worked with different internal teams and External vendor (Oracle) on different issues like performance tuning and FDM & HFM application issues.
• Installed tested patches into the production environment and documented all associated patching procedures, including specific configurations required.
• Proactively monitored the performance of the production database and Application components.
• Worked with database team for backups are performed in keeping with agreed back up and recovery requirements.
• As an admin, involved in migration, up gradation, patch installation, performance tuning on different Hyperion components.
• Involved in Disaster Recovery testing and coordinate with different internal teams (windows, UNIX, oracle, control m, NAS, enterprise storage, Business team) for testing and for internal audit prospective whether system is up and running.
• Effectively working on HFM housekeeping tasks such as Extracting and deleting task& data audit of the various objects that make up the database and application healthy.

Environment: Hyperion ver 11.1.x Essbase, Planning, EPMA, Shared Services, Workspace, Smart View, Excel Add In, HFM, FDQM, FRs in Unix & Windows box, MS Office suite and Informatica.

Confidential, CA,USA

Senior Hyperion Consultant

• Understand Business requirements and extensively worked on NEW system.
• Worked heavily with senior management end users to define scope requirements for new systems and enhancements.
• Involved in preparation of tech specs (Data mapping docs) based functional specs and assist same to the team.
• Work closely with data architecture, IT and infrastructure teams.
• As per client request implemented new FR s on the system and installed EPM11.1.1 and configured with FDM.
• Metadata Reconciliation and Financial Master Data Management Hierarchy Techniques and Best Practices. Give the bank best practices for Hyperion Solution Hierarchy design and maintenance in DRM.
• Security Administration Design. Design Node Types, Node Access Groups, and Security for downstream users to allow for mapping reconciliation.
• Design for Mapping of metadata and dollars from Planning to FCS (GL) and OFSA (reporting) Designed the Mapping solution for dollar uploads, eliminations, intercompany transactions, etc. to facilitate the upload of dollars for Budget from Planning back to OFSA and the General Ledger, FCS.
• Master Data Dictionary, incl. source, integration target, properties/metadata, list of values, business owner.
• Solution/Design Document DRM build, including source data model for data sources to data targets.
• Doing Consolidations and Analysis through HFM Client and Web.
• Extracted data from source system (general Ledgers), validated /Transformed/cleansed data into FDM and mapped to the respective accounts into HFM application.
• Extensively worked rules in FDM to load data into HFM application.
• Creating Grids by using Explore Data modules and created Dynamic member list as per client request.
• As per client requested created & modified business rules.
• Validation of Grids after load and consolidation.
• Involved in changing the Metadata whenever needed.
• Configure Data Entry Forms by using Web Applications and Creating Grids as per requirement.
• Managing POV in the explore data setting.
• Set up security, including users, groups, security classes, and access rights.

Environment: Hyperion ver11.1.1.3,HFM,DRM, Planning, EPMA, Shared Services, Workspace, Smart View, Excel Add In, OBIEE(10g)

Confidential, LLC, TX

Team Member Hyperion Consultant

• Installation and Configuration of Essbase Analytical server, Administration Server and Administration Console, Essbase Excel Add Ins and Hyperion Analyzer for development, tests and production environments.
• Involved in Development and performance tuning with Hyperion Analytic Services (Essbase) multidimensional databases including Outline, Rule Files, Calc Scripts, Reports, database optimization
• Maintain Hyperion Servers, create batch files and Maxl scripts to automate the data load process, Dimension Building, calculations and backups.
• Creating Calculation scripts, MaxL script for process automation.
• Migration to new production server and supporting end user, planners for budgeting.
• Daily and weekly back up process as well as Data loading job monitoring.
• Reporting using Excel add in, Hyperion Analyzer.
• Creating Repository for Hyperion Planning Application.
• Building Planning Application and building metadata using HAL.
• Loading planning data using planning desktop and smart view client.

Environment: Hyperion EssBase 7.1.2, Hyperion Planning, Tools: SPC Excel Addin, Excel Macros with VBA, Esscmd, Shell scripting, MaxL scripts, Hyperion Reports, Hyperion Analyzer O/s: windows

Confidential, Austin, TX, USA

Hyperion Consultant

• Extensively worked with business users for every month BAU release to run smooth and implemented the same as per business requirements like Metadata maintenance in Hyperion Applications.
• As per the business requirements, modified existing rules, Re created implemented new rules to fulfill business requirements.
• Involved in importing data from different data sources including OLTP/OLAP database, excel and text file to Essbase cube. Merged and aggregated data from different data sources. Created and maintained Rule files, Report Scripts and Calc Scripts.
• Maintained and updated members, outline, and alias automatically using Batch files and MaxL.
• Worked on the performance tuning (Cube Optimization) of the Applications for the fast data loads, better calculation times of the cubes and fast retrieval of the reports using the Dense/Sparse settings, Cache settings, Outline formulas and Calc scripts.
• Developed Excel Templates for user interface in Essbase database.
• Used Essbase Administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
• Extensively implemented unit testing for everything release.
• Installed tested patches into the production environment and documented all associated patching procedures, including specific configurations required.
• Apply various Filters for efficient and accurate retrieval of required data. Viewer.
• Designed and developed various types of reports (Pivot, Tabular, and Chart and OLAP Query reports) to be used by various user groups using Hyperion Intelligence.
• Drill Down functionality applied for most of drill down functionality like Summary Level,
• Customer Level and Territory Level.
• Develop Custom Hyperion Query reports with complex user interface (Dashboards) utilizing multiple database environments to provide real time reporting capabilities.
• Created and managed BQY job schedule, created and managed time events using on demand sever.

Environment: Hyperion System 9, Hyperion system BI +, Essbase integration services, Hyperion Planning, Hyperion BRIO, Hyperion Reports, MS Excel Add In, Oracle, Windows2000 server