Post a Job Sign in

Patrick Sofin

Systems Architect / Database / Software Engineer

Colorado Springs, CO


To obtain a senior systems engineering, integration, or architect position in which to use my extensive database, software, and systems experience to the advantage of your organization's success.

Work Experience

Database / Software Engineer

Patrick Sofin Consulting
Colorado Springs, CO

October 2010 to Present

Clients: Woman Marine Association (WMA), Women of the Corps Foundation (WCF), Others. 
• Chief Data Architect and Applications Architect for the design, development and improvement of a web-based database application using Oracle 8-11g, MS SQL Server 2000-2008, MySQL and Access, Eclipse (Indigo v3.7) and Java EE 1.5-1.7 to design an extensive SQL database to catalog a major museum collection. 
• Java Web services were created using Jersey, and Apache CXF on Linux for RESTful and WSDL based services. Apache ANT and Maven. Services hosted on Apache Tomcat and JBOSS AS. 
• JavaGUI development using JDK 1.7, and Eclipse Indigo, with WindowBuilder plug-in, PuTTy for port tunneling, Batik plug-ins for Scalable Vector Graphics, Inkscape for SVG editing, and Cygwin for the Windows X server environment.. This design was extensively XML data driven. 
• Supported Virtual Private Network using Public Key encryption. 
• Supported Windows XP and Red Hat Enterprise Linux as the delivery platforms. 
• C++ was used to interface with unmanaged code and Windows API. Visual Studio.NET was used with C#.NET for some web interfaces. 
• Reviewed Access database designs to prepare transition to SQL database. ETL (Third party and custom built) tools were used to transfer data from the existing Access databases to Oracle and MySQL instances. 
• Wrote extensive SQL adhoc queries to support reporting and data migration. 
• Software architecture support using Windows 98/2000/XP/Vista/Windows 7, UNIX (Solaris and Red Hat Enterprise Linux (RHEL)), Oracle 8 -11g, and MS SQL server 2000 - 2008.

Electronics Engineer

Volunteer Positions
Various Locations

January 1969 to Present

Working alone and with other EMS support personnel I designed, built, repaired and restored antique and amateur radio equipment including receivers, transmitters, and antenna systems. Extensive training in crisis response and planning. 
Participated in EMS support and activities. 
The activities of this position included: 
• Utilizing extensive experience with antenna design, electromagnetic wave propagation, communications and electronics principles and technology. 
• Working with antique and modern ground terminals and satellite and computer radio technologies. 
• Utilized HAM radio Amateur Extra license. 
• Worked in radio and color television repair. 
Languages: C#, VB .NET 2003-2008 Enterprise Edition, Visual Basic for Windows Professional/Enterprise Edition 3.0-6.0 [Active X Components and Controls, Active Server Pages, ActiveX Data Objects, Data Access Objects 3.5, Remote Data Objects 2.0, COM, DCOM, OLE Automation], Microsoft Visual C++ 5.0-6.0, Microsoft C 6.0, PeopleSoft 7.02-8.3 / SQR / PeopleTools, UNIX Shells: Bourne, C, K, T, Bash, Perl 4.0-5.8, DHTML, HTML, XML, XPATH, XSD, XSLT, SOAP, WSDL, BPEL, SOA, Web Focus, Java Script, JAVA 1.1-1.5, J2SE 1.4.2_09, VB script, Visual Basic for Applications, Ada, FORTRAN 77, MUMPS, Basic, Assembler, PL/1, MVS JCL.

Systems Architecture Integration Engineer

Patrick Sofin Consulting
Warner Robins, GA

January 2012 to March 2012

Worked with a team of engineers to support the Distributed Common Ground Station (DCGS) Bulk Release 10B. Supported the Critical Design Review (CDR) and tracked CDR action items. Investigated and resolved system design problems including: overall system performance, enterprise integration issues, and COTS/ GOTS software product issues. Served as lead for two task orders supporting sub-contractors from other companies. 
The activities of this position included: 
• Supporting the Enterprise Portal (EP), the Enterprise Management Cell (EMC), the Mission Enclave Management Cell (MEMC), the Mission Enclave Application Cell (MEAC), and the Containerized Clustered Virtual Environments (CCVs). 
• Migration of systems design and implementation towards a more open architecture environment. 
• Supporting Sun T2/T3/T4 hardware architecture platforms using Solaris 10 with zones, database systems using Oracle 11g, and X86 hardware platforms using Windows Server 2008 R2. 
• Resolved NFS mounting schemes issues using different NFS and Server fully qualified domain names. 
• Supported DNS domains to supply name resolution for the enterprise. 
• Supported Host based Security System (HBSS) and with LDAP authentication using IAAS. 
• This position was eliminated due to a contract related change in project funding.

Senior Programmer Analyst Principal

CACI International, Inc
Winchester, VA

March 2010 to September 2010

Worked with a team of engineers to provide enterprise hardware, software, and O&M support for Windows 2000 and Windows XP workstations. Developed software applications used to monitor system performance, generate automated alarms, and automate the configuration of workstations to interface with desktop applications via a SharePoint (MOSS 2007) portal interface. Supported a customized proprietary records management system build in HighView SDK 4.1 
The activities of this position included: 
• Using Windows Script Host Object Model (WSH) and VBScript (VBS) to create scripts that would directly edit the system registry to set the required Internet Explorer 6.0 user permissions. 
• Using custom developed alarms to report on blocking locks detected using a custom built SQL query running on Oracle via an ODBC connection using ADO with VBScript, TOAD 7.6, and Ultra-Edit32 10.0. 
• Implementing coding standards, code development, reusable software libraries, and management best practices. 
• Supporting Solaris 9, Windows Server 2003 R2, and Oracle 10g 
• Providing direct support to end users. Worked with several trouble ticket reporting systems. 
• Working with a team of developers and system support personnel to manage trouble tickets generated by users. 
• Providing SAN design support. 
• Supported the migration from Windows 2000 to Windows XP for developers, and the VS .NET development environment.

Senior Database Architect

L-3 Communications
Tampa, FL

March 2007 to September 2009

Developed technical requirements, performed object oriented analysis and design, validation, and implementation of windows based and web based applications. Analyzed, designed and tested network and server architectures to support multiple proposed thin client solutions. Supported the Distributed Common Ground Station - Special Operations Forces (DCGS-SOF) Program Team.. Developed metadata schema and resolved cross-platform integration issues. Responsible for selecting, purchasing, installing, testing, and evaluating, both Hardware and Software (COTS / GOTS). 
Performed heterogeneous platform and architecture development, and systems integration. Mentored and coached less experienced team members. 
The activities of this position included: 
• Using HTML, Classic ASP, and ASP.NET 1.1-2.0-3.5, VB, C#, and VS .NET 2003 - 2008, 
• Using Microsoft SQL Server 2000 - 2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), 
• Developing T-SQL stored procedures, functions, and web services. 
• Reviewing and extending the ER design of SQL database instances, including data warehousing and datamarts. 
• Supporting the development of portal technologies using Microsoft SharePoint 2007. 
• Creating applications to provide access to DOD approved Active Directory extended attributes on Windows Server 2003. 
• Simulating simultaneous multiple client loading on thin client architectures under test conditions using VBScript and VMware 3.5. 
• Providing tier three support to resolve CA Unicenter trouble tickets. 
• Supporting Solaris 10, Linux, and Microsoft Windows XP based systems. 
• Using Java, Oracle Web Logic, Oracle 10.2g, OpenMap, and the Multi-Media Analyst and Archive System (MAAS). 
• Supporting the DCGS Integration Backbone (DIB) using SOA architecture and XML web services.

Database / Systems Administrator and Software / Systems Engineer

Northrop Grumman Mission Systems
Colorado Springs, CO

March 2003 to October 2005

Colorado Springs, CO [Joint National Integration Center] (March 2003 to October 2005). 
Worked sometimes alone, and sometimes with a team of engineers to support Ballistic Missile Defense (C2BMC) at the Joint national Integration center (JNIC), located at Schriever AFB. Many duties were performed while supporting this project: 
• Database Administration using Oracle 8i-9i-10g / MS SQL Server 2000/Oracle PL/SQL stored procedures, Oracle packages, and MS T-SQL. Designed and implemented Oracle 8i-9i-10g databases. Ongoing database performance monitoring, and tuning. SQL query design, development, and support. 
o Used TOAD 7.x-8.x, Oracle Enterprise Manager, and Grid Control for Oracle database support. 
o Used MS SQL 2000 Enterprise Manager and SQL Query Analyzer for MS SQL Server 2000 support. 
o Used Perl 5 and Bourne shell scripts to automate Oracle database startup/shutdown, and backups. 
o Performed database migration, restoration, and ported databases to new platforms. 
• Systems Administration using UNIX and Windows 2000/XP for servers and workstations. Solaris and IRIX support provided. Hardware used included Sun Ultra-60, E420, 480, V880, SunBlade2000, and SUN 3510 FC StorEdge array, and various SGI platforms. 
• ClearCase Administration using version 2002.05 Multisite on Solaris 8 / 280R platform with integration to ClearQuest. Worked with ClearCase clients on Windows 2000 platform. Supported the Rational Unified Process (UCM). 
• Data Warehouse/Datamart Engineering and support including ETL activities and implementation using J2SE 1.4.2_09 with NetBeans 4.1, PL/SQL stored procedures, and Perl 5 on Solaris 9 and Windows XP using Oracle 10g clients and server. IA compliance issues were addressed and resolved. 
• Software Engineering and support using VB.NET 2003 Enterprise edition. Created application for Asset configuration management. Used MS SQL server 2000 to develop and implement database backend. 
• Systems Architecture Integration Engineering. Designed and implemented a Storage Area Network (SAN) solution using hardware from multiple vendors. Performed Systems / Network Engineering, Systems Administration, and Project Management tasks in this effort. Performed engineering analysis for replacement and upgrading of existing computer and networking equipment including equipment specifications and cost-benefit analysis to meet acquisition objectives.

Database/Software Engineer

Patrick Sofin Consulting
Colorado Springs, CO

June 2001 to March 2003

Worked alone and with other engineers to support a variety of projects. Provided system software and hardware architecture support and integration. Performed database design and development, including implementing ETL processes and procedures. Ongoing training in RDBMS concepts. Supported PeopleSoft ERP upgrade for HR and Payroll. 
The activities of these positions included: 
• Creating and modifying Custom PeopleSoft SQR's. 
• Using Perl V 5.005 and Excel Macros to perform data transformations and Excel reports. 
• Working with PeopleSoft ERP 7.02 - 8.3 upgrade for HR and Payroll. 
• Performing ETL from Informix V. 7.31 on HP-UX B.11.00 to DB2 on MVS OS/390 using various Informix (dbexport, dbschema, dbaccess), compression, ASCII-EBCDIC conversion, and DB2 (DB2 Load) tools. 
• Supporting AIX and on Windows. 
• Using PeopleTools 8.14 to work with PeopleSoft Objects such as Records, Fields, Pages, etc. 
• Working with PeopleSoft in two-tier, three-tier, and Web-based modes. 
• Performing Oracle 8i/9i database ER design, development, SQL custom queries, and documentation. 
• Creating and maintaining PL/SQL stored procedures, triggers, forms and reports. 
• Supporting UNIX (Solaris 10 and AIX), Windows 98/2000/XP, Windows Advanced Server 2000, and MS SQL Server 2000. 
• Working with VB, VB script, classic ASP, ASP.NET, DHTML, XML, Java Script and Apache Web Server.


Various Clients
Various Locations

February 1999 to March 2003

Software Developer

Broadwing Communications
Austin, TX

March 2000 to June 2001

Worked with a team of engineers to support a variety of projects. Created a Web based commissions tracking tool. Automated a complex manual process. The automation of this manual process took the place of three FTE positions. Created, and performed maintenance, and data import for a datamart for telephone records auditing purposes. Implemented an ETL system to gather information from one Sybase 11 database and three Oracle 8.16 instances to reconcile Primary Interexchange Carrier Charges (PICC). 
The activities of this position included: 
• Using SQL Server 7.0 to design and implement a 27 table relational database. 
• Used Visual Interdev 6.0, Active Server Pages, IE 5.5, and T-SQL Stored procedures. 
• Used Perl 5.600, the Tk kit for Perl, and ACR Detail (Unitech Corporation) to automate a manual process. 
• Using Powermart Informatica 4.7, Embarcadero Rapid Sql 5.7, Sql Navigator 3.2. 
• Using Oracle Developer 2000 for NT, Oracle 8.16 (Client and stored procedures), and Brio Query Designer 6.2.2 (a web-based reporting tool) 
• Worked with Web Focus to review its potential as an OLAP tool. 
• Supported the data warehouse and Operational Data Store. 
• Over 10 million dollars in revenue identified for recovery.

Software Developer

Renaissance World Wide
Austin, TX

February 2000 to March 2000

Worked with a team of engineers to develop and implement a web-based telephone records and expense tracking tool. 
The activities of this position included: 
• Using Java (Forte for Java, Visual Café), Java Script, VB Script, Visual Interdev 6.0, and Active Server Pages. 
• Using IE 5.0 and Netscape 4.7. 
• Using Visual Basic 6.0 to develop and implement COM objects on Microsoft Transaction Server. 
• Using Visual Basic 6.0, SQL Server 7.0, Active X Data Objects, and Microsoft Access 8.0. 
• Implementing changes to an existing desktop database application and update tool.

Systems Integrator / Architecture Analyst

Compaq Computer Corporation
Greenbelt, MD

February 1999 to May 1999

Worked with a team of engineers to provide software and hardware architecture analysis for a web based development effort for the United States Postal Service. VeriSign certificates were used to implement SSL An Oracle 8.x database was installed and configured. Produced documented analysis of the current application architecture and provided recommendations for improvements. 
The activities of this position included: 
• Using Solaris 7.0 (2.7) 
• Performing software and hardware systems administration. 
• Supporting Sun Enterprise 3000 Server, 
• Using Solaris for ISP 2.0, Sun Web Server (SWS) 2.1, HTTP, and HTTPS. 
• Using Secure Socket Layer (SSL), Java 1.1-1.2, Sun Hot Java browser, and Netscape 4.05. 
• Using Windows 95/NT 4.0, Microsoft Internet Information Server (IIS), and Microsoft Sequel Server 6.5. 
• Using Microsoft Internet Explorer 4.0, Visual basic 5.0, DCOM, and Microsoft Message Queue.


Master of Science in Software Development and Management

Rochester Institute of Technology -
Rochester, NY

1988 to 1992

Advanced Certificate in Applied Computer Studies

Rochester Institute of Technology -
Rochester, NY

1988 to 1991

Doctor of Dental Surgery

State University of New York at Buffalo -
Buffalo, NY

1977 to 1981

Bachelor of Science in Chemistry

State University of New York at Albany -
Albany, NY

1973 to 1977

Additional Information

• Active US government Top Secret / SCI security clearance. 
• Database and data warehouse design and implementation. 
• Systems hardware and software architecture, analysis, design, management, and integration. 
• Systems and database administration. 
Operating Systems: Windows 3.1/3.11/95/98/NT/2000/XP/VISTA, Windows NT 3.5.1-4.0; Windows Server 2000-2008, AIX 4.1.4; HP-UX B.11.00, Solaris 1.1.1-2.4, 8-9-10; SunOS 4.1.1-4.1.4; IRIX 4.0-6.5.6, OS/2 2.0-2.11; DOS 3.3-6.22; MVS: OS/390, TSO/ISPF, RJE, JCL, IMS; AT&T System V 3.5.1, DEC ULTRIX; VAX/VMS 5.5, OSF1 3.2-4.2; Mac OS 8.0, Linux (SUSE, Slackware), Red Hat Enterprise Linux (RHEL) 5.3-5.4. 
Hardware: IBM / PC Compatibles and Notebooks: ISA, EISA, PCI, PCMCIA, SCSI Peripherals; Sun X86 / Sparc: SLC, IPC, IPX, Classic, LX, Ultra, 2, 5, 10, 20, 60, 80 Sun Server 4/330, 1000, 2000, Sun Enterprise 3000, Sun E420, 480 V880, 3510 FC StorEdge array, V210, V240, V440, Blade 150 and 1500, and Sun peripherals; Silicon Graphics Indigo, Indy, Indigo2, O2, Octane, Origin 200 and 2000; Other: IBM 3090 Mainframe; DEC VAXCLUSTER; DEC ALPHA; Macintosh, Routers, Switches, Firewalls, Print servers. 
Software, Tools, and Utilities: Visual Studio .NET 2003 - 2008, Rational Rose 2002 and UML, ClearCase Server Multisite 2002.05, ClearCase Client 2002.05 for Windows 2000, Clear Quest, PeopleSoft 7.02-8.3, PeopleTools 8.14, SQR, Forte for Java, NetBeans 4.1, Visual Café, Visual Studio 6.0, Visual Interdev 6.0, Common Gateway Interface (CGI), Netscape Navigator 2.0-4.7, Microsoft Internet Explorer 3.02 - 8.0, Apache Web Server, Microsoft Internet Information Server (IIS), Microsoft Visual SourceSafe 4.0-6.0a, Sun Web Server (SWS) 2.1, Solaris for ISP 2.0, Network Time Protocol (NTP), Robo Help 4.0, Crystal Reports 4.0-7.0, Rumba for NetWare 3.1-3.2, Rumba APPC 3.2-4.0, Rumba Office 1.0, Rumba Tools for Visual Basic 1.0-2.0, McAfee Anti-Virus 1.14-2.27, Norton Utilities 5.0-9.0, Symantec / Norton Anti-virus, Pro/Engineer 11.0 (CAD package), ProComm Plus 2.0-3.0, Reflections for Windows 4.0, Smarterm 240; Microsoft Excel 4.0-2000 for Windows, Microsoft Office Professional Edition 4.2-2007 for Windows 95/98/NT/2000/XP. IEF Toolset 5.0 (For Microfocus Cobol), WhatsUp Gold, Remedy Trouble Ticketing System, Multitier systems implementation, E-mail services, Domain Name Service (DNS), Network Information Service (NIS, NIS+), Network File System (NFS), File Transfer Protocol (FTP), Remote Access Service (RAS), DHCP, LDAP, Active Directory. 
Databases and tools: TOAD (Tools for Oracle Application Developers) 7.x-9.x, JDBC, ODBC, Oracle Enterprise Manager 8i-9i-10g-11i, MS SQL server 2000-2008 Enterprise Manager / SQL Query Analyzer, Integration Services, Reporting Services, PeopleSoft 7.02-8.3, PeopleTools 8.14, SQR, Informix V 7.31 on HP-UX B.11.00, DB2 on MVS OS/390, Oracle Forms 6i and Reports 6i, Oracle Developer 2000 for NT, Oracle 7.0-8.16-8i [Database, Client, SQL, PL/SQL, and SQL Plus], Microsoft Access 2.0-2007, Microsoft SQL Server 6.5-7.0-2008, T-SQL and SQL server toolset (ISQL) stored procedures, functions, Sybase 11[Database, Client], DB2 via Sybase Gateway, Powermart Informatica 4.7, Embarcadero Rapid Sql 5.7, Sql Navigator 3.2, DB2 / SQL, VAX RDB. 
Networks: HTTP, HTTPS, SSL; FTP, NTP, TCP/IP, DHCP, IPX/SPX, NetWare 3.1.2(server)-4.10(client), NetWare for SAA 1.3 (server); SNA / SDLC 3270, lu 2.0-6.2. ; DECNET/Pathworks 4.0; Sockets, LAN / WAN.