Job Title- Oracle R12 Development role
Duration – 10 months
Location – Columbus OH remote is ok.
SPECIFIC SKILLS - Design, develop, configure, enhance, and implement Oracle E-business suite of R12 applications for Safelite projects. Will use all financial and Supply Chain Management (SCM) modules like iProcurement, Purchasing (PO), Account Payables (AP), Account Receivables (AR), iReceivables, General Ledger, Inventory and Property Manager Modules
- Responsible for architecting and designing solution for complex application architectures and integrations with oracle E-Business Suite (EBS) applications modules.
- Must have experience in Oracle reports, interfaces, conversions, enhancements, and forms (RICEF) objects.
- Experience in Reports using XML publisher, Client, Excel4Apps and Oracle Developer Suit.
- Must have good knowledge on standard Oracle EBS tables, mainly on AP, AR and Inventory and other related modules.
- Should have experience in oracle workflow and customize workflow
- Develop PL/SQL programming and tune SQL queries to improve the performance
- Develop PL/SQL Packages, Stored Procedures, Functions, Database Triggers, SQL * Loader scripts, and shell scripting.
- Prepare MD50, MD70 and MD120 documents using AIM methodology
- Able to support Kofax (Markview) for invoicing
- Experience in developing new forms, customize existing forms and personalize forms as business requested.
- Able to troubleshoot root cause, Fix the Transaction level issues for month end and quarter end support.
- Able to perform Unit Testing, System integration testing, implementation, maintenance, and performance tuning.
- Technically fluent in Writing / Debugging, Database Packages / Procedures / Function / Triggers in RDBMS using Oracle Technologies i.e. (SQL, PL/SQL).
- Should be able to work with multiple suppliers for gathering requirements, design, develop and document all the details.
- Able to support end-end O2C (order to cash) and P2P (Procure to Pay) transactional flows.
- Experience in using STAT tool for code migration from one environment to another environment.
- Expert in configuring new trading partner in iProcurement using XML & EDI Gateway module
- Troubleshoot issues related PO XML and Invoice XML for iProcurement vendors
- Work on both TOAD, SQL *Loader and PL/SQL Developer as SQL development tools to create PL/SQL code.
- Able to work on SQL navigator tool to build complex queries.
- Develop complex XML publisher templates for AP Check Printing
- Able to work on all production issues by supporting all the modules in Financial and SCM.
- Develop and support EDI (Electronic Data Interchange) to securely exchange data between two parties
- Participate in peer code/design reviews to ensure the delivery of quality solutions.
- Lead collaborative requirements gathering efforts and work with business.
- Experience in configuring new punchout vendors in iProcurement to order products from external vendors (example office max, proforma)
JOB DESCRIPTION - Monitoring the Cherwell queue – working tickets as they come through
- Assist with project work as assigned by lead Oracle developer
- Participate in code reviews
|