Canny Wei Email & Phone Number

Atlanta, Ga, Us

Atlanta, Georgia, United States

• Developed and maintained loan data dashboards by SQL, Power BI, Excel Power Query, ensure accuracy from million rows datasets on daily bases, boosted the revolution of automated BI to replace manual Excel work. Made frequently updates based on requirements from sales manager/product manager/underwriter.• Optimised existing system, work closely with data engineers to accelerate query performance or resolve data issues. Cooperated with quantitative modelling team, built new credit scorecard models for loan approval and reduce losses from charge off.

Boston, Massachusetts, United States

• Quantitative data research project with State Street Global Advisors, constructed a Python-based frame for portfolio testing and visualization, analyzed dataset over 8 million rows, performed in-depth EDA and comprehensive overview of trends.• Using K means and random forest method to classify and predict the market regime through time series of 20+ macro indexes, building robust strategies using machine learning approach.

Deerfield Beach, Florida, United States

• Designed data models/flows/ETL pipelines, modified complex SQL queries and DAX functions, developed automated Power BI dashboards from IBM Db2/Mainframe/Oracle/NetSuite databases, processed large datasets of 10 million claims worth 80 million dollars, replaced manual Excel processes with business intelligence tools.• Analyzed and visualized dynamic claim rates of insurance product to provide operation strategies for stakeholders from financial accounting department. Cross-functionally assisted warranty department with monitoring vendor quality by calculation and visualizing in products failure rate.• Inspected and tracked down the detail of data defects in databases by data transformation/normalization using SQL and Power Query, worked with IT/data engineer to clean data and optimize queries performance, saved thousands of dollar losses caused by data corruption, ensure accuracy and reliability.

• Analyzed financial assets data by SQL and Excel, assisted with the development of KPIs, processing dataset over 100,000 rows, helped manager achieve quarterly goals of deposit growth and product sales.• Create interactive business intelligence dashboard by Power BI to visualize business data, delivered weekly report to help stakeholders monitoring performance of branches, speed up decision making.

• Utilized Excel to collect, analyzed and visualized operation data for over 400 stock accounts, support increase revenue in commissions.• Evaluated and built risk models, recommended investment plan according to risk assessment and communication result for more than 600 clients.

Master Of Science, Business Analytics

Graduate with distinction

Bachelor Of Science - Bs, Financial Mathematics

President’s Honour Roll, Academic Scholarship(2020-2021), Outstanding Graduation Thesis(2022)