Welcome to Josh Anstead's Portfolio

Comprehensive System Upgrade and Process Automation

Overhauled IT systems to enhance security, efficiency, and scalability. Migrated legacy applications, implemented automation, and developed advanced dashboards for data visualization.

Technologies: SQL Server 2019, VB.NET, VB.Core, Power BI, SSRS, Zebra Scanners

• Upgraded SQL Server systems, optimizing stored procedures
• Developed barcoding and scanning tools for enhanced traceability
• Created dynamic Power BI dashboards for real-time insights
• Migrated applications to the cloud with advanced security protocols

Impact: Enhanced system performance, reduced operational bottlenecks, and improved security with MFA and JWT JSON integrations.

Legacy Application Modernization and Data Integration

Overview: Modernized critical legacy applications to enhance performance and security.

• Rearchitected an ASP.NET/MS SQL application to a Laravel, PHP, React.js, and MySQL solution.
• Migrated to secure Linux hosting with Azure/Entra AD authentication.
• Enabled encrypted data exchange between MySQL and MS SQL, integrating data into SSRS and Power BI dashboards.

Impact: Improved management reporting and system security, contributing to a 25% increase in decision-making speed.

Month-End Reporting Automation

Overview: Overhauled legacy reporting processes to enhance data accuracy.

• Designed an automated point-in-time reporting solution for month-end data snapshots.
• Integrated key metrics into ERP systems for seamless data migration.
• Eliminated manual processes, reducing reporting time by 40%.

Impact: Resolved a 25-year reporting bottleneck and saved over $30,000 in operational costs.

SQL Server and ERP Modernization

Overview: Upgraded legacy MS SQL Server for ERP systems from 2003 to Enterprise Edition 2019, modernizing and stabilizing infrastructure.

• Upgraded MS SQL Server in stages (2005, 2008, 2012) while migrating ERP schemas, security settings, and transactional data.
• Reconfigured DNS rules and OLE DB connections to enable seamless traffic transfer between servers, ensuring a zero-downtime transition.
• Modernized .NET and Access-based ERP applications by dynamically updating DLLs with late binding, transforming static 32-bit solutions into scalable 64-bit infrastructure.

Impact: Future-proofed ERP systems with a dynamic, adaptable architecture, improving operational efficiency, scalability, and compatibility across diverse applications.

Advanced Power BI Solutions

Overview: Developed comprehensive dashboards for analytics and monitoring.

• Designed Power BI dashboards for monitoring key business events and operational risks.
• Built IT and security monitoring dashboards, enhancing visibility across siloed systems.
• Created sales analytics and compliance dashboards supporting strategic decision-making.

Impact: Provided proactive insights and ensured regulatory compliance.

Unified Reporting System and Automation

Overview: Centralized reporting tools to improve data consistency.

• Consolidated reports from Access and SAP Crystal Reports into SSRS.
• Utilized advanced T-SQL features for consistent, multi-format output.
• Enabled end-to-end deployment across SSRS, Power BI, and legacy systems without delays.

Impact: Streamlined reporting processes and improved adaptability to stakeholder requests.

Automated 3D Geospatial Data Processing and Quality Control

Automated data quality control for DOT projects, optimizing 3D survey maps. Implemented advanced algorithms and geometric transformations for accurate mapping.

Technologies: VBA, VB.NET, Python, AutoCAD, MicroStation, LiDAR

• Developed automation scripts for geospatial data processing
• Corrected map errors using vector algebra and geometric transformations
• Processed and validated large LiDAR datasets
• Optimized algorithms to handle datasets with millions of points

Impact: Improved data accuracy and validation speed by 50%, contributing to successful project delivery.

Time Warner Cable Installation Quote Automation

Designed automation tools to streamline surveyor and manager workflows. Developed event-driven processes, integrating local desktops, servers, and web applications for seamless communication.

Technologies: VBA, Windows Desktop API, Spy++, Web Dev Tools, Microstation Mapping, Google Earth, KML, GIS Mapping

• Engineered event-driven automation processes to enhance efficiency and reduce manual effort.
• Mapped and manipulated the DOM for web scraping, data integration, and automated interactions.
• Automated resource ergonomics to pull mapping resources, including Microstation Mapping, Google Earth, KML Mapping, and GIS Mapping, for virtual surveying.
• Developed middleware solutions for interoperability between Excel, desktop applications, and web browsers using VBA and Windows API.
• Utilized Spy++ to reverse engineer window handles and DOM relationships for automation and data flow orchestration.
• Designed and tested asynchronous workflows with polling wait loops to handle real-time data processing.
• Implemented error handling and recovery strategies using commands like On Error GoTo -1 to ensure robust task execution.
• Enhanced reliability by simulating synchronous workflows for asynchronous operations.
• Integrated APIs for cross-platform data synchronization and dynamic resource allocation.

Impact: Reduced manual effort by 50%, improved SLA compliance from 64% to 99%, and preserved a critical client contract. Streamlined mapping and data validation processes, enabling faster and more accurate survey completion.

Advanced ERP Integration and Automation

Spearheaded the development of automation tools and data integration processes, bridging isolated ERP systems and desktop applications to enhance operational efficiency and data accuracy.

Technologies: VBA, SQL Server T-SQL, MySQL, FTP, Microsoft Office Automation, Power Automate, RPA

• Developed an add-on application that automated data entry and streamlined data flows between disconnected ERP systems and desktop applications.
• Improved SLA metrics from 64% to 99% by automating critical processes such as resource scheduling, data modeling, data mining, and ETL operations.
• Designed and trained machine learning models for data warehousing to enhance data mining capabilities and resolve errors identified by quality control and customer complaints.
• Implemented event-driven logic and custom event listeners using Power Automate, VBA, and APIs to enable real-time data exchange between web browsers and desktop applications.
• Enhanced data quality and process reliability with redundancy automation, leveraging middleware solutions to ensure uninterrupted operations.
• Utilized advanced tools like VBA, SQL Server T-SQL, MySQL, and FTP to develop a robust integration solution.

Impact: Enabled seamless data flow and automation across platforms, improved data accuracy, boosted customer satisfaction, and increased operational efficiency by automating manual workflows and reducing errors.