Although I started my career as an intelligence analyst, I soon acquired database and programming skills to support my work. As demand for competitive intelligence analysis declined, I began to emphasize my technical skills. Sometimes, my clients sometimes needed both my analytical and technical skills.
I have worked on projects managed using agile methodology for Amerprise Financial and Wells Fargo. In the last few years, I have used agile principles on projects where I was the sole developer.
My projects involving database and software development are described throughout the project descriptions you will find on the "Projects" and "Problem solving" pages available from the menu at the top of this page.
MS SQL Server Management Studio and T-SQL
Experience: 7 years
Functionality used:
- Creation of stored procedures and functions
- Data Manipulation Language
- Data Definition Language
- Cursors and other complex SQL
- Error handling
Sample projects:
- Price-setting and analysis tool for thousands of products.
- Self-serve sales & marketing reporting tool using dynamic SQL in SQL Server CRM database.
- Nightly scripts for survey distribution to customers.
- Automation of reporting and contact list generation using T-SQL.
- MS Access/MS Word/MSSS application to compose letters to customers based on >1 million record data sets.
Formal instruction:
System Administration for Microsoft SQL Server 7.0, February 2001
New Horizons Computer Learning Center (Richfield, MN)
Oracle SQL Developer / PL-SQL
Experience: 3.5 years
Functionality used:
- Creation of stored procedures and functions.
- Data Manipulation Language
- Data Definition Language
- Cursors and other complex SQL.
Sample projects:
- Creation of pass-through queries for MS Access applications.
- Composing and running quality test scripts in data conversion projects.
- Ad hoc queries for sales reports, marketing campaigns, quality assurance.
Formal instruction:
Oracle 10g SQL Fundamentals, July 2007
Onyx Software Development Training Company (Edina, MN)
Teradata SQL Assistant / Teradata SQL
Experience: 1 year
Functionality used:
- Creation of stored procedures and functions.
- Data Manipulation Language
- Data Definition Language
- Cursors and other complex SQL.
- Error handling.
Sample projects:
- Automated daily pricing system for tens of thousands of products (stored procedures, tables, functions, and views).
Formal instruction: None (self-taught).
Hadoop / HiveQL
Experience: 1 year
Functionality used:
- Data Manipulation Language
- Data Definition Language
Sample projects:
HiveQL scripts to pull data to support product price-setting decisions and to populate a Domo executive dashboard.
Formal instruction: None (self-taught)
MS Access w/ VBA automation and MS Office integration
Experience: 25 years
Functionality used:
- Creating forms, tables, queries, pass-through queries (to Oracle, SQL Server, and Teradata)
- Visual Basic for Applications (VBA): e.g., automated email, import/export using Excel and text files, export to PowerPoint, automated MS Word mail merge.
- In general, I created distributed user-friendly applications and personal-use, task-specific applications.
Sample projects:
- Creation of end-to-end automated reporting tools incorporating SQL Server and Oracle linked sources as inputs with outputs to Excel, Word, PowerPoint, and Outlook.
- Creation of ad hoc reporting databases incorporating data imported from diverse sources (e.g., data hygiene projects, sales and demographic reporting).
See the projects described on the pages below for how I used MS Office automation to provide solutions to business problems.
Price-setting & price analysis
Creating self-serve tools for reporting & analysis
Quality assurance & process improvement
Formal instruction:
Advanced Database Design, July 2008
Computer Education Center – Science Museum of Minnesota (Saint Paul, MN)
Advanced Microsoft Access, June 1998
Chubb Institute for Advanced Studies (Parsippany, NJ)
Programming in Visual Basic 4.0, December 1997
Chubb Institute for Advanced Studies (Parsippany, NJ)
Domo
Experience: 1 year
Functionality used:
- Creation of cards and dashboards.
- Creation of dataflows from database-fed and file-uploaded sources.
- Extract-Transact-Load (ETL) operations.
Formal training: None (self-taught)
Tableau
Experience: 3 months
Functionality used:
- Connection to LIVE and EXTRACT sources.
- Creating sheets and presenting on a dashboard.
- Adding interactivity to sheets and dashboards.
- Custom formula creation.
Formal training:
Tableau introductory training online (January 2016)
Tableau Software, LLC, tableau.com/learn/classroom
Tableau Next Steps (live online training; August 2021)
O'Reilly Media Inc.
Hands-On Tableau Training for Data Science (online; June 2022)
Udemy, Inc.
Tableau for Data Visualizations (live online training; July 2022)
O'Reilly Media Inc.
Power BI
Experience: Classroom only
Formal training:
Microsoft Power BI First Steps
O'Reilly Online Training (January 2021)
Power BI
Normandale Community College (October 2023)
Salesforce
Experience: 6 months
Functionality used:
Researching opportunities and campaigns (including client budgets and planned billing).
Formal training: None (self-taught)
NetSuite
Experience: 1 year
Functionality used:
- Querying clients and products.
- Deduping tool.
NOTE: My primary use was linking data from back-end to use in self-serve reporting application built with MS Access (which provided much more flexibility in reporting than NetSuite front-end offered).
Formal training: None (self-taught)
Google Analytics
Experience: 2 years
Functionality used:
- Standard & custom reports
- Scheduling auto-delivery of reports
- Ad hoc campaign reporting based on UTM tags.
ALSO: Developed taxonomy for UTM tags to support measurement by specific object in email (e.g., header link, footer link, particular body text link, image link, etc.).
Formal training: None (self-taught)
MS Visio
Experience: 6 months
Functionality used:
- Process maps.
- Entity relationship diagram (database mapping)
- Organizational charts.
- Floor plans.
Formal training:
Microsoft Visio (January 2016; December 2018)
Computer Education Ctr - Science Museum of MN
Confluence
Experience: 1.5 years
Functionality used: Uploading & sharing documents
Formal training: None (self-taught)
MS Teams
Experience: 1.5 years
Functionality used:
- Documentation creation
- Project management
Formal training: None (self-taught)
Dow Jones Factiva
Experience: 4 years
Functionality used:
- Keyword & topic watches
- Ad hoc searches
Formal training: None (self-taught)
SAP/ERP
Experience: 3 years
Functionality used:
- General product research.
- Researching and editing prices with VK11/12/13.
- Composing my own queries in SQVI (QuickViewer) to extract large amounts of information on products and their costs. Used in SQL Server datamart to support pricining decisions.
Formal training: None (self-taught)
Copyright Will Beauchemin 2024