SUMMARY:

• 8 Years of IT experience as an Oracle apps 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), Financial modules (GL- General Ledger, AP- Account Payables, AR - Account Receivables, SLA, Cash management, Asset management).
• 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, XML interfaces, EDI.
• Worked with Oracle support in resolving unidentified issues encountered and created Service requests and coordinating them.
• Worked on agile and waterfall methodologies and lead scrum discussions and reviewed sprint sessions with product owners and stakeholders.
• 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 executable, concurrent programs and execute the request set from backend.
• Strong knowledge of Application Object Library (AOL) i.e., defining users, menus, responsibilities, creating executable, 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 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 BR100, and Conversion Mapping CV040 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.2.2, 12.1.3, 11.5.10

Modules: General Ledger (GL), SLA, Account Payables (AP), Account Receivables (AR), Purchasing (PO), Inventory (INV), Order Management (OM), Shipping, Cash management, Asset management, Application Object Library (AOL)

Databases: Oracle 11g, Oracle 10g

Languages: SQL, PL/SQL, C, C++

DB Tools: XML Publisher, Oracle Workflows, BI Publisher,SQL Developer, TOAD, SQL*Plus, SQL*Loader, Visio

Scripting: UNIX shell scripting

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Oracle Apps analyst

Responsibilities:

• Involved in business architecture design reviews. Interacted with architects to understand the process flow of the assets.
• Worked on MD50 functional document and creation of test documents and reviewing end-to-end functional testing.
• Developed interfaces of Purchase order drop from PO to custom module
• Worked on setup of new boarded suppliers and associated its corresponding site
• Worked with consignments and and the setup of items, ASL involved for the process.
• Worked with Payment process request (PPR) to configure few batches to stop process for review enabled to review the payments after select. Once reviewed, the concurrent program is executed to build and format and send the checks to suppliers.
• Loading customer invoices using Auto invoice import into AR and processing receipt transactions and accounting the entries to GL.
• Worked with setup of transaction flex fields, transaction types, receipt methods, receipt classes in AR.
• Work on Auto Lock Box functionality and setup in Account Receivable (AR) to process receipts and apply them to customer invoices.
• Worked with banks to setup lockbox communication and electronic remittance for payments.
• Worked with Oracle support in creation of Service request and coordinating issues in resolving them.
• Worked on sub ledger accounting (SLA) module.
• Worked with loading journal entries in GL module and setup of journal sources, categories, suspense account and intercompany accounting.
• Developed interfaces of Inventory module to post material movements from field locations to either another locations/ warehouses setup as either inv org transfers or sub inventory transfers from the custom ALC module.
• Design ADF forms to perform custom inventory movements for inventory transactions.
• Worked on custom concurrent programs, API to initiate process flow within various systems.
• Created BI Publisher reports using RTF template, xls template and xpt templates
• Performed functional testing, end-to-end testing and user acceptance testing.
• Involved in calls with Performance DBAs and analyzed various tuning process involved during trace file generation.
• Worked on user tickets and resolved based on severity levels.
• Worked on inbound interfaces to load the data into base tables and also outbound interfaces where the data has to be fed to other systems.

Environment: Oracle 11g, Oracle ebusiness R12.2.2, SQL, PL/SQL, TOAD, BI Publisher

Confidential, Baltimore, MD

Oracle Apps functional

Responsibilities:

• Gathered business requirements and set up business processes within the modules. Developed functional specification document for application customization and enhancement.
• Worked with vendor invoices from EDI sources and loaded into standard invoice base tables.
• Worked on auto invoicing rules to define invoicing properties based on billing address and currencies.
• Worked on transaction type, transaction sources, transaction flex fields setups and auto accounting in AR
• Worked with various production issues ranging from payment process, resolving month end issues, processing lockbox transactions and resolving roadblock issues by working with Oracle support.
• Added cross validation rules to the new accounting structure.
• Worked with reconciliation of bank statements with payments and receipts in Cash management.
• Worked on asset retirement process in asset module and asset addition through mass addition program from payables to asset management.
• Accounting sub ledger transaction entries to GL through SLA and drill down through its process to track its source transactions for Ledger entries.
• Worked on setup of journal line types, ADR, journal line definition, SLAM within SLA to configure accounting entries based on events.
• Worked on intercompany and intercompany accounting in GL.
• Used pipelined functions and ensuring dynamic sql to append conditions dynamically for faster sql access.
• Developed interface programs to load invoice entries into Payable module.
• Worked in creating and setting up various AOL objects like DFF, value sets.
• Interacted with legacy data management users by providing outbound data on supplier, customer. Used UTL FILE for proving outbound files.

Environment: Oracle Apps R12.1.3, Oracle 11g, SQL, PL/SQL, SQL developer, XML Publisher

Confidential, Louisville, KY

Oracle Apps functional

Responsibilities:

• Developed interface programs for loading customer information, bank details, payment terms and currency data from legacy systems to base tables by SQL loader, PL/SQL procedures and script files.
• Worked on external requisition for creation to POs to external suppliers and internal requisitions for creation of ISO for inter org transfers.
• Worked with standard invoices and credit memos to process the transactions
• Developed interface programs to load transactions into Receivables module and accounted for journal entries to GL through Sub ledger accounting.
• Worked on TCA for party creation, associating sites, account and account uses.
• Worked with XML interfaces to parse and store the data through inbound systems.
• Worked with month end closing for purchasing and payables. Review accounting entries and posting to GL through SLA.
• Worked on loading and reconciliation of statement with system transactions.
• Worked on entities, event classes, event types, journal line definition to modify accounting entries in SLA.
• Customized reports in AR such as: Aging Report, Customer Payment Details Report
• Good knowledge on intercompany and intercompany accounting in GL.
• Worked on tickets supporting AR module end-to-end process.
• Worked with end users to resolve the issues and also setup weekly calls with the business folks on review of the outstanding issues.
• Troubleshooting invoice payment related issues and ensured routing multiple invoice files simultaneously using threads rather than one file upload enhances the performance.

Environment: Oracle Apps 12, Oracle 10g, SQL, PL/SQL, SQL developer, XML Publisher

Confidential, San Antonio, TX

Oracle Apps techno functional

Responsibilities:

• Involved in requirement gathering, analysis, design and development of interfaces and reports. Interacted with functional consultants, DBA team and developed technical MD70 specification.
• Developed a tracking application that closely integrates with Oracle transportation management for tracking the shipments from start location to end location.
• Developed a custom program (Inbound Interface) to validate and import the shipments or labels generated from warehouse to end stop locations. This open interface is start point to process any scan event.
• Worked with shipping parameters, exception, picking rules, pick slip grouping rules, sequence rules and release rules
• Worked with internal requisition creation and execute create internal orders program for ISO creations and move the material from one inventory org to another and receiving them to close the process successfully.
• Worked with automatic receipt creation and interim tables for quick cash while dealing with transactions invoices in AR.
• Worked on building exceptions template for the supervisors happening at every scan event. This exception report is inturn used to instruct the field tech to correct the missing or incorrect label deliveries.
• Developed custom interface for pick release program within ordering module. The custom pick release program generates callout number for the deliveries sent out to warehouse. This callout number is used as further reference.
• Coordinated knowledge transfers to technical team and guided them on technical issues.
• Wrote UNIX scripts for parsing, archiving the inbound files and FTP the outbound files.
• Gathering functional requirements and created technical documents for custom reports, script files.
• Wrote PL/SQL programs for implementing validation rules and loading data from staging tables to interface tables.
• Executed concurrent programs through request sets and through backend by using APIs.
• Developed inbound interface to load purchase order details into purchasing base tables from legacy systems.
• Extensively worked on FND LOAD for migrating concurrent programs, value sets, descriptive flex fields, lookups from one instance to another.
• Registered the shell scripts as concurrent programs and created a scheduling process that invokes the scripts periodically.

Environment: Oracle Apps 11.5.10, Oracle 10g, SQL, PL/SQL, SQL developer, UNIX