Sql Server Resume Profile
AL
Objective:
To secure a highly challenging, technical position in the area of database development, computer programming, analysis, or administration that will allow me to utilize and to expand on my experiences in the field of Information Technology.
Skills Summary:
- 24 years at all levels of IT with latest emphasis on DoD Information Assurance and Computer Network Defense, SQL Server 2008R-2, Powershell, ASPX, VB.Net 2008, Business Objects, Visual Basic 6.0, VBScript, ASP.Net, Access 2007/2010, T-SQL, PL/SQL, ODBC, ADO, DAO, XML, APIs, Crystal Reports, MS Office, Project, Visio, SQL Diff.
- Over 20 years as a Software Analyst
- Over 14 years as a Database Developer
- Over 20 years of manufacturing experience
- Over 7 years in support of Department of Defense operations
- Significant experience in DoD IA/CND, Aviation Maintenance Software Design, Development and Support
- Over 6 years management experience as Project-Lead, Development-Team-Lead and IT Department Manager
- Familiar with CMMI Level III Documentation Standards
- Significant experience in software design documentation process, i.e. requirements-gathering, requirements specifications, functional specifications, flow-charts, etc.
- Full Lifecycle Application Development experience SDLC .
- CompTIA Security , Brainbench Visual Basic.Net 2003, MS Access 2000 Programming and MS Access 2000 Fundamentals Certifications
- SQL Server 2000/2005/2008R-2 database design, development and administration
- Oracle 8i/9i/10g/11g database design, development and administration.
- Other databases include Access 95/97/2000/XP/2007/2010, DB2, Progress, Paradox, IMS, Image, dBase III
- Languages include: VB.Net 2003/2005/2008, VB 4/5/6, VBA, VBScript, SQL, PL/SQL, T/SQL, Powershell, ASPX, HTML, XML, PHP, JavaScript, VBScript, DOS, QBASIC, GWBASIC, COBOL, Progress 4GL
- Education in C , Visual Basic, VB.Net, C .Net, ASP.Net, HTML, XML, COBOL, PASCAL, FORTRAN
- Report development experience in Crystal Reports versions 2, 6 and 9, Access and others
- Designed, developed and deployed a Material Requirements Planning System developed in Paradox 3.5 and PAL.
- Administration of Windows 2003/XP/2000/NT/98/95/3.1, MS-DOS, IBM AIX, HP/UX, Linux and HP3000 MPE.
- Windows Network Administration, MS Exchange, Active-Directory, Outlook, Firewall Administration
- EDI Administrator on GEISCO and Harbinger/Supply Tech for DOS.
- Application support for MS Office products, Lotus SmartSuite products and Corel WordPerfect.
- Installation, configuration and support of a document imaging, indexing and filing system.
- Hardware support, including assembly, trouble-shooting, maintenance and repair of PCs and peripherals.
- Programming of Intermec Bar code scanners and data collectors for physical inventory of finished goods.
- Y2K Compliance Programmer/Analyst on HP3000 utilizing COBOL, IMAGE, QUERY, Librarian, MPEX, PowerHouse QUIZ, Suprtool, Transact, Omnidex and DBGeneral.
- System Manager on an HP3000 922 LX, MPE supporting a 32-user MRP system MDSS .
- Member of team that developed an EDI to Order Entry System interface for an HP3000/MPE manufacturing system.
- Custom EDI report development
- Licensed HAM Radio Operator, General Class
- First Aid/CPR/AED certification
- Active Secret Clearance and CAC
Work History:
- Network Defense Engineer SQL Server 2008, Powershell, VBScript, VBA, Army Information Assurance and Computer Network Defense, Joint Net-Ops Command Center - Afghanistan JNCC-A , Bagram Airfield, Afghanistan Confidential
- Supporting IA/CND operations for all of Afghanistan
- Maintain, enhance and support the Heuristic Observable Traffic Passing Across Networks System HOTPAN , an application for identifying cross-domain violations across the entire CJOA for further investigation of potential security breaches and/or spillages of classified information
- Provide SQL Server database administration and support for McAfee HBSS and HOTPAN, as well as Access and Excel support for the IA staff.
- Develop Powershell, VBScript and SQL scripts for obtaining, storing and analyzing and reporting of various network activity logs and registry data being retrieved on a daily basis across all government networks in use in Afghanistan.
- Analyze, improve and/or automate processes wherever possible
- Gather requirements, produce design documents, develop, deploy and support databases and software as needed
- Modify and improve Web-based application for presenting network activity logs to authorized investigators.
- Security certification, Secret Clearance and CAC as required for access to Government Systems
- Senior System Analyst/Aviation Analyst SQL Server2000/2005, Oracle 11g, Crystal Reports, VB.Net, Army Field Maintenance Directive, Support Operations Division, Redstone Arsenal Confidential
- Developed database management system in support of AMCOM's Contractor Oversight Team COT based in Bagram, Afghanistan for use during Inspection, Auditing and reporting processes
- Supported US Army Aviation Maintenance and Supply Systems, ULLS-A E , SAMS-E
- Developed SQL scripts for manipulation, correction and reporting of Government data in SQL Server databases at Reset Sites
- Analyzed, simplified, improved and/or automated processes wherever possible
- VB.Net 2005 SQL Server 2005 GAANT charting application design/development for charting Reset unit performance versus schedule
- Gathered requirements, produced design documents, developed, deployed and supported databases and software as needed
- Designed and developed Web-based application and back-end database for managing ROM costs to reside on Redstone WebDesk. Tools utilized included ASP.Net VB , JavaScript, SQL Server 2005, T-SQL stored-procedures
- Built and deployed data-warehouse server for use in analyses of maintenance data across 160 unit and Reset databases
- Required to adhere to strict government guidelines with regard to CMMI Level III standards for documentation and testing
- Secret Clearance and CAC as required for access to Government Systems
- Contract Programmer Analyst VB.Net, VB 6.0, SQL Server, Crystal Reports Confidential
- Software Developer: VB.Net 2003/2005/2008, Visual Studio.Net, VB 6.0, Visual Studio 6, SQL Server 2000/2005, SQL, T-SQL, OSQL, SQLCMD, ADO, DAO, ODBC, VBScript, Business Objects, Visio, SQL Diff
- Requirements-gathering, software design documentation including requirement and functional specs, Visio process-flow-charting, proposed screen-shots and class-definitions, database schemas.
- Development and support of a system designed and developed for use by ARMY Aviation Maintenance Units.
- Primary area of responsibility is support for the existing Supply System, an ASP.NET VB application, while being involved in the design and development of the next version of the application
- Responsible for designing and developing a scripted solution for migration of users from SQL Server 2000 and MSDE to SQL Server 2005 and SQLExpress, respectively.
- Required to adhere to strict government guidelines with regard to CMMI Level III standards for documentation and testing, as well as strict company software design standards, which were enforced through code reviews by peers
- Systems Analyst/Programmer, Contractor VB.Net, VB 6.0, MS Access, SQL Server Developer Confidential
- Systems Administrator/Network Administrator/Web Master: MS Exchange, Active Directory, Windows 2K3 Servers, Fortinet Firewall, Endian Firewall, VNC, Outlook Web Access.
- Software Developer: VB.Net, Visual Studio.Net, XML, VB 6.0, Visual Studio 6, Access 2000/XP, VBA, SQL Server 2000, SQL, PL/SQL, ADO, DAO, ODBC, API, COM, Excel, Data Migration
- Development and support of a custom loan monitoring system for tracking insurance coverage on properties listed as collateral on bank loans for verification of adequate coverage on real and personal properties with regard to flood zones, wind zones and other locations. Issue notices to customers and force-place insurance coverage as required. Maintained interfaces between TAG systems, banks and insurance providers. Worked closely with bank personnel to ensure the accuracy of the process.
- Senior Software Analyst, Development Team Manager Corporate Agile Team VB.Net and VB 6.0 Developer of Data Migration Tools, Platform Interface Automation and Data Pre-processors Confidential
- Management of a team of developers responsible for design and development of data pre-processors, platform interface automation and data migration tools.
- VB.Net, Visual Studio.Net, XML, VB 6.0, Visual Studio 6, Access 2000/XP, VBA, Oracle, Progress, DB2, IBM/IMS, SQL Server 2000, Unix/Linux, NT/2000/XP, SQL, PL/SQL, ADO, DAO, ODBC, API, COM, XML, Excel, Agile CM Engineering Change Management Software
Senior Developer, Confidential
Worked with team in development and support of Web application for tracking and reporting rail-car repair information utilizing HTML, PHP and JavaScript on Linux with Oracle backend
Contract Programmer Tele-commute , Accu-Reg Software Confidential
- Contracted to modify and enhance an application designed to process exported data from hospital registration system, analyze the data for errors and, where possible, make necessary corrections, report all errors, track the number of errors committed by various users and provide management reports. This application/service greatly improved the accuracy of registration information prior to submission to insurance companies, significantly reducing the amount of time required for claims-processing and payment.
- Senior Software Analyst, Senior Technical Consultant, Development Team Manager - Agile Implementation Team VB 6.0 Developer, Oracle 8i DBA, MS Access 97/2000, Data Migration Tools, Software Adapters, Data Pre-processors, FTP, VB.Net, XML Confidential
- Development of data migration tools, data pre-processors, automation of platform interfaces.
- VB.Net/Visual Studio.Net, XML, VB 6.0/Visual Studio 6, Access 97/2000/XP, Oracle, Progress, DB2, IBM/IMS, SQL Server, Unix, NT/2000, ODBC, SQL, PL/SQL, ADO, DAO, FTP, API, COM, Excel, VBA, Agile Anywhere, wininet.dll.
- COM for automation of data retrieval from Agile Anywhere ECM application via VB 6.0. API to Excel, Outlook and the registry from VB 6.0, Vb.Net and Access.
- FTP automation through VBScript and command files, as well as via function calls to the wininet.dll.
- Dynamic creation of hidden DSN entries in the registry for connection to remote legacy databases from VB and Access through the API. Entries were hidden from the user in order to prevent unauthorized use of ODBC utilities
- MS Access Application Developer/DBA Contractor Supporting Problem Tracking Application for National Operations Center, Single Stock Fund Project, U.S. Army Confidential
- Access 97 database administration, VBA development and support for Access and Excel automation.
- Provided reports and graphs as required to be reviewed by the Department of the Army at the Pentagon.
- Provided user support on various Windows Applications, i.e. MS Word, MS Excel, MS Outlook, PowerPoint, etc.
- Secret Clearance applied for, but project was relocated to Virginia before completion of application.
- Business Technologist Supporting C/S OpenRoad/Oracle App. Confidential
- Provided support for a Client/Server ERP System Adage, SCT with Oracle backend .
- Utilized Citrix for presenting Adage to the user community and as a session support tool.
- Developed interface between HP MM3000 and Adage ERP for automatic order creation.
- Developed Access application that would identify and resolve or report data issues in Adage ERP.
- Visual Basic 5.0 and 6.0, MS Access 97, DAO, ODBC, SQL to Oracle on UNIX and HP3000/Image.
- Crystal Reports 6.0 development, reporting from Oracle and Image databases.
- Access VBA automation of error correction for out-of-sync conditions caused by interface errors, and/or corrupt data.
- Administered an EDI System STX, Harbinger/Supply Tech and interfaces to the HP 3000 via Reflection VBA Scripts.
- Programmer/Analyst Contractor -Y2K Project on HP3000/IMAGE/COBOL Confidential
- COBOL maintenance programming on HP3000 for Y2K compliance and non-Y2K development.
- Modifications to PowerHouse and Transact programs, JCLs and Suprtool routines for Y2K compliance.
- Installed and tested Y2K compliant job scheduling software on the HP3000.
- Visual Basic 5.0 and 6.0, MS Access 97, DAO, ODBC, SQL applications and/or Suprtool routines to replace obsolete HP Information Access applications.
- Crystal Reports 6.0 development, reporting from Image databases.
- Installed, configured MiniSoft ODBC utilities for HP3000/Image with MS Access 97 applications.
- Omnidex, 3rd party indexing software, version upgrade on HP3000/IMAGE
- MPEX, QUERY, Suprtool, DBGeneral, HPEdit, HPGlance, JCL, Librarian.
- Systems Administrator and IS Department Manager, IS Dept. Confidential
- IS Department Manager, System Administrator and Network Administrator for a 50-user Novell 3.12 Network.
- Supported Macola MRP System, HR System and EDI Administrator Harbinger/Supply Tech for DOS.
- Development of a finished goods inventory tracking system in Lotus Approach, QBASIC program to display histogram as part of SPC capability studies of robotics equipment, other Lotus 123 and MS Access 97 applications.
- Crystal Reports 2.0 development, reporting from Btrieve database.
- User support for all MS Office products, Lotus SmartSuite products and Corel WordPerfect
- Administered a document imaging and filing system for the Accounting Department.
- Designed and deployed first company Website utilizing HTML
- Administered a Merlin Legend Definity G-3 phone system.
MIS Director, MIS Dept. Confidential
- IS Department Manager, Administration of a small HP3000 server and Growth Power ERP system.
- Performed user maintenance, Resizing of data sets as needed, backups restores.
- Hardware assembly, installation configuration and support of PC's on Windows NT/95/3.11.
MIS Coordinator, MIS Dept. Confidential
- Administration of a 200-user RS/6000 AIX, warehouse inventory mgmt. system and communications equipment.
- Progress 4GL and Lotus 123 spreadsheet application development.
- Installation and maintenance of LANtastic office networks and PC hardware.
- Developed an inventory system for hardware, software and software licenses in Paradox 3.5.
Programmer/Analyst, IS Dept. Confidential
Member of a Route Accounting System development team working in Confidential SQLWindows and Sybase.
Programmer/Analyst, MIS Dept. Confidential
- System Administrator of an HP3000 922LX 32 user manufacturing system MDSS .
- COBOL maintenance programming, JCL's and PowerHouse QUIZ, HP Glance XL.
- Application development in Paradox 3.5, Lotus 123, dBase III , and QBASIC.
- EDI Administration of GEISCO, GE Information Services for DOS.
- Design and development of an MRP system in Paradox 3.5, which included BOM maint, order entry, material requirements planning, netted production schedule, inventory control for raw materials, WIP and finished goods
- PC hardware and LANtastic network troubleshooting and repair.
- Materials Systems Specialist for Materials Dept, where developed the first inventory control system for raw matl
- Product cost-estimator for the Sales Dept.
- Automated cost-estimation process by developing macro-driven Lotus 123 spreadsheet application
- Quality Control Inspector and Statistical Process Control Technician for manufacturing floor.
- Machine setup and production line management for Paint Dept