Search Results

My Portfolio Various projects I have worked on over the years Architecture 2021, 2015 Cost Data Warehouse Cost Data Warehouse for manufacturing production insights to break out true elements of cost throughout multiple levels of subassembly production. Multiple versions exist. See details Information access 2017 Heritage Lakes Estates Condominium Assn. Website Modernized communication with homeowners in the community by posting key information and documents. Prior to launch of website, homeowners in the community would need to wait for an email response to answer basic questions and receive various documents. Go to website Personal 2023 LAS @ Work Feature A profile of my experiences in the LAS @ Work blog from the University of Illinois at Urbana-Champaign through my time as Principal Architect at Corterra Solutions. Read more about me! Go to website Process improvement 2019 New Start Dog Rescue Automation Saved 100's of manual hours generating a printable application form from a Google Forms response by implementing the GSuite tool called Autocrat. Autocrat allows for workflow automation in the GSuite. Particularly in this instance, used Autocrat to generate a printable document from a Forms response collected in Google Sheets. See details Information access 2016 Object Change Log Design and implement a system to automatically track all changes to production code (SQL, C# library, JavaScript, etc.) to support IT change audit. Read more about how this is accomplished. See details Architecture 2012-Present XRM ERP Designed, lead, and engineered a custom ERP application built on top of CRM/XRM/CE/Power Platform for a global electronics distributor and manufacturer with operations in 26 different counties. See details SQL 2021 Go To Looper Article I wrote for SQL Server Central (750,000+ subscribers) regarding a technique in SQL Server using GoTo for looping. Go to website Process improvement 2020 Interview Guide Developed an interview guide process. This process improved hiring efficiency in our interview process for technical candidates. Included a three-phased approach using Microsoft Teams to initially screen, technically screen, then finally interview on-site. Both candidates and internal team members appreciated the transparent process. This enabled the team to more effectively gauge talent in a consistent manner. Download Architecture 2019 Marketing Interface Design eCommerce Interface utilizing SSIS and JSON based REST web API calls. See details Process improvement 2019 New Start Dog Rescue Website Website I architected to help a local non-profit dog rescue manage their own changes. This saved costly updates by a professional website design firm while still meeting their needs to find volunteers fosters, and adoption candidates. Setup the overall layout and trained the Board on updating design elements to meet the look they desired. Go to website Architecture 2017 Time Collection System Time collection system design and development using Dynamics CRM, SQL Server Integration Services, SharePoint, and Reporting Services. Includes Time Sheet for manual entry labor and Time Clock for clock in/out See details Process improvement 2018 XRM Solution Dependency Checker (XRM Toolbox Plugin) Lead the design of a plugin in the popular XRM Toolbox community tool supporting Microsoft Power Platform (and legacy "xRM"/CRM). Used in the deployment lifecylce to validate that solution contains all necessary dependencies. Eliminated failed solution deployments due to missing dependencies. Over 30k downloads. Go to plugin page

Feb 25, 2022 2 min Open the Table Browser with a Bookmarklet | Dynamics 365 Finance & Operations Jul 7, 2021 3 min GoTo Looping in SQL FEATURED POSTS Never Miss a New Post. Enter your email Subscribe Thanks for subscribing! THOUGHTS Apr 7, 2023 2 min Five Tips for Successful On-Premises Dynamics 365 Finance and Supply Chain Deployment Most deployment of Dynamics 365 Finance and Supply Chain are SaaS in the Microsoft cloud. With that said, there is an on-premises,... 48 views 0 comments 1 like. Post not marked as liked 1 Feb 17, 2023 1 min Custom Component Cannot Find Connection Manager (0xC0010009) SSIS Error: Cannot find the connection manager with ID "" in the connection manager collection. 15 views 0 comments 1 like. Post not marked as liked 1 Jul 13, 2022 1 min Power Platform 2022 Release Wave 2 Power Platform Release Wave 2 overview 13 views 0 comments 1 like. Post not marked as liked 1 Feb 25, 2022 2 min Open the Table Browser with a Bookmarklet | Dynamics 365 Finance & Operations Open the Dynamics 365 Finance and Operations table browser without installing an extension! 129 views 0 comments 1 like. Post not marked as liked 1 Dec 9, 2021 2 min Get Choice Label / Option Set Label (Dataverse Reporting) What are Choices in Dataverse? Also, and formerly, known as Option Sets and Picklists, Choices are effectively a key-value pair object... 692 views 0 comments 1 like. Post not marked as liked 1 Jul 7, 2021 3 min GoTo Looping in SQL Overview of GoTo looping technique in Microsoft SQL Server 62 views 0 comments 1 like. Post not marked as liked 1 Jun 25, 2021 2 min Quick Tip: SQL Transaction Log Management Transaction log growing out of control? Encountering error "The transaction log for database is full" Find out how to fix in this post! 24 views 0 comments 1 like. Post not marked as liked 1 More Posts ABOUT ME Technology consultant with a focus on business applications. I drive organizational change, solve business problems, and improve processes using technology and creative problem solving techniques. Excels in the design, architecture, development, implementation, and support of business application solutions. Utilizes in-depth technical knowledge, combined with expertise across a broad range of technologies, businesses, and industries, to solve client challenges. Experience partnering with entire client organizations, from manufacturing floor workers, to accounts receivable clerks, to C-level executives. Manages all aspects of the software development lifecycle as a key resource and adviser to both clients and team members. Read more about my experience in a profile by University of Illinois at Urbana Champaign LAS @ Work series here. ​ Specialties: -Business Application Design & Architecture -Requirements Gathering -Business Systems Analysis -Power Platform -Microsoft 365 -Dynamics 365 -Azure -Teams -Data Analysis -Business Process Improvement -SQL Server (SSIS, SSRS, T-SQL) Read More > SUBSCRIBE Enter your email Subscribe Thanks for subscribing! Favorite Blogs Name Focus CRM Tip of the Day Microsoft Dynamics, Power Platform Corterra Solutions Microsoft Power Platform, Teams, Microsoft 365, Azure SQL Authority (Pinal Dave) SQL Server Jukka Niranen Microsoft Power Platform ("CRM") Brent Ozar SQL Server Favorite Books Title Author Topic The Art of War Sun Tzu Business 100 Things Every Designer Needs to Know About People Susan Weinschenk Solution design & architecture Doughnut Economics Kate Raworth Economics Extreme Ownership Jocko Wilinek Business How to Win Friends and Influence People Dale Carnegie Business Feature Engineering Bookcamp Sinan Ozdemir Data science Systems Design Interview Alex Xu Solution design & architecture Way of the Wolf Jordan Belfort Business The Goal Eliyahu M. Goldratt Process improvement Solve For Happy Mo Gawdat Mental health Contact

Problem solver | Business Application Architect | Accomplished SQL Professional

Interview Guide 2020 Developed an interview guide process. This process improved hiring efficiency in our interview process for technical candidates. Included a three-phased approach using Microsoft Teams to initially screen, technically screen, then finally interview on-site. Both candidates and internal team members appreciated the transparent process. This enabled the team to more effectively gauge talent in a consistent manner. < Previous Work Download Next Work >

Heritage Lakes Estates Condominium Assn. Website 2017 Modernized communication with homeowners in the community by posting key information and documents. Prior to launch of website, homeowners in the community would need to wait for an email response to answer basic questions and receive various documents. < Previous Work Go to website Next Work >

XRM ERP 2012-Present Designed, lead, and engineered a custom ERP application built on top of CRM/XRM/CE/Power Platform for a global electronics distributor and manufacturer with operations in 26 different counties. < Previous Work Built an ERP application using CRM/CE/XRM/Power Platform as the development platform with components in SQL Server, SharePoint, SSIS, SSRS. Project incorporated dynamic JavaScript libraries and custom C# plugins to acheive the look and feel of a full-featured ERP application. Modules included prospecting, sales, purchasing, inventory management, manufacturing, product configuration management, finance, and logistics. Numerous third parties were integrated for real-time duty rates, daily exchange rate retrieval, and integration to 3PL warehouse. Next Work >

Go To Looper 2021 Article I wrote for SQL Server Central (750,000+ subscribers) regarding a technique in SQL Server using GoTo for looping. < Previous Work Go to website Next Work >

Time Collection System 2017 Time collection system design and development using Dynamics CRM, SQL Server Integration Services, SharePoint, and Reporting Services. Includes Time Sheet for manual entry labor and Time Clock for clock in/out < Previous Work The Time Collection System is a full featured system for managing employees time. Whether that time be entered by the employee (Time Sheet) or the employee "clocking" into a job (Time Clock), the time collection system handled these scenarios. Additionally, it handles for auto approvals or manual approval of time to allow for organizations to limit approval time if not required, or to ensure accurate recording with a manual review. The system handled different work shift, approval teams, and all other features expected of a time collection system. This time collection system has been enabled in a variety of different software, particularly Dynamics, but can be ported to other software as the concepts remain the same. Contact me to learn more! Next Work >

LAS @ Work Feature 2023 A profile of my experiences in the LAS @ Work blog from the University of Illinois at Urbana-Champaign through my time as Principal Architect at Corterra Solutions. Read more about me! < Previous Work Go to website to read more! Next Work >

New Start Dog Rescue Automation 2019 Saved 100's of manual hours generating a printable application form from a Google Forms response by implementing the GSuite tool called Autocrat. Autocrat allows for workflow automation in the GSuite. Particularly in this instance, used Autocrat to generate a printable document from a Forms response collected in Google Sheets. < Previous Work What is autoCrat? Autocrat is an add-on to the G Suite that allows for automating the creation of documents from responses to forms. It is very dynamic and user friendly, requiring next to no "code" other than the "tags" it uses. Three Key Components Google Form Capture information. Faces the internet This is how the volunteer, adoption candidate applies Google Sheet Stores the responses for easy use Suggest to configure from the form under the response tab Google Doc Formatted document template for each response Document is formatted and is a template to map data from the Google Sheet of responses into the formatted document using tags Steps to Configure Create Google Form Ensure you setup the responses to be stored in a Sheet Create Google Doc Template Use << tag name >> to specify where data should be mapped to Do not duplicate tag names Go into the Google Sheet that is holding the responses Click on "Add Ons" Go to "autoCrat" and "Launch" Once autoCrat launches, it will show you any "Merge Jobs" if you have any already configured, but if not, you won't see anything currently listed and can start by clicking the New button. Merge Job = what the autocrat add-on calls the action to merge data from the sheet into the formatted document Walk through the screens to configure the job Once complete, responses entered in the Form will automatically generate a Doc/PDF and a response in the Sheet Helpful Links: Autocrat User Guide: https://docs.google.com/document/d/1WTGSSlH6gwUHpipusPKLIsgfFUamDbFbJ7JaoG6-ZBo/edit Autocrat Forum in a Google Group: https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!forum/nv-autocrat-add-on Next Work >

My Portfolio Various projects I have worked on over the years Architecture 2021, 2015 Cost Data Warehouse Cost Data Warehouse for manufacturing production insights to break out true elements of cost throughout multiple levels of subassembly production. Multiple versions exist. See details Information access 2017 Heritage Lakes Estates Condominium Assn. Website Modernized communication with homeowners in the community by posting key information and documents. Prior to launch of website, homeowners in the community would need to wait for an email response to answer basic questions and receive various documents. Go to website Personal 2023 LAS @ Work Feature A profile of my experiences in the LAS @ Work blog from the University of Illinois at Urbana-Champaign through my time as Principal Architect at Corterra Solutions. Read more about me! Go to website Process improvement 2019 New Start Dog Rescue Automation Saved 100's of manual hours generating a printable application form from a Google Forms response by implementing the GSuite tool called Autocrat. Autocrat allows for workflow automation in the GSuite. Particularly in this instance, used Autocrat to generate a printable document from a Forms response collected in Google Sheets. See details Information access 2016 Object Change Log Design and implement a system to automatically track all changes to production code (SQL, C# library, JavaScript, etc.) to support IT change audit. Read more about how this is accomplished. See details Architecture 2012-Present XRM ERP Designed, lead, and engineered a custom ERP application built on top of CRM/XRM/CE/Power Platform for a global electronics distributor and manufacturer with operations in 26 different counties. See details SQL 2021 Go To Looper Article I wrote for SQL Server Central (750,000+ subscribers) regarding a technique in SQL Server using GoTo for looping. Go to website Process improvement 2020 Interview Guide Developed an interview guide process. This process improved hiring efficiency in our interview process for technical candidates. Included a three-phased approach using Microsoft Teams to initially screen, technically screen, then finally interview on-site. Both candidates and internal team members appreciated the transparent process. This enabled the team to more effectively gauge talent in a consistent manner. Download Architecture 2019 Marketing Interface Design eCommerce Interface utilizing SSIS and JSON based REST web API calls. See details Process improvement 2019 New Start Dog Rescue Website Website I architected to help a local non-profit dog rescue manage their own changes. This saved costly updates by a professional website design firm while still meeting their needs to find volunteers fosters, and adoption candidates. Setup the overall layout and trained the Board on updating design elements to meet the look they desired. Go to website Architecture 2017 Time Collection System Time collection system design and development using Dynamics CRM, SQL Server Integration Services, SharePoint, and Reporting Services. Includes Time Sheet for manual entry labor and Time Clock for clock in/out See details Process improvement 2018 XRM Solution Dependency Checker (XRM Toolbox Plugin) Lead the design of a plugin in the popular XRM Toolbox community tool supporting Microsoft Power Platform (and legacy "xRM"/CRM). Used in the deployment lifecylce to validate that solution contains all necessary dependencies. Eliminated failed solution deployments due to missing dependencies. Over 30k downloads. Go to plugin page

Cost Data Warehouse 2021, 2015 Cost Data Warehouse for manufacturing production insights to break out true elements of cost throughout multiple levels of subassembly production. Multiple versions exist. < Previous Work The Cost Data Warehouse (CDW) is a manufacturing insights solution to break down the true elements of cost in manufacturing. The 2021 version is written in X++ for Dynamics 365 Finance and Operations (on-premise). The 2015 version is based on Dynamics 365 "xRM" using SQL and SSIS. Why is CDW needed? The purpose of CDW is to break down actual labor, overhead, and material costs for multi-level production orders/BOMS. In short, breaking out sub-assembly material cost into the actual elements of cost to produce the sub-assembly. Without CDW, sub-assembly labor and overhead cost is treated as material cost. This overstates the actual labor and overhead costs. Sample use case This is particularly important in the government contracting space. Bids must be placed on government contracts. In the bid, detailed information must be provided on expected cost broken down into categories. CDW provides the client a more accurate picture of their actual costs, allowing a more competitive bid than the competition. Additionally, it is key in reporting for both internal operational use and reporting to the government on status of a contract once won. Next Work >