Pharmaceutical Sales Reporting and CRM

by Lou Galli

Application Development
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:

  • Weekly Product Tracking
  • Monthly Product Tracking
  • Managed Care Reporting
  • Weekly Physician Dashboards and Scorecards
  • Monthly Physician Dashboards and Scorecards
  • Hospital Reporting
  • Call Reporting
  • Sample Reporting
  • Incentives Contests
  • Speaker and Grant Reporting


  • Some Technologies Utilized included:
  • Linux and Windows servers
  • Database (Oracle, MySQL, Access)
  • ETL (Datastage)
  • Business Intelligence (Cognos, MicroStrategy, Tableau, Qlikview)
  • SAS
  • Google Maps API
  • Siperian Master Data Management (MDM)
  • Trillium Address Standardization
  • Visual Studio (.NET)
  • Visual Basic
  • Visual Basic for Applications (VBA)
  • SAS
  • PHP
  • Python
  • Java
  • CSS
  • HTML
  • Javascript
  • DHTML
  • XML


  • Copyright 2019