Senior Systems Engineer Resume Profile
OBJECTIVE
To obtain a position as a senior IT professional/Data Analyst/Database Developer implementing and supporting highly visible, business critical projects.
SUMMARY OF QUALIFICATIONS
Confidential
- Over 30-year's experience in all areas of computer network design, installation, training, support and project management. Extensive MSSQL experience in all versions from 6.5 to 2008, and currently hold an MCDBA in MSSQL 2000. Problem solver and multitasker with proven ability to make a fast, positive impact on wide ranges of projects. My qualifications include but are not limited to the following:
- MSSQL 6.5/7/2000/2005/2008, MYSQL Access Database development administration
- Programming: VB6, VB.NET,SQL, PERL, HTML, ASP.NET XML
- Scripting: VBScript, PERL, JavaScript
- Report Design: SQL Reporting Services, Crystal Reports, VB.NET, SQL 2005/2008 and MS Access
- Importing and cleansing of data into SQL databases by creating SSIS and ETL packages
- Windows NT/2000/2003 network infrastructure design, installation, administration
Project management
- Help Desk setup and support at a supervisory level
- Server hardware and software setup
- Network mapping flowcharting using Visio
- TCPIP network and subnet design, implementation
- Linux administration
- Cisco Systems router/switch setup administration
- Cisco PIX Firewall setup administration
- Certified Cat5e Fiber Optic network cabling Technician
- VLAN design and implementation
- VPN design and implementation
- Develop and Implement Data Backup strategies Veritas, Vice-Versa and Tapeware
PROFESSIONAL EXPERIENCE:
Confidential
SQL Developer
- Setup FTP sites for client and in-house transfer of large data files
- Create mapping tables for proper data record creation from client input files
- Develop ETL modules using SQL, SSIS packages, and PERL to import data from large healthcare organizations into CareCore's databases
- Troubleshoot data issues for existing data flow issues
Confidential
IT Director / Developer
- Develop Microsoft Access application for deployment to 300 users at Tobyhanna Army Depot under contract from Department of Defense
- Consult on project with client on design and implementation of application
- Consult with client and Centris consultants on technical direction of project, including moving Access Backend to SQL 2005 and Frontend to an ASP.NET web application
- Write stored Procedures for data access to SQL 2005 backend
- Create SSIS scripts to transfer data from Access db to SQL 2005 db
- Creation of Client Requested reports on historical data and utilization
- Manage application project creating web based business application
Confidential
Microsoft Certified Instructor
Microsoft Certified Technical instructor for students working on certifications in the IT industry. Instruction for Microsoft MCSE, MCDBA, MCSD, MOS, Cisco CCNA, Applications including Office, Crystal Reports, Photoshop, Dreamweaver, and Frontpage.
Confidential
Senior Systems Engineer
- Lead engineer on Enterprise level project involving 6 daily newspapers
- Supported LAN/WAN consisting of Cisco Switches and Routers
- Managed server farm of 40 servers running NT/2000/2003
- SQL 2000 database administrator for 6 daily newspapers
- Liaison with Unisys on enterprise wide application for publishing systems
- Linux Email Server administrator for 13 newspapers
- Unix, AS400 administration
- Managed various backup solutions using Backup Exec Enterprise
- Created workflow applications and scripts using VB6, VB.NET, SQL, PERL, JavaScript and VBScript.
- Avaya and PBX administration
Confidential
Sole Proprietor/Consultant
- Manage mid - large scale projects of network and application installation and upgrades
- Specializing in installation of CAT5 and Fiber optic networks
- Installation and support of Microsoft NT/2000/2003 networks
- Design and administration of Microsoft SQL and Access databases
- Install Legato Systems co-standby server now called Replistor
- Support of Advanced Publishing Technology APT Editorial and Classified newspaper software, including integration with Quark Express, Adobe InDesign, Adobe Photoshop, Xpance Display Advertising software, and Crystal Reports
- Develop programs for Clients using Visual Basic 6/.NET, Microsoft Access, and SQL databases.
Confidential
Principal Partner/Consultant
- Nation wide consulting to daily newspapers for their IT needs
- Supporting and upgrading of existing Computer Automation mainframe systems
- Contracted support to installed systems
- Installation and support of Novell and Microsoft networks.