Pharmaceutical Industry: ! Sales and Marketing Data Solutions and Case Study! ! A large US based global pharmaceuticals and health care company, with 90,000 employees and operations in over 130 countries, turned to Streebo to help them use Kalido MDM to its full potential and master data coming from its affiliates from all over the world.!

Pharmaceutical Industry: ! Sales and Marketing Data Solutions and Case Study! ! Pharmaceutical companies due to the critical nature of their business are always in need of up to date information, which can be applied immediately. The world we live in has become increasingly complex, with high proliferation of competition, complicated regulations and commercial considerations. ! ! Therefore, the need for quality information in a timely, executable and quickly implementable manner is very important to stay ahead of competition and to fuel business growth. Incomplete data or lack of proper information can lead to an inaccurate representation of business performance and market trends causing miscalculated sales and marketing decisions and resulting in losses to the organization. ! ! To prevent such events from occurring, pharmaceutical companies need data solutions that can evolve with the industry. Marketing and sales departments face a variety of challenges, including,! ! §  Competing effectively in the marketplace! §  Gaining business insights and data from multiple sources! §  Employing decision analytics from the available data! §  Achieving sales force optimization and effectiveness! §  Accessing accurate and timely information! §  Increasing pricing and cost pressures! §  Increasing regulatory complexity!

Pharmaceutical Industry: ! Sales and Marketing Data Solutions and Case Study! ! To compete effectively, those in marketing and sales need timely and accurate information to inform their decisions. The problem is not access to data; but the ability to gain most out of the data at hand. ! ! As most pharmaceutical companies already have access to a large amount of internal and third party data. Their main issue arises at the unavailability of proper technology to effectively analyze data in a timely manner and to make better decisions. ! ! Key technology issues that arise include; ! ! §  Absence of full data integration! §  Slow data loading that results in missed insights based on key details leading to missed opportunities! §  Outdated technology and processes that require significant end-user effort ! §  Bad and redundant data! ! Pre-defined data management workflows, a departmental data repository, data loaders for data within and outside of the organization, and timely implementation are just a few key elements Sales and marketing teams need in analytics to make good business decisions. Streebo can design and implement solutions that meet these needs.!

Case Feature: Master Data Management for a Global Pharmaceutical Company! ! A large US based global pharmaceutical and healthcare company, with 90,000 employees and operations in over 130 countries, turned to Streebo with a simple problem statement. The pharmaceutical company needed a single, accurate source for product listings across its global affiliates. The company intended to cross sell products between affiliates and also enable them to provide this mastered data to downstream business intelligence and data warehouse systems.! !

Problem! The company’s current processes and systems prevented it from fully leveraging available data. Multiple names and references related to the same product caused confusion, and extensive human effort was required to extract data and value from current systems. Both of these issues made if it nearly impossible to obtain insight into, and draw meaningful conclusions from, product performance and sales across the company.! !

Solution ! After a thorough analysis, Streebo provided the following solution:! §  Informatica for the backend ETL, ! §  Oracle as the database technology hosting Kalido and, ! §  Kalido DIW to help the company use Kalido MDM to its full potential. ! ! Using Kalido MDM, the company could now ensure unified and consistent data for its business intelligence systems, as well as better monitoring and high computational analytics. !

Case Feature: Master Data Management for a Global Pharmaceutical Company! ! Business Highlights! Streebo’s technical consultants helped plan and implement a multi-phase master data management solution. The Streebo team:! ! §  Architected and created a comprehensive business model to allow the customer to seamlessly manage data feeds from multiple data sources.! §  Maintain an on-site and off-shore collaborative development model to ensure extended coverage and a shorter implementation timeframe for new initiatives and go-lives.! §  Utilize a setup process that ensures unified and consistent data for the client’s business intelligence systems, monitoring and high computational analytics.! §  Integrated about 25 affiliates over the year from across 4 continents with data security measures in place to ensure confidentiality constraints, a critical requirement for sensitive transactional data. Around 15 affiliates are lined up to golive over the next 6 months. !

Case Feature: Master Data Management for a Global Pharmaceutical Company! ! Technology Highlights! The Streebo team is engaged and driving new affiliate integrations with a centralized master data management repository and data warehouse, a process involving ETL based on Informatica, a Kalido implementation based on Oracle as the underlying database technology and database objects for feeding BI on Qlikview.! ! Streebo architected a solution that allowed the customer to create a master data repository based on the data being received from a SAP source system from various locations.! ! Streebo utilized the powerful Informatica and Kalido MDM 9 to create an extensible and scalable model.! !

Technology Stack! §  Kalido MDM 9! §  Oracle 11g! §  Informatica! §  QlikView!

Case Feature: Master Data Management for a Global Pharmaceutical Company! ! About Streebo! Headquartered in Houston, TX and a Kalido Business Partner, is a global provider of Data Warehousing, MDM and Data Governance Solutions. Streebo provides services and solutions that complement Kalido’s product offerings resulting in an improved ROI for our customers. Many Fortune 1000 companies rely on Streebo for their business intelligence needs and we are a leading Kalido implementation partner with a track record of several successful implementations. From advance trainings to fully managed production environments, Streebo provides complete 360 degree solutions for Kalido products.!

US Headquarters:! 10998 S. Wilcrest Dr. Suite #162! Houston, TX 77099.! Phone: (832) 426-2700!

! General Inquiries:! Questions or comments: [email protected]! Recruiting: [email protected]! Marketing and PR: [email protected]! !

Stay Connected:! ! !