Hyperion Infrastruure Support Resume
CT
Professional Summary:
- Three years of experience in Hyperion Infrastructure Support and Hyperion Products: Essbase, Planning, Reports, EAS, Sys9, MDM, HAL, Hyperroll, Appworx
- Extensive experience in migrating/deploying Planning/Essbase Applications among development, testing and production environments.
- Experience in Performance/UAT testing of Hyperion Applications.
- Extensive experience in installing Hyperion Essbase, Planning, Reports, Analyzer, EAS, on UNIX and Windows Operating Systems.
- Experience working on WebSphere and Weblogic application servers.
- Extensive experience working on windows, UNIX and Linux environments.
- Experience in Leading Implementations and Installations.
- Team Lead with excellent Analytical, Communication and Trouble shooting skills.
- Received “Service Excellence Award” from GE Commercial Finance for outstanding performance in Hyperion upgrade from 6.5 to 7.0 Version.
- Self-Starter and Adaptive to new technologies.
OLAP: Hyperion Essbase 7.0/ 6.5/6.2/5.0, Hyperion system 9i, Hyperion Planning,
Hyperion Analyzer, Hyperion Reports, Hyperion Enterprise, Excel, Smart View,
Hyperroll 4.2, EAS 7.x
Languages: SQL, PL/SQL, C, C++, Java 1.2
Databases: Oracle 9x/8i
Operating Systems: UNIX, Linux Windows 9x/2000/2003/XP, MS-Dos.
Tools/Utilities: Oracle Toad, RMI, Appworx
Emulation: Putty, Telnet and Windows Terminal Server
Web Design: HTML
Professional Experience:
Confidential June 2006 to February 2009
Project 1: Hyperion Infrastructure Support
Client: Confidential Danbury CT.
Abstract: GE Commercial Finance is one of General Electric's largest "growth engines" with Lending Products, Growth Capital, Revolving lines of Credit, Equipment Leasing of every Kind, Cash Flow Programs, Asset Financing, and more. GE Commercial Finance plays a key role for client businesses all across the world. Hyperion is implemented in all of the GE COMFIN businesses (CFS, CAP, EFS, HFS, GECAS, CFA and CSE), with all business reporting to CFC (Corporate).
Role: Hyperion SME Team
Hyperion SME is the Hyperion Infrastructure Support team in GE that provides 24/7 support on Hyperion Applications across the GE COMFIN domain. The team consists of six members (5 offshore, 1 onsite support). Currently the SME (Subject Matter Expert) team supports nine businesses across GE Comfin.
Responsibilities:
- Mastered high level trouble shooting of all the infrastructural activities related to Hyperion products (Hyperion Essbase, Planning, EAS, Reports, Analyzer, Hyperroll, HAL)
- Individually handled many outages (planned as well as unplanned) like reboot of all the servers which happens on every third fiscal week, day light savings, os patches etc.
- Pioneer (in the team) in preparing proper SOP’s for all the Hyperion infrastructural activities (migrations, DR process, access related issues, automations using Appworx)
- Played a pivotal role in installation and upgradation of Hyperion Essbase, Reports, HAL between different environments for CFA, CAPSOL, CSE business.
- Handled migration of applications (all data and level 0) between different environments.
- Played a vital role in resolution of infrastructural issues on server-side before going-live in production.
- Installed Essbase on Linux, Planning on Windows 2003, Reports on UNIX, Planning Web
- Automated the backup process for all the applications of all environments using Appworx tool.
- Took the lead in Disaster Recovery process when all the production servers went down.
- Trained new Associates joining the team.
- Hands-On experience in writing queries in database and shell scripts in UNIX.
- Good hold of UNIX commands and Appworx tool which involves creating and trouble shooting chains.
- Found out the root cause (RCCA) of application corruption due to signal 11 crash in Essbase 6542 version. Implemented the fix in all the environments (prod, qa and dev). Was involved in coming up with a permanent fix to all the issues, which were repeating.
- Worked closely with Hyperion Support (USA, Aus and Europe) Analyst’s for unresolved issues faced during troubleshooting Hyperion products.
- Presented many lean (which reduced lot of Non value added work) like creation of chain to restart 20-25 server’s at a single go using appworx tool, automated the reports restart on 16 servers with one login.
- L1-certified in the project
- Applying RCCAs (Root cause corrective action) for repeated issues
- Creation of Applications in System9 environment.
- Handled migrations (both Essbase and Planning), adding user and groups in System9 environment
- Involved in documenting all the RCCA’s, PPA , SOP’s and more
- Supported more than 30 applications in production both functionally and technically.
- Took Ownership and lead the Defragmentation maintenance for all critical production applications in order to make smooth Quarter close
- Automated the CFS business activities through appworx chains which updates the new accounts in Essbase closing cubes on daily basis, with Zero Defects, resulting in NO Manual dependency on Nightly Cycle processes
- Took charge of maintaining GIS Outage Tracker for all GE COMFIN business consistently for a very long period.
Environment: Hyperion Essbase 6.5.4.2/ 7.1.5 Sys 9i, Planning 3.0/3.5.1, Reports 7.0.1.2, HAL7.0,
Websphere 5.0, Weblogic, Oracle 8i, Oracle GL, Hyperroll 4.2, Windows 2003 server,
Linux, UNIX.
Project 2: Hyperion Server Upgrade from 6.5 to 7
Client: Confidential Danbury CT.
Role: Team player
Responsibilities
- Involved in setting up users, disk space, servers and prerequisites creations for new Installations.
- Performed Essbase Upgrades/Migrations from version 6.5.4 to 7.1.5 for all business.
- Played a key role in the performance testing of planning and closing applications before being deployed to production.
- Troubleshooting issues during 7 version installation/Application migrations.
Environment: Hyperion Essbase 7.15, Linux, Hyperion Planning 3.0/3.5.1
Project 3: Hyperroll Server Upgrade
Client: Confidential Danbury CT.
Role: Team player
Responsibilities
- Gathering Prerequisites for Hyperroll Upgrade
- Working with client and gathering requirement
- Prepared implementation/Rollback plans for Upgrade
- Assigning different tasks to offshore team.
- Resolved Pre/Post Installation issues.
- Played a key role in UAT after upgrade
Environment: Hyperroll 4.2 version, Linux, Hyperion 7.1.5version
Project 4: Hyperion MDM
Client: Confidential, Danbury CT.
Role: Hyperion MDM System Administrator
Abstract: GE Commercial Finance uses a centralized approach for managing all its dimensional Master Data related to all its businesses. All the hierarchal Meta Data is now maintained in a centralized server called as Hyperion Master Data Management. It provides a centralized, transparent process for managing critical business performance management master data that drive enterprise reporting.
Responsibilities:
- Involved in Creation, Deletion and Managing of Users and groups and troubleshooting access related issues.
- Assigning of Node access group and property categories to Users and groups.
- Creation and deletion of Versions, Hierarchies, Exports, Imports, Properties, Property Query, Node Access groups, Blenders, System categories
- Adding properties to Property categories and
- Creation of Node Types and adding Properties and Validations/Verifications to Node types
- Creating Validations/Verifications and applying them to hierarchies.
- Creation and running of Automators to load and alter Metadata in MDM hierarchies.
- Involved in Creating of Blender to synchronizing two hierarchies of different version in terms of their structural differences
- Automated the import and export process of MDM hierarchies using Appworx tool
- Handling and troubleshooting issues related to MDM.
- Automated the MDM migration process and handled migrations between different environments.
Environment: Hyperion MDM 9.2.0, Windows Server Enterprise version 2003, MS-SQL, Appworx 6.1
Education:
Bachelor of Technology in Computer Science
Achievements:
- Received numerous VOC’s and awards from Client (GE) and Employer (Genpact) for project executions.
- Awarded Star Player of Genpact for excellent performance during critical situations.
- Bronze Award from AVP of Genpact for successful project deliverables.
- Awarded Star Player of the year 2008 from GE (client-side).
- Was awarded Certificate by GE COMFIN Client for an outstanding performance and contribution to the organization during Hyperion Version Upgradation and Hyperroll Upgradation