SUMMARY:

• 9 years of progressive industry experience in requirement gathering, analysis, design, implementation, testing, documentation, production support and upgrade of Oracle Federal and Oracle public sector financial and supply chain applications
• Recently involved in successful conversion and new implementation oracle federal financials for Confidential
• Good understanding of E - Business Suite Modules Accounts Receivables AR, Accounts Payables AP, General Ledger GL, Loans LNS, Budget Execution BE, Federal Financials FV, CLM, Discrete Manufacturing Inventory INV, Purchasing PO, Order Management OM, Bill Of Materials BOM and Work In Process WIP .
• Strong skills in Oracle Applications R12 12.0.4, 12.1.3 /11i and Oracle databases 11g/10g/9i/8i.
• Proven efficiency in developing RICEW Reports, Interfaces, Conversions, Enhancements or Extensions and Workflow components and Oracle Alerts.
• Good Knowledge of OAF.
• Expertise in AIM methodology to enrich project management and documentation processes.
• Experience in code reviews, integration and end-user support.
• Excellent analytical, problem solving, work ethics, communication, inter-personal and presentation skills.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS Federal Financial Technical Consultant

Environment: Oracle Applications 12.1.3, AOL, UNIX, pl/sql, reports 10g, Forms 10g, BI Publisher, Workflow, OAF, PO, LNS, GL, AP, AR.

Responsibilities:

• Performed as conversion team member for Supplier conversion, Comprizon Purchase Order, Supplier Banks Conversion, Employee Conversion.
• Involved in end-to-end interface developments and completed the following programs
• Collection Interface Repository Treasury Interface/FedWire Interface
• Fee Accrual Process Dividing fee income recognized across the life of Loan .
• Supplier Interface.
• Supplier Bank Interface.
• Purchase Order Interface.
• Annual Exposure Fee Calculation
• Hi-Jacked Standard Code to support as per EXIM Bank's logic.
• Month-End Accrual Programs.
• Travel Interface Concur .
• Developed XML Publisher reports BOC Activity, Pending Exp Fee, AR Receipt Details etc. .
• Modified standard AP Invoice Workflow to suit customer needs.
• Involved in performance tuning with respect to receipt workbench
• Support developing oracle application framework screens.
• Closely working with ERS reporting team.
• On demand developed sql and xml validation queries, reports
• Consistent right on-time delivery of the objects with great accuracy and with proper documentation.
• Ability to explain the team and users with proof of concept strategy for any issue/requirement/observance/development.

Confidential

Sr. Oracle Apps Developer

Environment: Oracle Applications 12.0.4 and 12.1.3, AOL, UNIX, pl/sql, reports 6i, Discoverer, BI Publisher, Workflow PO Approval Workflow is completely customized, PO, OM, BOM, WIP, INV, GL, AP, AR.

Responsibilities:

• Upgrade Project Apps from R12.0.4 to 12.1.3 and database 10g to 11g
• Upgrade activities of current business processes 12.0.4 to 12.1.3 BOM, WIP, INV, AP and PO .
• Mapping, Assessing the performance impact adding index, table partition of the custom code with database upgrade and Extensive Testing.
• Custom upload templates were created to upload items, price for the items, cross references and item categories.
• Handled proper flow of data through SOA to outside systems feeder system being Oracle .
• Worked on interfaces to feed data to EDI Electronic Data Interchange templates like 846 Inventory Feed to B2B partners like Confidential, Confidential, Confidential, etc.
• Provided extensive operations support to maintain the uptime and availability of production applications using AWR Automatic Workload Repository report.
• Modified schedules of jobs running on a regular basis at concurrent manager level.
• Modified outbound programs, PO Approval Workflow to trigger revision emails for Drop Ship purchase orders, change of the address on customer order and change of quantity should trigger an email to vendors.
• Created custom program, triggers to cancel the purchase order shipments in case of RTV and send the list of cancellations to business users which might cascade sales order line cancellation.

Confidential

Production Support

Responsibilities:

• Support for Month-End Close/Quarter Close/Year End Activities.
• Handled Back-To-Back Order, Drop Ship, In-stock, OSP Out Side Processing fulfillment scenarios.
• Modified PO Approval Workflow for business requirements modifying email format .
• Worked with highly customized code for sales order progression Work Order Release, requisition creation, consolidating multiple requisitions to purchase orders, sending purchased orders to vendors and acknowledgement, Importing AR Receipt.
• Lead offshore team in development, bug fix and enhancements projects by providing technical guidance as SME and driving all the tasks to completion.
• Worked closely with SOA dev team to validate, test and stabilize interfaces.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Member of the Oracle Application 12.0.4 implementation project.
• Worked on Supplier Conversion.
• Developed numerous outbound and inbound interfaces.
• Developed new reports PL/SQL, rdf, XML BI Publisher and Discoverer per business needs.
• Prepared MD 070, CV 070, CV 060, MD 120 AIM documents.
• Created lookups, flex fields, concurrent program and shell scripts.
• Written SQL Loader programs.

Confidential

Oracle Apps Techno-functional Consultant

Responsibilities:

• Involved in requirements gathering from business users for GL Conversion, FA Conversion, AP Invoices Interface and Supplier Interface.
• Designed and developed conversion programs for GL and FA in R12.
• Developed AP Invoice Interface and Supplier Interface.
• Created new reports in AP, INV modules.
• Created PURCHASE ORDER REPORT using BI Publisher.
• Fixed bugs in AP Check Printing Report BI Publisher Report .
• Worked with Oracle support team to troubleshoot and fix bugs.

Confidential

Oracle Finance Reports Developer

Responsibilities:

• Developed Direct Shipper Tax reports in PL/SQL and RDF for different counties and states.
• Created value sets, concurrent programs, lookups.
• Efficiently combined similar requirements and created templates for development work.
• Modified existing reports and tuned SQL queries.
• Tested reports and documented the test cases.

Confidential

Technical Consultant

Responsibilities:

• Developed packages, reports, value sets, triggers, tables, indexes, synonyms, sequences, views and lookups.
• Developed and modified concurrent programs.
• Creation and modification of Oracle Discoverer and RDF Reports.
• Developed order validation package to load data to interface tables in order entry and run order import to load data to the base tables.
• Written PL/SQL code for generation of B2B messages 3A6 and 3B2, error messages BAM, exception handling and relevant messages in the log files.
• Created and modified wrapper program to call the custom Pre-Order Import, Order Import, Post Order Import, Order Validation and Auto Booking programs with necessary validations.
• Replaced XML gateways with Advanced Queuing concept.
• Prepared MD070 and MD120 using standards of AIM.
• Changing the Zoom Form Additional Customer Information .
• Involved in customization of forms using CUSTOM.pll