MS SQL Server Management Studio

Experience:  7.6 years

Latest version used:  2017

Functionality used:

  • T-SQL:  Cursors, dynamic SQL, OpenQuery calls to other servers.
  • Stored procedures, ad hoc queries, views, function creation,  scheduled jobs.
  • Creating, modifying, populating, and dropping tables.

Sample projects:

  • Nightly scripts for survey distribution to customers.
  • Automation of much of seasonal product sales reporting (revenue and customer demographics with historical comparisons).
  • MS Access/MS Word/MSSS application to compose letters to customers based on >1 million record data sets.

See sample of my code

Return to top

Oracle SQL Developer & Toad / PL/SQL

Experience:  2.8 years

Latest version used:  11g

Functionality used:  Ad hoc queries, function creation.

Sample projects:

  • Creation of pass-through queries for MS Access applications.
  • Composing and running quality assurance scripts in data conversion projects.
  • Ad hoc queries for sales reports.

Return to top

MS Access w/ VBA automation and MS Office integration

Experience:  19.8

Latest version used:  2016

Functionality used:  Creating forms, tables, queries, pass-through queries (to Oracle & SQL Server), reports, VBA modules.

Sample projects:

  • Creation of end-to-end automated reporting tools incorporating SQL Server and Oracle inputs and 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 sample of my code.

Return to top

MS MapPoint

Experience:  4 years

Latest version used:  2013

Functionality used:  Address plotting, importing customer info for address plotting and geographic reporting of statistics and demographics, creating presentation-quality maps for reports.

Sample projects:

  • Researching possible sites for new store locations.
  • Determining under-penetrated ZIP codes for mailing list purchasing decisions.
  • Planning direct mail campaigns.

Return to top

Google Analytics

Experience:  2 years

Latest version used: December 2018

Functionality used:  Standard reports, creating 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.).

Return to top

NetSuite

Experience:  1 year

Latest version used:  (2010)

Functionality used:  Queries, deduping tool.  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).

ALSO:  Developed conventions for naming municipal clients to help differentiate different townships in same state with the same name (but different county) as well as for entities associated with unincorporated areas. Performed mass upload of new customer information after trade shows (and after data cleansing, deduping, and address verification outside of NetSuite).

Return to top

US Census Bureau website

Experience: 1 year

Latest version used:  (2017)

Functionality used:

American Fact Finder
Selecting data sets and geographic level for large extracts of demographic data for use in marketing projects.

GeoCoder
Uploading thousands of customer addresses to verify correctness of the address, get corrections to them, and have Census Bureau geocoding (e.g., census tract) applied to each.

Return to top

Software courses

Microsoft Visio 2013, December 2018
Computer Education Center - Science Museum of Minnesota (Saint Paul, MN)

Advanced Database Design, July 2008
Computer Education Center - Science Museum of Minnesota (Saint Paul, MN)

Oracle 10g SQL Fundamentals, July 2007
Onyx Software Development Training Company (Edina, MN)

System Administration for Microsoft SQL Server 7.0, February 2001
New Horizons Computer Learning Center (Richfield, 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)

Return to top