WorkCover Data Warehouse
We provided an IT consultant to lead a team to develop a data warehouse for WorkCover.
Strategic and operational managers required WorkCover specific reports, flexible ad-hoc reporting and actuarial analysis. The WorkCover data warehouse was developed to fulfil these requirements.
Our consultant performed the following tasks for WorkCover:
- Formulated, communicated and gained approval for the project strategy and approach.
- Hired and managed the project team.
- Consulted with Q-COMP staff and external bodies.
- Analysed and documented requirements.
- Designed new business processes.
- Negotiated with and managed internal and external stakeholders.
- Reviewed existing systems.
- Defined measures and dimensions.
- Prepared functional specifications.
- Designed the database.
- Recommending software tools for data analysis.
Bridge Information System
We provided a consultant to the Department of Main Roads to lead a team of 3 developers, 4 acceptance testers and 2 technical writers to develop their Bridge Information System.
The Bridge Information System is an application for recording structural and condition information about bridges and culverts which is used to inspect and maintain structures, determine load carrying capacities, determine heavy vehicle routes and assist in the valuation of assets throughout Queensland.
Our consultant performed the following tasks for the Department of Main Roads:
- Created project plans and task estimates encompassing design, development, acceptance testing, documentation, training and technical support.
- Performed design reviews with system owner and key users.
- Performed quality/progress reviews.
- Prepared development architecture and environment including PC setup, support tools and utilities.
- Prepared test data, test plans and test environment.
- Prepared training database and training course material.
- Held business requirements workshops throughout Queensland.
- Managed the development of the Bridge Information System.
The Bridge Information System is currently used throughout Queensland by the Department of Transport and Main Roads.
Job Management System
North Brisbane Trees wanted to implement a job management solution for estimating, quoting, invoicing, scheduling and tracking of jobs.
We helped them find and assess available products in the market place and select the best solution for their business. We then installed and configured the system to align with their business practices and provided initial training and support before handing over on-going support to the product vendor.
Job Management System
Trusted Pest Management wanted to replace an existing inadequate job management system for estimating, quoting, invoicing, scheduling and tracking of jobs including mobile access for their field service staff.
We helped them find and assess available products in the market place and selected the best solution for their business. We then installed and configured the system to align with their business practices, converted/cleansed/imported the data from their old system and provided on-going support.
Asset Management
We provided an IT consultant to the Department of Transport and Main Roads to manage the procurement of an Asset Management Solution.
The Asset Management solution significantly improved the department’s ability to pro-actively manage the maintenance of its electrical and electronic assets, particularly street lighting and traffic signals.
Our consultant performed the following tasks for the Department of Transport and Main Roads:
- Managed the project from start-up through the concept and procurement phases.
- Managed the business process and change planning.
- Managed the requirements specification.
- Managed the development of the business case.
- Managed the tender process.
Energy Usage Profiling
We provided a consultant to Energex to assist them in improving their Profiling System.
The Profiling system enables Energex to analyse clients’ energy consumption and forecast future consumption. The profiling results are used for the generation of quotes and associated contracts.
Our consultant performed the following tasks for Energex:
- Organised and facilitated user workshops to capture system requirements.
- Re-engineered and modelled business processes.
- Documented user requirements.
- Created system prototype.
- Designed application.
- Designed and modelled database.
- Developed profiling system.
Suncorp Data Warehouse
We provided an IT consultant to Suncorp to develop strategies and techniques for the management and development of Suncorp's data warehouse.
This was a major new initiative in the Banking arm of Suncorp. The new data warehouse supports both regulatory reporting and internal management reports.
Our consultant performed the following tasks for Suncorp:
- Defined overall architecture and metadata strategy.
- Defined MIS management processes, roles and responsibilities, requirements definition standards and data mapping specification techniques.
- Designed a metadata management tool for design and testing, and to produce “lineage” reports to allow everyone to understand the data derivations and transformations.
- Acted as Team Leader, delivering the initial release and coordinating activities between the analysts, architects, ETL developers and testers.
Asset Data Modelling
Our consultant performed the following tasks for Toowoomba Regional Council:
- Provided advice on how data should be modelled.
- Provided advice on options for data interfaces TRC systems
- Assisted in the development and implementation of plans to test data interface processes
- Assisted TRC staff with specification of data migration plans from current system to the new system.
- Assisted TRC staff with mapping data flows within TRC and documenting effects on TRC business processes.
Road Asset Management
We provided an IT consultant to the Department of Transport and Main Roads to provide expert Business Intelligence(BI) advice, to design and govern the quality of the data warehouse and BI solution, and to manage the technical aspects of the project, including testing and implementation.
The project introduced integrated, flexible reporting of trusted information for asset and performance management of the Queensland main roads system.
Our consultant performed the following tasks for the Department of Transport and Main Roads:
- Advised on the appropriate approach and staffing for the project.
- Assisted with recruitment of business analysts and selection by tender of a partner company to provide the BI development skills for the project.
- Mentored the business analysts on BI concepts during requirements definition.
- Documented the information architecture and facilitated the handover to the partner company for design and development.
- Took responsibility for planning, scheduling and coordinating all of the testing and implementation activities.
- Negotiated with a wide range of stakeholders to gain approval of test plans, test reports and releases.
Work Management
We provided an IT consultant to WorkCover to help them improve their work management by prioritising and allocating work more effectively.
Our consultant performed the following tasks for WorkCover:
- Wrote a business case and project proposal for improvements to their data warehouse and reports.
- Interviewed stakeholders.
- Proposed and gain endorsement for new processes and on-line system for the Underwriting Compliance business function.
- Led the development and implementation of the new on-line system.
Investigation Management System
We provided an IT consultant to the Queensland Police Service to cleanse and migrate their data to a new Investigation Management System.
Our consultant performed the following tasks for the Queensland Police Service:
- Conducted workshops and documented business process requirements.
- Designed the data migration software.
- Led two programmers during the development, testing and implementation.
Job Management System
Stevie Redback pest and termite control wanted to implement a job management solution for estimating, quoting, invoicing, scheduling, dispatching and tracking of jobs.
We implemented a job management system for them and configured the system to align with their business practices and provided initial training and support before handing over on-going support to the product vendor.
Job Management System
Timmers Construction wanted to implement a job management solution for estimating, quoting, invoicing, scheduling, dispatching and tracking of jobs.
We implemented a job management system for them and configured the system to align with their business practices and provided initial training and support before handing over on-going support to the product vendor.
Telemarketing System
Ministry of Leads wanted a system that all staff, including remote staff, could use for recording actions, outcomes and tasks relating to telemarketing activities. They also required management reporting capabilities.
We developed a bespoke SharePoint web app telemarketing system for The Ministry of Leads which aligned with their business practices and allowed for remote operations and central management of telemarketing activities.
Point Of Sale Solution
The purpose of this project was to identify and assess stock control & POS systems available in the market place against Griffith University's business requirements and industry best practice regarding the management of food and retail; and to recommend a stock control & POS systems(s) to replace Griffith University's current systems.
Asset Management System
Active Mobility Maintenance wanted to implement an Asset Tracking and Maintenance Solution.
We investigated potential solutions and recommended an Asset Management System that would:
- Enable Active Mobility Maintenance to print and attach QR code labels to assets.
- Manage customer details.
- Track asset maintenance and financial history.
- Manage service requests and scheduled maintenance.
- Schedule and assign jobs to staff.
- Record asset maintenance information.
- Provide customer access to asset information via web site.
- Generate reports.
Software Licence Management
We provided a consultant to the Department of Main Roads to work with a team implementing the Office of Government ICT Software Licence Management (IS45) standard.
Main Roads implemented the Software Licence Management (IS45) standard to improve the management of software licences and to improve the management of software assets in general. The project delivered improved Software Licence Management capabilities by developing and implementing roles and responsibilities, policies, processes, procedures and tools related to software asset management.
Our consultant performed the following tasks for the Department of Main Roads:
- Participated in Office of Government ICT IS45 briefings and workshops.
- Defined an IS45 Strategy for Main Roads.
- Developed IS45 awareness presentations and briefing notes.
- Developed an IS45 project proposal including implementation strategy, schedule, roles and responsibilities, communications plan, quality plan etc.
- Performed market research, organised vendor demonstrations and held initial discussions with vendors to investigate potential enterprise discovery, configuration management, software licence management and software asset management solutions.
- Defined an IS45 framework including Software Asset Management services, roles, policies, processes and tools.
- Created a Software Asset Management business unit to manage software for whole of department.
- Facilitated workshops with stakeholder reference groups across Queensland.
- Documented Business Requirements including current and future state processes.
- Developed tender documents including tender evaluation plan, offer documents and tender assessment matrix.
- Managed and participated in the evaluation of offered products.
- Managed the customisation and implementation of the chosen product.
- Implemented new Software Asset Management roles, policies, processes and procedures.
Incident Recording, Management and Investigation System
We provided a consultant to Queensland Police Service to lead a team of 8 business analysts and 12 police officers to document the requirements for an Incident Recording, Management and Investigation System.
Queensland Police Service was replacing more than 150 disparate legacy systems with a single integrated policing system. A major focus of this project was to improve business processes through integration and rationalisation of existing applications.
Our consultant performed the following tasks for the Department of Transport and Main Roads:
- Defined requirements analysis and options analysis strategy.
- Defined requirements analysis and options analysis methodologies, tools and templates.
- Developed and managed project schedule.
- Managed key stakeholders and project resources.
- Managed development, quality assurance and delivery of business requirements and tender documents.
- Held high level needs and objectives workshops with key stakeholders.
- Held functional requirements workshops with business area representatives.
- Documented and modelled current state processes.
- Re-engineered business processes to meet business requirements.
- Documented and modeled future state processes.
- Documented and modeled functional requirements.
- Developed a Configuration Management Database (CMDB) to record and report on the current and future state application portfolio.
- Documented current state applications including logical entities, physical entities, processes, interfaces, functions, architectures and owners.
- Documented future state applications including logical entities, physical entities, processes, interfaces, functions, architectures and owners.
- Documented system requirements for COTS application, legacy systems, interfaces and applications to be developed.
Business Analysis Unit
Queensland Health had implemented a Business Analysis Unit to perform business analysis for ICT projects within Queensland Health. They were having a number of issues with providing business analysis services to projects and we provided a consultant to review and improve their processes, methodologies and tools.
Our consultant performed the following tasks for Queensland Health:
- Reviewed the Business Analysis Unit work practices, processes, methodologies and tools.
- Implemented risk/issue management and change management processes.
- Recommended and implemented improvements to Business Analysis Unit work practices, processes, methodologies and tools.
- Performed reviews of deliverables including Business Requirements Specifications and System Requirements Specifications.
- Performed performance reviews of Business Analysts.
Road Crash System
We provided a consultant to the Department of Main Roads to lead a team of 3 developers, 2 acceptance testers and 1 technical writers to develop their Road Crash System.
The Road Crash System is an application for analysing crashes and implementing remedial treatments to those roads which produced the best benefit cost ratio.
Our consultant performed the following tasks for the Department of Main Roads:
- Created project plans and task estimates encompassing design, development, acceptance testing, documentation, training and technical support.
- Performed quality/progress reviews.
- Performed business area liaison.
- Prepared development architecture and environment.
- Created software development standards.
- Implemented development environment which included PC configuration, source code control and development guidelines.
- Analysed, designed and developed application
The Road Crash System is currently used throughout Queensland by the Department of Transport and Main Roads.
Application Rationalisation
We provided an IT consultant to work with a team to investigate opportunities to rationalise Main Roads software applications.
Main Roads wanted to reduce the number of software applications being used from 4000 to 200. The objective of the project was to identify what, where, how and why existing applications were being used and to make recommendations to significantly reduce the current number of applications being used in Main Roads.
Our consultant performed the following tasks for the Department of Main Roads:
- Defined application rationalisation investigation approach.
- Defined application rationalisation investigation methodologies, tools and templates.
- Identified current state applications in use across 13 districts across Queensland.
- Performed stakeholder interviews to obtain application details, evaluate business value and assess the technical condition of each application.
- Analysed information collected for approximately 4000 applications.
- Developed an application rationalisation investigation report containing a number of recommendations to reduce the number of applications and to prevent application proliferation from reoccurring in the future.
Executive Information System
We provided an IT consultant to Telstra to lead a team of 8 developing a new Executive Information System.
The objective of the project was to integrate HR, financial and operational data to provide a tool for the CEO and senior managers to identify issues and drive the resolution of these issues.
Our consultant performed the following tasks for Telstra:
- Project Planning.
- Risk and Issues Management.
- Scope Management.
- Benefits management
Following successful release, Telstra’s CEO determined that the project would be expanded to support all Telstra’s senior managers.
Training and Skill Development
We provided a consultant to Tourism and Events Queensland to provide MS Office and Sharepoint training and skill development for TEQ staff and associated partners.
Our consultant performed the following tasks for Queensland Trourism and Events Queensland:
- Designed and conducted skills and self-assesment for TEQ staff.
- Adapted training content and materials.
- Developed and aligned plans and scheduled training delivery.
- Undertook training delivery.
Licence Processing
We provided a consultant to Queensland Transport to managed a team of 2 business analysts, 8 development staff and 7 testers, trainers and data entry clerks for the development and implementation of a new on-line system for processing licences.
Our consultant performed the following tasks for the Queensland Transport:
- Managed recruitment of resources.
- Project planning and scheduling.
- Managed data migration.
- Manage user training.
- Manage deployment.
- Managed stakeholder communications.
Billing System
We provided a consultant to Energex to help them migrate seven Queensland electricity boards to a common billing system.
Energex and the other boards needed to perform a substantial data migration to a common billing system. Our consultant was required to analyse their requirements and to devise methods by which they could complete the data migration within a very tight deadline.
Our consultant developed a suite of tools for the teams of data analysts to specify requirements for data integrity and processing. The tools checked the specifications and automatically generated programs to perform the data migration and integrity checks. Using the tools, all the electricity boards successfully their migrated to the common billing system.
Q-COMP Data Warehouse
We provided an IT consultant to lead a team to redevelop a data warehouse for Q-COMP.
Our consultant performed the following tasks for Q-COMP:
- Formulated, communicated and gained approval for the project strategy and approach.
- Hired and managed the project team.
- Consulted with Q-COMP staff and external bodies.
- Analysed and documented requirements.
- Designed new business processes.
- Negotiated with and managed internal and external stakeholders.
- Reviewed existing systems.
- Defined measures and dimensions.
- Prepared functional specifications.
- Designed the database.
- Recommending software tools for data analysis.