David Chamberlain Email & Phone Number

North Hampton, Nh, Us

Virtual

• Developing end to end applications using Excel VBA, relational databases and SQL• Leveraging experience in defined benefit plan operations to deliver value in client implementations and corporate actions• Collaboration with other defined benefit consultants and developers within an Agile Scrum environment• Trusted technical partner that collaborates closely with end users to understand and respond to business needs.• Take full responsibility on end-to-end deliverables (analysis, design, develop, test, and deploy)• Analyze and convert complex retirement plan requirements and develop and/or bug fix on Actuarial pension benefit validation platform that meets the scheduled release date provided using Excel, Visual Basic, VBA macros and Azure.• Complete detailed unit/acceptance testing and certification to ensure development is delivered on time and in conjunction with defined release management practices.• Ensuring designs meet performance, security, usability, and reliability and scalability requirements.

Virtual

Define data and processing requirements and facilitate user acceptance testing for global professional services firm offering wide range of risk, retirement, and health solutions in 120 countries. Leverage data and analytics delivering clients professional insights on how to reduce volatility and improve performance. Oversee Defined Benefit Plan administration with diverse set of technology tools including VBA, SQL, Excel, and Access.Key Accomplishments:• Created business solutions through advanced knowledge of Excel, VBA, SQL and Access completing highly sophisticated pension calculations with 100% accuracy.• Manipulated sophisticated macros to reconcile large data sets and streamline processes and procedures.• Oversee data quality and ensure database security fully documenting and updating processes and procedures and communicating progress. • Demonstrated exceptional work quality creating database tables, views, and functions.

Boston, Ma

Administered all defined-benefit (DB) and defined-contribution (DC) retirement plans with over $1 billion in assets for world-class teaching hospital of Harvard Medical School. Guided employees and retirees through all phases of DB and DC retirement and pension process from commencement, stop payments, to disbursement. Utilized database and spreadsheet expertise to facilitate expeditious delivery.Key Accomplishments:• Invented multiple spreadsheets tools for in excel for maximizing contributions considering plan limits and plan/system confines and calculating DB plan benefits and splits. • Created queries ensuring compliance with IRS, DOL, PGGC, and ERISA regulations• Protected data quality during complicated plan updates on disbursement agent payment system. • Established strong reputation for impeccable customer service skills working with plan participants, IT team members, and colleagues.

Bachelor Of Science, Business Administration, Dean’S List

Concentration: Finance

Certificate, Client/Server Programming And Web Development