Sales reporting platform for one of the largest pharmaceutical company
Business Need
- Implement reporting platform for sales force of 3500 reps
- Mobility and speed
- Data from multiple sources including ERP, CRM, Sales, Specialty Sales, and Targeting
- Actionable information
- Alerts and Summaries
Challenges
- Ensure data quality while delivering actionable insights
- Performance issues on mobile platform
- Metrics and goals based on product portfolio
Stakeholders
- Company leadership
- Sales and marketing
- Sales analytics
- Vendors
- Information technology
Approach
- Aligned approach and architecture between the various stakeholders
- Developed data warehouse to consolidate and summarize data
- Designed process to define and execute alerts
- Built quality assurance checks into data processing framework
- Participated in sales meetings for training and feedback
Results
- iPad based platform deployed to sales force
- Helped adaption of mobility platforms such as CRM and call detailing