Dylan Drum Email & Phone Number

Charlotte, Nc, Us

Charleston, South Carolina, Us

San Francisco, California, Us

- Developing 7 microservices within a high-performing team, leveraging .NET Core and MongoDB to ensure efficient data storage and retrieval.- Successfully deployed microservices to Kubernetes using Harness cloud tool, streamlining the deployment process and ensuring scalability and reliability.- Innovated and implemented gRPC protocol endpoints, replacing REST API endpoints, resulting in improved performance and reduced data transfer latency.

Charlotte, Nc, Us

- Lead System Architect for Microsoft Purview onboarding/integration effort for data warehouse metadata management and governance- Designed and currently developing a real-time event based data pipeline to synchronize Cloud (Purview) and On-Premise metadata repositories (MSFT Purview, Azure Event Hubs, Azure Logic Apps, Azure SQL DB, .NET Core REST API, SQL Server, Teradata, Hadoop)- Delivered 140+ pages of detailed architectural design documentation for synchronization of cloud and on-premise data warehouse metadata- Designed and developed a custom data lineage POC with data warehouse ETL process metadata and Atlas REST API- Define technical requirements for Agile Product Owner to meet stakeholders business goals.- Responsible for training, mentorship, and technical expertise to my agile development team (8 devs)- Engineered from POC all the way to Production, a Secret Management application which reduces manual tasks by 100+hrs per year. Tech stack of Angular FE with Kendo UI controls, HashiCorp Vault and a .NET Core Web API backend using Entity Framework Core and Linq queries to efficiently pull data from SQL Server Database.- Designed and developed a custom DLL solution to call the Secret Management API to retrieve service ID credentials and create connection strings securely at runtime within SSIS ETL packages. - - This application and DLL solved an open audit issue of unsecured/unencrypted credentials and secrets.- Responsible for CI/CD operations such as authoring Ansible Tower playbook for use in automated deployment of microservice code from development through testing and production lanes and developing relevant Jenkins build files.- Conducted code reviews and quality assurance for agile scrum team user stories.

Charlotte, Nc, Us

- Re-Engineered an existing monolith web application for Data Classification Management to a Microservices design using a Single page web application (SPA) with a .NET core web API backend, SQL Server database and Angular front end.- Developed a Keep It Current process for an internal application to send automated email notifications to data owners for CRUD operations on production support contacts using .NET Framework(C#, HTML, CSS), SQL Stored Procedures and SSIS packages saving over 100+ hours per year of manual effort for the EPE team.

Charlotte, Nc, Us

- Developed CRUD operations and report metric calculations for Outage Reporting module of SPM application allowing users to automate the documentation and reporting of Teradata outage occurrences. Involved the development of C# business logic to create report metrics, allow CRUD operations, as well as stored procedures in T-SQL (.NET Framework).Implemented SQL enhancements to existing ETL packages which reduced execution time by over 90%- Performed demos of working software to stakeholders- Engineered enhancements to an existing web application and REST API for Keytab generation using Angular and .NET Core.

Charlotte, Nc, Us

- Developed ETL processes for the data warehouse using SQL and SSIS. - Full stack development user stories for data warehouse data movement SLA tracking web application (Monolith ASP.NET web app w/ SQL Server)- Analyzed production operation requests reported by stakeholders to identify root cause and solution

London, Gb

• Planned and executed the transition of 8,000 users across the organization to a new Cisco WebEx platform• Led over 300 training sessions to migrate more than 1500 users• Assessed, defined, and documented an efficient business process and standard operating procedure to migrate users• Created a team structure by defining responsibilities for 4 different roles assigned to 10 team members• Scheduled and led hourly training sessions to migrate users adapting to class size, user knowledge, and their unique WebEx account usage• Trained and communicated with all levels of employees including Executive Leadership• Reported daily data metrics between multiple departments utilizing Excel formulas• As team lead, acted as liaison between management and team members to address questions and ensure on time deliverables• Performed ad-hoc troubleshooting to complete user migrations successfully

• Manage inventory ensuring promise dates for customers are honored• Ensure accuracy of daily deposits• Resolve all customer complaints and process claims in a timely manner• Lead and Train new employees