EXPERIENCE SUMMARY

• Over 14 years of experience in Oracle Applications design, development, testing and support across different versions (10.7, 11i and R12).
• Experience in Oracle business flow in Order - to-Cash (O2C) and Procure-to-Pay (P2P) cycles
• Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration and project coordination activities.
• Technical skills include PL/SQL, Forms 6i/10g, Reports 6i/10g, Custom pll, Form Personalization, Oracle Discoverer, XML/BI Publisher, Oracle Workflow, Conversions, Data Migration, SQL*Loader, Interfaces for Cross-System Integration using Oracle APIs and Custom Extensions to Oracle Applications with Good knowledge of Unix Shell Scripting and Oracle Alerts.
• Experience in design, develop, implement and customization of RICEFW (Reports, Interfaces, Conversions, Extensions, Forms and workflow) Components.
• Good working knowledge of all the stages of Software Development Life Cycle (SDLC), Proficient with Application Implementation Methodology (AIM) and Enterprise Application Process Methodology (EAPM)
• Techno-functional expertise, well augmented by excellent analytical, problem solving, communication, and interpersonal skills, with the ability to interact with individuals at all levels, the ability to perform individually or as a dedicated team member, and good exposure in coordinating with Offshore and Onsite resources

PROFESSIONAL SKILLS:

• Oracle eBusiness Suite (EBS) 10.7, 11i, R12
• Oracle Distribution/Supply Chain/Manufacturing (INV, PLM, PO, OM, WSH, BOM, WIP, iSupplier, QA, Advanced Pricing, ASCP, RLM and ENG)
• Oracle Financial (GL, AP, AR, ipayments and Advance collections)
• Oracle CRM (Service contracts)
• TCA, AOL, SYSADMIN and Oracle Alerts
• Oracle Discoverer, Oracle BI/XML Publisher and Oracle Reports
• SQL, PL/SQL, Oracle, Developer 2000 (Reports 6i/10g, Forms 6i/10g), Custom pll, Form Personalization, Workflow, Unix Shell Script, TOAD, SQL*Loader, PL/SQL Developer, WIN CVS, PVCS, Mercury ITG/Kintana, Change Control, PUTTY, Data loader, SQL*Plus, GITHUB

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Responsibilities:

• As a Technical Architect, was responsible for analyzing the existing systems and implement new payment methods integrating with Oracle Order management, Oracle Payments, Receivables and Cash Management.
• Designed technical approach (End to End) to implement PayPal Xpress Checkout and PayPal Credit. The framework is designed in a flexible model to allow for implementation of future payment systems or locale with minimal efforts. A new java servlet is designed to interface between EBS ~ SOA. SOA interacts with PayPal upon receipt of the information.
• Reconciliation is automated and performed without user intervention.
• Payment integration implemented for US and Canada in an onsite-offshore model. Solution is currently being rolled out to UK.
• 6 different operations are implemented between EBS ~ SOA ~ PayPal including Funds Capture, Refund, Re-authorization, Update Authorization, Payment Void and bank statement reconciliation.
• It was an onsite ~ offshore model development.
• Currently working as an onsite technical lead for production support.
• Oracle Applications R12.1.3, Oracle Tools TOAD, Oracle 10g, Red Hat Linux, SOA

Confidential, Mchenry, IL.

Responsibilities:

• As a Systems architect analyzed legacy systems within FSS, including Oracle ( Confidential
• Library System, 29 years) and define Master Order concept through Consolidated Order Management system.
• Mapped Sub-orders and identified data fields with the target system.
• Designed the data model within oracle system as an extended schema.
• Defined touch points for both batch and real time as a web service.
• Developed the solution for incoming feeds to COMS.
• Performed Initial load of data elements including Items, Cost and Inventory.
• Listed out Use cases for the complete process and facilitated User Acceptance
• Oracle Applications R12, Oracle Tools TOAD, Oracle 10g, Red Hat Linux 5.4

Confidential

Responsibilities:

• As a Technical lead handled all activities including resource management, complete work assignments to offshore team, quality coding, testing and documentation as per SOX.
• Provided Production support for Order to Cash modules along with Service Contracts and Advanced collections.
• Monitored integration points with other legacy systems like WMS, AS400, EDW, RVI for Picking, Shipping and Invoice related interfaces.
• Developed Re-Allocation form.
• Worked on R12 upgrade from 11i
• Modified Trade return process.
• Oracle Applications 11.5.10.2, Oracle Tools XML Publisher, TOAD, Oracle 10g, Red Hat Linux 4.0

Confidential

Responsibilities:

• Worked as a System Architect (Techno-Functional Role) in a team of 12 members.
• Production support was the key and new sites implemented (AWP, Australia, Italy, Schaeff Germany)
• Designed order close match solution, Universal Work queue, Dakosy system interface and Customer facing documents.
• Terenet Credit Memo Program auto scheduling, by getting all the file names from the given UNIX directory and submitting in each operating unit as per the file name.
• Developed new reports on Discoverer to support the production engineers.
• Modified existing Standard PO xsl style sheet.
• Integrated export compliance with KEWILL at order booking, Delivery and shipping levels.
• Integrated manufacturing labels with xml gateway and Loftware.
• Designed check printing program in the specific bank formats.
• Order line workflow modifications (VAT hold).
• Developed solutions for 3PL PO Approval workflow, ASN email/fax and Customer facing documents.
• Worked on forms personalization’s and migration scripts.
• Oracle Applications 11.5.10.2, Oracle Tools XML Publisher, TOAD, Oracle 10g, Red Hat Linux 4.0

Confidential, Orrville OH

Responsibilities:

• Worked as a Technical Consultant in a team of 15 members.
• Working for the client on OPM 11.5.10 who has wide range of products in food segment. They manufacture Jam, Jelly, Peanut Butter, Sandwich, Ice Cream Toppings and Coffee. Their main brands are Smucker's, Jif, Dickinson, Crosse & Blackwell, Adams & Laura Scudder, Knott's Berry Farm, Hungry Jack, Pillsbury, Martha White, White Lily, Crisco, Red River, Kava, None Such, Borden, Milnot, Eagle Brand, Pet, Golden Temple, Folgers, Millstone. Recently they acquired Folgers Coffee.
• Developed a solution to automate the create, remove, and change inventory status in OPM currently these transactions were happening in WMS system (DLx), will automate the entry of those transactions in OPM. It will read the transactions from the inventory activity table in DLx, determine if the transaction is one that OPM is interested in and create the appropriate OPM inventory transactions. A flat file is generated by this program containing the inventory transactions. This flat file will be input to the transaction API.
• Developed solutions on integration between different building with in same plant or organization for Shuttle adjustments.
• Developed a new package, shell script and prog file to calculate the co-products produced and adjust in OPM. These adjustments are created as flat file that will be used as an input for the inventory API to adjust the inventory.
• Oracle Applications 11.5.10 (OPM), Mercury IT Governance center, Autosys Job scheduling

Confidential, Romeo, MI

Responsibilities:

• As an Onsite Techno-Functional manager for conversions development and testing.
• Team of 20 members (Onsite & Offshore)
• Developed conversions from legacy to Oracle Applications R12 that includes Item, Item Revisions, PLM Attributes, Categories, Attachments, Life cycle and roles, Kanban Pull Sequence, Item Cost, QA Specification, and QA Collection Plan
• Responsible for RIE components with XML as output template that include QA Inspection and Part Information Reports with Images embedded for each part, ASCP - Weekly Sales Forecast and Consolidated Resource and Material Requirement Reports, and OM - Past Due and Expected Shipments, Scheduled Shipment Report, Product Certification
• Responsible for labels - production and shipping, wherein there are over 70 label formats to be handled by item or work order while in production and while shipping with master/ grand LPNs and these labels will be printed through Loftware
• Responsible for packing workbench form - packing/ unpacking the current on-hand quantity as per the standard pack quantity into a new master LPN where the child labels were produced from the above Label PROD program or unused LPN for the given sub-inventory and locator
• Participating in developing the MD070, mapping documents along with MD120 for all the above components with the help of functional and user inputs
• Developing Unix Shell Scripts to download and upload the concurrent program definition and for XML part
• Developing the Mapping documents, CV055, MD070, and MD120 for all the above components with the help of functional and user inputs
• Handling all the conversion activities while loading the data into testing and production instances before Go-Live
• Oracle Applications R12 RUP 4 (eBS, Financials, AR, GL, AP, OM, PO, INV, WIP, BOM, RLM, ASCP), Oracle Tools XML Publisher, TOAD, Oracle 10g, Red Hat Linux 4.0

Confidential, Livonia, MI

Responsibilities:

• Worked as a Technical Consultant in a team of 20 members
• Worked on Confidential project, wherein the aim is to integrate the products offering by the client
• Worked on the functionality that pertained to the Erstwhile Confidential products (basically advertising delivered via newspapers)
• Developed solutions to drive the cross selling of newspapers and shared and solo direct mail and provided clients the best possible local media plans guided by their national advertising goals and budgets
• Responsible for preparation of technical designs, solution, development, and testing that included newspaper filter to identify the raw buyable units and check the preferences and media level exclusions, Run Of Press (ROP) filter, preprint filter, and best day date calculation based on discovery preferences
• Oracle 10g, TOAD, Visual Studio

Confidential

Responsibilities:

• Technical Lead for a team of 6 members
• Worked for the client that is a subsidiary of Confidential and a part of tools MAC group that is implementing Oracle eBusiness Suite 11.5.10
• Worked on the Five Star project that involved multiple types of objects spread across multiple technologies, wherein the types of objects involved interfaces, reports, extensions, and customizations
• Worked on the enhancement, wherein the technologies involved within the client’s industries project were Oracle and DRP systems
• Responsible for the preparation of technical designs, solution design, development, and testing that included cross reference form developed to map the data between Oracle and Legacy systems (DRP)
• Worked on the outbound interface for DRP system (INV), safe-reserve form (OM-WIP-PO-INV), VAT compliance report for Europe (AR), print process sheet (WIP), Item DFF update (INV), order priority reserve program (OM), and standard invoice report customization (AR)
• Developed the above new components as well as provided production support for manufacturing modules
• Oracle Applications 11.5.10 (eBS, Financials, AR, WIP, MFG, OM, PO, INV), Oracle Tools (Workflow, XML Publisher), TOAD, PVCS, Oracle 8.x

Confidential

Responsibilities:

• Technical Consultant in a team of eight members
• Worked on the project to enable Confidential quality and receivables across different Rosemount sites (Germany, Chanhassen, and Singapore)
• Responsible for the preparation of technical designs, solution design, development, and testing that included material review process (Workflow), supplier corrective action (Workflow), and receipts interface to sync-up with JD Edwards (after receive, deliver or any return to vendor)
• Provided post-production support for two months (support extension)
• Oracle Applications 11.5.9, TOAD, PVCS, Oracle Tools (Workflow), Oracle 8.x

Confidential

Responsibilities:

• Offshore Technical Lead for a team of 9 members
• Worked on the project to enable Confidential procurement and Confidential planning across different Rosemount sites (Germany, Chanhassen, and Singapore) that also involved supplier to create/ view data such as ASN and invoices using iSupplier portal
• Worked on the project that had data touch points between JD Edwards and Oracle to sync-up the data between both the systems using SeeBeyond
• Responsible for the preparation of technical designs, solution design, development, and testing
• Worked on new development and provided post-production support for two months (support extension)
• Oracle Applications 11.5.9, Oracle Tools (Workflow), TOAD, PVCS, Oracle 8.x

Confidential, St. Louis, MO

Responsibilities:

• Offshore Technical Lead for a team of 8 members
• Worked for the client who is converting all the business processes that are at present prevailing for their IHP division in JD Edward system to Oracle in different phases of implementation and is implementing Oracle suite of modules to serve the growing business needs
• Worked for the client who is going for a single integrated system Oracle Applications across all of its divisions and thus the conversion of legacy data to new system forms major part of the program
• Responsible for the preparation of technical designs, solution design, development, and testing
• Developed solutions on integration between COPICS and Oracle to bring in all the BOM information
• Developed solutions to upload the on-hand quantities which are laying in the Shop Floor while they are performing wall-to-wall physical inventory counting
• Developed Exception report that displays all the receipts created during the day by buyer, which exceeded the receiving tolerance
• Synchronized with the Sequencing system that catered to the need of Sequencing system in Motores by providing WIP, Bill Of Material, and other item specific information to the Sequencing system, on the basis of this Motores generates its daily production schedule
• Developed a program for Mena and Motores, production controls everyday scrap out in-process material due to process defect, order cancellation, test failures, and various other reasons wherein scrap items can be “Purchase Items”, “Transfer Items”, “Phantom/ Non-Phantom Sub-assembly”, and “Non-Phantom Sub-assembly but not reaching count point”
• Moved all the scrap items into SCRAP sub-inventory after doing the necessary steps of operation, from that sub-inventory; each item is to be issued, since the daily volume of scarp transactions is large, so it is desirable to complete these programmatically
• Oracle Applications 11.5.9, Oracle Tools (Workflow), TOAD, PVCS, Oracle 8.x

Confidential

Responsibilities:

• Technical Consultant in a team of 16 members
• Worked on the project to enable Confidential procurement and Confidential planning across different Rosemount sites (Singapore and Chanhassen) that also involved supplier to create/ view data such as ASN and invoices using iSupplier portal
• Responsible for the preparation of technical designs, solution design, development, and testing
• Developed solutions on integration between JD Edwards with Oracle for Purchase Orders and supplier synchronization and modified the order line Workflow so that after ship confirmation for particular orders to increase the in-transit quantities in specified sub-inventory
• Developed solutions, wherein the VMI planned Purchase Order upload was performed using a custom JSP in the collaborative planning portal and once the file is uploaded, a program will be invoked that will insert the records into the PO interface table and from there the PO import program will pull the records into the standard table
• Oracle Applications 11.5.9 (PO, iSupplier), Oracle Tools (Workflow), TOAD, PVCS, Oracle 8.x

Confidential, San Diego, CA

Responsibilities:

• Technical Consultant in a team of 16 members
• Worked on the project that resulted in the retirement of the Mainframe-based order processing and Inventory Management system, replacement of STN, implementation of SAP, integration of Supply Chain, and enhancement of plant and warehouse functionalities in terms of planning and execution
• Worked on the project that deals with the TV business of the client
• Responsible for the preparation of technical designs, solution design, development, testing, and preparation of user manuals
• Worked on integration points such as pick slip, ship confirm, QC release, and item interface between Oracle and DM+
• Worked on integration between Coss and SmartRack with Oracle for pick slips and ship confirm
• Developed Alerts for ship confirmation errors and audit tracking all the direct orders that were downloaded in Oracle from SAP and those were pick released, and an email program for exceptional cases
• Oracle Applications 10.7, PVCS, TRS, Oracle Tools (SQL Navigator), Oracle 7.x

Confidential

Responsibilities:

• Senior Software Engineer in a team of 12 members
• Implemented MFG modules and upgraded Financials modules from 11.5.4 to 11.5.8
• Prepared technical design and tested the interfaces developed
• Developed complex inbound interfaces from Legacy system to MFG modules (BOM, Routing, and Purchase Orders)
• Customized standard PO report to print on pre-printed stationary for different type of POs such as standard, blanket, releases, and export with annexure and without annexure
• Developed and customized reports such as Pick List Cards for stores (WIP), Profile Class Wise Debtors Outstanding report (AP), Goods Receipt Note (AR) pre-printed stationery, and billable delivery note on pre-printed stationery
• Customized Standard report, Buyer’s Requisition Action Required report, Engineering Change Order report, 57f4 report, and PO Requisition Status report
• Oracle Applications 11.5.4 and11.5.8 (AP, AR, GL, PO, BOM and WIP), Oracle 8i, TOAD

Confidential

Responsibilities:

• Senior Software Engineer in a team of eight members
• Worked on the project that included implementation of MFG modules
• Responsible for designing, coding, testing, and documentation
• Developed complex forms for checking the cable details
• Developed an interface for uploading items and item categories
• Developed interface program to upload discrete job details in job schedule and job details tables in WIP
• Customized Standard report such as Seeded report to explode a bill and restrict the output to show one level below ATO model items
• Developed a report for POs having two-way, three-way, and four-way matching with item value more than the amount in Purchasing
• Oracle Applications 11.5.8 (MFG), Oracle 8i, TOAD