Ahmed Ugool
Canberra,ACT
Summary
Motivated and logical individual talented in data analysis, data modelling, and data reporting. Experienced in using various tools such as SQL, R-studio, Databricks, Python, SAS and MS Excel to obtain insights from data. Proven history of developing actionable insights from data to drive business decisions.
Overview
6
6
years of professional experience
Work History
EL1 - Data Analyst
Department of Employment and Workplace Relations
03.2023 - Current
- Worked within the VET Fee Help Redress Measures.
- Applied advanced SQL techniques to extract, transform, and analyze large datasets from multiple internal and external sources, ensuring data accuracy and consistency in reports.
- Wrote complex SQL queries utilizing joins, subqueries, and window functions to retrieve and manipulate data across various relational databases for in-depth analysis.
- Automated SQL scripts to streamline and enhance data extraction processes, improving the efficiency of reporting and reducing reliance on manual methods.
- Defined data requirements and reporting specifications through SQL-driven insights, ensuring that business stakeholders received relevant and actionable data aligned with operational objectives.
- Regularly optimized SQL queries by reviewing execution plans, refactoring code, and applying indexing strategies to improve query performance and data retrieval times.
EL1 - Senior Data Analyst
Jobs And Skills Australia
02.2022 - 02.2023
- Worked within the Nowcasting and Economic Modelling Section
- Utilized SQL and Databricks extensively to develop and maintain Nowcasting dashboards and scenario modeling frameworks, extracting data from multiple sources to support real-time economic forecasts and trend analysis.
- Collaborated with Westpac Group on the implementation of new data products, leveraging SQL for efficient data extraction, transformation, and integration into existing systems.
- Leveraged Microsoft Azure and Databricks for large-scale data processing, employing SQL alongside cloud-based technologies to streamline data pipelines and analytics workflows.
- Conducted in-depth coding and data analysis using SQL, R-Studio, and Power BI, ensuring comprehensive data insights and visualizations for stakeholders.
APS6 - Senior Data Analyst
Department Of Education, Skills And Employment
09.2021 - 02.2022
- Worked within the Compliance Caseload Review Section
- Conducted deep data analysis of the JobSeeker program and the targeted compliance framework using advanced SQL queries to extract and analyze large datasets for identifying trends, patterns, and compliance anomalies.
- Delivered comprehensive SQL-driven reports that highlighted key insights and actionable findings, presenting these to senior management for critical decision-making purposes.
- Liaised with the Department of Social Services, exchanging data products and responding to data requests by leveraging SQL for efficient data retrieval and transformation.
- Managed urgent, time-sensitive data requests—often following natural disasters or large-scale government decisions—by employing SQL and other tools to rapidly extract, clean, and deliver accurate datasets.
- Utilized various data tools, including Microsoft SQL, Qlik, SAS, and Excel, for in-depth analysis, reporting, and data visualization.
APS4 - Revenue Analyst
Australian Taxation Office
07.2020 - 09.2021
- Collaborated with the JobKeeper Stimulus Reporting Section and Individuals Policy Section, delivering daily reports and in-depth analysis on the JobKeeper Program across various demographic and data splits.
- Acted as a liaison with the Department of Treasury, managing multiple phases of JobKeeper reporting and responding to ad hoc requests.
- Conducted external policy costings, departmental financial analyses, and assessed revenue impacts of models in partnership with the Department of Treasury to contribute to the Tax Benchmarks and Variations Statement.
- Advanced my SQL and Teradata expertise to streamline data extraction and reporting.
- Developed a high level of proficiency in Excel, leveraging its capabilities to manipulate, present, automate, and analyze complex datasets effectively.
Junior Economist
Department of Education, Skills and Employment
02.2019 - 06.2020
- Contributed to the Labour Economics Section and the Small Business Financial Policy and Data Section, focusing on economic analysis and policy development.
- Gained extensive experience in labour economics analysis using datasets from the ABS, OECD, and World Bank.
- Conducted in-depth analysis of small business trends and supported the implementation of federal government policies.
- Completed an independent research project examining small business access to finance.
- Developed and implemented economic models to forecast key macroeconomic variables, enhancing strategic planning and decision-making processes.
Education
Bachelor of Economics -
Australian National University
06.2018
Skills
- Structured Query Language (SQL)
- Data Analysis
- Databricks
- Microsoft Excel
- Analytical Problem Solving
Timeline
EL1 - Data Analyst
Department of Employment and Workplace Relations
03.2023 - Current
EL1 - Senior Data Analyst
Jobs And Skills Australia
02.2022 - 02.2023
APS6 - Senior Data Analyst
Department Of Education, Skills And Employment
09.2021 - 02.2022
APS4 - Revenue Analyst
Australian Taxation Office
07.2020 - 09.2021
Junior Economist
Department of Education, Skills and Employment
02.2019 - 06.2020
Bachelor of Economics -
Australian National University
Similar Profiles
Evaristo ChuaEvaristo Chua
APS6 Senior Program Officer at Department of Employment and Workplace RelationsAPS6 Senior Program Officer at Department of Employment and Workplace Relations
Reese SalmonReese Salmon
Senior Intelligence Analyst (APS 6) at Department of Employment and Workplace RelationsSenior Intelligence Analyst (APS 6) at Department of Employment and Workplace Relations
Jay MattnerJay Mattner
Project Officer (APS5)/Fire Warden at Department of Employment and Workplace RelationsProject Officer (APS5)/Fire Warden at Department of Employment and Workplace Relations
Thomas CurrellThomas Currell
Assistant Director (a/g) at Department of Employment and Workplace RelationsAssistant Director (a/g) at Department of Employment and Workplace Relations
Shobita battaShobita batta
Graduate Registered Nurse at North Canberra HospitalGraduate Registered Nurse at North Canberra Hospital