Jason Gassner Email & Phone Number

• Collaborated on and developed numerous MS Access databases with VBA ETL processes.
• Developed and designed comprehensive SharePoint Power Apps applications, leveraging Power Automate and SharePoint Lists. Collaborated within a 4-person team to deliver the project ahead of schedule, receiving.
• Engineered robust.NET/C# applications using modern design patterns to automate ETL tasks and streamline data consolidation into coherent, actionable reports.
• Optimized business processes through expert C# solutions, consolidating and organizing data from thousands of Excel sheets into a unified, easily readable format, significantly enhancing efficiency.
• Liaised with designers, managers, and clients to identify and apply best practices in asset management and software development, resulting in substantial improvements in project completion times.
• Mentored junior developers and provided technical guidance on best practices, contributing to team knowledge sharing and skill development.

San Antonio, Texas Metropolitan Area

• Designed and implemented automation solutions, saving the company hundreds of labor hours weekly by streamlining manual processes.
• Developed a C# WinForms application to enhance business efficiency through built-in automations for SAP transactions, automatically importing and writing data as needed.
• Led development projects, including the migration of a multi-gigabyte Microsoft Access database to the cloud, enabling hundreds of remote workers to maintain productivity during COVID.
• Built and maintained a multi-terabyte SQL Server, crafting complex stored procedures, views, and table normalization to ensure robust data management.
• Engineered ETL processes in C# to interface with Microsoft Dynamics CRM/XRM APIs, utilizing the Dynamics CRM Software Development Kit for efficient data integration.

San Antonio, Texas, United States

• Served as the primary point-of-contact and subject-matter expert for smart cards within a public key infrastructure (PKI) environment, managing over 1200 smart cards and critical access points.
• Developed an Access database to monitor and track smart cards, significantly improving business efficiency over the legacy Excel-based tracking system.
• Ensured compliance with security policies and protocols, maintaining the integrity and confidentiality of sensitive data and access points.
• Collaborated with IT and security teams to implement best practices in smart card management and PKI infrastructure, enhancing overall system security.
• Trained staff on the use of the new Access database and smart card management procedures, ensuring a smooth transition from the legacy system.