SUMMARY:

• A professional Oracle Apps consultant having over 6 years of overall Domain experience in IT, which involves around 6 years of experience in design, development, support, customization and implementation of Oracle Applications (ERP).
• Extensive technical expertise in Oracle Applications 11i/11.0.3.
• Extensive experience in defining, analyzing, designing, implementation and support for Oracle Supply Chain Management, Manufacturing and Financial modules like Purchasing(PO), Order Management(ONT), Inventory(INV), Work In Process(WIP), Bills of Material(BOM), Material Resource Planning(MRP), Costing, Shipping(WSH), Advance Pricing(QP), Accounts Receivables(AR), Accounts Payables(AP), General Ledger(GL).
• Good knowledge and understanding of Oracle Order to Cash and Procure to Pay Life Cycles.
• Proficient in importing data from legacy systems or 3rd party tools to Oracle Applications through interface programs and conversion programs by developing PL/SQL scripts for SQL loader and writing custom wrapper.
• Proficient experience in AOL concepts and System Administration by providing support to apps users in Oracle Applications.
• Good knowledge and understanding of Oracle R12 release.
• Extensive experience in Customization and Modification of Forms, Reports using Oracle Forms 4/6i, Oracle Reports 3.0/6i.Experience in developing applications using Oracle RDBMS 9i/8i.
• Excellent skills in designing and developing different types of Reports using Oracle Reports3.0/6i, Discoverer 4i & XML Publisher.
• Experience in the transformation of existing IT systems to Service Oriented Architecture based on multiple application interaction patterns leveraging Oracle BPEL PM and Oracle ESB layers.
• Expertise in Fusion middleware components such as Oracle BPEL Process Manager, ESB Controller and ADF.
• Excellent knowledge of web - based standards such as BPEL, SOAP, WSDL, XPath, XSLT and XML.
• Experience in SOA suite 10.1.3.3 installation and administration.
• Adept at incorporating Human Workflows (Approvals/Task Routings), File/FTP Adapters, AQ Adapters, OA Adapters and DB Adapters in BPEL processes.
• Good working experience in modeling, automation, and continuous improvement of business processes, routing information of any type according to user-defined business rules using Oracle Workflow 2.6.3.
• Used Oracle AIM documentation for preparing technical design documents for customization and conversions in Project Implementation Methodologies.
• Proficient in understanding the concepts and hierarchical structure of Multi Org. Good knowledge of TCA Architecture.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development using SQL*Loader, SQL developer and Toad as development tools. Created and maintained Database objects.
• Exposure of UNIX Shell Scripting to schedule concurrent programs.
• Worked in projects that involved Fine tuning of queries for faster retrieval of data and involved in resolving various Troubleshoot issues.
• Excellent Team Player with good problem solving approach having strong interpersonal, communication, leadership skills and ability to work in a time-constrained and team-oriented environment.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.

TECHNICAL SKILLS:

Packages: E-Business Suite Oracle Applications: Versions 11.5.3, 11.5.7, 11.5.8, 11.5.9, 11.5.10,R 12 and 11.0.3.EAI and B2B Integration Oracle Fusion Middleware - (ESB & BPEL), Jdeveloper 10.1.13.1, 10.1.3.3, BPM, Oracle Service RegistryMiddleware Messaging Oracle Fusion, IBM MQ Series

ERP/Modules: Oracle Purchasing (PO), Oracle Order Management (OM), Oracle Inventory (INV), Work In Process (WIP), Bills of Material (BOM), Material Resource Planning (MRP), Costing, Shipping (WSH), Advance Pricing (QP), Oracle Receivables (AR), Oracle Payables (AP), General Ledger (GL).

Programming Languages: SQL, PL/SQL, C, C++, Java, HTML

Processes: Order to Cash and Procure to Pay processes

Development Tools: Oracle Forms 4.5/6i, Oracle Reports 4.5/6i, Discoverer 6, XML Publisher, Oracle Workflow 2.6.3, JDeveloper, BPEL, SOA suite 10.1.3.

Database: Oracle 8i/9i/10g

Operating System: Windows 98/NT/2000/XP, SUN Solaris 2.5/5.6, UNIX, Linux

Tools: TOAD, SQL*PLUS, SQL* Loader, SQL developer.

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Fusion Middleware Consultant

Responsibilities:

• Worked with the implementation team having detailed discussions with the client on system requirements and mapping on oracle applications.
• Involved in numerous team meeting to gather the requirements, explain the functionalities to the users and give a status update on various reports that I have developed.
• Troubleshooting all kinds of development time and SOA environment related issues within planned timeline.
• Involved in AR Open Invoices Interface by writing a custom wrapper to validate and load the data from staging tables into AR interface tables.
• Developed numerous custom reports from scratch involving modules such as PO, OM, INV, AR, AP as per user’s request.
• Customized some reports in modules such as AR, AP which involved adding new columns, parameters, logos and removing some columns from the standard report.
• Involved in the installation of OC4J containers and configuration of the connection pools and data sources for Database and Oracle Applications Adapters on the application server.
• Involved in configuring the Email notification services on applications to send notifications using SOA Suite.
• Presented the business users with a Pilot integration of the existing systems with Oracle Apps using Oracle SOA Suite.
• Designed and developed an inbound BPEL process to import the Inventory Lot Transaction information from MES system and update it in OSFM using Inventory Lot Transactions Interface.
• Hands on experience in JDeveloper to develop BPEL and ESB services.
• Used JDeveloper to build BPEL process and deploy to the service in OM module.
• Extensively worked in Designing and Developing different interfaces, involving ESB/BPEL as a middleware, which also includes interfacing the Oracle Applications, MQ, WMS (Warehouse Management System).
• Troubleshooting all kinds of development time and SOA environment related issues within planned timeline.
• Worked on Sales Order Interface using BPEL to import the sales orders from legacy system to Oracle Apps.
• Performed System Administrator tasks which involved creation of Users, Responsibilities, and assigning Responsibilities to Users.
• Developed XML templates which involved adding logo’s, adjusting the template to letter format based on existingOraclereports.

Environment: Oracle Applications 11i (INV, PO, AR, GL, AP, OM, WSH, QP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Forms 6i, Reports 6i, XML Publisher, JDeveloper, BPEL, SOA 10.1.3.

Confidential, Dayton, OH

Fusion Middleware Consultant

Responsibilities:

• Worked with the implementation team having detailed discussions with the client on system requirements and mapping on oracle applications.
• Developed Item Interface to load the Items data from legacy system into Oracle Applications by running standard API.
• Performed PO conversion which involved developing a custom wrapper to validate and load the PO data into purchasing interface tables and then populating the oracle base tables through standard PO interface program.
• Developed the AP invoices Interface program, loaded the data into interface tables and calling Payable Import Program.
• Involved in AR Open Invoices Interface by writing a custom wrapper to validate and load the data from staging tables into AR interface tables.
• Worked on Sales Order Interface using BPEL to import the sales orders from legacy system to Oracle Apps.
• Hands on experience in JDeveloper to develop BPEL and ESB services.
• Involved in Creation and Approval of Purchase Orders, Invoices and Sales Orders in Oracle Applications E-Business Suite, 10.2.
• Involved in creating the Build Scripts for deploying the ESB and BPEL services across different environments. Deployment activity also includes pushing T-Models, WSDL files and creating UDDI key for such components using ANT tasks.
• Troubleshooting all kinds of development time and SOA environment related issues within planned timeline.
• Involved in designing Audit Logging Mechanism in ESB and BPEL which includes logging the data at all the points transacted through SOA.
• Developed Reprocessing service in PL/SQL and ESB/BPEL to reprocess the data at runtime, in case of any error. All the Inbound and Outbound data transactions through ESB/BPEL layer are captured at initial and final points and a concurrent program is developed to poll the errored data on scheduled basis and reprocess the same data.
• Involved in creating the Build Scripts for deploying the ESB and BPEL services across different environments. And deploying ESB and BPEL projects using custom ANT task to different environments.
• Performed System Administrator tasks which involved creation of Users, Responsibilities, and assigning Responsibilities to Users.
• Documented functional features and behavior of required customizations using AIM methodology. Prepared and involved in analyzing conversion documents CV 40 and CV 60.
• Defined payment terms, Locations, Invoice Approvals and setting up Bank Account information in Oracle Financials AP.
• Involved in creating new messages and attached them to oracle standard forms as per business requirement.
• Worked on workflow in creating messages and sending notifications in PO module.
• Customized various standard reports in PO, INV and created new reports as per business requirements, using Oracle reports.
• Developed XML Reports in various modules based on existingOraclereports.
• Generated numerous XML tags in the output for creating the templates by running the concurrent program.
• Developed numerous templates from an existing report for various operating unit in XML publisher.
• Helped and involved in understanding the functionality flow of complete life cycle of Order to Cash to the users which includes defining and setting various objects pertaining to the modules.

Environment: Oracle Applications 11i (INV, PO, AR, GL, AP, OM, WSH, QP), Oracle 10g, TOAD, PL/SQL, SQL* LOADER, Forms 6i, Reports 6i, XML Publisher, Workflow 2.6.3.,JDeveloper, BPEL, SOA 10.1.3.

Confidential, Versailles, OH

Oracle Applications Technical-Functional Consultant

Responsibilities:

• Involved in designing, developing interfaces, customizing user requests and implementation change requests. During these processes interacted with end users and implemented their requirements into the Application Systems.
• Developed Requisitions open interface, loaded data from staging tables to interface tables and called a seeded API to populate the Purchasing base tables.
• Involved in the implementation of Item Open interface and resolved related technical issues.
• Involved in BOM conversion by developing a custom interface program to load the staging table data into BOM base tables.
• Responsible for Order import using Order Management OE ORDER PUB API to update sales order into respective base tables.
• Worked on price list API to populate base tables in QP.
• Personalization of Oracle forms like, Order Entry, Item Master, Material Transactions and various other forms using custom.pll, as per the client’s requirements, using Oracle Forms. Created Error correction forms for PO Receipts interface.
• Involved in customization of various Reports in PO and OM modules using Oracle Reports.
• Extensively used AOL for Configuration of Key Flex Fields and Descriptive Flex Fields.
• Registered the automation scripts as concurrent programs and created a scheduling process that invokes the script periodically.
• Worked on preparing and reviewing MD050s and MD070s for various formal documents and transactional reports corresponding to their respective business areas.
• Developed Custom Order Hold and Discounts program using OM and Advanced Pricing module through PL/SQL.
• Developed Reports using Discoverer6i, Created business areas, custom views, new folders, conditions and joins based on user requirements.
• Customized Workflows for sending notifications using workflow 2.6.3.
• Involved in the end users on the functionality of Procure to Pay modules.

Environment: Oracle Applications 11i (PO, OM, INV, GL, AP, QP and BOM), TOAD, Oracle 10g, SQL*Plus, PL/SQL, SQL*Loader, SQL Navigator, Forms 6i, Reports 6i, Discoverer 6i, Workflow 2.6.3.

Confidential, Cleveland, OH

Oracle applications Technical Consultant

Responsibilities:

• Analyzed the Business Systems for Oracle Application integration, interacted with end users to gather and analyzed the technical requirements, designed, drafted specifications, developed and implemented Financial Modules.
• Involved in Customer Conversion to load Customer details into HZ base tables by an API.
• Developed the AP invoices Interface program, loaded the data into interface tables and calling Payable Import Program.
• Loaded Legacy Journals data into interface tables and then populated the base tables of GL by running standard API.
• Implemented and supported AR Auto Invoice import Interface program.
• Involved in Enhancement of the existing system by developing new forms for the system and integrating them with existing modules. Customized existing forms and incorporated new functionalities.
• Involved in customization of standard Oracle reports in AR, AP and GL as per client requirements using Oracle Reports.
• Customized Workflows for sending notifications using workflow 2.6.3. Prepared functional and technical specifications according to Organizational wide standards.
• Registering concurrent programs, request groups for reports and concurrent requests.
• Involved in development of customer Interface and Interacting with users to get the requirements and mappings during conversion.
• Involved in the end users in creating and modifying thereceipts, Invoices, customer detailsfrom front end andhelp them in understanding the complete process and flowof AR and AP modules.
• Performed testing while assuring smooth transition to production, wrote technical documentation, set up user- workshops and assisted with enhancements requests.
• Developed Reports using Discoverer4i, involving creating folders, drill down reports and item classes in AP, AR and GL.

Environment: Oracle Applications Release 11i (11.5.9), AR, AP, GL, OM, PO, WIP ToadOracle 10g, PL/SQL, SQL Plus, Forms 4.5, Reports 6i,SQL* Loader, Workflow 2.6.3, Discoverer 4i.

Confidential, Dallas, TX

Oracle Technical Consultant

Responsibilities:

• Involved in improving existing functionality and business processes (in the areas of Orders, Contracts, and Invoices) using TCA concepts.
• Converted the data from legacy systems into 11i. Developed control files for SQL*Loader and PL/SQL programs for loading, data mapping, data conversions and validating the data into the interface tables of AP.
• Wrote a Program to insert data into Item Transaction Interface tables based on different Transactions and populated the base tables by calling a seeded API.
• Worked on the Oracle Inbound Ship Confirm Interface, which perform actions on Deliveries, Updating shipping attributes, updating the Freight costs by calling an API.
• Populated customer base tables in AR by implementing customer Interface program.
• Involved in customization of standard Oracle reports in OM, AP as per client requirements using Oracle Reports.
• Involved in customization of schedule order form and moved Promise Date from one canvas to another, using Oracle Forms.
• Designed and developed numerous packages and procedures using various APIs to load data from staging tables into Oracle base tables.
• Developed OM queries to Count Orders by Order Types, Order Source. Identified, demonstrated and documented Order Entry, drop shipments, Internal Orders.
• Updated Profile Options for related modules and successfully upgrade to Multi-org functionality.
• Hands on experience in Oracle Applications System administration, involved in setting up user responsibilities, privileges of users, administering concurrent managers/transaction managers (activate/deactivate, request priorities), registering various Forms and Reports.
• Took part in the entire phase of the project which includes, initial operations analysis, business process re-evaluation, testing,, conversions, customizations and documentation and implementation of modules.

Environment: Oracle Applications Release 11i (11.5.9), AR, AP, INV, OM, WSH, GL Toad, Oracle 10g, PL/SQL, SQL *Plus, Forms 4.5, Reports 6i, SQL* Loader.

Confidential

Oracle Database Developer

Responsibilities:

• Created and altered logical and physical database objects such as table spaces, tables, indexes, synonyms, sequences, constraints, and triggers to development needs.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Worked closely with database developers to ensure adherence of the database guidelines, standards and procedures and generated system plans.
• Created s procedures, triggers and functions to retrieve data from the database using PL/SQL.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Created user defined Exceptions while Handling Exceptions
• Created Test Packages for other packages and procedures.
• Troubleshooting production problems and worked effectively with address problems.
• Involved in testing and fixing bugs.

Environment: Oracle 8i, PL/SQL, SQL, SQL*Loader, Toad