Note: The job is a remote job and is open to candidates in USA. OSG is hiring a Senior Oracle Technical Functional Analyst to own and support its Oracle E-Business Suite R12 platform. The role focuses on billing accuracy, month-end close, inventory and purchasing support, Oracle development and reporting, client portal configuration, and leading offshore developers.
Responsibilities
- Own billing accuracy. Resolve AutoInvoice rejections, AR and revenue file issues, and invoice interfaces to Great Plains and DataServ — fixing the root cause, not just the symptom
- Lead month-end close, including onboarding new clients into billing and handling metering and FedEx supplemental uploads
- Run pricing changes safely: annual USPS postage increases, client price and coupon updates, and statement minimums — scripted, tested in non-production and reconciled after go-live
- Support inventory and purchasing: PO receipts and approvals, quantity-on-hand and transaction corrections, and usage and stock reporting for our sites
- Build and maintain PL/SQL, concurrent programs, and Oracle APEX reports and alerts that help support and finance teams catch failures early
- Configure and support Portal client data: client setup, archives, job and image purges, and status and notification issues
- Direct an offshore team: write clear stories with acceptance criteria, review code, approve production migrations, and run a clean end-of-day handover
- Serve as the escalation point for P1/P2 Oracle and portal incidents
- Keep work visible: maintain current status and logged effort on the board, and propose fixes for recurring issues instead of waiting for tickets
Skills
- 6+ years of techno-functional experience on Oracle EBS R12, with hands-on depth in Receivables/AutoInvoice and at least one of Inventory, Purchasing or Payables
- Strong SQL and PL/SQL, including concurrent programs, interfaces and the EBS data model
- Experience building Oracle APEX reports and forms
- A track record supporting month-end close and debugging interfaces to an external GL or billing system
- Experience leading offshore developers: story writing, code review and release control
- A proactive mindset — you raise and fix problems the business hasn't reported yet
- Clear, confident communication with finance and operations users
- AR + AutoInvoice, eBTax, SLA/GL, plus at least one of Inventory, Purchasing, Payables, Advanced Pricing/Order Management, Oracle Workflow, Forms personalization
- SQL, PL/SQL, concurrent programs, APEX, BI Publisher, Oracle Alerts
- AutoInvoice, INV/PO open interfaces, SQL\•Loader, UTL\_FILE
- AOL (lookups, value sets, responsibilities), FNDLOAD
- Request logs, SQL trace/TKPROF, lock analysis, period-close exceptions report
- Integrations experience; Azure DevOps
- Print and mail or high-volume billing experience
- USPS postage pricing
- Microsoft Dynamics Great Plains
- Workato or a similar iPaaS
- SOX or access-control experience
- UI development (JavaScript/ReactJS, OAF, ADF)
Benefits
- Health Insurance (EPO & HRA options)
- Dental Insurance
- Vision Insurance
- Short & Long Term Disability
- Flexible Spending Accounts
- Life Insurance
- Accident & Critical Illness Insurance
- Company 401(k) Matching Contribution
- Paid Time Off (PTO)
- Employee Assistance Program (EAP)
Company Overview
Company H1B Sponsorship