Oracle Functional Analyst

The Timberline Group; St. Louis (MO); On-site; USD 110,000 - 140,000; Full time

Job summary

The Timberline Group is seeking an Oracle HR/OAB ERP Developer to support development, maintenance, and deployment of Oracle HCMS functionality. The role focuses on HR/OAB modules and requires collaborating with business customers and the technical team to determine and implement changes that improve business processes and overall effectiveness.

Responsibilities include gathering and evaluating business requirements, designing and testing new Oracle capabilities and configurations, investigating

Qualifications

• Oracle Applications ERP Developer experience with HR, Benefits, ESS, and MSS.
• Develop and execute QA test plans for unit, system, and regression testing.
• Build interfaces or data conversion between Oracle HR, Payroll, and Benefits and other systems.
• Build fast-formulas and reports for Oracle HR, Payroll and Benefits.
• 70% technical and 30% functional role.
• Experience using data loader and SQL Loader to load legacy records into Oracle.
• Ability to develop complex SQL queries.
• Experience with relational DBMS such as Oracle and SQL Server.
• Experience with Oracle Alerts.
• Experience using Oracle Reporting (Admin and User layers).
• Knowledge of Oracle Forms and Reports.
• Expertise in Conversion and Interface programming using PLSQL.
• Understanding of IT standards, procedures and best practices.
• Understanding of how to analyze and solve business problems.
• Interpersonal skills to interact with all levels of technical and business personnel.
• Experience designing, developing and maintaining IT systems.
• Experience participating in project teams.
• Ability to work independently, under pressure, and meet schedules.

Responsibilities

• Gather and evaluate business requirements; determine approach using Oracle capabilities and customizations.
• Develop, test, and implement new Oracle capabilities, customizations, or configurations.
• Investigate Oracle HCMS data/interface problems; determine resolutions.
• Work with business customers to identify improvements or new capabilities benefiting the organization.
• Document and estimate requests for new capabilities; assess organizational value.
• Assist in developing recommendations, business cases, and estimates for new functionality and changes.
• Document Oracle HCMS configuration and support info per Metro IT standards.
• Coordinate with Metro infrastructure, database, and app teams for proper testing.
• Assist with orientation and training of Oracle end users/customers as appropriate.
• Mentor other IT team members to grow capabilities.

Skills

Oracle HR/OAB

SQL Loader

PL/SQL

Oracle Alerts

Oracle Reports

SQL queries

Interpersonal skills

Independent work

Oracle Forms

Interfaces

Tools

Oracle Database

SQL Server

Job description

To support development, maintenance, and deployment of functionality related to Client’s Oracle HCMS E-Business Suite. This position will focus on the Oracle HR/OAB area and requires working with our business customers and our technical team to determine and implement Oracle HCMS related changes that improve business processes and business effectiveness.

Responsibilities

• Gather and evaluate business requirements. Determine approach to meet requirements with Oracle capabilities and customizations.
• Develop, test, and implement new Oracle capabilities, customizations, or configurations.
• Investigate Oracle HCMS functionality, data, and interface problems. Determine and implement resolutions.
• Work with business customers to identify improvements, alternatives, or new capabilities that would benefit the organization.
• Document and estimate specific requests for new capabilities. Help to assess the value to the organization.
• Assist with development of recommendations, business case, and estimates for new functionality and changes.
• Document Oracle HCMS Configuration, support information, customizations in accordance with Metro IT standard application methodology.
• Work with Metro infrastructure, database, and application teams to ensure proper unit, system, user acceptance, and performance testing.
• Assist with, as appropriate, orientation and training of Oracle end users/customers.
• Mentor other IT team members as appropriate to help them grow in their capabilities.

Knowledge, Skills, & Abilities

• Oracle Applications ERP Developer experience with HR, Benefits, ESS, and MSS.
• Develop and execute quality assurance test plans for unit, system, and regression testing.
• Build Interfaces or data conversion between Oracle HR, Payroll, and Benefits system and other applications.
• Build Fast-Formulas and reports for Oracle HR, Payroll and Benefits.
• This position is 70% technical and 30% functional.
• Previous experience using data loader and SQL Loader to load legacy records into Oracle.
• Ability to develop complex SQL queries.
• Experience with relational database management systems such as Oracle and SQL Server.
• Experience with Oracle Alerts.
• Experience using Oracle Reporting using Admin and User layers.
• Knowledge of Oracle Forms and Reports.
• Expertise in Conversion and Interface programming using PLSQL.
• Understanding of information technology standards, procedures and best practices.
• Understanding of how to analyze and solve business problems.
• Interpersonal skills necessary to interact with all levels of technical and business personnel.
• Experience designing, developing and maintaining information technology systems.
• Experience participating in project teams.
• Ability to work independently, work under pressure, adapt to demanding situations and maintain schedules