SUMMARY:

• An industrious and motivated Oracle Applications Architect/Database Consultant/Techno - Functional Consultant, with 12 years of proven expertise in design, development and code optimization as Oracle Developer and experience in Software Development Lifecycle of Oracle Applications - Design, Development, Testing and Implementation.
• Experienced in Oracle Applications, Modules include, Supply Chain/Procurement PO, INV, OM, and Modules like Order Management OM, Advanced Pricing QP, Shipping Execution WSH, Purchasing PO, Human Resource Management System HRMS, Financials AP, AR, Treasury, Cash-management, Discrete Manufacturing BOM, WIP, INV and Process Manufacturing, Oracle Advance Supply Chain Planning ASCP
• Familiar with Oracle Master Data Management, Product hub and Customer hub. Extensively worked on Oracle customer base with TCA architecture.
• Hands-on experience in Data Conversion, Data Migration, Developing Interfaces in various modules.
• Led team of developers/technical consultants in various projects, both on-site and off-shore.
• Extensively worked with Developer 2000 (Forms/Report) and worked on customization and enhancements of forms, reports and interfaces in various Modules in Oracle 11g/10g/9i/8i/8 environment using SQL, PL/SQL, SQL Trace and UNIX/Linux Shell scripts.
• Extensively worked on PL/SQL Stored Procedures, Functions, Stored Packages, Database Views, Triggers, and knowledge of various PL/SQL packages and Oracle Application APIs.
• Experienced in environments requiring direct customer interaction during Specifications, Design, and Development and Product Implementation phases.
• Experienced in writing design documents (AIMS) MD50s and MD70s. Familiar with MD, BR, CV
• Highly analytical team player with aptitude for quickly scrutinizing environments to identify and prioritize needs/risks and develop solutions.
• Application tuning using TK- Prof and Explain Plan.
• Proven relationship-builder with exceptional interpersonal, communication, and presentation skills.
• Post Production support, bug fixing and enhancement.

TECHNICAL SKILLS:

ERP: Oracle Applications 10.7/11.0.3/11 i/R12

Languages/Tools: SQL, PL/SQL, SQL*Plus, Pro*C, SQL*Loader, Work Flow Builder,Java, C/C++, TOAD, SQL Developer

GUI &Reporting Tools: jDeveloper10g (OAF/ADF), Forms 10g/9i/6i/4.5, Reports 10g/6i/5.0/2.5, Discoverer 4i

Databases: Oracle 12c/11g/10g/9i/ 8i/8.0

Operating Systems: Windows XP/NT/2000/98/95, LINUX, UNIX Sun Solaris 2.6

Version Control/Ticketing Tools: PVCS, CVS, Sub-version, Kintana, Seapine SCM, Sharepoint, JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Tacoma, WA

Sr. Oracle Applications Architect/Developer

Responsibilities:

• Designed and developed following extensions/interfaces between Oracle EBS and ASCP systems for client to minimize the machine changeover time, to optimize the shop floor resource and to run the production in cost effective manner where system shows Final Assembly Planned orders from ASCP including its lower level components in structured manner with its attributes sorted and prioritized based on user defined grouping criteria and Sorting rules. And also, allows the manufacturing personnel to release them from EBS. functionality to be accomplished in Oracle EBS to perform Level Loading and Line balancing for the Oracle ASCP planned orders prior to sorting and sequencing. This process is performed on selected planned orders to transfer resource from one line to another line (Line Balancing) or change (pull in or push out date) in the suggested start date of planned order (Level Load) to streamline the daily production.
• All the predefined assembly items that will not be manufactured in the location where the sales order is taken, will be either directly purchased from external supplier or will be manufactured in other Milgard location and then be transferred to sales order shipping warehouse.

Environment: Oracle Applications 12.2.3 (Oracle Manufacturing/Supply Chain, Oracle Advance Supply Chain Planning), Oracle 11g, LINUX, TOAD

Oracle Applications Consultant

Responsibilities:

• Developed various custom interfaces to validate and import prior-day and intra-day Bank statements in Cash Management from banks
• Developed custom interface to transmit valid payment information to the bank ( Confidential ) from Oracle Treasury as XML file
• Developed various automation interfaces in Oracle Treasury to import/export Transactions - Bank statements/Exposures/Deals to and from external system

Environment: Oracle Applications 12.1.3 (Cash Management, Treasury, AP), Oracle 11g, LINUX, TOAD

Oracle System Analyst

Responsibilities:

• Gather requirements, review and document current processes by studying existing system and interviewing business owners, users and super users
• Functional implementation and support for Manufacturing and Logistics track modules of INV, BOM, WIP, Purchasing, Order Management, ATP/Scheduling, Pricing and Shipping
• Analysis of earlier Customizations solutions to find the better way of handling the customizations.
• Coordination with development team, testing of the new designs including extensions, conversion, interfaces and reports.
• Regular onsite/offshore coordination to get clarifications from users/technical consultants over components developed from offshore and coordination among teams of other modules.
• Hands on SQL Queries for Trouble shooting & Reconciliation
• Run SQL Scripts and Concurrent Programs to perform data extracts, data validation, data fixes.
• Identified the custom reporting requirements and documented them appropriately for the reporting team.
• Identified the customization for Standard Oracle Reports to satisfy Business requirements.
• Validated several custom reports developed by technical team.
• Created new value sets on as need basis.
• Assigned profile options according to business requirements.
• Prepare and maintain various project related documentation like BR100’s, MD50’s and Test Scripts

Environment: Oracle Applications 12.1.3 (INV, OM, BOM, WIP, PO, AP, AR), Oracle 11g, LINUX, TOAD

Oracle Applications Functional Consultant

Responsibilities:

• Data Migration, Business System Integration Testing
• Data extracted, verified and tested using various scripts and concurrent programs.
• Created Unit Scripts and Business Scenarios which reflect the requirements
• Involved in configuring various CRP, UAT and Production Migration.
• Analyzing the issues reported on the custom solutions.
• Analysis for the MD.050, Requirements, Business Processes and work with the development team to fix the issues, testing and deliver.
• Analysis of earlier Customizations solutions to find the better way of handling the customizations.
• Coordination with development team, testing of the new designs including extensions, conversion, interfaces and reports.
• Hands on SQL Queries for Trouble shooting & Reconciliation
• Prepare and maintain various project related documentation like BR100’s, MD50’s and Test Scripts.

Development Environment: Oracle Applications 11.5.10.2 (INV, BOM, WIP, CST, PO, AP), Oracle 11g, LINUX, SQL Developer

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Developed a custom Quote form, with features and capability similar to standard oracle sales order form in Order Management, like adding freight/charges, checking Pricing & Availability, Re-pricing and including launching various oracle forms that assist in creating a quote.
• Developed a custom Quote Re-price Form that schedules quotes to be re-priced in batches.

Development Environment: Oracle Applications 11.5.10.2, Oracle 10g, LINUX, Forms/Reports6i, Toad 10

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Developed concurrent program (Java) to imports data from MS SQL Server into Oracle Incentives.
• Developed Custom Mobile Supply Chain Application screens to process move-order allocations, pick-confirm, pack (assign LPN) various lot and serial controlled items.
• Developed Custom API’s to support MSCA application screens to handle various inventory and shipping actions
• Developed custom API’s to create, book and ship Sales Orders from other applications (iPad)
• Customized Sales order form to automatically create and import shipping locations when new site is added to a customer
• Developed a custom form to create customer site and import them as shipping locations and also to quickly add communication (email, fax etc.) to a customer
• Developed a custom customer base engine to create party/customer and their relationship/profile/contacts/Sites/site uses etc.
• Developed a custom OAF page to query various concurrent programs tied to a responsibility and vice versa
• Developed Custom Inventory Label printing program.
• Developed various custom pick-release processes that release different orders/types.
• Developed custom pick-release and shipping documents to be called from custom pick-release APIs
• Modified various standard OM/AR/INV reports
• Modified various OM/WSH workflow processes
• Developed a custom form in Inventory to handle various miscellaneous transaction
• Developed custom XML/BI publisher reports to automatically print, fax and also email Sales order, ASN, Purchase order, Invoice etc.

Development Environment: Oracle Applications R12 (12.0.6) (OM, AR, OPM, INV, QP, PO, WSH), Oracle 10g, LINUX, Forms/Reports10g, jDeveloper 10.1.3.3.0, Toad 10, Work Flow Builder 2.6.3.05

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Developed Custom Form to apply Cash Receipts across different operating units in Receivables.
• Developed Custom Form to create attachments (remarks) across different operating units and hold them as one global repository.
• Developed custom form and interface in Process Execution module (GME) to quickly create and close batches to expedite the batch creation process.
• Developed a custom Quick Sales Order form in Order Management
• Developed custom interface to upload price lists and modifiers in Advance Pricing.
• Developed a custom interface to create Inter-org material transfer and sub-inventory transfer.
• Modified various oracle forms using form personalization and custom.pll
• Developed custom API to import invoices using Auto-Invoice program
• Developed shell scripts to extract reporting data from various databases and load them into oracle

Development Environment: Oracle Applications R12 (12.0.3) (OM, AR, INV, QP, PO, WSH), Oracle 10g, LINUX, Forms/Reports10g, Toad 10, Work Flow Builder 2.6.3.05

Sr. Oracle Applications Developer

Responsibilities:

• Developed Custom Form to view Sales Orders, AR Invoices and AR Receipts.
• Developed Custom Data Fix Utility API to clean up the data coming through different outside sources.
• Developed interface to process various incoming EDI 210/810/850 files from multiple vendors/sources.
• Developed Custom Interface to Archive and Purge Concurrent Requests/Forms personalization Information.
• Developed customer conversion interface.
• Developed AP Invoice import interface.
• Developed Custom Interface to update System Profiles with User values.
• Worked on customization of Universal Work Queue View.
• Worked on customization/personalization of standard Sales Order and Telesales order forms.
• Developed Custom Interface to Activate/In-Activate Customer Sites/Uses.
• Customized PO Approval Workflow to send e-mail notification to suppliers, which includes PO along with an attachment (Importer Security Filing for 10+2 form).
• Developed mailer program to send e-mails with attachments (greater than 32K) from oracle.
• Modified the Payables Positive Pay report output according to client requirement.
• Worked on sales order workflow customizations to apply different holds.
• Created oracle alerts (periodic and event-based) to send notifications to various User groups.
• Created interface to apply holds (credit and price threshold) on customer orders.
• Developed various UNIX scripts and PL/SQL utility programs.
• Developed various custom reports with different outputs (XML/pdf/Excel).
• Worked extensively on forms personalization (front end and custom.pll).

Development Environment: Oracle Applications 11.5.10.2 (OM, AR, AP, GL, INV, QP, PO, WMS), Oracle 10g, LINUX, Forms 6i/Reports 6i, Toad 9, Work Flow Builder 2.6.3.05

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Developed a Custom Program that runs business specific validations to Pre-Validate Orders coming through e-Commerce Gateway.
• Developed a Custom (Error Corrections) Form to view Sales Orders to be Pre-Validated coming through e-Commerce Gateway.
• Developed a Custom Interface in Order Management to Import Orders coming through EDI Interface.
• Worked on e-Commerce Gateway Setups.
• Developed a Custom Interface that applies “Pricing Hold” on all the existing and future customer orders against a selected list of customers.
• Developed a Custom Pricing Engine Using Advanced Pricing APIs.
• Developed OM Attachments Interface.
• Developed a Custom Interface that creates Customer Contact Roles and Contact Points using APIs.
• Developed Custom Order Fulfillment Form that captures all the additional information (DFF) on the order.

Development Environment: Oracle Applications 11.5.10.2 (OM, INV, QP (Advanced Pricing), AR, EC (E-Commerce Gateway)), Oracle 9i, LINUX, Forms 6i/Reports 6i, Toad 9, Work Flow Builder 2.6.3.01

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Developed a Custom Interface in Order Management that accomplishes Pick Release and Ship Confirm Process using APIs against the feed from WMS.
• Developed a Custom Interface that Ship Confirms Drop-Ship Orders against the feed from WMS.
• Developed a Custom Interface that Updates/Creates Material Receipts (Account Alias) in Inventory against mentioned accounts.
• Developed a Custom Interface that Creates/Updates, Books and Splits the Sales Order Lines, using APIs, in Order Management against feeds from different sources.
• Developed a Custom Interface that Creates Sales Orders in Entered/Booked Status, Using Order Import.
• Developed a Custom Interface that Creates, Pick Releases and Ship Confirms OSW (On-Site Warehouse) Sales Orders in Oracle Applications.
• Developed a Custom Interface that applies/releases “Denied Party Hold” on all the existing and future customer orders against a selected list of customers.
• Developed a Custom Form “Customer Engine Model”, which is used to assigns an Engine Model (BOM) to a Customer.
• Developed a Custom Form “Product Line Sequence”, which is used to assigns a Product Line to a Part.
• Developed a Custom Form “Customer Controlled Ship”, which allows defining different levels of controls on Customer Parts.
• Developed a Custom Form “Part Query”, which fetches various attributes defined on a Part, like, Total On-Hand, Qty Shipped (YTD), and QTY on Order (YTD), Standard Cost, Catalog Price, Catalog Lead Time and various Descriptive Element Values like UPQ.
• Developed a Custom Interface to Update/Insert attributes on Items and Item Catalogs through Item Import.
• Customized the ZOOM functionality on Shipping Transaction Form Using Form Personalization.

Development Environment: Oracle Applications 11.5.10.2 (OM, INV, AR, BOM) Oracle 10g, LINUX, Forms 6i/Reports 6i, Toad 9

Oracle Applications Techno-Functional Consultant

Responsibilities:

• Developed a custom interface programs to update part numbers on Service Contracts.
• Developed an interface to Re-price the updated Service Contracts using Advanced Pricing APIs.
• Added a Work-Flow Activity to the Sales Order Lines Work-Flow that updated Lines with PTO Items.
• Developed a custom interface to Load/Update Pricing Modifiers and Qualifiers.
• Developed a custom form “Web Program Types”.
• Customization of Standard Consolidated AP/OM/AR/GL Reports/Forms, which includes extensive PL/SQL coding.
• Interacting with Business users and gathering specs for various modules.
• Worked on setups in different modules like of Order Management, Oracle Purchasing, Oracle Inventory, Oracle Receivable, Oracle Payable and Oracle General Ledger.
• Developed custom programs to load data into OM tables
• Developed Interface program that validates and loads data into OM interface tables.
• Developed interface Program that picks up the records and Ship Confirms in Oracle.
• Customized the Workflow of Order Header to put custom Terms and Holds based on Customer.
• Developed custom programs to generate Reports with Custom Billing Information.
• Developed custom programs to load the AR transactions for generating click charge reports.
• Developed custom reports generating concurrent request information (excluding/including scheduled requests).
• Developed custom interface that sends sales order information to external system.
• Developed Interface that updates Billed Revenue Information.
• Created new Standard Purchase Orders for all items that were used for receiving quantity updates and inserted them into Interface tables.
• Developed Interface Program to load item details into staging tables, validate them and insert them into Interface tables.
• Developed BOM Bills Conversion Interface.
• Developed custom interface and worked on standard API’s in OM/QP/AR.
• Developed Interface Program that creates Customers, Customer sites and location details.
• Worked on Asset setup processes for Quick additions, Detail additions, and Mass additions in FA.
• Developed Custom triggers to support business needs.

Development Environment: Oracle Applications 11.5.10.2 (OM, QP, INV, BOM, PO, AR, AP, GL, FA), Oracle 9i, LINUX, Forms 6i/Reports 6i, Toad 8.6.1.0, Work Flow Builder 2.6.3.01

Oracle Applications Technical Consultant

Responsibilities:

• Developed a Custom Interface that sends information about Booked Orders with no Holds on them to an external system.
• Developed interface program that picks up the data and validate them and insert them into interface tables in OM.
• Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs.
• Developed a Custom Form called ‘UPC/UCC14 Form’ that helps user to enter all Packaging Information (Descriptive Elements) on a Product (item) i.e., it enables to enter DFFs at different levels on an Item.
• Developed a Conversion Interface that ties text as attachments to Items in INV and Purchase Orders in PO using attachment API.
• Developed a Custom Interface that sends Invoicing Information to AP.
• Developed various reports in OM like Price Override Report, Open Units and Dollars Report, Past Due Summary Report, Unprocessed Orders Report, Shipped Not Billed Orders Report.
• Worked on LockBox Interface.
• Developed AR Attachments Interface.
• Developed AP Suppliers Conversion Interface.
• Developed AP Invoices Conversion Interface.
• Developed AP Banks Conversion Interface.
• Developed Items Conversion Interface.
• Developed custom Program to convert BOM Bills.
• Developed custom Program to convert BOM/WIP Routings.
• Developed Interface that updates Items Safety Stock, Translated Description and attaches notes to Item.
• Developed Interface for PriceList Upload.
• Worked on setups like payment terms, suppliers, creating and troubleshooting of payment batches, Created accounting rule for Revenue recognition, Auto Accounting Receipts, Application Rule Sets, Auto cash Rule Sets in AR, GL setups like Creation of Journal Entries, Reversing Journals, Recurring and Mass allocation Journals, Budget organizations & Consolidation, Revaluation in multi-currency, multi-org environments
• Technical Design Document creation and Concurrent Requests setups using FND Loader.

Development Environment: Oracle Applications 11.5.10.2 (QP, AP, AR, GL, PO, INV, BOM, OM), Oracle 9i, LINUX, Forms 6i/Reports 6i, Toad 8.0

Oracle Applications Technical Consultant

Responsibilities:

• Developed a Custom Interface in AR for Revenue Recognition Purpose, where “Net$0 Reclass” type transaction is used to create a transaction from the original order in case where original transactions book revenue to deferred revenue accounts.
• Developed a custom form that provides appropriate Tax Code information considering the ‘Ship To’, ‘Selling Country’, ‘Country Type’ and the ‘Item Type’ on the Order.
• Customization of Defaulting Rules in Order Management.
• Developed an Interface to upload data on different database, with that current information on Oracle BOM database.
• Developed a custom Tax Code defaulting API in Order Management.
• Developed a Custom Interface in AR as part of a “Request Set” creation that updates DFF’s on the Invoice Interface Line before AutoInvoice is run and also applies the VAT notes to the Invoice.
• Developed an Interface for Customer Conversion in AR.
• Developed a custom Interface that copies begin and end dates on Service contracts, copies attachments and updates ‘Remit To’ addresses on Invoices after AutoInvoice is run.
• Preparation of Technical specifications and User Reference Documents.

Development Environment: Oracle Applications 11.5.10 (OM, AR, INV, BOM), Oracle 9i, LINUX, Forms 6i/Reports 6i, Toad 8.0

Oracle Applications Technical Consultant

Responsibilities:

• Reviewed the User Requirements Document (URD), Functional Requirement Documents and Technical Requirement Documents
• Prepared Technical Documents for future references on the Applications developed
• Developed Interface Packages/objects that send data to the external Planning tool (Xelus)
• Developed validation programs to validate the data before loading into interface tables from staging tables.
• Detailed Test conditions, Test Plan and Test Criteria for the applications developed
• Prepared the Test Scenarios, Test Cases for the Application under test
• Conducted Interface Testing of Applications developed
• Prepared Troubleshooting documents for the Applications developed
• Used Oracle’s Explain Plan method to analyze the execution of SQL statements in Cost-Based optimizer.
• Involved in SQL statement tuning for multi table joins by using hints. Used Oracle performance tools like SQL Trace and TKPROF to tune the application.
• Responsible for the performance tuning of the Packages/procedures and table Indexes using Explain Plans and SQL Trace.

Development Environment: Oracle Applications R11.5.9 (PO, OM, INV, AR), Oracle 9i, UNIX, Forms 6i/Reports 6i, PL/SQL 2.x, SQL*Loader, Toad 8.0