Paul G. C. Smith /

Technical Skill Summary

Software Engineering

● Requirements Analysis, Modeling, and Documentation
● System Design, Modeling, and Documentation
● Relational Database Design, Implementation, and Data Modeling
● Software Development Life Cycle, Microsoft Solutions Framework

Software Development Tools, Languages, Environments

● Microsoft Visual Source Safe, Microsoft Visio, Unified Modeling Language (UML)
● HTML, JavaScript, Visual Basic Script (VBScript)
● Visual Studio.NET, Visual Studio 2005, C#, ASP.NET, ADO.NET
● Microsoft SQL Server, T-SQL, DTS, Stored Procedures, Triggers, User Functions, Job Scheduling, Integration Services
● Windows 3.1 / 95 / 98 / 2000 / XP

Professional Training and Certification

● MOC 2124: Programming with C#
● MOC 2310: Developing Microsoft ASP.NET Web Applications with Visual Studio.NET
● MOC 2389: Programming with Microsoft ADO.NET
● MOC 2524: Developing XML Web Services with Microsoft ASP.NET
● MOC 2555: Developing Windows-Based Applications with C#
● MOW 2364: What’s New in Visual Studio 2005 /

Work Experience – Information Systems

05/2006 – Present ASAP Printing CorporationSouth Salt Lake City, UT

Software Architect / Sr. Developer

  • Architect order collection / management and production management systems
  • Perform MS Access to SQL Server Data Conversions with SQL Server 2005 Integration Services
  • Design and implement new systems, including integration with existing systems. Design and implement web applications for e-commerce Internet sites, using ASP.NET, ADO.NET, C#, and SQL Server
  • Mentor junior-level developers

Technical Skills: Requirements Analysis, System Design, Relational Database Design, SQL Server 2005, Visual Studio 2005, Microsoft Visual Source Safe 2005, C#, ADO.NET, ASP.NET, ASP Classic, HTML, Javascript, UML

04/2003 – 04/2006 EG&G Defense Materials, Inc.Stockton, UT

Programmer/Analyst

  • Design and implementation of databases on Microsoft SQL Server 2000, including creation of interface layers for communication with application business layer, utilizing stored procedures, triggers, user functions, database job scheduling.
  • Design and implementation of data conversions and imports, primarily using SQL Server stored procedures.
  • Design and implement new systems, including integration with existing systems. Design and implement web applications for facility Intranet, using ASP.NET, ADO.NET, C#, and SQL Server.
  • Maintain legacy MS Access systems. Perform system migration from MS Access to SQL Server.
  • Co-administer development/test environment database and web servers.
  • Draft IS department policies.
  • Security Clearance Information: National Agency Check complete for Department of Defense

Technical Skills: Requirements Analysis, System Design, Relational Database Design, SQL Server, Access, Visual Studio.NET, Microsoft Visual Source Safe, C#, ADO.NET, ASP.NET, HTML, Javascript, UML

11/2002 – 04/2003 ConsultNetDraper, UT

Consultant

  • Assigned to Modus Media International in Lindon, Utah, to monitor EDI processes to detect and correct problems.

05/1999 – 11/2002Envision Technology SolutionsMidvale, UT

Application Developer; Manager, Product Development

  • Led teams of two to five people in development projects to add functionality to existing company products. Managed software maintenance projects on multiple versions of released software, systemizing a chaotic process, leading to improved product quality and customer relations, reducing reported customer problems.
  • Developed, designed, built, maintained, and implemented a major overhaul of an internal software defect tracking system and processes, leading to improved system reliability, reduced turn around time for defect repairs, and overall improvement of released software quality.
  • Designed, developed, and maintained company’s risk management / claims administration software products used by major corporations and government agencies with user bases ranging from 1 to over 100.
  • Maintenance of products’ SQL scripts for Microsoft SQL Server 6.5 / 7.0 / 2000, including stored procedures and triggers.
  • Provided data conversion and electronic data interchange (EDI) services, including creating custom import and export utilities for transfer of data between systems, converting data, and translating code schemes.

Technical Skills: Systems Analysis & Design, Relational Database Design, Software Development Life Cycle, SQL Scripting, Data Conversion, Project Management, EDI, SQL Server, SQL Anywhere, Oracle, Visual Source Safe, Access, VBScript, Power Designer, Power Builder, UML

Work Experience – Non-IS

2003 - PresentColumbia College West Valley City, UT

Adjunct Instructor

Teach evening courses in Political Science

1998 – 1999Prudential Insurance Company of America Salt Lake City, UT

Agent and Registered Representative

  • Evaluated financial and insurance needs and objectives of clients
  • Made financial and risk management recommendations
  • Serviced insurance and financial products, including annuities and mutual funds

10/1995 – 05/1998Utah State ArchivesSalt Lake City, UT

Processing / Reference Archivist

  • Processed collections, provided reference service, wrote series inventories, agency histories
  • Developed, designed, built, maintained, and implemented the first references services support system for the Utah State Archives, resulting in improved management of reference information among the staff and improved customer service. Upgraded system to Access 97. (equivalent to about 1 year of technical experience)

Technical Skills: Systems Analysis & Design, Microsoft Access, Visual Basic for Applications, Relational Database Design; Completed Microsoft Official Curriculum for Access 2.0

Education

2001 - 2004Columbia CollegeWest Valley City, UT

BS summa cum laude, Computer Information Systems (GPA: 4.000)

BS, Business Administration in Marketing (GPA: 4.000)

  • Languages used: Java, COBOL, C++, IA-32 Assembly, UML
  • Dean’s List

1991 - 1998University of UtahSalt Lake City, UT

ABD, Political Science (GPA: 3.607)

  • Primary Field: American Government
  • Secondary Fields: Political Theory, Comparative Government (Russia)
  • Allied Field: Philosophy
  • Teaching Assistant (1991 – 1994)

1987 - 1991Western Illinois UniversityMacomb, IL

MA, Political Science. International Relations / Comparative Government Emphasis (GPA: 4.000)

BA summa cum laude, Majors: Economics & Political Science. Minor: History (GPA: 3.955)

● Honors Scholar in Economics / ● Outstanding College Students of America, 1988
● Phi Kappa Phi Honor Society / ● Omicron Delta Epsilon Economics Honor Society
● National Dean’s List, 1988 & 1989 / ● Phi Alpha Theta History Honor Society
● Pi Sigma Alpha Political Science Honor Society

1985 - 1987Black Hawk CollegeMoline, IL

AA, Government and AS, Mathematics (GPA: 3.700)

  • Phi Theta Kappa Honor Society