SUMMARY

• Over 8 years of professional IT experience worked closely with IT and Finance/Accounting team with Data warehousing, Client - Server applications, Oracle and SQL Server Database, Relational Databases and HFM development.
• 5+ years of experience in design, analysis, development and implementation of various applications in client/server environment using) Hyperion Financial Management 9x & 11.x, Hyperion FDQM 11X, 9.X, Hyperion Essbase, Hyperion Planning9x & 11.1, Hyperion Financial Reporting, Hyperion Web analysis, ESSCMD, Essbase Excel Add in.
• Experienced working with Hyperion Financial Management (HFM) 9.3.1 and 11.1 strong backgrounds in Creating, Deploying, Maintaining and modifying using HFM tools.
• 3+ years experience in Experience in all the phases of end to end ERP implementation such as Design Project Solutions with respect to As-Is & To-Be Design, Requirement Gathering, Configurations, Setups, Confidential Analysis, Testing, Conference Room Pilot (CRP's), User Acceptance Testing (UAT), End User and Super User Trainings, and Post Production Support.
• Involved in installation and configurations of various products of Hyperion system 9.x such as HFM, Hyperion Planning, FDQM, ODI and Analytic Services Server, Analytic Services Client, Analytic Administrative Service Console, Shared Services and deployment of Web Server
• Experienced working with Hyperion Financial Management (HFM) 9.3.1 and 11.1 strong backgrounds in Creating, Deploying, Maintaining and modifying using HFM tools.
• Experienced working with Hyperion Planning 9.x and 11.1.x, Hyperion Essbase.
• Designing and modified Hyperion Planning dimension, creating data forms, data grids in planning and HFM applications.
• Designing and modified Essbase cubes, Database outlines Calculations scripts and rules files for dimension building and data loading using Essbase Analytic Administrative services (EAS) Console and batch processing.
• Extensively experienced in Excel based custom reporting solutions over diversified data sources. Financial solution includes, P&L, Balance Sheet, Actual Vs Budget, Forecasting, Product analysis, Customer analysis, etc. Highly experienced in building Relational databases with different RDBMS.
• Experienced using ESSCMD and MaxL statements for batch processing to automate loading rules files, loading data and execution of calculation scripts and report scripts.
• Expertise in testing the reports with database using TOAD or SQL Plus.
• Expertise in providing security for Planning & Essbase applications and ability to create user and group profiles for assigning proper privileges using both User provisioning, Native security and Shared services modes.
• Good knowledge of building the Financial Budgeting and Forecasting, EPM and OLAP applications with Planning.
• Expertise in Creating and Registering HFM Applications, loading data & consolidating.
• Expertise in developing data (or) web forms, task lists, Menus, Business Rules, User variables, Smart Lists, application management and trouble shooting.
• Created customized financial Reports using different tools like Hyperion Interactive and Financial Reporting studios based on the requirements of the clients.
• Experience in automation, optimization and performance tuning of Essbase application data, upgrading, testing and migrating cubes in different Hyperion applications.
• Experience in performing Migration between different Environments and in Upgrade between different Versions including Life Cycle Management.
• Expertise in analyzing metadata and building Dimensions viz. Generation, Level, parent and child preferences and loading fact data using Rule files.

TECHNICAL SKILLS

OLAP Tools: Hyperion Analytic Administration Services, Hyperion Planning System, Hyperion Shared Services, Hyperion Essbase, Essbase Integration Services (EIS), Smart View, Essbase Excel Add In, ESSCMD, MaxL, MDX, Hyperion Reports, Hyperion Financial Reporting Studio, ODI.

Reporting Tools: Hyperion Financial Reporting Studio, Hyperion Reports, Web Analysis, Hyperion Analyzer, Hyperion Intelligence, Hyperion Spreadsheet Add-in, Hyperion System SmartView.

Languages: SQL, PL/SQL

Operating system: Windows/ Unix/ Linux

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr.Hyperion HFM Administrator

Responsibilities:

• Performed Hyperion Financial Management (HFM), and FDQM Administrator duties including maintenance of metadata and rules.
• Maintained multiple sources to Hyperion account mappings used in conjunction with Hyperion Application Link and Financial Data Quality Management (FDQM).
• Created and maintained Hyperion reports as well as facilitating ad-hoc reporting requests
• Loading data into HFM application by using data load file.
• Managed Member list, journals, Rules using Rules editor and Data forms.
• Generated Ad hoc reports, Daily reports and Ending monthly balance reports from HFM application.
• Implements HFM at the business unit level, including required data integrations, as needed.
• Developed user training materials and conduct new user training sessions, as needed.
• Worked extensively on the Planning on Custom Dimensions and writing member formulas to run them as Dynamic Members.
• Maintained and support HFM and FDM applications including managing system security, data processing, and troubleshooting user issues including Smart View.
• Maintained metadata changes and mapping tables between all financial systems as needed and communicate changes to global users and management.
• Created Company standard reports using FR report writer.
• Oversaw data uploads and verifications in Hyperion via FDM.
• Worked on the Budgeting on Forecasting models and suggested changes to the existing process.
• Validated and deploying the application using the Dimension Library.
• Worked on optimization cubes and changing the Essbase.cfg settings to give the optimized results.
• Worked on Automation of Data Loads into the Planning and Essbase. Automation of the data loads done by means of the Maxl scripts and Batch scripts.

Environment: Hyperion Financial Management 11.x.x, FDQM, Hyperion Planning 11.x.x, SmartView Add-in, Excel Add-in, MS Office, Visual Explorer,, Shared Services.

Confidential, New York City, NY

Sr.Hyperion Administrator

Responsibilities:

• Worked in a team to implement HFM and FDQM application and setup of Financial Reporting.
• Designing Dimension and its attributes, Application settings, Account types, Consolidation Methods, Currencies, and Intercompany Transactions.
• Created Data Forms in HFM application by using Form Builder for users to input the data. Also created Data Grids in HFM application for consolidating financial data.
• Maintain and support HFM and FDM applications including managing system security, data processing, and troubleshooting user issues including Smart View.
• Maintain metadata changes and mapping tables between all financial systems as needed and communicate changes to global users and management.
• Create Company standard reports using FR report writer.
• Oversee data uploads and verifications in Hyperion via FDM.
• Take responsibility and ownership for query/problem/issue resolution, process improvement and fixing the root cause of problems in the application support processes.
• Meet individual objectives and contribute to the achievement of the teams overall objectives.
• Meet performance objectives relating to turnaround times on problem resolution.
• Identify problem areas in regards to processes and work with the team to generate solutions and escalate to management as appropriate.
• Manage downtime expectation and communicate to users and work collaboratively and effectively within a team of peers.
• Demonstrate the ability to work effectively within cross-functional teams.
• Work closely with accounting team to identify system problems and provide solutions to minimize system outages.
• Work on Oracle EBS General Ledger as data source for Hyperion applications. Imported data from Oracle GL module to FDQM.
• Applied HFM for data management processes for gathering data, calculating, approvals, consolidations, and submissions of data.
• Used Essbase Administration Services for activities such as filter creation.
• Modifying batch scripts using MaxL and ESSCMDs to load data from relational systems database to Essbase cube, developed MDX queries.

Environment: Hyperion ESSBASE 11.1x, Hyperion Planning 11.1x, Hyperion Financial Management 11.1.2.1, Hyperion Financial reporting 11.1.2.1, FDQM,Hyperion Workspace 11.1x, Hyperion Shared services 11.1x, SmartView.

Confidential, NYC

Hyperion HFM Administrator

Responsibilities:

• Management of the Hyperion Environments (FDM/HFM/Planning) and other related products the primary platform for all reporting/consolidations/planning including, Metadata, rules and security as well collaborate with IT Architect for deployment of upgrades and patches across all environments (Development, Test & Production)
• Maintain and administer validation of FDM rules/scripts to insure accurate and complete migration of data from source systems through FDM to Hyperion Financial Management and Planning
• Development, deployment and maintenance of most effective and efficient processes and tools for data loading (templates, Web Development, deployment and maintenance of Financial Reports and dashboards including the collection of end user requirements and building reports to their specification in compliance with management approvals
• Support the development and deployment of initiative to drive best practices and deployment of enhancements to maximize tools processes and resources.
• Analysis/validation of monthly financial data; actuals, forecasts, budgets, strategic plans, and other reported data to insure accuracy and reasonableness of reported data along with providing feedback to Units, VCs and/or HQ for needed corrections within defined financial and SOA requirements
• Enterprise wide users support with data changes globally for monthly actuals, quarterly forecasts, annual budgets and strategic plans within defined timelines and SOA requirements
• End users support with data reporting tools and process including errors/discrepancies/validations corrections to insure timely and accurate finance reporting along with providing the most effective and efficient process and tools for data loading(templates, Web Forms, Grids, Journals, etc.)
• Enterprise wide end users Subject Matter Expert (SME) training and support with SmartView, Grids, queries and functionalities to facilitate financial data mining for analysis, inquiries and adhoc reporting
• Perform other related duties as assigned.

Environment: Hyperion Financial Management 11.1.2.1,FDQM, Hyperion Financial reporting 11.1.2.1, Hyperion Interactive Reporting, Hyperion Workspace 11.1.2.1, Hyperion Shared services 11.1.2.1, Smart view11.1.2.1ApexIT, Minneapolis, MN

Confidential, Minneapolis, MN

Hyperion Administrator

Responsibilities:

• Performing as the Project QA Team Lead for the Essbase Upgrade project.
• Participating in Business requirement gathering, walk through, reviews and user group meetings tasks and tracking Stories/Jobs using Excel and Jira.
• Assisting in Creating, designing, developing, enhancing, maintaining, and implementing efficient and effective Test Plan, Test strategy
• Test approach, Test Case, Test Script documents for enterprise wide end-to-end testing all of these projects
• Developed automated test scripts using Excel Smart View.
• Executed automated as well as manual test scripts and validated Test conditions for Systems, Integration, and Regression.
• Planning tasks and reviewing and carrying out through all phases of Software/Project Development Life Cycle (SDLC).
• Coached, mentored, and assisted subordinates with Testing Methodology.
• Created and maintained physical server database structures such as tables, views, and indexes for the projects
• Performance Tuning with the environments DEV/TEST/PROD and testing.
• Applying QA methodology, writing Test Plans, Test Cases and creation of test data for Performance, Load and UAT testing.
• Working through UAT testing and co-coordinating with teams and documentation for different phases of migration.
• 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 Outline Restructure, Cache settings, Outline formulas and Calc scripts.
• Responsible for assigning work to testing team, conduct meetings with the business units to gather requirements for test cases and build test cases.
• Manually moving all the components like Essbase calc scripts, reports, load rules, Server variables, Security Filters etc.
• Assisting in modifying Maxl and EssCmd scripts to reflect the new server and security model.

Confidential, Minneapolis, MN

Oracle EBS Functional Consultant

Responsibilities:

• Conducting meetings with Team members to discuss about project scope and project planning.
• Responsible for successful roll out of Oracle applications for Financial and Purchasing modules.
• Preparing and tracking the Project plan. Ensure the timelines are met.
• Solution design for UK and India operating units roll out, including India localizations.
• Performed all the financial set ups, built FSG’s for various financial statements.
• Providing customization designs and work around for various business requirements.
• Reviewing the documentation and responsible for sign offs.
• Designed and executed ‘Data migration’ strategy for master and transactional data.
• Month end closing procedure - design, documentation, training and issue resolution.
• Dealt with Users from Offshore team as required for resolving the issues.
• Done the Configuration for GL, AP, AR, and Cash Management modules as per the client needs.
• Maintain and present the project metrics to the Management.
• Conducting CRP, UAT and User Training for Implementation.
• Planning, finalizing and Preparing Primary Ledgers, Reporting Ledgers, and Ledger sets as per client reporting requirements.

Confidential, Pittsburgh, PA

Oracle SCM Functional Consultant

Responsibilities:

• Worked on implementing internal requisition and internal sales orders as a solution for intercompany transactions.
• Worked on solution design and setup of Inventory, Purchasing & Order Management as per the client requirements and suggested business process changes.
• Requirement gathering, Configured Inventory, Purchasing and Order Management for three different implementations.
• Involved in resolution of functional issues related to Oracle Manufacturing and distribution during implementation of modules
• Created functional design documents (MD.050) for customizing forms to address business requirements and to address the labeling requirements.
• Provided solution to better manage recalls in all the locations around the globe.
• Setup and maintenance of all the alerts and notifications.
• Prepared training documents and assisted in user training in WIP, OM & PO modules
• Assisted in period closing and also daily production support by resolving system & user issues. Following up with Oracle Support on service requests.
• Negotiate technical and non-technical solutions that both satisfy the business user and conform to the technical architecture.

Confidential, Washington, D.C

Oracle Financial Functional Consultant

Responsibilities:

• Involvement in Budgeting exercise of the organization, including preparation and phasing of budget.
• Creating the ARC Budget for fiscal year 2008 using Oracle GL Budgeting.
• Worked on development of new FSG reports and customized various standard FSG reports.
• Developed ad-hoc journal reports using FSG as well as standard General Ledger reports and Oracle Payables reports such as Trial Balance, Payment Register and Invoice Register.
• Studying the current accounting structure and suggesting changes to improve financial reporting and analysis.
• Provided solution in development of new workflows related to requisition and payments approval.

Confidential, Los Angeles, CA

Oracle Financial Functional Consultant

Responsibilities:

• Implementation of Financial modules (GL,AP, AR and PO) in a team
• Responsible for gathering user requirements, data conversions, customizations and testing.
• Suggesting the best practices in the industry in conjunction with local requirement.
• Tight and primary integration between various modules was extensively tested and verified. Unit, System, Integrated Testing for GL,AP, AR and PO modules during CRP1 and UAT
• Supporting daily operation for all Financial Modules
• Guiding for Customized Report, Interfaces etc
• Deliverables included need analysis, functional mapping, Confidential analysis, business process re-engineering, finding solutions, setup and prototyping & testing
• Provided Training & Conducted Practice & Additional Business Requirements sessions
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• Defined Value Sets, Descriptive Flex fields, and Custom Profile Options