SUMMARY

• Around 8+ 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 guides, 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.

TECHNICAL SKILLS

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 Techno Functional 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 Purchase Order 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 Techno Functional 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.
• Development of Program to process EDI 870 inbound data from staging tables.
• 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.
• Program to create a Lift for the Lots.
• Customer data conversion.
• AR Interfaces.
• Customizations related to Cost Import Manager.
• PO Receipts program.
• Development of custom Report to the Business Users to evaluate the Suppliers.
• 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.
• Customizations for creating Work Orders.
• Performance tuning for SQL queries.
• 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.
• Development of PL/SQL BULK collects to load huge volumes of data.
• PL/SQL Object types.

Confidential, Webster, NY

Oracle Apps Techno Functional Consultant

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

Responsibilities:

• Involved in the System study and Gap analysis phase of the project.
• Interact with the Business Users to gather the Business Requirements, analyze the system impacts and to provide Technical solutions.
• Solution Design documentation based on the System Requirements.
• Provided the feasible solutions and design to meet the Client Business requirements.
• Responsible for the Drop Ship Flow Technical design.
• Program to extract the PO details and send the information to Other environment.
• Program to import and create the Sales Orders.
• Customized the Purchase Blanket release creation process, PO Receiving.
• Customer Credit Check Process Hold.
• Oracle Receivables (AR) Customer Interface: Involved in design and development of Customer Interface program. Developed a Custom SQL Loader Program to load legacy data into
• Custom staging table. Developed Custom PL/SQL API to validate the data, which loads into
• Customer interface tables and through Oracle Standard Customer Interface, the valid data gets loaded into Oracle base tables.
• 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.
• Prototype the solutions based on the Business requirements.
• Technical Design documentation based on the System Design.
• Provided support for the initial issues after Implementation in Production.
• Maintain Issue logs for the Deliverables.
• Coordinate with the Legacy system teams to interface with Oracle Applications.
• Implemented different types of reports like XML, Oracle reports and pl/sql reports.
• Development of Oracle Workflow.
• Created Oracle FND Messages
• Created Oracle Database Triggers to send the data during an update on the tables.
• Created Descriptive Flex fields for FND Lookups.
• 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.
• Created Oracle Form Functions.
• Preparation of Unit Test scripts.
• PL/SQL package Conversion of External System data to Oracle.

Confidential, Webster, NY

Oracle Apps Techno Functional Consultant

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

Responsibilities:

• Interact with the Business Users to gather the Business Requirements, analyze the system Impacts and to provide Technical solutions.
• Solution Design documentation based on the System Requirements.
• Provided the feasible solutions and design to meet the Client Business requirements.
• Responsible for the Drop Ship flow Technical design.
• Developed the Pre-Requisition Import process.
• Developed the Drop Ship Order Import process.
• Sales Order conversion to Drop ship orders.
• Customer, Customer Sites conversions.
• Development of Inbound and Outbound interfaces.
• Development of Oracle custom Forms.
• Technical Design documentation based on the Solution Design.
• Provided support for the initial issues after Implementation in Production.
• Development of Oracle Workflow.
• Implemented different types of reports like XML, Oracle reports and pl/sql reports.
• Created FND Messages
• Created Oracle Database Triggers to send the data during an update on the tables.
• Performance tuning for SQL queries.
• Preparation of Unit test scripts.
• Created Oracle Form Functions.
• PL/SQL package Conversion of External System data to Oracle.

Confidential, Webster, NY

Oracle Apps Technical Consultant

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

Responsibilities:

• Solution Design documentation based on the System Requirements.
• Technical Design documentation based on the Solution Design.
• Provided the feasible solutions and design to meet the Client Business requirements.
• Technical Design documentation based on the Solution Design.
• Sales Order conversion to Drop ship Order.
• Customize Purchase Requisition Import process.
• Inbound and Outbound Interfaces.
• Provided support for the initial issues after Implementation in Production.
• Coordinate with the Legacy system teams to interface with Oracle Applications.
• Code developments as per Client standards.
• SOX compliance for the Interfaces with External 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.
• 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.