SUMMARY:

• Senior BI Consultant with 10+ years experience of Oracle Hyperion packages including Financial Management, Planning, Essbase, ASO, Data Relationship Management, Web Analysis, Financial Reports, Smartview and Business Intelligence (OBIEE). Six Sigma Green Belt trained at Confidential . Experience working in Onshore - Offshore model and knows how to work around constraints and make best use of it. Proven ability to lead high performing Business intelligence teams, architect and deliver various Data Warehouse and Business Intelligence solutions that successfully drive growth and revenue. Expert in providing senior level analytical knowledge and acumen, coaching and mentoring junior team members in analysis, architecture, design and integration techniques. Combines business knowledge with technical expertise, analytical approach and operational excellence.
• Experience on Data Warehousing and Business Intelligence technologies (BI/DW). Experience in fullHyperionPlanningimplementations.
• Strong Technical and Functional experience in development and administration of various financial applications
• Involved in projects covering all the areas of software development life cycle (SDLC).
• Perform constant application administration by enforcing security measures, scheduled backups and data exports, data loads, and optimization of databases.
• Primarily in Implementation and support of Oracle Hyperion Suite of Products.
• Experience creating and updating technical documentation and following development methodology
• Experience working with customers and high level end users
• Good Knowledge of project management knowledge areas (35 hours of PMP study hours completed)
• Extensive experience with Change Control, Problem management, Incident management and Knowledge Management.

TECHNICAL SKILLS:

Tools: Hyperion (6.5X, 7.1.2, 9.3.11.1.2.1 , 11.1.2.4) Essbase, Planning and HFM. Essbase Administration Services (EAS), Smart view, Hyperion Shared Services, Hyperion Planning (3.3.1, 9.3.1, 11.1.2), HAL, ODI, Excel add-in, MDM/DRM, Smart View for Office

Reporting Tools: Hyperion Web Analysis, Hyperion Financial Reporting, Workspace, Essbase Integration Services (EIS), Hyperion Analyzer, OBIEE

Database: Sql Server 2008/2008R2, Essbase 9BI+

Languages: C,C#

OS/Environment: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Branchburg, NJ

Lead Consultant

Responsibilities:

• Requirements gathering for designing of the Project Forecast and Revised Budget process.
• Creating and testing calculation scripts as per the needs of the users using Hyperion Essbase.
• Building financial reports for VP for Engineering and co-operate using Hyperion Financial Reporting and Smart view.
• Enhanced and developed budgeting, reporting templates and ad-hoc reporting using the smart view for office
• Support for Month end closer and resolving on-call issue for users for the closer.
• Designing and developing of the workflow process using planning unit in Hyperion Planning.
• Working with stakeholders, architects and analysts to establish technical designs that address business requirements
• Customization of applications, smart lists, data forms, menus and dimensions where done through planning.
• Data Optimization and performance tuning of the application.
• Provided documentation of all the technical and functional issues which would be helpful to users for future .

Confidential, New York, NY

Hyperion Essbase/Planning Developer

Responsibilities:

• Developing the business rules based on the business requirements gathered from client. (Multicurrency, Intercompany etc)
• Developing end-to-end planning process, which includes, webforms, Menu items, Smartlist.
• Provide to User on application activities.
• Developing Hyperion Financial reports & OBIEE reports
• Documentation of all the technical and functional issues which would be helpful to users for future .
• Requirements gathering for the implementation of Hyperion DRM
• Was responsible for administrating the task of maintaining the server, providing user security and application maintenance.
• Building financial reports for co-operate using Hyperion Financial Report.
• Write and designing a test case strategy.

Confidential, NY

Hyperion Essbase/Planning support

Responsibilities:

• Developing the business rules based on the business requirements gathered from client.
• Developing end-to-end planning process, which includes Tasks list, Menu items, Smartlist.
• Provide support & to User on application activities.
• Developing Hyperion Financial reports
• Handling the month close & rolling forecast activities.
• Maintaining security permissions for users and groups.
• Administration of BSO cubes and creating Batch files, rule files using Maxl for data loading.

Confidential, NY

Hyperion Essbase Support

Responsibilities:

• Understanding and gathering the knowledge of the existing process
• Supporting the day to day activities of Essbase.
• Working on Corporate Interface Layer with Datastage team.
• Designing and Reporting for forecasting
• Worked on workforce planning and capital application.
• Provide data integrity and verification of financial reporting using Hyperion FDM application.
• Handling the administration of BSO cubes.
• System life cycle documentation (SDLC) for the changes made to the system.
• Created new complex calc- scripts for data calculations for reporting purposes and also re-scripted existing calc scripts for more effective calculations.
• Data Optimization and performance tuning for Essbase.

Confidential

Hyperion Reports Development & Support

Responsibilities:

• Developing the business rules based on the business requirements gathered from client.
• Developing end-to-end planning process, which includes Tasks list, Menu items, Smartlist.
• Developing Hyperion Financial reports.
• Maintaining Planning related Shell and Maxl scripts.
• Migration of Business rules, Reports etc.
• Setting up the properties, properties categories, system ps and queries in DRM.
• Testing new business rules and calculation scripts as per the requirement.

Confidential

Hyperion Developer

Responsibilities:

• Complete End to End migration of Application from pre system 9 to System 9
• Mapping of all source feed in system 9 environment.
• Migration of all system dependencies on new system (Appworx Chains for
• Automation).
• Creation of HAL Jobs for building Planning dimensions, Loading formulas and UDA.
• Documentation of design document and issue tracker.
• Worked technically on the POC (Proof of concept) and presented the POC to the client.
• Updating the data feeds from both the legacy GL (turn the feed off) and the single instance GL (turn the feed on)… Utilizing 1 single feed from the single instance GL.
• Data validation of the new feed, recon of data between Essbase and GL feeds.
• Essbase cube optimization to reduce the size of .pag files.
• Creation of validations and verifications as per the Business needs for validation of data through DRM.
• Was responsible for importing and exporting of data using Hyperion DRM from E-Business Suite.
• Link Processes, MDM, Load rules and Business Rules
• Understanding the allocation logic and developing the calculation scripts based on the user requirement.
• Developed Excel models for reporting, Excel Add-in, to end-users,
• Installation of Hyperion Software (EIS, EAS), Developer.
• Development - Metadata/ Data Upload/ Data Transfer.
• Understanding the model Functionally
• Used Hyperion Application Link (HAL) to integrate for data sources to Hyperion Planning database.
• Replacing existing planning model with the Webforms and Business rules.