Sr. Hyperion Lead @ Dallas, TX
DILEEP k
Please find the below requirements and forward suitable resumes to recru...@aptivacorp.com
Note: PASSPORT & Visa Copy MUST for Submission No H1 Transfer candidate No OPT
Position: Sr. Hyperion Lead
Location: Dallas, TX
Duration: 6+ Months
Job description:
Essential Functions:
· Design, develop and deploy enterprise scale Essbase applications to meet ad hoc analysis and reporting needs based on business requirements.
·Provide technical support for Essbase Administration Services (EAS), Hyperion Shared Services, Financial Reporting Studio, and Hyperion Workspace.
·Develop and maintain Essbase Outlines, Calculation Scripts, Dimension Builds, Data Loads, Report Scripts, and Batch Automation Scripts (MaxL and MSH).
·Perform Essbase data loads from disparate data sources including data validation and discrepancy correction.
· Develop and maintain SQL scripts to facilitate data staging and loading.
· Responsible for managing and monitoring Hyperion load process (ad hoc requests and nightly scheduled loads) and addressing load issues.
· Perform exports of Essbase data to downstream applications & databases.
·Thorough understanding of Dense/Sparse settings, dynamic calculations, and development best practices for Essbase Outlines.
· Technical Knowledge of Outline development functionality such as Attribute Dimensions, User Defined Attributes (UDAs), Substitution Variables, Aggregate Storage (ASO), and Block Storage (BSO).
·Optimize and tune Essbase applications to enhance performance for data loads, aggregations & calculations, and data retrievals.
· Manage Security Provisioning by maintaining users, user groups, and access security privileges.
·Provide support for the Smart View Excel Add-in including VBA programming.
·Develop Planning & Forecasting applications and maintain business rule logic and web forms.
·Design, develop, and maintain Hyperion Financial Reports.
·Fulfill complex ad-hoc queries, analysis, and reporting requests submitted by business users.
· Provide ongoing support to business users for daily operational requests and issue resolution for a user base of 200+ global users.
· Participate in annual audit of applications and semi-annual user access review.
· Ensure application compliance with policies, procedures, and change control process.
· Play a key role in project rollouts including new development, enhancements, and upgrades.
· Develop and execute unit, system integration, and user acceptance test plans to support application testing.
· Create application specific training materials and conduct end user training sessions to support the business communit