Melbourne, Victoria, Australia
An accomplished, self-driven Data Engineer with over 16 years diverse experience in Retail, Marketing, Logistics, Medical Aid, Insurance and Child Care industries; specialising in SQL, Data warehousing, BI and Azure systems. I am forward thinking and have a passion for solving large complex technical problems, data analysis and process optimization. Dedication, professionalism and an unrivaled work ethic are key to my personal character.
Agile SQL Architect, Analyst and Developer • Engage and collaborate with business stakeholders to gather BI, reporting and data requirements for the booking, marketing, HR, payroll and financial systems • Training and mentoring junior SQL Developers • Design, develop and maintain new Data Warehouse, Data Dictionary and ETL processes to enable operational dashboards. • Assisting data teams with data analysis and reporting tools using SQL, SSRS, Tableau, Snowflake and PowerBI • Administration of Azure Database, Azure Data Lake Gen 2 and blob container storage • Develop, implement and fine tune schema data structures and stored procedures • Proactively define and implement strategies that optimize data efficiency, quality and identify process or technology improvements • Managing versioning using source-control (Git) • Daily involvement in agile delivery methodologies
Agile Database Architect in a Marketing environment responsible for analyzing requirements, creating, modeling and maintaining the database structures within MS Azure. • Created an ETL framework based on SSIS projects to automate uploads of our client’s data into MS Azure database. • Built Powershell scripts to regularly retrieve our client’s files from sftp sites to upload data from Excel/CSV into database. • Developed SQL Server procedures to transform, calculate leader board rankings and incentive earnings per member across all clients and load this data into our M8 loyalty programs data model. • Collaborate with a .Net development team to ensure efficient methods of data retrieval and manipulation. • Analysis and requirements gathering for a new data warehouse BI solution • Created database views for our reports development team to use for Yellowfin RCube • BI extracts
Lead Architect in Supply Chain and Logistics team responsible for analyzing, designing, documenting and implementing large, complex technical solutions. • Provide expertise to all levels of business (including directors, business analysts, project managers and operations managers and staff); to identify and translate system requirements into software design documentation, including Wireframe and UML designs. • Provide technical oversight, training and guidance to the development team. • Design for all areas of the business such as merchandising, accounting, marketing and ERP and third party (3PL) systems. • Establish standards for software architecture and design - TOGAF. • Conduct and lead design sessions to help stakeholders collaborate with development teams on design decisions. • Collaborate with Project Managers to provision estimates, develop overall implementation solution plan, and serve as a lead as required, to implement the installation, customization, and integration efforts. • HighJump (Warehouse Management System) development. • SQL and Oracle Development, Design and strategize including table partitioning, ETL SSIS packages using BCP, Archiving, Integration using XML, SOA, WSO2, ESB and web services. • Maintenance of and Integration of the Product Lifecycle Management (PLM) system (Tradestone) database with host Allocation, Planning and ordering systems. • Creating and implementing business rules using JRules for the PLM system. • Database maintenance & improvements of in-house ERP and Point-of-sale system • SQL and DC team standby support.