Adam Mcguinness Email and Phone Number
Adam Mcguinness work email
- Valid
- Valid
- Valid
Adam Mcguinness personal email
- Valid
Adam Mcguinness phone numbers
Recent Projects:- Headed, planned, designed, enabled and transitioned customer facing legacy reporting solution to Power BI.- Enterprise reporting high level road-map. Defined Power BI frameworks and methods to support implementation.- Led Proof of Concept to determine if Power BI is appropriate technology for upgrading and enhancing legacy reporting.- On premise to cloud (AWS) Snowflake Data Warehouse migration delivering business agility and reduction of technical overheads.- Migration of various analytics components to cloud (AWS).- Roadmap for simplification and improvement of analytics platform.Certified:- TOGAF 9 Level 2 - Data Vault 2.0 Practitioner- Data Vault Data ModelerHaving spent my formative years at the coal face, I now focus on ensuring implementations not only align to business strategy, but also remain sustainable and flexible, plus can be rolled out incrementally to provide early business value.As a result of alternative use cases and requirement maturity, I understand that information can be presented and consumed in various fashions, hence a "one size fits all" approach inevitably leads to undesirable "cottage industry" solutions. These in turn can result in informational discrepancies across the enterprise, and frequently contribute to an organisation's technical debt.Innovations I have recently conceptualised, subsequently designed and overseen architectural implementation of include a data warehouse repository based on the Data Vault method, an enterprise metadata repository, and a data acquisition pattern providing re-use opportunities during various interim states. I strive to maximise re-use opportunities, thus reduce overall investment in duplicate components across the enterprise via the definition and realisation of architectural and solution building blocks including metadata management, accurate ETL frameworks, extensible data models, SDLC methodologies, scale-able platforms, associated assessment and selection of supporting technologies and road maps.Always watching industry innovations and their related business benefits, I am an active member of the Melbourne TDWI chapter and attend relevant industry conferences.
Future Fund
View- Website:
- futurefund.gov.au
- Employees:
- 477
-
Future FundMelbourne, Vic, Au
-
Data ArchitectFuture Fund Sep 2021 - PresentMelbourne, Vic, AuSignificantly contributes to Future Fund’s data technology architecture; ensuring that it supports the Agency’s current and future business strategy and direction. This involves overseeing decisions on policies, principles, services, roadmaps, standards, guidelines, and solutions for the betterment of the Future Fund as well as guiding the process of planning acquiring, building, modifying, and deploying technology.
-
Data Warehouse, Analytics Platform & Bi ArchitectNps Medicinewise Jul 2017 - Sep 2021Created architecture to migrate constrained on-premise data warehouse to cloud (AWS) data warehouse service Snowflake resulting in improved reliability and business responsiveness. Supported cloud data warehouse migration with hands on approach including assisting with reconciliation activities.Developed architecture and ran project to to move other analytics assets into AWS including data acquisition solution and SAS which is employed by NPS’ bio-statisticians and epidemiologists.Conducted thorough assessment of constrained on-premise data warehouse. Amongst other recommendations suggested evaluation of cloud options. Performed industry scan of available possibilities taking lead candidate technology to proof of concept. Shaped and led evaluation, reporting outcomes to senior stakeholders resulting in accepted recommendation to migrate in pursuit of business efficiencies and objectives which are not available today.Improved knowledge amongst senior stakeholders of capabilities, building blocks and methods required to deliver trusted and accurate analytics products.Detailed review of business objectives dependent on the data warehouse, the warehouse’s readiness, target states and requisite transitions required to achieve business goals.Assessment of challenged bespoke visualisation portal delivering roadmap towards a sustainable solution for delivery via commercial off the shelf software.Solution architecture for realising a mastered reference data repository to transition away from random manually managed spreadsheets.
-
Delivery Lead, Architect And All Rounder - Power Bi EnablementNps Medicinewise Jul 2020 - Jun 2021Headed, planned, designed, enabled and transitioned customer facing legacy reporting solution to Power BI.Transitioned legacy customer facing reporting solution developed in a combination of SSRS and in-house custom built components to cloud based, simplified, on-line and on demand Power BI based solution.Apart from addressing business continuity risk faced due to aging technology and complex bespoke components, this project has established the foundation to modernise NPS' future reporting capabilities on an industry leading cloud technology which is far more supportable and extensible.
-
Project ManagerNps Medicinewise May 2019 - Aug 2019Led technical team to realise defined architecture for migrating and operationalising analytics assets migrated from on-premise infrastructure to AWS.
-
Data Warehouse Scrum Master - ActingNps Medicinewise May 2018 - Aug 2018Leadership of the data warehouse team via the Scrum Mastering role managing backlog, planned sprints mastered in Jira, retrospectives resulting in team methodology improvements.
-
Data Warehouse And Business Intelligence ArchitectColes Jan 2016 - Jun 2017Melbourne, Vic, AuFounded the framework for the development and operationalisation of advanced analytics resulting in increased stability of solutions and trusted outputs. Historically advanced analytics had been lacking SDLC disciplines.Designed and supervised development of the self-serve back-end building blocks facilitating user managed:- Reference data.- Business rules applied to data.These empowered users to autonomously manage aspects of their information needs without having to engage the BI team.Established target architecture for overhauling and simplifying core data warehouse information concepts, which over time had evolved into multiple redundant objects producing conflicting information and consuming unnecessary compute resources.Led a team during the proof of concept initiative scrutinising an information management and metadata tool for potentially contributing to improved management and understanding of Cole’s BI solutions. Presented recommendations to department GM to implement which were accepted and actioned. -
Solutions Manager - Business Intelligence Strategy & PlanningIag Feb 2015 - Jan 2016Sydney, New South Wales, AuEstablished BI architectural repository for capturing information about all IAG BI assets which previously resided in four different BI teams. Assists in influencing overarching design decisions and road-map definition.Inaugurated the BI enterprise data modelling capability resulting in consistent and share-able method right across IAG’s BI community. Created BI classification framework enabling the labelling of gold, silver & bronze solutions which relates to their accuracy, information dissemination and robustness plus several other characteristics.Founded method and process to oversee and approve design decisions for all major BAU and project initiatives.Conducted regular quality assurance and facilitation sessions for in-flight BI projects.Gathered input requirements to facilitate “sandpit” based prototyping BI activities. Evaluated appropriate technologies resulting in technology selection. Created implementation principles and standards. -
Senior Business Intelligence Solutions ArchitectIag Aug 2010 - Feb 2015Sydney, New South Wales, AuIntroduced the Data Vault data warehousing method to IAG resulting in:- Solution being adopted as IAG’s BI strategic data asset and then being expanded to acquire and integrate IAG’s enterprise data.- Winning the 2014 CGU excellence award for Information and Technology Services.- Methodology enabling incremental and concurrent design and development activities. - Facilitating near real-time operational reporting from CGU’s new distribution and underwriting system.__Creation of the "Enterprise Reporting and BI Target State" on a page providing the basis of the "elevator pitch". Communicates information consumption use cases, requisite foundations and data layers.Assessment of current DW/BI state and creation of roadmap to reach target state as defined by business requirements whilst addressing stakeholder concerns.Definition and design of reconciliation & quality mechanism which applies accuracy and integrity tests on data inputs and outputs which demand a high level of quality. Test results in some cases contribute to mandatory APRA submissions where accuracy of data must be proven.In collaboration with CGU's Information Governance Manager, establishment of the enterprise metadata repository provisioning business terms, their definitions and a catalogue of technical metadata providing consolidated and lineage views of BI solutions composed from data model, database, ETL and BI elements.Identification and definition of architectural and solution building blocks required to realise the above including, metadata management, ETL framework, data modelling principles, data management principles, data warehouse structures.Collaborated with infrastructure group ensuring physical platform is provisioned accordingly and fully scale-able.Application of architectural governance over implementation of business intelligence solution.Contributed to architectural process improvement within architectural team.
-
Architect - Data WarehouseSuncorp Apr 2009 - Aug 2010Brisbane, Brisbane, Au -
Data Migration Team LeadAltis Consulting Nov 2008 - Apr 2009Sydney, New South Wales, AuContracting through Altis as Data Migration Team Lead for Tru Energy’s data migration development team responsible for integrating legacy gas and electricity billing, customer, meter and other source data into the replacement centralised Oracle application. -
Senior ConsultantInformatica May 2008 - Oct 2008Redwood City, Ca, UsInvolved in pre and post sales activities providing knowledge and practical hands on implementation of Informatica products to potential and existing customers.Product compatibility, functional alignment, configuration, best practice and knowledge transfer are all in the mix. -
Etl Architect/Lead Etl DeveloperFoxtel Aug 2006 - May 2008North Ryde, Sydney, AuDesigned various star schemas utilising dimensional modelling principles in ERwin.Facilitated workshops to identify data sources and attributes required to meet subject area requirements.Created business intelligence models, information design and mapping documents necessary for delivering to business requirements.Designed and implemented ETL framework architecture in DataStage and SQL Server supporting identification and recording of source data availability and subsequent processing metrics.Implemented ETL development standards and associated quality assurance methodology.Devised and implemented change control process in relation to ETL/BI software, database and reference data components, including selection of supporting tools.Designed ETL templates to meet various processing requirements including type 1 and 2 slowly changing dimensions, twin time stamp fact tables, logging of rejected records and management of reference data. -
Data Warehouse ConsultantWorkcover Nsw Jan 2005 - Jul 2006Gosford , Nsw , AuReviewed functional requirement specification and translated into technical specification in order to deliver required ETL functionality. Established ETL architecture.Created and tracked development schedule in Microsoft Project, reporting progress to management accordingly.Created logical design of process required to automate Cognos reporting post warehouse load. Developed functional and technical requirements for automating scheduled loads of the data warehouse including the supporting data model.Performed source to target mapping of external data submission files to assist in development of jobs required to load into the data warehouse.Created technical design of DataStage and QualityStage jobs required for performing the submission load.Oversaw build, unit test and integration of components developed.Established ETL change management methodology required for system integration testing, UAT and ultimately promotion into production. -
Data Warehouse ManagerQbe Insurance Jan 2004 - Dec 2004Sydney, New South Wales, AuFounding member of QBE Australian Operations Data Warehouse team.Lead the project sub-committee charged with identifying the most appropriate front-end BI interface for Warehouse.Kept project stakeholders up to date, including the steering committee.Managed the migration to new hardware platforms including existing databases, ETL projects and software upgrades.Implemented automatic reconciliation of warehouse loadsAltered and enhanced existing Red Brick data warehouse in the QBE environment to store portfolio statistics from both the legacy HIH and active QBE databases, thus allowing continuous portfolio analysis despite migration of business from one underwriter to another.Assisted Directors and Actuaries in portfolio analysis and modelling, thus playing an integral role in returning the Liability division to profitability.Provided statistical data to divisional Directors and Actuaries as required. -
Bi/Warehouse Designer/Analyst/ProgrammerQbe Insurance Oct 1996 - Dec 2003Sydney, New South Wales, AuDesigned and deployed star schema data marts and associated ETL DataStage projects.Designed, developed, deployed and supported three-tier client-server decision support application, enabling users to easily obtain business data, thus helping support their business decisions.Designed and developed Oracle data warehouse from which the data returned by the above application was extracted.Created and supported invoicing database to manage the collection of policy excesses resulting from liability claims.Structured and delivered Brio Query training course for staff having ad hoc reporting needs, enabling self service to underlying star schemas.
Adam Mcguinness Skills
Adam Mcguinness Education Details
-
North Sydney College Of TafeElectronic Engineering
Frequently Asked Questions about Adam Mcguinness
What company does Adam Mcguinness work for?
Adam Mcguinness works for Future Fund
What is Adam Mcguinness's role at the current company?
Adam Mcguinness's current role is Leadership, architecture and a hands on approach for systems which transform data into information..
What is Adam Mcguinness's email address?
Adam Mcguinness's email address is ad****@****ail.com
What is Adam Mcguinness's direct phone number?
Adam Mcguinness's direct phone number is +612929*****
What schools did Adam Mcguinness attend?
Adam Mcguinness attended North Sydney College Of Tafe.
What skills is Adam Mcguinness known for?
Adam Mcguinness has skills like Data Warehousing, Business Intelligence, Data Modeling, Solution Architecture, Etl, Data Warehouse Architecture, Data Migration, Informatica, Integration, Testing, Databases, Business Analysis.
Who are Adam Mcguinness's colleagues?
Adam Mcguinness's colleagues are Adam Schulz, Joel Grant, Adam Crockett, Darryn Verey, Priyanka Garg, Michael Ioannidis, Paul Banks.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial