Oliver Sin Email & Phone Number

Markham, On, Ca

Toronto, Canada Area

Toronto, Canada Area

• Developed a web based funding applications for Toronto Central Local Health Integration Network (LHIN) using .NET, MVC, JavaScript/HTML5/CSS, JQuery, Razor, Entity Framework and Bootstrap)• Develop backend database processes using SQL Server 2008 and 2014. (T-SQL, Stored procedures, triggers, scalar and table functions, full text search, file table, query tuning) • Create dynamic and complex reports using SQL Server Reporting Services SSRS.• Develop SOAP and RESTful web services for external and internal application integration.• Build integration and ETL processes to integrate data from various data sources using SQL Server Integration Services SSIS.

Gathered and define business requirements while managing the risks to improve business process and translating the requirements into system solution. Coordinate with end users to define engagement along with the project development and resource estimates. Reviewed detail designs and participated in coding review. Managed development/deployment standard and guidance. Analyzed technical issues and problems and suggested remediation options.• Lead the development team to create a Loyalty Card System (LCS) using J2EE, JSF, Web Services, Hibernate, JBoss and Oracle 11g database for a retail store chain. • Designed and developed a membership website and its corresponding backend rewarding system using ASP.Net, C#, JavaScript, JQuery and SQL Server (TSQL) for a pharmaceutical company.• Responsible for delivering services and managing CRM Solutions and Loyalty Program using Microsoft Dynamics CRM and other proprietary systems.• Implemented various marketing data analysis and ETL projects using SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Hadoop MapReduce and SQL Server Reporting Services (SSRS).

• Served as project manager and lead the team to implement a Human Resource Information System. • Streamlined the Point of Sales System (POS) for institute from its legacy environment to a three-tier architecture.

• As a project manager of the implementation of PeopleSoft HR management system (HCM 9.0) including Workforce. Payroll, Absent and Employee Self Service modules.• Lead a team to establish a B2B system to manage the data flows between internal and external trading entities using Sterling Commerce's Gentran Integration Suite as the B2B platform.• Design and implement various ERP projects under Oracle E-Business Suite 11i.• Develop (80% Coding, 20% Design) various accounting and manufacturing related projects using .Net Framework, C#, WPF, SQL Server (TSQL), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Manage a team of IT staffs to render IT advices and services. Duties include staff management, vendor management, outsourcing contract management, conduct tendering and other procurement activities.• Successfully developed various statistical and census related application for the 2006 Population By-census using DB2, C, Visual Basics 6.0, Java, JBoss HTML and Struts.

• Lead a team developed a Shipping Order routing system for a garment manufacturer. The system connects the vendor, factories and the freight forwarders through Standard Chartered Bank’s B2Bex platform using XML, ASP.NET, VB.NET and SQL Server 2000. • Lead a project team to reengineering Point of Sales System (POS) system for a sportswear department store using Visual Basics, C++ and SQL Server 2000.

• Lead the Scan and Pack project team that includes the development and implementation team. This project intends to build a package of products that can streamline the supply-chain management. It embraces and links all of the partners in the chain through the latest technology. The major technologies used are Web base application (C++, HTML, and Sybase), bar code scanning and Electronic Data Interchange (EDI).• Responsible for System Architecture Design, Analysis and Implementation of a Shipment Consolidation system. The system original was in mainframe platform. It was then re-engineer to client/server environment. The system was used a distributed database design and implemented in multiple countries. The system was used Oracle database located in RS6000s and Windows NTs. The thin client is developed in PowerBuilder 5.0 under Windows environments.

• Responsible for the design and development of a distributed data processing network which received orders on-line over 100 remote department stores. The application including order processing, inventories control, shipping, receiving, and invoicing. The system operates on IBM AS400 at the warehouses and remotely connected the head office’s mainframe system.

Master Of Arts (Ma), Mathematical Statistics And Probability

Bsc, Mathematics And Computer Science

• The Governor General’s Gold Medal • The Chancellor’s Prize • Bishop’s Memorial Prize in Computer Science