C# ASP.NET Programmer

Aaron Spilman

OBJECTIVE: To be part of an intelligent team that writes software in a timely manner that is error free, and easy to use.

Chrims, Inc. 3/2007 – 9/2009

Dublin, CA

Network Administrator / Database Administrator / Programmer

• Install, Configure & Administer 25 Windows servers and 10 redhat servers)

• Create virtual servers with Xen, VirtualBox, VMWare.

• Upgrade Exchange 2003 to 2007; manage user permissions in active directory.

• Upgrade SQL 2000 to SQL 2008; manage database security and backups.

• Design and execute project to move production web servers and databases across country with no down time.

• Manage 60 node wide area network MPLS network.

• Provide desktop support for 150 end users

• Hire and provide mentoring to new help desk and administrator personnel.

• Convert legacy ASP classic applications to ASP.NET 3.5 / C# using Visual Studio 2005 & 2008.

• Write XSLTs to allow bulk processing and loading of XMLs into Informix and MS SQL.

• Write maintenance screens to allow customer support to make updates to highly normalized database.

• Provide support to software end users as needed.

Technology used: C#, T-SQL, DTS, SSIS, ADO.NET, IIS, XML, XSLT

Spilman Software Design 4/2004 – 3/2007

Oakdale, CA

Database Administrator / Programmer

• Upgrade SQL 2000 to SQL 2005, manage database security and backups.

• Construct T-SQL scripts for manufacturing company to correct database irregularities, allowing managers to more accurately create reports.

• Design and write a windows service to synchronize data from Ellie Mae’s Encompass to Del Mar Database’s DataTrac, eliminating the need for double entry by end users.

• Design and develop CRM application to replace Goldmine.

• Create interface with Inter-Tel phone switch, allowing CRM application to screen-pop customer record when they call in.

• Convert three page Excel equation into web application.

Clients: Formulation Technology, Sage Software, Clean Power Research, Acro Electric, Talentmine, SAS Accounting, Foundation Capital Group

Technology used: C#, T-SQL, DTS, SSIS, ADO.NET, IIS, MySql, COM objects.

Premier Bancorp 10/2002 – 4/2005

San Diego, CA

Network Administrator / Database Administrator / Programmer

• Design and develop web based application to replace internal paper tracking system for loan processing. Application includes rules based workflow, submittal and change request tracking, milestone and approval email notification, and historical data.

• Write T-SQL script to maintain number of user assigned records in Goldmine. New records are imported based on location and credit score.

• Reverse engineered file structure for Calyx Point, allowing new customer loan documents to be inserted into mortgage software.

• Design and develop an ASP application to copy data from Goldmine to Calyx Point.

• Create documentation for Corporate Business Processes, Work Flow, Network Operations, Disaster Recovery, Backup and Recovery Procedures. Coordinate the opening of four new offices for physical and intellectual infrastructure.

• Install SQL 2000, Manage database security and backups.

• Hire and provide mentoring to new help desk and administrator personnel.

Technology used: ASP.NET, C#, T-SQL, DTS, ADO.NET, ASP 3.0, VB 6.0

Spilman Consulting 10/2001 – 12/2002

San Diego, CA

Network Administrator / Database Administrator / Programmer

• Design and develop / built software and hardware to run kiosk for trade show.

• Write payroll application module to calculate state and federal payroll withholdings.

• Install SQL 2000, manage database security and backups

Clients: Premier Bancorp, TagCD, C. C. Hutchinson, Inc. Classic Auto Sales, Novatel Wireless

Technology used: ASP.NET, C#, ADO.NET, MSDE, VB 6.0, ASP 3.0, T-SQL, IIS, ADO

Novatel Wireless, Inc. 7/1999 - 9/2001

San Diego, CA

Network Architect / Database Administrator

• Responsible for the design, implementation and management of the company's network. Designed the corporate WAN/LAN over multiple locations in the US and Canada. Led a network upgrade project that resulted in a 10 times improvement in network throughput.

• Deployed a Cisco VPN/PIX solution set to enhance remote access and increase security.

Technology used: T1, ATM, Frame Relay, Cable Modem, ISDN, DSL, EIGRP, IPSEC, PIX firewalls and Cisco networking equipment.

• Install SQL 2000, manage database security and backups

System Administrator

• Responsible for implementing and managing the company's computing and telecommunication environment.

• Opened two new offices, coordinated the wiring install, server room setup, and equipment procurement. Configured and installed the server equipment.

• Expand the company's telecommunications system utilizing local switches and VoIP to link offices in Canada and the US.

• Had decision authority for hardware and software with regards to workstations, servers and network equipment.

• Hire and provide mentoring to new help desk and administrator personnel.

Technology used: Windows NT, Windows 2000, Microsoft Exchange server, Crystal Reports, OWA, SQL, InterTel Phone Switches, VoIP.

MicroJoin, Inc. 1/1997 - 7/1999

Poway, CA

IT Manager

• Maintain a network of seventy users in an NT4 environment using exchange server.

• Oversee the cabling of the entire building for data and phone using structured techniques.

• Responsible for the installation and maintenance of a new phone system.

• Handled the data migration from two different MRP systems after the company was purchased.

• Had decision authority for hardware and software with regards to workstations, servers and network equipment.

Field Service Repair Technician

• Responsible for installing and repairing, computer controlled electro-pneumatic, manufacturing equipment

DuPont Aerospace 12/1995 - 12/1996

El Cajon, CA

Technician

• Installed strain gages, thermal couples, and load cells. Wrote Visual Basic interface for large motor controllers.

PM Electric & Kuhler Corp. 10/1991 - 12/1995

San Diego, CA

Electrician

• Install switch gear, electrical panels, disconnects, conduit, j-boxes, lighting fixtures, receptacles, motion sensors, CAT-5 cabling, Token Ring cabling.

U.S. Coast Guard 10/1988 - 11/1990

Memphis, TN

EDUCATION

Monte Vista High School

Spring Valley, CA

Grossmont College

El Cajon, CA

Microsoft Exchange Server 5.5 Class

Microsoft Certification

MCSE on Windows 2000

Cisco Certification

CCNA

Cisco Certification

BSCI Class

California Notary

California Department of Real Estate

Sales License

AFFILIATIONS

Boy Scouts of America – Eagle Scout

REFERENCES

- References provided on request.

Contact this candidate