Software Development Specialist Advisor

Key Responsibilities Test Strategy & Execution: Design comprehensive test plans, test cases, and test scripts based on functional specifications and Business Requirement Documents (BRDs). Module Validation: Perform functional and backend testing across core Oracle EBS modules (e.g., Financials: GL, AP, AR, FA, CM; SCM: PO, OM, INV, WIP, BOM). Backend & Database Testing: Write complex SQL queries and PL/SQL scripts to validate data migrations, verify interface logic, and troubleshoot backend tables. RICEW Testing: Validate Reports, Interfaces, Conversions, Extensions, and Workflows (RICEW), ensuring custom components map accurately to business needs. Integration & API Validation: Test integrations between Oracle EBS and third-party systems using Web Services, APIs, and SOA architectures. Defect Management: Log, track, and retest bugs using tools like JIRA, HP ALM, or Bugzilla, collaborating with offshore/onshore technical teams for quick resolution. Documentation: Maintain traceability matrices and update technical/functional documentation (e.g., MD050, TE040, AIM methodology). Essential Qualifications Education: Bachelor’s degree in Computer Science, Information Technology, Business, or a related field. Experience: 3+ years of dedicated experience in QA, Business Analysis, or Implementation support within Oracle EBS environments. SQL & PL/SQL: High proficiency in reading, writing, and debugging SQL queries and PL/SQL packages. Domain Knowledge: Strong understanding of financial accounting rules, supply chain end-to-end flows, and order-to-cash (O2C) or procure-to-pay (P2P) cycles. Tools: Hands-on experience with Oracle Workflow Builder, BI/XML Publisher, and automated testing frameworks. Soft Skills: Sharp analytical skills, high attention to detail, and excellent communication abilities to articulate complex technical issues to non-technical stakeholders