Dayl Brack Email & Phone Number

Newcastle, New South Wales, Australia

• Technical Data Lead on the Data Governance project. Major outcome is the automated Data Lineage linking across multiple technologies (SSIS, Snowflake, SSRS, SQL Server, Oracle, Qlik Replicate) that displays at the Business, Systems or technical levels.• Developed the Credit Card component of the Open Banking system. This involved loading data provided by an external company into first SQL Server then to Snowflake.• Worked with the Risk team to extend the Mortgage Stress Test System using SSIS\SQL Server.

Newcastle, New South Wales, Australia

• Worked with the Reporting Specialist to design the Data Lake for incremental loading.• Automated the loading of the data lake using SSIS with packages run on the SQL Server.• Established DEV and PROD systems to replace the current PROD only system.• Upskilled the Reporting Specialist to maintain and extend the Data Lake framework.

Newcastle, New South Wales, Australia

• Overall responsibility for the NZ Data Warehouse.• Designed and created the NZ Efficient Market Pricing Mart using SSIS in consultation with the business users.• Lead the migration of NZ data warehouse load processes from DTS to SSIS. I designed the tableau replacement system to the existing Cognos reports.• Mentored other data warehouse people in the system design and operation.• Mapped and refactored the NZ legacy weekly and monthly data warehouse processes. This identified true dependencies and reduced the processing time by 30%.• In 2019 completed the Certified Data Vault Data Modeler course.• Worked with propriety software to load the data Vault into Snowflake. Recently changed some of the proprietary loading to DBT.• Designed the data vault for the Product information.• Designed several Business Data Vault objects including age calculations, country determination and cover movements.• NIB acquired GU Health Pty Ltd in 2018 and I integration of serval systems their systems into the NIB core framework. This include the Profit and Loss SSAS cube.

Newcastle, New South Wales, Australia

• I evaluated scheduling options before choosing and implemented the ActiveBatch scheduler. I created standard templates to use with ActiveBatch to run various systems including SSIS, DataStage, SAS, Business Objects, SQL, PowerShell, Python, FTP and emails.• Designed numerous ETL processes in SSIS and DataStage to load various databases.• Migrated the database platform from IBM Informix to MS SQL 2014.• Worked with the Premium Processing Team to automate the Broker Commissions process.• Mapped and refactored the entire process flow for source system clone processing that optimised the process paths and reduced processing time by 40%.

Newcastle, New South Wales, Australia

• Designed the Product Catalogue database by working with Product Subject Matter Experts to.• Provided access to the data to application developers and other data systems via views and scheduled data transfers.

Newcastle, Australia

• Worked with users to provide Ad-hoc reports to meet their requirements.• Designed and Implemented several Business Objects Universes. Trained users in the use of Busines Objects to create their own reports returning the correct information. This effort was recognised with the yearly Internal Service Award 2012.

Auckland, New Zealand

• Worked with the Taxation Subject Matter Experts where I created the GST Mart, which was used in the banks tax returns. Implemented a Business Objects Universe for this and trained the tax users to use the system to get the correct results.• Implemented several bank wide reports using SSRS. (2020 – did a SSRS refresher course)• Involved in the evaluation of Wherescape Red, a ELT system that supplemented SSIS.• Tools Used: SAS, HTML, XML, SQL Server 2005/2008, T-SQL, SSIS, SSAS, SSRS, Business Objects, Oracle, PL\SQL, Wherescape Red.

Auckland, New Zealand

• I designed and implemented a reporting system that delivered reports and allowed the determination of which reports were actually being used.• Developed a job scheduling system which resulted in the automation of over 1000 new and legacy processes that virtually eliminated active support. This included the database design, back-end application that operated 24/7 and the user interface.• Tools Used: .NET C#, IIS,

Auckland, New Zealand

All aspects of website maintenance. Lead developer in the KnowledgeNet project.Tools: MySQL, PHP, .NET

Auckland, New Zealand

While studying at University in Software Engineering I worked part time with the Navy in revamping their intranet. This involved in working with over a dozen departments in either designing their website or mentoring people in those departments to do the design themselves.Tools: Coldfusion.

Auckland, New Zealand

As the Technical Manager I had 10 staff and was responsible for running of 10 hardware laboratories for 30 Academic Staff and over 400 students. I was also responsible for Operating and Capital Expenditure Budgets.

Auckland, New Zealand

I maintained Unix and Linux Systems and supervised 1 full time and 1 part time staff members.

Auckland, New Zealand

Initially implemented a Novell Network.Tools: Novel (CNE), Unix, Linux, MS Access, FileMaker Pro,

Brisbane, Queensland, Australia

Modems, Fujitsu 4745 front-end processors, Honeywell's Datanet 8, Bridge\3com Network Equipmen

Brisbane, Queensland, Australia

Cobol, Pascal, Fortran

Canberra, Australia

Software Development in a Finance area.Tools: Cobol, JCL

Graduate Diploma In Information Technology, (Software Engineering)

Activities and Societies: Graduate Student Representative

Associate Diploma In Business Computing