Bob Wang
Brisbane,QLD
Summary
As a technical business analyst with a strong background in data science and business intelligence, I have acquired in-depth, hands-on knowledge of Agile, BABOK, and SDLC through my half a decade of experience. Recognised for my proactive nature, sense of responsibility, and team-first attitude, I bring unique insights from my experience across diverse sectors, including state government and not-for-profit, to enable evidenced-based, data-driven decision-making in delivering project success.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Business Support IT Application Officer
Department of Justice and Attorney General QLD
04.2024 - Current
- Migrating VisualFile system from Remote Desktop Service to local device to enable users within the department with improved accessibility
- Collating feedback gathered from pilot testing and tracking the issues, actively engaging with the IT Service department to verify and improve the migration process
- Coding in Windows Powershell and creating .bat files to enable deployment
- Using Active Directory to moderate user permission groups and enable group policies to update in facilitating the migration process
- Keeping track of the asset catalogue and their status to ensure devices are online and migrated to the new organisational unit
- Remoting into desktops to address persisting issues on department devices
- Using SSMS to extract data by querying and exporting into formatted xlsx for the reporting team.
Business Analyst
Endeavour Foundation
08.2023 - 03.2024
- Involved in the project of migrating current Exchange email servers to Office 365, helping with identifying ownership of email distribution lists, creating PowerBI dashboards for visualising and grouping email accounts by batch size, type, and department etc
- Mapping out current-state process of SD-WAN network setup to assist with the transition of said process to BAU operation
- Have successfully convinced the senior leadership team to move as-is workflow from hardware procurement team to IT operations team
- Drafting business cases for projects, obtaining, and specifying details including timeline, budget, benefits, risks etc
- Assisting with the business case of implementing a modern backup and recovery solution that can backup up all of Endeavour's data sources
- Preparing business cases to pass for the senior leadership team gate1 approval.
Technical Business Analyst
Department of Resources, Queensland Government
03.2023 - 07.2023
- Taking lead in driving data migration from Appian to Microsoft Dynamics 365
- Identify future state data requirements using insights from previous BA process maps
- Identify data structure inside Microsoft SQL Server by querying for metadata information
- Identify data quality issues and produce visualisation of issues in PowerBI
- Mapping out the Entity Relationship of the future state data in steps: dataflow diagram, data wireframe of the current state system, Entity Relationship Map Working with data analysts in producing data migration strategy Conduct interviews with stakeholders from both system support and business area SMEs to understand business and technical data requirements
- Defining data entities, resolving ambiguities of terms in current data structure
- Helping with procurement of external data vendor partner
- Finding solution to long existing company data relationship issue by liaising with ASIC for an integration initiative of the two organisations' database.
Technical Business Analyst
Anglicare
06.2022 - 09.2022
- Assisting in data migration from InforSunSystem to Microsoft Dynamics 365, restructuring dimensions in the data warehouse
- Identify future state data requirements using extraction from raw data export in Excel format
- Working with data analyst in building data models by identifying data warehouse reference codes
- Conduct interviews with the finance and accounting department stakeholders to identify data redundancies in existing models
- Identify changes in policy requirement by reviewing financial reports and legislation documents
- Providing BI team with documentation support in building new PowerBI dashboard using artefacts from data warehouse
- Providing the accounting team with documentation support in building a new invoicing system
- Scrum based environment, tracking user stories in JIRA.
Associate Business Consultant
DXC Technology
02.2020 - 06.2022
- Joined through the graduate program, a one-year program that provides exposures to various roles through rotations on different projects in various industries
- Company sponsored the obtaining of training and accreditations
- Insurance claim application: client is public sector
- Worked on building insurance claim applications on Salesforce system for workers in the construction industry
- Helped with identifying requirements needed for billing and using requirements gathered to build applications leveraging salesforce automation ability
- Gambling early intervention system: client is one of the largest gambling companies in Australia
- Helped with building an early intervention system that sends alerts to clients notifying user patterns, documenting server backend requirements from data on salesforce marketing cloud
- Resourcing for ANZ region, assisting with BAU resourcing process in the DXC ANZ region
- Resourcing circle management, lodging records on salesforce, resourcing list maintenance
- DXC APAC training model, develop new employee training model for technical roles
- Conducting cost benefit analysis comparing first-party training solution and internal training, presenting findings to senior leadership in meetings
- Grad APP - worked as PM in assisting the development of graduate onboarding mobile application, using human centred design thinking to arrive at solutions which gamifies the onboarding process
- Helped with RAID analysis, project timeline and budget tracking.
Education
Master of Business Analytics -
University of Queensland
05.2025
Graduate Certificate in Business Analytics -
University of Queensland
01.2023
Graduate Certificate in Data Science -
UNSW
01.2021
Bachelor of Commerce -
ANU
01.2020
Skills
- ● Business Analyst: BPMN (Visio), User Journey/Empathy Mapping, UML, Functional and Non-Functional Requirement Elicitation, UAT
- ● Data science: SQL (SSMS, Postgres SQL, MySQL), Python (Numpy, Pandas, Matplotlib, scikit-learn), R Studio, Excel (Macros, Pivot Table, Analysis Toolpak, VBA, Power Query)
- ● Business Intelligence: PowerBI (DAX), Qlik, Tableau, Dataverse
- ● Project Management/Agile: Prince2, ITIL4, Business Case, RAID Analysis, Project Timeline, Confluence, Jira, User Stories
- ● D365 Dynamics Finance: AR, AP, GL, Forecasting, Dashboards
- ● Microsoft Fabric: Integrating data sources from SQL server, D365, Azure, Excels
Certification
- IIBA ECBA
- Scrum.org certification
- Salesforce admin
Accreditation
● IIBA ECBA
● Scrum.org certification
● Salesforce admin
Languages
Chinese (Mandarin)
Native or Bilingual
English
Native or Bilingual
References
Upon request
Timeline
Business Support IT Application Officer
Department of Justice and Attorney General QLD
04.2024 - Current
Business Analyst
Endeavour Foundation
08.2023 - 03.2024
Technical Business Analyst
Department of Resources, Queensland Government
03.2023 - 07.2023
Technical Business Analyst
Anglicare
06.2022 - 09.2022
Associate Business Consultant
DXC Technology
02.2020 - 06.2022
Master of Business Analytics -
University of Queensland
Graduate Certificate in Business Analytics -
University of Queensland
Graduate Certificate in Data Science -
UNSW
Bachelor of Commerce -
ANU
Similar Profiles
Ja'alla LuscombJa'alla Luscomb
Media Intern at Department of Justice and Attorney GeneralMedia Intern at Department of Justice and Attorney General
Kayleen ScottKayleen Scott
Executive Legal Secretary at Department of Justice and Attorney-GeneralExecutive Legal Secretary at Department of Justice and Attorney-General
Mia MorelloMia Morello
Administration Officer at Department Of Justice And Attorney-GeneralAdministration Officer at Department Of Justice And Attorney-General
Samhitha VaralaSamhitha Varala
Senior Civil Engineer at Telangana scientificSenior Civil Engineer at Telangana scientific
Masahiro YonezuMasahiro Yonezu
Product Development Associate at NTC Wismettac Australia Pty Ltd Brisbane BranchProduct Development Associate at NTC Wismettac Australia Pty Ltd Brisbane Branch