Tommy Chan Email & Phone Number

Livonia, Michigan, United States

Daily work duties includes:Integrating CSV/XML/API data import/export processes (ETLs) between system endpoints;Troubleshoot complex client configuration related to timesheet, scheduling, labour management and payroll issues to provide ITSM support;Creating custom business reports, providing data analytics to ensure accountability to all employee related.

Windsor, Ontario, Canada

Technical lead of a project team implementing Workforce Time & Labour management system to streamline a variety of past-practice methods that tracked employee time and pay manually. A critical milestone of this project was integrating Workforce with our PeopleSoft HRMS, payroll and security systems, while maintaining data integrity and adhering to a.

Detroit, MI

Provided support to GM's Dealer Network Planning & Investment group in an onsite role. Organized, developed and delivered client-requested reports and other project deliverables on time, adhering to client requirements. Developed and tested business technical functions associated with customized client software and coordinated with team managers and client.

Windsor, Ontario, Canada

Created new SOPs and updated existing PeopleSoft queries, SQR reports and Excel macros to reduce manual processing hours by 20% per month within the HR department. Performed sysadmin duties for Continuum, the security system responsible for swipe access control of every corporate badge card and secured door pads.

Virtual

Created multiple SQL store procedures and table triggers to reduce integration and regression testing time by 20%. This was a result of the improved efficiency in finding the proper test participants when executing test plans. Also created training material to allow other members on the team to learn and duplicate the same process, which resulted in a.

Toronto, Canada

Implemented enterprise system upgrades and provided ongoing technical support for the Best Employers In Canada administration team by automating multiple ETL processes and past-practice business procedures. The result increased project profit by 10% and trimmed 900+ hours of manual labour annually.Converted our client data warehouses to integrate with the.

Toronto, Canada

Maintained the functionality for 40+ customized pension admin systems, databases and websites with 98% uptime and developed ETL enhancements to improve data integrity and process runtime by 10% per year. Upgraded multiple SQL queries, store procedures and table triggers to reduce integration and regression testing time to reduce client issue turnaround.

Toronto, Canada

Developed technical documentations and presentation materials for the training/information seminars regarding the online services provided by the companyMaintained frequent contact with subscribing users to provide training seminars and troubleshooting services related to our online reporting system

Windsor, ON

Reorganized the network structure to increase effectness on system servers, workstations and various mainframes under one manageable Windows Server 2000 network running SQL Server 2005 and legacy applicationsSetup a second domain controller for systems backup, load balancing and remote application deployment and arranged technical training to staff for the.

Bundang-gu, Seoul, South Korea

Provided guidance to children ages 5-13 to use the English language as a communication toolOrganized weekly lesson plans to layout activities and work topics for each classDemonstrated leadership skills to manage large groups of children to participate in art projects and science experiments

Windsor, Ontario, Canada

Performed Master of Ceremony host duties that required public speaking to crowds of up to 1000 people and provided nightly music entertainment for the patrons at the nightclubs.

Herzogenaurach, Germany

Liaised with the development team to gather business requirements for the initial launch of the mi-adidas project. This internship provided me with invaluable experience on managing daily tasks related to business-to-business and business-to-client projects. The result of this internship gave me the necessary training on how to develop effective business.

Widnsor, ON

This co-op position provided many valuable learning opportunities on industry standard systems development life cycles, methodologies and techniques in order to participate in the development of information systems using a standard, systematic approach. My role was to convert a variety of past-practice manual workflows into automated process with.