About
Dynamic Business Intelligence Consultant with proven expertise in designing and implementing robust BI frameworks and database systems. Adept at streamlining data storage, developing advanced analytics solutions, and translating complex business requirements into actionable insights using Power BI, Azure Synapse, and Microsoft Fabric. Leverages strong technical acumen in ETL processes, data modeling, and data governance to enhance data accuracy and drive strategic decision-making.
Work
3rd Rock Business Solutions Pty Ltd
|Business Intelligence Consultant
Sydney, NSW, Australia
→
Summary
Led the design and implementation of comprehensive BI frameworks and database systems, streamlining data storage and reporting solutions for diverse clients.
Highlights
Automated critical data integration from SAP ERP to Azure Synapse, enabling seamless financial reporting across Power BI and Jedox for enhanced analytical capabilities.
Developed scalable ETL processes and a centralized Row-Level Security (RLS) solution via Power Apps, dynamically updating security across all semantic models to ensure data governance.
Engineered a dedicated HR Datamart within Microsoft Fabric, providing robust infrastructure for advanced workforce analytics and strategic insights.
Created an innovative Python framework to automate DAX query execution and export results to CSV, facilitating seamless external system integrations and data sharing.
Managed end-to-end data pipelines, ingesting data from AX6 and other diverse sources into warehouse tables, ensuring data integrity and supporting semantic model development.
Designed and maintained high-impact Paginated Reports for key stakeholders, accurately tracking store performance by region, sales type, and other critical KPIs.
3rd Rock Business Solutions Pty Ltd
|Junior Support Engineer
Sydney, NSW, Australia
→
Summary
Provided essential first-level technical support for critical BI tools and systems, resolving user-reported issues and ensuring optimal data accuracy and system performance.
Highlights
Monitored and maintained diverse BI systems, ensuring high data accuracy and optimal performance across Power BI, Jedox, SQL Server, SSRS, and SSIS environments.
Successfully troubleshooted and debugged complex data discrepancies, report errors, and dashboard issues, significantly improving data reliability and user satisfaction.
Collaborated effectively with BI developers and data engineers, escalating intricate issues while assisting in writing and optimizing SQL queries for data extraction and validation.
Developed and maintained comprehensive documentation for support processes, FAQs, and solutions, enhancing internal knowledge bases and team efficiency.
Provided thorough user training and onboarding for BI tools, empowering clients and internal teams to effectively leverage data analytics solutions.
Actively participated in rigorous testing and validation phases for new BI reports and dashboards, ensuring high quality and readiness for deployment.
Education
University Of New South Wales
→
Bachelor
Computer Science
Sydney Technical High School
→
High School Certificate
HSC
Grade: ATAR 98.4
Languages
English
Certificates
Power BI Data Analyst Associate
Issued By
Microsoft
Anaplan Certified Model Builder
Issued By
Anaplan
Fabric Analytics Engineer Associate
Issued By
Microsoft
Skills
Database & Data Modelling
SQL Development, Synapse Data Warehouses, Fabric Data Warehouses, Stored Procedures, Views, Tables, SSAS Tabular Models, Cube Processing, Semantic Model Development, Microsoft Fabric, Relationship Management, DAX Measures.
ETL & Data Integration
Azure Synapse, M Query, Fabric Pipelines, Data Ingestion, Data Transformation.
Power BI & Fabric Expertise
Power BI Desktop, Paginated Reports, Power BI Report Builder, Row-Level Security (RLS), Azure AD/Entra ID, Standalone Datamarts, HR Analytics, Fabric Automation, Dataflows, Pipelines, Python Notebooks.
Peripheral Systems & Tools
Jedox, Power Apps, Dynamic Data Entry Forms, Master Data Management.
Business & Collaboration
Executive Requirements Translation, BI Solutions, Stakeholder Communication, Reporting Needs, KPI Tracking.
Programming & Web Development
Python, React, React-Router, Tailwind-CSS, Unity, Visual Basic, Data Structures & Algorithms (DSA), LeetCode.
Interests
Hobbies
Reading, Gaming, Fitness (Strength Training & Running).