My rare background as both an intelligence analyst and an MS SQL Server/MS Office developer enables me to meet business needs no one else can. I provide actionable intelligence from the data you have or will find the data you need. I help you define the questions that should be answered and find their answers. I also help improve your business processes by identifying waste and by automation. I create tools to let you do your own analysis and reporting.
On my site you will learn about some of my projects through case studies, brief descriptions , and work samples. I have categorized them for you below.
I look forward to discussing with you how I might help meet your business objectives.
Prospect identification; journey mapping; customer acquisition & retention; developing customer segmentation schemas; campaign design & results analysis.
Clients:
- US Army
- Toppan Merrill
- Anchor Bancorp
- YMCA of the North
- Minnesota Orchestra
Identifying products for price increase or decrease; creating programmatic pricing systems using algorithms and guardrails; developing self-serve database tools to analyze and define prices for products and services.
Clients:
- Target
- Best Buy
- MTS Systems
Clients:
- Target
- Nabisco
- Best Buy
- Medtronic
- Wells Fargo
- MTS Systems
- Ameriprise Financial
- Royal Bank of Canada
- Global Traffic Technologies
- Blue Cross/Blue Shield of Minnesota
Automation of business processes in MS Access and Excel, interacting with databases like SQL Server and Oracle and with Outlook, Word, and PowerPoint. Applications include self-serve reporting tools, price-setting, financial service processes, and marketing campaigns. User interface design that is elegant and mentally-ergonomic.
Mapping & improving processes; eliminating bottlenecks; lean implementation; root cause analysis; developing & tracking quality metrics; data hygiene; quality specification management.
Clients:
- Nabisco
- Medtronic
- Wells Fargo
- YMCA of the North
- Ameriprise Financial
- Global Traffic Technologies
- Drug Enforcement Administration
Combining demographics, psychographics, geography, statistics, actions by competitors & customers, technology, and other dimensions to produce actionable intelligence.
Clients:
- Nabisco
- US Army
- Toppan Merrill
- Anchor Bancorp
- YMCA of the North
- Minnesota Orchestra
Email marketing & campaign analysis; pixel-tracking; UTM tagging; Google Analytics reporting; digital ad pricing analysis & recommendations.
Clients:
- Target
- YMCA of the North
- Minnesota Orchestra
Identifying opportunties and threats through systematic monitoring and analysis.
Clients:
- Nabisco
- US Army
- Wells Fargo
- Toppan Merrill
- Drug Enforcement Administration
Copyright Will Beauchemin 2024