Don Wyatt

Orem, UT 84058

don@donwyatt.com

 

801-759-0897

Website: donwyatt.com

 

 

PROFESSIONAL SUMMARY

Results-driven professional with a deep passion for SQL Server and expertise in T-SQL stored procedures, SSIS, SSRS, SSMS, SSAS integrations, and linked servers. Proficient in navigating and optimizing a Linux environment. Highly skilled in C# programming, leveraging it to develop efficient solutions. Known for effectively translating complex business requirements into robust technical solutions. Strong problem-solving abilities, meticulous attention to detail, and a commitment to delivering high-quality results.

 

SKILLS

Expert in:

        SQL, C#, Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microsoft Power Query, Microsoft Power BI, Data Analysis, Salesforce ODBC Connector, Shopify ODBC Connector, HubSpot ODBC Connector, Tableau, Crystal reports, MVC, XAML, Perl, FreeBSD, Debian

Intermediate in:

        MySQL, MariaDB, HTML/CSS, JavaScript, jQuery, Bootstrap, PHP, Python, Pandas, scikit-learn, VMware vSphere, First Aid, basic medical, HIPPA , Alan Bradley PLCs, Adam.Net, Cold Fusion CFML, MVVM, bash, tcsh, C, Windows Server, RedHat, Gentoo, Ubuntu, Knoppix. INFOR ION

Basic knowledge of:

        QlikView, Snowflake, AWS Glue, Oracle, PostgreSQL, SQLite, conversational Spanish, Java, JSPs, EJBs, Arduino Microcontrollers, PC/104, Rasberry Pi, ucLinux, FPGAs, Omron PLCs, Modicon PLCs, Ruby, sh, ksh, COBOL, Pascal, BASIC, Slackware, NCR Unix

 

EXPERIENCE

Managing Software Engineer Little Giant Ladder Systems

April 2015 June 2023

        Demonstrated strong leadership skills and effective communication by leading and managing all aspects of database applications, integrations, and Data Analysis for the organization, ensuring optimal performance, reliability, and security.

        Played a primary role in the successful digital transformation of the company's online presence, transitioning from a basic WooCommerce website with limited ordering capabilities to a fully developed Shopify website. Orchestrated a custom ERP integration with seamless integration with Microsoft SQL Server, Shopify, Salesforce, and HubSpot, enabling enhanced functionality and streamlined operations.

        Orchestrated the development and implementation of reporting solutions, leveraging SQL Server, T-SQL stored procedures, SSIS, SSRS, and SSAS integrations. Notably, led the successful development and implementation of a SSAS OLAP Data Warehouse, managing 3 million sales order transactions and 17 million inventory transactions.

        Led a comprehensive initiative to overhaul the pricing systems, implementing a streamlined SSIS/Excel integration solution to efficiently manage approximately 25 distinct price groups, each consisting of 50 to 60 products.

        Spearheaded the extension of the Sage 500 ERP system through custom application development, enhancing functionality and meeting business needs.

        Developed and implemented a custom integration between Sage 500 ERP and Salesforce, enabling seamless synchronization of orders, pricing, registration, and customer history for a substantial customer base of approximately 500,000 users.

        Developed a predictive shipping time system using python, scikit-learn and pandas. Leveraged data from our ERP system, including inventory information, supply chain data, and lead time, to accurately forecast product shipping dates. This system improved operational efficiency, allowing for better resource allocation and enhanced customer satisfaction.

        Oversaw the full software development lifecycle, from requirements gathering and design to coding, testing, and deployment.

        Demonstrated exceptional teamwork by mentoring and coaching a team of 5 members, fostering their professional growth and development while ensuring the delivery of high-quality results.

        Utilized strong communication skills to collaborate with stakeholders to gather requirements, analyze business processes, and propose technology-driven solutions to drive operational efficiency and productivity.

 

 

Senior Software Engineer - Martin Garage Door Manufacturing

March 2013 April 2015

        Managed reporting needs for the company's Infor CRM and ERP system.

        Developed comprehensive sales analysis reports, enabling targeted marketing strategies based on trends and statistics, resulting in improved effectiveness.

        Successfully orchestrated the workflow and migration of a complex pricing structure with billions of separate pricing possibilities, ensuring smooth transition and accuracy.

        Implemented streamlined processes to migrate from Excel sheets and Access databases to a SQL Server-based, normalized system, enhancing data integrity and accessibility.

        Developed robust reporting and testing mechanisms for pricing management, facilitating effective decision-making and pricing optimization.

        Contributed to a project team responsible for bringing a "design online" system to prominent retailers like Home Depot, DirectBuy, and Lowes, showcased at homedepotgaragedoors.com.

        Implemented workflow management within the Infor ION middleware system, synchronizing customer order history, accounting, and related data for a customer base of 58,000.

 

Software Developer - Adams Land and Cattle

06/2008 04/2013

        Designed, developed, and maintained a multi-tier multi-mode cattle sorting system capable of handling drug treatment records, drug recommendations, and weight gain estimations for 2500 animals per day. Utilized C# programming language with a WPF front end.

        Developed integration services and migration of data for several enterprise level database systems, MAS 500 (Accounting), Optimum HR, Empowertime (Human

        Resources), SmartSoft (Grain Handling), Daily Gains Pro (Cattle Management), and a proprietary in house UNIX/COBOL based cattle management system

        Worked through and developed custom integration with the MAS 500 accounting system to automate the processing of payment from the packer, as well as payments to the grain suppliers

        Integrated between the SmartSoft Grain handling system and the MAS 500 accounting system

        Developed customized reporting interface in Crystal Reports in order to assist the Human Resources department managing their 160+ employee files

        Contributed to the development of an ASP.NET based website for reporting on cattle management statistics, providing stakeholders with valuable insights.

        Developed an in-house support ticket management system tailored to the specific needs of the Adams Land and Cattle Management Team, streamlining issue tracking and resolution processes.

 

UNIX Support Technician I, II, and Technical Support Manager Verio Inc.

June 2003 April 2008

        Wrote PERL, or LINUX command line scripts to solve problems for the customer

        Supported and trained users on the installation of open source and proprietary software programs on the FreeBSD, and Solaris UNIX platforms

        Managed administration maintenance of thousands of FreeBSD servers

        Supported customer based interactive web solutions, involving client and server side scripting and database interaction

        Maintained technical proficiency to act as a 3rd level support, in addition to managing, training, monitoring, and coaching a team of 10 support technicians.

 

Teaching Assistant Brigham Young University

November 2001 April 2003

        Web Systems IT (210A, B), Operating Systems (IT 344), Database Systems (IT 350)

        Directed and trained 45 students in the development of interactive web content

        Taught concepts that included the following: XHTML, XML, Java 2, JavaScript,

        DOM, JSP, PERL, CGI, Apache, LINUX, UNIX, and DBI

        Managed a small network of approximately 50 multi-OS computers.

        Directed and trained students in the exploration and development of programs and utilities in the LINUX / UNIX environment

        Taught concepts that included the following: Programming in C/C++/ASM/Script

        Directed and trained students in the development of programs used to interface and interact with MySQL, Postgres, and Microsoft SQL Server

 

EDUCATION

        Bachelor of Science in Information Technology, Brigham Young University, Provo Utah

        Associates of applied science in Electrical Automation and Robotics Technology, Utah Valley University, Orem Utah

        EMT Basic, Mid Plains Community College, Kearney Nebraska

ADDITIONAL INFORMATION

        Actively support Bikers Against Child Abuse (B.A.C.A), an organization dedicated to empowering and protecting children who have experienced abuse.

        Currently enhancing conversational Spanish language skills to facilitate effective communication in diverse professional environments.