Denis Ramsay
10 Tanglewood Lane, Unit 315
North Providence, RI 02904
 [Send email to request phone number] 70-9211
[Send email using form at bottom]


Experience
Web Application Developer – Reed Business Information (contract)  August
2008 – Current
•	Maintain and enhance 7 classic asp internet facing web applications.
•	Bug fix and web site enhancements for approximately 40 internet facing
applications.
•	SQL Server 2005 as back-end storage utilizing store procedures. 
•	Manage Microsoft Visual Source Safe for 4 source control databases. 
•	Managing/maintaining .Net applications for data loading into SQL.
•	Created vb.net application designed to export SQL data to XML for RSS site
feeds.
•	Created vb.net application to load excel documents to populate SQL Server
allowing dynamic updates to web site.


Web Application Developer – Citizens Bank (contract)  June 2007 - August
2008
•	Maintaining N-Tier asp.net web application to incorporate new
features/functionality.
•	Upgrade classic asp application to asp.net code.  
•	Modify vb.net 2.0 application which moves data from SQL Server to a mainframe
application.  
•	Create development documentation/specifications.  
•	Design SQL Server tables and stored procedures to interact with new
functionality of Web application.  
•	Design database driven reports using SQL Reporting Services.  
•	Design/implement .config file encryption schema.  
•	Design/implement application logging into all applications.  
•	Migrate DTS Packages from SQL Server 2000 to SQL Server 2005 SSIS environment.

•	Modify application in asp.net for password maintenance (Expire, encrypt) on a
web app.  
•	Create vb.net windows application that reads data from sql server and posts it
to a mainframe using attachmate api emulator interface.  
•	Create web based application to track collateral information scanning
information from a barcode, storing in a sql server.  
•	Create SRS Reports as a replacement for Crystal reports.  
•	Develop security framework to manage the security of information being stored
in web.config (Login Names, passwords).  
•	Create vb.net application utilizing triple DES encryption schema and the .Net
framework to encrypt connection string information, while maintaining a security
key file external to the application.  
•	Create Web based application to allow the company to save countless man hours
on Security Permissions maintenance and approval process; tightly integrating the
application into Active Directory via the LDAP Syntax for displaying live
information to the management staff.

IT Analyst/Developer – Rhode Island Student Loan Authority  March, 2005
– June, 2007
•	Create and maintain a blackberry based web application written in .NET
•	Create .NET based application for allowing students to apply for loans on the
internet. 
•	Manage corporate wide SQL 2000 based servers to include security management,
database/table creation to conform to needed development specifications.  
Maintain current DTS Packages.  
•	Perform SQL Server upgrades from SQL 2000 to SQL 2005.  
•	Upgrade DTS Packages to COM Components accessible via the component services
module of Windows server 2003.  
•	Maintain classic ASP code, while migrating to ASP.NET.  
•	Create an application in VB to interface with Sovereign Bank to allow local
universities to transfer student refunds via ACH saving hundreds of hours per
month in manual processing.  

IT Analyst/Developer - Civigenics, Inc. August, 2000 – December 2004
•	Architect, design, implement and support corporate infrastructure (Windows
Server 2003 AD, Exchange Server 2000, SMTP Servers, FTP Servers, HTTP(s)
Servers), data management (SQL Server 2000, Oracle 8.0) and collaboration
applications. 
•	Ensuring all daily backups were performed successfully (Backup Exec 9.1)
•	Norton Anti-Virus Corporate Edition is maintained and updated with current
virus definitions; and that all servers (hardware and software) are configured
appropriately for optimal performance.  
•	Direct staff members (including software developers, systems integrators, and
test engineers).
•	Maintained budgetary responsibility for the department and negotiated
contracts with external vendors. 
•	Maintaining the corporate Internet/Intranet web site originally written in
Classic ASP, eventually re-designing the web sites in ASP.NET.  

Internet Developer - Boston Scientific Corporation (contract) 	March,
2000 – August, 2000
•	Redesign the company Intranet (from static HTML to ASP/VBScript)
•	Design and implement COM Components hosted in MTS communicating with Oracle
and MSSQL Server. 
•	Using ASP, COM, Oracle, HTML, and Visual Interdev 6.0, designed a Web based
internet application allowing potential employee candidates to create their
resume on line and submit to internal Recruiters via SMTP server side technology.
 
•	Created Intranet Application allowing employees to search through Oracle
database for current Job Opportunities, then apply for the position on-line. 
•	Created web based application-enabling employees to enroll in training courses
offered by the company.  

Internet Developer - Interpro Workforce Mgmt (contract)  October, 1999 –
March, 2000
•	Design / Document and develop an Internet Web Time and Attendance
application.
•	Using ASP, COM, DCOM, Oracle, HTML, and Visual Interdev 6.0. 
•	Using pre-built COM components to enable web page functionality.

Application Developer - Mercedes Benz (contract)  September, 1999 –
October, 1999
•	Completed unfinished application using VB 6.0, MTS, SQL Server to allow
Mercedes' dealerships to prepare on-line applications for Credit. 
Intranet Developer – American Express (contract)  August, 1998 –
September, 1999
•	Design and develop Intranet Application for Corporate Expense reporting using
ASP, COM components, and SQL Server backend.   
•	Design and develop business rules of the application, using class objects.   
•	Interact directly with Corporate Customers to implement the application at
customer sites.

Systems Analyst – Continental Airlines  November, 1997 – August, 1998
•	Design/develop web based software using ASP/COM and MS SQL Server to enable
connectivity between pilots, flight attendants and corporate headquarters.  
•	Design/develop web based software using ASP and SQL Server for internal
contract management; allowing management to query worldwide airport based vendor
contracts.  
•	Design/develop software using COM SQL Server and SNA Server; allowing pilots
and flight attendants to access the corporate mainframe via the WWW for
scheduling and flight management.

Education
United States Marine Corps – 1st Marine Division Information Technology Group –
Camp Pendleton, CA 1983-1987