EXPERIENCE SUMMARY:

• Over all 12+ years of work experience including 12.3 years in Oracle E - Business Suite Supply Chain Management (SCM) with expertise in Inventory, WMS, MSCA, Order Management, Shipping, Purchasing, WCS, Bills of Material, Work in Process modules.
• Experienced in designing, development, testing and deployment of Interfaces, Conversions, OAF pages, Discoverer Reports, XML Reports, Oracle Reports, Oracle Forms, Workflows, PL/SQL Packages, Form customizations and Personalization, Web Services and Production Support.
• More than 7 years of onsite Oracle WMS Shipping experience worked Techno Functionally on Warehouse Management System, Inventory, Order Management and Shipping modules.
• Oracle WMS Implementation experience including configuring the mobile guns, printers and labels.
• Extensive experience in different Oracle E-Business flows such as Order to Cash ( O2C ) and Procure to Pay ( P2P ).
• Functional responsibilities: Business Requirements gathering, GAP Analysis, Solution Design, designing workaround solutions, Test Plan Preparation, Data Conversion, Unit Testing, Functional Architecture, System Integration testing, CRP, UAT, Go-Live preparation and Production Support.
• Technical activities: Interface with users, identifying functional and technical gaps, estimating work, solution designing, programming, documentation and production support.
• Experience in data mapping & conversion from legacy system to Oracle.
• Extensive experience as Oracle Techno functional roles in ERP Implementation, Enhancements and production support Projects in Oracle EBS R12 and Oracle EBS 11i.
• Trained on Oracle Cloud.
• Oracle OCA Certified.

TECHNICAL EXPERTISE:

ERP: Oracle EBS R12 & 11i

Modules: Warehouse Management System (WMS), Warehouse Control System (WCS), Inventory (INV), Order Management (OM), Shipping, Purchasing, Bill of Material (BOM), Account Receivables (AR), Account Payables (AP) and Oracle Process Manufacturing (OPM).

Programming Languages: SQL, PL/SQL, Java

GUI: Oracle Forms, Oracle Reports, OA

FrameworkTools: Toad, SQL Developer, Workflow Builder, JDeveloper, Discoverer, MWA/MSCA Application, PVCS, IBM RTC Tool, Putty, Data Loader, WEB ADI, CodeSoft labeling tool

EXPERIENCE:

Confidential

Responsibilities:

• Business meetings with users and gather the project requirements and do gap analysis.
• Analyze the current processes and analyze the customizations and categorize into components to deliver.
• Analysis with the team to fit the new requirements in the current design without major changes in the processes and less impact to the users.
• Understand the BR030 requirements and design the conversion mappings, worked on Item conversion, BOM Routing conversion, BOM Conversion, WIP Job Conversion, Onhand Conversions and custom component conversions.
• Work with the team to develop, test and deliver the solution.
• Preparations for project milestones, CRP, SIT and UAT testing, end users on new system processes and Post Go-Live support.

Environment: Oracle Apps 12.2.4

Software / Tools: SQL * Plus, SQL Developer, Putty, Data Loader

Confidential

Responsibilities:

• Scoping meeting with business and gather project requirements and do gap analysis.
• Setup new WMS warehouse with configurations that includes WMS rules, Picking rules, Organization parameters, Receiving parameters, Shipping parameters, Cycle Counting, Pick load page setups, Task types configuration, Shipping networks, Labels and other basic configurations necessary to run the warehouse.
• Identifying the developments needed for the process implementations to cater VMI Consignment model and integrations needed to communicate with different Suppliers.
• Understand the BR030 requirements and prepare MD050 and MD070 documents.
• Worked on OAF Page developments.
• Work with offshore development teams and deliver the technical components.
• MWA Page developments.
• Preparations for SIT and UAT testing, users on new system processes and Post Go-Live support.

Environment: Oracle Apps 12.2.4

Software / Tools: SQL * Plus, SQL Developer, JDeveloper, MWA Application, Putty, Data Loader

Confidential

Responsibilities:

• Scoping meeting with business and gather project requirements and gap analysis.
• Worked with the team in streamlining and implement the business processes to accommodate the new requirements.
• Identifying the developments needed for the process implementations from logistics at different manufacturing plants and distribution warehouses and discuss in the team.
• Analyze labeling application being used by the legacy systems to print special customer labels and worked on the solution to integrate the existing labeling solution (CLS) integrated with CodeSoft labeling application and implement in Oracle.
• Integrated the third-party shipping carrier applications like FedEx, UPS, Purolator with Oracle to automate and process the shipments for transportation and update the waybill and auto ship confirm.
• Oracle OAF Page Developments.
• Oracle Web ADI Developments.
• MWA Page developments.
• Worked on Stock locator conversions and Subinventory item Min-Max and Prime locator conversions for all the plants and warehouses from the legacy system.
• Worked on Warehouse setups and WMS rules like pick rules, put away rules, task assignment rules, Label assignment rules.
• Preparations for CRP and UAT testing, users for daily WMS activities and Post Go-Live support.

Environment: Oracle Apps 12.1.3

Software / Tools: SQL * Plus, Toad, MWA Application, Putty, Data Loader

Confidential

Responsibilities:

• Designed and developed programs to create move orders.
• Designed and developed reports and labels for the move.
• Developed Web ADI to load stock locators, Subinventory Min-Max and Prime locators, Item categories and item attribute updates.
• Create stock locators, setup travel paths, prime locations and others setups.
• Create Put away rules to move the stock to the appropriate locators using zones, ageing, prime locations and travel path locator attributes.

Environment: Oracle Apps 12.1.3

Software / Tools: SQL * Plus, Toad, MWA Application, Putty, Data Loader, Web ADI

Confidential

Responsibilities:

• Designed and developed Work Centre Efficiency Reporting System.
• Designed and developed different type of objects for Trade Fees Project.
• Developed WMS Lot Translate form for without using MWA application.
• As part of the application migration from R11 to R12, worked on development and customizations of many objects like forms, rdf reports, xml publisher reports, interfaces, pl/sql Packages, redesigning the objects as for the new business requirements.
• Worked on Customizations and development of workflows in OM and PO.
• Oracle service requests and patches testing.
• Gap analysis and involved in solution designs and documentations.

Environment: Oracle Apps 12.1.3, 11.5.10.2

Software / Tools: SQL * Plus, Forms & Reports 10g, Workflow Builder, Toad, MWA Application, SVN, Putty, Data Loader

Confidential

Responsibilities:

• Involved in designing and development of the project to process Trade Fees more structured and progressed easily to track the provisions posted to General Ledger, create Purchase Orders automatically, create credit memos or debit memos automatically, reverse the provisions automatically from the workbench etc.
• Involved in the business meetings and gather requirements.
• Developed oracle forms, reports, Interfaces and conversions.
• Did user s and documentations.

Environment: Oracle Apps 12.1.3, 11.5.10.2

Software / Tools: SQL * Plus, Forms & Reports 10g, Toad, SVN, Putty, Data Loader

Confidential

Responsibilities:

• Solution design of Work Centre Efficiency Reporting System.
• Developed OAF setup pages to create Departments, Work Centres, LabourCodes and associations.
• Developed Oracle Form to capture and report work centre efficiency.
• Developed work centre report for business signoff and efficiency monitoring.
• Create and Study MDS documents.
• Done the gap analysis and involved in solution designs and documentations.

Environment: Oracle Apps 12.1.3

Software / Tools: SQL * Plus, Forms & Reports 10g, Toad, Jdeveloper, SVN, Putty, Data Loaded

Confidential

Responsibilities:

• Involved in Oracle Applications R12 upgrade testing from 11.5.10.2.
• Involved with monitor support tickets, Oracle SRs, Patch upgrades, data fixes.
• Played an important role in resolving the tickets on WMS, Inventory, Order Management, Shipping, WCS issues and Enhancements on user request for better productivity. Interactions with the users whenever necessary.
• In parallel involved in the new project developments and implementations to fulfill business requirements.
• Developed Oracle forms to validate the serials of the mobile phones at the QA station to track and restrict the mobile handsets incorrectly shipping to the customers.
• Developed various OA Framework pages, Discoverer reports, oracle Alerts, Form Personalization’s as per the business requirement.
• Support Warehouse users with WMS Mobile transactions like Pack, Unpack, Pick, Load, Drop, Sub transfers, Inquiries, Put away, Cycle Counting and Physical counting. Warehouse Control Board Task management system, WMS Rules generation.
• Mobile Money Project enhancements.
• Done the gap analysis and involved in solution designs, documentations.

Environment: Oracle Apps 12.1.3, 11.5.10.2

Software / Tools: SQL * Plus, Forms & Reports 6i, Forms & Reports 10g, Toad, Jdeveloper, Discoverer, MWA Application, IBM RTC Tool, Putty, Data Loader

Confidential

Responsibilities:

• Developed OA Framework page to upload the items from csv file into the staging tables.
• Developed the packages to validate and import the items into the base tables.
• Prepared Test cases and documentation.
• Prepared the discoverer report to maintain items.
• Done the gap analysis and involved in solution designs, documentations.

Environment: Oracle Apps 12.1.3

Software / Tools: SQL * Plus, Toad, Jdeveloper, Discoverer, IBM RTC Tool, Putty

Confidential

Responsibilities:

• Business requirement gathering and designing.
• Prepared the design documents and BR100 setup documents for implementation.
• Involved in the solution testing and business presentations and user s.
• Involved with Oracle SR creations and monitoring.
• Developed packages to automate the process of delinking the capital projects from the inventory stock and unpack and packing from and into LPNs.
• Involved in define and setup of WMS enabled organizations, Sub inventory and Locators and inventory stock take process. Defined WMS Put away and label format Rules
• Developed interface for loading Item cross s.
• Developed the inter-org traveler report.
• Support Warehouse users with WMS Mobile transactions like Pack, Unpack, Pick, Load, Drop, Sub transfers, Inquiries, Put away, Cycle Counting and Physical counting, WMS Rules generation.

Environment: Oracle Apps 12.1.3

Software / Tools: SQL * Plus, Reports 10g, Toad, Discoverer, MWA Application, IBM RTC Tool, Putty, Data Loader

Confidential

Responsibilities:

• Involved in the business requirement gathering and project designing.
• Participated in client meetings.
• Prepared the design documents and BR100 setup documents for implementation.
• Involved in the solution testing and business presentations and user s.
• Setup of WMS organization, Sub inventory, Locators, Order management scheduling requirements, document set creation and Order types.
• Developed Web Services for sending Sales Order Details, receiving shipping information, sending invoice and delivery information and receiving RTT handover confirmation.
• Developed packages to validate the sales orders and shipping information and used WMS direct shipping concept and APIs to unpack, pack, pick confirmation, ship confirmation and invoice processing.
• Developed XML publisher reports for shipping manifest and Invoices.
• Developed Discoverer reports for user maintenance.
• Developed various Discoverer reports, Oracle Alerts, Registration of AOL objects.
• Support Warehouse users with WMS Mobile transactions like Pack, Unpack, Direct shipping, Sub transfers, Inquiries.
• Involved in full Oracle Order to Cash cycle.

Environment: Oracle Apps 11.5.10.2

Software / Tools: SQL * Plus, XML Publisher, Toad, Discoverer, MWA Application, IBM RTC Tool, Putty, Jdeveloper