Counsellors dynamic client data system helps Queensland smokers quit.

“We can 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.”

Shelley Peardon, A/Allied Health Coordinator, Health Contact Centre, Health Services Support Agency, Queensland Health

As the Federal Government introduced new quit smoking programs in 2010–11, the Queensland-based phone service, Quitline, faced a challenge. Executives wanted to deliver these new programs, but to be eligible, they had to create far more detailed reports than was possible using their current database: they needed to be able to track referrals, client information and outcomes according to individual client segments.

Using an Agile deployment methodology, Microsoft Services took the lead in a fast-paced deployment of the newly released customer relationship management (CRM) product, Microsoft Dynamics CRM 2011. A combined team of on-site Microsoft experts, Microsoft Gold Certified Partners and Quitline staff designed, tested and deployed a new customer management system in a highly collaborative deployment, with Quitline staff providing input at every stage.

Completed in less than four months, the new CRM is a huge success. According to the Quitline Manager, a highly committed effort has created a CRM with exceptional reporting capabilities, and which staff love to use. Best of all, CRM reports, dashboards and workflows can be configured without additional coding, which reduces long-term support costs and empowers staff to develop their own productivity-enhancing reports.

*
*We wanted to be fully compliant with reporting requirements for new programs by January 2012. This gave us just six months to build a completely new customer database and get it operational.*

Shelley Peardon
A/Allied Health Coordinator, Health Contact Centre, Health Services Support Agency,
Queensland Health

*
Business Needs

Quitline is a telephone-based counselling service run by Queensland Health that provides advice and referral services to clients who wish to give up smoking. Based in Brisbane, the service operates from a Queensland Health contact centre that employs 50 counsellors, and provides over 1,200 consultations per month.

To manage the service and keep track of clients, Quitline used a combination of custom software tools and a database, but staff found them cumbersome to use and difficult to adapt.

“Our existing database didn’t contain all the information staff needed, and the information that was there wasn’t easily accessible,” says Shelley Peardon, A/Allied Health Coordinator, Health Contact Centre, Health Services Support Agency, Queensland Health. “As a result, counsellors didn’t have easy access to client information during a call.

“The database was also quite cumbersome for follow-up activities. For example, a clients’ address had to be lifted manually from the database and re-entered into the system we use to despatch medicines. It was very manual – we wanted efficiencies.”

While considering a replacement during 2011, Peardon and her staff faced changing reporting requirements from the service’s Government sponsors.

“The Government provided new funding, but to deliver on commitments we needed to provide much more detailed reports – specifically reports that identify different types of clients, and tracked progress and outcomes
within each client segment,” says Peardon.

“To ensure we could provide adequate reporting, we needed to be able to record more data, interrogate it ourselves and design our own reports.

“Speed was absolutely vital. We wanted to be fully compliant with reporting requirements for new programs by January 2012. This gave us just six months to build a completely new customer database and get it operational.”

Solution

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.

*
*I believe Microsoft had a commitment to get the CRM right; I believe they cared. Above all, their methodology worked.*

Shelley Peardon
A/Allied Health Coordinator, Health Contact Centre, Health Services Support Agency,
Queensland Health

*
“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
deploy iterations.

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.

Benefits

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.”

Self-configured reporting

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.

For More Information 

For more information about Microsoft products and services call the sales and information line on 13 20 58 Monday to Friday 8am to 8pm AEST. To find a partner or solution, visitwww.microsoft.com/australia/findapartner/

客户规模: Medium Organization
行业: Public Health & Social Services
国家或地区: Australia
解决方案:
  • Microsoft Dynamics CRM
  • Microsoft SQL Server 2008 R2 Enterprise
  • Windows Server 2008 R2 Enterprise
组织机构简介: Quitline is a telephone service that provides 24/7 health information, counselling and referral services to Queensland citizens who wish to stop smoking. They are a part of state-run Queensland Health, but receive additional funds from other sources, including the Federal Government.
业务状况: The existing Quitline database could not segment customer groups or generate the variety of reports Quitline needed to comply with the evolving requirements of its principal funding body, the Federal Government.
利益:
  • Highly engaged workforce
  • Self-configured reporting
  • Improved analysis and management
  • Reduced long-term costs
可下载的资源Word 文档