SUMMARY

• Eight (8) years of strong experience working as Oracle Applications Technical consultant in OM, INV, ASCP, BOM, WIP, WMS, AR, GL, PO, AP, Workflow and E - Commerce Gateway (EDI) modules using Oracle Applications R 12 / 11. .5.9 / 11.5.8 / 11.5.7 / 11.5.3 , Oracle D2k, PL/SQL, TOAD, SQL, Forms 6i, Reports 6i, Discoverer Oracle 10g/9i/8i/7.3 under Windows 2000/NT/98/95, Unix environment.
• Extensive Experience in Apps with 4 Full-Life cycle implementations and a partial Implementation.
• Extensive Experience in Oracle Application 11i Application Object Library (AOL).
• Extensive experience in working with Stored Procedures, Functions, API’s, Packages, Triggers and Application tuning.
• Excellent Functional Knowledge in Oracle Manufacturing, Financials and Advanced Supply Chain modules
• Excellent experience in EDI 850,855, 860, 865, 830,862,856,810,820 transactions.
• Worked on Customizing Forms and reports as per client requirements
• Excellent experience in legacy conversions, Applications customizations and Interface development.
• Expertise in designing, implementing and customizing Oracle Manufacturing and Financial Modules.
• Expertise in design and development of Interface Programs and Data Conversion Scripts.
• Worked in Oracle Application Object Library (AOL) features like value sets, Flex fields, Concurrent Programs, Profile Options, standard request submissions and parameters which are extensively used in the process of development.
• Worked on System Study, Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite.
• Sound Relational Database Concepts and extensively worked with ORACLE and MS SQL Server.
• Excellent knowledge in order-to-cash and procure-to-pay flow and good understanding of TCA architecture.
• Development of Oracle Apps Reports, Interfaces, Customizations and Extensions (R.I.C.E)
• Hands-on experience in creating, working and customizing various Workflows for Oracle Applications.
• Performance tuning of applications using built-in Oracle utilities like Explain Plan and TK-Prof and used Optimizer hints and Bulk Binding techniques where needed.
• Demonstrated ability to identify root causes of problems, considering both the long and short-term impact of proposed solutions and develop workable solutions
• Possess excellent communication, interpersonal and analytical skills along with can - do attitude

TECHNICAL SKILLS

ERP: Oracle Applications R12/11i (OM/ONT, AR, AP, INV, ASCP, WSH (Shipping),WMS, PO, AP, AR, BOM, CST, WIP, GL, Projects, E-Commerce Gateway (EDI) and AOL).

Oracle tools: Forms 9i/6i, Reports 9i/6i, Discoverer 4i, SQL * Loader, SQL*Plus, Work Flow Builder 2.6, XML Publisher

Other tools: TOAD, Oracle Export and Import, ERWin data modeler, Designer 2000, Kintana

Web Technology: java Script, VB Script, JSP,HTML

Operation Systems: UNIX, Windows Vista/XP/ME/NT 4.0/2000/98 SE/95

Languages: SQL and PL/ SQL, UNIX Shell Script, C, C++

Database: Oracle 10g/9i/8i/8i, MSSQL 2000

PROFESSIONAL EXPERIENCE

Confidential, MO

Oracle Apps Technical Consultant

Responsibilities:

• Involved in Business requirement gathering (BR100), Functional design (MD50 and MD57), development, documentation, functional testing.
• Analysis and Solution Design for 3PL FedEx (FedEx Ship Manager) and LMS integration (outbound and inbound interfaces) Project with shipping.
• Designed custom extension (form) for Sub inventory replenishment.
• Designed custom form for “On Hand QTY”.
• Customized BOL (Bill of Lading) as per user requirements.
• Designed custom form for “Dock appointments”.
• Designed custom report for “Expected Receipts” (PO/ISO/RMA).
• Designed custom reports (Item availability report) according to user requirements to help user get data related to On hand availability of the items before pick release.
• Designed custom “Planning Shipment Report”.
• Designed/tested BI Publisher reports (Business Intelligence) for Item usage, Donate/Discard, Inter-Org transfers,
• Assisted in design and testing of custom Batching extensions and reports and Pick/Pack slips.
• Worked on Price List Conversions.
• Assisted with integration of Adv pricing with OM.
• Involved in standard oracle setups like Ship methods, shipping networks, Account Alias, Item DFF setups, Ship confirm rules etc. and custom setups like pick position/bay sequence, sub inventory DFF setups etc.
• Functional testing and logging test cases and Bugs in MTM (Microsoft Test Manager).
• Troubleshooting issues post development.
• MD50, MD57 and MD70 review with business and technical team.
• Created and reviewed CSRs (change requests) for various designs depending on feedback from Business users post CRP.
• Continuous and daily interactions with business end users to gather requirements and test the customizations.
• Involved and presented in CRP/UAT sessions and End user .
• Production support and end user support.

Environment: Oracle Apps R12.1.3 (OM, Adv. Pricing, BOM, INV, ASCP, WMS, SHIPPING, PO,AR) PL/SQL, TOAD, SQL, Forms 6i, Reports 6i, BI Reports, Oracle 10g, MTM (Microsoft Test Manager), Microsoft Service Manager, Data Loader, UNIX.

Confidential, Plymouth, MN

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in requirements gathering, analysis, and development.
• Designed MD50 (functional design) document.
• Prepared technical design document (MD70) for the given functional requirement.
• Developed custom code for Un-allocated inventory order management using different custom procedures and API’s at different levels and registered as a Concurrent Program.
• Developed a custom code to move orders from master org to hubs based on the customer location.
• Developed a custom code to check on hand availability of the SKU at the hubs.
• Developed a custom code to create move order and to create delivery.
• Customized the code to create trips and create additional trip stops.
• Developed a code to create label records and to update Service Request status.
• Developed a code to create task and to create an output file with required data.
• Involved in trouble shooting of EDI (ARO 943) custom code.
• Customized EDI 940 as per client requirement.
• Customized create shipping label code to populate ship via.
• Presented in Design review, CRP and UAT sessions.
• Daily team interaction and status report updates to the leads and managers.

Environment: Oracle Apps R12 (OM, BOM,ASCP, INV) Oracle D2k, PL/SQL, Workflow Builder, TOAD, SQL, Forms 6i, Reports 6i, XML Publisher, Oracle 10g, Windows NT, Unix.

Confidential, Plainsboro, NJ

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in requirements gathering, analysis, development, QA and post-production support.
• Performed GAP analysis to ensure that the requirements are captured properly.
• Developed the BOM conversion code to convert the data from VAX to oracle system using different APIs at different levels and registered as a Concurrent Program.
• Created custom Shell scripts to handle the loading the data file into the custom tables and archiving of the data file.
• Developed the Customers Conversion code to convert the contact data from legacy system to oracle system using 16 different APIs at different levels and registered as a Concurrent Program.
• Worked on creation of Contact Allowance maintenance form and handled the contact allowance conversion to convert the allowance information for each contact from the legacy system.
• Developed a PL/SQL Pricelist Conversion code to create a new pricelists in the oracle system from VAX system and registered it as a concurrent program.
• Developed the Let down report to display the available items and their locations and statuses.
• Customized the Invoice and Credit Memo reports as per the business requirement
• Developed the Line Shortage Report to display the ordered quantity to the available quantity for each item in the system.
• Customized the International Invoice report to show the attachment details of the order line on the report.
• Worked on Customizing and Creating various Oracle and XML reports as per client requirement.
• Proposed improvement to process thro default value setup in OM in order to minimize the error rate
• Daily Development Interaction with leads for status and any other outstanding issues.

Environment: Oracle Apps R12 (OM, AR, BOM, INV, GL) Oracle D2k, PL/SQL, Workflow Builder, TOAD, SQL, Forms 6i, Reports 6i, XML Publisher, Oracle 10g, Windows NT, Unix.

Confidential, San Mateo, CA

Oracle Apps Technical Consultant

Responsibilities:

• Prepared Technical Specification documents, mapping documents for EDI 0 / 856 using X12 Gentran.
• Did setups for e-Commerce Gateway like Trading Partner Groups, Trading Partners, EDI Locations, Code Conversion Categories, Code Conversion values, etc and successfully communicated EDI Files.
• Design and developed an interface between Bank of America and (AR) Oracle Receivables for Cash Receipts (Auto Lockbox).
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) for importing Legacy Purchase Orders into Oracle Purchasing, Legacy (AP)Payable Invoices into Oracle Payables, Journal Imports Interface from external Payroll, Items into Inventory, Bills of Material into BOM from legacy system.
• Developed Conversion program to import Vendor/Supplier Information into Purchasing by loading data into staging tables from legacy system, validating data using PL/SQL API and then loading the data into Vendor information Base tables.
• Wrote Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) for Supplier/Vendor conversion
• Worked on GL Interface, Journal Import, Budget Upload, Payables Accounting Process, and Payables Transfer to GL in GL, AP modules.
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) and Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Open Sales Orders using Open interface tables in Oracle Order Management.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Customers, Parties, Customer Accounts, Party sites using TCA architecture .
• Interface development to import Projects, tasks & Budgets from external systems to Oracle PA.
• Designed and developed an Outbound Interface between Interlace Systems (Supply-Chain Management tool) and Oracle Applications for Customers, Items, BOMS, On hand Quantity, etc.
• Designed and developed an interface between third party billing system (INTUIT) and Oracle Receivables (AR) to load external invoices data on daily basis. Used SQL*Loader for import INTUIT invoices into Staging tables, and developed PL/SQL API for complete validation of data and inserting into Interface tables.
• Developed various Custom reports, Customized existing reports according to the functional specifications including Packing Slip, Pick Slip, Daily Inventory Transactions Report, Invoice and Expense reports, AR Adjustments etc using Reports 6i/9i.
• Used Oracle Application Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.
• Did post implementation support for various departments like Financials, Purchasing, Planning, Manufacturing and Sales.
• Created SR/TAR in metalink, got fixes from oracle support and applied patches with coordination of Apps DBA for Bug fixing
• Maintained all the work done using PVCS. Also documented the work by creating various manuals for by future testers and users.

Environment: Oracle Apps 11.5.10 (GL, AR, AP, PO, OM, INV, WIP, BOM, CRM,WMS) Oracle D2k, PL/SQL, Workflow Builder, TOAD, SQL, Forms 6i, Reports 6i, XML Publisher, Oracle 10g, Windows NT, Unix.

Confidential, Phoenix, AZ

Sr. Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in requirements gathering, analysis, development, QA and production support.
• Prepared on the Module design Technical documentation MD070 for the changes performed.
• Worked on Creating the Monthly AP Extract file and FTPing it to CRS server, so as to fit the client requirement.
• Worked on Creating the Daily AP Extract file and FTPing it to CRS server, so as to fit the client requirement.
• Created custom Shell scripts to call the PL/SQL code that creates the files, FTP and archive the data files.
• Modified the bank codes and Bank statement interface as per client needs in Oracle Cash Management.
• Developed a custom Interface to handle the Inbound Purchase Order (850) through EDI, to validate the additional Header and line information.
• Worked on coming up with VAT Reports for GBP OU in pl/sql.
• Worked on creating a Daily COA Refresh Program to update COA values from another Database on a nightly basis.
• Created a SQL Report to display the list of Vendors on hold and registered as a concurrent Program.
• Worked on customizing the Bechtel Custom Report Bechtel Invoice Register Report to add and display the extra fields on the report.
• Worked on form customization by creating shortcuts to get to another form.
• Worked on the out-standing SCM module Production support issues.
• Involved in ad hoc querying and reporting.
• Weekly Development Interaction with Technical lead and Business team for status and any other outstanding issues.

Environment: Oracle Apps 11.5.10 (AR, AP, GL, PO, INV), Oracle D2k, PL/SQL, TOAD, SQL, Reports 6i, Oracle 10g, Windows NT, Unix.

Confidential, Minneapolis

Oracle Apps Techno-Functional Consultant

Responsibilities:

• Involved in requirement gathering, design, coding, development, documentation and post production support.
• Prepared Requirements document (UD) for Data Migration from Peoplesoft to Oracle system.
• Worked on Configuring various Oracle modules (OM, Shipping, INV, AR, Advanced Pricing) for a multi-site, multi-phase implementation
• Performed GAP analysis to ensure that the requirements are captured properly.
• Prepared Module Design Technical documentation MD070
• Worked with SQL Loader and PL-SQL Built in packages to import the PeopleSoft data into Oracle Applications using different APIs at different levels as and when necessary.
• Customized the Order entry form as per the requirements and created the customer specific pricelists.
• Customized PO Requisition Approval and PO Approval workflows.
• Created custom data migration programs to import data in the order of millions of records from the existing system.
• Worked on Customization of Bills in BOM.
• Prepared Migration Documents and User Manual.
• Worked on Creating various Oracle and XML reports as per client requirement.
• Have done performance tuning for the complex queries by using EXPLAIN PLAN.
• Coordinated with the offshore team to get the requests done.
• Worked as a Member of the Production support system to address day to day issues.

Environment: Oracle Apps 11.5.10 (OM, AR, QP, AP, PO, GL, BOM, INV, WIP), Workflow, Oracle D2k, PL/SQL, TOAD, SQL, Forms 6i, Reports 6i, XML Publisher, Oracle 9i, Windows NT, Unix, Discoverer.

Confidential, Fort Wayne, IN

Oracle Apps Techno- Functional Consultant

Responsibilities:

• Involved in requirement gathering, design, coding, development, testing, documentation and post production support.
• Worked on Configuring various Oracle modules (OM, Shipping, INV, AR) for a multi-site, multi-phase implementation
• Involved in interface that loads data from legacy system (AS400) into the auto-invoice table.
• Created and setup the auto accounting rules as per the client requirement and business need to handle the AR invoice accounting in GL.
• Worked on Auto Lockbox in AR.
• Customized the Order detail report.
• Worked on Order import interface.
• Extensively used workflow to build and launch business processes.
• Designed and developed custom program to load EDI 850 inbound Orders into Order Management and send custom acknowledgement codes through EDI 855 Outbound from Order Management.
• Designed change order summary report using discoverer.
• Imported the bulk of Journal Entry Transaction into GL INTERFACE table for the difference third party sources and ran Journal Import to insert validated journal entries into the production tables.
• Built Data base objects like Tables, Indexes, Foreign Key s and Views
• Worked on Communization of Bills in BOM
• Worked in accordance with SOX Compliance.
• Worked with the Performance/DBA teams to tune the applications.
• Define Concurrent programs, Executables and Request Sets for the SQL scripts.
• Performed Sys Admin activities for Technical work including setting-up of user responsibility, request group.
• Extensively worked on Oracle Discoverer tool to develop custom reports and necessary creation of new folders, items in Business Areas.
• Daily Development Interaction with Technical leads for status and any other outstanding issues.
• Worked as a Member of the Production support system to address day to day issues.

Environment: Oracle Apps 11.5.7 (OM, AR, AP, WIP, PO, AP, INV, BOM, GL), Workflow, Oracle D2k, PL/SQL, TOAD, SQL, Forms 6i, Reports 6i, Oracle 9i, Windows NT, Unix, Discoverer.

Confidential

Technical analyst.

Responsibilities:

• Involved in the design and development of user interface (GUI) in Forms 4.5 and table design using Oracle.
• Developed various Business and ad-hoc Reports.
• Created Data Flow Diagram, Entity Relationship Diagram from Designer.
• Involved in writing PL/SQL Triggers, Procedures, Functions, Packages and performance tuning.
• Various stored procedures were written to achieve the back end functionality.
• Development, Testing, Implementation and .