Home

LakshmiKantha Reddy Salepela Edula - Senior Oracle EBS SCM Functional Consultant

[email protected]

Location: Cary, North Carolina, USA

Relocation: REMOTE

Visa: H1B

Lakshmi Salepela Summary: Over 17 years of experience in IT and on Oracle Cloud, Oracle E-Business Suite R12 & 11i modules like Oracle Order management, Advanced pricing, Oracle inventory and Oracle Purchasing Effectively delivering/implementing Oracle Distribution/Supply Chain Modules of Release R12, 11i e-Business suite, Oracle cloud. International experience of Independently Handling Customers onsite in Qatar, United Kingdom, EUROPE (Norway, Netherlands, Germany), Saudi Arabia and USA Worked in all phases of the Implementation cycle, which includes Requirements Gathering & Analysis, System Design and Development, Testing, and Implementation. Functionally lead the team developing various interfaces in Order management, Purchasing and Shipping and Advance pricing areas Experienced in authoring and reviewing the process documents like requirement analyses, functional design, setups, user manuals, unit test plans and status sheets. Expertise in interacting with channels/customers to understand their current technical environment, key business issues /drivers, and future technology requirements to provide solutions which suits their product definition Hands on experience in most of the project management process Excellent interpersonal skill, self-motivation, problem solving skill and quick adoption to new applications and technologies. Certified in Oracle procurement cloud and Order management cloud modules with functional knowledge. Technical Skills: Technologies: Oracle Application R12 &11i versions, Oracle Supply Chain Management Cloud Primary skills Oracle EBS: Oracle Order management, Oracle Advanced Pricing, Oracle Purchasing, Oracle inventory, Oracle e-commerce gateway, Bill of Materials Integrations with EBS: Order sources like EDI, Web services with Oracle EBS order management, CyberSource Credit card integration with Oracle EBS, Integration of fulfillment systems with Oracle EBS. Integrations with Oracle cloud: Integration of Oracle cloud/fusion order management with Oracle EBS, Integration of Oracle cloud/fusion order management with third party logistics Primary skills Oracle cloud: Order cloud management, Oracle Product data hub cloud, Oracle Supply Chain Execution Cloud Tools: Toad, MS Visio, MS Office, SQL Developer Programming Languages: SQL Other project tools: Jira, Service-Now Education: Bachelor of Technology from SVU College of engineering, 2004 Certifications: Oracle E-Business Suite R12.1 Supply Chain Management Certified Implementation Specialist: Order Management Oracle Procurement Cloud 2017 Certified Implementation Specialist Oracle Order Management Cloud 2017 Certified Implementation Specialist Achievements: Received the "VCS-Valuable Contribution Star award" By Senior Manager for Q2-2008 in Patni computer systems limited. Received the Dream team member Annual Award for the 2007 Year in Patni computer systems limited. Received Bravo Award in 2017 for excellent customer services from IBU HEAD in Tech Mahindra Several client appreciations emails Professional Experience: Client: Panduit Corp, Chicago, IL Duration: January 2023 to till date Role: Oracle Cloud SCM functional consultant Project: Panduit ERP Cloud Implementation Description: Panduit develops network, infrastructure and electric wiring solutions. Panduit crop is using Oracle EBS 11i as their current ERP system and implementing the oracle cloud as new ERP system. Responsibilities: Gathering requirements in inventory, order management and Oracle Supply Chain Execution Cloud Analyzed the requirements in order management and supply chain execution process and mapped the required to standard, custom processes Prepared the configuration sheet for Oracle cloud / fusion order management, Oracle inventory. Worked configuring the item organizations, inventory organizations, locations, sub inventories and locator structures, receiving parameters, shipping parameters, inter organization parameters, Facility shifts, workday pattern in cloud inventory. Configured the Cloud order management setups such as Order management Parameters, Order orchestration, Orchestration Process Assignment Rules, Processing Constraint, Pre transformation rules, Post transformation rules, Product transformation rules, Order Profiles, Order management EFF s ,Order Types , line types , Order Holds, Credit check process , Ship Confirm Rules, Shipping Parameters, Pick Wave Release Rules, Customer Pricing profiles ,Pricing segments, pricing strategies , price lists, Discounts , Shipping charge lists, pricing lookups, pricing matrixes, ATP rules , Sourcing rules and sourcing assignment sets Designed a detail level solution to interface the sales orders from Oracle cloud to oracle EBS and vice versa . Worked on Carrier integration to update the freight oracle cloud shipments and order lines Prepared Functional solution design Document (SDD) for various custom components like integrations, customer facing reports such as order acknowledgement, dispatch note, Bill of Lading, Proforma invoice Worked mapping EDI 850 Sales order inbound integration process which involves working with OIC team and staging the data in ATP database. Configured Applications Security, Job roles, Duty roles, and Privileges in oracle cloud instances Worked on Sales Order flow, Return, Dropship and Back-to-Back flows (Buy, Make & Transfer flows) Gathered the requirements and created function specification documents for BIP reports, OTBI reports, Sales order conversions using FBDI, integrations Worked on mapping of the Oracle BICC (Business intelligence cloud connector) PVO s to provide the data extract to external DWH (data warehouse ) Designed and configured the cloud pricing structure. Uploading of Sales order using FBDI as part of conversions. Uploading of Price lists using FBDI as part of conversions. Organized CRP (Conference Room Pilot), SIT and UAT Worked on bugs and glitches during internal testing phase of the cloud project. Tracking of bugs and monitoring the resolution progress on daily basis in oracle cloud project. Prepared the training material for user training for cloud project, Conducted user training or Oracle order management and supply chain execution flows on day-to-day activities of user in cloud order management. Environment: Oracle fusion SCM (Order management, Supply chain execution, PDH, Purchasing) Oracle Applications 11i modules (Order management, Advanced pricing, PO, INV). Client: Arrow electronics Denver, CO Duration: August 2022 to December 2022 Role: Oracle applications Advanced pricing consultant Project: Arrow electronics quotes and advanced pricing Description: Arrow electronics uses MWS (My works space) as quoting tool which is integrated with oracle. I have provided my enhancing the pricing solution built on MWS. Responsibilities: Debugging the pricing related issues in quoting tool(MWS) Supporting MWS to EBS integrations (Quote to Order) processes Identifying the performance issues with custom pricing engine built in MWS application and fixing with permanent solution Worked on enhancing the pricing solution in MWS application. Testing the quote to order scenarios. Validating the complex pricing scenarios. Documenting the solution for all re occurring incidents Maintaining the document repository Environment: Oracle Applications R12 modules (Order management, Advanced pricing, PO, INV). Client: Emerson, SIDNEY, OH Duration: April 2022 to July 2022 Role: Oracle applications Support Consultant Project: Emerson Commercial & Residential Solutions (COMRES) Oracle applications support Description: Emerson Commercial & Residential Solutions implemented Oracle applications R12 for its Distribution and manufacturing business in USA. I have provided customer support to their existing Oracle application modules like Oracle order management, Oracle purchasing, Oracle Inventory and other modules. Responsibilities: Supporting their daily issues in order management, shipping modules, inventory modules. Supporting Custom integrations processes Creating Oracle SR s for Bug s and data fixes Identifying the problems for reoccurring issues and fixing with permanent solution Worked on Enhancements. Supporting interfaces which are integrated with Order and fulfillment systems Identifying Root cause for Problems Monitoring and clearing of month end inventory, Shipping transaction related issues Documenting the solution for all re occurring incidents Maintaining the document repository Environment: Oracle Applications R12 modules (Order management, Advanced pricing, PO, INV). Client: Cummins Emission Solutions, Indianapolis, IN Duration: May 2021 to Feb 2022 Role: Principal consultant/SCM consultant Project: CES - IT Description: The objective of this project is to support and enrich the processes in oracle application R12 modules. Supporting Oracle cloud implementation project. Responsibilities: Conducted meetings with stakeholder to gather the EDI specific requirements Analyzed the EDI specific Requirements for new customers, suppliers Enabled the trading partner setups Enabled EDI locations for Customers& Suppliers, Code conversions as per requirements Tested the EDI cycle for new customers (EDI 856 outbound, EDI810 Outbound) and suppliers (EDI 830 outbound) Generated the EDI files from oracle EBS and coordinate with E-commerce team for analyzing the files Conducted UAT for business users and getting approvals to migrate the solution to Production environment. Logged the issues and work with the all-stake holders till the issues are resolved. Onboard the new customer EDI s, supplier EDI s upon successful completion of testing Worked on key documentation such as functional specification documents (MD50), test cases documents, production migration related documents. Worked on Order management, advanced pricing specific issues such as order import issues, Shipping documents printing, Picking and shipping issues and Pricing issues. Reviewed the requirements and provide solutions in order management, advanced pricing areas Monitored the Scheduled jobs and analyze the failures using Appworx application. Designed and tested of new Approx. chains to schedule the concurrent programs from Appworx Application. Designed several reprocessing mechanisms to process the failed data in few functional areas. Analyzed the requirements from ASCP team and performing necessary setups in Oracle EBS which including sourcing rules, IR ISO setups, profile options. Worked with OBIEE team to modify existing reports, creating new reports Maintained the status tracker of monthly releases and development progress. Provided the status update to leadership on development activities in Oracle SCM track Worked on Order management cloud implementation project. Environment: Oracle Applications R12modules (Oracle Ecommerce gateway, Order management, Advanced pricing, PO, INV) Client: GE Appliances, Louisville, KY Duration: October 2018 to February 2021 Role: Advanced Pricing Lead Consultant Project: GE Appliances Parts Order Ship Bill Project Description: The objective of this project is to Implement and support the oracle application R12 modules for Haier appliances. Several of the business processes are in their legacy ERP system and all the OSB process (ORDER SHIP BILL) will be mapped in Oracle ERP applications R12 Responsibilities: Requirements gathering in advanced Pricing work stream. Analyzed the requirements and captured the requirements in RD50. Identified FIT s and GAPs in advanced pricing Designed the detail level solution for Advanced pricing and prepared the BR3080 document Conducted design Review with business, architecture team. Prepared BR100 and performed in Pricing setups in Development, PRE-PRODUCTION and PRODUCTION instances. Extensively worked on Price lists, modifiers, qualifiers, Pricing attributes, Formulas with factors usage, Pricing security Prepared Functional specification documents for various custom pricing attributes, Files feeds to various systems, pricing service interfaces in advanced pricing. Develop custom solution to derive price for newly created items, existing items having procurement cost change using pricing formulas, dash board page (OA Page) to show derived prices for various customer groups, approval process to approve/Reject/modify the derived prices. Design the Price list file upload tool. Migrate the price lists, modifiers from legacy system to EBS R12. Responsible for System integration and coordinating with developers to develop the interfaces Responsible for Integration testing and Regression testing Responsible for logging defects\bugs in the JIRA system Maintaining the document repository Participated in Pre- CRP, CRP1, CPR2, SIT, UAT, Cutover activities, Go-live, Production support Document the solution for all re occurring incidents Coordinate with offshore developers and expedite the development to achieve project time lines Environment: Oracle Applications R12 modules (Order management, Advanced pricing, PO, INV) Oracle cloud (Order management, pricing) Client: GE Appliances, Louisville, KY Duration: December 2015 to October 2018 Role: SCM functional consultant/Support consultant Project: Oracle EBS OSB Customer services Description: GE appliances implemented Oracle applications R12 for its EDI customers and Local delivery business in USA. We have provided customer support to their existing Oracle application modules like Oracle order management, Oracle purchasing, Oracle Inventory, General Oracle receivables, Oracle payables and other modules. Responsibilities: Supporting daily issues in order management, shipping execution, Inventory and purchasing modules. Worked on problem management, Volume related issues, root cause analysis and providing permanent solutions to stabilize the system Provided solution to develop programs which automatically fixes the workflow, scheduling and issues Handled outages (planned and unplanned) from customer services Worked on sub project to Implement the Cybersource credit card integration with Oracle applications Closely worked with integration teams (SOA), other fulfillment systems Worked with Zenoss team to enable SQL alerts to identify the workflow issues, order status, scheduling failures, ASN failures on daily basis Provided training to new team members and helped them in onboarding to the customer support. Documented the solution for all re occurring incidents Maintained the document repository Tested of solutions in test environments and tracking testing defects. Analyzed all the repetitive issues and providing the permanent solutions for frequent issues Environment: Oracle Applications R12 modules (Order management, Advanced pricing, PO, INV). Client: Mazda Motors, Irvine, CA Duration: May 2015 to November 2015 Role: SCM Functional Consultant Project: Mazda motors GSCM project Description: Mazda motors implemented its parts business in three regions (USA, Canada and Mexico) from legacy application (PDS mainframe system) to next generation supply chain flatform based on Oracle EBS as part of Global supply chain management (GSCM) program. Mazda implemented best practice solutions with in supply chain management space to enable Mazda s GSCM program. Responsibilities: Worked on Fit gap analysis to identify various interfaces, Extensions and conversions Designed the custom solutions like Superseding item, Referral warehouse allocations, Claims, Accrual returns based on dealer accrual limits eligible in each quarter Designed the custom solution for order import process to EBS from dealer portals like EMDCS (USA), eMATE (Canada) and Mazda racer dealer portal. Designed the ASN inbound program through interface Provided solutions to Send\Receive various standard EDI document to its Suppliers and customers Design of interfaces from EBS to their Customs brokers for export sales Conducted CRP testing Co coordinated with developers and expediting the development to achieve project time lines Assigned tasks to offshore and coordinating with offshore through daily calls Maintained OF (Order fulfillment) track issues logs and scheduling business meetings with users to close the issues Tested case executions in test environments and tracking testing defects. Environment: Oracle Applications R12 modules (OM, Advanced pricing, PO, INV, I-supplier Portal) Client: Dell, Hyderabad, India Duration: April 2013 to April 2015 Role: SCM functional consultant Project: Dell Oracle ERP, Description: Dell Implemented Oracle applications R12 system as back-office system to record transactions in oracle database. As part of FSBO (Future state back office) program, we have implemented solution for USA and Project was executed in agile methodology. Responsibilities: Analyzed the AS-IS solution implemented for EMEA business and implemented same solution with additional requirements for USA region Drafted the MD 50's for custom objects such as item interfaces, Costing interface, Pricing interfaces (From upstream systems like FASTRACK, PDS, HARMONY to Oracle EBS R12). Handled Errors in Order import from GEDIS system to EBS and Order statuses flows from order fulfilment systems to Oracle EBS Provided unit test scripts for developers Executed System integration testing in SIT instance Coordinated with Developers, Business analysts of various fulfillment systems to ensure E2E testing. Demo to the stake holders Tested of solution in test environments and tracking testing defects. Ensured assigned user stories (Requirements) are completed within sprint (3-week duration) Environment: Oracle Applications R12 modules (Order management, Advanced pricing, PO, INV). Client: Hydratight, UK Duration: April 2010 to March 2013 Role: SCM Functional Consultant/Sr. Consultant Project: Hydratight oracle applications implementation Description: Hydratight has provided excellent bolted joint solutions and machining services to the Power Generation, Oil and Gas, Industrial and Aero industries. We have implemented oracle applications for its UK, APAC region Responsibilities: Effectively mapped requirements with seeded oracle functionality Designed the custom components where ever required. Prepared BR-100 document for PO, OM modules Responsible for designing of custom objects, interfaces and custom process in distribution modules. Implemented various order cycles like normal sales, internal sales, Inter-company sales, Drop shipments, Rental solution Prepareed Functional specification documents for few custom objects and for discoverer reports, XML reports Worked on Data migration, Cleaning and validating data. Setting up related setup Functional testing and prepared test cases for various scenarios in Order management, purchasing and for custom objects, interfaces. Identified SOD/SOX issues and resolved. Prepared of transition plan and risk management Provided On-site post production support in various sites in UK, EUROPE, Middle east Environment: Oracle Applications 11.5.10.2 modules: Inventory, PO, Order Management modules Client: Dynea Chemicals, Hyderabad (Client is located in UK & Europe) Duration: March 2009 to April 2010 Role: SCM Functional Consultant Project: Dynea Europe Oracle AMS Project Description: Dynea Chemicals engaged in to Manufacturing distribution of industrial adhesive systems. We provide the support to the existing Oracle application modules,. Business has roll out more branches across Europe. Responsibilities: Clear the month end pending transactions. Proactively assisted, coached, and mentored other engagement team members on issues which they encountered in the design and implementation of the solution. Participated in weekly status calls with users and onsite coordinators. Resolved issues by providing Functional or technical resolution Functional Testing of custom objects like Oracle discoverer reports, interfaces and XML reports Prepared functional specification documents for new enhancements Maintained distribution documents like (Bill of lading, Proforma, customer proforma, DGN and other shipping documents) Managing project risks, issues, assumptions and dependencies Environment: Oracle Applications 11.5.10.2 modules OPM Inv, PO, OM, Formulator, Production supervisor Client: Dynea Chemicals, Hyderabad, India (Client is located in UK & Europe) Duration: November 2008 to March 2009 Role: SCM Functional Consultant Project: Dynea Europe Oracle Implementation Project Description: Dynea Chemicals engaged in to Manufacturing distribution of industrial adhesive systems. We are implementing oracle applications in few European sites and providing support to the existing Oracle application modules Responsibilities: Prepared BR-100 document for PO, OM modules Prepared user manual with screen shots for better understanding Prepared TE40 documents for all scenarios in Order management and purchasing. Responsible for designing of custom objects, interfaces and custom process in distribution modules. Implemented various order cycles like normal sales, consignment sales, internal sales, intercompany sales, Drop shipments Prepared Functional specification documents for few custom objects and for discoverer reports, XML reports Worked on data migration, Cleaning and validating data. Setting up related setup Performed functional testing and prepared the test cases for various scenarios in Order management, purchasing and for custom objects, interfaces. Testing of interfaces like weigh bridge, Consafe barcode solution, Merkur integration Environment: Oracle Applications 11.5.10.2 modules OPM Inv, PO, OM, Formulator, Production supervisor Client: Gexpro, Mumbai, India (Client is located in Ireland) Duration: March 2008 to November 2008 Role: SCM Functional Consultant/Sr. Engineer (Software) Project: GEXPRO Oracle Applications Support Description: GEXPRO Ireland engaged in to distribution of electrical equipment. We provide the support to the existing Oracle application modules (Order Management, Purchasing, Parables, Receivables, Inventory, General Ledger, BOM, WIP, and CST). Business has roll out more branches across Ireland. It is integrated with Rexel Oracle Instance. Responsibilities: Co-Coordinated team members and Sending weekly status sheets to Onsite Co-Coordinator as well as users. Handled Daily Tickets related to various user problems in INV, PO, OM, AR and AP Modules. Cleared the pending month end transactions. Attended weekly status calls with users and on-site coordinator. Resolved issues by providing Functional or technical resolution Environment: Oracle Applications 11.5.10.2 modules INV, PO, OM, AP, and AR Client: Gexpro Global, Mumbai, India (Client is located in Ireland, Italy, Hungary, China) Duration: June 2007 to March 2008 Role: SCM Functional Consultant/Sr.Engineer (Software) Project: GEXPRO Global rehost& transition Project Description: GEXPRO (Formerly known as GE Supply). It is basically oracle apps testing project. Rexel Acquired GE Supply in few countries (Ireland, Italy, Hungary, china). Still Rexel was using GE Servers. Now they are moving to maintain own Servers by cloning database. Few entities data have been deleted. So, we tested various process, reports, custom objects functionally using QTP tool. Responsibilities: Prepared TE40 documents for all scenarios in Order management and inventory. Tested the new instances functionality Prepared QTP Test Scripts for Automation testing. Conducted Knowledge session for Testing people (QTP Testers) on Oracle applications. Technical testing after slicing the data in database Environment: Oracle Apps 11i(INV/PO/OM/BOM/WIP/AP/AR/GL) Client: JDSU, Mumbai, India Duration: March 2007 to May 2007 Role: SCM Functional Consultant Project: JDSU (Production Support) Description: JDSU is the worldwide leading provider of broadband test & measurement solutions and optical products for communications, commercial and consumer markets. The Company offers test and measurement systems and services for telecommunications service providers, cable operators, and network equipment manufacturers. In addition, the Company offers components, modules and subsystems for optical communication, display, security, medical/environmental instrumentation, decorative, aerospace and defense applications. Oracle Corporation implemented oracle application in JDSU. Patni computer systems providing support to JDS Uni-phase on behalf of Oracle Corporation. Responsibilities: Handled daily tickets related to various user problems in INV, PO, OM, BOM, and WIP Modules. Received calls from customers and creating service requests through i-support and tele support on behalf of Oracle Corp. Resolved issues by providing functional or technical Monitored service requests and updating status to oracle shift leads through shift hand over call at the end of shifts. Resolved Month End Closing related issues. Environment: Oracle Applications 11.5.10.2 modules INV PO, OM, BOM, WIP, MRP Client: Qatar Building Company, Doha, Qatar Duration: November 2006 to February 2007 Role: SCM Functional Consultant Project: QBC Implementation (Project) Keywords: information technology golang purchase order microsoft Arkansas California Colorado Illinois Kentucky Maryland Ohio