Victor Lambe

Victor specialises in enterprise informationarchitecture in large organisations with complex and interdependent systems. He can provide information management standards and frameworks, design and plan information projects and implement those projects as required. His work is typically in the areas of data warehouse,enterprise architecture, information governance, master and reference data management, data migration, enterprise transformation and technical leadership.

He has an MBA, excellent communication skills and is adept at working with business stakeholders to develop a clear understanding of the business issues and a shared vision of how information assets can be structured and leveraged to provide maximum business value.With his combination of business, communications and technical skills he is able to create a bridge between business and technical people and successfully define and drive complex data projects.

Recent Accomplishments

  1. Design / construction of enterprise data integration, data warehouse and Business Intelligence (BI) platforms for NSW Ministry of Health, Ausgrid, AMP, Pernod Ricard, Sydney Rail, NSW RMS, and the Australian Child Support Agency.
  2. Definition of the Enterprise Information Architecture at Downer EDI, Ventia and Pernod Ricard.
  3. Development of an Enterprise modelling framework for Commonwealth Bank (CBA), NSW State Transit Authority and NSW Department of Community Services. Implementation of this framework using Aris, Mega, System Architect and Enterprise Architect (Sparx).
  4. The enterprise and data architecture for HealthConnect – a high profile national project aimed at providing all Australians with a shared electronic health record.

Education

  • Science at University of Western Australia.
  • Master Business Administration (Technology Management) from Chifley Business School.
  • Senior Member of the Australian Computer Society with Practising Computer Professional award.

Technical Specialisation

  • Enterprise Informationarchitecture and management.Architecture Frameworks. Enterprise level information, business and application strategy and modelling. TOGAF and ITIL certified.
  • Information modelling, operations database design, data warehouse design, messaging standards.
  • Specification of information management standards and reference architectures. Technical leadership.
  • Business Intelligence. Cliq View, Tableau, SSRS, SSAS, Cognos, OBIEE.
  • Enterprise data integration. Data Services design. Enterprise Services Bus (ESB). ETL / ELT
  • Architecture tools. Sparx, ARIS, System Architect.
  • DBMS. Oracle, SQL Server, SQL-Lite DB2. NDB Datastore (Python and Java)
  • Development planning (Roadmap) and project planning. MS Project.

Experience – Most recent on top

Victor has been working as a freelance consultant for a number of years. This has given him a view of wide knowledge of architectures, technologies, methodologies, problems, solutions and potential pitfalls. This section lists consulting engagements as short as two months and as long as three years.

Architecture as a Service Lead Architect (Ajilon) April 2016 – Present

Ajilon consulting provides Architecture as a Service to the NSW Ministry of Health. Victor leads the architecture practice and in that role has provided:

  • Architecture Governance establishment. Specification of governance structures, principles and processes.
  • Knowledge management and metadata standards. Specification of standards and governance processes.
  • Information architecture establishment. Specificationof reference models, standards and coaching.
  • Solution architecture leadership (team of four architects).

Information Architect (Ventia) August 15 – February 16

Establishment of the Enterprise Information Architecture practiceatVentia.Ventia is a large ($2B+) business recently born out of the service divisions of Leighton contractors, Thiess, VisionStream and several others. My role was to establish the Information Architecture practice in this new but complex and large company. I put major components such as Governance Policies, Data Management Strategy, Common Information Model, Metadata modelling standards and tools in place.

Freelance Data Architect (Ausgrid, AMP, E Street) December 14 – July 15

  • Six week assignment with Oakton to develop a BI Strategy and transition plan for AMP.
  • Smart Grid Smart City data warehouse support (developed by me – see October 11 – June 14 assignment).
  • Development of an audio-visual application using the Google stack including App Engine and Big table. Big Table, Objectify /NDB , SQL-Lite, Java and Python.

Enterprise Data Architect (Downer EDI) July 14 –November 14

Downer EDI provides engineering and infrastructure management services. It is one of Australia’s top 100 companies and was running a major systems transformation program to consolidate and improve systems. Victor was bought in to develop an enterprise information management strategy for the group to guide the transformation. In this role he specified:

  • Information management priorities.
  • Data integration strategy including master data management and reference data strategy.
  • Data governance, roles, responsibilities and processes.
  • Data cleansing, de-duping and change authorisation tools and processes.

Data Architect (Ausgrid) October 11 – June 14.

Data Architect at Ausgrid (formerly Energy Australia). Primary projects included planning for the migration of the electricity distribution network management system (a key platform in the support of critical NSW infrastructure) and the development and deployment of a large data warehouse (DWH), analysis and data visualisation platform.

Both of these projects required a single enterprise view of Ausgrid assets. Victor specified the tools and techniques to be used for integrating the data from these various systems and verifying the data veracity. He defined standards, practices and governance processes that recognised the need for agility while ensuring controlled change. There were no common semantics and so Victor implemented the power industry’s Common Information Model (CIM) to define terminology and guide data preparation so that all asset records could be merged into a single view.

For the Ausgrid DWH Victor selected the Inmon model (normalised integration layer with denormalised data marts for specific reporting requirements). The solution architecture was derived based on the functional requirements and the capabilities available within the Ausgrid environment. Selection criteria for solution components were prepared on that basis and vendors asked to respond. The final technical architecture selected was Oracle database running on Linux with Oracle Business Intelligence suite (OBIEE) and Oracle Answers (previously known as Seibel Analytics) providing the analysis / visualisation platform.

As the DWH project progressed Victor led the development team as they built the components required to integrate data from 23 source systems and publish it via 8 datamarts on the reporting and visualisation platform. Victor is a competent Oracle Development DBA and assumed that role (as well as team lead) to control development, provide a quality gate and ensure the databases were tuned for optimal performance.

Enterprise Data Architect (Pernod Ricard) March 11 – August 11.

Victor specified the Enterprise Data Architecture for Premium Wine Brands (a new company incorporating Pernod Ricard Australia and New Zealand, Jacobs Creek, Wyndham Estates etc.) and developed a roadmap for its implementation. The company uses the Oracle Enterprise Service Bus (ESB), Cognos, TM1, EnterpriseOne (E1), the OAGIS messaging model and numerous specialized applications. Victor constructed a data architecture using these components suitable for the company’s strategic direction. The data architecture he defined provides a near-real-time enterprise data warehouse and Cognosdatamarts that can be updated on an as-needed basis. It exposes relevant data (from E1 and other applications) as data services (aka data virtualisation). It also provides master data management capabilities (initially for customer master) integrated with a workflow management system.

Two applications were selected to be the first to use the new architecture with an aim of delivering the application functionality and transferring the skills required to maintain and extend the architecture to Premium Wine Brands internal staff. Victor created an enterprise data model (EDM) based on the OAGIS model and added Premium Wines extensions to cover all the data requirements of the two applications. He then showed how the EDM can be used as the basis for the implementation roadmap and to specify data services (including schemas, ESB adapters and connectors) as well as the foundation for the enterprise data warehouse. He specified the customer master data management services (which was to be built in-house and serve as a template for other MDM projects) and provided technical leadership for development teams in Sydney and Adelaide while transferring skills to them.

Prior Experience

This section provides a very brief overview of some of the other more recent projects in which Victor has participated. More details on any project are available from Victor.

Period / Company / Role / Tasks
2010 / RailCorp / Database Design / Design of Finance DWH.
2009 / NSW Dept of Family / Enterprise /Data Architect / Provision of an enterprise modelling framework that enables the linkage of functional and data requirements to Siebel logical and physical models. The framework also considers performance management by linking performance data to business objectives so that a comprehensive view of the data requirements to be supported by Siebel is created.
2008 / Bluescope Steel (via CSC) / Solution Architect / Development of a Master Data Management (MDM) strategy and architecture for Bluescope Steel. Victor and the CSC architects developed a business case, conceptual design and work-plan proposal with an initial focus on product and customer master data.
2008 / Commonwealth Bank (CBA) / Meta model Architect / Victor extended the modelling standards he had developed at RailCorp (see next entry) and applied them to the CBA environment so that they could be used as a framework suitable for visualising, specifying and managing the organisational, business and systems changes associated with the Core Banking Modernisation program.
2007 – 2008 / RailCorp (NSW) / Enterprise Architect / Development of strategy and architecture to improve rail incident management including the specification of modelling standards to enable an enterprise level view of processes and systems to be developed.
2006 – 2007 / RTA (NSW) / Solution Architect / This is an Oracle warehouse built using Oracle Warehouse Builder, Discoverer and Oracle Applications Express (for master and reference data management).
2004 - 2005 / Australian Child Support Agency / DWH Architect / Lead architect charged with the creation of an integrated data warehouse for the CSA. Responsible for providing conceptual design, architecture (data, technical, applications, security) standards and leading detailed design into construction.
2004 / NEHTA / Clinical Messages / Developing Clinical message structures for use with the HealthConnect architecture (see next item)
2002 - 2003 / Commonwealth Dept of Health and Ageing / Solutions Architect / Development of the high level architecture for the HealthConnect project - a very high profile project with national exposure that will eventually provide all Australians (voluntarily) with a shared electronic health record and will be one of Australia’s largest data warehouses. Although given specific responsibility for the data architecture Victor’s contribution extended to defining the enterprise architecture framework and defining the applications and technical architecture.

Industry Experience

Financial Services.

●Banking (Bankwest, American Express, Commonwealth Bank of Australia, AMP, Suncorp Metway)

●General and Life Insurance (Lumley Technology, AMP, Suncorp Metway, QBE)

●Superannuation & Trust Funds (AMP)

●Government (Child Support Agency).

Utilities.

●Telecommunications (WorldCom)

●Electricity (Pacific Gas and Electric California), Ausgrid.

●Water (Water Authority of Western Australia)

●Transport (Queensland Rail, Road Traffic Authority of NSW, RailCorp, NSW State Transit Authority)

Health.

●Hospital and GP systems (Kaiser Permanente, California; Commonwealth Department of Health and Ageing, Canberra).

●NSW Department of Community Services

Manufacturing / Construction

●Ventia,

●Downer EDI,

●Bluescope Steel,

●Premium Wine Brands

●Fluor Daniel (UK)

Contact

mobile. 0419 019 448 office. 02 9918 7737

Referrees

Please ask and the most relevant people will be nominated.

March 2017Page 1 of 5