Summary
Overview
Work History
Education
Skills
Certification
Websites
Timeline
Generic

Scott Dugger

Englewood,CO

Summary

Detail-oriented IT specialist with over two years of experience in software configuration and implementation. Expertise in transforming complex healthcare data into accurate internal formats through SQL-based validation and error resolution, successfully supporting Pacific Source Health Plans in adding over 140,000 new clients. Proficient in troubleshooting healthcare data integration issues and collaborating with clients to deliver tailored solutions, resulting in a 30%+ reduction in waste for BD Healthcare manufacturing. Hands-on experience with SQL, Oracle, and MS Access, facilitating financial reorganization and business expansion for Johnson Controls.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Disgner/Operator/Programmer Analyst

My Website
Denver, Colorado
01.2013 - Current
  • Spearhead the design, evaluation, debugging, and roll-out of a website that enables any# of artists to distribute artwork at scale via PHP, D3.js, JQUERY, JavaScript, MySQL, Rest API, and other platforms
  • I designed and integrated a single user interface (UI) and user experience (UX) for mobile and desktop utilization, leading all technical design and functionality testing
  • Assess and utilize flexible technologies to promote the on-time and within-budget performance of all website architecture, requirements gathering, and planning, facilitating 100% in sustained growth
  • Conducting regular architectural reviews, providing valuable insights to enhance system robustness

Utilized: LAMP Stack, Mysql, SQL, Database Design, Architecture, PHP, D3.js, JavaScript, JQuery, Xquery, Xpath, API, UX, UI Design, NoSql API, Restful APIs, CSS, JavaScript Frameworks, NoSQL Database, OpentAI, ChatGPT

Consultant/Contractor

Self Employed Various Clients
Denver, CO
01.2008 - Current
  • Implemented Acumatica software, establishing formulas, BOM, QC, QA, and SOPs at Belmar Pharma Manufacturing.
  • Integrated ConnexOne with data warehouse through ETL processes for medical data.
  • Restored databases and interfaces within 30 hours after a 10-month downtime at UpWork.
  • Developed AI/ML software that enhanced Business Process Management, boosting revenue by 50% at UNO, Omaha, NE.
  • Created SQL API data mining calculators that increased sales by 20 to 30% at West Telecom Omaha, NE.
  • Executed business analysis for Crystal Reports using Oracle database PLSQL, reducing waste and enhancing profit margins at BD Columbus, Nebraska.
  • Contributed to financial reorganization by managing documentation / Application during database migration from Oracle to Microsoft systems at Johnson Controls.
  • Developed ELT/ETL/DWH Provider Data Management integration tool architecture, adding over 145,000 providers at Pacific Source, Eugene, OR.
  • Developed Architecture and software integration tool to track cross-platform software response times of FACETS and other various software-developed solutions per specification at Trizetto
  • Provided written and verbal reason for architecture failure for the identity management software platform at Trizetto – Denver, CO
  • Using a combination of ASP.NET, VB.NET, Win Forms, VBA, Excel, MS Project within a DLL framework extracted information to guide project managers for cost basis analysis, Production Support at IBM
  • Allowed for cross-language support to deliver tasks in other languages. So the software could be used in any country, Agile, Waterfall, at IBM

Contractor

Qmetrics – Remote- Healthcare
San Diego, California
03.2024 - 10.2024

• Data warehouse design implementation and integration of medical survey information from several different sources.

• Documented, and provided visual aids for training purposes.

• Interface training, design, and implementation with 3rdparty vendors.

• Utilizing: C#, PHP, SQL, My SQL, POSTGRE SQL, .net, MySql, XAMPP, ConnexOne, Files, Documentation, Storyboarding, Healthcare Provider Management

Business Analyst

MSI Global
Hampton, NH
10.2021 - 11.2023
  • Designed and validated ETLs, including but not limited to an ETL that supported a new data warehouse architecture, enabling the cleaning/organization of raw data and preparation for cloud storage and business analytics
  • Assessed the overall architecture of a third-party software before purchase to ensure the software's effectiveness and relevance for the organization, communicating evidence-based recommendations
  • Mentored 3 professionals concerning T-SQL, API implementation, OOP concepts, and distributing information in an accessible manner, in addition to addressing and resolving misunderstandings
  • Debugged APIs that were currently in use, and led the architecture of APIs to maximize the seamless extraction of data and its distribution across multiple parties.

Utilized: C#, T-SQL, SQL Server, ASP.NET, VB.NET Service Engine, API, Restful API, web services, Business Analysis

Education

Bachelor of Science - Computer Information Systems

Colorado State University, Pueblo
Colorado
05-2000

Skills

  • PHP development
  • C#
  • ASPNET
  • API integration
  • Database design
  • ETL processes
  • UI/UX design
  • Data analysis
  • Project management
  • Systems architecture
  • Software testing
  • Problem solving
  • Communication skills
  • Mentoring others
  • Documentation practices
  • Stakeholder engagement
  • Performance optimization
  • Data entry
  • Analytical thinking
  • Problem-solving
  • Issue resolution
  • Teamwork and collaboration
  • JavaScript frameworks
  • Restful APIs
  • UX/UI design
  • Data integration
  • Api implementation
  • System architecture
  • Quality assurance
  • Effective communication
  • C programming
  • API development
  • UX design
  • Database management
  • Agile methodology
  • Business analysis
  • System integration
  • Project coordination
  • Technical documentation
  • Team collaboration
  • Object-oriented programming
  • Software architecture design
  • Proficient in HTML
  • Integration testing
  • Data structures
  • Business intelligence analysis
  • Requirements gathering
  • Functional analysis
  • Relational databases
  • Dashboard design
  • Continuous integration
  • User requirements
  • Software development
  • SQL expert
  • API design
  • Front-end frameworks
  • Microsoft ASPNET
  • System design
  • Version control
  • IT project coordination
  • Ad-hoc report integration
  • Application architecture
  • User acceptance testing
  • Exception handling
  • Code reviewing
  • Web architecture
  • Website architecture
  • Proof of concept
  • Business process improvement
  • RESTful API integration
  • Project management experience
  • In-depth SQL expertise
  • Test-driven development
  • Proficient Git usage
  • Responsive web design
  • Solid MVC architecture
  • CSS3 proficiency
  • API development expertise
  • Expert PHP development
  • Strong HTML5 skills
  • DevOps principles
  • Continuous deployment
  • NoSQL databases
  • Software best practices
  • Application development
  • Nodejs experience

Certification

Licensed Long-Term Healthcare Administrator, State of Arkansas/Nationally Licensed

Timeline

Contractor

Qmetrics – Remote- Healthcare
03.2024 - 10.2024

Business Analyst

MSI Global
10.2021 - 11.2023

Disgner/Operator/Programmer Analyst

My Website
01.2013 - Current

Consultant/Contractor

Self Employed Various Clients
01.2008 - Current

Bachelor of Science - Computer Information Systems

Colorado State University, Pueblo