Brad G. Skidmore
Denver Colorado
303-***-**** https://www.linkedin.com/in/bradskidmore/ ****@******.***
Software Developer
BIDS SSIS ETL Development IT Application Architect Remote Contractor Report Analyst
Effective Results Oriented Super Achiever
Specialties:
.Net Visual Studio TFS BIDS (SSIS) AJAX JSON SOAP REST MVC KO SSO SAML 2.0 OnBase
Languages Used:
C# ASP.Net ASP JavaScript jQuery VBScript VB6 Classic VB.Net XML XSL SQL TSQL PSQL DB2
Summary of Qualifications
10+ years ETL BIDS SSIS
10+ years SQL Server Database Design
10+ years Information Technology
10+ years Software Engineering
10+ years OOP
10+ years Microsoft Platform
10+ years C#
10+ years VB6 VBScript
5+ years .Net Web Forms
5+ years JavaScript and jQuery
1+ years .Net MVC KO
1+ years AWS SNS SQS
Professional Experience
(and select accomplishments)
Trinity Health
Remote Software Engineer MSOW Scripting, S3 September 2019 to February 2020
Supported MSOW Physicians Credentials Web sites
Migrated and overhauled legacy Windows Tasks, Batch, and VBScripts
oAmeliorated bloated, broken, and dead code (Consolidated over 17K files down to 600)
Processed 25 Lifecycle Win Server upgrades, maintenance, and configuration
oVisio Diagraming SSL TLS, and Systems Analysis
Supported numerous ETL requests for Oracle 11g
oCreated Stored Procedures
oPerformance tuning
Tools and technology used
oIIS VB Script Batch Files Access 4.0 Jet Blat Email
oOracle 11.2.0 12.2.0 SQL Plus to CSV FTP
MicroStar Logistics, Denver, Colorado August 2018 to August 2019
Software Consultant, Spotlight Inc. LetITShine
Sole Engineer for the Pallet QR-Code Labeler for M*’s Flagship Keg processing warehouse in Eagle Pass TX
oSystem supports 1 million+ kegs processed each year for Constellation Brand (Corona, Modelo, etc.)
oSystem supports automatic COMAC SATO Printers and standalone SATO Printers.
oSystem includes: NiceLabel middleware MS SQL Server 2016 MVC Web (Entity framework)
Sole Engineer for M*’s TAP Print Queue System
oC# Windows Service AWS SQS SNS JSON
Supported numerous ETL requests Address scrubbing Performance tuning ASP VBScript maintenance.
Tools and technology used
oSQL Server 2016 SSRS TSQL MySQL SmartyStreets API
oC# VBA VB Script HTML JavaScript
Station Casinos, Las Vegas, Nevada May 2018 to August 2018
Software Consultant, VertiSystem
System Analysis and defect mitigation for Station Casinos Player Tracking Software
The Contract was originally scheduled for 6 months but was finished successfully in under 3.
oThe inhouse team at Station Casinos was unable to isolate corruption being experienced in production data for over 2 years and had several outside contracting firms investigate the issues.
oWithin the first couple weeks, I reproduced the issues in their development environments under 2 different scenarios.
oNot only did I ameliorate the original issue, but I also enhanced their logging (added configurable verbose logging), enhanced and repaired existing error handling, fixed an application hanging issue, repaired parameter data typing sizing, as well as eliminated aesthetic artifacts plaguing the system.
Station Casinos was facing heavy fines under Title31 audits and penalties. However today…
oStation Casinos is in full compliance
o Station Casinos has a stable application which outperforms expectations.
oTools and technology used: VB6 SQL Server 2016 TSQL DB2 iSeries
National Flood Services AON, Kalispell, Montana September 2015 to April 2018
Remote Software Contractor, MBO Partners
Supported multiple simultaneous projects e.g. Regulatory, Sustainment, GAPS, Endorsements, Data Conversion
Completed project feature enhancements ahead of NFIP mandatory regulatory scheduled requirements
Identified and repaired multiple business level affecting defects for the Sustainment Project
Performed countless production data fixes and ad hoc reporting and analysis
Performed multiple KT sessions for the edification of both senior and junior software developers
Added and enhanced multiple critical features for the GAPS project, OnBase
Implemented Endorsement Project Business Rules Engine C# jQuery JSON XML (https://codeeffects.com/)
Completed multiple overlapping mission critical data conversions affecting complex security using BIDS SSIS
Added IdP Initiated SAML2.0 SSO (Single Sign On) Clients https://www.componentpro.com/products/saml
National Flood Services Stone River AON, Kalispell, Montana July 2010 – April 2015
Remote IT Application Architect
Supported multiple simultaneous projects e.g. FloodPro Classic, Regulatory, Sustainment, Flood Connect
Added multiple features to the legacy application e.g. Document upload, multiple reporting features and did KT to help bridge all features from Legacy application into the latest FloodPro application.
Completed project feature enhancements ahead of NFIP mandatory regulatory scheduled requirements
Identified and repaired multiple business level affecting code defects for the Sustainment Project
Developed VB6 and VB.Net maintenance work for the Kansas Flood Connect team acquired by NFS
Implemented Idp Initiated SAML2.0 SSO (Single Sign On) Using https://www.componentpro.com/products/saml
oSee https://blogs.oracle.com/dcarru/sp-vs-idp-initiated-sso reference Idp Initiated SSO
oIdp Farmers Insurance (Fire Insurance Exchange) to Sp Consumer National Flood Services
oIdp Philadelphia Insurance Companies to Sp Consumer National Flood Services
National Flood Services Fiserv Stone River, Kalispell, Montana November 2006 – July 2010
Remote Software Contractor, TEKSystems
Supported FloodPro Classic legacy web application.
Performed countless production data fixes and ad hoc reporting and analysis
Pioneered and implemented BIDS SSIS to be used as the standard ETL technology at National Flood Services.
Additional Experience
AlphaTRAC (www.alphatrac.com), Westminster, CO March 2006 – September 2006
Software Contractor, TEKSystems
VB6 and ETL BIDS SSIS
State of Montana Office Of Public Instruction, Helena, MT January 2006 – February 2006
Software Contractor, TEKSystems
Eberl Claims Service Inc, Westminster, CO November 2001 – November 2005
Software Contractor, TEKSystems
Catastrophe Claims Management and E-Billing
Cold Fusion MX HTML JavaScript VB6 COM VB services via NTSVC.ocx and SQL Server 2000
AT&T Broadband Comcast, Denver, CO November 2000 – November 2001
VB Developer Contractor, XL Sure Software (Extended support until Nov 2006)
Created ART (Accurate Retention Tracking) track AT&T's Cable Services Retention Team productivity
Developed Client Server Software to track Customer Retention calls
Developed Active X Objects Active Reports
Product Development Corporation, Denver, CO August 2000 – November 2000
Software Contractor, TEKSystems
Developed Active X Objects Active Reports and Crystal Reports VB6 maintenance
FRx Software, Englewood, CO November 1999 – July 2000
VB Developer
Resolved over 100 software modification requests and enhancements. VB (4,5,6)
Amerinet Mortgage Services, Englewood, CO March 1999 – October 1999
VB Developer
MCI WorldCom, Highlands Ranch, CO November 1998 – March 1999
Report Analyst
TeleTech, Thornton, CO March 1996 – September 1998
Supervisor
Managed agent staffing levels
Supervised Command Center Coordinators
Developed Access databases and Excel spreadsheets enhanced with VBA
United States Air Force, X1N355C November 1989 – October 1995
Aircrew Hebrew Mid-East Cryptologic Linguist, Senior Airman
Airborne transcriber of Hebrew voice communications to English transcripts
Operated intelligence collection systems
Maintained order of battle databases
Compiled critical intelligence reports for the National Security Agency
Education
Defense Language Institute - Associate of Arts (AA), Hebrew
Mastering MS Visual Basic 6.0 Fundamentals - Microsoft Certification
Ridgefield High School Washington- High School Diploma