Hi, I'm Dusica
A Microsoft-Certified Data Management, Programming and Reporting Specialist in Perth, working with Azure Cloud.
What I do
Clients & Employers
Qualifications & References
Detailed Case Studies
Skills
What I do
Since studying a Bachelors in Business Computing at Unitec Auckland, I've built up 24 years of experience, taking on a number of roles, across many of Australia’s highest-value sectors including large-scale mining, healthcare and print publishing. I am a proud nerd, always looking for the next challenge. For example, I have mastered Azure Cloud, and recently gained additional Microsoft Certification in Data Management and Analytics, BI Reporting and SQL Business Intelligence Development.
Database Development & Administration
I’ve developed and managed Relational Databases, Data Marts, and Data Warehouses using Microsoft’s full suite of software, either through full SDLC or as integration/migration projects.
Project management, DEVOPS, Systems Development
I've managed several teams and large projects implementing DevOps practices. My Functional and Technical Specifications resulted in successful, timely project completions and happy clients.
Data Management
A surprising amount of businesses have messy data. I specialise in data clean-up, integration, enhancement and migration as well as complex data extractions and transformations. If your people can mess up your data, I can clean it up.
BI ANALYSIS + REPORTING
With a strong understanding of how to analyse and interpret data, I deliver forecasts, estimates, dashboards and other summaries, supporting business in big-picture decision making.
In 2022, I gained full Microsoft Certification for both Azure Fundamentals and Azure Data Fundamentals.
In 2018, I gained full Microsoft Certification for Data Management and Analytics, BI Reporting, Business Intelligence Development in SQL 2016.
Working experience
Former clients and employers
Prior to my work for the WA Police Force, Department of Communities and the WA Department of Health, I worked for much of the last decade on KJV and Chevron's Gorgon Project, through HATCH, across multiple roles and projects. Prior to that I worked on other HATCH projects like Iron Ore and Ravensthorpe Nickel.
At HATCH, I was also involved in In-house system development, off-the-shelf software evaluations as well as various small systems development, maintenance and reporting to all levels of management.
Prior to that I worked at Salmat as a Programmer, where I also worked for a number of large clients, as well as numerous small to medium businesses.
On the side, I've also completed solo projects for smaller businesses, the latest one being for autism care provider ISADD.
References
“I have never seen anyone who takes that much pride in data they are managing”
“In Dusica we Trust – every day there is an enormous amount of data than we can’t process individually. Dusica has the ability to turn data into logical information that can be used to generate significant commentary and analytics which drives the project forward at all times.”
“Dusica astounded us with her ability to comprehend our very complex situation so quickly.”
Qualifications
BSc, Technical Computer Sciences, UNITEC, Auckland, New Zealand, 2000
Microsoft Certified: Azure Fundamentals, 2022
Microsoft Certified: Azure Data Fundamentals, 2022
Microsoft Certified Solutions Expert: Data Management and Analytics, 2018
Microsoft Certified Solutions Associate: BI Reporting and Analytics, 2018
Microsoft Certified Solutions Associate: BI Development, 2018
Microsoft Certified Professional, 2001
Implementing and Designing SQL Server 7 Databases, 2001
AS/NZS ISO 9001-2000 internal business system auditor, 2005
Advanced PResScript programming, by PrintSoft, 2004
BSc, Chemistry, University of Novi Sad, Novi Sad, Serbia
The sPECIFICs
Detailed
Case Studies
Below are a couple of specific case studies, some with more in-depth write-ups regarding the projects I've worked on, in which capacity, as well as some details on how that resulted in positive outcomes for the businesses and people I've work with.
WA POLICE
2023 - Present
Senior Data Engineer, Full-time. ETL / Azure Synapse Analytics – pipelines, Gen2, lakehouse, Serverless SQL pools, Notebooks (PySpark). Database exploration and Dataset preparation for downstream: Power BI Reporting Analysts (including support for Power Bi) and Data Scientists; DWH – exploration and development of STAR structures. Logic Apps integration with Synapse pipelines. DevOps git integrated and Azure Boards.
DEPARTMENT OF COMMUNITIES
2022
INSIGHT Consultant, Power BI Developer, and SQL Programmer - I assisted in the development of automated messaging-hot plate programming from SQL Azure database, developed Power BI reports, advised on SQL Azure database and SharePoint online interfacing and provided Staff Development for their in-house team.
ISADD Job Management & Billing System
2016, 2019-2021
Business and Data analysis and System Requirements Definition - I was enlisted by Intervention Service for Autism and Developmental Delay (ISADD) to analyze their existing business processes and billing system and build a custom solution for their business. As well as using PowerBI, this project involved building a prototype, then identified bottlenecks to fine tune business rules and implement better processes. I delivered a Full System Requirements definition, complete with a proposal document and ROI, outlining a solution using off-the-shelf software, that was most appropriate for their business and budget.
WA DEPARTMENT OF HEALTH
2019
As a Database and Application developer, I carried out full SDLC development of MS Access/SQL Server Database Application to extend functionality of the existing Clinical Incident Management System, as requested by the PSSU unit of The WA Department of Health.
This was my main project for eight years. I've had multiple roles in my time working on it, taking on more responsibilities as the project matured. These include being a Senior Analyst/Developer and Database Administrator. While primary focus of my work were development, improvements and administration of billing and financial systems and data, my services also extended to Project Controls, HR, Commercial and other disciplines.
The gorgon project
2010 – 2017
ETL development and execution – Large file migration Project. During the Commissioning Phase of the project developed and executed solution for loading technical and other project documents into the Hatch workshare as well as for data/document handover to Client.
Raventhorpe Nickel Mine
2007 - 2008
ETL development and execution – Large file migration Project. As a member of BHP Technical Document Management support team, I was assigned to assist in document migration to new document managements systems.
BHP Iron Ore Poject
2006 - 2007
HATCH IN HOUSE PROJECTS
2008-2010
Data Management Consultant – On top of client work, I also contributed to Hatch's internal operations, working on project estimates, forecasting, resource planning and utilization, materials management, costing – either in a development or execution and support role
SALMAT Work and Projects
2002 - 2006
Programmer – Variable data printing unit. Everyday work at SALMAT was actually a large scale Mail Merge for printing on Xerox industrial printers. Data preparation, however, was pretty involved since data was coming from various unstructured, semi-structured as well as structured sources. Cleansing, deduplication, restructuring and enhansments, as well as customer segmentation, were everyday tasks at this job.