OSG

Compensation

Full Description

Sr Oracle Technical Functional Analyst OSG is a commercial printing and customer communications management company headquartered in Carol Stream, Illinois. We produce and deliver billing statements, notices and other critical communications for clients across the country, with nine facilities and roughly 870 employees in 34 states. Our billing, inventory and purchasing for a portion of our businesses is run on Oracle E-Business Suite R12. We are looking for a senior Oracle professional to own that platform to keep it accurate, stable, and a step ahead of problems. 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. Qualifications: • 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 Technical skills: Area Must have Modules AR + AutoInvoice, eBTax, SLA/GL, plus at least one of Inventory, Purchasing, Payables, Advanced Pricing/Order Management, Oracle Workflow, Forms personalization Development SQL, PL/SQL, concurrent programs, APEX, BI Publisher, Oracle Alerts Interfaces AutoInvoice, INV/PO open interfaces, SQL*Loader, UTL_FILE Administration AOL (lookups, value sets, responsibilities), FNDLOAD Support Request logs, SQL trace/TKPROF, lock analysis, period-close exceptions report Tools Integrations experience; Azure DevOps Additional Skillsets a Plus: • 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) Company 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) OSG offers equal employment opportunity and will not discriminate on the bases of race, religion, color, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, family medical history or genetic information, political affiliation, military service, or other non-merit based factors.