It is true that a custom made database application can be as affordable as purchasing
a regular software product. There is no need to compromise the features and functions
you need from a database application in order to operate your business efficiently.
We have also provided database solutions for large organisations such as Telstra,
the Roads and Traffic Authority, RAMS Home Loans, and the University of New South
Wales. To build this profile and develop such experience took IT Magnet a lot of hard
work, the benefits of which can now be available to you.
In tailored database development, problems usually arise if the software company
does not spend enough time understanding your business requirements. Our team of
20 professionals is small enough to focus on your business, yet large enough to
allocate the necessary resources for your project.
What else
gives us the competitive edge?
Though we develop purpose-built databases, they are actually developed on our own
existing foundation (or framework), which helps us provide you with a more reliable
and affordable database.
The rest of the development work is strictly guided by a 55 page 'Development Standard,'
which ensures that your product is of very high quality.
Over the years IT Magnet has developed a range of modules (or functions), many of
which are able to be re-used for your software, resulting in a shorter development
timeframe.
Most of our database programmers are certified by Microsoft or Oracle, having in-depth
knowledge of database programming, design and optimisation, which means we can provide
expert advice and a fair comparison between the quality of
Microsoft Access, Microsoft SQL,
and
Oracle databases
What assurances come with
the delivery of our databases?
We provide a fixed cost with no fuss unless you change your requirements
All our databases are delivered with a 6-12 month warranty
We provide dedicated technical support personnel (and not just a helpdesk phone
number)
Extended technical support and warranty options are available
There are little or no ongoing fees
You have an unlimited license to use your software
In some cases, under some conditions, the source code for
your software can be made available
Please call IT Magnet on 1300 369 350, as we find a phone conversation the most effective means
of communication for both parties. Alternatively, please
click here to send us an enquiry.
Latest Database Projects
University of NSW
Database for National and International Educational
Demographic
The Committee of Deans of Australian Medical Schools (CDAMS) was conducting a 12-month
project to design and initiate a national database that would collect reliable demographic
and educational data on medical students at all 15 Australian and several international
medical schools. It was intended that the database would provide an efficient and
cost-effective mechanism for evaluating undergraduate and graduate entry medical
education, as well as the short and long-term outcomes of medical education programs,
particularly rural health programs. Using web-based technology IT Magnet provided
a complete solution making the system accessible to the students, data collectors
at every school, central administrators and B2B partners. The solution was based
on Microsoft SQL database, MS .Net platform, web-based technologies and 8 layers
of security.
Westside Under Ground Power
Business Process, Estimation & Quotation Database
WUP is one of the leading providers of electrical services to major companies like
Integral Energy and Energy Australia. The company runs large projects which require
a significant amount of electrical goods and human resources. This required a software
system that would take care of the entire process of a project. Estimating the project
costs, providing quotations, managing progress and activities throughout the project,
maintaining inventory, and providing financial details were all necessary features.
The solution provided by IT Magnet encompasses MS. Net, MS SQL, and integration
with Attache financial software. This software also featured an innovative function
called 'Auto build', a process unique to this industry that takes away the complexity
of the manual calculation of required resources for a project.
Telstra Corporation Limited
SMS Based Fault Reporting Database
Telstra required a software-based
solution to manage its day-to-day fault reporting process. When a fault occurs,
a field staff sends an SMS to a central mobile phone number which is intercepted
and recorded by a central computer system. The staff located in the office then
accesses the details of the fault from their PC, works on a resolution and sends
progress-status to different groups.
It was imperative that the system
handled large volume of transactions on a daily basis. Also, due to the mission-critical
nature of the system the up-time had to be close to 100%. IT Magnet not only provided
a robust and scalable architecture, it also delivered the system within a strict
timeframe.
Rams Home Loans
Online Home Loans Calculator Database
RAMS Home Loans is Australia's second
largest non-bank mortgage provider with approximately 30 percent of the market share.
The company has a large mobile sales force that meets hundreds of potential customers
on a daily basis and provides borrowing consultancy and quotes. The business requires
its sales representatives to be able to carry a laptop computer to the meeting places
and run a variety of calculator applications such as a loan repayment calculator,
a bridging loan calculator, and others. IT Magnet delivered solutions for the following
business requirements:
Web-based access to
the system so the applications can be accessed from any location.
The web-based application
pages must refresh instantly, as would a desktop application.
Users must be able
to download an off-line desktop version of the application in the event that the
Internet is not available.
Downloadable executable
must be small.
Administrators of
the system must have secure interface for changing variables of the applications
or calculators.
Offline desktop users
must be notified as soon as an Internet connection is detected.
The interface must
be user-friendly and all applications must be easy to navigate.
Calculator interfaces
must be of an Excel-like format, as it is widely accepted by the sales community
across Australia. IT Magnet provided a solution by combining MS. Net for web-based
functions and Macromedia Flash for Excel-like instant response, which not only met
the business requirements, but in some areas exceeded the client's expectations.
As for data storage, both MS SQL and XML were used to cater for online and offline
access facilities.
IT Magnet provided a solution by combining
MS. Net for web-based functions and Macromedia Flash for Excel-like instant response,
which not only met the business requirements, but in some areas exceeded the client's
expectations. As for data storage, both MS SQL and XML were used to cater for online
and offline access facilities.
Roads and Traffic Authority - NSW
Document Management Database
The Sydney Traffic Services department
of the RTA creates a large number of engineering drawings for road signage and installation.
Being such a large organisation, and the designers being located in various locations,
it became necessary to install centralised document management software. IT Magnet
developed a fully tailored software package that saved the designers a significant
amount of time in searching for drawings, browsing, reviewing and even reusing existing
drawings. The software also keeps track of changes made to each drawing and saves
each change as a new version of the drawing file. Using sophisticated techniques,
the software penetrates the market-leading CAD drawing software, changing its normal
behaviour and protecting the user from making unwanted mistakes. For example, after
making changes to an existing file, a user may accidentally overwrite the existing
file instead of saving the changes as a new file, as intended.
Fountain Cosmetics
Largest Online Store for Cosmetics Products
Fountain Cosmetics is the largest
Australian online store that stocks hundreds of brands of cosmetics products and
serves tens of thousands of customers across the world. The business consists of
several entities and serves a variety of business areas such as beauty salon, retail
store, online retail, restaurant, multi layer marketing system like AMWAY and more.
The responsibility was given to IT Magnet to deliver a solution to manage such a
complex environment that included salon appointments, sales transactions, integration
of Ecommerce and off-line sales, suppliers and customers, complex MLM genealogy,
sales commission, cross profit and loss and integration with other software such
as POS and accounting. IT Magnet developed a predominantly Microsoft .Net and SQL
based system that simplified their operation, minimised errors, improved customer
service and cut operational costs.
Aussiepay
Australia's First Online Payroll and Leave Management
Database
Aussiepay, one of Australia's leading
payroll service providers, provides online payroll services as well as tailored
consulting services to a large number of prominent businesses across Australia.
The company processes over 10 million pay cheques every year. Its main operation
is to collect process and deliver information electronically; hence accuracy is
of essence. Aussiepay required a robust database, collection of applications and
a time-saving reporting system. IT Magnet proved its expertise in developing software
where business requirements are highly complex and the size of application is vast.
St George Bank
Recommended Ecommerce Database Systems Solution Provider
Having provided Ecommerce solutions
to a large number of clients for seven years, IT Magnet has achieved tremendous
expertise in the Ecommerce domain and has launched a product called IES - IT Magnet
Enterprise Solution. St George bank has recently taken IT Magnet on board as its
strategic partner in providing Ecommerce and online payment services to its customers.
Apart from delivering IES to St George bank's customers, IT Magnet is also involved
in providing relevant consulting services.
Platinum TV
Innovative Multimedia TV System with content Database
Platinum TV is an innovative user-managed multimedia TV system that allows users
to schedule and control content on public arena TV screens. The underlying technology
used for this system is a world first, and earned a significant amount of praise
at the Sydney Bar Show. On popular demand from hotels and clubs, the software was
developed for managers to move beyond Fox and Optus channels on their TV screens.
Instead, during low-rated TV programs, they are able to schedule and display their
own digital content like fashion parades, and sport, for example. Platinum TV enables
in-house designed advertising to be shown, as well as promotional information and
breaking news in scrolling-text bar. The entire system can be managed and scheduled
remotely over the internet from any computer. Many high profile venues in Australia
are already using the system and many more are showing interest.
Inten Constructions
Construction Project and OH&S Management Database
With over 40 years of combined experience in the commercial, retail and industrial
construction sectors, Inten has become a market leader. Having the power of a large
employee base the company is able to manage several projects at any one time. However,
due to highly competitive nature of the industry the company was looking to streamline
a lot of its paper work, eliminate its unmanageable electronic files and put together
a complete software system which would allow them to run more projects with the
same number of staff as well as minimise errors. The responsibility to develop this
innovative and designed from scratch system was given to IT Magnet. The delivered
system not only offers project management efficiency it includes an innovative OH&S
management system which has been missing from the construction industry over the
years.
Red Gravel Publication
Project & Risk Management Database for Architects
Risk Management Architecture has been developed to manage project risk effectively.
This enables architects & designers to improve end results through identifying and
analysing a wide range of issues, as well as providing a systematic means of making
informed decisions. The system takes an individual project through the design and
approval process by using a series of formalised procedures and checklists. The
key benefits include minimised errors and omissions in documentation, reduced possibility
of litigation, increased accountability for staff, and an improved work flow leading
to shorter timeframes. The system integrates with users' Outlook and Word documents
at an advanced level in keeping a project communication log. The software was also
designed to runs in Windows, Macintosh and web-based environments. Dozens of companies
in the industry have already purchased the software and with many more showing interest.
Motive Finance and Leasing
Online Finance and Leasing Application Management Database
Motive Finance and Leasing was handling a large number of customers on a monthly
basis relying on a paper-based system. It soon realised that the process was error-prone
and labour intensive. They also realised that finance and leasing application forms
needed to be available to customers over the Internet allowing after-hour access
as well as the ability for customers to check progress of their applications. Taking
advantage of Microsoft .Net technologies, IT Magnet delivered a solution that met
those requirements within a tight budget.
KDR Roofing
Contractor Management and equipment inventory database
KDR Roofing is a rapidly growing roofing
service provider, proudly serving Sydney's western suburbs, Newcastle and other
areas of NSW. Due to the rapid growth of the company, IT Magnet was hired to build
a system that would keep track of all KDR's head contractors, sub-contractors, jobs,
quality control, payroll, invoicing, quotation and other day-to-day issues. The
delivered solution was an online system (hosted on the Internet) so the staff of
KDR could access the system anytime from any computer located at any of its offices
as well as from home.
Connections Event Management
Database for online Survey, Rating & Event Management
Connections Event Management provides
a full range of event management services to the Australian corporate sectors. IT
Magnet has developed a complete solution that contains a Customer Relationship Manger
(CRM), an event management application and a task manager for the internal operations.
This fully web-based software is taking care of all the core parts of the business,
leaving almost no paper-based operations. Containing a Business 2 Business portal
the software allows Connections' business affiliate to view information over the
Internet that is only important to the affiliate.
J-Curve Recruitment
Recruitment Database for Employers and Employees
J-Curve is a leading recruitment company,
specialising in the broadcasting industry. IT Magnet developed an online system
that facilitated inventory for jobs, clients and applicants, assisting both visitors
and J-Curve. The system also runs regular trivia and competitions and allows the
administrator to update online notice board.
Blacket Hotel
Online Database for Customer Relationship and Marketing
Set in the heart of the corporate,
retail and entertainment precinct, Blacket Hotel is Sydney's newest four star hotel.
Keeping track of customer particulars and promoting its services to customers are
the fundamental business requirements of Blacket Hotel. IT Magnet has developed
an online business application that allows administrators and marketing managers
to carry out electronic marketing, communications, and customer relationship activities.
Furthermore, to ensure the smooth running of its day-to-day IT operations, Blacket
Hotel required sound, secure and affordable IT infrastructure, which IT Magnet provided
for quite an affordable price.
New Fema Industrial Safet
Online Product Catalogue, Enquiry and Quotation Database
Serving the manufacturing industry for six years, New Fema is a prominent name in
the Australian light and heavy machinery wholesale market. IT Magnet has developed
a website system for New Fema containing an online product catalogue for its large
and complex product range. From a management console, New Fema is able to manage
its product inventory and update its website by categorising, adding to and removing
its product base. The management console also allows New Fema to update any other
information across the website.
Portrait Australia
Database to Manage Products, Artists and Customers
Portrait Australia showcases Australian art, crafts, and Aboriginal art and culture.
The website features a secure B2B (business to business) portal which allows Australian
artists and art galleries to login and directly make their products available for
sale online. The user-friendly Content Management system also enables artists and
galleries to manage their personal profile. Artists subscribe to the website and
pay an annual fee, which is managed from a management console by the administrator
of Portrait Australia. The Ecommerce-ready website then allows domestic and overseas
shoppers to purchase the artworks and make payments.
Gadigal Information Services
Content Database for Information-Rich Website
Sponsored by both government and corporate sectors, Gadigal's website is information-rich,
and allows the administrator to have full control of creating, categorising and
managing a variety of information about Australia's indigenous communities. The
easy-to-use administration console allows volunteers and students to manage text,
images, audio and video on the website, and to publish news and events. The management
console also allows different back-end operators to perform different jobs in order
to maintain the integrity of the website.
Koori Radio
Music Database System
IT Magnet's multimedia and online development took a huge leap forward as it took
on the challenge of making Koori Radio available for the internet community. The
website allows live streaming and on-demand listening and viewing. This required
extensive knowledge of available multimedia technologies, hardware options and optimal
communications infrastructure. Apart from listening activities, the website also
features an image gallery and events page which are updated by the administrators
on a regular basis. Being Sydney's only Aboriginal and Torres Strait Islander full-time
community radio station, Koori Radio has a large audience base across Australia
and overseas.
Dynamic Disco
Audio and Video Database for Innovative Jukebox
Dynamic Disco is an innovative Jukebox
system that overshadows any rival software in the jukebox market. The software incorporates
a range of features allowing a party host, any nominated operators and party guests
to upload, organise and play music, karaoke and video in a format of the user's
choice. Developed on Microsoft Media Player technology, this Dynamic Disco software
integrates with Media Player to the deepest extent that no other software has ever
done. The system has gained enormous popularity across the east cost of Australia,
serving private functions, bowling clubs, hotels, restaurants and function centres.
First Australian Businesses
Online Business Directory Database
The government-funded Indigenousbusinesses.com.au
is the largest online business directory system containing almost every indigenous-owned
business across Australia. The system enables easy searching by providing two options
- graphical navigation using an Australian map, and a traditional text search. The
results are shown by post code, proximity and business categories. The system also
offers a portal for business owners to register online, set up their own customisable
mini-website which is self-maintained. The system's content policing module enables
the administrator to approve content before is can be published online by business
owners. With proper technical infrastructure and active promotion, the directory
system is being accessed by a large number of visitors with a special interest in
dealing with indigenous-owned businesses.
Footsteps Gallery
Arts and Merchandise Database
Footsteps Gallery's government-funded
website was mainly intended for Australian corporations and the overseas market.
The website hosts a range of artworks and merchandise, and contains special features
to allow organisations to personalise their searching. With regards to shipping,
the website is equipped with a state-of-the-art dynamic feature that automatically
calculates the size, weight, dimension and destination address of a product. It
then selects the best courier company to use to ship the goods. This shipping feature
also allows the website administrator to assign shipping rates and preferred courier
companies to self-defined zones worldwide. With the advanced content management
system, the administrator is not only able to upload and manage new products, but
also to maintain the profile of the artists associated with the artwork.
Ray Tually Finance & Investment Services
Record Keeping Database to Manage Finance, Investment
and Accounting
Serving a large number of customers
successfully over 10 years, Ray Tually Finance & Investment Services encountered
a tough data management challenge. Due to the volume and complexity of its data
and the variety of services the business provides, it needed unified and robust
information management software to move forward. IT Magnet was hired to develop
such a software system to coordinate the 3 core services - Finance, Investment and
Accounting.
