SUMMARY:

• 10 years of experience in IT in multiple industries. Four and half years of strong experience in the Hyperion suite as techno - functional consultant Confidential architect Confidential developer and administrator. Strong experience on SAP as lead ABAP consultant and on BIW implementations.
• Hyperion BI consultant with strong multiple full lifecycle experience in Hyperion EPM suite including HFM Confidential BI+, Planning and Essbase.
• Strong functional knowledge of HFM processes to support cross functional teams.
• Good working knowledge of regulatory and reporting requirements (US GAAP and IFRS).
• Full lifecycle experience in project management tasks Confidential supporting business development Confidential POC presentations Confidential stakeholder meetings and scope management Confidential delivery and post rollout support.
• Broad conceptual knowledge of the Hyperion space including consolidation engine and processes Confidential HFM dimensionality Confidential security Confidential allocations Confidential multi-currency support.
• Development and implementation of complete EPM system architecture for HFM consolidations and allocations processes and BI+ reporting solutions.
• Strong development experience in Hyperion S9 suite including metadata Confidential rules for consolidation and allocations Confidential forms and grids Confidential BI+ reports(Web analysis and Smart View).
• Administration of data loads Confidential back ups Confidential security Confidential users and reports. Troubleshooting and resolving data issues and system recovery.
• Implementation of forecasting application on Hyperion Planning.
• Design and development of Essbase cubes Confidential Calc scripts and Maxl scripts.
• Installation Confidential configuration Confidential performance tuning and system upgrades of the Hyperion suite.
• Multiple implementations of SAP-ABAP/4 and SAP BIW as lead consultant.
• Excellent analytical and research skills. Self-starter with ability to work on multiple projects with minimum supervision while adding value to cross-functional teams.

TECHNICAL SKILLS:

Tools: Hyperion EPM Stack: Financial Management 4.x and 9.x Confidential Planning 4.x Confidential Performance Management Architect Confidential Performance Scorecards Confidential BI+ (Financial reporting and Web Analyzer), FDM 9.x Confidential Smart View

Databases: Oracle 9.x Confidential 10.xSAP: ABAP Confidential BW

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta

HFM BI Architect

Responsibilities:

• Build administration process and SOPs for production environment for Hyperion S9 applications.
• Complete end to end installation and configuring Hyperion S9 environment (HFM Confidential Planning Confidential BI+, security and load balancing).
• Architect and build applications for Income statement Confidential Balance sheet and cash flow reporting.
• Develop rules (Multi-currency Confidential EPU Confidential custom consolidation) and web grids using HFM for consolidation applications.
• Developing IC elimination process Confidential IC reports and reconciliation .
• Testing the developed/enhanced reports in System 9 FM development environment and moving the same into test and production environment.
• Developing Confidential designing and technical specifications for all sales & operations planning requirements in Hyperion System 9 FM at client location and coordinating with the offshore team leads for the development of the objects
• Testing all reports and reconciliation with Source System and ETL where ever needed.
• Discussing with the end users for the all tickets that are generated in the CR management tool and analyzing the requirements for the same.
• Understanding the end-users requirements and looking for a feasible and optimized solution. Finding the Fit-Gaps for the Existing the business warehouse system. Providing Solution for all the S&OP Requirements.

Environment: Hyperion System 9 (HFM/Planning/Reporting), Performance Management Architect (Dim Lib Confidential App Lib Confidential Data Synch and Lib Job Console), Oracle Confidential SAP/BW Confidential Windows and Unix

Confidential, Pennsylvania

HFM Architect

Responsibilities:

• Develop solution architecture using Hyperion S9.
• Post roll-out administration support and help desk on Hyperion S9.
• Developed intercompany processing and administration application using HFM.
• Successfully planned and implemented general ledger translation software package Financial Data Management for all business units.
• Converted all data (Actual/Budget/Forecast) from 2004 and forward for both data and journal entries via a custom Visual Basic program
• Developed HFM applications Confidential import formats Confidential mappings Confidential rules Confidential web forms and monthly reporting package.
• Testing the reports in HFM development environment and moving the same into Dev and Prod environment.
• Developing the business content which are feasible for end-user requirements before going for a generic objects
• Providing solution for all the end user requirements and finding the fit-gaps.

Environment: Hyperion System 9 (HFM/Planning Confidential BI+), Oracle Confidential Windows and Unix

Confidential

HFM Developer

Responsibilities:

• Understanding the business requirements and developing the technical design / architecture.
• Design and implement FDQM environment Confidential including import formats Confidential scripting Confidential dimension mapping and validation reports.
• Installation and configuration of Hyperion Confidential FM Confidential Essbase Confidential Planning and reporting tools.
• Developing BPM applications using HFM Confidential Planning Confidential reporting & providing solution for all the new reports requirements.
• Developed dynamic reconciliation workbook tool to tie out Enterprise with HFM data using Hyperion Retrieve and Hyperion Smart View for multiple data categories (by entity Confidential by account).
• Preparing the functional and technical design and coordinating with the Offshore for the developments for Hyperion Objects and its maintenance.

Environment: HFM Confidential Hyperion Planning Confidential Oracle. SAP/BW Confidential Windows and Unix

Confidential

HFM and Planning Consultant

Responsibilities:

• Planning for the upgrade Confidential defining a time frame Confidential describing task list.
• Discussing and analyzing the user requirements with the Business Partners.
• Coordinating with the off-shore teams for testing different Hyperion Objects in HFM like Meta Data Testing Confidential reports Confidential grids etc.
• Actively took part in prepare Confidential pre-upgrade & post-upgrade phases of the project.
• Pre migration and post migration checks.
• Convert all old web templates to new version using the utility and fix any issues.
• Creating custom cubes and objects.
• Modified Update rules Confidential transfer rules Confidential update routines and transfer routines as per client requirements
• Direct update of master data from flat files and flexible updating of flat files
• Uploading Hierarchies from flat files

Confidential

SAP BW Consultant

Responsibilities:

• Creating custom cubes Confidential Infoobjects Confidential cubes Confidential Infohubs Confidential Generic Extractors & ODS
• Modified Update rules Confidential transfer rules Confidential update routines and transfer routines as per client requirements
• Direct update of Master data from Flat files and Flexible updating of Flatfiles
• Uploading hierarchies from flat files. Creating process chains for the data loading Activities
• Loading Transaction data from flat files and generation of queries
• Weekly & Monthly data loading.

Confidential

SAP ABAP Onsite Coordinator

Responsibilities:

• Coordinating with the off-shore teams at Confidential - Singapore and Satyam Chennai
• Involved in Analysing of Functional Specification and Preparation of Technical Documentation
• Developing Critical Layouts using Smartforms and Perform unit tests as per test plans
• Going thru the Code Review and performance Testing of objects
• Involve in Estimation and TD review. Correcting the reviewed and testing defects
• Responsible for overseeing the Quality procedures related to the project.

Confidential

SAP ABAP Lead Consultant

Responsibilities:

• Involved in the Client Team for ABAP Development
• Leading the ABAP Team and Identifying the Objects for Go live Critical
• Preparations of Technical Documentation and assigning the objects
• Perform unit tests as per test plans and Going thru the Code Review and performance Testing of objects
• Involve in Estimation and TD review. Correcting the reviewed and testing defects
• Updating the task folders according to the ASAP.Post Go live maintenance
• User and Handling the critical objects for Go live.
• Testing - unit testing & integration testing
• Responsible for overseeing the Quality procedures related to the project.
• Client site for implementation.

Confidential

SAP ABAP Consultant

Responsibilities:

• Preparations of Technical Documentation and Perform unit tests as per test plans
• Involve in Estimation,TD review. Correcting the reviewed and testing defects
• Preparation of Program Documentation. Updating the task folders Confidential Quantify.
• An ALV GRID report in FI/CO is to check the prices and transport costs imported from the SU via TPS with the MSO standard price. It has been decided that ESAP will have multiple plants per MSO instead of Storage Locations. From a costing Point of view we have to be sure that the same materials will have the same standard price across all plants. We need a report to compare the Standard price of a material with in one MSO plant with the Standard price of that same material in a different MSO plant.
• An ALV GRID report in FI/CO is to display the list of material numbers assigned to each routing together with some selected material master settings for each material.
• A report in PP to display the list of Bill Of Material’s for given material Confidential plant and other combinations

Confidential

SAP ABAP Consultant

Responsibilities:

• Development of Module pool program for Back Flush activities with updated the databases and Posting the data thru the Batch data communication.
• Generation of SAP scripts.Report generation Programs.
• Developed BDC programs for uploading the data into Quality and Production Servers.

Confidential

SAP ABAP Consultant

Responsibilities:

• Developed Interactive reports Confidential BDC’s and scripts
• Developed standard reports.
• Calling function modules from different screens for the user action using reports and functions modules.