Business Analyst Manager
Current• Managed team which provided user support for Dynamics NAV in U.S. and Canadian regional offices.• Upgraded NAV 2009 to NAV 2016 for US operations, including SSO authentication against Office 365.• Upgraded NAV 2009 to NAV 2015 for Canadian operations.• Migrated US NAV to Azure platform.• Developed solution to integrate cloud-based POS/CRM system into NAV utilizing direct connection to remote MySQL database.• Part of team that developed ETL pipelines in SSIS, data warehouse, and SSAS cubes to provide BI insight into various transactional data, including data from cloud-based POS/CRM system and NAV.• Developed multiple BI reports and dashboards.• Developed solution to integrate cloud-based procurement and expense system into NAV utilizing web services.• Developed EDI integrations with multiple vendors, using multiple custom vendor file formats and schemas.• Developed solution to export ACH files from NAV, including providing remittance information in ANSI ASC X12 format.• Developed custom workflows in NAV to facilitate control over vendors.• Developed solutions to integrate custom Dynamics CRM solution with NAV.• Developed multiple reports in both NAV and CRM.