Ferdie Oosterhoff Email & Phone Number

Sydney, Nsw, Au

Sydney

Sydney, New South Wales, Australia

Responsibilities:• Build the ‘green-fields’ Data Systems and Integration team, with processes and frameworks, to provide data management and solution capabilities for Transport Operational data.• Development and delivery of new data solutions, leveraging the TfNSW ODRE Enterprise cloud data platform and capabilities.Key Achievements: • Key contributor to the building of the Data Systems and Integration team. Team grown from 4 to 40 people, with contribution to demand management processes, architectural and design principles and frameworks, DevOps and CI/CD establishment.• Creation of an MDM roadmap, and delivery of MVP MDM ingestion and API provision capability.• Development and delivery of a ‘Common (data) Ingestion Framework’.• Establishment of the DSI Technical and Architectural Working Group.• Production of version 1.1 of the TfNSW SIRI Specification, to include Facilities Monitoring.Activities:• Team leadership.• Business engagement, business analysis, requirements gathering, estimation and sizing.• Establishment of architectural and design standards.• Solution design.• Team recruitment.• Attendance and contributions to multiple working groups.• Scrum ceremonies, feature/epic development, backlog grooming, showcases, sprint planning, story prioritisation, sizing and daily standups.Projects: • ODRE re-establishment and MVP • Digital Twin RFP• Historical Data Search, migration and enhancements.Methodologies and Frameworks: • Agile, Scrum, SAFETechnologies and Tools: • SQL Server, Azure Data Factory, Databricks, Cosmos DB, Python, Spark

Sydney, New South Wales, Australia

Responsibilities:As a key member of the Operational Systems Data Team to provide:• Subject-matter and transport domain expertise to various programs and projects. • Technology and development expertise to various programs and projects. • Data management and data integration expertise to various programs and projects.Key Achievements: • Successful delivery of Stage 1 of TfNSW’s first Data Vault implementation.• Evolution of the Operational Data Mart, with extensive operational reporting.• Production of the TfNSW SIRI (Service Interface for Real-time Information) specification.• Delivery of the PTMS (Public Transport Messaging Service) broker platform, for transmission of timetable and real-time information from transport Operators to Customer Information Services and downstream applications.Activities:• Business engagement, business analysis, requirements gathering, estimation and sizing.• Custom report and dashboard development.• Data analysis.• Data modelling and data integration.• Data standards development and writing.• ETL pipeline and database development.• Scrum ceremonies, story development, backlog grooming, showcases, sprint planning, story prioritisation, sizing and daily standups.• Solution design.• Mentoring.Projects: • LiveTraffic Historical Data Search• Public Transport Messaging Service (PTMS)• ODRE (Operational Data Real-time Exchange)• ODM (Operational Data Mart)Methodologies and Frameworks: • Agile, Scrum, WaterfallTechnologies and Tools: • SAP Business Objects, Tableau, Oracle, SQL Server, Azure Data Factory, Databricks, Cosmos DB, Python, Spark

Sydney, Australia

Responsibilities:• As a Business Intelligence SME to provide broad-ranging subject matter expertise in analysis, data architecture, and BI design and development.Key Achievements: • Implementation of the Operational Data Mart, integrating bus scheduling and real-time tracking data to support contract management and KPI reporting, timetable scheduling and fleet management.• Development of TfNSW’s first Data Vault implementation, representing integration of 10+ data sources into a single Data Vault 2.0 data-warehouse, with a virtualized information delivery layer.Activities:• Business engagement, business analysis, requirements gathering, estimation and sizing.• Trials, evaluations and proof-of-concepts.• Solution design.• Data modelling.• ETL pipeline and database development.• Identification of test-cases (test-driven development), and acceptance criteria.• Mentoring.Projects: • Vanguard• ODM (Operational Data Mart)• NetBI TrialMethodologies and Frameworks: • Agile, Scrum, WaterfallTechnologies and Tools: • SAP Business Objects, SAP Data Services, Tableau, Oracle, SQL Server, NetBI

Sydney, Australia

Responsibilities:• Consultancy role, leading dashboard and report development, and a BI platform upgrade and migration.Key Achievements: • Delivered dashboards for the manufacturing floor production lines, to control quality and improve production line output.• Large report migration and Business Objects platform upgrade, 300+ report and 50+ users.Activities:• Technical team leadership.• BI Platform upgrade and migration.• Custom report and dashboard development.• ETL pipeline and database development.Technologies and Tools: • Business Objects Enterprise, Business Objects Dashboards (Xcelsius), Oracle, Oracle Business Intelligence Enterprise Edition (OBIEE), Informatica

Sydney, Australia

Responsibilities:• To act as a BI platform SME, reporting to the National Solution Lead, with accountability for leading client BI project delivery.Activities:• Customer engagement, business analysis, requirements gathering, estimation and sizing.• Solution design.• Custom report and dashboard development.• ETL pipeline and database development.Projects: • Tomago Aluminium, Implementation of a Plant Maintenance KPI reporting solution.• GPT, interim support role for data warehouse and analytics solution.• Murray Goulburn, BI project delivering custom reporting on SAP BW.• Cancer Institute of NSW Data-mart, solution for processing and aggregation of cancer incidence statistics for periodic legislative reporting.Technologies and Tools: • SAP BusinessObjects Enterprise, SAP Data Services, Microsoft SQL Server, Microsoft SharePoint, SAP Integration Kits, Crystal Reports, Web Intelligence, Xcelsius Dashboards

Sydney

Responsibilities:• Reported to Company Directors, broad consultancy role, managing teams and projects, client solution delivery, pre-sales consultancy, design and development for BI solutions.Activities:• Customer engagement, business analysis, requirements gathering, estimation and sizing.• Project Management.• Technical team leadership.• ETL pipeline and database development.• Custom report and dashboard development.Projects: • Luxottica, reporting and dashboards• ASICS, reporting and dashboards• Optus, a custom business account management portal, with integrated reportingTechnologies and Tools: • SAP BusinessObjects Enterprise, SAP Business Warehouse, Oracle, Xcelsius Dashboards