James Lin Email & Phone Number

Toronto, Ontario, Canada

Toronto, Canada Area

- Utilized Microsoft SQL Studio to manage production and replication databases for applications to ensure accuracy and optimal functioning capacity- Implemented efficiency changes to the travel insurance software NIS Acturis that resulted in quicker processing times and quality of life benefits for the operations team resulting in improvements in SLA targets. This was done on both a front end and back end level via SQL Server procedures/scheduled jobs- Participated in routine application upgrades while analyzing key changes and providing support to users after change implementation- Built insurance products for various clients as well as overseeing the development cycle of these products from the development, UAT and production environments while adhering to policy launch deadlines- Part of an agile team utilizing JIRA to integrate clients within online claims portal system. Consists of daily scrum meetings, creating user stories from gathered business requirements and/or enhancements from analysis, participated in smoke tests prior to a promotion of enhancements/clients to live environment

Toronto, Canada Area

• Created and maintained a database to track all support tickets for any employee within the department ranging from low to critical priority to improve overall efficiency• Helped managed opened tickets and ensure that an unresolved ones were closed• Decommissioned applications servers and former employee assets to perform monthly cost reduction operations that achieved significant savings• Performed cost reduction operations to ensure proper resource management• Part of social committee and planned monthly events for the department with other co-op students to achieve successful events for various holidays and special events• Submitted ticket requests for employee assets and entered data entries in multiple databases to ensure data integrity

Toronto, Canada Area

• Created and edited existing reports that extracted data from client tracking system using Java expressions and SQL to easily analysis data for efficiency improvements• Organized data using Excel and uploading bulk data to the Canadian government database achieving proper data integrity of client information• Assisted coworkers with the use of the in-house client tracking system• Mentored clients in the basic use of PowerPoint and email drafting to transfer important computing skills for beginner users• Matched in house client tracking system with the Canadian government database to ensure that all client data are accurately reflected• Entered, deleted and modified client information on the client tracking system to ensure all information are up to date and achieving minimal data duplication