Sql Server Computer Science

Daniel R. Davis

Skills

SQL Server **** Classic ASP, ASP.NET VB Script T-SQL Language

Perl Script PHP Script Windows Servers FORTRAN

HTML/CSS/DHTML Java Script Linux Visual Basic

C, C++, C# MS Access/Excel Sharepoint Sharepoint Designer 2010/2013

MySQL Database InfoPath

Professional Experience

October 2013 to July 2017

T&L Distributing

IT Specialist / Systems Analyst / ASP.NET Developer / Sharepoint Developer & Administrator / SQL Reports

Sharepoint Developer and Administrator installing and setting up Sharepoint for Departments and SSRS

Worked independently as sole IT Personnel

Data Migration using SSIS from AS400 DB2 to SQL Server 2010 for SSRS reporting

SSRS reports on migrated data using T-SQL Stored Procedures, Views, Linked Servers

Sharepoint 2013 Administrator and Designer and Infopath custom forms

Custom ASP.NET C# Applications with SSL for Forms Submissions and Product Catalog

Built over 60+ SSRS reports including Financial and Statistical Reports, and reports on Report usage Logs and Application Log

Built about 12+ SSIS Packages for importing 120+ Tables from DB2 to SQL Server 2010 with extensive T-SQL scripts for Data Scrubbing to import into SQL Server databases and tables

Utilized HASHBYTES (MD5) for data migration to add creation dates or modified dates to data tables to identify new records or modified data recordsets

Installed and used TFS 2012 for version control of SSRS reports and ASP.Net projects, and project planning

Monitored SSRS Report usage logs daily using custom SSRS report to identify and track usage and errors

Help Desk Support for 20+ employees installing GotoAssist and TeamViewer, tracking tickets in Sharepoint

Setup Email and New Workstations with Office 365 and managed inventory on Sharepoint

Wiped old workstations and reinstalled Windows and Office and GotoAssist

Installed Shareplus on I-Pads, walked users over phone to fix problems with remotes offices installing Shareplus

January 2013 – June 2013

Wellsfargo, Payment Card

Contract Programmer

Working with Classic ASP in Agile Development

Power Builder

SQL Server Stored Procedures

Team Foundation Services

March 2012 – December 2012

Houston Food Bank Houston, Texas

Systems Data Analyst / Database Administrator IT Contractor (SNI)

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 (Share Your Holiday)

Help Desk support over phone or at users workstation when needed

April 2008 – March 2012

Lookout Services Bellaire, Texas

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

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. Training 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

Help Desk support via phone calls with end users to use custom software (2 or 3 calls per week)

September 2007 – October 2007

Boring Specialties Houston, Texas

Sub Contract Programmer for Robert Shields Associates, League City, TX

Three week project debugging and fixing in house Visual Basic application, and SQL Server Reporting Services (SSRS)

May 2007 – July 2007

Noble Drilling Corp. Sugar Land, Texas

Sub Contract Programmer for Entersys Group, Houston TX

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

November 2006 – March 2007

University of Texas Medical Branch Galveston, TX

Contract Programmer through Robert Shields Associates, League City, TX

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

September 2000 to June 2006

Affiliated HealthCare Inc Houston, TX

Programmer Analyst III (ie Lead/Senior Programmer) and SQL Server Database Administrator

SQL Server TSQL Programmer created Affiliated Healthcare’s Repricing System creating Databases, Tables, Stored Procedures, Triggers, Views, ASP Webpages in an IIS 5.0 web servers and SQL Server 7 and SQL Server 2000 which was used as the primary business product and revenue

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

January 1999 to April 2000

Systems Development Group Utica, New York

VB Programmer, IIS Administrator, ASP Developer

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

January 1998 to January 1999

AFSA Data Corporation Utica New York

Student Loan Adjuster

August 1987 to August 1995

United HealthCare (formerly MetLife Group Health and MetraHealth) Utica, NY

Benefits Claims Analyst / DRG Specialist/Desktop Help Support

Adjusted Medical Claims based on Group contracts guidelines and to insure proper payments in a timely manner. I worked on HICFA 1500 professional forms, UB-92 hospital forms and DRG per diem claims

Written correspondence to medical providers to request additional information in order to process medical claims according to the contract guidelines

Written correspondence to the Insured explaining how medical claims were processed according to the contract guidelines

Customer Service Representative answering questions from Insured and medical providers concerning the processing of their claims

Provided PC Help desk support

Education

Bachelor of Science in Computer Information Systems/Computer Science

State University of New York Institute of Technology; Utica, New York

Associate of Applied Science in Computer Information Systems/Computer Science

Mohawk Valley Community College; Utica, New York

Mohawk Valley Community College, Utica, New York

Independent Study in Computer Science building fully functional 6502 Emulator in VAX C used for teaching 6502 Assembly Language to computer science students which included a full featured visual debugger allowing the user to visualize the instructions being executed and allowing for single stepping of 6502 instructions, setting break points, auto run instructions.

Certifications

Currently working towards CISCO certification in Network Administration, and CISP certification

Contact this candidate