VS01711 - OFSAA OAS / Reporting Technical Consultant

E4 Software Services Pvt Ltd.; Mumbai; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

E4 Software Services Pvt Ltd. seeks a skilled Oracle analytics professional to design, develop and maintain OFSAA reporting solutions. You will build dashboards for ALM, LRM, FTP, LLFP and PFT, map business requirements to data models and optimize report performance.

The role requires strong SQL/PL/SQL abilities, experience with OAS data structures, and cross-functional collaboration for data validation and issue resolution within a financial services context.

Qualifications

• 5+ years of hands-on experience in Oracle Analytics Server (OAS)/OBIEE/OAC reporting.
• Experience in designing, developing, configuring and maintaining reports and dashboards for OFSAA applications such as ALM, LRM, FTP, LLFP and PFT.
• Good understanding of OFSAA financial services data models and reporting structures, mapping requirements to data.
• Strong SQL and PL/SQL skills for report-data analysis, query development, reconciliation and troubleshooting.
• Experience in creating new reports and enhancing/maintaining existing reports with calculations, filters and presentation requirements.
• Ability to perform report-to-source reconciliation, data validation and root-cause analysis for reporting discrepancies.
• Experience in report performance tuning, SIT/UAT support, defect resolution and production deployment for OAS/OBIEE/OAC reporting solutions.

Responsibilities

• Design and develop reports and dashboards for OFSAA applications.
• Tune report performance and support SIT/UAT and production deployments.
• Coordinate with data teams for data validation and reconciliation.
• Maintain existing reports and implement enhancements and new calculations.

Skills

OAS/OAS reporting

OBIEE

OAC reporting

OFSAALFS?

SQL

PL/SQL

Report design

Data modeling

Performance tuning

Tools

Oracle Analytics Server (OAS)

OBIEE

OAC

SQL

PL/SQL

OFSAA

Job description

• 5+ years of hands-on experience in Oracle Analytics Server (OAS)/OBIEE/OAC reporting, preferably in an OFSAA and financial-services environment.
• Experience in designing, developing, configuring and maintaining reports and dashboards for OFSAA applications such as ALM, LRM, FTP, LLFP and PFT.
• Good understanding of OFSAA financial services data models and reporting/result structures, with the ability to map business/reporting requirements to underlying data.
• Strong SQL and PL/SQL skills for report-data analysis, query development, reconciliation and troubleshooting.
• Experience in creating new reports and enhancing/maintaining existing reports, including report-level calculations, filters and presentation requirements.
• Ability to perform report-to-source reconciliation, data validation and root-cause analysis for reporting discrepancies in coordination with functional and data teams.
• Experience in report performance tuning, SIT/UAT support, defect resolution and production deployment/support for OAS/OBIEE/OAC reporting solutions.