After consulting the Queensland Government procurement panel, Queensland Health engaged Microsoft through a standing offer arrangement.
“Our enterprise services delivery organisation, Microsoft Services, has the people, the methodology and the expertise to rapidly deliver,” says Brad Beumer, Architect for the Dynamics Centre of Excellence, Asia–Pacific & Japan, Microsoft Services. “We conducted a needs assessment, then worked with partners to create a solution based on the latest version of the company’s CRM technology, Microsoft Dynamics CRM 2011.”
According to Beumer, Dynamics CRM 2011 contained two features that made it ideal for Quitline. First, enhanced reporting, with an out-of-the-box report configuration tool that enables users to create their own reports in less than ten minutes. Second, it has advanced workflows that guide users through pre-defined steps, helping staff work more efficiently.
However, Beumer made the Microsoft Services delivery methodology a key aspect of the bid, believing it would guarantee on-time delivery.
“We have an agile, rapid-delivery method for CRM deployment that we’ve developed as part of our standardised Sure Step implementation methodology,” he says. “This methodology includes tools, templates and a series of best practices.”
The approach worked. “We chose Microsoft because they had a clear understanding of our needs, they had established processes, and they were willing to commit the resources to create the CRM,” says Peardon. “This made me confident they could deliver by December.”
The design to delivery phase took 12 weeks, starting in early October, and was executed by a mix of Microsoft staff, CRM specialists from Gold Certified Partners, and Quitline staff. The Quitline staff became a core part of the design, advising developers on what
they liked and didn’t like through each of the build, test and
One key part of the solution involved using Active Directory Federation Services to provide Claims-based Authentication. This meant that workers could easily log on to the CRM, even if they were working in a Novell operating domain.
“Microsoft had different people coming in at different times, focusing on specific things,” says Peardon. “Various staff provided regular status reports and managed project issues. They were very professional.”
A key deployment strategy was to avoid customisation by using as much out-of-the-box functionality as possible. At the start of the project, Beumer conducted a ‘Fit-Gap’ analysis that identified variances between Quitline requirements and out-of-the-box CRM 2011 functionality. Beumer worked closely with staff to identify where it made practical sense to modify Quitline requirements because the cost and time savings outweighed anticipated usability benefits.
“I believe Microsoft had a commitment to get the CRM right; I believe they cared,” says Peardon. “Above all, their methodology worked. As a manager, I was able to keep up with the progress of the project and feel one step ahead.”
With a Microsoft SQL Server 2008 Enterprise database, the agency’s new CRM system went live on schedule in December 2011. It provides integration with the Quitline telephone system, so staff can contact citizens direct from the database. Workflows manage call scheduling and rescheduling, helping staff ensure all calls are made on time.
With its new CRM system, Quitline was able to start delivering new, highly detailed reports to the State Government in January 2012, ensuring they met funding commitments. With excellent information to hand, and automatically scheduled calls, Quitline counsellors can ensure citizens receive a more focused, responsive service.
Highly engaged workforce
Because Quitline staff became an integral part of the design, testing and review process, staff buy-in is very high.
“Our staff helped make the CRM, so there’s a deep sense of ownership,” says Peardon. “This is critical because the CRM is now part of their everyday world – and because they’re so engaged, they’re doing things with the CRM that are really exciting.
“For example, if a client of Aboriginal and/or Torres Strait Islander descent calls, and would prefer to speak to an Aboriginal or Torres Strait Islander counsellor, staff can use the CRM to refer the caller to a particular counsellor.
“We can also analyse referrals, medications and outcomes by small sub-groups. We know when and where to follow up, and that makes the citizen the ultimate beneficiary.”
A key improvement for staff is that they don’t need technical assistance or expert database reporting skills to build new reports. They simply copy data into Microsoft Excel spreadsheets, from where they can create graphs or dashboards.
Peardon believes this empowerment improves motivation, productivity, and morale. “Staff can construct their own reports without technical assistance, which is a huge benefit to us. With reports that monitor their own progress and case outcomes, counsellors can analyse for themselves how they are succeeding in helping clients quit smoking.”
Improved analysis and management
More detailed reporting has also improved transparency and management.
“Our sponsors can see exactly how their funds are being spent, and the results feed into health statistics,” says Peardon. “In addition, with more refined data, we can analyse where clients are calling from. That makes our quit smoking programs more effective, because we know where to target our campaigns.
“More refined data also makes the CRM a very powerful management tool, because I can allocate resources better. If I can see the proportion of callers that prefer to speak to Aboriginal or Torres Strait Islander counsellors, I can plan staffing more effectively.”
Reduced long-term costs
Because Peardon’s staff have the skills and knowledge to build new dashboards, reports and workflows for themselves, the contact centre has also reduced long-term costs.
Microsoft product that was featured
Microsoft Dynamics CRM 2011 helps you enrich customer interactions. It provides your staff with real-time customer analytics and guides them with streamlined business processes that facilitate informed decision-making. With exceptional new out-of-the-box reporting capabilities, Dynamics CRM 2011 puts staff in charge of their data, with easy-to-configure, self-generated reporting. And with better customer information, you can pursue more prospects, focus on the best sales opportunities, and impress customers with timely, targeted information.