Highlights:
Certificate in Data Warehousing/Business Warehousing
? Successfully oversaw three implementations of company software installed at different insurance companies.
? Oversaw CRM program implementation and data cleansing. Assisted in establishing pipeline reports, dashboards, and data subscriptions.
? Monitored workflow metrics on behalf of various insurance agencies, measuring claim volume, severity, automotive parts usage, and vehicle characteristics in order to better optimize operations.
? Approximately $4.5 million in savings resulting from advertising analysis from 2003-2004, across 108 geographic markets.
? Supervised other analysts, managed a project that expanded the print media buy for CVS retail locations in 8 new markets.
? Provided recommendations towards media planning for dozens of geographic markets.
? Optimized CVS’ advertising, minimizing duplication and waste during the acquisition of Eckerd store locations.
? Identified dozens of needed improvements with leased proprietary software; provided testing and quality assurance on any new enhancements to the software package.
? Calculated 6 consecutive quarters of sales data, extrapolating annual sales at a ZIP Code level, identifying individual store trade areas, while incorporating potential new trade areas of stores yet to open.
? Created an annual schedule of CVS’ media analyses across all geographic markets.
? Developing a new modeling system in order to base marketing decisions on data trending, utilizing a combination of multiple regression modeling, and a decomposition of quarterly store sales.
? Introduced new analysis procedures and criteria for sub-ZIP Code print media distribution within the Las Vegas and Philadelphia markets for CVS.
Companies I like:
Digitas, Nielsen, Arc Worldwide
Provides key data warehousing and OLAP expertise, giving quality client service for major insurance agencies
Description
