Consultant

Scott Dugger

*** - *** - **** ***********@*****.*** – location, US

Professional Summary

I have over 10 years working as a combination of a Systems Analyst and a Business Systems Analyst(SA/BSA). I bring a unique blend of practical business analysis and systems analysis expertise, allowing me to bridge the gap between technical teams and stakeholders effectively. Examples of this can be found throughout my resume. With Johnson Controls I was brought in to do Systems Analysis to flow chart a source of truth for platform migration and perform the needed technical support to integrate three separate companies underneath the Johnson Controls umbrella. This would solidify the companies so they could act independently, and together for the betterment of the system and business operations. While mapping, flowcharting, creating/maintaining comprehensive documentation, solving backlogged requests, and answering technical questions about the billion-dollar-a-year system I was responsible for, I had the chance to meet with business stakeholders to understand why the business was underperforming. The simple "why" answer was that sales reps had to sell the same labor, and product pricing scheme across the board. It did not matter if the project was occurring in rural South Carolina or California all items had to be priced the same. I took this knowledge back to the system side and built an innovative enhancement that would allow them to modify the pricing schemes to match the sales representative's needs (who). This innovative enhancement resolved the "what" and resulted in a 200% increase in projects priced and sold.

While doing healthcare research with UNO I had the opportunity to spend 8 years driving AI/ML innovative technology solutions to automate and enhance operational efficiency, and patient safety. This made me learn the importance of the Who, the What, and the Why. The AI/ML tool taught the new staff how to meet each patient's unique needs and prompt them to the correct care for that patient, based on what the software had learned from previous nurses. In healthcare, you have consistent staff turnover. This system was innovated to not only overcome "why" the loss of knowledge was occurring but also to resolve "what" needed to be done, and "who" would benefit. This AI/ML-driven software ensured each nursing note taken was billable and consistent with the treatment plan. This point-and-click AI/ML automated interface reduced nursing charting from hours to minutes giving nurses more time for patient care.

I have worked on all sizes of projects from small to large enterprise projects. I have taken the responsibility for managing product backlogged items on small projects, such as with VISA where I resolved over 50 Pre-Paid QA backlogged reports on terabyte databases. I performed a similar task with Pacific Source Health Plans where I QA'd their databases bringing them into government compliance. One Enterprise-level application I innovated a solution for was BD. BD manufacturing machines were failing to produce good products about 50% of the time. I collaborated with engineers, manufacturing floor champions, IT teams, and stakeholders to identify a reporting platform that would allow engineers to quickly find failing machines. The ability to respond quickly to failing machines reduced waste from 50% to 1%, increasing profit margins by millions per month. I take bug fixes as an opportunity to document how to write code more efficiently. My role with Pacific Source Health Plans involved documenting, verifying, and improving new and existing requirements, while also facilitating clear communication between stakeholders and development teams. Improving upon existing requirements allowed Pacific Source to add another 140,000+ clients, and added 2600+ new jobs. In my career, I have learned how to gain user acceptance, by bringing them into the creation process. With UNO, and BD I worked side by side with nurses, and engineers to learn, and understand what, why, and how they do their jobs. This type of attitude works wonderfully with post-production support issues because you have already established rapport with end users. After all, their consistent feedback was put into the product.

As you can see by reading the above my Key abilities are:

Conducting detailed business analysis to gather and translate requirements into actionable technical specifications for AI-driven or other platform solutions.

Collaborating with engineers, data scientists, and IT teams to design and optimize all types of implementations including AI that enhance business processes and automation.

Analyzing data flows and operational processes to identify opportunities for AI and other integrations to find process improvements to recommend.

Write user stories in the 3W (the who, the what, and the why) format and document Acceptance Criteria.

Creating and maintaining comprehensive documentation, such as data mappings, process flows, and requirements documents.

Working closely with multiple agencies to align business processes, system requirements, and integration needs.

Providing guidance and adhering to approved company practices in documentation, project management, and change processes.

My qualifications include the ability to understand various tools AI or otherwise to reach business and system goals. I am skilled in workflow analysis, integrations, APIs, and ERP system design. Additionally, I am proficient in managing user stories, flow diagrams, and process improvements.

With a collaborative approach and a commitment to delivering impactful results, I ensure that I contribute to the success of projects and drive meaningful advancements in technology and business processes.

Professional Experience

Various Clients Remote / Onsight

Contractor/Systems Analyst / Technical Business Analyst /Architect/Production Support Contractor 2008 – Present

•Implementation of ConnexOne, Data warehouse integration ETL Flat Files with medical data information. Visual Documentation, and training of the system. Utilizing: Gathering Business Technical Requirements, SaaS, C#, PHP, MySql, SQL, T-SQL, PostgreSQL, DBeaver, Connex, XAMPP, SQL Server, HTML, CSS. Healthcare, Data Mapping- Qmetrics

•Led the restoration of DBs and interface through root cause analysis in 30 hours, ending a 10-month downtime period through comprehensive data analysis, requirements gathering, documentation, and strategic planning at UpWork

•AI / ML, software development to improve Business Process Management and Revenue Cycle Management. Increased revenue by 50% in some cases and reduced data entry from hours to minutes Scrum Master at UNO, Omaha, NE – Achieved Long-term Term Care Administrators License

•Developed Client-side SQL API Data Mining calculators using VBScript & JavaScript that increased sales by 20 - 30% and bonus rates by 2 –4%. Reduced information finding to milliseconds at West Telecom Omaha, NE

•Developed API Data Mining techniques that allowed quantified summary of information in milliseconds and charts and graphs at West Telecom Omaha, NE

•Performed Business Analyst / Scrum Master work to develop Crystal Reports utilizing an Oracle database PLSql with a Toad interface. The Crystal report reduced waste from 50% to 1%. Increased Profit margins of as much as 1 million per month per department utilizing the report. Documented flow of information at BD Columbus, Nebraska

•Added 7 new product lines which added 1000 new jobs at BD Columbus, Nebraska

•I was responsible for about 1/3rd of the company’s income, during a financial reorganization / ELT/ETL/DWH Data Mapping, Data Migration, documentation, and training. Performed Business Analyst work to allow for flexible profit margin increases by allowing labor margins to be adjusted uniquely for each sales representative, which attracted better sales staff and increased profit margins at Remote - Johnson Controls

•Developed an ELT/ETL/DWH Provider Data Management integration tool Architecture was provided to add 145,000+ providers from the state of Washington at Pacific Source, Eugene, OR

•Provider ELT/ETL/DWH Data Management / Integration tool development and integration with FACETS was provided to manage the data for providers creating 2,600 new jobs at Pacific Source - Eugene, OR

•SQL Architecture, training, and documentation provided to resolve QA issues of the provider-patient database system. Utilizing T-SQL, EXCEL (Dynamo) at Pacific Source – Eugene, OR

•The life cycle of existing software was extended through architectural and software development 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

•Allowed for cross-language support to deliver tasks in other languages. So the software could be used in any country, Agile, Waterfall, at IBM

Golden Gate Software, SQL, SQL Server 2012 Database, firewalls, C#, .NET, education and training support of pre-paid solutions by resolving over 50 QA backlogged SQL reporting requests Large Datasets, troubleshooting and resolving Golden Gate Issues, Resolved Sever Network Issues, Production Support

Utilized: Excel, ETL, Golden Gate Software, SQL, SQL Server, C#, .NET, EAI, Agile, Waterfall,

Utilizing: Enterprise Level Software Design and Architecture of Identity Management System. Data Mapping, UX, UD, UI, FACETS, API integration, CI / CD, C#, JavaScript, JavaScript Frameworks, SQL, Access. Wrote ETL software to track the response time of system applications. XML, C#, ASP.NET, Visual Basic, COBOL, NoSQL, WinForms, Agile, Production, Support, Precise Documentation, clear concise explanation, ASP.NET, C#, WPF, XAML, POSTGRE SQL,WinForms, Sql Server, FACETS, architecture for mass transactions, Hot Keys, decreasing search time, using MVVM (MVC), WPF, C#, XAML, SQL, QA Database documentation SQL Server, TOAD, Oracle, C# VB.NET, VB 6.0., VBA, Production Support, Dynamo, QA SQL based reporting, Per specification development, PLSql, Oracle, Documentation, Training, Visual Aids, Access DB, TypeScript, ELT/ETL/DWH, Agile, Waterfall, ERP, Data Migration, Share Point, Story Boarding, XAMPP, MySQL, Classic ASP, VB Script, PHP 8, BA Skills, Excel, Office Suite, Problem Solving, Healthcare, Excel, Technical BA, Conflict Resolution, Translating business data needs into technical language, Scrum Master

Art Fox Club Remote

Architect, Programmer, Database Architect October 2013 - Present

•Spearhead the design, evaluation, debugging, and rollout of a website that enables any number of artists to distribute artwork at scale via PHP, D3.js, JQUERY, JavaScript, MySQL, Rest API, and other platforms

•Design and integrate 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, marketing, and delivery.

Utilized: Mysql, SQL, Database Design, Architecture, PHP, D3.js, XML, XPath. JavaScript, JQuery, API, UX, UI Design, NoSql API, Restful APIs, CSS, JavaScript Frameworks, SVG, Scrum Master

Qmetrics – Remote- Healthcare

Independent contractor Business Analyst, Data warehouse Architect and interface designer 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 3rd party vendors.

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

.

MSI Global Remote

Business Process Software Developer Analyst October 2021 - November 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 software

effectiveness and relevancy 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 architecture

Utilized: C#, T-SQL, SQL Server, ASP.NET, VB.NET Service Engine, API, Restful API, web services, and Spreadsheets, ELT/ETL/DWH, Snowflake

Miles Technologies Remote

Senior Software Contract Professional May 2021 - August 2021

•Documented Rest API architecture failures, evaluating failures present and performing root cause

•analysis/software modifications to troubleshoot and resolve issues quickly

•Led Windows service migration to console jobs, leading the creation and implementation of software

•culture of continuous learning and improvement

•projects within scope without sacrificing quality assurance in service delivery

Utilized: Restful API, MVVM, C#, VB.NET, ASP.NET, SQL, SQL Server, XML, Web Services, ELT/ETL/DWH, API

GAVS Technology Remote Union Pacific Railway

Project Lead December 2020 - April 2021

•Improved transparency and efficiency in bug tracking and resolution, documenting technical issues present and recommendations for resolution.

•Maximized resource allocation, planning, budgeting, and deliverable performance for 2 technical projects, promoting maximum transparency among project teams and stakeholders

•Recorded code and framework designs, confirming that technical documentation was accurate and complied with various regulations and standards

•Utilized the Fibonacci sequence to create and distribute project scope estimates, assessing and

evaluating project KPIs and goals to maximize operational excellence

•Oversaw 5 person project teams.

Utilized: XML, C#, ASP.NET, SQL Server, NoSQL, Unity, and spreadsheets when performing technical documentation, planning Scrum Master, and projects

Additional Experience

Lead Consultant PacificSource Health Care

Software Consultant Johnson Controls Manufacturing

Project Lead Architect Bullwinkles Rustic Lodge

Lead Software Consultant TEKsystems

Software Consultant Visa

Software Consultant GE-Healthcare

Software Consultant IBM Telecommute

Software Developer NFP

Project Lead Consultant ES&S Systems Software

Contract Project Lead Consultant Systems Analyst ATI

Business Analyst/Programmer/Data Integration BD Original Equipment Manufacturing

Programmer/Analyst West Telecommunications Management Group

Project Lead Consultant Web Developer BLM Technology

Project Lead Data Architect/Lead Programmer/Researcher UNO

Lead Developer/Architect University of Colorado Springs (UCCS), Biotech Center, University of Nebraska,

Omaha

Contractor Profit Systems

Lead Programmer/IT Support CCRI Casinos

Senior Programmer MCI-WorldCom

Core Competencies

Data Management, Data Warehouse. Revenue Generation, Solution Development, Quality Control and assurance, Requirements Gathering, Business Analysis, Network Support, HIPAA Compliance, Project Management, Production Support, Data Architecture, partnering, communication, negotiation, analysis of large, complex, or vague Business or technical problems, work effectively in a strong Customer service/team oriented environment, research, create, and document requirements, processes, technical specifications, manage to prioritize multiple assignments. develop, present, and effectively communicate ideas, teach and mentor others, ELT/ETL/DWH, Business Analyst, Debug, Code, Test, Maintain, Mentoring, Teaching, Creativity, Problem Solving

Technical Proficiencies

ASP.NET, Visual Basic 6.0, JavaScript, PHP 8, ETL Advanced, CSS3, RAZOR, PHP, Java, Android iOS, C#, MVC, TFS, WPF, XAML, WinForms, LINQ, VB.NET, AJAX, XML, XQUERY, XPATH, Strap.js, D3.js, API Web Services, JSON, Angular, React, Node, Agile, Waterfall, PL/SQL, T-SQL, COBOL, Excel Automation, VBA, JQUERY, AJAX.NET, ERP, C++, Linux, Crystal Reports, Visual Studio, Microsoft Access Database, GIT, SQL Server, MySQL, Pervasive SQL. NoSQL Databases, Stored Procedures, Oracle, SAP, MESi, FlexNet, Dynamo, High Use Applications, WordPress, Scrum, Automation, Machine Learning, OLAP, OLTP, Unity, DHTML, Data Island Reports, FACET Integration, XML NoSql, Cloud AWS. Angular

Education/Certifications

Bachelor of Science in Psychology & Criminal Justice, Southeast Missouri State University

Bachelor of Science in Computer Information Systems, University of Southern Colorado

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

Links

https://scottdugger.artfox.club/

https://wordpress.scottdugger.net/work-samples/

https://www.linkedin.com/in/scott-dugger-8b7906185/

Contact this candidate