Oracle EPM Engineer

Insight Global is looking for an Application Engineer for a top client based in San Jose, CA. This role serves as liaison between business customers and applications systems for development of new systems/business processes or changes to existing processes/systems, Provides technical assistance to customers in resolving day-to-day systems or business, problems which may include specific project support or computer-based applications, Participates in inspection/audits and conducts control evaluations, Analyzes and researches new or existing products, systems, procedures, and/or work flow needs; recommends solutions/action, Participates in or conducts post-implementation analyses, Determines and performs required testing activities for new and modified systems, Develops integrated test plans based on customer requirements, Analyzes testing criteria for specification compliance, Develops test data, executes testing and documents results, Coordinates and maintains simulated production environment

Will serve as a SME in maintaining and enhancing PayPal global budgeting, forecasting & long-term planning systems. Support multiple Planning and Consolidation applications in Oracle Essbase (IaaS/PaaS) and SaaS EPM Cloud environments.
Responsible for performance tuning and optimization of Planning and Consolidation applications.
Ability to work both individually and within a team environment.
Proven experience in providing system support and direct contact with users to solve issues with business applications.
Conduct testing, including system, integration, performance, and user acceptance testing.
Prepare and maintain necessary documentation including design documents, test documentation, training materials, and administration/procedural guides.
Develop Complex Business Rules in both calculation manager and Groovy.
Script using Python/Groovy/CDM APIs and utilize EPM Automate to automate data admin activities.
The Hyperion / Essbase Developer must have hands-on implementation, development and support experience, preferably gained within one or more financial institution.
Skilled in Partitioning, automation, optimization and performance tuning of Essbase application data/metadata processing, upgrading, testing and migrating of cubes in different environment.
Update logical and physical database designs with requested or required changes
Provide input and expertise on architecting and designing system enhancements or creating new
Develop and maintain Block Storage Outline / Aggregate Storage Outline (BSO/ASO) cubes
Create and maintain data forms, calculation scripts, MAXL automation, schedule jobs using batch scripts and business rules.
Expertise in writing custom Essbase calculations scripts, MDX scripts, automated the Essbase Cubes using MaxL, Esscmds and Batch Scripts.
Prepare test cases and effectively conduct unit testing, including interacting with business users to validate results.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal. com.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .
- Finance and Revenue background
- EPM, Oracle 19C or 21C 6+ years
- Experience in Performance Optimization of Planning application which includes data load process / Business Rules / Cal script and reporting Methods.
- Proficient in writing complex code in Calculation Scripts & Business Rule
- Financial process and functional knowledge

#J-18808-Ljbffr