Sr Oracle Support Analyst

CREATIVITY IS OUR SUPERPOWER. It’s our heritage and it’s also our future. Because we don’t just make toys. We create innovative products and experiences that inspire fans, entertain audiences and develop children through play. Mattel is at its best when every member of our team feels respected, included, and heard—when everyone can show up as themselves and do their best work every day. We value and share an infinite range of ideas and voices that evolve and broaden our perspectives with a reach that extends into all our brands, partners, and suppliers.

Job Description – Oracle ERP Production Support Analyst Position Summary We are seeking an experienced Oracle ERP Production Support Analyst to provide production support, operational troubleshooting, incident management, and application support for a highly customized Oracle ERP environment. The ideal candidate should have strong Oracle ERP functional knowledge, excellent Oracle SQL/PLSQL skills, and experience supporting business-critical ERP applications. The environment includes significant custom development built on top of Oracle E-Business Suite (11i/R12), requiring both technical troubleshooting and business process understanding.

Production Support Provide L2/L3 production support for Oracle ERP applications. Investigate and resolve application, data, and interface issues. Perform root cause analysis and implement corrective actions. Support business users during critical incidents and escalations. Monitor application health, concurrent programs, interfaces, and batch processes. Coordinate with business users, infrastructure teams, vendors, and development teams. ERP Functional Support Support day-to-day ERP operations across Order-to-Cash, Procurement, Inventory, and Finance processes. Analyze business process issues and system impacts. Troubleshoot transactional issues and data discrepancies. Work closely with business SMEs and functional teams to resolve production issues. Provide guidance on ERP functionality and process flows. Technical Support/Development Develop and troubleshoot Oracle SQL and PL/SQL programs. Support custom interfaces, reports, conversions, and enhancements. Investigate data issues and perform approved data corrections. Analyze performance issues and optimize SQL queries where required. Support deployment and migration activities. Defect fixes, performance tuning, and automation initiatives Testing, deployment, and release support Functional Knowledge Required Strong Functional Knowledge Order-to-Cash (O2C) Customer Orders Shipping Execution Inventory Transactions Invoicing Order Fulfillment Lifecycle Procurement Requisitions Purchase Orders Receiving Supplier Management Procurement Workflows Inventory Management Inventory Transactions Item Master Cycle Counting Inventory Reconciliation Material Movements Finance & Accounting General Ledger (GL) Accounts Payable (AP) Accounts Receivable (AR) Financial Period Close Accounting and Financial Reporting Receiving Receipt Processing Receipt Corrections Inventory Receiving Transactions Required Technical Skills Oracle E-Business Suite 11i, R12, or higher Strong Oracle SQL and PL/SQL development skills Experience supporting highly customized Oracle ERP environments Oracle Forms, Reports, Interfaces, and Concurrent Programs Data analysis and troubleshooting Incident and production support management Preferred Skills Oracle Workflow knowledge XML Publisher / BI Publisher Unix/Linux shell scripting Oracle ERP integrations and interfaces ITIL / Production Support processes ServiceNow or similar ticketing tools Qualifications Qualifications Bachelor's degree in Computer Science, Information Systems, Accounting, Finance, Supply Chain, or related field. 6+ years of Oracle ERP production support experience. Strong Oracle ERP functional and