​​​​announcements

multinational pharmaceutical company gets competitive advantage with a sales and marketing business intelligence (bi) solution from db wizards

August 7, 2013 Manila, Philippines – A leading multinational supplier of branded and generic pharmaceutical company has partnered with dB Wizards, a leading IT solutions provider, in the implementation of a Business Intelligence Solution that will allow them to efficiently monitor sales and marketing performance.

About

This Pharmaceutical Company is a subsidiary of a Group of Companies based in South Africa that caters to more than 150 countries around the world. The need for a BI system was brought about by difficulties in creating accurate sales reports and incentives per Med Rep based on actual sales generated.

“We have had difficulties in the calculation of incentives for our Med Reps. We encountered huge discrepancies due mostly to human error,” shared Mr. Jojo Casaje, Group Sales Manager of this leading pharmaceutical company. They became aware of these discrepancies but were not able to pinpoint where the errors were.

dB Wizards developed a customized reporting and analysis solution for the pharmaceutical industry running on Microsoft SQL Server 2012. With the latest enhancements on SQL Server, the system allows this Customer to process their monthly sales reports in minutes instead of days. These reports gathered from several sources nationwide are now easily transformed into a single master list. With this, strategic business plans for improvement are immediately made available - i.e. the Management can promptly act to address issues such as which areas are behind/on track in terms of sales target and they can simply analyze sales data based on the consolidated reports.

“We saw data in incentives that do not match. Because of the extra layer of validation, this Customer's sales team immediately understood how to fix the calculation and how to do it themselves without relying too much on IT people,” shared Mr. Poch Reyes, Managing Director of dB Wizards.

The Customer is now able to process their monthly sales reports and incentives calculation within minutes from their usual 3-5 days of manual processing. Templates are already provided to be filled up using their Android Tablets integrated with the system for automatic data upload. This process easily records the number of hospital visits of Med Reps, and the actual sales they make per day versus calls made. Most importantly, accuracy of data is greatly increased because processes are now automated.

“We have chosen dB Wizards from three other suppliers not only because they have what we need for data warehousing and reporting, we also saw their expertise in the Pharmaceutical Industry particularly their implementation experiences with large pharmaceutical companies such as Zuellig, Wyeth, Euroasia and more. Also, the scalability of BI for Pharma is really something that is very adaptable to our current requirements and for many years ahead,” said Mr. Ian Xavier, IT Manager.

dB Wizards has been in the IT business for 14 years now, implementing innovative solutions for data warehousing, analysis and reporting. Pocholo Reyes, Managing Director of dB Wizards, shares his thoughts, “We are thankful to have the opportunity to assist industries such as Aspen and to help them further realize their potential in the market today. To continuously address our customers’ needs, we intend to continue enhancing and offering solutions for business productivity such as BI for Pharma.”

The Philippine office of this Pharmaceutical Company, together with their Australian office, now gears toward enhancing their infrastructure and is currently engaging dB Wizards for another full-blown project.


Blog Message

Story title

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum varius, tincidunt odio nec, placerat enim.
Blog Message

Story title

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum varius, tincidunt odio nec, placerat enim.
Blog Message

Story title

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum varius, tincidunt odio nec, placerat enim.
Read more stories...
Blog Message
Alex Smith20 minutes ago

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum varius...

Blog Message
Dan Smith1 hour ago

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum varius...

Blog Message
David Smith11/10/2013

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam id ipsum varius...

Moblie SharePoint San Francisco 2014 April 28, 2014

San Francisco, California, United States


4th Conference on Business Intelligence May 29, 2014

Manila, Philippines


International Cloud 2014 June 18, 2014

Saigon, Ho Chi Minh, Vietnam

The Wizards Magic

We're proud to share the magical results we bring to our customers' businesses. Check out our growing list of satisfied customers per industry.

The Winning Team

Meet our Management Team and the winning people behind what makes Wizardsgroup the Partner Implementer of Choice of many customers.

Attend an Event

Join us to an in-person or online event. Network with our inhouse experts and your peers. Discover great IT solutions available in the market today!

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.


Correlation ID:bfbd119e-d0af-4000-b7d6-52e7ef5ece5b

Contact us

28F 88 Corporate Center
Sedeno corner Valero Streets
Salcedo Village, Makati City 1227
Phone: (632) 757-4889, Fax: (632) 757-4890
Email: ndph.marketing@nttdata.com

Go Social

Our Competencies

Image Image