Ken Yim Email & Phone Number

Toronto, Canada Area

Toronto, Canada Area

- Developed various C# applications and processes to reduce duplicated tasks every week and extended ChangePoint functionality.o Developed C# application connected to ChangePoint database every week to search 500+ resources and corresponding approvers, generated emails for reminding resources to submit time and approvers to approve time.o Developed C# application and ran every 5 minutes to detect and create Project in ChangePoint automatically and granted corresponding permission… Show more - Developed various C# applications and processes to reduce duplicated tasks every week and extended ChangePoint functionality.o Developed C# application connected to ChangePoint database every week to search 500+ resources and corresponding approvers, generated emails for reminding resources to submit time and approvers to approve time.o Developed C# application and ran every 5 minutes to detect and create Project in ChangePoint automatically and granted corresponding permission through ChangePoint Web Services.o Integrated C# application into ChangePoint workflow to send approval email. Also developed another C# application to connect to Outlook mailbox account to check the approval response and move ChangePoint workflow to next step.o Automated workflow process in ChangePoint through Stored Procedures and Web services. Result of time saving and increased accuracy. o Implemented ETL (Extract, Transform and Load) process to migrate different timesheet data sources (Over millions of records) into single database through SSIS. It significantly improved the process time from 2 hours to 10 minutes.o Developed Pivot table report in Excel connected to OLAP cube database through SSAS in SQL Server. Provided instruction and training to Project Managers.o Developed and supported SSRS report by using ASP.NET and published to ASP.Net website.- Created and maintained tables, Views and Stored Procedures in SQL Servers.- Customized SharePoint and Project Sites by using CSS, JavaScript and web parts. - Administrated SharePoint and Project Server (500+ resources) including user and group permission setup, project plans management, Project Sites management and customization, out-of-the box workflow setup and maintained, Project Server OLAP cube database administration, project plans and sites backup and restore.- Maintained PHP and MySQL based report application, ensure it’s working all the time. Show less

- Analyzed Business problem, provided technical solution and support.- Developed and maintained tables, Views and Stored in SQL Servers.- Implemented Loblaw intranet site with Flash support into SharePoint with CMS functionality. It is significantly reduced Business time to update content.- Implemented 15+ Banners (such as Loblaws.ca, shopnofrills.ca, superstore.ca etc.) in Reddot. Allow Business to update content in ease.- Developed SharePoint InfoPath form in customized… Show more - Analyzed Business problem, provided technical solution and support.- Developed and maintained tables, Views and Stored in SQL Servers.- Implemented Loblaw intranet site with Flash support into SharePoint with CMS functionality. It is significantly reduced Business time to update content.- Implemented 15+ Banners (such as Loblaws.ca, shopnofrills.ca, superstore.ca etc.) in Reddot. Allow Business to update content in ease.- Developed SharePoint InfoPath form in customized approval workflow and integrated Remedy. Result of reducing form process time and people effort.- Developed custom list and workflow in SharePoint to transfer 10+ fields from the list to Word document and copy different set of files (more than 10+ Word files in a set) to destination depends on the selection in the list. It’s significantly reduced manual process time and mistake. Show less

Computer Programming And Operating Diploma, Computer Programming, Specific Applications

Web Page And Site Design Certificate, Web/Multimedia Management And Webmaster