Programmer Analyst

AdvanSoft; Arlington Heights (IL); On-site; USD 105,000 - 150,000; Full time

Benefits offered by this job

Job summary

AdvanSoft is seeking an experienced Programmer Analyst in California to lead Oracle ERP interfaces and integrations. The role requires extensive Oracle EBS/Cloud, SOA, and data integration expertise, with heavy SQL/PL/SQL and OA Framework work across UNIX/Linux environments.

You will collaborate with business SMEs, Information Services, and cloud services teams to design, test, and deploy enhancements and migrations. Strong analytical and communication skills are essential.

Qualifications

• 8+ years of experience in Oracle ERP interfaces and integrations.
• Strong background in Oracle EBS/Cloud and Oracle Fusion Cloud.
• Proficient in SQL/PL/SQL and OA Framework customization.

Responsibilities

• Consult with business SMEs to configure Oracle interfaces across the client’s org.
• Coordinate with Information Services, Oracle Support, and OMCS for requests.
• Analyze functional specs and work with devs on design changes.
• Enhance business processes via customization and automation.
• Prepare cost-benefit analyses for system implementations.
• Develop functional specs for load programs.
• Recommend upgrades for Oracle Cloud ERP, OIC, and SOA/BPM suites.
• Review ERP performance and fix code issues via scripts.
• Define inputs and distribute reports and analytics.
• Perform unit testing, IT testing, and assist UAT with test scripts.

Skills

Oracle EBS/Cloud

JavaScript

JET Framework

SOA Cloud Service

SOA Suite

BPM

SQL

PL/SQL

OA Framework

Web Services

XML/JSON

XSLT

Tableau Reporting

UNIX/Linux

Toad

JDeveloper

ODI

Education

Bachelor's degree in Information Systems/CS/Eng

Tools

ODI

Toad

JDeveloper

SQL*Loader

XML Gateway

Job description

Position : Programmer Analyst

Location : CA

Education : Bach in Information Systems, Computer Science, Computer Applications, or related Engineering discipline, or equivalent

Job Type : Full time

Experience : 8+ Years

Skill Set : Oracle EBS/Cloud: Oracle Applications R11i & R12; Oracle Fusion Cloud Applications; Oracle Integration Cloud (OIC), JavaScript, JET Framework, Oracle SOA Cloud Service (SOA CS), Oracle BPM 11g/ 12c Suite, and/or Oracle SOA Suite 11g/ 12c Suite (Service Bus, BPEL, BAM, BPEL, OSB, Web Services, WSDL, SOAP, XML/JSON, XSD, XSLT); Modules: Application Object Library, Oracle Alerts, Sys Admin, General Ledger, Subledger Accounting (SLA), Payables, Receivables, Purchasing, Oracle Inventory, Order Management, Approvals Management Engine (AME), Oracle iProcurement, Oracle iExpenses, Oracle HCM, Oracle Projects, Service Contracts; Technology/Languages: SQL, PL/SQL, OA Framework (OAF) Customizations; Personalizations, SOA, Oracle ADF, Advanced Queuing (AQ), Workflow, Oracle Forms and Reports, Forms Personalization, XML/BI Publisher, Core Java, Oracle Discoverer, Tableau Reporting, UNIX Shell Scripting, Environments: UNIX, Linux, and Windows NT; Relational databases (Oracle 10g/11g/12c), Web services (SOAP, REST, WSDL, XML, and other API standards); DevOps tools for CI/CD, on-prem & on-cloud GUI: Forms 6i/9i/10g/11g/12c & Reports 6i/9i/10g/11g/12c, Workflow Builder; Tools and Utilities: JDeveloper 11g/12c, Oracle Data Integrator (ODI), XML Gateway, SQL*Loader, Toad, Utl-file; Office Tools: MS Office suite (Word, Excel, PowerPoint)

Job Responsibilities

• Consult with business SMEs and Operations teams to ensure all Oracle interfaces are configured, tested and working properly across client’s organization
• Coordinate between Information Services and the Business, Oracle Support and OMCS (Oracle Managed Cloud Services) for Service Requests and problem resolution to expand or modify system to serve new purposes or improve work flow and incorporate IT best practices.
• Analyze functional specifications, closely work with stakeholders on design change and work with development team on customization.
• Work on enhancements in existing business processes through customization or automation, gap analysis, blueprint design, assisting business workshop and validation of functionality.
• Prepare cost-benefit and return-on-investment analyses to aid in decisions on system implementation.
• Analyze and prepare functional specification documents for technical team to work on code changes for load programs.
• Recommend new equipment or software upgrades/packages in Oracle Cloud ERP; OIC; BICC
• Review and analyze Oracle ERP performance indicators to locate code problems, and correct errors by correcting code scripts.
• Specify inputs accessed by the Oracle EBS system and plan the distribution and use of the reports and analytical results for decision making and business analysis
• Responsible for performing unit testing, IT testing and assist in UAT. Creation of test scripts using tools like SQL, Toad
• Analyze the Oracle SaaS APIs/Integrations, connection adapters, Connectivity Agents, Exception handling with Fault handlers and Global fault handlers
• Assist all phases of project from requirement gathering to analysis, testing, cut over, go-live, data migration and hyper care support.