Brock O'Dwyer Email & Phone Number

Sydney, New South Wales, Australia

Sydney, New South Wales, Australia

Lead collaborative efforts with diverse stakeholders to establish a thorough grasp and implementation of metadata capture, data lineage, ownership, quality rules, and holistic problem-solving solutions across the data lifecycle. Excel in addressing complex data challenges through innovative problem-solving, collaborative approaches, and advanced analytics, with a distinctive proficiency in SQL, Excel analysis, and resolving intricate data anomalies, especially within heterogeneous data environments.

Sydney, New South Wales, Australia

Senior Data Analyst in Keying and Linking for Equifax Data Fabric Transformation ProjectResponsible for transforming current legacy systems to Google Cloud Platforms ensuring all existing legacy data is maintainedExpert in using tools including Excel, Python, SQL, BigQuery, Google Cloud PlatformsPrimary focus is keying and linking multiple independent sources into one cohesive system. Ensure correct data is matched across those sources

Circular Quay

I provide specialist support for projects and operations by defining and analysing business and functional requirements to identify opportunities for improvement. I have a performance history of independently leading and facilitating discussions with a wide variety of stakeholders, ensuring a common understanding of the programme scope. I facilitate continuous feedback with key stakeholders in order to represent the views of the business to the broader delivery team to achieve targeted business outcomes.

Barangaroo, New South Wales, Australia

Project 2IC of the Westpac 2018-2019 Review and Remediation project across both BTFA and BTGL streamsBuilt an Excel tool to record the outcomes of the program then automate the results communication back to advisers and BTBy applying a holistic view to the scope of the project I was able to identify and remove 30% of the project workload due to a duplication of work across separate monthsDesigned and built an Excel workflow tracker to manage labour resources and predict labour requirements over the lifecycle of the project by recording the outcomes of the team and provided predictive graphs on what the team could accomplishCreated and implemented solutions to complex problems which did not have any precedents and developed procedures to effectively convey these solutions to the team

Parramatta, New South Wales, Australia

1-month contract to deliver an emergency update of the Australian Aged Care data available to the public. Project finished on time and on budget.Verified the data lineage of over 20,000 documents across a new online system designed to provide a more transparent view of aged care facilities to the publicData Analyst Role using Excel and a bespoke cloud system

Auckland, New Zealand

Developed an integrated system to analyse 10,000+ maintenance schedules and 1,000,000+ work orders and provide reports on defects and potential for efficiency upgradesDelivered high level proposals to senior management on how to most effectively restructure their labour resources saving the company thousands in previously underutilised labourDeveloped and maintained relationships with AIM internal and external stakeholders to represent the views of the business to the broader delivery team and help facilitate process change to achieve updated business outcomesWorkflow Analyst role using tools including Excel, VBA, MaxiCloud, Custom Scripting Language based on C/C++

Broadway, Sydney

Developed relationships and communication strategies with 500+ owners of individual units at UniLodge Broadway during a period of upheaval where the building façade required safety upgrades at significant costs to ownersMaintained all contracts and renewals of lease agreements between the owners and UniLodge Broadway, and between residents and UniLodge Broadway/UniLodge Wattle LaneManaged the UniLodge Wattle Lane property with a team of 3 employees and developed tools and strategies to handle large volumes of resident turnover at semester endAssisted with the preparation of high-level reports including the annual business plan and the quarterly marketing and communications planDeveloped a tool using Excel VBA to personalise communication with all owners saving 30+ hours of work each month

Rosebery Nsw

Redesigned the existing processes for project plans, schedules, budgeting and expenditures across the project departmentDeveloped an access database and online database designed to facilitate the move of hundreds of documents to a cloud-based systemControlled the Strategic Management And Reporting Timeline keeping the business accountable to deadlines which are subject to flow on dependencies

Developed and implemented new policies and procedures for record keeping in compliance with the NSW State Records Act 1998.Maintained the TRIM record document database of over 1,000,000 records and was a key member in all aspects of system design, testing and implementation of Council’s record keeping system.Managed a team of 5 employees, while building and maintaining quality assurance checks to ensure all work was following local government guidelines and directives

Bachelor Of Engineering (Be), Mechatronic Engineering (Space)

Currently attending. Mechatronic Engineering (Space)

Master Of Business Administration (Mba), Business Administration And Management, General

Master of Business Administration, accelerated course

Aviation

Aviation - Theory work required before going for Private Pilot Licence. Aerodynamics - Understanding how an aeroplane flies. Navigation.

School Certificate, High School/Secondary Diplomas And Certificates

Mathematics Extension 1, Physics, Chemistry, English,