Anthony Vidmar
About Anthony Vidmar
Anthony Vidmar is a Data Architect at Advanced Drainage Systems, Inc., where he has worked since 2023. He has extensive experience in database management and business intelligence, having previously held various roles at OPERS from 1999 to 2023.
Work at Advanced Drainage Systems
Anthony Vidmar has been employed as a Data Architect at Advanced Drainage Systems, Inc. since 2023. In this role, he has led significant projects, including the conversion of over 1200 database tables from DB2 to SQL Server. He ensured data synchronization through a Change Data Capture process, which is critical for maintaining data integrity and consistency across systems.
Previous Experience at OPERS
Anthony Vidmar has extensive experience at OPERS, where he worked in various roles from 1999 to 2023. He began as a Programmer Analyst and progressed to Lead Programmer Analyst, IT Manager - Product Owner of Operational Data Store, and Senior Programmer Analyst. His responsibilities included managing data sources, enhancing Tableau workbooks, and spearheading database conversions to optimize data storage.
Education and Expertise
Anthony Vidmar holds a Bachelor of Science in Computer Science from DeVry University, where he studied from 1996 to 1999. His educational background has equipped him with the technical skills necessary for his roles in data architecture and programming. He has developed expertise in database management, Business Intelligence, and data warehousing throughout his career.
Achievements in Data Management
Throughout his career, Anthony Vidmar has achieved notable milestones in data management. He became the product expert on Toad Data Point and collaborated with Quest Software to implement significant bug fixes and improvements. He also played a key role in a Business Intelligence and Data Warehousing initiative, which expanded to include over 700 tables and more than 1000 weekly tasks.
Data Architecture Projects
In his roles, Anthony Vidmar has led various data architecture projects. He implemented a process to compare the contents of over 1000 tables weekly, managing nearly 1 billion rows of data. Additionally, he spearheaded a domain-driven database conversion to reduce redundant storage of sensitive information, such as Social Security Numbers and Personally Identifiable Information.