Michael Chung Email & Phone Number

Edmonton, Ab, Ca

Gathered and analyzed business requirements for development of SSRS financial reports. Primarilyfocused on presenting forecasting data for Operating, Capital, and Salaries modules. Built and maintain SQL 2012, 2014, and 2016 database servers, scripts, indexes, and complexqueries in SSRS for data analysis and extraction. Experienced in performance tuning, monitoring, troubleshooting, and optimization of SQL databasesusing tools such as SQL Database Engine Tuning Advisor… Show more Gathered and analyzed business requirements for development of SSRS financial reports. Primarilyfocused on presenting forecasting data for Operating, Capital, and Salaries modules. Built and maintain SQL 2012, 2014, and 2016 database servers, scripts, indexes, and complexqueries in SSRS for data analysis and extraction. Experienced in performance tuning, monitoring, troubleshooting, and optimization of SQL databasesusing tools such as SQL Database Engine Tuning Advisor, SQL Profiler, and SentryOne Plan Explorer. Created and maintained Stored Procedure ETL mappings between Questica Budget and otherfinancial data sources (.csv, Excel Files, Dynamics GP, SoftVelocity: Clarion) Show less

Edmonton, Canada Area

Responsible for major upgrades of customized software, SQL development and maintenance, and gatheringtechnical business requirements.Key Contributions: IT lead of major disability process management system upgrade. In charge of deployment, datamigration, and integration of multiple enterprise systems. Three year project costing roughly$3,000,000. Implemented new claim type within Disability Management System in six months utilizing productbase functionality… Show more Responsible for major upgrades of customized software, SQL development and maintenance, and gatheringtechnical business requirements.Key Contributions: IT lead of major disability process management system upgrade. In charge of deployment, datamigration, and integration of multiple enterprise systems. Three year project costing roughly$3,000,000. Implemented new claim type within Disability Management System in six months utilizing productbase functionality. Provided solutions and alternatives in lieu of third party customizations, savingthe company over $100,000. Gathered business requirements and developed solutions using C#, SQL, .bat scripts, and PowerShell.Identified and automated slow business processes with in house applications collectively savinghundreds of hours of manual work annually. Passionate about saving time and money, utilizing SQL Jobs Scheduler and Windows Task Schedulerto automate redundant tasks. Show less

Vancouver, Canada Area

Created a web service that allows partnered companies to provide their information for a database operated by TerraTap. These companies would then be able to view other partners and their services offered from a TerraTap website.- Developed a normalized SQL database to store company and contact information.- Connected back end Java to communicate with front end PHP using RESTful web services. - Implemented GET, PUT, POST, and DELETE Java functions to handle URI requests.

Vancouver, Canada Area

Produced two visually appealing desktop applications to help students learn aspects of coding.- Two animated applications would prompt the user to either: • Select the correct block of missing code from a list provided. • Place mixed up code into the correct order.- Developed the front end of the application using ASP.NET and C# for the back end.- Questions for the game would be remotely uploaded by the professor using a Microsoft Excel… Show more Produced two visually appealing desktop applications to help students learn aspects of coding.- Two animated applications would prompt the user to either: • Select the correct block of missing code from a list provided. • Place mixed up code into the correct order.- Developed the front end of the application using ASP.NET and C# for the back end.- Questions for the game would be remotely uploaded by the professor using a Microsoft Excel file.- The user would be given a rating based on their score and the time taken to complete the questions. - Users would be required to log in and their stats would be recorded on a separate server. Show less