Project Data

HCL Confidential Submitted to TIAA-CREF *

Mohammad Gayazuddin

SUMMARY:

3+Years of experience in Oracle Hyperion Applications.

• Over 3+ Years of experience in Oracle Hyperion Applications.

• Having good knowledge in BSO and partial knowledge in ASO database

• I Have Good knowledge in Planning Classic Applications.

• Performed metadata loading using outline load utility for different dimensions.

• Worked in teams to develop and MAXL scripts for nightly maintenance of the applications and databases.

• Involved in creating the Data forms (Web forms) for the data representation for the end users.

• Support all applications development effort involving Hyperion planning applications and Essbase.

• Strong experience as Hyperion Essbase Cube Optimization, Dense and Sparse settings, database backups, partitioning, etc.

• Good knowledge on implementation projects.

• Assigned privileges to users through Shared Services.

• Good knowledge in outline design, script writing and optimization.

• Monitored logs for all the nightly processes in the morning and performed relative actions to rectify any Errors occurred during the scheduled nightly processes.

• Involved in resolving issues tickets by priority wise.

• Experience in Backup and Recovery of Database Objects and Shared Services.

• Work with the off-shore team.

• Contacted Oracle for product support and submitted SR for different issues.

• Worked on the Hyperion services when there are any server issues.

• Meetings with the business users to understand the requirements for any new deliverables.

• Involved in resolving tickets for Essbase issues.

• Documenting each and every step of the process.

• Having good knowledge in 9.x.x.x to 11.x.x.x Essbase migration.

• Involved in gathering requirements from Users and developing reports.

• Good knowledge of using LCM migration.

Technical Skills:

Category Details

EPM Tools Hyperion Planning, Hyperion EPMA, Essbase 9.X/11.1.X/11.2.X Data Bases Oracle/SQL

Operating Systems Windows 2003/2008 server, Windows XP/7/8 OLAP Tools Hyperion Financial Reporting 9.X/11.1.X/11.2.X,Essbase Add-in Application Package Essbase Add-in

Project Management Tool Rally Enterprise 2003 - 2008, Build: 146 Version Control Tool Hyperion Essbase Services 11.1.1.x, Hyperion Administration Services 11.1.1.x,Excel add-in

HCL Confidential Submitted to TIAA-CREF 2

Professional Experience:

• Working as a Hyperion Developer for HCL technology from Jan 2016 to till Date. Project Experience:

Project: Britvic Hyperion Support Sep 2017 – Till Date Project Description: Britvic is an United Kingdom and Ireland. Product based company. We have 2 ASO cubes and 2 planning cubes. We need to update FDMEE and DRM on monthly Basis. Responsibilities:

• Daily status mail has been sending to user and team after refreshing the cube data.

• Monitoring and fixing of tidal jobs.

• Every 4

th

weekend I have perform DR activity.

• Every 3

rd

weekend I have perform Defragmentation activity.

• Every 2

nd

weekend I have perform OS patching activity.

• Every Friday end of the day I have Updating substation variables.

• As per user request I have updating new PIBS in application.

• As per request outline from migration STG To PRD.

• Maintaining of application services

• Providing access to HIR / HFR requests.

• Providing application level access to users

• Scripting creation/updating during Automation of Jobs

• Metadata maintenance as per the request.

• Raising CR requests as per need.

• Providing access to Essbase / FDMEE requests.

• Incident Management (Handling of incidents)

• Providing application level access to users

• As per request data from migration PRD To STG

• At the end of the month, submitting KEDB document. Project Experience:

Project: Veritas Hyperion Support Sep 2017 - Sep 18 Project Description: Veritas is an American international data management company. We have 3 BSO cubes and 3 planning cubes. We need to update FDMEE and DRM on monthly Basis. Responsibilities:

• Daily status mail has been sending to user and team after refreshing the cube data.

• Monitoring and fixing of tidal jobs.

• Resolving HIR error.

• As per request outline from migration STG To PRD. HCL Confidential Submitted to TIAA-CREF 3

• Updating variables.

• Maintaining of application services

• Providing access to HIR / HFR requests.

• Providing application level access to users

• Scripting creation/updating during Automation of Jobs.

• Metadata maintenance as per the request.

• Raising CR requests as per need.

• Providing access to Essbase / FDMEE requests.

• Incident Management (Handling of incidents)

• Providing application level access to users

• As per request data from migration PRD To STG

• At the end of the month, submitting KEDB document. Project Experience:

Project: Staples Hyperion Support Mar 2017 - Aug 17 Project Description: Staples is Walmart Company. We have 6 ASO cubes. We need to update people soft and FDMEE on monthly basis.

Responsibilities:

• Maintaining of application services

• Daily status mail has been sending to user and team after refreshing the cube data.

• Providing access to HIR / HFR requests.

• Monitoring and fixing of tidal jobs.

• Resolving HIR error.

• As per request outline from migration STG To PRD.

• Updating variables.

• At the end of the month, submitting KEDB document.

• Raising CR requests as per need.

• As per request data from migration PRD To STG.

• Providing access to Essbase / FDMEE requests.

• Incident Management (Handling of incidents)

• Providing application level access to users

• Scripting creation/updating during Automation of Jobs

• Metadata maintenance as per the request.

HCL Confidential Submitted to TIAA-CREF 4

Project Experience:

Project: Incyte Hyperion Support Oct 2016 - Feb 17 Project Description: Incyte is pharmaceutical company. We have 3 BSO cubes and 3 Planning cubes. We need to update people soft and FDMEE on monthly basis. Responsibilities:

• Maintaining of application services

• Health check of critical application during week end

• Incident Management (Handling of incidents)

• Providing application level access to users

• Scripting creation/updating during Automation of Jobs

• Document creation for new tasks

• Metadata maintenance as per the request.

• Update/Modify data forms as per the requirement. Project Experience:

Project: TIAA WITF A50 CSEB FACT Prod. Supp. Jan 16 - Sep 16 Project Description: TIAA is an insurance company. we have 3 ASO cubes and 3 Planning cubes. We need to update meta data from DRM and data comes PeopleSoft on monthly basis. Responsibilities:

• Creation and design Essbase BSO and ASO application.

• Extensive experience in End-to-End development process till product implementation and support process.

• Worked with BSO to store different types of multidimensional data.

• Optimized the database calculation and loading performance.

• Created Ad-hoc reports for client end.

• Written MaxL Scripts to automate the process of dimension build and data load.

• Month close, update data and meta data and daily support and Reconciles monthly twice

• Application level access provide users.

Contact this candidate