Application Systems Analyst II

Why Merit?

At Merit Medical, our mission is to create innovative medical devices that improve lives. Our goal is to hire and develop people who want to build something special through hard work, team effort, and commitment. Together, we are making a difference in the lives of patients around the world.

WORK SHIFT

DAY (United States of America)

SUMMARY OF DUTIES

This position is responsible for management, implementation, administration and training of specific Application Systems projects and functions worldwide.

JOB DUTIES

• Provide Functional/Technical support for various Oracle EBS Applications which includes but not limited to Accounts Payables (AP), Accounts Receivables (AR), EBusiness Tax (EB Tax). General Ledger (GL), Fixed Assets (FA), Cash Management (CM), and Costing.

• Build custom Accounts Receivables (AR) reports, Accounts Payables (AP) reports, custom A/R Aging Bucket reports, Cash Receipt Applications reports requested by accounting departments using SQL Developer.

• Support and resolve issues in AR Balance Forward Billing (BFB) Invoicing process and extract BFB data using Oracle SQL to upload to customer's web portal.

• Build custom Oracle Fixed Assets, General Ledger (GL) reports for Audit and Reconciliation Purposes.

• Implement Electronic Payment Files in Oracle Accounts Payables (AP). Setup Payment Templates as per HSBC Bank 's Payment Specification document.

• Assess and plan financial system needs. Responsible for working with Accounting, Financial Planning & Analysis (FP&A), Costing, Treasury, and Tax departments to determine what system improvements are needed to maximize efficiency and accuracy.

• Provide support for Accrual Accounting, Accrual Reconciliation Reports and resolve issues in R12 Period End Accruals for Expenses.

• Create customized financial data reports required for Financial Planning and Analysis (FP&A) using SQL.

• Design AP Expense reporting tools, Sales tax tools, Cash management, workflow management, General Ledger (GL) reconciliation software, and automated receipt applications.

• Write PL/SQL packages to Import Expenses from third party application Concur Expense to Oracle AP and resolving the issues during the import/export process.

• Resolve period close accounting issues, help end users to fix transaction interface errors submitted in ServiceNow Ticketing system in in Oracle Accounts Payables, Accounts Receivables, Costing, General Ledger, and Order Management modules.

• Create Software change requests, upload Test cases, and Test Results in Jira.

• Create dashboards in ServiceNow Ticketing systems for resolving and monitoring issues submitted by Business users.

• Update/Load data in Oracle in AP, AR, and GL.

• Configure, Customize, and support Oracle CM for MT940 Bank Statement file format.

• Design, Configure, Test and Document the Procure-to-Pay (P2P), Order-to-Cash (O2C) business cycles in Oracle EBS R12 Financials and Sub Ledger Accounting (SLA).

• Design and implement Oracle Financials Applications systems and extract Financial Applications data for Blackline reconciliations.

• Responsible for finding areas for improvement during their assessment and planning of system needs, and responsible for designing new processes and systems to meet those needs.

• Responsible for investigating new solutions, understanding what software systems are available, working with end users to explain how the system would work, and then putting together a plan on implementing the system.

• Design system and built-in house and using knowledge of Management Information Systems (MIS System Analysis) to provide expert guidance.

• Provide training to end users and create user manuals for future reference.

• Perform Ad Hoc reporting, data extraction using knowledge of the underlying data architecture of all systems within their area of responsibility, including Oracle EBS version R11, R12.1.3 or later and any secondary systems the candidate has designed or implemented.

• Configure R11, R12.1.3 Modules E-Business Tax, AR, AP modules to integrate with Vertex Q series third party Tax application and providing support to resolve the issues related to Tax Invoices.

• Perform data extraction using knowledge of database architecture, specifically relational databases, as well as reporting tools such as SQL Developer, BI tools (Domo), Excel, Word, and using excellent SQL language skills.

EXPERIENCE REQUIRED: 4 years' experience as Applications Systems Analyst, Oracle Systems Developer, or other closely related IT occupation.

DEGREE REQUIRED: Bachelor of Science degree in Management Information Systems, Financial, Information Systems, or Operational Information Systems.

SPECIAL REQUIREMENTS:

Demonstrable knowledge of and prior experience in:

• Configuring Oracle E-Business Suite version R11, R12.1.3 or later. integrate with Vertex Q series third party Tax application.

• Building custom Accounts Receivables (AR) reports, Accounts Payables (AP) reports, custom A/R Aging Bucket reports, Cash Receipt Applications reports requested by accounting departments using SQL Developer.

• Data base architecture, specifically relational databases.

• Providing support for Accrual Accounting, Accrual Reconciliation Reports and resolving issues in R12 Period End Accruals for Expenses.

• Resolving period close accounting issues, helping end users to fix transaction interface errors in Oracle Accounts Payables, Accounts Receivables, Costing, General Ledger, and Order Management modules.

• Resolving issues in A/R Balance Forward Billing (BFB) Invoicing process and extract BFB data using Oracle SQL to upload to customer's web portal.

• Extracting Oracle Financial Applications data for Blackline reconciliation third party application.

• Updating/Loading data in Oracle in AP, AR, and GL.

• Creating custom Oracle Fixed Assets, General Ledger (GL) reports for Audit and Reconciliation purposes using Oracle SQL.

• Creating PL/SQL packages to Import Expense reports from Concur Expense application to Oracle AP and resolving the issues during the import/export process.

• Implementing Electronic Payment Files in Oracle Accounts Payables (AP). Setup Payment Templates as per HSBC Bank 's Payment Specification document.

• Configuring Oracle Applications R11, R12 .1.3 Modules E-Business Tax, Accounts Receivables, Accounts Payables modules to integrate with Vertex Q series third party Tax application and providing support to resolve the issues related to Tax Invoices.

• Configuring, Customizing, and supporting Oracle Cash Management for MT940 Bank Statement file format.

• Designing, Configuring, Testing and Documenting the Procure-to-Pay (P2P), Order-to-Cash (O2C) business cycles in Oracle EBS R12 Financials and Sub Ledger Accounting (SLA).

• Providing Functional/Technical support for various Oracle EBS Applications Modules which includes Accounts Payables (AP), Accounts Receivables (AR), E-Business Tax (EB Tax). General Ledger (GL), Fixed Assets (FA), Cash Management (CM), and Costing.

• Reporting tools: SQL Developer, BI tools (Domo), Excel and Word.

• Creating dashboards in ServiceNow Ticketing systems for resolving and monitoring issues submitted by Business users.

• Creating customized financial data reports required for Financial Planning and Analysis (FP&A) using SQL.

• Management Information Systems (MIS System Analysis).

• Creating software change requests, uploading Test cases, and Test Results in Jira.

Travel Requirements: Domestic travel up to 7 days per month. International travel up to 7 days

per year.

NOTE: Only qualified applicants need apply. Do not apply if you are an H-1 or F-1 visa holder, or if you otherwise require employer sponsorship to obtain U.S. employment authorization. Do not apply if you are not eligible to be employed in the U.S.

As an eligible Merit employee, you can expect the following:

• Multiple Shifts and Hours to choose from: Days, Swing (Eve), and Nights

• Medical/Dental & Other Insurances (eligible the first of month after 30 days)

• Low Cost Onsite Medical Clinic

• Two (2) Onsite Cafeterias

• Employee Garden | Gardening Classes

• 3 Weeks' Vacation | 1 Week Sick-Time | Paid Holidays

• 401K | Health Savings Account

To see more on our culture, go to www.merit.com/careers.

Military Veterans are encouraged to Apply.

Merit is a proud Utah Patriot Partner committed to hiring our Veterans.