Brandon Mercer Email & Phone Number

Australia

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 automatic HR & Finance dashboards using Power BI.● 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 managed a new instance of Tableau Cloud and distributed dashboards throughout the business, often to high-level executives. Responsible for the security, internal structure and maintenance of both Tableau and Snowflake.● 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 Snowflake to transform/model data into an appropriate structure.● 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 story-telling techniques to reveal valuable insights with the assistance of Tableau visuals.

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 Support services.● 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 reports.● 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.