Kevin M.
Coleman
(978) 649-2753
Op Systems: Win 2003 Server, Win XP, Win 2000
(client and server), Win NT, UNIX/Ultrix, VM/
.
OO
Languages: C#.
Web Development: C#.
Databases: MS SQL Server 2000 and below,
Oracle, RDB, MS ACCESS, Informix
Oracle: Version 8 DBMS, Forms,
CASE, PRO*C, PRO*FORTRAN, PL*SQL
XML Creation of XML documents to pass information to and
from databases. Obtained specific experience with
Hardware: PCs (servers &
desktops),
Report Writers: Seagate Crystal Reports, SQL-Server Reporting Services
Other Tools: Microsoft .
Source Control: Microsoft SourceSafe, Rational
ClearCase
Certifications: Microsoft
Certified Professional - Solution Developer Since 1995
EDUCATION:
MSCS 1993
Masters of Science - Computer Science, December 1993.
BSCS 1988
Bachelor of Science - Computer Science, June 1988.
Recent
Classes
Advanced .
·
(taught by .
·
Introduction to
Java course (1 week)
·
Introduction to Web Development with Java course
(1 week)
EXPERIENCE (Contract)
Fidelity Investments -
·
Developed
TBXWeb website and Content
Management System. Currently involved in .
·
TBXWeb,
a .
·
The
corresponding Content Management Tool for TBXWeb was also written in C#.
·
Also
supporting a legacy trading application, called Brokerage Exchange, and
currently written in ASP, VB/COM, and DHTL that has a current user community of
about 5,000 traders.
·
While
redesigning Brokerage Exchange, I am currently involved in a much large
fidelity-wide initiative of building a Common .
·
Developed
NASA
for Correspondents, a web-based application for Fidelity Correspondent
account creation to be used in external Fidelity locations. A sister
application to NASA, this tool allows for fast account creation for several
types of Fidelity accounts including Individual, Joint, IRA, Sep-IRA, Keogh and
Trust.
·
The
application was written in ASP, VB, Jscript, XML, and COM. The database interface
used a view against several Informix and Oracle databases.
·
·
The
complexity in the application was handling all of the business rules so that
each account could be created with speed and accuracy.
·
The
applications large user base and complexity of the super-view made development
and testing against several databases a must (Dev, QA, Test, and production).
·
Also
worked to prototype this application, among others, to be redeveloped in
Microsoft .
Ropes & Gray -
·
Worked
onsite developing a Lawyer Tracking System.
·
Building
.NET web forms and associated class logic to support maintenance of projects,
teams, team members, and assignments of Lawyers for the firm of Ropes and Gray.
·
The
application written in Microsoft.
Coleman Consulting,
Inc. Tyngsboro, Massachusetts (October 1999 July 2003)
·
Worked
developing several dynamic and ecommerce websites for local customers.
·
These
websites all had custom web-based content management tools written in .
·
Each
web application utilized
·
Development
languages include C#, VB.
·
These
websites included:
v
iPrepay (http://www.iPrepay.net)
v
Azabbo Real Estate (http://www.azabbo.com)
v
World Tech Consultants (http://www.worldtechconsultants.com)
-
v
v
Town of
v
Channel Bridge Marketing (http://www.channelbridgemarketing.com)
-
v
DemandFacts, Inc. (http://www.demandfacts.com)
-
v
The Flannery Group (http://www.theflannerygroup.com)
-
v
Turnpike Rebate (http://www.turnpikerebate.com)
-
·
Creative Exchange, Inc. -
v
Rewrite
a client-server quotation management system for a printed circuit board design
company. This redesign allows management to more effectively track multiple
iterations of proposals and quotes for a multitude of customers. The system
also manages the content assigned to a quote and can be the tool that emails
the quotation, in its entirety, to the customer for consideration.
v
The
application was rewritten in Visual Basic 6, with an Access database using
v
The
database is centrally located giving the management team access to the whole of
the data.
v
Distribution
of the software kits are provided with the use of Wise Install Builder.
·
Perkin-Elmer -
v
Designed
and developed a Timecard maintenance System that allows non-exempt employees to
punch in and out during the course of any workday.
v
An
intuitive front end was created allowing users to use a card swipe machine to
validate the employee privileges and gain access to the application. Proper
error checking was performed and feedback given graphically to the employee.
v
The
website was written using ASP, VBScript (server-side only) and Jscript.
v
This
new functionality had to be written to integrate with a large portion or code
that was previously written. The whole code base was to be consolidated.
v
The
backend was initially written using
·
Azabbo Real Estate (http://www.azabbo.com)
-
v
Designed
and built a dynamic website to showcase new and existing home sales in the
local area. Features include Showcase Home, Open Houses, Dynamic residential
and commercial listings, and a tie in to Azabbo-specific
v
Technologies
used ASP, Jscript, VBScript, HTML,
v
Created
a web-based content management tool for the website. This ASP application
allows the customer to maintain their dynamic content (characteristics such as
pricing, status, etc) for the exclusive listings on their website.
v
Other
pages in this site are static detail pages showcasing some local builder
drawings, local news, etc.
·
Compaq Computer Corporation
v
Support
ActiveAnswers website. This website enables end users and
resellers to configure high-end Compaq servers and workstations.
v
Create
ActiveRepository tool using VB6, Access2000, and
v
Integrate
a JAVA COM object into ActiveRepository that reads localized part
descriptions, pricing, and status information into the Compaq Parts List (CPL)
database via a real-time link into a remote database via ODBC. The CPL houses
current parts information for each country. ActiveRepository catalogs both the
parts information and the web UI information within the same tool.
v
Manipulate
ASP pages, Jscript code and build COM components in VB6 to make a portion of
the site to run standalone.
v
Used
Microsoft Site Server to manage multiple versions of the Compaq websites for
customer.
·
Kylor Corporation
v
Designed
and created ActiveAnalyser tool to test and verify data used on Compaqs
ActiveAnswers website for on-line PC configuration. This tool stores
configurations, test definitions, and then tests these combinations against the
configuration engine and displays results in an embedded browser control within
application. The results of the test are then stored in the database for
comparisons performed later.
v
Uses
v
Designed
and implemented ActiveLocalizer tool for Compaq which allows configuration
specialists to load the contents of part-specific data from the configuration
engine, modify it, and then create a new configuration engine (flat file). The
engine then populates and verifies the ActiveAnswers website for Compaq. The
user may modify the data within the grid or export the data with OLE Automation
to Excel, modify the spreadsheet, and then import via OLE Automation back into
the tool. The user then can create a new version of the configuration engine
with the tool.
·
Courion Corporation
v
Converted
Visual Basic 6 enterprise application from DAO to
v
Migration
of the application from MS Access to SQL Server 7.0 took place. This included
data model changes to tables and indexes and the creation of stored procedures.
v
The
main reason for this development work was to optimize a database intensive
process that typically ran overnight in approximately 18 hours to a more
acceptable time of 9 hours.
Hewlett Packard
·
Designed
and implemented workflow application, Orion. This order tracking system
tracks HPs orders with EMC Corporation and creates electronic documentation
via MAPI calls to Microsoft Outlook and Microsoft Exchange and OLE automation
with Microsoft Excel.
·
The
front-end written using Visual Basic 6 utilizing
·
Web-based
version retrieves read-only view of orders within Orion database using ASP
scripts with embedded Java and VBScript, server-side COM object written with
VB6, and returns dynamically generated HTML pages to present to the user.
·
Complex
reports using Crystal Reports were written and distributed with the application.
·
Orion was
written with heavy uses of classes with all database activity centralized in
one core class making it easier to become a server-side component when
migration to Web.
·
Roles
included lead developer, designer, and technology transfer to other team
members.
·
Setup
kits built using Wise distributing all software, runtime libraries, ADO/ODBC
driver software, and registry setting logic.
·
Built
COM objects in VB5 and VB6 with Active Server Pages and Server-Side Scripts.
ASP scripts had embedded Java and VBScript code.
·
COM
objects output dynamically built HTML pages for the user to view. The Web sites
were viewable in both Netscape and IE.
·
COM
objects communicated via
Digital Equipment Corporation / Compaq
Computer
·
Developed
and implemented technical solution for upgrading an existing 16-bit
client-server application suite called Omega to VB5. Project consisted of
four modules containing approximately 450,000 lines of Visual Basic 4.0(16-bit)
code.
·
Application
responsible for paying commissions to 6,000 Digital salespeople worldwide.
System adopted by Compaq to be corporate-wide mechanism for sales compensation.
·
Roles
included team leader, lead developer, architect, and included technology
transfer.
·
Determined
best method of upgrade including selection of third-party custom controls and
replacement of costly Intersolv closed ODBC driver with a free Microsoft ODBC
driver.
·
Helped
create delivery mechanism using state-of-art Microsoft ODBC driver software
combined with internally developed WISE scripts.
·
Modified
data access strategy from ODBC API calls to RDO 2.0
Kylor Corporation
<