Forum | Russian | FAQ | SiteMap | Contact Us








1234567891011121314

Resume 11

John Sommerset
Concord, California

Summary of qualifications

Project Management
Demonstrated ability to manage 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. Has the wisdom that comes with over 20 years of software development experience.

Systems Analysis & Design
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 .

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

Programming
Skilled programmer with over 20 years 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.

Tool Knowledge

Servers
Microsoft Windows 2000 Server, Microsoft NT Server 4.0, Microsoft Internet Information Server IIS , Microsoft Site Server Commerce Edition, Microsoft Component Server, UNIX and Netscape Enterprise Server.

Programming
Visual Basic 5, 6, .NET , C#, Active Server Pages ASP, .NET , Visual InterDev 6, .NET , FrontPage, Visual Basic Script, Java Script, HTML, ActiveX, SOAP, COM, COM+, XML, DAO, ADO and ADO.NET.

Databases
Microsoft SQL Server, Microsoft Access, Oracle and IBM DB2.

Transaction processing
IBM CICS, DB2, Windows 2000 Component Services COM+ , SQL Server, and .NET Transaction Processing.

Web Projects

  • www.WcirbOnline.org
  • www.Starbucks.com
  • www.ObjectWare.com
  • www.Rheodyne.com
  • www.Cedco.com
  • support.Quantum.com
  • www.Documaster.NET
  • Qsl.qntm.com
  • Training.qntm.com
  • IFile.qntm.com
  • TAG.qntm.com
  • HRconnection.BankAmerica.com
  • BAclub.BankAmerica.com
  • Transition.BankAmerica.com

Education

Bachelor of Science in Computer Science: University of West Florida, Pensacola, Florida.

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

Recent Training:
Microsoft ASP.NET, Microsoft .NET Security, Microsoft .NET Cashing & State Management, Microsoft .NET Remoting, Migrating from COM to .NET, Microsoft .NET Web Services, Microsoft .NET Debugging, Microsoft .NET Transaction Management.

Professional experience

Transtrel, Inc., Concord, CA
2/84-Present

President

I have continuously operated this IT Professional Services business for over 17 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 7 years, I specialized in web development using Microsoft products.

  • See www.myweb.com.
  • Member of Microsoft Developers Network.
  • Certified California Small Business
  • Former Microsoft Solution Provider
Docuwizardr.NET - Concord, CA
4/01-Present

Owner

This is a project to develop a Document Management Web system based on the Microsoft .NET architecture.

  • See www.Docuwizard.NET.
  • Technologies: ASP.NET, VB.NET, ADO.NET, C#, .NET Transaction Processing, Windows 2000 Advanced Server, XML, IIS, Visual Interdev, SQL/Server 2000, Visio, IIS and HTML.
Kwan, Inc., Sacramento, 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

  • Managed the project
  • Conducted negotiations with DMV
  • Prepared the bid documents
  • Prepared cost analysis including staff requirements
  • Prepared systems analysis
Workers Compensation Insurance Rating Office, 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, SOAP, MSMQ and FTP.
Noster Bank, Concord, CA
2/1999 8/2000

Senior Systems Analyst/Programmer Consultant

Team Noster Bank 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, 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 Noster Bank 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 Consulting, 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.
Noster Bank, 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.
Arco Publishing, San Mateo, CA
7/95 7/96

Web Consultant

Managed, designed, programmed and hosted this company s website www.Arco.com on a UNIX platform.

ObjectDale - San Francisco, CA
4/95 4/96

Web Consultant

Managed, designed, programmed and hosted this company s website www.ObjectDale.com on a UNIX platform.

Reodyne, Cotati, CA
7/95 7/96

Web Consultant

Managed, designed, programmed and hosted this company s website www.Reodyne.com on a UNIX platform.

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 Mateo, 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 Inner & 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 Mateo, 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.
Littelton 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, Santa Clara, 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.
Eulesshouse, 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, Redwood, 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, Redwood, 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.

Amanda Corporation, Redwood, 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.

Pacific Bell, San Mateo, CA
7/85 6/86

Senior Systems Analyst/Programmer Consultant

This was a project to develop the Easy Access Request System EARS which is part of the Service Order System SORD .

  • Performed a system audit for the US Department of Justice
  • Re-architected the system
  • Developed programs using IBM Mainframes, TSO, CICS and COBOL.


1234567891011121314











Untitled Document