|Desired Industry: Computer Software/Programming
|Desired Job Location: New London, Connecticut
||Date Posted: 6/5/2007
|Type of Position: Full-Time Permanent
||Availability Date: 6/11/2007
|Desired Wage: 65000
||U.S. Work Authorization: Yes
|Job Level: Experienced with over 2 years experience
||Willing to Travel: Yes, Less Than 25%
|Highest Degree Attained: Masters
||Willing to Relocate: Yes
Hands-on technical/technical management position in database systems development.
Raytheon Technical Services (2006-present)
Create, maintain, troubleshoot, and enhance multiple, interlinked client-side and (single) server-side MS Access 2003 databases pertaining to the development, evaluation, administration, distribution, and management of SOBT products.
Evaluate beta test versions of SOBT products, to verify compliance with SCORM requirements.
dba SofTail (The Software Tailor)
Freelancing from my home computer, performing small-scale, short-term projects.
ELECTRIC BOAT CORPORATION
Data Integrity Group (2002-2004)
Streamlined and significantly enhanced an Access database system used for auditing CATIA-based data objects (e.g., 2D and 3D drawing models, Configuration Release Objects, parts, plot sheets). This involved extensive SQL procedure writing for Access and DB2, and configuring and tuning.
Streamlined and significantly enhanced the business process for performing audits, including:
enhancing a legacy SQL query to a DB2 database, to select which objects to audit,
developing Excel and Access macros, to automatically format/transfer the results of the DB2 database query into the Access database,
creating SQL and Visual Basic code in Access, to auto-fill the audit forms, including automatic assignment of audit objects according to the auditor's areas of expertise,
reviewing the completed audits, to verify their correctness and accuracy, by viewing randomly-selected audit objects within the CATIA system,
creating Access forms, to incorporate audit results into the Access database system,
within Access, creating ad-hoc and quarterly Audit Findings reports individually tailored and e-mailed to each of the engineering supervisors, managers, and directors (as opposed to the legacy system of requiring each person affected to access a "one size fits all" Lotus Notes file of ~200 pages, to extract their information, which ranged from 2-10 pages).
As a result of my improvements to the business process, the number of audits increased from 10-15% of the available objects, to 70-100% of the available objects, and the average size of an individual supervisors report was reduced by ~90%.
Standards and Procedures Group (2000-2002)
conduct audit of all workmethods, standards, and procedures, as well as Data Integrity procedures, which were utilized as company-wide rules for interacting with the CATIA system to develop computer-based models,
develop a business process to convert workmethods, standards, and procedures from an in-house authoring system used to create paper-based manuals, to an Intranet web site based system,
use Word macros and Visual Basic to automate and standardize aspects of this conversion, to minimize human error, and to test for errors in the conversion process,
develop and document "lessons learned" standards and procedures for the conversion process.
Engineering Innovation Group (1996-2000)
perform comparative analyses of enterprise resource planning software products
perform comparative analyses of object-oriented database software products for both engineering and business decision support system applications
design, develop, and implement a prototype object-oriented database structure for ship valves
use C++ to assist in developing a virtual reality simulation for the spread of fire and smoke for a shipboard fire, on a Sun Unix workstation (7-month project)
design the Concept Formulation conference room, featuring 12 laptops, four workstations, and four liquid plasma wall displays
I received the following awards, during this period:
February 1997: Electric Boat; $500 award for work performed as a member of the project team for fire and smoke modeling in virtual reality.
NAVAL UNDERSEA WARFARE CENTER
Service Contract System Administrator (1986-1996)
develop software systems for management/business applications within the directorate, including database design, human interface design, knowledge engineering, and expert systems development
develop and implement systems to facilitate the acquisition and monitoring of contractor services
respond to program manager queries regarding contracts
act as liaison among engineers, contract negotiators, and contractor company executives
The total scope of work involved approximately 35 contracts, worth over $250 million, for work to be performed during contract periods ranging from 1 to 5 years.
I received the following awards, during this period:
January 1987: Special Achievement Award ($1,200) from the NUSC Technical Director, "In recognition of and with appreciation for your sustained superior performance of duties at this center during the period January 1, 1986 through December 31, 1986."
9 March 1987: Letter of Appreciation/Significant Accomplishment from supervisor, for initiating 20 contract packages, totaling $67 million, in materials and services.
15 September 1988: Special Achievement Award from the NUSC Technical Director, "In recognition of your superior contributions and dedication to duty"
30 June 1996: Special Act Award from the NUSC Commanding Officer, "In recognition of your superior contributions and exemplary achievements, for outstanding work and technical expertise as a contract technical representative for Code 30. Mr. Panko's effort in supporting the planning, development, and technical guidance of Code 30 contracts has resulted in quantitative improvements in the execution of all of Code 30 contracts."
Rensselaer Polytechnic Institute; MS, School of Management, Operations Management/MIS; 4.0 GPA
University of Connecticut; BS School of Engineering, EE/Computer Science; 3.2 GPA
NOTE: All of the listed training occurred during 2007.
COURSE TITLE HR/MIN
Database Technologies, Part I 8
Database Technologies, Part II 8
MS Word 2000 Fundamentals 8
Crystal Reports v10 Introduction to Report Design, Part 1 4
Crystal Reports v10 Introduction to Report Design, Part 2 4
Crystal Reports v10 Introduction to Report Design, Part 3 4
Data Objects in the Oracle 10g Database 2
MICROSOFT ACCESS 42
MS Access 2000 Fundamentals 8
MS Access 2000 Proficient User 8
Getting Started with Access 2003 2h40m
Basic Access 2003 Tables 3
Basic Access 2003 Forms 2h40m
Using Queries and Reports in Access 2003 3h40m
Personalizing and Maintaining Access 2003 1h20m
Enhancing Tables, Forms, and Reports in Access 2003 2h20m
Advanced Querying in Access 2003 1h40m
Working with Data and Presentation in Access 2003 2
Access 2003 and the Web 1h20m
Access 2003 Programmability 1h20m
Database Administration in Access 2003 2
Six Sigma and the Corporate Enterprise 3
Define the Six Sigma Opportunity 3
Leadership in Six Sigma 3
Six Sigma Team Dynamics and Performance 3
Six Sigma Team Leadership 3
History of Organizational Improvement and the Foundations
of Six Sigma 2
Organizational Goals and Objectives 2
Overview of Business Process Management 2
Monitoring SQL Server 2000 Performance 2
The Six Sigma Project Charter and Plan 2
The Six Sigma Change Agent 2
Six Sigma and the Voice of the Customer 2
Six Sigma and Critical Customer Requirements 2
The Importance of Metrics to Six Sigma 1
SQL SERVER 28
Using T-SQL in SQL Server 2000 3
SQL Server 2000 Programming Business Logic 3
Overview of SQL Server 2000 2
SQL Server 2000 Databases 2
Managing SQL Server 2000 Databases 2
Backing Up SQL Server 2000 Databases 2
Restoring SQL Server 2000 Databases 2
SQL Server 2000 Replication 2
SQL Server 2000, XML, and the Web 2
The SQL Server 2000 Logical Data Model 2
SQL Server 2000 Indexes 2
SQL Server 2000 Transactions and Distributed Data 2
Transferring and Transforming Data in SQL Server 2000 1
Designing and Implementing Security in SQL Server 2000 1
Lifetime member of MENSA.
2006 - present: Windows XP, Windows NT, Dreamweaver 2004, Advanced Learning Center ADL Test Suite 1.2.7, Army Validator Tool, W3C HTML Validator, data warehousing, SQL, Visual Basic, XML, Microsoft Office
2005: IBM-compatible PC, Photoshop 8.0, Crystal Reports, Microsoft Office XP Professional (Access 2002, Excel 2002, PowerPoint 2002, Word 2002), .NET, Oracle 10g
2002-2004: NT workstation, Dreamweaver 4, FrontPage, Microsoft Word, Page Maker, Powerpoint, Visio, Windows XP, Windows ME, Windows NT, data warehousing, data mining
1996-2002: HP workstation, NT workstation, HP UNIX, HTML, Microsoft Word, Windows 3.1, Windows 3.51, Windows 95
1986-1996: IBM PC, VAX 11/780, VAX 8600, MS-DOS, Lotus 1-2-3, Oracle, Prolog, SQL
1980-1986: VAX 11/780, VAX 8600, BASIC, COBOL, DATATRIEVE, DBASE III/IV, DCL, FORTRAN, FoxBase, LISP
1978-1980: Hewlett-Packard desktop series, HP-BASIC
I hold an active SECRET clearance.
Available upon request.
Candidate Contact Information:
|JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.