At SA Engineering Group, we have extensive experience providing top-notch services in Data Engineering and Project Controls across various industries. Below are the sectors we've worked in, showcasing our expertise and successful project outcomes:

1- Transport

2- Pharmaceutical

3- Airline

4- Water

5- IT & Banking

6- Telecommunications

7- Media Agencies

8- Retail

We have successfully completed projects in the transport industry, delivering innovative solutions and enhancing operational efficiency. Some of our notable projects include:

1- ROC Program in Sydney Trains ($1b)

2- Technology Projects in Transport for NSW($1.2b)

3- Timetable Program in Sydney Trains

4- Cyber Security Uplift Program in Transport for NSW

We have successfully implemented an integrated project control for five new respules construction projects at the AstraZeneca manufacturing plant in Sydney. This project ($800m) highlights our expertise in providing tailored solutions for the pharmaceutical sector, ensuring efficient project management and successful project outcomes.

Troubleshooted and debugged ETL processes for Qantas and Virgin Airlines.

Developed complex Stored Procedures, Triggers, and User-defined Functions for T-SQL Queries and dynamic joins.

Designed, developed, and maintained ETL mappings and Teradata ETL scripts.

Implemented ETL solutions using Oracle Data Integrator, Teradata, and Airflow.

Conducted dimensional data modeling, star schema designs, and DevOps in AWS.

Collaborated with automation teams, provided work effort estimates, and verified solution

Collaborated with Sydney Water on their largest program of work in NSW, the Upper South Creek treatment plant.($2b)

Established a project control structure aligned with INSW requirements and Sydney Water stakeholders' needs.

Developed a consolidated project control system to capture key milestones and activities.

Assessed Upper South Creek proponents during the ECI process as part of the NEC contract.

Assisted Sydney Water in awarding the contract to the most suitable candidate.

Contributed to the successful management and execution of the Upper South Creek treatment plant project.

Various contracts across IT & Banking industry.

Created and designed ETL pipelines from scratch.

Led a team of Data Engineers.

Designed and implemented Data Lake and Data Warehouse storage for AWS/Azure.

Developed effective database solutions and models for storing and retrieving company data.

Established best practices for naming conventions and coding standards for data models.

Conducted data modeling for cloud data warehouses and designed Snowflake Staging and Target databases.

Integrated data using Talend ETL processes for SQL/Snowflake/Oracle databases.

Collaborated with NSW Telco Authority on a $1.2 billion program.

Established a consolidated program control structure to manage schedule, risk, and cost effectively.

Improved reporting structures for enhanced project monitoring and decision-making.

Implemented robust project management practices to ensure successful execution and delivery.

Contributed to the efficient management of the CCEP program, optimising outcomes and minimising risks.

We worked with Starcom MediaVest Group.

Facilitated efficient data extraction from Media System Data Warehouse through the development of stored procedures and queries.

Created queries, functions, and stored procedures in MS SQL Server database for data management.

Spearheaded ETL processes using SQL Server Integration Services (SSIS) for data transformation and loading.

Implemented ETL processes in MYSQL to import data into a central database.

Transferred data from APIs and web interfaces to SQL server database via SSIS packages.

Monitored and troubleshooted SQL Server performance, and managed backup/recovery and performance tuning for SQL server databases.

Cleaned, created, and designed new databases according to organizational requirements.

Utilized Windows/Linux PowerShell programming and provided professional assistance in test strategy, plans, scenarios, and scripts development.

Ensured database security, confidentiality, and data loss prevention through backup and disaster recovery plans.

Gathered business requirements from end users and line managers, and conducted user acceptance testing.

Implemented logging, error handling using Event Handler, and Custom Logging for SSIS Packages.

We worked with Woolworths Group.

Led a team of Data Engineers and Data Analysts.

Designed and implemented an ETL Architecture Framework.

Developed, tested, and deployed ETL solutions using Oracle Data Integrator and Teradata.

Designed, built, and maintained CI/CD infrastructure using Jenkins.