Portfolio : Code Snippets : Resume : Contact

Pete Erwin - Resume
PO Box 666
Assonet, MA 02702
tel. (508) 644-9962
fax (413) 513-4429

Database and Web Developer with graphic design background and a passion for new media is available for projects developing e-commerce and database driven web sites.


Professional Experience


Vice President
Business Systems Analyst IV

Citizens Financial Group - www.citizensbank.com
Lincoln, RI
9/2002 - present

Currently working in Portfolio Credit Risk Department. Manage SQL Server databases with bank's commercial loan portfolio. Developed ETL process using MS-SQL DTS Packages to extract loan data from multiple servers across bank into single data warehouse for group risk analysis and monthly reporting. Mapped and extracted data for pre-conversion reporting for several bank aquisitions.


Senior Web Developer
Tom Snyder Productions - www.tomsnyder.com
Watertown, MA
10/2000 - 9/2002

Managed all technical aspects of company Web site with a focus on developing front-end Web and back-end database driven enhancements. Examples range from source code 'click-through' tracking for monthly email campaigns to developing online surveys, search utilities, Dealer Sales Extranets, and custom online registration systems.


Information Systems Manager / Webmaster
Tom Snyder Productions
Watertown, MA
09/1999 - 10/2000

Managed day-to-day use of Ecometry order fulfillment system and supported all users in marketing, customer service, sales, accounting and shipping departments. Organized and performed Y2K upgrade and testing.

Contributed to redesign of company web site (ASP/SQL) and built an automated e-commerce system.

Developed opt-in email subscription system for sending monthly messages to 45,000 customers.


Marketing Systems Manager
Tom Snyder Productions
Watertown, MA
01/1999 - 09/1999

Provided technical support for marketing and sales department initiatives such as catalog and email campaigns, web page creation, creation of online survey system. Managed upkeep of Apache web server and MPE/iX database system running Ecometry. Provided software support for Robelle SuprTool and Cognos PowerHouse (QUIZ).


Technical Support Representative
Tom Snyder Productions
Watertown, MA
10/1996 - 12/1998

Provided technical support to customers (K-12 teachers and administrators) via phone and email for software products published by Tom Snyder Productions.



Skills

AUTHORING TOOLS

  • Adobe Photoshop
  • Macromedia Dreamweaver MX
  • Macromedia Fireworks MX
  • Microsoft Visual Basic .NET

SOFTWARE DEVELOPMENT

  • HTML
  • JavaScript
  • Perl
  • MS-SQL Data Transformation Packages (DTS)
  • Visual Basic / VBScript
  • ASP 3.0
  • CGI
  • XML

PLATFORMS / SERVERS / MISC.

  • HP 3000 MPE/iX
  • MacOS
  • Microsoft IIS
  • Microsoft Site Server 3.0 Commerce Edition
  • Microsoft SQL Server 7.0/2000
  • Microsoft Windows 9x/2000/XP
  • Microsoft Office 9x/2000/XP
  • WebTrends Analysis Suite



Other Training


ASP.NET Programming

April 2003

Programming a Microsoft SQL Server 2000 Database
June 2003

Administering a Microsoft SQL Server 2000 Database
July 2003

Microsoft Windows 2000 Network and Operating System Essentials
September 2003

Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000
October 2003


WebTrends Analysis Series Essentials
May 2001

Fast Track to Dreamweaver UltraDev
March 2002

WebTrends Analysis Series Essentials
May 2001


Ecometry the Basics - January 1999, May 2002
In-depth, hands on course covering all the important Ecometry functions: Merchandising & Purchasing; Advertising & Sales; Telemarketing & Ordering; Warehousing & Shipping; Accounting & Reports

Databases and Analyzers - May 1999
Gained a highly technical study of the underlying structure of Ecometry and Analyzers including troubleshooting tips with the ability gather data and define and resolve issues involving IMAGE, Omnidex, MACORD, MACITM, MACMAN and SGBASE datasets.

SuprTool - May 1999
Completed an intensive hands-on course on the use of SuprTool from basic commands through combining data from different datasets. Gained knowledge on the use and application of SuprTool by examining data stored in Ecometry databases and extracting and manipulating data, creating and using output files, tabling, and building.



Education
UMass/Dartmouth
Bachelor's, History
Dartmouth, MA 1993

UMass/Dartmouth
Massachusetts Teacher Certification - Grades 9-12 History
Dartmouth, MA 1994


Other

Volunteer Web Developer/Webmaster for Town of Freetown (web site)

Member, Freetown Historical Commission (web site)

Walked and hitchhiked across the USA from 1990-1991 (web site)


References

Available upon request.