Adam Westermann
About Adam Westermann
Adam Westermann is the DB Client Calc Automation Systems Manager II at Alight Solutions in the United States, with a background in benefits management and analysis from Aon Hewitt and a degree in Statistics from Northern Illinois University.
Title and Current Role
Adam Westermann currently holds the position of DB Client Calc Automation Systems Manager II at Alight Solutions in the United States. In this role, he manages automation systems that streamline and improve calculation processes for Defined Benefit clients.
Previous Work Experience
Adam Westermann has a strong background in benefits management and analysis. He previously worked at Aon Hewitt as a Benefits Manager from 2012 to 2014, following a 4-year tenure as a Benefits Analyst from 2008 to 2012 in the Greater Chicago Area. His experience at Aon Hewitt focused on benefit-related analytics and management responsibilities.
Education and Expertise
Adam Westermann completed his Bachelor of Science (B.Sc.) in Statistics at Northern Illinois University, where he studied from 2003 to 2007. He possesses expertise in data analysis, actuarial valuation, SQL, and Excel/VBA.
Development and Engineering Projects
Adam Westermann has developed several important tools and projects in his career. He created a Python-based calculation engine for actuarial valuation, utilized by Defined Benefit client teams. He engineered a dynamic data analysis tool employing SQL table architecture and stored procedures for participant data comparison. Additionally, he designed and built coder and user-specific tools in Excel linked to SQL for complex data mapping, updating, and validating.
Training and Mentoring
An active mentor and trainer, Adam Westermann leads Microsoft Excel training sessions for new hires and colleagues. He manages and trains colleagues on enhancing features for annual actuarial valuation processes using custom-built tools. His training initiatives extend to both off-shore and on-shore colleagues, focusing on Excel/VBA, SQL Server, Access, and Defined Benefits for client projects and batch testing.