|
| Alan Crosthwaite |
| San Marcos, CA 92069 |
| Email:
alancrosthwaite@cox.net |
| Phone: 760.510.1820 |
| Cell:
760.402.5374 |
|
 Resume Resume
as .pdf
References |
|
| Primary Skills 10+ years
programming |
| VB.NET,
ASP.NET, XML, ADO, SQL Server, T-SQL , VB 6.0, Classic ASP, DTS, JavaScript,
Flash, HTML, COM, COM+, VSS, Visual Studio |
|
| VB.NET |
| High profile production
back office applications utilizing ASP.NET, VB.NET, and Stored procedures |
| Complex use of DTS
packages including
active-X components, FTP, data scrubbing, import, and export. |
| Developed applications using
Crystal Reports Version 8.5, datasets and complex sub-reports. |
|
| ASP.NET |
| Production ASP.NET
websites utilizing SQL Server, DTS, and VB.NET Dlls. |
| Management
Reporting web site for Verizon using ASP.net and de-normalized rollup
tables for fast reporting. Heavy use of SQL Server, DTS, and
DotNetCharting object. |
| Complex use of DTS including
active-X components, FTP, and stored procedures. |
| Web services utilizing SOAP,
ASP.NET, and SQL Server. |
|
| Web Development Portfolio |
| San
Marcos Youth Baseball (ASP, Access, FTP, HTMP, Flash, Photoshop, SMTP) |
| Jack
Pennock's Baseball Fundamentals (HTML, Flash, Access, Photoshop,
Frontpage) |
| ADS
Golf (HTML, Flash, Photoshop, Frontpage) |
| Hunter
Preferred Contractor Application (ASP, Sql Server, VB 6, FTP, HTML) |
| Hunter
Jobs Available Application (ASP, Sql Server, VB 6, FTP, HTML) |
| Alan
Crosthwaite Digital Photo Gallery (Photoshop, FTP) |
| Proflowers
Web Site (ASP, Sql Server, XML, VB 6, MTS) |
|
| Visual Basic 6.0, 5.0, 4.0 |
| Developed numerous Client/Server/Web
applications with RDO, ADO and (SQL Server/Oracle). |
| Extensive experience with object oriented
programming techniques, using classes/collections. |
| Subject matter expert working
with Crystal Reports Versions 6, 7 and integration with VB. |
|
| RDBMS (SQL Server
6.5, 7.0,
2000) |
| Table Creation, Index Creation,
and query optimization |
| SQL Server CDO, CDONTS, and
active X controls |
| SQL Server Stored Procedures,
Triggers, and Functions |
| SQL Server Database Administration,
backup functions |
| SQL Server DTS packages |
|
| Secondary Skills |
| Flash,
Adobe Photoshop, Pivotal CRM customization, Digital Photography, Paintshop
Pro, Fireworks, UML, Rational Rose |
|
| Professional Experience |
| 1/04 to
Present - Verizon - Sapphire, Carlsbad, CA |
| Senior Contract
Programmer |
|
Designed and programmed
a management reporting application using ASP.net, SQL DTS, very complex Sql
Server stored procedures, DotNetCharting object. Architecture needed to support
a 24 million record base table and provide extremely fast reporting using
de-normalized rollup tables.
|
| 11/03 to
12/03 - NAS North Island - CSC, San Diego, CA |
| Senior Contract
Programmer |
|
On
this short 5 week contract, worked directly for the IT Director to modify many
ASP pages. Created Sql tables and stored procedures, modified existing code
base.
|
| 12/02 to
08/03 - Greenpoint
Credit, San Diego, CA |
| Senior Contract
Programmer |
|
Heavy
SQL Server 2000 database programming using stored
procedures, T-SQL, and DTS packages/jobs. (Will provide coding samples upon
request). Built numerous web sites using ASP.net, Crystal Reports 8.5, IIS, and
VSS.
Created
VB.net .dll programs and .exe programs for above applications.
|
| 12/02 to
Present - San Marcos Youth Baseball, San Marcos, CA |
| WebMaster,
Developer, Web site Director |
|
Created
the dynamic SMYB web site
using FrontPage, Flash, ASP, VB, Access
|
| 05/02 to 12/02 - Sempra
Energy, San Diego, CA. |
| Senior Programmer -
BackOffice Integrator |
|
Programmed
using Visual Basic, T-SQL, DTS, ASP, IIS, COM, and VSS. Performed All aspects of
multi-tiered programming to include the creation of requirements documents, the
programming of Visual components, creation of ASP intranet web pages, writing
SQL DTS packages with Active X components, and very complex SQL stored
procedures. As a Crystal Reports expert, created complex (multiple sub-report)
stored procedure driven management reports and all supporting interfaces.
|
|
| 12/01 - 04/02 - Guidant,
Temecula, CA. |
| Programmer |
|
As a contract programmer at Guidant, programmed in VB, ASP, and for the first
time, Documentum. This company used Oracle as their database. Additionally, I
programmed using SQL and Crystal Reports. |
|
| 3/01 - 12/01 - LightSpan San
Diego, CA. |
| Senior Contract Programmer |
|
All
aspects of Visual Basic programming: functional requirements, specifications,
debugging and delivery of .exe and .dll (COM) client server programs and all
aspects of ASP web site programming including QA and building test plans.
SQL Server 7 and Sql Server 2000 stored procedures, DTS packages, jobs
‘Pivotal’
CRM software customization, debugging, and promotion.
|
| 06/00
- 3/01 - Hunter Industries San Marcos, CA. |
| Senior Contract Programmer |
I was hired by Hunter to modify/create a program for them that was called the
"Contractors Frequent Buyer Program", a program similar to the
American Airlines frequent flyer program. They needed someone that could do all
aspects of programming, including specifications, database design, coding for
client server interfaces, web and intranet, debugging/qa, and delivery. I coded
using VB 6, Sql Server, Access, ASP, HTML, and FrontPage. I worked directly for
the Marketing Director for this 9 month contract. The Hunter
Industries Frequent Buyer Program is still being used and was a huge
success. I can provide documentation of the technical specification and user's
guide upon request. This was a very large multi-user VB app that contained over
55 forms, 300 stored procedures, 35 Crystal Reports, and 35 ASP pages. I did
100% of the project. Additionally, I was asked to create a Job's available web
site for Hunter, which is still used here at this URL: Hunter
Industries Employment Web Site.
|
|
| 02/00 - 6/00 -
ProFlowers.com San Diego, CA. |
| Senior Contract Programmer |
While on contract at Proflowers.com, did more complex VB 6 programming. I coded for
internal company solutions. This was a multi-server, multi-tiered e-commerce
environment. I created stored procedures, used MTS for distributed components,
XML to move datasets back and forth between servers, VSS, and MS project. I did
ASP coding, configuration management, and project documentation.
|
|
| 04/99 - 2/00 - First American
Title San Diego, CA. |
| Senior Contract Programmer |
As a middle tier team lead at First American, I programmed using VB 6 and MS Sql
Server 7. We used ADO, Site Server, MTS. I used Rational Rose to general UML
diagrams, code. We used VSS, COM (of course), MS Project, and Visual
Interdev 6.0. My team was responsible for the middle tier that connected to
divisions/companies outside of FA, sending and receiving Flood Certificate data
using XML and MSMQ technologies. Additionally, I developed ASP solutions, was on
the Interview team, and conducted weekly 'brown bag' training during lunch. We
created a 'reading club' and studied together to move our collective group's
programming knowledge forward. Additionally, I was responsible for the creation
of complex stored procedures and data architecture for our specific projects.
|
|
| 06/98 - 4/99 - Epic
Solutions Rancho Bernardo, CA. |
| Senior Contract Programmer |
It was while at Epic Solutions that I learned about classes/collections, active
X dlls, controls using VB versions 5 and 6. Additionally, here I was part of a
team of programmers that were simultaneously working on the same (for profit)
code base. I was responsible for middle tier components, complex GUI layer forms
and active X controls. There was consistent use of VSS for source control, long
programming days and nights, and tight deadlines. Epic has an Oracle
database backend, and while they had DBAs there responsible for the major
database tasks, I did create stored procedures and tables.
|
|
| Education |
BA Business Economics,
University of California Santa Barbara
Herbert Hoover High
School, Glendale, CA |
|
| References |
| Personal
and Professional References Available Here |
|
| Other Items of Interest |
| Business owner and creator of
"QuickSilver For Amway Distributors". On my own time at home, I created a Windows program using Paradox for
Windows for Amway Distributors that enabled distributors to track all aspects of
their business. This included all aspects of development, including database
programming, reports, windows setup and distribution, help files, documentation,
online web interfaces for download, sales, distribution, and software patches.
Over 300 copies sold netting over $30,000 in profit.
My
Digital Photography
Graduate U.S. Army Officer Candidate School, Ft. Benning, GA
Graduate U.S. Army Flight School, Ft. Rucker, AL
|