William Librata

Alfred Health is the main provider of health services to people living in the inner south-east suburbs of Melbourne and a major provider of specialist services across Victoria, operating three facilities: The Alfred, Caulfield, and Sandringham.

• Responsible for delivering analytics solutions around real-time data movement and cloud migration.
• Collaborated with the Analytics Partnering team to deliver advanced analytics projects.
• Developed a near real-time NLP data pipeline.
• Enhanced data warehouse functionality.
• Designed and implemented cloud infrastructure using Infrastructure as Code (IaC).
• Developed the data warehouse semantic layer using DBT.
• Designed and developed cloud migration strategy.
• Proactively monitored and maintained both on-premise and cloud data warehouse environments.

• Worked within the Knowledge Management team providing technical capability and support to maintain data integrity in the data warehouse.
• Collaborated with the Analytics Partnering team to deliver cloud-based analytics solutions.
• Designed and developed robust, scalable data pipelines using Python and Azure serverless technologies to process structured and semi-structured data.
• Developed a Power BI report for a Mental Health dashboard.
• T-SQL programming and development in MS SQL Server.
• Created ETL packages to cater to regular automated data requests.
• Performed quality checks on reports and exports to ensure data quality.
• Held full responsibility for data integrity in the data warehouse system, monitoring reliability and availability.
• Extracted data for data registries, research, and other business and ad hoc purposes.
• Performed database performance tuning as required.

illion (formerly Dun & Bradstreet Australia) is a data analytics company and one of the largest independent data providers in Australia and New Zealand, well known as a consumer and commercial credit score provider and debt collection agency.

• Worked in the database team as part of Enterprise IT, primarily as a data specialist across data modeling, ETL pipelines, data warehousing, data lakes, and online reporting.
• Developed automated, complex, high-performing ETL pipelines both in the cloud (AWS) and on-premise (SSIS).
• Designed, built, and maintained data warehouses in the cloud (AWS Redshift) and on-premise (SQL Server).
• Designed, built, and maintained a data lake in AWS using Lambda and S3.
• Worked closely with data scientists to deliver machine learning solutions using SSIS and Python.
• Performed SQL Server performance tuning for both OLTP and OLAP environments.
• Built, set up, and configured new SQL Server instances for OLTP and OLAP environments.
• Developed database objects (triggers, stored procedures, functions) via T-SQL programming.
• Developed online reporting solutions using SSRS.
• Performed data modeling.
• Secured data using database encryption, SSL connections, data masking, and database auditing.
• Designed physical database structures (partitioning, sharding) for optimum performance.
• Advised development and architecture teams on database design, performance, and disaster recovery.
• Delivered monthly sessions covering trends and best practices for the database team.

InterfaceIT was a Melbourne-based SaaS start-up building an enterprise-grade door-to-door sales mobile application for Android and iOS. In June 2016, InterfaceIT was acquired by GeoOp, a publicly listed SaaS company based in New Zealand that builds job management systems for Android and iOS.

• Worked in a small agile team developing data solutions using test-driven development methodologies.
• Focused on enriching and expanding data coverage across multiple countries using various cloud and database technologies.
• Developed ETL processes using Python to process geospatial data.
• Developed a scalable data processing framework using Python and AWS technologies including S3, Lambda, SQS, and EC2.
• Designed and built a data lake in AWS using S3 and Lambda.
• Designed and built a data warehouse on AWS Redshift.
• Researched, analysed, and acquired new datasets to expand data coverage and capabilities.
• Developed backend REST APIs using Python Django REST Framework to support the web console and mobile applications.
• Analysed and resolved data quality-related issues.
• Identified and resolved SQL Server and PostgreSQL performance-related issues.

Results Direct is a data-driven marketing services company focused on CRM, working with multinational companies such as Club21 (representing Calvin Klein and Armani), GM Holden, Hyundai, and KIA.

• Managed a team of 3 operations support members and 2 database developers.
• Responsible for accuracy and timely delivery of daily, weekly, and monthly recurring tasks.
• Provided technical support to team members when required.
• Mentored team members on database-related topics.
• Led new in-house project delivery and resource acquisition.
• Delivered monthly database-related tech talks and presentations.

• Member of the backend team responsible for automating manual production ETL processes using VBA, SQL Server, and SSIS.
• Performed root cause analysis when required.
• Developed ETL processes using SSIS.
• Automated manual processes using VBA and T-SQL.
• Ensured on-time delivery of critical reporting to clients.