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 PLC’s, 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, JSP’s, EJB’s, Arduino Microcontrollers, PC/104, Rasberry Pi, ucLinux, FPGA’s, Omron PLC’s, Modicon PLC’s, 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.