Adam Gilmore Email & Phone Number

Brisbane, Queensland, Australia

The Asset Value and Optimisation (AV&O) Project aimed to optimise Essential Energy’s annual $500M network investment spending. I was the solution architect and lead technician on the project. The optimisation generated 50B risk values for electrical network assets. The risk values were passed via data integration to an investment management system used by.

Remote

Essential Energy was upgrading its data and analytics platforms, migrating from on-premises SQL Server to Azure Synapse. I was employed as a data solution architect to deliver solutions on the platform. I first focused on improving the maturity of the data platform architecture, standards, and delivery practices before being seconded to the Asset Value and.

Brisbane, Queensland, Australia

• Bolton Clarke is Australia's largest not-for-profit Aged Care provider, serving tens of thousands of clients with 6000 staff and over 3 million visits annually. After a long association with Bolton Clarke as a.
• Definition of the Data Management… Show more Bolton Clarke is Australia's largest not-for-profit Aged Care provider, serving tens of thousands of clients with 6000 staff and over 3 million visits annually. After a long.
• Definition of the Data Management Architecture describing ETL patterns and modelling standards.
• Creating the technical architecture for a modern cloud data warehouse based on Azure Synapse Analytics and Azure Data Lake.
• Creating a migration plan from existing on-premises data warehouses to the cloud.
• Creating a technical architecture for reference master data.

Brisbane, Queensland, Australia

• Flight Centre embarked on a multi-year uplift of its reporting and analytics function. I was employed as a Data Modeller. I worked with internal stakeholders to understand the procurement and wholesale travel.
• Liaising with business stakeholders to understand both requirements and business processes.
• Analyse existing models, source systems, and reports to understand requirements, business processes, and data sources.
• Developing an ontology and conceptual model, including definitions for business processes, business entities, facts, dimensions, measures, attributes, and relationships. Effectively, a Data Warehouse data catalog and.
• Creating and deploying logical and physical data models for the Data Warehouse- phase 1. The target platform was Azure SQL Database.
• Developing a semantic model for the Data Warehouse (PowerBI shared data set), including calculated measures.

Brisbane, Australia

• Dimodelo Solutions is a small Data Warehouse consulting firm that created the Dimodelo Architect Data Warehouse Automation tool. Principal Consultant role:In my role as principal consultant, I completed several.
• Defining the Product direction, features, functionality and design to meet market need. The latest version supports a modern cloud data warehouse architecture targeting Azure Data Lake and Azure Data Warehouse (now.
• Writing Marketing and Training materials. Training material included both general data management and product-specific training. Marketing material included blog posts and copywriting.
• Technical sales. As a technical support representative, I participated in remote sales calls, providing sales advice and demonstrations. I also engaged with various Microsoft Sales and Product teams to promote the.

Brisbane, Queensland, Australia

Ergon wanted to improve its internal and regulatory reporting and analysis of the impact of network outages.I worked within the project team and liaised with the business, development teams, enterprise architecture, etc., to develop a conceptual, logical and physical data warehouse data model that conformed to an enterprise industry-standard data model and.

Brisbane, Queensland, Australia

• StrataDB is a boutique Microsoft Business Intelligence consultancy. I work as a Data Warehouse and Business Intelligence consultant for the company. I was involved in the development of consulting proposals..
• Salad Fresh—Fast-moving Consumer Goods - Food. Modifications to their Sales and Sales Forecasting Data Warehouse and Business Intelligence cubes. Microsoft platform, SSAS, and SSRS.
• Industry Data Online - BI Solution provider to Clubs in Australia. The first… Show more StrataDB is a boutique Microsoft Business Intelligence consultancy. I work as a Data Warehouse and Business Intelligence.
• Industry Data Online - BI Solution provider to Clubs in Australia. The first engagement was to build a pilot Data Warehouse and Cube to replace their existing Club Data Online product. Both Finance (i.e. GL) and Gaming.
• Assisted Toowoomba Regional Council set up their SSRS Enterprise Reporting Platform.
• US Census Population Projections Cube used for Media buying. Show less

Brisbane, Queensland, Australia

Ergon wanted to improve its internal and regulatory reporting and analysis of the impact of network outages.I worked within the project team and liaised with the business, development teams, enterprise architecture, etc., to develop a conceptual, logical and physical data warehouse data model that conformed to an enterprise industry-standard data model and.

• TRANSMAX develops the software that is used to control and monitor most traffic lights in Queensland, as well as parts of Victoria and South Australia. TRANSMAX initially employed me on a short-term basis to develop a.
• Developed a BI Proposal for the Dept Main Roads.
• Development of a Solution Architecture.
• Analyse, design, and Develop the data warehouse, ETL, and cube with complex MDX. Development of Excel and Reporting Services reports.
• Presentations to support the Sales process to various organisations, including Senior managers of all State traffic authorities and Private Road Network Operators.
• Created a product description document for marketing purposes. Show less

Brisbane, Queensland, Australia

• The Queensland Police Service employed me as the Data Warehouse Architect on the Intelligence Traffic Analysis Systems (ITAS). ITAS was a new application being developed by QPS. The Data Warehouse extracted data from.
• 6-week proof of concept.
• Data… Show more The Queensland Police Service employed me as the Data Warehouse Architect on the Intelligence Traffic Analysis Systems (ITAS). ITAS was a new application being developed by QPS. The Data Warehouse.
• Data Warehouse development Planning and High-level Data Warehouse Matrix.
• Defined Enterprise Data Warehouse Architecture and Development Patterns.
• Interviews and Employed 4 Data Warehouse and BI specialists.

B. App. Sc, Computing

Education record