SKILL:

SQL Server 2008 ASP, ASP.NET VB Script Confidential - SQL Language

Perl Script PHP Script Windows Servers FORTRAN

HTML/CSS/DHTML Java Script Linux Redhat/Fedora UNIX

Visual Basic C, C++, C# Cisco Networking MS Access/Excel (Macro)

MySQL Database Nessus Packet Scanners NMap Port Scanner

Assembler Languages (Z80, 6502, 8086, Vax Assembler)

PROFESSIONAL EXPERIENCE:

Confidential

IT Specialist / Systems Analyst / ASP.NET Developer / Sharepoint Administrator

Responsibilities:

• Created new Sharepoint 2013 System
• Data Migration using SSIS from AS400 DB2 to SQL Server 2010
• SSRS reports on migrated data using Confidential -SQL Stored Procedures, Views, Linked Servers
• Sharepoint 2013 Administrator and Designer and Infopath custom forms
• Custom ASP.NET C# Applications with SSL

Confidential, Houston, Texas

Systems Data Analyst / Database Administrator IT Contractor

Responsibilities:

• Database Administrator building and maintaining Databases and Data Warehouse
• Creating Custom reports using Jet Report Excel Plugins
• Creating reports using SQL Server Reporting Services, Stored Procedures and Views
• ETL importing data into Databases and Data Warehouse using SSIS
• Maintaining application written in PHP

Confidential, Bellaire, Texas

ASP Programmer/Technical Writer/Network Administrator/Security Analyst/.NET programmer

Responsibilities:

• Maintaining ASP applications in Classic ASP
• Writing new applications and components in .NET C#
• Writing Stored Procedures for SQL Server
• Securing in web applications to prevent SQL Injection, Cross Site Scripting, Form Injection
• Monitoring log files for suspicious activity including penetration scans, brute force attacks
• Technical writing of the applications software to include Data Flow Diagramming, Entity Relation Modeling and Diagrams, Database Schemas, Software Life Cycle Modeling, Project Management methodologies. managers on Software Life Cycle, QA and Project Management
• Managing SQL Servers with Backup Jobs including Full, Differential and Transactional Backups
• Writing Stored Procedures, Triggers, Views for SQL Server Databases
• Implemented Triggers and Recovery Plan to preserve critical data from being deleted
• Working with Team Foundations Servers and Visual Source Safe
• Building and Maintaining Windows Servers, Setting up TCP/IP Printers, Desktops, Laptops, Scanners
• Installing Software: SQL Server, Windows, Virus Scanners, security updates, etc
• Building Linux Servers and Monitoring Software (Nagios/Nessus/Nikto) and Syslog for Firewall Monitoring
• Creating Perl Test scripts for internal Penetration Testing
• Repairing Servers and performing upgrades such as Network Cards, Memory, Hard Drives
• Configuring hardware VPN firewalls and Server Firewalls for SMTP, SQL Server and Web HTTP/HTTPS protocols
• Maintaining Firewall configuration documents
• Setting up secure Wireless routers with WEP encryption
• Setting up NAS Drives for file shares and secure AES file encryption for secure file retrievals

Confidential, Houston, Texas

Sub Contract Programmer

Responsibilities:

• Three week project debugging and fixing in house Visual Basic application, and Reporting Services

Confidential, Sugar Land, Texas

Sub Contract Programmer

Responsibilities:

• VBScript programmer developing automation VBScripts to automate data cleansing of inventory data building HTA user interfaces to call CScript programs and SQL Server stored procedures and tables
• Developing Macros and VB code for data cleansing or formatting Excel Spreadsheets for import into SAP systems

Confidential, Galveston, TX

Contract Programmer

Responsibilities:

• ASP Programming with SQL Stored Procedures for calculating dates in IIS 5.0 and SQL Server 2000
• Implemented SQL Triggers for enforce data integrity
• Excel applications programming calling Stored Procedures functioning as original ASP Web pages for testing outside ASP web pages
• Parsing XML files for passing parameters to ASP Web pages and Stored Procedures

Confidential, Houston, TX

Programmer Analyst and SQL Server Database Administrator

Responsibilities:

• Migrated Databases from SQL Server 7 environment to SQL Server 2000 including Databases, Users and Roles, and Repricing Application to upgrade to a better server platform.
• Created various ASP Web applications using VBScript, Javascript and DCOM Objects with Visual Basic 6.0 Microsoft Transaction Server and ADO components
• Designed and Implemented SQL Server backup and maintenance plans and Database Replication
• Created and automated ETL processes to download flat files via FTP, Decrypt PGP files and import the files into SQL Server Databases and transform files into AHI’s internal formats using MS Dos batch files, BCP commands and DTS packages
• Created batch processes to parse and import EDI ANSI 837 files into SQL Server databases for repricing and exported repriced claims to EDI ANSI 835 responses to business partners, encrypting with PGP.
• Created ad-hoc reports by importing client Excel Spreadsheets into SQL Databases and running ad-hoc queries against SQL Databases then exporting the results back to Excel Spreadsheets in the original format provided by the client or customer request
• Created and maintained user security on SQL Servers including SQL Server roles

Confidential, Utica, New York

VB Programmer, IIS Administrator, ASP Developer

Responsibilities:

• Developed applications under ASP and Microsoft Access databases, using VBScript, Perl script and Javascript.
• Implemented web user security.
• Managed IIS 5 web servers including monitor web server usage and logging and monitoring user sessions
• Built new Visual BASIC 6 applications and managing existing Visual BASIC applications related to ImageMate product line of Real Property information management systems
• Built custom reports using Crystal Reports with Visual Basic 6
• Provide onsite customer support installing applications or troubleshooting applications