You are encouraged to run your own data management improvement project within your budget and timeline by:

• becoming aware of the data management pitfalls,
• taking advantage of the free resources to support your project,
• possibly requesting the guidance of this consultancy for a fee if you need further help.

>> read more on data management pitfalls >> get access to Free resources

Once you have become aware of the data issues you may have, and have explored the Free resources on this website so you can run your own project, if you still choose to request guidance, please make contact to provide enough detail on your project and concerns so we can assess if and when to conduct an initial consultation.

Consultations are run either live via Video link or Telephone or Delayed Support via Email or potentially at an agreed physical location, depending on your circumstances and in line with the current guidelines around the COVID-19 pandemic.

Note: for physical meetings which incur travel costs, such cost may be added to the cost of the initial consultation. This is negotiated on a case by case basis.

By purchasing any service from I.T.Matters(Aus), you (The Customer) are entering into an agreement with I.T.Matters(Aus) that is bound by the Terms of Service outlined below, and compliant with the NSW and Commonwealth business legal obligations.

• Initial Consultation
  • Upon agreement on the terms of the initial consultation, payment for the initial consultation including potential travel costs may or may not be required prior to the initial consultation. A tax invoice will be sent to you for such payment.
  
  
  
• Agreed Services
  • Upon agreement on the scope of the services, timeline and associated fees, you will be sent a quote preferably via email (if available) detailing such agreement.
    
    
  • It may take a few iterations, however, once the agreement is reached and the final quote sent, you will be required to formally agree to the quote preferably via reply email (if available).
    
    
  • Upon completion of the agreed service, a tax invoice will be sent to you and payment will be expected according to the agreed terms of service as per the quote.

Small Businesses Kelly's Bushranger Farms, Meat Retailer (Central West, NSW) Kenthurst Post Office, Australia Post franchise (Sydney, NSW)

Corporations IT Division, BHP (Newcastle, NSW) IBM, USA Oracle Corporation, Australia (Sydney, NSW)

Government Agencies Air Services Australia (ACT) AusIndustry, Commonwealth Dept of Industry, Tourism, and Resources (ACT) Australian Customs, Commonwealth Dept of, (ACT) CIO, Australian Fisheries Management Authority (ACT) Observer section, Australian Fisheries Management Authority (ACT) Australian Tax Office, Commonwealth Dept of, (ACT) eBusiness Division, Commonwealth Dept of Industry, Tourism, and Resources (ACT) Family and Community Services, Commonwealth Dept of, (ACT) Immigration, Commonwealth Dept of, (ACT) IP Australia, Commonwealth Dept of, (ACT) ONHMRC, Commonwealth Dpt of Health (ACT) Biosecurity, Primary Industries, NSW Dept of, (Orange, NSW) ICT, Primary Industries, NSW Dept of, (Orange, NSW) State Rail Authority, NSW Government (Sydney, NSW) TAFE, NSW Department of Education (Sydney, NSW)

Corporate Standards, Data Modelling ... Back to client list NSW DPI: Within the Information and Communications Technology (ICT) group, pair development of the Information Management Framework and Data Strategy inclusive of the Enterprise Data Modelling Framework - developing the Enterprise Contextual, Conceptual and Logical models - based on published patterns incorporating standards, and project models. Facilitate the integration of the EDMF in NSW DPI Software Life Cycle and Business Teams. Promote collaboration and architecture. Environment: Sybase PowerDesigner, SQL Server, Oracle AFMA: Reporting to the CIO, pair development of the Information Management Framework and Data Strategy based on DAMA DMBOK. Peer-review of data governance, and database administration strategies; develop data definitions, and data modelling strategies including standards for data modelling using PowerDesigner. Environment: Sybase PowerDesigner 11 and 12, Twiki IBM, USA: Beta testing of Rational Data Architect, and further useability testing. Environment: Rational Data Architect AusIndustry: Develop a Corporate Data Model in the context of a new system for the electronic processing of application and delivery of grants. The project included the development of data modelling standard, training staff to use Oracle Designer (CASE tool) to document data holdings, providing technical advice. Environment: Oracle 8i, 9i on Unix and NT, ERWin, Oracle Designer 6i, Oracle Reports R6i, Rational Requisite Pro Air Services Australia: Develop prototype data models and designs to support the drawing of maps and routes whilst considering the conflicting peculiarities of a variety of international and national data and standards. Environment:Oracle Designer Australian Customs: Provide support to the data management team in regards to the data models for the Cargo Management Re-engineering project Develop the standards for Data Modelling for the future releases of the project. Facilitate the adoption of generic concepts and entities to make the model more complete and generic in order to fit into the Corporate architectural framework. Environment: Cool:Biz, Cool:Gen IP Australia: Develop the corporate standards for Data Modelling, Database Design and PL/SQL programming. Participate in the validation of the Data Model for the Corporate Customer database. Creating the Data Model for the New Patent System. Participate in the analysis of the National Archives requirements for documents in the context of the data model. Facilitate the analysis of the requirements for the financial interface from the adopted EDMS to SAP. Environment: Oracle 8, Unix and NT 4, Oracle Designer 6i, Rational Rose, Objective EDMS, XML, SAP. Executive Reports, Data Warehouse, Data Migration ... Back to client list NSW DPI: Various executive reports to support compliance of NLIS, and to support management decisions across the BioSecurity division. Includes provision of data for the purpose of mapping. Environment: SQL Server 2008 and 2012, Business Objects 4, Crystal Reports, ArcGIS AFMA: Within the Observer section, Business Process and Data Modelling to integrate Observer data in the datawarehouse. Develop wiki content to increase user awareness towards better information management. ETL of ISMP data to datawarehouse. Provide input in evaluation of ETL toolset. Environment: Sybase PowerDesigner 11 and 12, Oracle 10g and 11g, TOAD, Visio, SourceSafe, Twiki, MS-Access Immigration: Build a new Integrated Data Store to support datamarts for the Compliance project - including alignment to the Corporate Data Model artefacts and intent, and to the Corporate Business Process Model. Environment: Modelmart and ERWin 7.3.5, DB2 v9.1 ATO: Map Siebel Conceptual model to Enterprise Data Model in the context of data warehouse design - involving liaising with Siebel development teams to get consensus on business rules. Include such rules in the ERWin Siebel logical data models so as to be quality input to the Enterprise Data Model. Working closely with the ATO Enterprise Data Modelling team. Environment: MS-SQL Server, Siebel 7.7, Teradata, ERWin; Large team of over 300 consultants Family and Community Services: Conduct data migration workshops and develop SQL reports and programs for Release 3 of the F(aCS) O(nline) F(unds) M(anagement) S(ystem). Environment: MS SQL Server - Enterprise Manager, Query Analyser, MS Access, Siebel 7.7 eBusiness, ITR: Develop a Data Warehouse to support the web publishing of data for Executive reports - including the facilitation and implementation of enterprise-wide customer definitions to support enterprise reporting. Environment: Oracle 9i database; Oracle Designer; Microsoft .Net framework Education and Training ... Back to client list BHP, IT: Provision of educational services: course delivery and course design; a database design course was designed in cooperation with BHP IT in Newcastle. Oracle: Provision of ad-hoc delivery of Oracle scheduled courses in the CASE, Web, and Java streams (Adelaide, Brisbane, Canberra, Melbourne, Sydney). State Rail Authority: Provision of services for Upgrade, Installation, and Training for Oracle Designer 6i. Review current Oracle Designer environment, Provide recommendations as to preferred framework; Install software; Negotiate Course Outlines; Create Training Material and Deliver courses. Environment: Sun Solaris - Oracle Designer 6.0, 6i Release 4 - Oracle 8i TAFE Training Division: Acted as course reviewer for the NSW TAFE Information Technology Training Division. State wide courses such as C++ for C programmers, Unix. TAFE Plus: Developed and Delivered C++ courses for TAFE Plus. Grant Management System ... Back to client list ONHMRC: Data Modelling, Database Design, Web Development to support an eCommerce application based on Java and Oracle technologies for the lodging of medical grants and the management of allocated funds. Environment: Oracle 7, and 8, Unix and NT 4, Oracle Application Server v3, Toad, Oracle Designer, JavaScript, HTML, XML, Source Safe Small Business Projects ... Back to client list Meat Retailer: Development of a web-based solution to support ordering of fresh meat online. Environment: Excel; HTML Australia Post Franchise: Development of a database solution to support post office box allocation and management. Ordering and Management of stock. Environment: MS-Access; Windows 95