Kevin C. Email and Phone Number

Providing business analytics for the purpose of marketing to individuals needing supplementary insurance to their Medicare coverage during their retirement years. Development of statistical analyses and models which enable a variety of data-driven decisions such as maximization of prospect response, tuning the frequency and timing of offers, optimization of blended advertising campaigns, and utilization of outbound and inbound marketing channels.

Maximized marketing revenue for clients from financial, retail, airline, and automotive industries by working with their internal marketing teams to optimize promotions using target segmentation, offer applicability, cross-product/service expansion, lifecycle and seasonality impact analysis, and channel exposure (mail, call center, website, TV/radio, in-person sales) analysis. Reduced needless client expenditures by identifying errors and inefficiencies ($3.5 million in one project alone). • Provided business dashboards for RFPs and health of the program using Xcelsius & SSRS.• Created and implemented response and retention models using regression techniques.• Projected mail & sales volume forecasts for client’s negotiation of annual performance targets.• Developed customer and product segmentations. Recommended ROI optimization strategies.• Designed marketing campaign strategies for statistical test/control comparison.• Produced economic analyses of distressed states after the credit crisis of 2008.• Presented seminars on selecting test & control groups for complex promotions, developing mail & sale volume forecasts, create dynamically updated dashboards.

Performed statistical analyses on transaction data for Measurement Strategy Consulting department.• Generated statistical graphs and metrics for use in marketing planning presentations. Test and control groups were created and analyzed to determine effectiveness and return-on-investment of point-earning sales promotions. Profiles were built of key consumer groups to help identify actionable improvements to marketing strategies. Business exposure included agricultural/chemical, air travel, and telecommunication industries.• Produced data analysis programs increasing the availability of sales, product, retailer, customer, and point earning/redemption information for ad hoc requests.• Created data feeds and reports using SAS, MS Excel, and MS Access to identify and select top candidates for mail marketing campaigns, membership kits, and catalogs.

Provided full spectrum of system life cycle expertise including project management, systems analysis and design, software development, and database administration.• Nominated for the Business Value Award at The Prudential as the Systems Architect who designed and implemented the carrier data interface system on the Prudential Outbrokerage General Agency project increasing carrier customers and revenue.• Saved The Prudential $750,000 in annual fees by replacing an external compensation feed system with an innovative in-house solution which was more scalable, extensible, maintainable, accurate, and available to end users. Received commendation from CIO for accomplishments towards the company’s success.• Created VB programs and ActiveX components to pull data from an MS Access compensation database, perform calculations and Hexadecimal conversions, construct data feeds, and automatically transfer them via FTP to network MVS mainframe compensation systems.• Created a VB program to dynamically compare different versions of an MS Access database and report all structural differences for explicit validation before implementing the newest version into production. • Designed and implemented a desktop database configuration management architecture for administrative control over multiple development efforts involving separate change requests and system integration tests. • Designed entity relationship diagrams, implemented databases with their component tables and columns, and wrote MS Access SQL queries, macros, reports, and VBA code modules. Created and published maintenance and status documentation as the production DBA. • Developed SAS programs to read from multiple QSAM files and create statistical feeds for campaign marketing purposes.• Coordinated the activities of a dozen insurance companies’ data streams with three internal compensation departments to enable prompt and accurate commission payments and production credits to agents and sales managers.