Project and Work Management Solution Integrated with ERP Platform for Construction Amitava Mitra , Solution Architect,

1. Project and Work Management Solution Integrated with ERP Platform for Construction • AmitavaMitra, Solution Architect, Oracle Primavera, TCS • AmitHalder, Head Primavera Services, TCS • Craig Larson, Director E&C Industry, Oracle

2. Agenda • Challenges for the construction industry • Construction PPM: Challenges and opportunities • Construction Project: Problems and solution • TCS Construction Project Management Solution Connecting people, process & information Business functions The Red Stack Solution landscape Process flow for owners Process flow for contractors Integration diagram

3. Challenges for the construction industry Tremendous business opportunity Construction industry growing @CAGR 7.3%, expected to reach US$2682 Billion by 2017 • 55% of global construction projects face cost and time overruns • Worldwide 30% of large engineering projects face cost and time overruns of 100% or more • 20% organizations face difficulty in managing resources • Key challenges include unavailability of materials, manpower & equipment, drawings, etc • Material wastage and rework due to detection of physical clashes at matured stage • Low adoption of IT in this sector, resulting in lack of real time information visibility and control

4. PPM: Challenges and opportunities Challenges Construction PPM • Owner/General contractor: Manage cost variance • Owner: Track project management • General contractor: Forecast and mitigate delays • General contractor: Manage resources • Owner, architect, general contractor: Visualize construction progress • Planning of scope, budget, schedule, performance requirements • Coordination and control of planning, design, estimating, contracting and construction • Maximizing resource efficiency through procurement of labor, materials and equipment • Effective communications across stakeholders • Enabling a functionally and financially viable construction project • Overall planning, coordination and control of a construction project execution • Timely risk identification through accurate and updated information • Cost management by enabling process efficiencies • Early visualization of project progress and clash detections Opportunities

5. Projects: Problems and solution Problem TCS solution Single integrated system with overlaying process framework for all stakeholders, enabling transparency across workgroups Multiple service providers. Disparate processes and systems to coordinate. Improved vendor management and seamless process workflows with lesser cycle time Lack of visibility in project execution. Long cycle time for reporting. • Effective management and control of both project execution and financials • Task automation • Comprehensive P6 WBS modeling • Reduced manual & duplicate activities • Actual versus planned views • Business Intelligence, trend analysis Inability to have effective working capital mgmt. and financial control. Delay/rework due to clash detection at later stage. Unable to visualize future state & progress. Early clash detection through BIM modeling, 4D /5D visual projections of impact on project schedule & cost due to delays

6. Connecting people, process and information • Project management • Process integration • Inventory and order management • Cost control • Performance dashboards • Mobile access • BIM integration • Regulatory compliance • Connect owner, architect, GC, other partners General Contractor Owner • Early risk detection • Forecast and track schedule, cost variances • Manage change orders easily • Improve operational efficiency • Connected field team via mobile access • Access to critical information • Up-to-date cost and specifications • Visibility and control of project budget, schedule • Project performance dashboards • Strategic decision making TCS Solution • Visualize project progress • Early clash detection • Accommodate plan and design changes • Visibility into Key Performance Indicators • Maximize accuracy and minimize risk • Boost operational efficiency • Enhance communication and collaboration Architect

7. Business functions Internal Users External Users Design Consultants Project Management Consultants Contractors Management Core Team Project Planning and Monitoring Vendor Management Planning Cash Flow Projection Risk Management RFI Drawing Reviews Accountability Schedule Update Change Mgmt Physical Progress Meeting Actions Resource Management Payment Requisition Operational Functions Cost Update Portfolio Analysis Daily Reports Issue Mgmt Budget Management Material Delivery Building Information Model, Estimation Finance & Control General Ledger Payables Cash Mgmt. Taxation Estimation Costing Material Take-Off Construction Modelling 4D Scheduling Parametric Components Schedules Insurance Mgmt. Receivables Fixed Assets Expense Mgmt. Closing Clash Detection 3D Navigation Animation Enabling Functions Document Management Enterprise Reporting Business Intelligence

8. The Red Stack Internal Users External Users Design Consultants Project Management Consultants Contractors Management Core Team Project Planning and Monitoring Vendor Management Planning Cash Flow Projection Risk Management RFI Drawing Reviews Accountability Oracle P6 EPPM Oracle Primavera Unifier Schedule Update Change Mgmt Physical Progress Meeting Actions Resource Management Payment Requisition Colosseum Site Update Operational functions Cost Update Portfolio Analysis Daily Reports Issue Mgmt Budget Management Material Delivery Building Information Model, Estimation Finance & Control Revit / Navisworks CostOS Oracle ERP General Ledger Payables Cash Mgmt. Taxation Estimation Costing Material Take-Off Construction Modelling 4D Scheduling Parametric Components Schedules Insurance Mgmt. Receivables Fixed Assets Expense Mgmt. Closing Clash Detection 3D Navigation Animation Colosseum Site update, Revit, Navisworks and CostOS are non Oracle products Oracle Webcenter Portal Oracle P6 Analytics / OBIEE Enabling functions Document Management Enterprise Reporting Business Intelligence Running on Oracle SUN Server Platform

9. Solution landscape Lean construction practices Policies and controls Standardized process framework Uniform codification

10. Process flow for owners

11. Process flow for contractors

12. Integration diagram

13. Solution benefits • Provides visibility into key performance indicators • Maximizes accuracy and minimize risk • Boosts operational efficiency • Enhances communication and collaboration • Addresses needs of all stakeholders and enables transparency across workgroups through a single integrated system • Improves vendor management and reduces cycle times with seamless process workflows • Delivers effective management and control of both project execution and financials

14. Questions

15. Thank you