Sql Server Active Directory

Information Systems Management Windows Servers (On-Prem and virtual) SQL Server

Enterprise Resource Electronic Data Interchange Mobile Device Management Network Administration Project Management Continuous Personal Development and Training Team Leadership

Technical Knowledge:

●Microsoft Windows – (Microsoft Windows Server 2000, 2003, 2008, 2012 etc., Microsoft Active Directory, Microsoft Azure Active Directory, Backup systems including Nutanix, HYCU, Veeam, Barracuda. Remote applications Windows Remote desktop manager, PC Anywhere, Citrix, VNC)

●Microsoft SQL Server - (SQL Server 2000, 2008, 2008R2, 2012, 2014, 2016 and 2019. SSMS, SSRS, SSIS)

●ERP – (Microsoft D365, Great Plains, NAV, AX, SAP, Agility, NetSuite)

●Microsoft Applications – (Microsoft Word, Microsoft Excel, Microsoft Visio, Microsoft PowerPoint, Microsoft Project, Microsoft Power Platform\Azure Logic App

●Integration\Ticketing (Boomi Platform, Tibco Scribe Integrations, Econnect, SmartConnect. Ticketing systems include Remedy, ServiceNow Jira etc.)

Relevant Professional Experience

Lyons Magnus, Fresno, CA

EDI Manager\ERP Support 06/2023 – 12/2024

Coordinate, implement, and manage all EDI related developments for Lyons Magnus. Responsible for analyzing and designing specifications used for enhancements and extensions in EDI applications, interfaces, and mapping. Served as the primary liaison between IT and internal business units, Vendors, Customers and 3PL’s

Key Accountabilities:

•Establish contact with trading partners, analyzing the data exchanged with all partners (Customers, Vendors, 3PL’s etc.)

•Determine the type of data exchange connection (AS2, FTP, SFTP etc.) capabilities trading partners prefer and develop guidelines and specifications for the requested document exchange

•Manage all EDI testing, implementations and upgrades including maintaining the EDI servers. This also includes the migration of the EDI servers from old infrastructure to the new hybrid environment.

•Daily production support, maintenance, and monitoring of EDI documents (850, 875, 855, 856, 810, 880, 940, 945, 943, 944, 864, 824, 832, 860)

NS Brands Ltd, San Antonio, TX

EDI Specialist\Application Support 07/2019 – 10/2022

Coordinate, implement, and manage all EDI related developments for NS Brands. Responsible for analyzing and designing specifications used for enhancements and extensions in EDI applications, interfaces, and mapping. Served as the primary liaison between IT and internal business units, Vendors, Customers and 3PL’s

Key Accountabilities:

•Establish contact with trading partners, analyzing the data exchanged with all partners (Customers, Vendors, 3PL’s etc.)

•Accountable for Master data catalogs management ensure data quality

•Determine the type of data exchange connection (AS2, FTP, SFTP etc.) capabilities trading partners prefer and develop guidelines and specifications for the requested document exchange

•Manage all EDI testing, implementations and upgrades including maintaining the EDI servers. This also includes the migration of the EDI servers from old infrastructure to the new hybrid environment.

•Daily production support, maintenance, and monitoring of EDI documents (850, 855, 856, 810, 940, 945, 943, 944)

•Designed, Developed, and implemented an automated archive system for Inbound\Outbound documents as well as well as error handling process using batch scripting

Fred’s Inc, Dallas, TX

Application Support Engineer 07/2018 – 07/2019

Perform support tasks from the Azure portal to integration middleware applications such as deployment of environments, platform updates. Utilized (LCS) Life Cycle Services to deploy updates to dev\test environments, created regression testing. Assist with resolution of application support incidents. Responsible for creating architecture, design, and other technical processes for multiple business entities.

Key Accountabilities:

•Utilizes experience to identify problematic relationships. Anticipates, prevents and eliminates problems and creates efficient fixes. Facilitates elimination of problems and proactive resolutions during implementation of D365

•Works cross-functionally to accomplish assignments. Interacts with internal and external peers and managers to exchange complex information related to subject matter experts

•Evaluation and execution compatibility of MS Dynamics 365 for pre-release, upgrades, hotfixes and current versions of software within Microsoft Lifecycle Services

•Work directly with Microsoft support identifying software bugs, identifying effective resolutions, smoke testing and communicating to the business with ETA.

•Participate in requirements gathering, process designs, etc. to understand the application and document it appropriate for the support team

•Understanding of Azure services/resources including but not limited to BLOB storage containers, data integration tools, APIs, SaaS, Microservices, Data Analytics, Edge, IaaS, PaaS, CaaS and FaaS, with strong Analytical and problem-solving skills

SRS Distribution Inc,

Application Support Specialist II 01/2018 – 7/2018

Maintain excellent ERP support, customer communication, as well as define problems, analyze symptoms, identify root cause and documenting long term resolution whether technical or procedural.

Key Accountabilities:

•Manage the Application Support Staff and infrastructure components of the applications. (Agility ERP)

•Participate in the development of standards and procedures as well as enforcement of such standards, IT Policies and IT process.

•Ensure that application development and application support work follow best practices, internal standards, policies and are developed. Support contributors in execution and delivery of architecture tasks.

•Follow formal change management processes for IT business applications.

•Document support process for systems integration and systems development across the organization.

•Oversee and perform application implementation and pass to production administration (Change / release support).

IT Consulting, Dallas, TX 02/2015 – 01/2018

IT Consultant\Support Technician II

Took on role of being IT lead for the creation, development, and support of a website and phone application for a personal project. Ensured that business needs, development and deployment were met from a stakeholder’s expectation. Also had some contracts helping upgrade some network components and ensuring that all software and firmware are up to date for the clients.

Key Accountabilities:

•Exposure to ERP systems such as SAP, Microsoft Dynamics AX, NAV, GP, D365 including integration packages (Web Services, eConnect, SmartConnect etc.)

•Effective & efficient provisioning, installation/configuration and maintenance of hardware and software and related infrastructure.

•Implementation of system hardware, operating systems, software systems, and related procedures that adheres with the client’s technology direction and policies.

•Technology Family: Windows, Exchange, Windows Infrastructure (AD, DNS, DHCP, IIS, FTP, GPO)

•Perform daily system monitoring, verifying the integrity and availability of all hardware server resources, system and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as Barracuda backup appliances.

•Document support process for systems integration and systems development across the organization.

•Design and implement complete backup systems over multiple domains and configured backup types\schedules per practice requirements

Prime Source Building Products, Irving, TX 03/2008 – 09/2014

EDI (Electronic Data Interchange) Administrator 08/2012 – 09/2014

Provide technical and administrative support for EDI design and analysis. Work directly with the executive and management teams to scope out requirements, set priorities, and execute testing & implementation. Supply senior technical leadership to both IT and business organizations within the enterprise while staying in the forefront of technological advances.

Key Accountabilities:

•Project manager for EDI upgrade in ERP system. Project was on-time and 8% under budget.

•Developed rolling go-live plan with value-added network (VAN) which was adopted as an enterprise plan across all three business entities.

•Responsible for maintenance and modifications for ANSI X12 Document Types: 810, 812, 820, 846, 850, 855, 856, 860, 864, and 997.

•Evaluated all SAP Batch jobs to ensure maximum efficiency was reached and minimal system usage.

•Created a roll-out plan for the Canadian branches and make sure all users and profiles were imported correctly.

•Did all the document testing for the EDI roll-out to ensure that there were minimal document errors once we went live. Kept open communication with all users and trading partners once SAP was live in Canada

•Designed and developed EDI dashboards showing statistical performance. One KPI demonstrated distributor incompliancy saving the organization $58,000 annually.

Contact this candidate