Lin (Vera) Deng Email & Phone Number

Toronto, On, Ca

Shenzhen, Guangdong, China

Toronto, Ontario, Canada

Toronto, Ontario, Canada

- Support the reporting and analytics lead in Sales/CRM to deliver tactical and strategic intelligence capabilities- Reviewing and amending client interaction data. Building and scrubbing data sets for analysis, review and invoicing of clients- Perform moderately complex technical tasks such as running code and creating reports, using tools such as Excel, SQL, or other Business Objects- Assemble, compile, and analyze data; assess data quality and resolve data issues- Effectively communicate operational and analytical results to management, summarize and interpret data and findings- Work with other partners including business management, finance, technology and middle office to drive change management initiatives

Toronto, Canada Area

• Extracted large amount of data from the database (Teradata) using SQL including join procedures and sub-queries• Explored the credit risk rating data from different rating agencies and developed customized graphs and diagrams to visualize rating distribution and trends in Tableau• Utilized a series of advanced SAS procedures to perform collateral transaction analysis and credit risk reporting• Produced effective credit risk reporting using SAS macros to automate the process of rating transition matrices generation

Canada

• Conducted a statistical research project on the topic of measuring the effect of minimum wage on income inequalityacross Canada in the past twenty years• Performed data cleaning on the raw data collected from Statistic Canada (handling outliers, duplications and missingvalues using SAS (PC/EG)), variable transformation and statistical tests (heteroskedasticity and autocorrelation)• Built a Feasible Generalized Least Squares to capture fixed and random effects and compare with other benchmarkmodels to enhance research feasibility• Presented the research result to supervisor and peer group members and provided constructive critique (feedback)to others in workshops

China

• Promoted a business plan to potential equity investors of an aluminum formwork enterprise• Performed competitor pricing analysis using Excel (PivotTable and VLOOKUP) and SAS to generate summarizedWeekly report to management• Collaborated in a team environment to design strategic business model and develop a pitchbook to present historicalresults and drive insights for the business plan• Created an automated Tableau return on Investment report on a weekly basis and distributed to private investors