POSITION OVERVIEW :OIPA Support

OIPA as primary skill & SQL.

• 4:30 AM to 12 PM hours support

• Working experience in OIPA application

• Good knowledge in SQL

• Experience on production support and monitoring

OIPA Support analyst will work directly with members of the production support, business and technical teams to review and maintain existing business and technical requirements used to configure the OIPA system, resolving issues related to data, interfaces, integrations or cycles.

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, nonforfeiture, 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