PROFESSIONAL SUMMARY:

• Around 6 Years of experience in providing cost effective solutions by using Oracle E - Business Suite (R12+ and 11i).
• My experience spreads across Implementations, Customizations, Data Migrations, Interfaces, Conversions and Enhancement projects.
• Experience in Requirements gathering, Architectural design, Interfaces design, Process Data-flow design and preparation of System Design, Test script generation and execution, preparation of training guides, training End Users and Production support.
• Experience working with Business Users, Business Analysts, IT leads and Developers in analyzing business requirements and translating them into Functional and Technical Design specifications.
• Good Knowledge (Technical and Functional) on the following modules in Oracle Applications - Oracle Payments (IBY), Purchasing (PO), Application Object Library (AOL), Order Management (ONT), Shipping Execution (WSH), Accounts Payables (AP), Accounts Receivables (AR), Assets, General Ledger (GL), Cash Management (CE), Oracle Inventory (INV), Trading Community Architecture(TCA), Work In Process (WIP), Bill Of Materials (BOM) and ASCP modules.
• Have good understanding of Procure to Pay (P2P), Order to Cash (O2C), Drop Shipment, Internal Sales Order (ISO), Back to Back Order, Plan to Replenish, Quote to Order cycles.
• Expertise in understanding, Modifying and development of FRICEW (Forms, Reports, Interfaces, Customizations, Extensions, and Workflows)components, proficiency in Design, develop, deploy, test and maintain technical objects that exist in Oracle applications environment.
• Responsible for various phases of software development such as System Study, Analysis, Coding, Testing and Documentation.
• Expertise in interfaces for Inbound and outbound data conversion.
• Extensive experience in developing Oracle database objects like Database Triggers, Stored Procedures, Functions, Cursors, and Packages using PL/SQL and Workflow customizations.
• Expertise in developing Form Personalization, Forms, Performing SQL Tuning, Unix Shell scripts, Oracle Workflows, XML Reports.
• Ability to build the work break down structure into manageable packages.
• Experienced at working with external vendors to resolve technical issues.
• Development and Implementation of standards for team excellence.
• Highly motivated team player with good communication skills and excellent problem solving abilities, would be willing to work independently or as part of a team.
• Having Good Communication, Self-Motivated and Inter Personal Skills., organize multiple tasks to meet schedules and deadlines.
• Self-starter with potential, initiative and a positive attitude.
• Keen and enthusiastic with constant desire to learn and a commitment to excel.

SKILL S:

Technical: Strong Technical knowledge of Oracle e-Business suite Supply Chain Modules in developing of RICE (Forms, Interfaces and Conversions) Components, SQL, PL/SQL, Forms, Workflows, Form Personalization, XML Publisher.

Functional: Excellent Techno-functional knowledge in Order to Cash, Procure to Pay cycles.

Tools: Used: TOAD, Putty, Data Loader, PL SQL Developer, BI Publisher, SSH client, Forms 6i, Reports 6i, Forms 10g, Workflow builder 2.0, RCS Menu, MKS Integrity, ITT (Integrated Ticket Tracking System). Oracle SQL, PL/SQL, Oracle Forms, Reports, Oracle BI Publisher, XML Publisher, UNIX Shell Scripting, BPEL, Oracle SOA Suite 11g/10g and JDeveloper 11g/10g. Oracle ERP Modules including Oracle Purchasing, Inventory, Account Receivables, General Ledger, Account Payables, BOM, WIP, Oracle Transportation Management and Oracle Order Management.

Methods: Software Development Life Cycle (SDLC), Product Life Cycle Management (PLM) Application and Oracle AIM Methodology(Application Implementation Methodology)

PROFESSIONAL EXPERIENCE:

Confidential, Orrville, OH

Oracle Apps Technical Consultant

Environment: Oracle R12, Oracle Database 11g/10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQLUNIX Scripting, WinSCP, Putty, ALM HP Quality Center, Control-M.

Responsibilities:

• Involved in the Analysis phase of the project.
• Preparation of MD70 Design documents from MD50.
• Development of Inbound Interface.
• Creation of Purchase Requisitions using Requisition Import process.
• Creation of Purchase Orders from Global Blanket Agreement and Approved Supplier List.
• Backflush of Raw Material Quantities from Ship To Warehouses.
• Email alerts to Users for the errors during the Purchase Order creation process.
• Development of custom Forms.
• Involved in the Analysis, Design, Development, Test and support phases of the Project.
• AR Invoice Interfaces.
• Account Payables to Suppliers during the Procure to Pay process.
• Oracle Forms personalization to achieve business requirements.
• Involved in registration of Forms, Reports using AOL.
• Created Oracle FND Messages
• Created Descriptive Flex fields.
• Created Oracle Form Functions.
• Created Oracle Database Triggers to send the data during an update on the tables.
• Performance tuning for SQL queries.
• PL/SQL packages to extract the data and FTP the files to External systems.
• FNDLOAD to migrate the Concurrent Programs, Lookups etc. to other Oracle instances.
• Preparation of Unit test scripts.
• PL/SQL packages to extract the data from Oracle tables and perform the operations.
• Creation of Oracle Request Sets and Concurrent programs.
• Sales Orders conversion in Order Management.
• Item Conversions in Inventory.
• Inbound and Outbound Interfaces.
• Shipping Interfaces to Other systems.
• Development of PL/SQL BULK collects to load huge volumes of data.
• PL/SQL Object types.

Confidential, Columbus, OH

Oracle Apps Technical Consultant

Environment: Oracle R12i, Oracle Database 10g, Windows 7, UNIX, TOAD, SQL, PLSQLUNIX Scripting, WinSCP, Putty, PVCS.

Responsibilities:

• Involved in the System study and Gap analysis phase of the project.
• Preparation of MD70 Design documents from MD50.
• Development of Inbound and Outbound interfaces for EDI.
• Development of Program to send EDI 856 transactions for the Shipped data from Oracle.
• Program to update the Oracle with EDI 861 Receiving Advice information.
• Worked on interfaces to migrate Suppliers, Sites, Contacts, Approved Supplier Lists, Purchase Requisitions, Purchase Orders, PO Receipts, Payables Invoice, Journal Imports, Banks, Branches, Bank Accounts, Customer data, AR Receipts to Oracle base tables.
• Development of custom Report to the Business Users to evaluate the Suppliers.
• Designed and developed PO requisition interface to load PO requisitions from the legacy System into Oracle purchasing (PO) using SQL*Loader and PL/SQL validations.
• Developed Auto Invoice Interface which imports invoices, credit memos and debit memos into Oracle Receivables (AR) module using SQL*Loader and PL/SQL validations.
• Worked on MOAC Multi Org security profile creation and assignment.
• Customizations around Payable Invoices.
• Development of custom Form to reprocess the Error transactions.
• Email alerts to the User groups.
• Involved in the Analysis, Design, Development, Test and support phases of the Project.
• Created custom form to load the data for finished goods requests for outside users.
• Oracle Forms personalization to achieve business requirements.
• Implemented different types of reports like XML, Oracle reports and pl/sql reports.
• Involved in registration of Forms, Reports using AOL.
• Created Oracle FND Messages
• Created Descriptive Flex fields.
• Created Oracle Form Functions.
• Created Oracle Database Triggers to send the data during an update on the tables.
• Performance tuning for SQL queries.
• Oracle Application Framework (OAF) personalization’s.
• Load the Inbound files through Control file.
• PL/SQL packages to extract the data and FTP the files to External systems.
• FNDLOAD to migrate the Concurrent Programs, Lookups etc. to other Oracle instances.
• Preparation of Unit test scripts.
• PL/SQL packages to extract the data from Oracle tables and perform the operations.
• Creation of Oracle Request Sets and Concurrent programs.
• Sales Orders conversion in Order Management.
• Items Conversion process in Inventory.
• Shipping Interfaces to Other systems.

Confidential

Oracle Apps Technical Consultant

Environment: Oracle R11i, Oracle Forms 6i, Report Builder, TOAD, SQL, PLSQL, WinSCP, Putty, PVCS.

Responsibilities:

• Perform impact analysis feasibility study of all existing customizations in the application before start the upgrade process.
• Ensuring that the system current functionality works as-is after the Upgrade.
• Reviewed oracle documents to capture all pre-upgrade steps and activities for Anchor system.
• Identification of required change controls for R12 upgrade and prepare MD70 documents.
• Involved in technical upgrade like custom reports, custom forms need to be re-compiled and executed using Oracle Developer Tools 10g, XML reports were updated and executed in BI Publisher.
• Performed a technical upgrade which includes Reports, forms, interfaces and various customizations during R12 upgrade.
• Worked on Trading Community Architecture (TCA).
• Developed the customer data import program for data loading from legacy systems to oracle TCA tables.
• Conversion of GL 3 segments to 9 segments.
• Workflow customizations for Cost of Goods Sold (COGS) Account Generator.
• Migrated General Ledger (GL) data from legacy systems to Oracle.
• GL Journal Conversion using Journal Import Program.
• Development of Inbound and Outbound interfaces.
• Development of Oracle custom Forms.
• Coordinated with Oracle support in resolving the issues with the upgrade.
• Implemented different types of reports like XML, Oracle reports and pl/sql reports.
• Created Descriptive Flex fields for FND Lookups.
• FNDLOAD to migrate the Concurrent Programs, Lookups etc. to other Oracle instances.
• Creation of Oracle Request Sets and Concurrent programs.
• PL/SQL packages to extract the data from Oracle tables and perform the operations.