Sr Hyperion Developer

5/2011 – offen

Coordinated the alternate hierarchy design change in Management reporting Essbase cubes in version 11.1.3
Enhanced existing drill thru reports setup using Hyperion Essbase integration services 11.1.3
Debugged issues in GL security refresh jobs refreshing security filters and groups.
Streamlined Geography and Line of Business alternate hierarchy refresh process for Management essbase cubes.
Setup automated unix scripts to generate reports to track last user login information and user group information from essbase for audit team .
Coordinated the design and development of a maxl scripts to assist removal of users from groups in Hyperion Shared Services 11.1.3.
Assisted client is setting up Hyperion Financial Reports to track Account metrics for rolling thirteen periods
Migrated Report provisioning using LCM Utility in Hyperion Shared services from one server instance to the other.
Facilitated the design and development of Responsibility owners reports using Hyperion Financial Reports 11.1.3.
Provided solution to client business team in scheduling Hyperion Financial Reporting Batches via a unix script.
Created complex stat line formulae using MDX functionality in management cubes.
Performed shakeout of all testing instance post sever upgrades and cloning
Debugged data load and performance issues in GL Cubes in UAT environment and provide solution to stabilize the jobs.
Provided IBM leadership team with weekly status tracker updates on status of work done by team members.

1/2008 – 5/2011

Designed and Developed the Services Sales Reporting Essbase cube in Hyperion Essbase v 9.3
Responsible for maintenance and support of Sales Compensation essbase cube.
Setup COGNOS reporting tables in SQL Server 2005 for Open order reporting.
Developed Supply chain reporting cube in Hyperion Essbase v 9.3
Designed weekly automation process to refresh source data and refresh Services Sales Reporting Essbase cube.
Setup OLAP models and meta-outlines in Hyperion AIS v 9.3 for designing the Supply chain reporting cube.
Maintained SAP source data uploads and weekly essbase Serial cube refresh in Essbase v9.3
Designed process to weekly refresh COGNOS reporting tables for Full stream serialization project.
Updated the excel vb macros in Salescomp excel reports as per business requirements.
Responsible for loading feeds, refreshing indexes and doing monthly currency conversions for Opera Macro cube.
Carried out monthly feed and index updates for Procurestaff and SHI Opera cubes.
Created new GSO dimension in Opera Analytics Macro map based on inputs from business.
Set up user accounts on Opera production server as per business request.
Set Amex essbase reporting cube to track employee spending done through Amex corporate card
Coordinated essbase cube design and training session with Supply chain transportation team.
Setup users in Hyperion Workspace to access Hyperion Web Analysis 9.3
Coordinated feed requests and feed format changes between Opera feed owners and business community.