• 8 Years of IT experience as an Oracle apps techno functional consultant and worked on versions 1...
• 8 Years of IT experience as an Oracle apps techno functional consultant and worked on versions 11i, R12. • Expertise working experience on design, implementation, post production support projects to various clients who implemented Oracle e-business suite. • Good Functional/Technical knowledge in Oracle application modules like Distribution and Supply Chain modules (OM – Order Management, INV- Inventory, PO- Purchasing, Shipping, BOM), Financial modules (GL- General Ledger, AP- Account Payables, AR – Account Receivables, Costing). • Expertise in design, development and customization of RICE (Reports, Interfaces, Conversions and Extensions) using PL/SQL, SQL Loader and UTL file. • Expertise in creating tables, packages, stored procedures, advanced queries, triggers, views, indexes and functions for databases using SQL *PLUS, and PL/SQL. • Good exposure of workflows. • Extensive experience on creating inbound, outbound interface scripts and performed conversions for loading data into Oracle applications and exporting data from Oracle application system to flat files and process the data files to other legacy system users. • Worked with Oracle APIs (Application Programming Interface) to register executables, concurrent programs and execute the request set from backend. • Strong knowledge of Application Object Library (AOL) i.e., defining users, menus, responsibilities, creating executables, concurrent programs and attaching these concurrent programs to request group. Defined custom applications of new request group, responsibilities using Application developer. • Excellent skills in development of Oracle Database 11g, 10g, 9i applications using SQL, PL/SQL, BI Publisher reports. • Excellent understanding on sub-ledger flows: Procure to Pay (P2P) and Order to Cash (O2C). • Experience in designing and developing reports using BI publisher. • Designed various Technical and Functional documents like MD050, MD070 and MD120, and Conversion Mapping CV060 using AIM Methodology. • Good knowledge on UNIX shell scripts to execute and automate the PL/SQL applications. • Expertise in working with development tools like SQL developer and TOAD. • Excellent analytical skills, logical reasoning, and interpersonal skills. TECHNICAL SKILLS: ERP versions Oracle Applications R12.1.3, 11.5.10, 11.5.8 Modules General Ledger (GL), Account Payables (AP), Account Receivables (AR), Purchasing (PO), Inventory (INV), Order Management (OM), Shipping, BOM, Application Object Library (AOL) Databases Oracle 11g, Oracle 10g, Oracle 9i Languages SQL, PL/SQL, C, C++ DB Tools XML Publisher, Oracle Workflows, BI Publisher,SQL Developer, TOAD, SQL*Plus, SQL*Loader, ERWIN Scripting UNIX shell scripting
* Click the button to send an offerSend offer