Chris Lau Email and Phone Number

• Process improvement lead in the Global Risk Analytic Operation group who managed and drove multiple operational excellence initiatives: o Eliminated 100+ quarterly SAS manual scripts execution through the implementation of a SAS-based parallel model execution framework (SAS, Python, SQL and shell-scripting) o Automated and standardized the generation of 10+ 100+ pages long (including dozens of graphs and tables) quarterly ongoing monitoring reports for consumer retail forecast models by developing an automated documentation framework in Python, SSIS, SQL & LaTeX, reducing the processing time for each document from 3-4 days to a couple of hours. o Led the development of a python utility that synchronizes the macro file generation process using the pandas library, improving data integrity and reducing processing time from 2-3 days to a couple of mins. o Led the development of a couple of automated model diagnostics reports for credit card and mortgage loss/balance forecast models in SSRS and Tableau such as cross-cycle/cross-scenario forecast review report and benchmark model comparison report with Hive, pyspark, shell-scripting and SQL Server o Led the entire development of migrating legacy PSI process in SAS to Hadoop ecosystem, including gathering business requirement from model developer, developing codebase and communicating the results to senior management.• Managed and streamlined the model execution process of consumer retail loss models in collaboration with data management, mortgage/card/auto analytic team and technology partners, including the standardization and automation of 200+ end-to-end quarterly model runs

• Developed, enhanced and maintained a large-scale, robust and high-performance mortgage underwriting surveillance system which ingests thousands of government and corporate compliance rules , perform multivariate analysis across thousands of loan attributes and generates a list of strictly and potentially non-compliant loans covering the majority of loan programs offered by the bank using state-of-the art information management techniques in SSIS, C#, TSQL/PLSQL,MSSQL/Oracle.• Developed scalable and flexible database solution with robust concurrency control mechanism which supports a real-time web-based income analysis tool utilized by home service specialists to examine the income quality of loan borrowers.• Performed data requirement analysis for various business initiatives and implemented multi-platform dynamic ETL solutions that communicated across a proliferation of data platforms • Applied extensive credit risk knowledge in performing independent analysis on a large group of loan data to provide insightful recommendation for business partners to draft loan violation requirement. • Facilitated communication and collaboration among multiple business groups and translated business requirement into technical representation.• Performed periodical comprehensive system and process review to optimize resource utilization and maximize system performance.

• Developed and enhanced the Auction SMA application in C#.Net and SQL ( main developer ) - Added auto-save functionality that saves the auction data per min using the .Net multi- threading library - Modified the application to accept excel spreadsheet as input for auction data - Added new interfaces for traders to correct, cancel and approve trades - Optimized the database performance by utilizing advanced SQL techniques such as clustered/non-clustered indexes and Common Table Expression• Designed ETL solutions for market data stored in the Market database - Designed table schemas for storing the MBS pay-up data - Implemented the data import/export processes in C# - Created indexes and triggers to maintain data integrity• Supported traders’ daily operations such as providing ad-hoc queries and cmd scripts

• Revamped the official website of the UW Transportation Service Department, adding data driven web elements into the infrastructure and beatifying the design of web elements and remodeling the webpage layout in C#, ASP.NET ,SQL Server 2008 and JQuery• Provided constructive insights on the infrastructure of the revamped web portal to maximize user-friendliness and utility as well as minimize maintenance overhead. • Implemented a comprehensive content management system which comprises of an easy-to-use and elegant web interface and interactive content management functionality.• Use Photoshop CS4 and Illustrator CS4 to compose design element that meets web presentation standard and process the design elements for optimization purpose