Tasked with implementing a consolidated Datamart to assist the bank with a consolidated view of its operations processes.

Was responsible for assisting Dev Ops in implementing an incremental build and deployment process for a series of Microsoft SQL Server databases. The solution was constrained by a series of challenges such as delineating between out-of-the-box objects and custom database objects, and handling schema comparisons on databases containing over 40 thousand objects. The CICD solution used a combination of Octopus Deploy, Team City, SQL Server Data Tools and powershell. In addition to the above… Show more Was responsible for assisting Dev Ops in implementing an incremental build and deployment process for a series of Microsoft SQL Server databases. The solution was constrained by a series of challenges such as delineating between out-of-the-box objects and custom database objects, and handling schema comparisons on databases containing over 40 thousand objects. The CICD solution used a combination of Octopus Deploy, Team City, SQL Server Data Tools and powershell. In addition to the above task also assisted in various pieces of database optimisation work and data modelling new pieces of work. Show less

The operations arm of Westpac is a compilation of various disparate brands and teams which have evolved independently of each other. The insights team which I was a part of was responsible for developing and maintaining an Operations Datawarehouse which would provide unified reporting for these various applications in a common and consistent way.During this time my key contributions were:• Gathering requirements for new reports, ETLs and processes, typically assisting the business… Show more The operations arm of Westpac is a compilation of various disparate brands and teams which have evolved independently of each other. The insights team which I was a part of was responsible for developing and maintaining an Operations Datawarehouse which would provide unified reporting for these various applications in a common and consistent way.During this time my key contributions were:• Gathering requirements for new reports, ETLs and processes, typically assisting the business in determining exactly what it is they need to achieve. Often this would be challenging as it would involve customers looking for us to implement a solution they believe they already have arrived at, and often the difficult task would be diplomatically helping them work through their objectives to arrive at a different set of requirements. • As technical team lead, it was my responsibility to ensure that all developers had the support they need to perform their job. All development was being performed by offshore partners in India, which provided additional barriers of needing to work largely via phone and email, understanding cultural differences and working in offset time zones. I believe I had a very strong rapport with all team members and have helped them develop into better programmers. • Designed an ETL Framework using BIML. This framework served to significantly reduce time to build and ensured all development was standardised. Cost of maintenance also massively reduced due to standardisation of packages and bugfixes were easily rolled out to all affected modules. Show less

• Designing technical specifications for developers to fulfill the requirements above. Due to the time zone differences mentioned previously as well as the fact the developers often had wide ranging technical abilities and often a lack of communication skills, detailed yet concise designs were always of paramount importance. • A regular responsibility would be to provide ad-hoc insights where existing reports didn’t provide the ability to find the answers the customer needed. Due to the… Show more • Designing technical specifications for developers to fulfill the requirements above. Due to the time zone differences mentioned previously as well as the fact the developers often had wide ranging technical abilities and often a lack of communication skills, detailed yet concise designs were always of paramount importance. • A regular responsibility would be to provide ad-hoc insights where existing reports didn’t provide the ability to find the answers the customer needed. Due to the many different systems and processes involved, often this would involve rapidly reverse engineering a data model or ETL to provide the required insight in the required timeframe. Show less

Blueshift have developed a system which helps manufacturers analyse the demand profiles of their product range, in particular with respect to fluctuations of demand following the application of promotional activity.This system incorporates a java GUI with reporting being sourced either through Excel pivot tables connecting to a SSAS engine or SSRS web based reports. Source data is loaded via customised interfaces developed in SQL server and automated on a schedule, and outbound… Show more Blueshift have developed a system which helps manufacturers analyse the demand profiles of their product range, in particular with respect to fluctuations of demand following the application of promotional activity.This system incorporates a java GUI with reporting being sourced either through Excel pivot tables connecting to a SSAS engine or SSRS web based reports. Source data is loaded via customised interfaces developed in SQL server and automated on a schedule, and outbound interfacesexport data into other systems in a similar manner.During this time, my key contributions were:• Fulfilled the role of implementing Blueshift’s core product for new customers. This involved both solutioning and engineering technical design to fulfil the project’s requirements, as well asleading the technical aspects of ETL development importing and exporting data to third party systems. This ETL development was typically constructed using stored procedures utilising linkedservers or BCP to import flat files, and at times included the use of SSIS. During my time at Blueshift I was involved in a total of 10 implementations.• Developed a framework of stored procedures to both streamline the effort required for the implementations described above and improve reliability and maintainability. This framework handledcommon tasks of loading data from flat files, excel, caching and archiving source data and various other common tasks.• Implemented a Continuous Integration strategy using Cruise Control and later Jenkins which took any changes committed to the SVN repository and deployed these to a test environment. Unittests were then executed and results sent to contributors in the case of deployment or test failure. The deployments included both java and database artifacts. Show less

Formed a business with a colleague from former occupation at Sony Music Entertainment. This business focussed on the development of JEE solutions and web applications and provided a wide array of solutions ranging from small business websites all the way to complex eCommerce solutions for numerous clients. Responsibilities included Project Management, Team Leading, Consultant, Architect and Senior Developer. Key Technologies included: - JEE Application Servers… Show more Formed a business with a colleague from former occupation at Sony Music Entertainment. This business focussed on the development of JEE solutions and web applications and provided a wide array of solutions ranging from small business websites all the way to complex eCommerce solutions for numerous clients. Responsibilities included Project Management, Team Leading, Consultant, Architect and Senior Developer. Key Technologies included: - JEE Application Servers (Tomcat, JBoss & Websphere), - HTML, Javascript & AJAX - Struts & Spring, - Web Services (SOAP & REST), - Cruise Control and ANT Show less

Worked as part of a team of 3 to develop a new portlet-style web application to allow web designers to self-manage and maintain websites for all of their artists. As well as this, we also developed a content management web application to easily build and maintain all data for the above web application, and a scheduled task framework to handle background tasks which needed to be run, such as mailouts. Key Technologies included: - JBoss - Struts - SQL Server and… Show more Worked as part of a team of 3 to develop a new portlet-style web application to allow web designers to self-manage and maintain websites for all of their artists. As well as this, we also developed a content management web application to easily build and maintain all data for the above web application, and a scheduled task framework to handle background tasks which needed to be run, such as mailouts. Key Technologies included: - JBoss - Struts - SQL Server and Oracle Show less

Worked as a lead developer in a small team tasked with migrating an eCommerce procurement application designed for the American market to the Australian market. Was also responsible for creating all builds and releases for the application, packaging and documenting all release notes and installation instructions for each release. Key Technologies included: - Weblogic Server - Java Servlets - XML and XSLT - HTML & Javascript - Oracle & Mercado SQL - OBIEDI

Provided ongoing development and support of a Vendor Managed Inventory Supply chain monitoring system for 15 customers BHP delivered bulk orders of Steel to. Also led a small team for the rapid development of a WAP prototype to assist train controllers on country freight services. This involved Java Servlets, XML/XSL, HTML/javascript, WAP/WML and other technologies. Key Technologies included: - Visual Studio (including ASP, C++, Visual Basic and VB script) - SQL… Show more Provided ongoing development and support of a Vendor Managed Inventory Supply chain monitoring system for 15 customers BHP delivered bulk orders of Steel to. Also led a small team for the rapid development of a WAP prototype to assist train controllers on country freight services. This involved Java Servlets, XML/XSL, HTML/javascript, WAP/WML and other technologies. Key Technologies included: - Visual Studio (including ASP, C++, Visual Basic and VB script) - SQL - EDI - Java Servlets - HTML & javascript - WAP / WML. Show less