Quoter Project

Sole Developer

2005 – 2007 IAG Australia

Summary:

This project involved specifying a quote and maintenance system that is capable of quoting different complicated insurance products from across the department enabling processes from Quote to Policy.

Goal Result
Manage process of quote through departments without need for printing and distribution of quotes Automated, centralised database and software system for distribution
Reduced or removed Paper based processes 30% Reduction
Increased Efficiency Saved >4 FTEs
Enabled result measurement down to individual users for KPIs and personal Stats Enabled reporting on individual staff
Ensure fully dynamic and upgradeable to enable changes to each product to be easily accommodated and changed by less technically skilled operators Added 14 products on dynamic system based on one product
 

In Depth:

This project involved specifying a quote and maintenance system that is capable of quoting different complicated insurance products from across the processes from Quote to Policy.
Aims of the project:
Manage process of quote through departments without need for printing and distribution of quotes.
Reduced or removed Paper based processes: Successfully reduced paper usage by 30% across dept.
Increased Efficiency: Successfully removed >4 FTEs
Enabled result measurement down to individual users for KPIs and personal Stats: Successfully enabled reporting on individual staff
Ensure fully dynamic and upgradeable to enable changes to each product to be easily accommodated and changed by less technically skilled operators: Successfully added 14 products on dynamic system based on one product.

Skills

  • MS Access front end and MySQL back-end for 70 users
  • Migrated to MS SQL Server back end using DTS 
  • VB and VBA
  • Access
  • Excel
  • Word
  • Outlook
  • OLE & COM Automation
  • Adobe Distiller
  • MySQL 
  • MS SQL Server
  • Crystal Reports

Share with:

FacebookTwitterLinkedIn


Published by

Craig Lambie

Creating more people like Elon Musk in this world is my aim. Big thinkers, limitless believers like the universe we live in, always expanding. I work with people on expanding their horizons and working through the little things so the big things can grow.

Leave a Reply

Your email address will not be published. Required fields are marked *