Lawrence Luo

Senior System Analyst @MCAP

Waterloo, ON, CA

MCAP is the largest independent mortgage financial company in Canada, as Senior System Analyst I’m focus on:• Analyzing and documenting mortgage/loan/bank financial markets business requirements• Developing various SQL Server Reporting Service (SSRS) reports to analyze different Mortgage/Loan/Payment/Trial Balance/General Ledger/Investor Remittance/Disbursements/Funding/Principal Interest/Deferred Fees/Borrower Statement financial activities.• Developing SSIS packets by SQL Server Integrate Service to ETL loan management system data to DW• Developing MS SQL database/Data warehouse/Business Intelligence environment• Developing SharePoint BI portal • Developing T-SQL SQL query script, Stored Procedure, function, view• Developing by.Net Framework, C#, VB.net, Windows batch, PowerShell• Installing and managing Precision Loan Management System (SS & C)• Developing SAP BO/Crystal Report• Developing QlikView BI/Report/Data Visualization• Developing Cisco Workload Automation (Tidal) scripts to make SQL jobs, Windows jobs, IBM iSeries, SharePoint BI reports works automatically every midnight • Working based on Agile methodology.