Home

Jagadeeshwar - Oracle Cloud ERP/SCM/OM/AR

[email protected]

Location: Sugar Land, Texas, USA

Relocation: Open

Visa: H1B

Summary 15 years of experience in IT consulting for the service industry. Widely experienced in Software Analysis, Design, Development, Implementation, and Testing of Object-Oriented Applications and Web-based ERP Applications EBS using oracle sql/plsql, forms, workflow and webservices Worked extensively in the area Oracle Applications EBS 11i, R12, Cloud Fusion and involved in analysis, design, development and implementation of business applications and user training Worked on financial modules: GL, AR, AP, CM, FA. Skilled in financial accounting and reporting Experience in SCM, Oracle Discrete Manufacturing, ASCP, BOM, WIP, Cost Management, Inventory. Experience in oracle fusion Cloud reporting, Oracle Fusion Cloud interfaces Worked on AP, AR, FA, Projects Costing and Billing, GL, PO and System Administration. Experience in various oracle application SCM modules, GL, OM, WMS, AR, INV, PO, GL, AP, BOM, AOL and SYSADMIN. Involved in release management of whole development and customization cycle, version control of all the codes using ACME Proficient in writing stored procedures, packages using PL/SQL, SQL. SQL and PLSQL experience 12 years UNIX shell scripting 5 years JAVA Script 4 years Having good knowledge on version control tool like WINSCP, Putty and Toad Excellent experience in developing and customizing the Interfaces. Experience in creation of executable, concurrent programs, parameters and value set in Oracle application using AOL. Analysis of the specifications provided by the clients. Developed PL/SQL packages, Procedures, and functions. Registering Custom Applications, Concurrent Programs, Request Set Tables Defining Request Groups & Menu. Development of interfaces and conversion like Items Import interface and Supplier Conversion. Involved in Development of AOL objects. Developed Control files to load data into tables. Experience on Data Migration & Data Conversions. Knowledge of using Oracle supplied APIs. Quote to Cash experience 12years O2C Cycle experience 10 years P2P Cycle experience 3 years COGS & IB (Install base Management) Module experience 2 years Oracle R12 Version (12.1.3) experience 10 years Oracle 11i Version experience (11.5.10.2) 4 years Involved in GST Implementation project. Involved in Oracle Cloud Fusion Implementation Project Involved in diagnosing and resolving technical, functional related problems. Strong expertise in development of web-based applications using Python, REST Webservices Strong experience in data engineering, Database designs, agile methodologies, coding, testing of In the role of a Business Analyst, assisted clients and customers in defining business needs, evaluation alternative solutions, made recommendations and helped in implementing approved suggestions Technical Skills: Programming Languages SQL, PL/SQL, JAVA Application/Web Servers Apache Tomcat IDEs Jdeveloper, Eclipse Web technologies JSP, JavaScript, jQuery, XML, CSS, JSON Web Services SOAP, RESTful Methodologies Agile, Waterfall Modeling Tools Visual Studio, Rational Rose Database Servers Oracle 8i/9i/10g/12c, MySQL Version Control CVS, SVN, Platforms Windows 2000/98/95/ Windows 7 Professional, UNIX Oracle tools Forms, Workflow Report Tools BI Publisher Education: Master Degree: Master of Business Administration (MBA) from Kakatiya University, 2002, India. Certifications: PGDCA from UICT DIT from PACE Oracle configurator, iStore training from Oracle Corp. Professional Experience Global Pay - Inspyrus Mar 2023 to till Date Senior Product Consultant Worked on Oracle Cloud and customization of the system in Oracle Applications SCM modules (Oracle Manufacturing (OM, WMS), Invenotry, and configurator) which cover design, development, testing, data migration, implementation and support phases. I have also worked/involved in implementation in many countries. Activity Performed: Analyzed client requirements to deliver tailored solutions aligning with business objectives. Customized code to implement functional requirements and deployed product updates using ad scripts. Conducted comprehensive end-to-end testing to ensure robust and error-free functionality across all scenarios. Designed and implemented solutions for diverse on-premise and cloud-based customers with varying ERP systems, including J.D. Edwards E-Business Suite and PeopleSoft. Utilized JIRA for seamless tracking from requirement gathering to production support. Maintained and managed code repositories using GitHub, ensuring version control and efficient collaboration. Delivered presentations to customers, showcasing implementation processes and introducing new features. Monitored production servers to ensure the stability of high-value transactions, performing tasks such as database purging, application server recycling, and certificate installation. Responsibilities: Analyzed and designed project requirements to ensure alignment with business objectives. Developed BPEL processes, both synchronous and asynchronous, to meet diverse project needs. Implemented Database Adapters to facilitate seamless integration with databases. Resolved technical issues within BPEL composites to ensure smooth functionality. Conducted comprehensive end-to-end testing for all project scenarios to maintain quality standards. Migrated code across development (DEV), quality assurance (QA), and user acceptance testing (UAT) environments. Collaborated with the QA team to test all scenarios and ensure defect-free delivery. Provided support to test users during UAT, addressing any issues and ensuring a seamless testing experience. National Cash Register Corporation US, Atlanta Aug 2006 to Mar 2023 Solution Owner NCR Corporation, formed in 1884, is the world s largest manufacturer of Cash registers and ATMs, NCR has a strong presence in providing software, hardware and solutions support specifically in ATMs in around 100 countries worldwide with over 60% global market share in ATM market. NCR has one of the largest Oracle Applications installed base globally with over 40 modules implemented and over 25000 users. Worked as a Senior Solution Owner for Oracle Applications EBS 11i, R12 and Cloud Fusion. Responsible for the customization of the system in Oracle Applications SCM modules (Oracle Manufacturing (OM, WMS), AR, and configurator) which cover design, development, testing, data migration, implementation and support phases. I have also worked/involved in implementation in many countries. Responsibilities: Interacting and understanding the client requirements concerning the customization team. Being a part of Interface team, worked closely with the business users, technical & functional team. Version control using ACME. Analysis of the specifications provided by the business user. To amend the existing code as per the requirements by the business. Tuning the NCR customized oracle objects for improve the performance of the database. Involved in business architecture efforts to address module needs and requirements. Designed and implemented MDM (Master Data Management) processes, offering guidance for complex model and option classes. Managed as-built configurations. Worked on modules including, Advanced Supply Chain Planning (ASCP), Inventory, Work-in-Process (WIP), Warehouse Management System (WMS), Manufacturing Execution, Quality, and Facilitated team activities for cross-track design and collaboration. Designed conversions, interfaces, extensions, and reports to enhance system functionality. Worked on OIC utilities for Fusion ERP integration Worked on financial modules, including General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), and Cash Management (CM), FA with expertise in financial accounting and reporting. Activity Performed: Development and Customization Activities in NCR: Provided the Automation to add the freight charge (modifier) which comes from third party after calculation using the standard oracle APIs. Provided the new custom Hold definitions, Quick Codes and functionality in Oracle SCM Order Management for achievement of the business requirement. Provided ability to perform oracle standard processes receiving, reservation, picks release, pick confirm and shipment of sales order(s) automatically. Provided the Automation of SCM sales order lines through the invoice interface activity Provided the functionality to Booked/Cancel the sales order lines automatically Provided Order management attachment (Modifiers) functionality Provided Defaulting Rules in Oracle Order Management Customized project (seiban) number Provided Drop Ship Automation for sales order in Oracle Order Management. Provided the new custom profile options for the application Performed validation for control the Order Enter, Scheduling Order line(s) by creating new processing constraints in Oracle Order Management, configuration creation on base model, Order Copy Method Functionality using Oracle HOOKS, RMA Functionality Provided the user friendly functionality to show the sales order line(s) status using CUSTOM.pll Provided the facility to capture the information by creating new descriptive flex fields (DFF s) for the business. NCR Workflow changes: Developed workflow for sending the different email notification to the CIS on the sales order in the different phases of sales order process. Provided Apply/Release Hold Automation in Order Management through workflow AOL Sys Admin Tasks in NCR: Created concurrent program executable, definition Created different value sets as per the requirement Created request groups. Created different responsibilities. Created users in oracle applications with particular responsibility. Added reports definitions, concurrent programs to particular request group. Other Activities in NCR: Gradually involved in Technical Assistance Request (TAR) with Involved in Internal training sessions within organization on ERP - Oracle application EBS 11i, SCM, Order Management, AR, AO, GL, Configurator, performance tuning, Advance PL/SQL and Organization business flow Project Details Project #18 Oracle Fusion Cloud Implementation Worked on customized objects identification for retro fitment. Worked on OIC integration oracle cloud AR to ERP Onprem R12 application Implementation of OM and AR cloud functionality Implementation of quote to cash cloud functionality Modified standard objects for business functionality. Worked on different modules on OIC Project #17 Oracle Cloud Fusion Reporting: Sales Order Report, Invoice Log Report Role : Technical and Functional Lead Environment: Oracle Cloud Fusion Key Project Details: Created few BI Publisher Reports in Oracle Cloud Fusion Responsibilities:- Created few custom cloud reports in Oracle Cloud using BI Publisher Cloud Fusion Reports and exposing the reports using eText methods. Learnt the Cloud TRM. Worked on OIC Project #16 ISG Webservices for Realtime Order Creation in ERP Role: Technical and Functional Lead Environment: Oracle Apps, PLSQL, JAVA REST Web Services Project Details: To interface Orders in ERP from customer portal app and respond them back with the ERP Order number using REST web services with a SLA of 5 seconds Project #15 As a Service Program: ServiceNow Integration Role: Technical and Functional Lead Environment: Oracle Apps, PLSQL, JAVA, REST Web Services Responsibilities: To gather requirements, Work with Business Analysts/Directors, Working as a Lead Developer, Tester Project Details: NCR is heading towards Service based solutions, so the project was to integrate Service enabled SW/HW products to customers on Rent, so we need to build an interface that can support Rental Order Types Project #14 Walmart EDI to OM Role: Technical and Functional Lead Environment: Oracle Apps, PLSQL, UNIX, E-Commerce Gateway Responsibilities: Created Custom Package, shell scripts, FTS setups, XML Publisher reports to support this requirement. Project Details: Walmart customer will send the file via EDI and we need to import Orders in ERP using Oracle 850 POI with all custom enrichments. Project #13 DOES Replacement with QB Role : Technical and Functional Lead Environment : Oracle Apps, PLSQL, Unix, SOAP web services Details : An interface between ERP and interfacing application QB through Oracle SOA Responsibilities: Created Synchronous Web Service in ERP for interacting systems through SOUP. Developed an interface which was used to stage the data sent from QB Application. Validating the data against ERP and then inserting the data into iface tables and creating the order. Doing Custom post validations and sending the acknowledgement back to QB via web service. Project #12 Automate Down count of Master/Site Order Process Role: Technical and Functional Lead Environment: Oracle Apps, PLSQL Details : Automated the manual process of down counting the Master Order once a site Order is created Responsibilities: Played the role of BA and gathered/documented the requirements. Worked as a developer to automate this process. Used Advanced PL/SQL techniques for performance tuning. Implemented the complex functionality of down counting the SW or HW lines as per Standard Oracle Functionality and Business Requirements. Created XML reports for user. Created end to end project plan for implementation Project #11 Product MDM Role : Technical and Functional Lead Environment : Oracle Apps, PLSQL Details : Item Structure/Family changes due to which all the interfacing applications need to accommodate the change. Responsibilities: Worked as a BA/developer to figure out all the changes that needs to be made to accommodate the changes done on the item structure. Project #10 PSA to OM Interface using Web Services Role : Technical and Functional Lead Environment : Oracle Apps, PLSQL, UNIX, JAVA SOAP web services Details : An interface between ERP and interfacing application PSA through Oracle SOA Responsibilities: Created Synchronous Web Service in ERP for interacting systems through SOUP. Developed an interface which was used to stage the data sent from PSA application and creating Orders in ERP using Standard Oracle Order import functionality and sending back the status. Project #9 R12 Implementation Worked on customized objects identification for retro fitment. Implementation of R12 functionality Modified standard objects for business functionality. Project #8 Argentina Localization Roles and Responsibilities: Modified standard order management functionality to apply NCR localization and taxation customizations. Modified defaulting rules to default DFF values based on item for validate taxation Modified the existing order process functionality by modifying existing programs. Modified standard reports for apply NCR customizations. Created new reports for include new localization changes which are provided by oracle. Project #7 DEMANTRA Project Roles and Responsibilities: Developed new order types and modified/created NCR workflows for process plant orders. Created new defaulting rules to default sales order form attributes. Developed new processing constraints on update/delete/create the sales orders to restrict the user. Created new attachments. Created new responsibilities. Modified the existing order process functionality by modifying existing programs. Project #6 WOT (Web Ordering Tool) to OM Interface Roles and Responsibilities: Developed WOT (Web Ordering Tool) to OM interface to extract data from WOT and performs validation and translations on the data, to get it aligned for loading into Oracle's tables. This interface will retrieve only NON-ATO and ATO Lead Unit items from WOT and perform validations/conversions to build the entire ATO configuration before importing into OM. Developed NCR WOT to OM interface for apply sales credits to the salesperson. Included changes to send notifications once order is imported to ERP. Project #5 OM Russia, COGS Roles and Responsibilities: Developed new forms for NCR Russia Implementation. Developed NCR Russia Line Level Recognition (AR) Developed a new functionality of Line Level. Developed a new form for recovery of material burden (NCR Material Burden Information) in case of shipments and receipts. NCR Russia Line Level Recognition (AR) Developed a new functionality of Line Level recognition for Russia AR Invoices replacing the Milestone Recognition functionality. Project # 4 Accounting Validation In NCR only Marketing orders checked to verify the accounting string by the concurrent program. The program will record which lines have valid accounting strings and which ones have errors. If any invalid accounting strings are found, a notification email will be sent to the CIS listed on the order. In addition to the program, a new hold and several database triggers will be used to ensure that only lines with valid accounting strings will be sent to AR for invoicing Roles and Responsibilities: Created new hold called Accounting validation hold and applied this hold to sales order Created new program to validate accounting string while booking the sale order and if it Modified custom_oexoeord.pll to validate the accounting string again before invoicing, if accounting string is invalid then not process for invoicing. If it is valid then release the Accounting validation hold and process for invoicing. Project #3 iStore Roles and Responsibilities: Created new program to validate the sales order header and line attributes before order imported into ERP. Created new program to automate the booking functionality. Used process order API to book the iStore sales order periodically. In program - validated the sales credits based on NCR sales person. Project #2 ICON Replacement Roles and Responsibilities: Developed new order types and modified/created workflows for process plant orders. Developed new processing constraints on update/delete/create the sales orders to restrict the user. Created new attachments. Created new responsibilities. Modified the existing order process functionality by modifying existing programs. Project #1 Configurator Roles and Responsibilities: Worked on Oracle Configurator Developer, Rule Creation, Publishing Models and Custom Mass Retranslation of Orders on the basis to the new Configurator Rules. Modified configurator interface to order management for validate item rules. Customized configurator hold application for NCR business requirements. Worked on customization of Freight application to a sales order line after shipping for Drop Ship Orders. Worked on Defaulting Rules and Processing Constraints. Worked on Form Customization using Form Personalization and Worked on creation of Menus, Responsibilities, Security Rules, Profiles, DFF, ValueSet and Concurrent Request. Worked on the Multi-Org Setups wherein created Operating Unit, Legal Entity and Inventory. Performed setups for new countries Live: Determination of the implementation model for a new country and working with the business users and development teams to accumulate the necessary information for new setups. Keywords: quality analyst business analyst business intelligence active directory information technology purchase order procedural language Arkansas