Optimization and Re-Design :

Pharmaceutical Reporting Application using SAS & VBA

I had enhanced a pharmaceutical Sales and Marketing reporting application by:

• Creating a map of the legacy system data sources, joins/merges/filters/calculations and outputs
• Re-writing the new process in three steps:
  1) Load all data sources,
  2) Merge & calculate into 1 master table
  3) Output reports by filtering from the master table
• Code was reduced by two-thirds
• The application run-time was reduced from 30 minutes down to 8 minutes

Pharmaceutical Reporting Application using SAS & VBA

I had enhanced another pharmaceutical Sales and Marketing reporting application by:

• Optimizing user interactive control response time :
  1) Identifying the slowest parts of the code
  2) Replacing conditional (color) formats with color properties
  3) Replacing looped cell references with range references
  
  
• Result: User controls responded in less than 1 second