AppSierra Solutions - OIPA Support Engineer - Oracle Insurance Modules (5-12 yrs)

Primary Role Duties and Responsibilities :

- Work on problems involving the evaluation of specifications for complex existing business requirements and processes to maintain and modify the technical/functional and documents.

- Work with Service Management, internal and external stake holders to provide solutions

- Perform functional gap analysis, review design documentation and participate in design reviews

- Review and interpret architectural and technical design documents to develop complex OIPA transactions and processes using best practice OIPA configuration techniques

- Review logical queries, calculations, reporting and complex formulas to troubleshoot the tickets

- Develop Technical configuration and SOP Documents

- Perform code reviews, migrations smoke testing

- Strong understanding of OIPA database schema and relational objects inherent to it

- OIPA daily Activity Error Report Review

- Document and share findings with the build team if the issue need to be fixed

- OIPA Cycle Support - Failures, SLAs exceeded

- Fluent in OIPA integration patterns (AS file, OIPA extensions, Web Services/API)

- Troubleshoot REST or SOAP services for integration failures or issues

- Expertise in entity based logical modeling and data throughput optimization

- Provide XSLT and OIPA configuration support for migrations or troubleshooting

- Collaborate with cross functional teams to align business intent with system behavior

- Understanding of OIPA schema and ability build SQL statements for application data related issues.

Required Skills :

- Excellent working knowledge of insurance life and health products for individual, group and worksite markets

- 4 years of hands on configuration experience on life or health products using OIPA V10 or V11

- LOMA certification and knowledge of typical insurance business functions including: underwriting and policy issue, payment processing, monthaversary, anniversary, disbursement, withdrawal, correspondence, non-forfeiture, lapse processing, state reporting, billing, policy servicing, product set-up, health claims processing, life claims processing

- Knowledge of Oracle SOA and BPM is desired

- Experience or Knowledge of OIPA interface configuration