- 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 via remote access.
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
|
|
