David Cogan
About David Cogan
David Cogan is a Senior SQL Developer at Purple Communications, Inc, where he has worked since 2020. He has extensive experience in database development and architecture, having previously held positions at Farm Credit Bank of Texas, Dell Inc, and 3M.
Work at Purple Communications
David Cogan has been employed at Purple Communications, Inc. as a Senior SQL Developer since 2020. In this role, he focuses on database management and development, contributing to the company's data infrastructure. His responsibilities include providing on-call support to address errors from packages deployed on older SQL servers. Cogan's expertise in SQL development plays a crucial role in maintaining the efficiency and reliability of the company's data systems.
Previous Experience in SQL Development
Before joining Purple Communications, David Cogan worked at Farm Credit Bank of Texas as a Senior SQL Developer from 2018 to 2020. His tenure at the bank involved significant contributions to database management in the Austin, Texas area. Prior to that, he spent 11 years at Dell Inc. as a Senior Database Developer from 2000 to 2011, and 7 years at 3M as a Senior Database Architect from 2011 to 2018. His extensive experience in these roles has equipped him with a deep understanding of database systems and development practices.
Education and Expertise
David Cogan has a solid educational background in computer science and business management. He studied at Ashland Community College, where he achieved a degree in Computer Science and Business Management. He furthered his education at Marshall University, majoring in Computer Science. Additionally, he attended the Wiekle Real Estate Institution, enhancing his knowledge in real estate-related data management. This educational foundation supports his expertise in SQL development and database architecture.
Database Development Projects
Throughout his career, David Cogan has been involved in various database development projects. He has redesigned database structures to enhance table structures, views, and procedures. Cogan developed new SSIS packages to import data from MySQL to SQL, optimizing data integration processes. He also created SSIS packages to import data from new API structures, facilitating seamless data flow. His work includes migrating databases to SQL version 2019, ensuring compatibility and performance improvements.