|
Portfolio Detail
|
 |
AFLAC - California North
Skills used: Visual Basic .Net, ASP .Net, Access, XML, Web Services
Created website to assist in tracking new agent and client leads. Allowed
client to monitor new agent training and client status. Custom reports provided
information on business performance. Agents received automated emails as they
progressed through business training. Integrated on-line payment for training
classes.
|
|
Ernst & Young
Skills used: Visual Basic, SQL Server
Three separate applications tracked similar corporate information. Met with
users and assisted with specification for the new system. Responsible for
analysis of existing systems, development of database architecture and
application functionality. Converted existing data for import into new system.
|
|
FoodToYou.com
Skills used: ASP, Access
Created website that utilized existing database, eliminating duplicate data
entry required by original vendor. System provided instant updates for menu
changes and allowed customers to submit orders through website.
|
|
FreeConferenceCall.com
Skills used: Visual Basic .Net, ASP .Net, Web Services, mySql
Wrote application to extract log files from a telephone switch and import into
database. Created reporting front end that also allowed for data export.
Configured mySql replication scheme to centralize log file data.
Created invitation system for conference calls. Allowed users to create groups
and send out invitations to participate in conference calls
View site
|
|
ICEX
Skills used: ASP, SQL Server
Modified existing code to incorporate new features for document repository
management. Streamlined system architecture to facilitate on-going maintenance.
Facilitated migration of code to clients who maintained separate systems.
View site
|
|
Informed Investors
Skills used: SQL Server, Cold Fusion, Windows Media
Responsible for design, development, implementation and maintenance of database
and website: informedinvestors.com. Used templates to extract site information
from database, rather than static pages. Incorporated audio streaming and
created on-line store. Templates improved design consistency and reduced effort
required to maintain site.
Outsourcing of webcasts was becoming cost prohibitive. Configured phone and
media servers at co-location facility and integrated new functionality into the
existing web site. Developed database and interface for viewing PowerPoint
slides and ask questions in real time. One year cost savings exceeded $80k.
Detailed information on website activity was required and could not be obtained
through existing reporting tools. Developed database and application to extract
log file data and provide client with important feedback on the number of
webcast participants. Wrote twenty stored procedures to expedite processing
time of large log files.
Credit card processing method required manual entry of card numbers and totals.
Developed an on-line store to automate the authorization process and eliminate
eight hours of weekly data entry. Created reconciliation reports to assist
accounting department.
Sales Department requested assistance in gathering leads. Developed four
separate applications and databases to extract information from identified web
sites. Data imported into existing CRM, eliminating hours of manual data entry.
View site
|
|
Investor Relations Technology
Skills used: Visual Basic, SQL Server, ASP, Access
Client required a way to distribute investor relations information without
incurring printing costs. Developed software and database to extract corporate
data, format into HTML documents and package the information for email
distribution. Process allowed client to distribute more frequent updates of
changing corporate information.
Client wanted daily reports on activity in Internet stock boards relating to
company. Reviewed leading boards and developed application and database to
extract URL, summary and author information. Client received automated email
reports daily.
Developed application and database to extract quarterly earning information on
thousands of publicly traded corporations from the Security and Exchange
Commission (SEC). Application retrieved and parsed text files from the SEC
site, then loaded them into SQL Server. Developed browser-based query tool with
client-side validation and charting of daily statistics.
|
|
NAFEM
Skills used: ASP, SQL Server
Modified code in order to accomodate NAFEM's conference needs. Guest access
provided non-members with the ability to request information from subscribers.
View site
|
|
Sequoiacom.net
Skills used: ASP .Net, Visual Basic, SQL Server, Windows Media
Designed and implemented webcasting site. Created interface to allow clients to
view statistics and control presentations remotely.
Developed Visual Basic application to automate encoding process and overlay
scripts onto the live stream. Set up password protection for confidential
presentations.
Built application to automatically convert PowerPoint presentations loaded to
the web server into images for use with the Webcast.
|
|
TiGi Corporation
Skills used: ASP .Net, Visual Basic, SQL Server, Windows Media
Incorporated registration, surveys and on-line testing into a series of
webinars for product rollouts and training.
View site
|
|
United Airlines
Skills used: Visual Basic, Access, DB2
Client needed to convert three years of data modeling effort from ADW to IEF.
Conceived and implemented solution where the data was extracted from ADW and
loaded into DB2. Process migrated 28 database models, some of which contained
over 14,000 objects. Application saved hundreds of hours budgeted for data
entry.
Client needed to determine the database dependencies through the various stages
of implementation, but CASE tool could not perform the required analysis.
Developed application that extracted information from DB2, eliminating the
manual comparison of hundred page reports.
|
|
Vcall
Skills used: ASP, SQL Server
Client wanted to migrate website from Java to ASP. Converted Java apps into ASP
and client saved thousands of dollars annually in licensing fees. Assisted
client in migrating website from external data center to internal servers.
View site
|
|
Visa
Skills used: Visual Basic, SQL Server, Cold Fusion, Access
Lead database developer for VISA intranet. Responsible for evaluation and
implementation of software to distribute information within the company. Helped
port several legacy systems to the intranet, enabling management to evaluate
the potential uses for the new technology.
Client wanted to reduce cost of distributing a thousand page monthly report to
thousands of member institutions. Assisted with development of application and
database that enabled users to quickly locate contact information and reduce
shipping expenses. Streamlined the mainframe data extraction process from five
days to twelve hours.
|
|
VitalSpring Technologies
Skills used: .Net, Sql Server, Visual Basic, Windows Media
Created site for on-line training and webcast registration. Developed client
interface for reporting and data export.
View
site
|
|
Washington Mutual
Skills used: ASP .Net, Visual Basic, SQL Server
Developed website to expedite and streamline registration for conferences.
Provided features to export data into Excel.
|
|
xwave - New England / State Of Maine - Department of
Corrections
Skills used: ASP .Net, Visual Basic, SQL Server
Wrote module to incorporate on-line training into the Corrections Information
System (CORIS). Training modules were arranged by job title, allowing quick
access to pertinent information.
Developed CD based training application that allowed DOC to distribute over two
hundred learning modules to employees who did not have sufficient bandwidth to
access the Flash files on the DOC website.
|
