SUMMARY

• Oracle E - Business Suite R12 Supply Chain Certified Specialist: Oracle Order Management
• 15 years of IT experience involved in requirement gathering, design, development, testing, implementation, maintenance, production support
• 12 years in Oracle Applications, worked on versions Oracle 10.7, 11.0.3, 11.5.8, 11.5.9, 11.5.10 and R12 on Supply Chain Management, Distribution, and Manufacturing modules for various clients.
• Mostly worked on Order to Cash, Procure to Pay and Manufacturing business cycles
• Involved in Setup of various modules according to the requirement of Client needs
• Expert in Development, Customization, System/Acceptance Testing, and Post-Deployment Support
• Very efficient in writing MD50 for designing custom processes
• Expert in designing interface/conversion programs including writing the Technical design document
• I worked on a Warehouse implementation project where I documented the TDD and developed the complete automation of Order management cycle including order entry, creating delivery, trips and shipments and interfaced all the order and shipping details to a third-party system
• I led a 10 member team in an implementation project to deliver the whole range of interface programs/conversion programs and reports and also led a team in an iProcurement production support project

TECHNICAL SKILLS

Oracle Applications: PO, INV, OM, BOM, WIP, ASCP, Oracle shipping, AOL, iProcurement, Advanced Pricing

RDBMS: Oracle 8i /9i/10g/11g

Domain: Supply Chain Management, Distribution

PROFESSIONAL EXPERIENCE

Confidential, Appleton WI

Oracle Applications OTC Functional

Environment: Oracle Applications R12.1.3 (OM, INV, PO, AR, Shipping, BOM, WIP, ASCP, iStore), Windows XP

Responsibilities:

• Responsible for ongoing functional support on the OM and SCM modules
• Very closely working with entire offshore team on daily basis
• Extensive user interaction for understanding and resolving production issues
• Conducting and attending meetings with business users to discuss current projects and also future enhancements
• Also provide training to users in the execution of Oracle transactions, preparing training documentation and Test Scripts
• Prepared MD50 for custom processes in order management and pricing modules
• Actively involved in setting up hold sources, processing constraints, inter-company shipping networks, transaction types, picking rules, pricelists, modifiers and qualifiers
• Worked on refreshing models in Oracle configurator
• Worked on inter-company drop-ship transactions as well as inter-company holds
• Worked on consolidated billing invoice for customers
• Extensively working on Oracle bidding and quoting, advanced pricing as well as interaction between iStore and order management
• Raised Service Requests with Oracle to resolve critical issues

Confidential, Fargo, North Dakota

Oracle Applications Manufacturing Functional Consultant

Responsibilities:

• Responsible for ongoing functional support on the Inventory, BOM & WIP, Costing, OM modules
• Lead an offshore team to complete the execution of the RICEW objects.
• Developed MD50 to roll up physical attributes of option choices to the configured items of existing sales orders.
• Analyzed and Configured Setups in Inventory, OM, BOM and WIP modules and making use of them in interfaces design and development.
• Worked extensively on WIP Backflush and Routing issues
• Setup item attribute controls, item templates and analyzed the need for sub inventories and setup shipping networks for inter-org transfer.
• Designed (MD50) for a customized Archive and Purge process for the Inventory Module.
• Performed Form Personalization on Move Transaction screen to in corporate scrap account functionality
• Worked in Lot Based and Serial Based Manufacturing based on the product requirements. WIP Assy Completions with the Lot Number generations based on the Discrete Job classification
• Conversion activities to load the Routings/Bills of Materials utilizing the Routing API and the Bills of Material API.
• Supported conversions like Items, Item Categories, BOM, Routing, Cost, Item transaction default & On hand qty.
• Assist in month end tasks to the inventory team. Documented month end reconciliation tasks list to the team.
• Creating Process, Testing Documentation and presenting them to Business Representative, external Source System analysts & Technical Analyst.

Confidential

Oracle Consultant

Environment: Oracle 11.5.10, Oracle Forms 6i and 11g, Reports 6i & 11g, Oracle Fusion Platform 11g, Toad, Shell Scripts

Responsibilities:

• Interacting with Confidential clients and providing them application, functional and technical support which includes taking initiative to improve processes, code base and application performance
• Production support of complete LSP loyalty system which consists of standard Oracle 11i modules (OM, Advanced pricing, INV) including customizations of interface and conversion programs and reports
• Participated in design discussions with business team and performed impact analysis
• Extensively worked on setting up pricelist, modifiers and qualifiers
• Extensively worked on AOL in setting up concurrent programs, creating key and descriptive flex fields, value sets etc. in both development and production environment
• Designed and developed interface programs to import pricelists, pricing formulas, custom prices pricing attributes and modifiers from legacy systems
• Actively involved in conversion and interface projects from LSP to Grand Central including writing technical design documents and development of the processes
• Worked on several existing programs and reports and re-structured them to improve their performance significantly using performance tuning utilities like TKPROF, AUTOTRACE, explain Plan, indexing and hints
• Open TAR for issues and co-ordinate with Oracle Corporation Support for the resolution of issues. Review and research Metalink notes, patches and performed dependency analysis before applying them on environment
• Prioritize, analyze and resolve application and technical incidents and problems
• Implement the approved set-ups and configuration changes.
• Fixed bugs and did enhancements using tools like Oracle Forms & Reports, Toad, WRQ Reflection, Telnet, FTP etc.
• Did version control through VSS
• Complete production support process through Review, walkthrough of documents / programs as part of QA
• Exposure on Oracle ADF and Fusion technology
• Prepare reports and share those with other teams

Confidential, Detroit MI

Oracle Supply Chain Techno-Functional Consultant

Environment: Oracle Applications 11.5.10 (OM, INV, PO, AR, Shipping, BOM and WIP), Windows XP, Oracle Forms 6i, Reports 6i, Toad, Shell Scripts

Responsibilities:

• Providing AAM users with application, functional and technical support
• Production support of complete ERP system which consists of standard Oracle 11i modules (PO,OM,INV,AP,WIP,BOM) including customizations of interface and conversion programs and reports
• Ran through the whole order to cash cycle including generating invoice transactions, remitting checks and executing bank reconciliation
• Worked independently on following interface programs to Import standard and blanket purchase orders, responses to request for Quotations(RFQ's) from suppliers, from another system to Oracle Independently developed an interface program to Import items from an external system to locator controlled Sub-inventories
• Prioritize, analyze and resolve application and technical incidents and problems
• Implement the approved set-ups and configuration changes.
• Bug fixing and enhancement using tools like Oracle Reports, Toad, WRQ Reflection, Telnet, FTP etc.
• Version control through PVCS
• Well conversant with tuning packages and procedures using utilities like explain plan, tkprof etc.
• Complete production support process through Review, walkthrough of documents / programs as part of QA
• Set up test data /scenario as required for testing the resolution of the issues
• Prepare weekly reports and communicate to AAM team

Confidential, Baltimore, MD

Supply Chain Techno-Functional Consultant

Environment: Oracle 11.5.9 and 11.5.10 (Order Management, Purchasing, Inventory, Warehouse), Oracle 9i and 10g, Windows XP

Responsibilities:

• Working in both upgrade and warehouse implementation
• Extensive involvement in upgrade project (from 11.5.9 to 11.5.10) through testing in upgrade instance as per test scripts and bug fixing and setting up the new system
• Working in core development team of warehouse implementation, involved in development of custom interface and conversion programs in order management, shipping, inventory and warehouse management
• Developed the entire custom Oracle Order management and shipping using shipping APIs to create deliveries, trips and firming deliveries
• Created a custom Pick release program which does the pick release for all the trips associated with the ship method
• Worked in iProcurement and modified workflows to change the approval routes of purchasing documents for a particular source
• Working closely with functional team and wrote technical design documents of interface conversion programs
• Worked in a team to develop planning engine-UI communication system based upon dbms pipe for 11.5.9(Oracle 9i) Implemented the same with dbms aq for 11.5.10 (for Oracle 10g)
• Worked on EDI Gateway to transfer Pyxis purchase orders to suppliers
• Production support of Pyxis system handling mainly supply chain issues
• Used SCCS for version control and Kintana from code migration

Confidential, Webster, NY

Oracle Techno-Functional Consultant

Environment: Oracle Service Contracts 11.5.9, Windows XP, Oracle Discoverer

Responsibilities:

• Production support of XONE system which is customized Oracle service contract module
• Defining and managing service contracts and tracking items in Install Base
• Prioritize, analyze and resolve application and technical incidents and problems
• Implement the approved set-ups and configuration changes.
• Building reports on contracts and billing data on discover 9i
• Worked on Oracle discoverer to retrieve and analyze data on contracts and contract billing
• Participated in functional and technical design discussions with stakeholders, Coordinated with teams of other impacted modules of Oracle Applications and worked for the resolution of product’s technical & functional design conflicts, bugs, and defects
• Review, walkthrough of documents and programs
• Set up test data /scenario as required for testing the resolution of the issues
• Prepare weekly reports and communicate to Confidential team
• Providing Confidential users with application, functional, setup and technical support

Confidential

Supply Chain Techno-Functional Consultant and Team Leader

Environment: Oracle iProcurement, Oracle Purchasing and Payables 11.5.8, Windows NT, UNIX

Responsibilities:

• Production support of whole Gemsbuy system both functionally and technically
• User interactions for issues and enhancements.
• Solving production Problem Request (Oracle Apps) of US sites of Gemsbuy global, delivering the solutions to key users
• Worked on all types of procurement issues including requisitions, Purchase Orders, Buyers, shipments and as well invoice generation in Payables
• Tuning packages, procedures and Oracle reports
• Effectively involving with GEMS functional key users to implement Gemsbuy system
• Modification of custom interface programs, reports, shell scripts and migration them to production instance after successful testing on test instance

Confidential

Development Team Leader

Environment: Oracle apps 11.03 and 11.5.5 (PO, OM, INV, WIP, BOM, AP, AR), Oracle Reports, Workflow, UNIX, Windows NT

Responsibilities:

• Handled distribution Modules - INV, OM, PO to support the GEMS Global Oracle Development and Support Team.
• Controlling development Problem Request (Oracle Apps.) of Various sites of GEMS global, delivering the solutions to end users
• Effectively done the setups for different sites for PO, INV and OM modules
• Development of Oracle reports on PO, OM, INV, BOM, WIP, AP, AR.
• Development of Interface and conversion programs on PO, INV, OM and AP
• Supervised and supported the manufacturing testing team in successful completion of Testing and in meeting time specific targets with utmost care to quality
• Worked with upgrade team from Oracle 11.0.3 to 11.5.5 and actively involved in value addition to the existing testing process by way of expanding the scope of Regression testing to interface, performance and adding the newer and additional functionalities to the existing test scripts.