Contact

jeff@duckcreekconsulting.com
602.214.4780

Goal

I am a highly experienced Microsoft Business Central (On-prem and Online), and Windows™ browser-based application developer. I have more than 30 years of programming experience and am available on a B2B or C2C basis. (Will consider W2)

I seek Senior Business Central and .NET senior developer roles solving business automation and integration challenges. Recently, I have been working with clients to ensure easy, constant, data migration between online and on-prem data so on-prem systems can continue running with BC online data. I understand and use BCCL and Microsoft Integration tools as well as custom HTTPS APIs. Integration with Azure has been critical in these requirements, too.

I have been a Windows™ business developer for more than 25 years working in C++, C#, SQL, JavaScript Navision, Dynamics Business Central, desktop, cloud, and service architecture across many clients.

Highlights

Technical Skills

History

Education: BS: Chemistry, ETSU, 1985

35 Years as a business automation and Windows applications developer

US Navy: Honorable Discharge

Professional Experience

Professional Experience

Duck Creek Consulting
January 2011 – Present
MS Dynamics Consultant

January 2011 – Present

MS Dynamics Consultant

PROJECTS:  

• 2023 – present: Contract developer for furniture manufacturer implementing BC for the first time, migrating from a 1990s bespoke ERP written originally in Access. Establishing scheduled jobs to migrate manufacturing, inventory, warehousing (shipping and receiving), and EDI data (mostly) from the cloud to a local SQL instance so they can continue to use their on-prem reporting, messaging, and information handling utilities and applications. (This leverages Erik Hougaard’s BCCL and Microsoft Data Integration tools, as well as a great deal of SQL development, Powershell scripting, and SQL Agent job scheduling.)
• 2022 – 2023: Contract developer for PPL (multi-state Medicare billing aggregator) working in NAV on-prem and BC both on-prem and on Azure.
• 2019 – 2022: Freelance for Tigunia: Business Central, Cannabis Processing and Tracking. Designed and created a comprehensive extension in AL for the Cannabis industry. Based upon production integration, provided user-configuration of data entry pages to simplify and ease of use.  Written in AL and JavaScript, with integration using RESTful services to talk to regulatory agencies.
• 2004 – 2020 BC Upgrades: Royal Canin; Green Dot, Assisted in data migration and master data management to upgrade from NAV versions to BC in the cloud and on-prem. Supported many data initiatives while upgrading.

END-USERS AND SOLUTION CENTERS

• 2023 Integration and new implementation for home furnishing manufacturer. Implemented BCCL (from Erik Hougaard) for data exchange, as well as multiple add-ons from Lanham and others.
• 2022 – 2023 Support for highly-customized dual instance of both NAV and BC for multi-state Medicare payment contracts.
• 2019 – 2022 Implementation and configuration for Lanham extensions for EDI and WMS.  Provided customization of handheld functionality for multi-warehouse picks.
• 2018 – 2020 Installation configuration of extensions for document management and Business Intelligence.
• 2019 – 2022 Custom extension development to mimic previous NAV C/AL customizations

NAV UPGRADES      

• 2001 – 2019 Have performed on-prem NAV upgrades from 1.2 through 2017.

SQL TOOLS 

• 2008 – 2022 SQL Queries to speed up migration of NAV data during upgrades. Multiple-jump upgrades on large databases took too much time for a two-or-three day upgrade. Wrote code factories that quickly scripted queries that could move all the data in 300GB NAV in under six hours.

SQL APPLICATIONS                

• 2018 – 2022 Duplicate customer finder and scripts to combine transactions under chosen customer.  Code factories to build custom scripts for data warehousing and data migration.

DATA WAREHOUSING         

• 1995 Built patient data warehouses for CDC , tackling the problems of duplicate and incomplete childhood immunization data.
• 2010 Built data warehouse to aggregate multi-company data for consolidated reporting and prediction.
• Saved much processing and customization in NAV by using SQL and external tools
• 2021 Integrated cloud BC data to Azure SQL for BI consumption.  Used OData, Azure Serverless, and Azure databases.  Provided a web-based platform for much richer reporting without the expense of BI licensing.       
• 2011 Used a data warehouse approach to archive NAV data prior to consolidating tables and truncating data into monthly or quarterly summaries.

REPORTING                

• 1999 – 2018 C/AL Reports   
• 2018 – 2022 AL Reporting in BC and Word
• 2018 – 2021 Jet Analytics (Jet Reports) integration with NAV
• 2007 – 2018 Built SSRS data reports for a field service company that supported banks and vaults.
• 2019 – 2022 Custom business reporting using DevExpress tools, online services, and custom controls inside BC

ENTERPRISE INTEGRATION 

• 2011 Large Bank (unnamed) SOAP services to exchange two-way data interchange between NAV and in-house enterprise systems. Two-way synchronization of General Ledger data on disparate systems. Used C# .NET and integrated with NAV.
• 2016 StorageCraft SOAP service integration to acquire serial number and licensing information for large software seller. Integrated with NAV and Oracle systems. The Oracle systems maintained serial numbers and licensing + maintenance information. The NAV integration allowed the assignment of contract information from a remote system.
• 2022 StrageCraft RESTful integration with third-party address and currency provider into BC. Used internal web and HTTP functionality in AL to make the calls and parse the results.
• 2022 Arcserve gRPC integration of invoice and return receipt data to a Google Pub/Sub topic. Solved this for both NAV and BC. This provided a way for multiple “subscribers” in the enterprise to gather information (separately but from a common service) about every invoice and return as it is posted.
• 2023 NAV to BC integration of dual-instance implementation requiring NAV data transmitted to cloud BC
• 2023 Automated EDI data upload from on-prem solution to SaaS BC. Download of ALL BC cloud data to on-prem SQL for Power BI and custom reporting

Notable Companies

Legends Home
2023 – present
Sr. Developer, multiple ERP (NAV + BC)

• Responsible for migrating business processes from on-prem bespoke (and frankly, old) ERP system to online BC system while retaining the myriad of on-prem SQL and .NET systems that used to integrate with the old system.
• Data exchange (from/to) to maintain available local data system

PPL
2022-2023
Sr. Developer, multiple ERP (NAV + BC)

• Supported complex data integration and data validation in solution using both NAV (connected to legacy portals) and SaaS BC (vendor and payment processing)
• Modified SQL stored procedures, NAV codeunits and reports, and extended BC with custom code, reports, tables, and table extensions.

Brighton Cromwell
2012 – 2015
Sr. Developer, multiple platforms

• Corrected failed implementation of NAV and corrected many failed customizations to turn BC into a paperless office
• Using page scraping, email, and FAX OCR, intercepted over 3,000 requests for bid from government agencies for automated bid construction. Used about 300 vendor price lists to compile lowest possible multi-source bids. Using past win statistics, automatically suggested the best 20 bids to return each day. Sales manually handled from there. (80 percent win rate)
• Automated development, testing, and deployment using Jenkins for daily updates.

ArcherPoint
May 2008 – July 2011
Sr. Applications Developer

• Developer and technical support in native and SQL Server versions of Microsoft Dynamics (NAV) from v1.2 through v2009.
• Financial, A/R, A/P, Inventory, Sales Reporting, Distribution, Office ™ automation, web, and service integration.
• Data Warehousing, analysis and reporting in SQL Server 2000, 2005, and 2008. Specific to Microsoft Dynamics (NAV) in SQL Server 2005 and 2008. 
• Visual Studio 2005 and 2008, specializing in .NET 2.0, 3.0, and 3.5 across both WinForms and Web development. Utilizing Infragistics, Ideablade DevForce, and DevExpress visual components, data access and productivity components.
• Design and development of revision, version, and release, control and management protocols using proprietary and open source tools.
• Performed multiple Navision database upgrades from versions as far back as 3.7 up to the current database versions.

Contact

Showing a Pivot Grid Custom Control written inside Business Central