What are the responsibilities and job description for the Oracle Analytics Server Developer position at CAPITAL CONSULTING LLC?
Job Description
Job Description
Location : San Antontio, Texas
Job Summary :
The Oracle Analytics Server (OAS) Developer will support a large defense agency’s E-Business Suite deployment by developing and maintaining advanced analytics and reporting solutions. The role involves migrating existing reports to OAS, enhancing reporting capabilities, and ensuring seamless integration with Oracle E-Business Suite (EBS) R12.2.x. The developer will collaborate with technical teams and stakeholders to design, build, and optimize data visualizations, dashboards, and reports that support mission-critical operations.
Responsibilities :
- Migrate and enhance reports from Oracle 6i to Oracle Analytics Server (OAS) .
- Develop, test, and deploy custom dashboards, reports, and visualizations for finance, HR, payroll, and benefits modules.
- Administer OAS on multiple environments , ensuring stability and performance optimization.
- Integrate OAS with Oracle EBS R12.2.13, Oracle Cloud, and Oracle Database 19c (RAC, ASM, Data Guard) .
- Work closely with Oracle EBS developers to support RICEFW components and ensure seamless data flow between systems.
- Maintain and optimize 120 OAS reports for data accuracy, performance, and usability.
- Provide weekly and monthly status reports detailing progress, issues, and planned activities.
- Troubleshoot and resolve performance issues related to SQL queries, BI Publisher, and data modeling .
- Ensure compliance with Air Force cybersecurity and data governance policies .
- Participate in system upgrades, patches, and performance tuning efforts .
- Document technical designs, data models, and user guides for reporting solutions.
Required Qualifications :
Preferred Qualifications :
Work Environment & Conditions :
LI-NN1