SUMMARY:

• With more than 16 years of experience in IT including 12 years as techno - functional consultant in Oracle ERP, I offer a rich skill base of consulting, implementation, support and development experience in Oracle Applications R12, R11i, R11, R10.4
• Extensive experience in the techno-functional aspects of Oracle Applications 12.1.3, 11.5.10/11.5.7/11.0.3/11.0.2/10.4 (INV, OM, WIP, OSFM, PJM, OPM, BOM, OE, PO, AR, AP, WSH, GL, AGIS, LEASE, QUALITY, WMS, AOL)
• Hands on experience as Team Leader, Senior Lead Developer/ Senior Programmer/Analyst
• Extensive Experience in development of Conversions, Open Interfaces, API, Concurrent Programs, Request Sets, SQL, PL/SQL, Alerts, Work Flow, SQL*Loader and reports.
• UNIX Shell Scripting.
• Supported production instances, fixes to production instance and higher management reporting.
• Extensive experience in customization and migration of Oracle Applications.
• Responsible for user acceptance testing and training.
• Responsible for Design and Development of Interface Programs.
• Responsible for Development of Data Conversion Scripts.
• Proficient in server side programming - Store Procedures, Functions, Database Triggers, Packages using PL/SQL and SQL.
• Involved in all aspects of Software Development Life Cycle and Production troubleshooting, Software testing, Requirement Analysis, Design Documents
• Conducted AS IS and TO BE Analysis.
• Experience in Unit Testing and Full Cycle Testing.
• Experience in application implementation methodology (AIM).
• Strong Communication, Presentation, Analytical and problem solving Skills. Proven Skills as an efficient Team Member in System Analysis, Designing, Development, Customization, Migrating and Documentation
• Extensive experience in Requirements gathering, Analysis and understanding of AS IS and TO BE models, Documentation and High Level Design.
• Experience in preparing Functional requiremt Document and Test cases.

TECHNICAL SKILLS:

Modules: Order to Cash Inventory (INV), Order Management (OM), Order Entry (OE), Advance Pricing (QP), Warehouse Management system (WMS), Shipping Execution (WSH), Accounts Receivables (AR), Oracle Quoting (QOT).

Procure to Pay: Purchasing (PO), Accounts Payable (AP), I-Procurement, I-expense.

Customer Relationship Management (CRM): Oracle Service Contracts (OKS), Install Base (CSI), Depot Repair, i-Payment.

Additional Modules: Oracle General Ledger (GL), Work In Process (WIP), Oracle Shop floor Management (OSFM), Oracle Project manufacturing (PJM), Oracle process Manufacturing (OPM), Bill Of Materials (BOM), Oracle Engineering, Advance Supply chain planning (ASCP), System Administration, FSG Reports, Fixed Assets, Oracle Workflow builder, Oracle Alerts (ALR), Oracle Quality, Project Accounting (PA), Oracle Human Resources (HRMS), Application Object Library (AOL/FND), Oracle XML Gateway.

Databases: Oracle 11g/10g/9i/8.x/8i/7.x

Oracle Tools: Developer 2000 (Forms 4.5, 5.0, 6i, 9i - Reports 2.5, 3.0, 6i, 9i ), SQL* Plus 3.x/8.x, Discoverer Administration (4i, 9i), Discoverer Desktop (4i, 9i).

Oracle Utilities: SQL* Loader, Export/Import

Operating Systems: DOS, Windows NT/2000/XP, SUN Solaris 2.5/5.6, HP Unix.

Languages: SQL, PL/SQL, MySQL.

Internet Technology: Java, J2EE, PHP, HTML, XML.

Development Tools: TOAD, SQL Navigator, Shell Scripts, Bartender for barcode reports, labels and tags, STATIT for graph, XML Publisher Report. Zebra Printer programming for label and barcode.

Version Control tool: Kintana.

Microsoft Products: Project, Visio, Word, Excel.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, California

Sr. Lead Techno-functional Consultant

Responsibilities:

• Setting up new forecast set and forecast.
• Setting up new master production schedule and master demand schedule
• Prepared application implementation methodology (AIM) MD-50 document.
• Developed extraction program to pull the data in XML-EXCEL format from various module like PO, OM, MRP, WIP.
• Developed Interface program to load new schedules and forecasts.
• Developed exception report for the items not associated with sourcing rules.
• Developed shell script to load XML files.

Environment: Oracle E-Business Suite Applications 12.1.3, INV, PO, OM, MRP, WIP, Toad, SQL, PL/SQL, XML Publisher, Operating system: Sun Solaris 5.8 OS.

Confidential, San Francisco, California

Sr. Lead Techno-functional Consultant

Responsibilities:

• Developed API to migrate the lease.
• Developed API to migrate the customer, locations and sites from QuickBooks to Oracle application.
• Developed interface program to migrate the vendor, sites, contact person from QuickBooks to Oracle application.
• Developed interface program to migrate the item and item cost.
• Developed interface to upload the AGIS transactions.
• Developed shell script to transfer ACH files to the bank.
• Developed new check formats.
• Developed interface program to migrate AR, AP invoices from QuickBooks to Oracle application.
• Engaged in code migration to production.
• Engaged in CRP and UAT to assist the user to do full cycle testing.
• Engaged in user training.

Environment: Oracle E-Business Suite Applications 12.1.3, GL, AR, AP, OLFM, AGIS, INV, Toad, SQL, PL/SQL, XML Publisher, Operating system: Linux 5.0 OS.

Confidential, San Francisco, California

Sr. Techno-functional Consultant

Responsibilities:

• Developed API to create new customer, site for subscription based sales.
• Developed interface program create the receivable invoice for PayPal and credit card transactions.
• Developed account analysis report in XML publisher to get excel output.
• Developed billing and payment history in XML publisher to get excel output.

Environment: Oracle E-Business Suite Applications 11.5.10.2, INV, OM, PO, AR, AP, I-expense, Toad, SQL, PL/SQL, XML Publisher, Operating system: Linux 5.0 OS.

Confidential, Fremont, California

Sr. Techno-functional Consultant

Responsibilities:

• Developed API application interface program create the job for various process like wafer, sort, assembly, test.
• Developed API to move the jobs with tracking the reject quantity.
• Developed interfaces to connect vendor’s B2B site and to bring lot information.
• Developed interface to automate the receive against the purchase release created from blanket purchase orders.
• Developed API for releasing the customer sales order, confirming the pick release and confirming the delivery.

Environment: Oracle Applications E-Business Suite 12.1.3, INV, WIP, OSFM, QUOTE, OM, PO, AR, AP, Toad, SQL, PL/SQL, XML Publisher, Operating system: Linux 5.0 OS.

Confidential

Sr. Techno-functional Consultant

Responsibilities:

• Created new operating unit, inventory organization.
• Setting up new responsibility for Order management, Inventory, Bill of materials, Work in process, Shop Floor.
• Developed interface program to migrate the item, cost, bom, routings.
• Developed API to migrate the customer, customer location, customer sites and contact information to new operating unit.
• Configured Inventory, Order management, Bill of material module.
• Developed new check for Singapore set of book in XML publisher.
• Developed program to calculate additional GST tax for AR invoices in Singapore set of book.
• Developed program to migrate the Vendor site and vendor contact information to new set of book.
• Tested full order to cash cycle.
• Prepared test scenarios for various order combinations.

Environment: Oracle Applications E-Business Suite 12.1.3, INV, WIP, OSFM, QUOTE, OM, PO, AR, AP, Toad, SQL, PL/SQL, XML Publisher, Operating system: Linux 5.0 OS.

Confidential, Cupertino, California

Sr. Techno-functional Consultant

Responsibilities:

• Developed API to create sales order from the legacy data.
• Developed new check printing program using XML publisher.
• Developed AR invoice using XML publisher.
• Developed Purchase order using XML publisher.
• Developed various reports in oracle discover.
• Prepared application implementation methodology (AIM) MD-70 document.
• Prepared test script for CRP1, CRP2, UAT.

Environment: Oracle Applications E-Business Suite 12.1.3, INV, OM, PO, AR, AP, Toad, SQL, PL/SQL, XML Publisher, Oracle Discover, Operating system: Linux 5.0 OS.

Confidential, San Jose, California

Lead Techno-functional Consultant

Responsibilities:

• Prepared test script.
• Developed Invoice printing program using XML publisher.
• Developed purchase order printing program using XML publisher and used bursting feature to send fax to the vendor.
• Developed check printing program using XML publisher.
• Developed revenue recognition report.
• Developed interface program to import sales order from Cleaver Bridge.
• Tested order to cash, procure to pay cycle with customization.
• Prepared application implementation methodology (AIM) MD-70 document.

Environment: Oracle E-Business Suite Applications 11.5.10.2, INV, OM, PO, AR, AP, Toad, SQL, PL/SQL, XML Publisher, Operating system: Linux 5.0 OS.

Confidential, Los Angeles, California

Techno-functional Consultant

Responsibilities:

• Developed program to split sales order line, reserving the on-hand quantity against the split order line, release and ship confirm the order lines based on EDI data.
• Developed program to create RMA lines based on customer return information.
• Developed interface in order management for EDI 850.
• Developed exception report for internal requests which has been confirmed but not received.
• Developed interface for the item, cost.
• Developed interface to load the vendor, vendor sites.
• Developed the program to load the bank, bank branches.
• Developed outbound files for AP, AR, and PO.
• Prepared application implementation methodology (AIM) MD-70 document.

Environment: Oracle E-Business Suite Applications 11.5.10.2, INV, OM, PO, AR, AP, Toad, SQL, PL/SQL, Operating system: SUN OS.

Confidential, Carlsbad, California

Lead Techno-functional Consultant

Responsibilities:

• Developed self service request, repair order, logistics line using API.
• Developed sales order upload program using API.
• Developed schedule ship date change alert.
• Developed exception report for approved PO without purchase requisition to alert buyers.
• Prepared application implementation methodology (AIM) MD-70 document.
• Handled day to day issues in INV, and PO.
• Handled day to day issues in various types of orders like standard order, drop ship order, configure to order (CTO), return order, internal order in OM.
• Created tar on production issues and followed up with Oracle support.

Environment: Oracle E-Business Suite Applications R11i (11.5.10) INV, OM, PO, AR, IB, Service Contract, Depot Repair, Toad, SQL, PL/SQL.

Confidential, Danbury, Connecticut

Techno-functional Consultant

Responsibilities:

• Prepared AIM document BR-100 for item template, sub-inventory, locator, Item categories and cost types.
• Prepared AIM document MD-50 for business need.
• Developed Item, Item category conversion program.
• Developed Customer item, Customer Item cross reference conversion program.
• Developed Cost conversion program.
• Developed locator, on-hand conversion program.
• Developed multi language packing slip and commercial invoice using XML publisher tool.
• Developed multi language VAT invoice using XML publisher tool.
• Developed purchase order report using XML publisher tool.
• Developed receiving interface for ASN lines sent by vendors.
• Prepared MD-70 document for conversion programs and reports.
• Setting up collection element, collection plan, Specification limits for quality module.
• Setting up different sub inventory and locator for the WMS based on high value and hazardous material.
• Prepared AIM document BR-100 for collection element, collection plan.
• Prepared AIM document MD-50 for action triggers.
• Developed action triggers for purchase order screen, receiving screen, WIP move transaction screen.
• Developed interface program to load quality data from legacy system.
• Developed of chart of accounts (COA) Reports based on various collection plans using XML publisher utility.
• Developed job analysis report, WIP operation report, quality analysis report using Oracle Discoverer administration and desktop.
• Developed quality analysis graphs using STATIT.
• Developed barcode reports to expedite receiving and picking process in WMS.
• Developed barcode for LPN and to moved the job using RF scanning devices through out operations.
• Developed labels and tags using zebra printer language.
• Developed Formula API Bill of materials for OPM.
• Developed API to upload OPM inventory quantities.
• Prepared MD-70 document.

Environment: Oracle E-Business Suite Applications R11i (11.5.10) QUALITY, PO, WIP, OPM, INV, WMS, Zebra Printer Language, STATIT, Report 6i, XML Publisher, Toad, SQL, PL/SQL.

Confidential

Techno-functional Consultant

Responsibilities:

• Developed abnormal demand form to capture the abnormal demand while creating the new sales order based on ASCP data.
• Customization of sales order line workflow for the abnormal demand situation.
• Integrated the abnormal demand form in oracle application using form personalization.
• Developed interface program to load the ASCP data from legacy system.
• Developed API to create item for OPM inventory.

Environment: Oracle E-Business Suite Applications R11i (11.5.10) OM, ASCP, INV, WIP, OPM, Workflow 2.6, Forms 6i, Toad, SQL, PL/SQL.

Confidential, Jemesburg, New Jersey

Techno-functional Consultant

Responsibilities:

• Customization of sales order line workflow to create service contract.
• Extracted item, sub inventory, lot, on hand data belongs to multiple operating units.
• Developed interface program for item, lots, on hand, sub inventory to upload the data in the new organization.
• Developed physical inventory report, fast and slow moving item report using Oracle Discoverer tool.
• Developed drop ship order report.
• Prepared LDTs for concurrent program, request sets, value set, request groups, responsibility, Menus.
• Tasted sales order full cycle with various scenarios.
• Developed cycle count report with barcode to be used for stock take.
• Developed barcode labels for each item to be used for picking by RF scanning devices.
• Prepared AIM document MD-70.

Environment: Oracle E-Business Suite Applications R11i (11.5.9) OM, INV, PO, WMS, MSCA, Toad, Oracle Discoverer 9i, Toad, SQL, PL/SQL.

Confidential, Olyphant, Pennsylvania

Techno-functional Consultant

Responsibilities:

• Extracted and imported Vendor, Vendor sites, Vendor Contacts, Bank, Bank Account, AP terms.
• Developed script to migrate FSG report.
• Extracted and imported fixed asset data.
• Developed GL open interface, AP invoice open interface, Purchase order open interface.
• Report migration and development.
• Develop financial report using Oracle Discoverer administration and desktop.
• Developed AP invoice aging report.
• Customized the ACH program.

Environment: Oracle Applications R11i (11.5.10) GL, AP, FA, PO, Oracle Report 6i, Toad, SQL, PL/SQL.

Confidential, Olyphant, Pennsylvania

Techno-functional Consultant

Responsibilities:

• Configured invoice batch source and transaction type, grouping rule.
• Developed AR open interface.
• Configured transmission format.
• Developed Shell script to load the lockbox data.
• Developed Procedure to validate and import the receipt.
• Developed Report and Alert.
• Registered report and report set.

Environment: Oracle E-Business Suite Applications R11i (11.5.10) AR, Oracle Alert, Report 6i, Toad, SQL, PL/SQL.

Confidential, San Jose, California

Technical Consultant

Responsibilities:

• Developed loader and control file to upload the raw data.
• Developed BOM assembly, component and reference designator interface.
• Developed Engineering changes interface, ECO revisions interface.
• Developed various report sets to schedule the activity.
• Developed various report for exceptions and error handlings.
• Developed BOM Explosion report

Environment: Oracle E-Business Suite Applications R11i (11.5.10) BOM, ENGINEERING, Report 6i, Toad, SQL, PL/SQL.

Confidential

Lead Techno-functional Consultant

Responsibilities:

• Support for the order related issues like order not getting booked, not getting released, order got closed but no invoice generated.
• Support for delivery order related issues like delivery got closed but inventory interface failed.
• Support for drop ship and internal orders.
• Opening and closing the period.
• Retriggering the failed workflow for the order.
• Support for Wip jobs for discrete and flow manufacturing.
• Uploading new price list through data loader and shell script.
• Defining Put-away rules, Picking Rules for WMS.

Environment: Oracle Applications R11i (11.5.7) WIP, OSFM, OM, WSH, INV, AR, PO, AP, WMS, MRP, Toad, SQL, PL/SQL.

Confidential

Lead Techno-functional Consultant

Responsibilities:

• Developed Vendor, Vendor Site and Vendor contact interface.
• Developed Purchase Order Interface, Receipt interface.
• Developed Payables open interface.
• Developed GL Interface.

Environment: Oracle Applications R11i (11.5.7) GL, AP, PO, Toad, SQL, PL/SQL.

Confidential

Lead Techno-functional Consultant

Responsibilities:

• Engaged in Information gathering.
• Configured new set of books, Locations, business group.
• Configured various responsibility and there profile setup.
• Configured Inventory, Order Management, Work in process, Shop Floor, Advance pricing module.
• Prepared AIM document BR-100.
• Prepared AIM document MD-50.
• Customized API and workflow.
• Customized formula in oracle pricing module to find the unit price for Assemble to order (ATO) type item.
• Customized Reports and PL/SQL.
• Developed Tax invoice report, Invoice ageing report, Packing Slip, Bill of Lading report development.
• Tested full cycle with customization and checked revenue recognition.
• Prepared the test script for user testing.
• Given Training to user.
• Engaged in rollover to production activity.
• Gave post implementation support.

Environment: Oracle Applications R11i (11.5.7) GL, INV, WIP, PJM, OM, ADVANCE PRICING, COFIGURATOR, WSH, AR, i-procurement, Workflow 2.5, Report 6i, Toad, SQL, PL/SQL.

Confidential, California

Lead Techno-functional Consultant

Responsibilities:

• Engaged in gathering detail Information.
• Defined new set of books, Locations, business group.
• Defined various responsibility and there profile setup.
• Configured Inventory module.
• Configured job, position, hierarchy, approval group in purchasing module.
• Prepared BR-100 document.
• Prepared MD-50 document.
• Developed Purchase order PDF report, Good receipt note, and auto mailing script to send document to vendor.
• Tested full cycle with customization.

Environment: Oracle Applications R11i (11.5.7) GL, INV, PO, Report 6i, Toad, SQL, PL/SQL.

Confidential

Techno-functional Consultant

Responsibilities:

• Defined various elements, sub-elements, class for costing.
• Mapped cost to general ledger by component class and analysis code.
• Created oracle package using various API like item cost, resource cost, allocation definitions and burden details.
• Created shell scripts to load various costing data from work in process system and payroll system.
• Created and registration of procedures in AOL to call the programs
• Created various analysis reports.

Environment: Oracle Applications R11i (11.5.7) GL, INV, COSTING, Report 6i, Toad, SQL, PL/SQL.

Confidential

Techno-functional Consultant

Responsibilities:

• Customized the Oracle workflow.
• Configured various order types and order line types.
• Configured new defaulting rules, Folders in Order Management.
• Developed various document sets for order management and shipping execution.
• Customized custom PLL.
• Developed reports for Proforma Invoice, Pack slip, Pick slip.
• Configured various shipping roles, folders in oracle shipping execution.
• Tested Full cycle for order to cash and procure to pay with the new customization to analyze the smoothness of the system.
• Prepared test plan for the users.
• Created Tar on product bug and followed up with Oracle support.

Environment: Oracle Applications R11i (11.5.7) INV, PO, OM, WSH, AR, Oracle workflow, Report 6i, Toad.

Confidential

Techno-functional Consultant

Responsibilities:

• Engaged in requirement gathering and concept study.
• Engaged in overall architecture design.
• Created database objects like tables, views, triggers for the portal.
• Created various packages, functions, procedures to extract customer bill to and ship to information, credit terms and amount, tax invoice, debit memo, credit memo, receipt information from Oracle receivables.
• Developed scripts to extract the item, on hand information from inventory.
• Developed script to extract the information about confirmed delivery, quantity and type of item shipped, forwarder through it is shipped and expected arrival time at destination.
• Developed various shell scripts and cron jobs to schedule the scripts.
• Prepared user manual preparation.

Environment: Oracle Applications R11 (11.0.2) OE, INV, AR, Toad.

Confidential

Techno-functional Consultant

Responsibilities:

• Developed open item interface, customer item interface, cross reference interface, revision interface and category interface.
• Developed BOM bill interface, inventory component interface.
• Created various package, procedure, functions to integrate the interface programs.
• Registered the programs in Application Object Library (AOL), created report set to run the program sequentially.
• Created reports to generated the error logs
• Created alert to send the error log to data owner.

Environment: Oracle Applications R11 (11.0.2) INV, BOM, Oracle Alert, Toad.

Confidential

Techno-functional Consultant

Responsibilities:

• Defined the business requirement.
• Developed interface program to find new schedule jobs from PROMIS manufacturing system
• Developed the program to calculate total raw material required for jobs based on bill of materials.
• Developed reservation interface to hold the raw material against the jobs.
• Developed open transaction interface for mass issue.
• Developed alerts, reports to notify purchasing department, stores department about the stock position and material shortage.
• Develop material issue report using Oracle Discoverer administration and desktop.

Environment: Oracle Applications R11 (11.0.2) INV, BOM, PO, PROMIS, Toad.

Confidential

Techno-functional Consultant

Responsibilities:

• Defined the business requirement.
• Developed interfaces to create the auto reservation, pick release, pick confirm process for eligible sales order.
• Registered the programs, report set in application object library (AOL) to schedule the program to run automatically
• Defined the alerts to notify to users about exceptional situation.

Environment: Oracle Applications R11 (11.0.2) INV, OE, Report 2.5, Toad, SQL, PL/SQL.

Confidential

Technical Consultant

Responsibilities:

• Developed job split screen for discrete jobs.
• Developed automatic job schedule program based on legacy data.
• Developed job tracking report.
• Developed machine wise yield report.
• Developed raw material transaction report based on shop-floor operation.

Environment: Oracle Applications R11 (11.0.2), WIP, OSFM, BOM, INV, Forms 4.5, Report 2.5, Toad, SQL, PL/SQL.

Confidential

Systems Programmer

Responsibilities:

• Engaged in technical discussion and system study.
• Involved in database design.
• Developed of forms and reports.
• Engaged in end user training.
• Engaged in technical manual.

Environment: Oracle 7.2, Sco UNIX V5.0, Developer 2000(Forms 4.5, Reports 2.5, Procedure Builder 1.5), SQL 3.2, PL/SQL 2.2, Windows 95