Job Description Oracle Primavera & Unifier Report Developer (Data Migration & Reporting)
Experience: 7 10 Years
Location: As per project requirement
Industry: Water Utility / Infrastructure / EPC / Capital Projects
Role Summary
We are seeking an experienced Oracle Primavera & Oracle Unifier Report Developer with expertise in report development, data migration, analytics, and enterprise reporting. The candidate will be responsible for designing, developing, and maintaining reports, dashboards, data migration strategies, and integrations for Oracle Primavera P6 and Oracle Unifier implementations. The role involves close collaboration with functional consultants, project controls teams, finance, engineering, and IT stakeholders to ensure accurate reporting and seamless migration of project data.
Key Responsibilities
Reporting & Analytics
- Design, develop, and maintain enterprise reports and dashboards for Oracle Primavera P6 and Oracle Unifier.
- Develop operational, management, and executive dashboards to support project governance and decision-making.
- Create ad-hoc reports and KPIs based on business requirements.
- Develop and maintain reports using:
- Oracle BI Publisher
- Oracle Analytics Cloud (OAC)
- Primavera Analytics
- Primavera Visualizer
- Power BI (preferred)
- Optimize report performance and ensure data accuracy and consistency.
Data Migration
- Prepare end-to-end data migration strategy for Primavera and Unifier implementations.
- Perform data extraction, cleansing, transformation, validation, and loading activities.
- Migrate:
- Project schedules
- WBS structures
- Activities
- Resources
- Cost data
- Baselines
- Contracts
- Cost Sheets
- Business Processes
- Documents
- Users and security configurations
- Develop migration templates and reconciliation reports.
- Perform trial migrations, mock conversions,
and production cutover support.
Report Development
Develop reports for:
- Project Schedule Status
- Milestone Tracking
- Resource Utilization
- Budget vs Actual
- Cost Forecast
- Cash Flow
- Earned Value Management (EVM)
- Contract Status
- Change Orders
- Payment Applications
- Risk & Issue Logs
- Project Portfolio Status
- Executive Dashboards
Data Integration
- Develop and support integrations between Primavera/Unifier and enterprise systems using:
- Oracle Integration Cloud (OIC)
- REST APIs
- SOAP Web Services
- File-based interfaces (CSV, XML, JSON)
- Support integrations with:
- Oracle Fusion ERP
- SAP
- GIS
- BIM platforms
- Aconex
- Document Management Systems
Data Quality & Governance
- Perform data validation, reconciliation, and quality checks.
- Develop exception reports and data quality dashboards.
- Ensure compliance with enterprise data governance standards.
- Support master data management for project controls.
Testing & Support
- Prepare migration test plans and reconciliation reports.
- Perform Unit Testing, System Integration Testing (SIT), and User Acceptance Testing (UAT) support.
- Troubleshoot reporting and migration issues.
- Provide post-go-live production support and performance tuning.
Required Technical Skills
Oracle Primavera
- Primavera P6 EPPM Administration
- Primavera Analytics
- Primavera Reporting
- Primavera Visualizer
- Schedule data structures
- Resource and cost reporting
Oracle Unifier
- Reporting Framework
- Business Process Reporting
- Cost Sheet Reporting
- Data Views
- User-Defined Reports
- Document Manager Reporting
Reporting Tools
- Oracle BI Publisher
- Oracle Analytics Cloud (OAC)
- Power BI (preferred)
- Advanced Microsoft Excel (Pivot Tables, Power Query, Macros)
- SQL and PL/SQL
Data Migration
- ETL concepts
- Data Mapping
- Data Cleansing
- Data Validation
- Bulk Data Import/Export
- CSV/XML/JSON processing
Integration
- Oracle Integration Cloud (OIC)
- REST APIs
- SOAP Web Services
- SQL
- XML
- JSON
Water Utility Domain Knowledge
Experience in one or more of the following is preferred:
- Water Supply & Distribution Projects
- Wastewater & Sewerage Projects
- Water Treatment Plants
- Pipeline Networks
- Pumping Stations
- Reservoir Construction
- Capital Infrastructure Programs
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- Oracle Primavera P6 and/or Oracle Unifier certifications are preferred.
- Certification in Oracle BI Publisher, Oracle Analytics Cloud, or Microsoft Power BI is an added advantage.
Preferred Experience
- 7 10 years of IT experience with at least 5 years of hands-on experience in Oracle Primavera P6 and Oracle Unifier reporting and data migration.
- Proven experience in large-scale Primavera and Unifier implementation or upgrade projects.
- Strong expertise in enterprise reporting, dashboard development, and data migration.
- Experience integrating Primavera/Unifier with Oracle Fusion ERP, SAP, or other enterprise systems.
- Solid analytical, problem-solving, and communication skills.
- Experience working in Water Utilities, EPC, Engineering, Construction, or Capital Projects organizations is highly desirable.
📌 Oracle Primavera & Unifier Report Developer (Data Migration & Reporting) (Delhi)
🏢 Arminus
📍 Delhi