Eric P. Gerstmann
About Eric P. Gerstmann
Eric P. Gerstmann is a Manager of Healthcare Data Warehouse & Analytics at Envision Healthcare, where he has worked since 2013. He has extensive experience in database technologies, having previously held positions at Barnes&Noble.Com and Russell Reynolds Associates.
Work at Envision Healthcare
Eric P. Gerstmann has been employed at Envision Healthcare since 2013, where he holds the position of Manager for Healthcare Data Warehouse & Analytics. In this role, he is responsible for overseeing data management and analytics initiatives within the organization. His work involves utilizing a variety of Microsoft tools, including SSIS, DTS, SSRS, SSAS, DQS, and MDS, to deliver comprehensive data solutions. His tenure at Envision Healthcare spans over 11 years, contributing to the company's data-driven decision-making processes.
Previous Experience at Barnes & Noble
Prior to his current role, Eric P. Gerstmann served as the Director of Database Technologies at Barnes&Noble.Com from 2000 to 2008. During his eight years at the company, he managed database technologies and contributed to the development of data strategies that supported the organization's online operations. His experience at Barnes & Noble laid a strong foundation for his subsequent roles in data management and analytics.
Experience at Russell Reynolds Associates
Eric P. Gerstmann worked as an Inhouse Consultant and Senior SQL Database Architect/Senior SQL Developer at Russell Reynolds Associates from 2010 to 2013. In this role, he applied his expertise in SQL database architecture and development to support the firm's data needs. His responsibilities included designing database solutions and optimizing performance, further enhancing his skills in data management.
Education and Expertise
Eric P. Gerstmann earned a Bachelor of Arts degree in History from Rutgers University - Newark, where he studied from 1982 to 1986. His academic background complements his professional expertise in designing and developing data warehouse schemas, utilizing both Star and Snowflake models. He possesses extensive experience with Microsoft SQL Server, covering versions from 6.5 to 2012, and employs advanced SQL optimization techniques to enhance database performance.
Technical Skills and Best Practices
Eric P. Gerstmann is skilled in using various data modeling tools, including Embarcadero DBArtisan, Data Architect, and Erwin. He promotes database best practices and standards within his teams, conducting code and design reviews to ensure high-quality database solutions. His experience includes implementing Change Data Capture (CDC) and Change Tracking, which are essential for managing data changes efficiently in complex environments.