Oracle Oac

Company Description WNS Holdings Limited NYSE WNS is a leading Business Process Management BPM company We combine our deep industry knowledge with technology and analytics expertise to co-create innovative digital-led transformational solutions with clients across 10 industries We enable businesses in Travel Insurance Banking and Financial Services Manufacturing Retail and Consumer Packaged Goods Shipping and Logistics Healthcare and Utilities to re-imagine their digital future and transform their outcomes with operational excellence We deliver an entire spectrum of BPM services in finance and accounting procurement customer interaction services and human resources leveraging collaborative models that are tailored to address the unique business challenges of each client We co-create and execute the future vision of 400 clients with the help of our 44 000 employees Role Overview Highly skilled Senior BI Consultant with deep expertise in Oracle Analytics Cloud OAC Oracle E-Business Suite EBS and Power BI to support a strategic client engagement This individual will support the design development and delivery of data and reporting solutions leveraging both Oracle and Microsoft BI ecosystems The ideal candidate must have hands-on experience with Oracle RPD development Discoverer report migration and should be capable of playing a Power BI Solution Architect role translating business requirements into scalable and user-friendly BI solutions Key Responsibilities Oracle Analytics OAC Oracle EBS Lead the design development and maintenance of interactive dashboards and reports in Oracle OAC including the use of the Data Visualization DV module for self-service analytics and ad hoc reporting Perform advanced development and customization of RPD Repository models Physical Business and Presentation layers ensuring alignment with Oracle EBS schemas and data logic Configure and manage data sources connection pools and subject areas to ensure high-performance reporting and secure access Set up and manage Schedulers Agents and Jobs in OAC to enable automated delivery of reports and alerts to business users Monitor and troubleshoot scheduled reports and jobs for execution issues data freshness and delivery failures Build and maintain datasets within DV and across subject areas to ensure reuse consistency and optimized performance Drive the migration of legacy Oracle Discoverer reports to OAC including analysis mapping validation and performance tuning Work closely with Oracle EBS functional leads to extract meaningful business insights across modules like Financials Procurement HR and SCM Power BI Architecture Development Work as the Power BI Solution Architect leading stakeholder discussions to define KPIs data flows and dashboard requirements Translate functional and business needs into technical designs and reporting solutions in Power BI ensuring accuracy performance and usability Build enterprise-grade Power BI data models star snowflake schemas custom DAX calculations and dataflows using Power Query Design visually engaging and user-centric reports following best UI UX practices ensuring clarity and actionable insight for stakeholders Ensure seamless integration with on premise or cloud data sources and enforce row-level security data refresh schedules and version control End-to-End BI Project Delivery Drive complete BI project lifecycle requirements gathering data discovery architecture development UAT deployment and hyper-care Collaborate with business users Oracle functional teams DBAs and other BI developers to ensure alignment on data definitions timelines and deliverables Proactively monitor performance usage and adoption of OAC and Power BI reports and recommend enhancements Maintain documentation of technical architecture RPD logic data flows and report inventory Required Skills Qualifications 8 years of overall BI DW experience with strong exposure to Oracle and Microsoft ecosystems Minimum 4 years of hands-on experience in Oracle OAC including RPD development Deep understanding of Oracle EBS data structures and reporting integration Proven experience in Oracle Discoverer report migration projects Strong expertise in Power BI including data modeling DAX Power Query custom visuals and embedding Demonstrated ability to design aesthetically pleasing and highly functional dashboards Experience working in agile environments and collaborating with cross-functional teams Ability to work independently and manage multiple priorities Qualifications Required Skills Qualifications 8 years of overall BI DW experience with strong exposure to Oracle and Microsoft ecosystems Minimum 4 years of hands-on experience in Oracle OAC including RPD development Deep understanding of Oracle EBS data structures and reporting integration Proven experience in Oracle Discoverer report migration projects Strong expertise in Power BI including data modeling DAX Power Query custom visuals and embedding Demonstrated ability to design aesthetically pleasing and highly functional dashboards Experience working in agile environments and collaborating with cross-functional teams Ability to work independently and manage multiple priorities