SUMMARY:

• Overall 11.3 years of work experience and 10.7 years of IT experience in Oracle Applications in various modules stated WMS, Oracle Inventory, Order Management, Purchasing, BOM, AP, AR, GL, WCS which also includes technically in development of Interfaces, OA Framework pages, Discoverer Reports, XML Reports, Oracle Reports, Oracle Forms, Workflows, PL/SQL Packages, Form customizations and Personalization, developing Web Services and Production Support.
• More than 7 years of onsite warehouse experience worked functionally and technically on Warehouse Management System, Inventory, Order Management and Shipping modules.
• Functional responsibilities: Requirement gathering, functional gap analysis, Application design, Configuration, Test script generation, end users and production support.
• Technical activities: Interface with users, identifying functional and technical gaps, estimating work, solution designing, programming, documentation and production support.
• Good knowledge on Oracle E - Business Suite technical architecture and deployment processes includes AOL setups.
• Well versed with Oracle advanced concepts.
• Having knowledge on Oracle SOA and ADF.
• Oracle OCA Certified.

TECHNICAL SKILLS:

ERP Package:: Oracle E-Business Suite

Modules: WMS, WCS, Oracle Inventory, Order Management, Oracle Purchasing, BOM, AR, AP and OPM.

Programming Languages: SQL, PL/SQL, Java, C, C++

Database: Oracle 7i,8i,9i,10g

Operating System: Windows, Unix

GUI: Oracle Forms, Oracle Reports, OA Framework

Tools: Toad, SQL * Plus, Workflow Builder, JDeveloper, Discoverer, MWA Application, PVCS, Confidential RTC Tool, Putty, Data Loader

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Scoping of project requirements and gap analysis.
• Worked with the team in streamlining the business processes to accommodate the new requirements.
• Identifying the developments needed for the process implementations from logistics and discuss in the team.
• Analyze legacy labeling systems and accommodate with new labeling solution by integrating with CodeSoft Application.
• Integrated the third party shipping carriers like FedEx, UPS, Purolator with Oracle.
• Data analysis and validations required for conversion from legacy systems.
• Warehouse rules generation and implementations.
• Development activities, user s and documentation.

Environment: Oracle Apps 12.1.3 Software / ToolsSQL * 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.
• 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.

Environment: Oracle Apps 12.1.3

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

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

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

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

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

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.
• 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

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

Confidential

Responsibilities:

• Developed OA Framework pages to upload the Forecast entries and Demand class data from csv file into staging tables.
• Developed packages to validate and call the API to load the forecast entries in to buckets and to create flex fields.
• Developed the RDF report to view error records.
• Developed discoverer reports to validate setups and allocation rules on the Customer and Items.
• Involved in the solution testing and documentation.
• Registration of AOL objects.

Environment: Oracle 11.5.10.2

Confidential

Responsibilities:

• Analysis on functional Specifications and design the Technical Specifications.
• Developed a custom form named WMS on-hand Quantity Lookup Form.
• Developed an XML report named Skid content report to report the order shipment details similar to pick slip report.
• Creating Oracle Alerts based on the requirements.
• Technical documentation, MD070.

Environment: Oracle Apps 11.5.10

Confidential

Responsibilities:

• Monitor tickets through remedy.
• Played an important role in resolving the tickets on WMS, Inventory,
• Order Management, Shipping issues and Enhancements on user request for better productivity.
• Prepare status reports on a weekly basis.
• Interactions with the users whenever necessary.
• Developed PL/SQL package (Item End of Life Cycle program) to track all the inventory items and change the item status based on user validations.
• Developed Interface program to extract total usage rates on Finished Goods department wise and developed a host program to FTP the file to See- Confidential file server.
• Developed two new Reports in BOM, developed shell script to send the report output to the mailing list and done many report customizations.
• Developed Forms, Form customizations and Personalization’s as per the user requirements.
• Maintenance and technical documentation.

Environment: Oracle Apps 11.5.10

Confidential

Responsibilities:

• Analysis on functional Specifications and design the Technical Specifications.
• Developed pl/sql packages to handle gift wrap items and interface to shop floor.
• Done enhancements in order cycle codes at order import, pick release, shipping, and RMA processing.
• Developed two new reports and a host program to send the report output to the email list.
• Developed a form to see the fixed SKU’s with its engraved and gift-wrap items.
• Developed UTP and did Unit testing, Integration testing.
• Maintenance and technical documentation, MD070.

Environment: Oracle Apps 11.5.9

Confidential

Responsibilities:

• Worked on designing, programming, unit and integration testing of custom components.
• Support the automation team in functional flows and fed with functional inputs.
• Run and execute the Test cases.
• Check for the bugs and flow corrections; fix and implement them if any in test instances and given to automation team.

Environment: Oracle Apps 11.5.9

Confidential

Responsibilities:

• Analyzed and Studied functional Specifications.
• Designed and enhanced the feature.
• Prepared user test scripts for different scenarios.
• Test Execution of the Test steps to ensure the expected behavior works fine for Order to Cash flow and inventory transactions.
• Bugs/Defects logging for any technical misbehavior in O2C Flow & tracking of the same to get fixed.
• Prepare status reports on a weekly basis.
• Customer interactions whenever necessary.

Environment: Oracle Apps 11.5.9