Sql Server Software Engineer

Daniel Clark

Moore, Idaho

******@******.*** l

Cell 206-***-****

Web and Database developer in PHP, ColdFusion, SQL Server, mySQL and ETL.

Skills: SQL Server, T-SQL, SRSS, SSIS, mySQL, Oracle PL/SQL, DB2, SQLite, Access, Drupal, WordPress, noSQL, PHP, ColdFusion, ETL, JavaScript, JQuery, HTML5, CSS3, XML, AJAX, SVN, Subversion, VSS, Git, FreeNAS

Professional Experience

Oct 2022 - Oct 2023, Jim's RV Park (Remote Contract)

PHP and DBA/mySQL Developer

Created RV reservation application.

Created customer Check-in with 2-clicks.

Added customer Check-in with updated ETA (e.g. customer running late)

Created print and emailed Daily, Weekly and Monthly management reports

Added pricing for 1, 3, 7, and 30 day stays, also discounts for veterans and seniors

Created search options by customer, RV space, license plate and From/To dates

Added history logging for all tables with search capabilities

Updated mySQL database to latest version

Technologies: PHP, mySQL, HTML5, CSS3, JavaScript, ETL, Eclipse

Mar 2022 - Sept 2022, Northcoast Group Health Care (Remote Contract)

SQL Server Developer

Created Doctor and Insurance Carrier denial reports

Created Open Accounts Receivable reports and ran them weekly for management

Created Doctor referral reports and sent them weekly to management

Created SQL Server functions to help with developing new reports

Technologies: Windows 10, SQL Server 2019, SSRS, SSIS, HTML5, CSS3, T-SQL, ETL, Eclipse, Bitbucket

Jan 2017 – Feb 2022, InnovAsian Cuisine (Remote/On-site Contract)

PHP and Database Developer

Created web application to move invoice batches in Dynamics Great Plains.

Created EDI application to download invoices from Dot Foods to SQL Server database.

Created export scripts in Access database with broker data and interface to Core Commissions application.

Using PHPExcel created Excel reports for Brokers and Salespersons.

Exported weekly and monthly accounting sales data into Discovery sales app.

Updated Nutrition product labels for 2018 requirements.

Created PHP web application to report brokers their customers and commission rates.

Technologies: Windows 10, SQL Server 2011, SSRS, SSIS, PHP, HTML5, CSS3, XML, EDI, ETL, JavaScript, T-SQL, Dynamics Great Plains, VBA, Access.

Dec 2012 – Nov 2016, Tacoma Housing Authority (Remote Contract to Permanent)

PHP and ColdFusion Developer

Updated major changes to our HUD Move To Work application, with new tenant rules and calculations.

Created web based ACH email application to notify 1,landlords of payments. (over 1,200 landlords)

Major upgrades to Reasonable Accommodations application making it more robust and user friendly.

Created a client Transfer List application tracking system for tenant moves.

Created online employee Performance Evaluation application with logging and Active Directory validation.

Created program to track Family Self Sufficiency client benefits.

Created client Wait List look-ups on the public website.

Created online Inventory Management System for tracking inventory and restocking.

Interfaced online Public Housing application using XML API to SQL Server database and uploading to our customer client tracking database.

Daily database backups, patches and upgrades as needed.

Technologies: SQL Server 2008, SSRS, SSIS, PHP, mySQL, noSQL, HTML5, CSS3, XML, JavaScript, ColdFusion 10, Drupal, Active Directory and LDAP, T-SQL, ETL

Oct 2011 – Sept 2012, Bell HTML (Remote Contract)

Web and Database Developer

Designer and developer of customer websites using WordPress and mySQL.

Modified PHP WordPress plugins per customers request.

Technologies: WordPress, mySQL, PHP, JavaScript, JQuery, CSS, XML

May 2011 – Oct 2011, Boeing (Remote Contract)

Web and Database Developer

Developed new features on Boeing contract supplier database.

Added new features for supplier email distribution lists.

Interfaced six legacy supplier applications across the country to main ESCAN supplier application.

Technologies: SQL Server 2005/2008, T-SQL, Oracle, ETL, ColdFusion 8, JQuery, JavaScript, CSS, XML, Dreamweaver

Nov 2010 – May 2011, Clocktower Media (Contract)

Web and Database Developer

Team member on an Idaho College medical web application for administrators and researchers reporting their research and grant information each year.

Developed wholesale seafood company shopping cart and custom CMS.

Technologies: PHP, ColdFusion 9, mySQL, JQuery, JavaScript, AJAX, CSS

May 2010 – Sept 2010, Hacker Group (Contract)

Database Developer

Vendor validation and proofing of sample mailings, with over mailed daily.

Developed T-SQL validation, suppression scripts for AT&T and Comcast mailings.

Created T-SQL and stored procedures for validation and reporting.

Exported mailing databases and transformed them into new SQL Server schema.

Technologies: SQL Server 2008, SSIS, SSRS, T-SQL, Stored Procedures, ETL

June 2009 – April 2010, AT&T Wireless (Contract)

Web and Database Developer

Lead developer for bug and content hot-fixes installed weekly.

Developer of new enhancements for Cellular phone ticketing system with 6,000 users.

Complete database redesign using ColdFusion Com objects and SQL Server stored procedures.

Exported all the data from existing database schema and loaded into new schema.

Technologies: SQL Server 2005, T-SQL, ColdFusion 8, IIS, SSIS, ETL, Eclipse, SVN, JavaScript, HTML, CSS, AJAX

Contact this candidate