Summary
Overview
Work History
Education
Skills
Websites
Clubs Organizations Societies
Certification Training
Timeline
Generic

Shrey Soni

Data Engineer
Brisbane

Summary

Results-driven data engineering professional with solid foundation in designing and maintaining scalable data systems. Expertise in developing efficient ETL processes and ensuring data accuracy, contributing to impactful business insights. Known for strong collaborative skills and ability to adapt to dynamic project requirements, delivering reliable and timely solutions.

Overview

5
5
years of professional experience
7
7
years of post-secondary education

Work History

Data Engineer

Howard Smith Wharves
Brisbane, QLD
05.2024 - Current
  • Company Overview: https://howardsmithwharves.com/
  • Designed and implemented automated ETL pipelines in MySQL, transforming raw hospitality data into structured formats for analytics
  • Developed SQL scripts and stored procedures to handle data extraction, transformation, and loading (ETL) workflows, reducing manual intervention
  • Optimised data transformation logic in MySQL to efficiently clean, aggregate, and normalize large datasets
  • Automated data ingestion processes, ensuring real-time or scheduled updates from source databases to Power BI dashboards
  • Designed and maintained logical and physical data models in MySQL and Power BI, optimising table structures and relationships for scalable reporting and analytical performance
  • Integrated Power Query transformations with Power BI data models, streamlining the visualization process and improving performance for end-users
  • Built data validation checks to ensure accuracy and integrity across all automated processes
  • Collaborated with cross-functional teams to understand business reporting needs and automated repetitive data workflows for efficiency
  • Https://howardsmithwharves.com/

Volunteer

CQUniversity
Brisbane, QLD
03.2022 - 03.2024
  • Assisted with special events and programs.
  • Maintained clean, neat, and operational facilities to serve program needs.
  • Supported engaging, fun, and smooth-running events by helping with organization and planning.
  • Used strong interpersonal communication skills to convey information to others.

Data Engineer - University Internship

Securemation
Brisbane, QLD
11.2023 - 01.2024
  • Company Overview: https://www.securemation.com/
  • Part of CisoZen product development team that delivers various offline cyber security services to all our subscribed clients
  • Worked on the ETL pipeline using SQL, Python, and Talend Open Studio for ingesting cybersecurity data from Azure file system to SQL server
  • Transformed raw cybersecurity data through data cleaning and transformation processes and loaded it to SQL server to prepare it for analysis and actionable insights
  • Integrated network traffic logs, security event logs, system logs, and threat intelligence feeds by importing data from SQL Server into Power BI for comprehensive analysis and visualization
  • Leveraged Power BI for data visualization, creating interactive dashboards and reports to provide actionable insights from the transformed data
  • Collaborated with senior engineers to meet data requirements and provided regular reports on data flow using Power BI
  • Utilized Azure DevOps to efficiently manage user stories, descriptions, acceptance criteria, and tasks, ensuring streamlined project management
  • Actively participated in daily stand-up meetings to address task progress, daily focus, blockers, and lessons learned, enhancing team communication and project tracking
  • Https://www.securemation.com/

Junior Data Analyst

Divine Cloudland Services
Brisbane, QLD
10.2020 - 02.2022
  • Company Overview: https://divinecloudlandservices.com/
  • Collected, managed, and maintained large datasets from Electronic Health Records (EHR), ensuring data integrity and accessibility
  • Identified trends, patterns and correlations in healthcare data, providing actionable insights to support decision-making processes
  • Developed interactive visualizations and dashboards using Power BI, facilitating data-driven decision-making
  • Collaborated with cross-functional teams to understand data needs and deliver actionable insights, enhancing operational efficiency
  • Executed complex queries and joined tables in MYSQL to meet specific data requirements, ensuring comprehensive data analysis
  • Https://divinecloudlandservices.com/

Education

Master of Information Systems -

Central Queensland University
Brisbane, QLD
03.2022 - 03.2024

Graduate Diploma of Information Systems - undefined

Central Queensland University
Brisbane, QLD
03.2022 - 06.2023

Bachelor of Engineering (Civil) - undefined

Gujarat Technical University
08.2014 - 06.2018

Skills

  • Python

  • SQL

  • Power BI

  • Tableau

  • Advanced Excel

  • Talend Open Studio

  • Click Up

  • Jira

  • Azure DevOps

  • Time management

  • Adaptability

  • Problem solving

  • Work ethic

  • Critical thinking

  • Verbal communication

  • Written communication

  • Listening skills

ETL development

Data pipeline design

Data modeling

Data warehousing

Websites

Clubs Organizations Societies

  • Central Queensland University CQUUNIMOVES Club, Active Member, 2022, Present
  • Central Queensland University ICT Society - CQUICTS, Member, 2022, Present
  • The Australia Computer Society (ACS), Student Membership, 2023, Present

Certification Training

Databricks Certified Data Analyst Associate, 09/01/24, Link

Timeline

Data Engineer

Howard Smith Wharves
05.2024 - Current

Data Engineer - University Internship

Securemation
11.2023 - 01.2024

Volunteer

CQUniversity
03.2022 - 03.2024

Master of Information Systems -

Central Queensland University
03.2022 - 03.2024

Graduate Diploma of Information Systems - undefined

Central Queensland University
03.2022 - 06.2023

Junior Data Analyst

Divine Cloudland Services
10.2020 - 02.2022

Bachelor of Engineering (Civil) - undefined

Gujarat Technical University
08.2014 - 06.2018

Similar Profiles

CREATE PROFILE
Shrey SoniData Engineer