Purpose of the position To work in BI projects involving Oracle Fusion HCM, Data modelling, Reports/dashboard development, BI Publisher RTF & Excel templates and to work in global teams and support global cross-functional workplace partnering with internal customers to help, support and enhance business systems.

Responsibilities & duties

Ability to understand business requirement and design data model from Oracle Fusion HCM database data model

Providing effort estimations to complex BI Publisher requirements / projects

- Responsible for Fusion HCM data model design & development, the development of BI Publisher reporting features for current and future applications and data using RTF & Excel templates

Should have implemented HCM Fusion datamodel in recent project

Should be familiar with Workforce Administration, Workforce Compensation, Performance, Talent, Profile modules functionalities

Should have implemented BIP based reporting in recent project

Should have implemented Template based reporting, preferably RTF & Excel

** Knowledge on OBIEE (RPD design & development, Catalog & Dashboard design) is an added advantage

Design, develop and implement enhancements and customizations to the BI Application environment

Establish a deep understanding of the company data model and reporting needs

Create technical designs from business requirements and engineer and develop technical solutions based on those designs.

Expert in debugging, optimizing and Performance Tuning of BI Publisher data models & reports

Participate in system-level tests responsible for comparing actual results with expected results

Must have experience in requirement gathering, rationalization of requirement and creation of Technical specification

Strong experience while providing support in Production environment.

Ability to understand Fusion HCM data model, Oracle Fusion HCM BI Publisher workflow notifications

Understand and design data models to setup robust BIP reports





Must know how to write advance SQL, use Oracle's SQL aggregate and analytic functions

Develop solutions that utilize the highest standards of analytical rigor and data integrity.

Design, development, and maintenance of ongoing KPIs, metrics, reports, analyses, dashboards, etc. to drive key business decisions.

Recognize and adapt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.

Monitor and tune the performance of the BI Publisher environment

Monitor, respond and resolve tickets and issues submitted by users, ability to perform RCA on critical tickets/incidents

Train and mentor team members and management to understand BI Publisher and assist with development of BI Publisher data models, templates & reports

Experience using databases in a business environment with large-scale, complex datasets

Previous success in designing and developing BI Publisher reporting applications

- Ability to clearly articulate ideas, technical concepts and obstacles with management

Experience & Key skills

Essential

Desirable

4-6 years of experience in Oracle Fusion HCM data model, design, develop RTF & Excel template based reports using Oracle BI Publisher

Experience of working with Oracle Fusion HCM data model

Experience of working with multi-cultural and geographically disparate teams.

Strong SQL/PLSQL knowledge

Strong BIP Templates design

Experience of working using RTF & Excel templates

Good hold on OBIEE

OBIEE Experience

Performance Tuning skills

Understanding of statistics and decision making

Personal qualities & behavioural traits

Essential

Desirable

Good verbal and written communication

Work in global environment

Team Player, Committed & Goal oriented

Detail oriented

Quick learner and own things to closure

Collaboration Skills

Analytical and Problem solving ability

Academic & qualifications

Essential

Desirable

B.E. / B.Tech / MCA

BI Publisher certification / BI Publisher Work Experience

SQL/PLSQL qualification

📌 Developer (Bengaluru)
🏢 Schneider Electric
📍 Bengaluru