Brandon Mercer Email & Phone Number

Australia

Chatswood, New South Wales, Australia

• Premier's Department - Principal Power BI developer and strategist for a Management dashboarding project.
• Department of Defence - Principal Tableau Developer for a demand management project.
• Team Lead at Billigence - Responsible for management of new starters and involved in pre-sale activities.
• Guide Dogs Australia - Data migration project involving the transfer of data from SQL server to Snowflake.

Chatswood, New South Wales, Australia

• Personal Injury Commission - Lead a Tableau reporting migration project.
• Attorney General's Department x 2 - Developed a Snowflake and Power BI POC that involved extracting raw data from S3 buckets and modelling it into an appropriate structure (SCD2). This data was then used to create.
• MA Financial Group Projects (Greenfield Data Team) - Consolidated data from multiple business areas into a new Snowflake instance and used this data to create countless automated Tableau Dashboards. Implemented and.
• Macquarie University Data Migration and Executive Reporting Project - Constructed multiple executive Power BI dashboards with data that was previously siloed across different faculties/divisions, using Alteryx and.
• Service NSW Strategic Survey Insights Project x 2 - Principal Project Analyst for 2 separate Tableau dashboard & Insight Analysis presentations. Converted survey data into a digestible form using Alteryx and used.

Chatswood, New South Wales, Australia

• Services Australia Executive Dashboards Project - Constructed multiple near real-time Tableau dashboards to help understand and strategically react to the cost of the Covid-19 pandemic on Centrelink, Medicare and Child.
• SIRA NSW Requirements Gathering and Mock-ups - Outlined the scope of a merger project involving 2 entities who were combining reports. Created initial mock-ups and uncovered new value that could be added to historical.
• Storage King - Worked with a senior DA to uplift historical Tableau reports to allow for easier identification of performance outliers.

I held this job during my 4-year University education. I attribute much of my strong communication ability to this role and matured greatly during this time. This role included my first management experience.

Australia

3-month Internship at Westpac's Barangaroo Office. This was my first corporate experience during the 3rd year of my University Education.