Alan Crawford

About Alan Crawford

Driven, professional, analytical thinker with over 20 years experience in the software industry. Continually working on personal and professional development. Experience of working with large and small software companies both in the United States and the UK. Extensive knowledge of SQL, Alteryx, Dynamics AX, ERP, EDI, Powershell and GIS systems.PROFESSIONAL AND TECHNICAL SKILLS• Developed multiple Alteryx workflows to facilitate data import, conversion and data analysis. Certified with Alteryx Designer Core and Alteryx Designer Advanced. • Experience with 850, 855, 856, 810, 846, 753 and 754 document types. Experience with EDI X12 and XML file formats. Worked with SPS Commerce and True Commerce to fully test, implement, and support EDI transactions.• Over 15 years experience in using SQL languages (T-SQL, PL/SQL) for retrieving data to be used for data analytics. • Skilled in Microsoft SQL Server Reporting Services (SSRS) and SAP Crystal Reports.• Key team member in delivery of RF propagation analysis for domestic and global electric, gas, and water utilities. • Formally trained in AWS Technical Essentials. • Over 20 years experience in application development. • Exposure to API development and JSON. • Excellent communication, inter-personal, and cross-functional collaboration skills. • Experience with Oracle, Access, and use of advanced Excel functions to retrieve, analyze, and visualize data.• Managed upgrade from legacy flat-file Gentran EDI system to cloud based True Commerce EDI system.• Developed Powershell scripts to import data from HR systems and Commercial banks. • Created and presented Training courses for domestic and global electric, gas and water utilities.• Over 10 years experience in GIS development using VBA, MapInfo MapBasic, ESRI ArcGIS technologies.• Strong experience with multiple high-level programming languages (C#, Visual Basic, VBA, X++, Topspeed Clarion) and scripting languages (MapInfo MapBasic, ESRI ArcGIS, ESRI Avenue). • Over 10 years of experience working with and modifying the Microsoft Axapta ERP system. • Microsoft Certified in Dynamics 365 Fundamentals.• Experience with software development tools like Jira, Confluence and Trello.• Exposure to VMWare, virtualization of existing physical hardware. • Experience maintaining databases and ensuring website availability for large utility companies and government entities.

Experience

1. Sr Systems Analyst

   Buck Knives

   Oct 2014 — Present · Post Falls, ID, US

   My role at Buck Knives as the Sr. Systems Engineer has been to manage the Axapta 2009 ERP system used for the complete workflow of manufacturing from purchasing, production, sales, through to shipping.• Also supported the technical aspects of the EDI (Electronic Document Interchange) system, which handles the flow of orders into and out of Buck Knives. Experience with 850, 855, 856, 810, 846, 753 and 754 document types. Experience with EDI X12 and XML file formats. Worked with SPS Commerce and True Commerce to fully test, implement, and support EDI transactions. • Perform on-site software customization and development services using the X++ language inside AX 2009.• Experience building custom applications, modifications, integrations, data conversion routines and custom reports.• Creation of custom reports using SQL Server Reporting Services.• Strong relationship building skills to work with stakeholders across multiple stakeholder teams.• Creative and methodical approach to a problem solving.• Evaluate opportunities to enhance the business through cross-group collaboration with other departments such as Finance, Marketing, Purchasing, Engineering, Manufacturing and Shipping.• Used MS-SQL to retrieve data for use in data analytics.• Formally trained in AWS Technical Essentials. • Exposure to API development and JSON. • Managed upgrade from legacy flat-file IBM Gentran EDI system to cloud based True Commerce EDI system.• Developed dashboards and visualizations in data visualization tools such as SSRS, Tableau and Microsoft Power BI. • Developed Powershell scripts for automation of importing data from HR systems and Commercial banks. • Skilled in Microsoft SQL Server Reporting Services (SSRS) and SAP Crystal Reports.• Experience with software development tools like Jira, Confluence and Trello.• Exposure to VMWare, virtualization of existing physical hardware.

Skills

• Esri
• Vb.net
• Rf Engineering
• Microsoft Sql Server
• Mapinfo
• Business Process Improvement
• Visual Studio
• Oracle Sql
• Sql
• Mentum Planet
• Database Design
• Cadcorp
• Database Administration