Robert E. (Bob) Ericson
1650 Nuala Street, Concord, California 94518
Phone: 925.686.6682 Email: Bob@WebOne.Com

Qualifications by Job Category (Years in parentheses)

Programmer (20) – Skilled programmer with experience in leading edge technologies.  Experience includes writing hundreds of programs for platforms ranging from IBM mainframes to Microsoft Windows websites. Stays up with technologies and currently specializes in Microsoft .NET. This is a great fit for a technical leadership role on a development team. Programming skills are current.

Database Analyst (15) – Has over 15 years experience developing relational database applications. Experience includes IBM DB2, Oracle, Microsoft Access, and Microsoft SQL/Server.

Systems Analyst (20) – Proven analysis and design ability with experience developing a large number of projects.  College major was Business Systems Analysis. Has designed a wide range of applications including eCommerce, distribution center, point-of-sales, retail, payroll, personnel, inventory, GL, AP, AR, stockbroker, billing, document management, customer support and more. Architecture experience ranges from IBM mainframes to n-tier websites. Knows how to develop data models (Entity Relationship Diagrams) and process models (Data Flow Diagrams).

Project Leader (10) – Demonstrated ability to lead projects - including multi-million dollar websites. Experience includes project planning, budgeting, staff planning, hiring, staff management, team leadership and working with senior management. Not afraid to take the reigns and lead a team. 
Technical Experience (Years in parentheses)
Operating Systems – Microsoft Windows Server 2003 (.5), Microsoft Windows Server 2000 (4), Microsoft NT Server 4.0 (5), Microsoft Windows XP (5) and UNIX (2).

Programming – Visual Basic 4-6 (10), Visual Basic .NET (3), C# (1), ASP(8), ASP.NET (2), Visual InterDev (4), Visual Interdev .NET(3), FrontPage(3), Visual Basic Script(5), Java Script(5), HTML(10), ActiveX(5), COM(2), XML(2), DAO(5), ADO(5), Microsoft Internet Information Server (10) and ADO.NET(3).

Databases – Microsoft SQL Server (7), Microsoft Access (10), Oracle (2), Sybase (1), DB2 (10).

Miscellaneous – Microsoft Word (10), Microsoft Visio (3), Microsoft Project (4), Microsoft PhotoDraw (2), Microsoft PowerPoint (3), Microsoft Developers Network (6), Visual Source Safe(4).

Mainframes (IBM mainframe expert until 1993) – IBM Mainframes (10), IBM CICS (10), VSAM (10), OS390 or equivalent (10), TSO (10), JCL (10), and COBOL (10). 
Web Projects
stockoptions.wellsfargo.com	www.WcirbOnline.org 		www.Starbucks.com
www.ObjectWare.com		www.Rheodyne.com		www.Cedco.com	
TomTorlakson.com 		MarkDeSaulnier.com		support.Quantum.com*
Qsl.Quantum.com*		Training.Quantum.com*		IFile.Quantum.com*	
TAG.Quantum.com*		BAclub.BankAmerica.com* 	HRconnection.BankAmerica.com*

*This website visible only on company intranet.
Education
Bachelor of Science in Computer Science: University of West Florida, Pensacola, Florida.

Post Graduate Studies in Business Administration: University of Florida, Gainesville, Florida.
Professional Experience

Kestrel, Inc. (webONE.com) - Concord, CA (2/81-Present)
President/Consultant
I have continuously operated as an incorporated computer consultant for over 20 years. I have served clients in a variety of roles in the development of information systems for companies ranging in size from small start-ups to some of America’s largest corporations. I have specialized in leading edge technologies and now Microsoft .NET. For the past 8 years, I specialized in web development using Microsoft products. 
* See www.webONE.com.
* Member of Microsoft Developers Network.
* Certified California Small Business & CMAS
* Former Microsoft Solution Provider

State Street Corp.  (StateStreet.com) – Walnut Creek, CA (3/06-Present)
Senior Developer (Contract)
I developed over 80 projects to improve a back office settlement system for financial markets. This system processed asset classes of Cash Wire, Cash Trades, Derivatives, Equity (stocks), Fixed Income, Futures, Currency, Swap and Wires. The clients of this system were Barclays Global Investors, Common Fund, Diversified Credit Investments, Eaton Vance, HSBC and Norges Bank. This is a client-server application supporting over a thousand users distributed world wide.
* Provided analysis and design of solutions
* Programmed solutions
* Developed database triggers and stored procedures
* Technologies: Visual Basic 6,  Visual Studio, SQL/Server 2000, Visio, Microsoft Windows Server 2003, Visual Source Safe.

Mark DeSaulnier – Concord, CA (11/02-present)
Senior Systems Analyst/Programmer Consultant
This is the campaign organization this California State Assembly member. I developed the e-commerce website www.MarkDeSaulnier.com which features online contributions and event ticket sales. I continue to host and maintain the website to this date.
* Managed the project
* Performed the analysis of the project
* Designed the database
* Wrote all the programs
* Integrated VeriSign into the website
* Hosted the website
* Technologies: ASP.NET, VB.NET, ADO.NET, Visual Studio.NET, SQL/Server 2000, HTML, Access, Visio, Microsoft Windows Server 2003.

Tom Torlakson – Martinez, CA (11/02-present)
Senior Systems Analyst/Programmer Consultant
This is the campaign organization this California State Senate member. I developed the e-commerce website www.TomTorlakson.com which features online contributions and event ticket sales. I continue to host and maintain the website to this date.
* Managed the project
* Performed the analysis of the project
* Designed the database
* Wrote all the programs
* Integrated VeriSign into the website
* Hosted the website
* Developed a virtual private network (VPN)
* Technologies: ASP.NET, VB.NET, ADO.NET, Visual Studio.NET, HTML, SQL/Server 2000, Access, Visio, Microsoft Windows Server 2003.


Wells Fargo Bank – San Francisco, CA (4/04-8/05)
Senior Systems Analyst/Programmer Consultant
I was responsible for the Stock Options Website (stockoptions.wellsfargo.com) which is used by 37 corporate clients to manage Employee Stock Options.
* Performed an analysis of the system
* Prepared system documentation
* Prepared alternate design recommendations
* Prepared a Service Level Agreement
* Analyzed and programmed modifications
* Participated in Sarbanes-Oxley audit and compliance team
* Technologies: ASP,  Visual Basic,  HTML, ADO, ADO, Visual Studio, SQL/Server 2000, Access, Visio, Microsoft Windows Server 2000, Visual Source Safe.

I was responsible for the Collateral Margining System which tracks loan margin compliance for Wells Fargo’s biggest clients.
* Performed an analysis of the system
* Prepared documentation
* Analyzed and programmed modifications
* Technologies: Dot Net (.NET), ASPX, C#, ADO.NET, Visual Studio.Net, HTML, SQL/Server 2000,  Visio, Active Directory and Microsoft Windows Server 2000.


Investors Bank & Trust – Walnut Creek, CA (6/02-11/02)
Senior Systems Analyst/Programmer Consultant
This company (www.ibtco.com) settles over $3 billion in securities daily from markets all over the world and is one of Wall Street’s largest custodians for institutions like mutual funds and retirement trusts. 
* Developed the Price Load sub-system for the Trade Operation system. 
* Developed the Domestic Asset Load sub-system for the Trade Operation system.
* Developed the Tax Reclaims sub-system for the Corporate Actions system.
* Translated programs from VB 6 to C# for pilot study.
* Technologies: VB 6, ADO, C#, ADO.NET, Visual Studio.NET, SQL/Server 2000, Access, Visual Interdev, Visio, Sybase, DBArtisan, Stored Procedures & ODBC.

Documaster - Concord, CA (4/01-6/02)
Project leader
This was a project to develop a Document Management Web system based on the Microsoft .NET architecture. 
* Designed the programs
* Designed the database
* Technologies: ASP.NET, VB.NET, ADO.NET, C#, .NET Transaction Processing, HTML, Windows 2000 Advanced Server, XML, IIS, Visual Interdev, SQL/Server 2000, Visio, IIS and HTML.

Kaia, Inc. - Dublin, CA (1/02-4/02)
Project Manager Consultant
This was the analysis phase of a project is to build and host a Spanish language version of the California Department of Motor Vehicles website (www.dmv.ca.gov) 
* Managed the project
* Conducted negotiations with DMV
* Prepared the bid documents
* Prepared cost analysis including staff requirements
* Prepared systems analysis

Workers Compensation Insurance Rating	Bureau - San Francisco, CA (10/2000-4/2001)
Project Manager & Chief Software Engineer Consultant
This was a development project for a multimillion dollar, multi-tiered, cross platform, website (www.WCIRBonline.ORG) that contains the repository of confidential workers compensation records for the State of California. 
* Managed the analysis & design effort.
* Worked directly with senior management.
* Supervised 10 employees including business analysts, programmers, database administrators, web designers and graphical artists.
* Planned the project using Microsoft Project.
* Hired & fired team members.
* Prepared the budget.
* Led the database analysis which included data models (Visio Entity Relationship Diagrams). The final design document included hardware recommendations, DBMS recommendations and a detailed design of all the objects (tables, indexes, triggers, security, etc.) in the database.
* Led the systems analysis which included the analysis of the current system consisting of an IBM mainframe running CICS, COBOL and VSAM. Used process models (Visio Data Flow Diagrams) to study user interfaces, manual processes and interfaces with other systems. 
* Developed the system platform which included IBM Mainframes, Sun servers running IBM DB2, and Dell web servers running Microsoft Windows 2000. The analysis included the study of alternate platforms and components including Microsoft .NET, Java, Microsoft NT 4.0, web services, HTML, SOAP, MSMQ and FTP.


Bank of America - Concord, CA (2/1999 – 8/2000)
Senior Systems Analyst/Programmer Consultant 
Team Bank of America website project -- The purpose of this website is to help manage membership and events for volunteer organization run by the bank throughout the world.
* Provided technical leadership for a 5 member team. 
* Developed the n-tier architecture.
* Researched alternative n-tier web architectures including COM, COM+, Distributed Network Architecture (DNA) and Microsoft Transaction Server (MTS).
* Designed the database using data models (Visio Entity Relationship Diagrams).
* Prepared tables, triggers & stored procedures for a Microsoft SQL/Server database. 
* Developed a prototype of the system.
* Wrote programs using HTML, ASP, VB, ADO, Access, Java Script, Visual Interdev (Visual Studio), IIS, HTML, Windows 2000, Windows NT 4.0 & SQL/Server.
* Developed an interface with the company LDAP.

Transition website project -- The purpose of this project was to assist in the merger of Bank of America with NationsBank. The website was a project scheduling system based on Microsoft Project. 
* Provided analysis and design of software components
* Developed programs using HTML, ASP, VB, ADO, Java Script, Visual Interdev (Visual Studio), IIS & Windows NT 4.0 & SQL/Server.
* Developed tables, triggers and stored procedures for a Microsoft SQL/Server database.

Energy Direct Marketing - Palo Alto, CA (8/98 – 12/98)
Project Manager & Chief Software Engineer Consultant
The purpose of this project was to develop an energy shopping website based on n-tier architecture.
* Managed the project and a couple employees.
* Worked directly with senior management.
* Planned the project using Microsoft Project.
* Prepared the budget.
* Prepared a database analysis which included data models (Visio Entity Relationship Diagrams). 
* Prepared a systems analysis of the desired system which included process models (Visio Data Flow Diagrams).
* Prepared the architecture to include Microsoft NT 4.0, IIS, SQL/Server, ASP, VB & ADO. 
* Prepared a prototyped of the website using HTML, ASP, FrontPage 98, IIS 4.0, Visual InterDev 6.0, Visual Basic 6.0 EE, Access 97, ADO, COM and SQL Server 6.5. 

Starbucks - Seattle, WA (5/98 - 8/98)
Chief Software Engineer Consultant
The purpose of this project was to build the Starbucks ecommerce website (www.Starbucks.com).
* Developed interfaces with Microsoft Commerce Server.
* Developed programs for customer registration, employment events, financial news, press releases, employment applications & feedback.
* Configured production servers including Microsoft Commerce Server, SQL/Server and IIS.
* Developed programs using HTML, ASP, VB, ADO, Java Script, Visual Interdev (Visual Studio), IIS & Windows NT 4.0 & SQL/Server.

Bank of America - Concord, CA (1/98 – 5/98)
Senior Systems Analyst/Programmer Consultant
The purpose of this project was to develop the Human Resource Services website.

* Developed programs using HTML, ASP, Microsoft Site Server 4.0, NT Server 4.0, IIS 3.0, Microsoft Visual InterDev, Microsoft SQL Server 6.5 and Microsoft FrontPage 98.


Quantum Corporation - Milpitas, CA (12/95 – 12/97)
Project Manager & Senior Systems Analyst/Programmer Consultant
There were three projects for Quantum: a Document Management website to manage technical documentation, a Student Registration website to allow employees to register for classes and a Customer Support website to analyze customer problems.
* Planned the projects.
* Provided analysis and design for the projects.
* Designed the databases.
* Developed a 3-tier architecture using VB COM objects.
* Supervised the work of 3 other developers.
* Prepared prototypes of the systems.
* Developed programs using NT 4.0 Server, SQL/Server IIS, ASP, Visual Basic, Visual InterDev, DAO, HTML, COM and Access.

Cedco Publishing - San Mateo, CA (7/95 – 7/96)
Web Consultant
Managed, designed, programmed and hosted this company’s website (www.Cedco.com) on a UNIX platform and HTML.

ObjectWare - San Francisco, CA (4/95 – 4/96)
Web Consultant
Managed, designed, programmed and hosted this company’s website (www.ObjectWare.com) on a UNIX platform and HTML.

Rheodyne - Cotati, CA (7/95 – 7/96)
Web Consultant
Managed, designed, programmed and hosted this company’s website (www.Rheodyne.com) on a UNIX platform and HTML.

Wells Fargo Corp. - San Francisco, CA (2/95 – 11/95)
Senior Systems Analyst/Programmer Consultant
This project was to develop a COBOL-to-Visual Basic re-engineering application using Windows, Visual Basic and Access. 

Pacific Gas & Electric - San Francisco, CA (9/93 – 9/95)
Project Manager & Senior Systems Analyst/Programmer Consultant
This was a large project to develop the Property Accounting Client/Server System. The result was a 2-tier architecture with a Windows user interface and an Oracle database.
* Worked directly with senior management.
* Supervised 3 employees including 3 programmers, programmers and a database administrator.
* Planned the project using Microsoft Project.
* Prepared the budget.
* Conducted JAD sessions.
* Prepared a prototype.
* Prepared the database analysis which included data models (Knowledgeware Entity Relationship Diagrams). 
* Prepared the systems analysis which included the analysis of current systems running on IBM mainframes running TSO, CICS, COBOL and VSAM. Used process models (Knowledgeware Data Flow Diagrams) to study user interfaces, manual processes and interfaces with other systems. 
* Developed the system platform requirements.
* Developed programs using Windows, Visual Basic, Oracle Database, Access, ODBC and Crystal Reporting. 



Charles Schwab & Co. - San Francisco, CA (4/93 – 9/93)
Senior Systems Analyst/Programmer Consultant
This project was to develop a prototype for Schwab’s first Windows-based Stock Trading System. The programs were developed using Visual Basic and Access.

Pacific Gas & Electric - San Francisco, CA (8/90 – 4/93)
Senior Systems Analyst/Programmer Consultant
This was a major multi-million dollar project to develop the Non-Energy Billing System. This is the billing system for everything except gas and electric. 
* Provided technical leadership to a large team.
* Worked directly with senior management.
* Designed the development process.
* Solved major Knowledgeware development issues.
* Designed the database.
* Developed over 40 programs using IBM Mainframes, TSO, Knowledgeware CASE, OS/2, CICS, COBOL and DB2.

Litton Industries – Alameda, CA (1/90 – 8/90)
Senior Systems Analyst
This was a project to design a warehouse distribution system for a retail company. The system required interfaces with 
* Worked directly with senior management.
* Prepared the database analysis which included data models (Knowledgeware Entity Relationship Diagrams). 
* Prepared the systems analysis which included process models (Knowledgeware Data Flow Diagrams) to study user interfaces, manual processes and interfaces with other systems. 
* Used Knowledgeware CASE tools.

Pacific Bell – San Ramon, CA (6/88 – 12/89)
Senior Systems Analyst/Programmer Consultant
This was a project to develop a training and class management system (TRAINS).
* Provided technical leadership to a small team.
* Worked directly with senior management.
* Designed the development process.
* Developed the architecture.
* Designed the DB2 database.
* Developed over 20 programs using IBM Mainframes, TSO, CICS, COBOL and DB2.

Westinghouse – Sunnyvale, CA (6/87 – 6/88)
Senior Systems Analyst/Programmer Consultant
This was a job to develop a missile and submarine project management system (BOSS) for United States Department of Defense.
* Provided technical leadership to a large team.
* Prepared the database analysis which included data models (Entity Relationship Diagrams). 
* Prepared the systems analysis which included process models (Data Flow Diagrams).
* Worked directly with senior management.
* Designed the development process.
* Developed the architecture.
* This may have been the first DB2 systems ever put into production.
* Developed over 20 programs using IBM Mainframes, TSO, CICS, COBOL and DB2.

Mervyn’s Department Stores – Hayward, CA (2/87 – 5/87)
Senior Systems Analyst/Programmer Consultant
This was a project to develop an inventory management system using IBM Mainframes, TSO, CICS and COBOL.

Computerland – Hayward, CA (2/87 – 5/87)
Senior Systems Analyst/Programmer Consultant
This was a project to develop an accounts receivable system using IBM Mainframes, TSO, CICS and COBOL.

Amdahl Corporation – Hayward, CA (2/87 – 5/87)
Senior Systems Analyst/Programmer Consultant
This was a project to develop a student registration system using IBM Mainframes, TSO, CICS and COBOL.

Employment history prior to this date is available upon request.