SUMMARY

• Confidential has more than thirteen years of experience in IT and eight plus years in implementing the full life cycle projects using Oracle Hyperion suite of products.
• He holds a master’s degree in Business Administration and bachelor’s in electrical and Electronics Engineering.
• He is a Consultant with substantial hands - on experience in implementing and supporting OLAP with domain knowledge on various Industry Verticals such as Financial, Pharmaceuticals, Mobile and publishing companies.
• He involved in budget preparations, forecasting and developed robust modeling and reporting to facilitate executive-level decision making.
• He has strong knowledge on Financial Statements and GAAP.
• He has working knowledge in Oracle Hyperion planning, Essbase and Financial management and Financial Reporting.

TECHNICAL SKILLS

OLAP Tools: Hyperion Essbase 9.3.1, 11.1.2.X, Smart View, Hyperion Planning 11. X, HFM 11.x and DRM 11.X

Reporting Tools: Hyperion Financial Reporting Studio, OBIEE, MS Excel

Training Tools: Oracle UPK 11.1 and 12.1

ERP Systems: PeopleSoft Campus Solutions, GL

PROFESSIONAL EXPERIENCE

Confidential, WA

Principal Consultant

Responsibilities:

• Developed Business Rules for What If Analysis, Tuition Projections and aggregation and budget impacts.
• Worked with budget users and managers to understand budgeting process
• Responsible for migration of SBCTC Planning application to different environments.
• Build the MDX scripts for Data movement between the applications and automated the process
• Optimized the calculation scripts/Business rules
• Developed web forms for LineItem and Human Capital Management module for Budget preparation and Analysis.
• Worked on application creation and migration of all the planning artifacts in multiple environments.
• Performed Data loads and validations/Reconciling data
• Worked on data validation using smart view and comparing with the GL and HCM data from PeopleSoft.
• Developed Training Materials, Workaid, and TestdocumentationsforHyperion and PeopleSoft modules for end users
• Prepared Test scripts for PeopleSoft GL Hyperion Data validation and developed training content using UPK

Confidential, Hampshire, UK

Senior Consultant

Responsibilities:

• Built Hyperion planning application and planning artifacts like webforms, tasklists, business rules as per the functional requirements
• Optimized the calculation scripts/Business rules
• Perform data analysis tasks, validation/reconciliation tasks, perform gap analysis, and mitigate data integrity issues
• Supported HFM and Sales Planning applications.
• Worked on month end closure activities.
• Worked on change requests adding new Sales countries.
• Responsible for metadata changes
• Worked on proportionate consolidations.
• Created member lists.
• Created data forms and data grids.
• Responsible for installation and configuration of Essbase, HFM, HSS 11.1.2.1 on Production and QA Environments.
• Migrated HFM application form old data center to new data center.

Confidential

HFM Consultant

Responsibilities:

• Served as Lead Consultant for HFM Environment design and support.
• Worked on sizing parameters for all the environments.
• Worked with client and end users to identify nonfunctional business requirements to set up the HFM environment.
• Developed documentation on the requirements.
• Responsible for the design and setting up of the below environments:
• Development/Prod Support Dev
• Integration Test/Prod Support Test
• Performance/UAT
• Production

Confidential

Senior Consultant (Hyperion and UPK)

Responsibilities:

• Led a team of 11 people and working as Techno Functional Lead for SLM IP.
• Understood the PeopleSoft Campus Solutions functionality and mapping them into Hyperion Essbase technology.
• Developed ‘Class Demand’, ‘Student Awards’ and ‘SLM’ applications in Essbase.
• Prepared all Functional Design Documents for the project.
• Responsible for task distribution, monitoring the team and making them to understand the requirement.
• Worked in designing the Dashboards ‘SLM’, ‘Student Awards’ and ‘Demand” in the OBIEE.
• Prepared Training module using UPK.

Confidential, New York, NY

Analyst Programmer

Responsibilities:

• Prepared monthly audit logs for HFM and FDM which will be presented during the external audit.
• Developed financial reports like P & L report and Balance sheet reports which will be used by client to publish their P & L statements and Balance sheets.
• Developed Admin Calc ‘HFMESSPRD Process’ which exports, clears data of BSO cubes and perform the aggregations and currency conversions and load the data into ASO cubes for Reporting purposes.
• Worked in production support for HFM, FDM and Essbase applications.
• Facilitated client meetings on audit logs and presented the audit logs to the Application Owner.
• Performed reconciliation activity between HFM & Essbase applications.

Confidential, New York, NY

Analyst Programmer

Responsibilities:

• Developed Business Rule ‘Currency Conversion’ which converts local currency to USD for all Market Entities.
• Developed web forms like ‘Input Exchange rates by Entity’ which will be used by global clients to enter the exchange rates of their entity.
• Created rule file ‘IPM BMSPL’ to load data into a different application that was extracted by the Clac Script from other source.
• Created Task Lists for April, September and Budget Projections.
• Created Task List for April Projections with the following Tasks associated.
• Entered data into Data form associated with a web form (Pre-populated).
• Ran Business Rule associated with Business Rule.
• Validated associated with Financial Report.
• Promoted associated with Workflow (For Approval and Rejection process).
• Worked on dimension modifications to enter the new market entities as per the business requirement.

Confidential, Detroit, MI

Analyst Programmer

Responsibilities:

• Created Business Rule to copy the data across Scenarios and versions.
• Developed different load rules for loading specific type of date files.
• Applied security on different applications by creating filters on its dimension members.
• Executed the MaxL scripts to load the data into different applications.
• Created various business rules and associated them to the required web forms.