Bill Van Der Ende Email & Phone Number

Toronto, Ontario, Canada

Achievements:• Part of a small team that designed and developed a cloud-native analytics framework (Microsoft Azure Data Factory, Azure Data Lake, and Azure Synapse) to bring Trisura’s data analytics capabilities to the next level• Developed multiple ETL packages to facilitate data migration between three systems using SSIS, including migration between MS SQL and PostgreSQL server• Converted a premium system from Microsoft Access database to SQL Server, enabling use of SQL Server features (stored procedures, views, user-defined functions, scheduled tasks) to greatly improve the system• Led reporting system migration from MS Access to SQL Server Reporting Services (SSRS)• Instrumental team member of a full IT infrastructure migration that was completed on-time and on-budgetResponsibilities:• Maintain and develop an in-house premium and claims system• Order and track software and hardware purchase requisitions• Administer PostgreSQL and Microsoft SQL Server database servers• Monitor ETL tasks between several database servers• Maintain source code trunk and branches for all internal development projects• Liaise with business representatives and leaders to determine software requirements• Assist Senior VP Systems with budgeting process• Main resource for working with internal and external IT auditors• Primary build-master for our public e-commerce website

• Configured and maintaining game server infrastructure (Ubuntu LTS, MySQL 5.7, PHP 7, Berkeley DB 5.3)• Scripted an automated scheduled backup of the MySQL and Berkeley DB backups• Developed a registration web site that integrates with the game login• Perform additions and changes to game code using Lua scripting and C++• Oversight of version control, build, and promotion of code updates• Created a self-updating game launcher client using C#

Toronto, Canada Area

Achievements:• As Team Leader, managed a team of four developers of several in-house applications (VB6, C#, MS SQL Server)• Devised complex algorithms to model financial calculations (earned/unearned premium, quota share reinsurance premium/commission) for various lines of business• Converted legacy production data during two corporate mergers• Developed an automated two-way data transfer between premium/claim system and accounting system• Key team member of a large-scale conversion of a corporate accounting system (using stored procedures and SSIS packages)• Transitioned a significant amount of reporting operations from client-based processing to server-based processing (using stored procedures, views, and user-defined functions)• Successfully migrated SQL database servers over several product cycles (SQL Server 6.5 -> 7.0 -> 2000 -> 2005)Responsibilities:• Communicate/liaise with business departments and department leaders to determine requirements of information systems• Maintain, upgrade, and support SQL Server database servers in three nationwide locations• Compile, review, and test development team source code• Design test cases and test new builds of in-house applications• Administer database operations for all in-house applications• Maintain and upgrade data transfer procedures with parent company• Primary contact for external and internal auditors• Provide evidence of compliance for Sarbanes-Oxley (SOX) regulatory requirements• Migrate SQL Server 2000 DTS Packages to SQL Server 2005 SSIS• Monitor data replication between branch and head office SQL servers• Ensure database tables have optimized index structures• Team lead on all phases of the software development life cycle