Pharmaceutical Sales Reporting and CRM
by Lou Galli
Weekly Product Tracking
Monthly Product Tracking
Managed Care Reporting
Weekly Physician Dashboards and Scorecards
Monthly Physician Dashboards and Scorecards
Speaker and Grant Reporting
Designed, developed and delivered over 50 projects in 20+ years.
Length of projects ranged from 6 weeks through 2 years. Lead teams comprised of over 50 members.
Delivered nearly all projects on time and on budget. Adhered to the agile project methodology to ensure that the customer was engaged in the entire process.
Won 12 Above and Beyond Awards for my efforts.
Received the highest possible performance rating in 4 of the last 6 years.
Largest Project: US Reporting Solution (2 Year Project)
Responsible for design, development, maintenance and enhancements of an 18 Terabyte Commercial Data Warehouse (CDW) environment for the U.S. Reporting Solution.
Solution provides a BI platform and Report Deliverables to 3,000+ Sales Associates, Front Line Managers, Regional Directors, Vice Presidents of Sales Operations and Business Analysts.
Highly proficient in creating and implementing best practice architecture across all the components of infrastructure.
My team consisted of over 50 members both on-shore and off-shore.
The distributed members were located in Bangalore, India and Saigon, Vietnam. On-shore team members were located throughout the United States.
Some of the reports generated included:
Some Technologies Utilized included:
Linux and Windows servers
Database (Oracle, MySQL, Access)
Business Intelligence (Cognos, MicroStrategy, Tableau, Qlikview)
Google Maps API
Siperian Master Data Management (MDM)
Trillium Address Standardization
Visual Studio (.NET)
Visual Basic for Applications (VBA)