Satish Upadhyayula

• Managing RICE log and Dashboards for Reports, Extensions, Integrations and Conversions
• Running regular SCRUM Meetings to review Reports, Extensions, Integrations and Conversions
• Actively involved in end-to-end process for Procurement/Order Management/Price List/Planning conversions using Oracle FBDI process
• Built OTBI and Data Models for various reports
• Actively involved in RICE integrations/Extensions/Conversions/Reports requirements/issues/design meetings for Order Management/Procurement/Inventory Work Streams
• Scheduled meetings between/cross-functional teams to address/resolve/progress RICE items

• Company Overview: NCH Corporation has outsourced its IT Services to Tech Mahindra and in the process I and my team became employees of Tech Mahindra
• Building KT Session topics, tracking and monitoring KT Sessions, Reverse KT Sessions, KT Session Recordings, and Reverse KT Sign Offs etc
• Working with SMO (Service Management Office) on understanding existing ITIL, PM software Tools and building processes and SOPs around managing delivery activities as per SLA agreements
• Reviewing daily, weekly, monthly, quarterly from metrics from ITIL systems for effective monitoring of incidents, service requests and changes to peripheral systems
• Building offshore technical team: Which includes recruitment, onboarding, mentoring, monitoring, target setting and performance assessment
• In the process identify resources skills and map them in right areas
• Work closely with offshore team and enable them to delivery projects and production support tickets
• Built processes and guidelines around (Development Guidelines, Migration Process, CEMLIS Version Control management process, Status monitoring processes etc
• Defined roles and responsibilities for Leads and individual contributors)
• Active participation in 'Change Control Board' and 'Demand Review Board Meetings'
• Responsible for Release Management activities: Migration of CEMLIS to UAT, Non Prod, Production instances, remigration of CEMLIS after refresh of Instances
• Provide weekly reporting on IT Services and Projects to Oracle Tower Lead
• Make recommendations for Service Improvement Plans and ensure actions are followed through to completion in a timely manner
• Managing CEMLIS while moving EBS Applications, Oracle SOA Servers and Oracle Product Data Hub Servers from one OCI tenancy to another OCI tenancy
• Leading Oracle SOA 12C upgrade and upgrade artifacts and composites from Oracle SOA 11i
• NCH Corporation has outsourced its IT Services to Tech Mahindra and in the process I and my team became employees of Tech Mahindra

• As an Applications Development Manager, led a team of Architects, Team Leads, Developers and consultants and developers that handled the various facets of an Oracle EBS Applications KTLO, implementation and upgrades
• Constantly identified and recruited new talent while keeping current team engaged and motivated
• Configured, implemented and managed Azure DevOps for Oracle ERP Applications R12 Upgrade projects (R11i to R12.2.8 and R12.1.3 to R12.2.8) by building custom reports, charts and dashboards to steering committee meetings
• Lead large Technical Teams (Onsite/Offshore) in successful delivery of Oracle ERP applications R12 upgrade projects (R11i to R12.2.8 and R12.1.3 to R12.2.8)
• Technical team that has retrofitted 8000 CEMLIS during two upgrades within project constraints (Cost, Time and Quality)
• Success delivery of migrating Oracle EBS Applications, SOA, Product Data Hub servers from private cloud hosting servers to Oracle Cloud Infrastructure
• Successful delivery of migrating Oracle EBS Application from on premise to private cloud
• Participated in 'Change Control Board': Reviewing Changes done in Production System, review medium to large impact of proposed changes, review of scheduled and on-demand refresh of instances
• Participated in 'Demand Review Board': Reviewing projects ready for execution, scoping of projects, efforts estimations for projects, resource allocation on the projects etc
• Built new module from scratch with in EBS Applications following Oracle Development guidelines
• Lead the technical team that Implemented and delivered around 50 plus projects (Small to Medium) level projects every year
• Managed Oracle Technical Team that has built integration between Oracle EBS Applications and peripheral systems like Vertex, Precision (3rd Party Transportation System), Sales Force, Global Order Entry Web Application (.Net Application), Field Service Application, Oracle Product Data Hub using Oracle FMW, Dell Boomi, DB Link, Business Events, PLSQL APIs with Ref Cursors etc
• Managed Oracle Technical Team that has built Automation Anywhere RPA BOT Processes
• Managed Oracle Technical Team that has built application using Oracle APEX (Time Off Applications for salaried employees, Migration Tool for CEMLIS, Use Case evaluation for RPA, Outside ERP scheduling application etc.)
• Provide day-to-day tactical support to delivery teams while engaging IT management at a strategic level
• Projected thought leadership, technical/functional expertise and was actively involved in Planning, Priority Setting, instructing, monitoring, promoting team development and managing multiple efforts simultaneously
• Worked closely with Delivery Managers and production support team on critical incidents, coordinating with resolution parties with subject matter experts

• Analysis and estimation of RICE items for R12 Project Implementations.
• Analyze business requirements, recommend technical solutions and provide technical Design documents for custom solutions.
• Suggest approach for the Conversions, Upgrade of Oracle Apps & Technology related decisions.
• R12 Upgrade projects, responsible for analyzing custom code and provide estimation and upgrade R11i custom objects to work in R12.
• Designed and built design custom solution or created special items from quick Sales Orders.
• Build WEB ADI solutions for Price List, Pricing Modifiers, AR Receipts, AP Invoices.
• Built report templates using Oracle BI publisher.
• Upgraded R11i Custom WF processes.

• Collaborated with clients to develop customized architectural solutions, meeting their unique needs and preferences.
• Assist in Requirement Scoping, Resource Management and Project Planning.
• Attended team meetings to resolve technical and project issues and review project schedules.
• Responsible for maintaining and enhancing coding guidelines and development process guidelines.
• Design and architect the custom solutions, project planning and provide production support.

Ø Sales Contract:

• As part of the Design Build Team (DBT), involved in gathering business requirements, identifying gaps, prototyping the new solution , designing and development of the application..
• Designed and coordinated all the data conversion development and testing tasks.
• Used Oracle Development standards for developing the whole application.
• Designed Health Check Reports and Discrepancy Reports
• Built flexible and scalable solution for commission calculation functions with in Sales Contract Module.
• Defined/Created entities like Contract Type and Contract Categories for reporting purpose.
• Schema Design for the custom table to store the shipment, billing schedules, expenses, actual and invoice details

Order Management:

• Sales Order Interface : Designed and developed Sales Order Interface functionality. Sales Orders are loaded into custom tables from different sources like . STAR, DRM, SCORE, CHEMPAX. External Sales Orders are then validated, successfully validated Orders are imported by using OM Order Import public API. Failed orders can be viewed and corrected from custom UI and can be imported again once the orders goes through validations successfully
• Unit Pricing enhancements. Customized Sales Order form to handle dual UOM and dual unit pricings, one in Price List UOM and another in Order Qty UOM. It was a challenge to make sure that pricing in both the units was always in right proportion as our custom code was called on top of Oracle Seeded Functionality.
• NOPS Interface : Sales Orders are created in Oracle OM module, but actual shipping is be done in legacy/Oracle OM. Booked Orders are exported to NOPS system through extraction of Sales Order information. SO orders are processed in NOPS system, then they are imported into Oracle OM module. To build this functionality many Tables/views/PLSQL/Forms/reports are built. OM workflow was customized to support both Oracle Standard flow and OM/NOPS interface flow.
• Sales rep Contention Extension: This extension will evaluate conditions for Salesrep Contention upon booking of a Sales Order. Read only access form for viewing ‘Salesrep Contention’ details is provided from ‘Sales Order’ and ‘Quick Sales Order’ UI’s. A custom UI is built to view and release ‘Salesrep Contention’. Upon release ‘Salesrep Contention’ details will be added as an attachment to the Sales Order.
• Uptaking OM Rollup Patch : Since OM UI are heavily customized at NCH, when NCH decided to uptake June 2008 Rollup patch, I had to make sure that all customizations are done on top of latest Oracle OM code. Also made sure that all the OM flows are working as intended.
• Flex Conflict Extension : This extension will allow the Order Management System to apply an automatic hold to an Sales Order based on Flex Conflict Policy for an operating unit. i.e applying hold due to Pricing Protection or Product Protection. As part of this functionality we have built custom tables, Forms UI and a separate Workflow Process. System will send Notification if Shipment Priority is hot and Sales Order went on Flex Conflict hold. User custom UI ‘Flex Conflict Release UI, user can view and release Flex Conflict hold.
• Novelty Orders Extension : This extension will require Novelty Orders to go through approval process if the sales rep exceeds their allotted amount per month. In such cases system will send an approval notification to their manager for approval. If the manager doesn’t respond in certain amount of time, then approval will be escalated to another group for approval. If the manger declines the approval then the items over the approved amount will be cancelled and order will proceed further. If Novelty Orders are created with in Credit limit specifed for a customer then upon billing, Sales Order lines are created with zero value.
• Integrating NCH Sales Promotion with Oracle OM : As part of this extension, built custom UI to capture NCH Sales Promotion data defined by Sales and Marketing team. Users will be able to define different criteria for a promotion ex: minimum qualifying order amount, existence for a qualifying product, selling price restrictions etc. If any Order containing Sales Promotion item, fails Sales Promotion validations then Sales Order is put on Sales Promotion Hold. Customer UI is built to view and release Sales Promotion Hold.
• Integrating EPA processing with OM flow: Developed setup UI to define Environmentally Restricted Products and customized OM workflow to check for EPA products and put them on Hold if they are found. Also developed UI’s that will help view and release the EPA holds on Sales Orders.
• View Commission UI: Developed User Interface that can be used to determine the commission on Sales Orders by varying Unit Selling Price, Price List and Quantities on a Sales Order Line.
• Developed various Pricing Tools : Developed various tools that will help the Business to create new Price Lists from a base Price List, Increase Price by a specific number for a given group of items or all the items in a price list. Create a ‘Over Price To Cover Price List’ from a base price list.
• NOPS Interface : Sales Orders are created in Oracle OM module, but actual shipping is be done in legacy/Oracle OM. Booked Orders are exported to NOPS system through extraction of Sales Order information. SO orders are processed in NOPS system, then they are imported into Oracle OM module. To build this functionality many Tables/views/PLSQL/Forms/reports are built. OM workflow was customized to support both Oracle Standard flow and OM/NOPS interface flow.
• Integrating EPA processing with OM flow: Developed setup UI to define Environmentally Restricted Products and customized OM workflow to check for EPA products and put them on Hold if they are found. Also developed UI’s that will help view and release the EPA holds on Sales Orders.

 Accounts Payable :

• AP Payments Batch Transfer program to send flat file to BOA in encrypted format (BAFF).
• Program to read 824 Transmission acknowledgement File from BOA and send confirmation status to a given user email.
• Program to download B12 Reconciliation file from BOA America FTP server and upload them into Cash Management Bank Statement Interface Table.

Ø Accounts Receivables:

• Designed and built custom solution for printing customer Invoices and Credit Memos from AR using XML publisher. Logos , Remit to Address and some additional information was brand specific. Formatting of Invoices must comply with postal regulations. Business requirement for multi page invoices, paragraph billing was followed. Always a file copy was created for each invoice.
• Invoice Print Program was customized to hold Invoices that are sent as Email/Fax to the customers in a Custom Schema. Custom form was built on the custom schema, where users can send the invoice after validation. Also Invoice Print program was modified to ignore Credit Memos being sent to Customer as Email/Fax.
• Built and designed Dunning letters print program to allow the mailroom and collection associates to discern different types of dunning letters on different printers.
• Built and Designed Program to automatically write off Freight off the Transaction which is 45 days past due and its Invoice balance amount is equal to the Total Freight Amount. Secondly the program generates a letter to the customer for write off amount and makes sure that Salesman pays the adjusted Freight Amount.
• Built and designed program to automatically write off Tax off the Invoice Transaction past Tax Due days . Program will create an adjustment transaction using ‘Receivable Activity’ called ‘Tax Write Off’ and secondly generate a letter to the customer informing about the write off.
• Built and designed AR Lock Box Interface to accept and upload remittance details sent by JP Morgan in prescribed and accepted format. Bank files are moved to specific directory and from there they are uploaded into AR Lock Box Interface. Reconciliation will be performed after remittance file is processed.

Custom Workflow: Customized Oracle workflows:

• Get the manager approval and split the order line based their approval/credit limit.
• Close the Order header on a specific time on the last day of the month.
• Split the invoices on the auto invoice interface tables based on the no of splits on pay terms.
• Integrated custom Solutions like ‘NCH Sales Promotions’, ‘Commission Calculation’, ‘EPA processing’, ‘NOPS Interface’ by modifying Oracle OM Header and OM line flows.
• Notify the Sales reps if the sales order is backordered and once the backordered orders get fulfilled.

• Collaborated with cross-functional teams to design and develop high-quality applications for various industries.
• Worked on complete project life cycle for three releases (11iR9, 11iR10, R12)
• Involved right from scope definition to design, architecture, data modeling, development, and integration testing.
• Worked with product management team to draft Requirement Definition Documents (RDD) for three releases.
• Designed and coded some of the core functionalities in the Depot repair modules including the depot workbench and automate the different process in service.
• Developed some of the complex integration with the other modules including WIP, OM, Field Service, Install Base and Service Contracts.
• Worked on Oracle Inventory Reservation Enhancement Project. (R12)
• Worked on enhancing features in Inventory Reservation UI.
• Incorporated Reservation Enhancement Features in Private API

• Development and tuning of interface program to load Open Invoices into AR System.
• Development and Tuning of Customer Interface Program.

• Customized Work Flow for iExpenses to provide Single Approver Solution.
• Involved in analyzing back end systems at different Business Units and how these Back end systems integrate with each other.
• Captured information in the form of System Inventory Matrix, Data Source Matrix and developed System Integration Diagrams.
• Involved in the development of Custom Application for Concentra. ( Not an EBS application ). Designed and Developed Stored Procedures for Custom Application.
• Requirement Gathering, GAP Analysis with existing features of TAG application. Capturing TAG Application objects into Designer Repository. Design, development for Enhancement of existing functionality.
• Developed Interface between Oracle Order Entry and Atlas third Party System (Order Entry System).
• Developed Interface between Oracle Inventory and Forecast21 Third Party System.
• Design, development of database triggers and stored procedures and Alerts.
• Developed new reports and modified existing Reports.

• Development and Testing of new Forms and Reports.
• Customization of MRP, PO and OE modules.

Development and Testing of Concurrent Programs, procedures, functions and Shell Scripts.

• Assigning tasks to On Site Developers and interacting with both Business users and On Site Developers. Maintaining Task Status report for On Site Developers.
• Development of new reports and reports data warehouse using Business Objects.
• Conversion of historical GL Transactions into GL Module.
• Setup of FA Module.
• Development of FSG Reports.

• Development of Reports for home grown EPR system.