Sam Cheng Email & Phone Number

Placentia, CA, US

Buena Park, California, US

· Enhanced the performance of SQL queries by implementing indexing strategies, optimizing JOIN operations, and refining WHERE clauses. Reduced query execution time by up to 50% through meticulous analysis and tuning. · Generated reports for relevant stakeholders based on user requests. Modified existing reports with new conditions and resolved report.

Plano, Texas, US

⠂ Developed complex SQL queries to extract electricity usage data, applied advanced data cleaning and processing techniques to ensure data quality and integrity in SQL under heavy workloads (4M+ electricity usage data), greatly improving data processing and analysis efficiency by 20%⠂ Used Tableau to build automated dashboards to track electricity usage.

⠂ Built monthly reports to track sales and revenue performance in Tableau, and provided recommendations around recommendation engine and promotion events, helping increase sales and revenue by 10%⠂ Influenced more than $100K of sales revenue with the development of a recommender system over partnered restaurants (“You may also like”) based on analysis.

⠂ Participated actively in the development, implementation, delivery, and maintenance of financial models following model risk management (MRM) guidelines.⠂ Responsible for back-testing and forecast-testing on the probability of default (PD) model. The proposed model showcased a performance lift (PD error rates) by approximately 8% using logistical.

⠂ Oversaw maintenance of access database consisting of all historic and current insurance information.⠂ Developed software systems for data entry, renew, cleaning, and analysis for insurance policy.⠂ Built weekly reports and monthly reports of all insurance policy renewal and presented to the leadership and sales and revenue team in order to help them make.

Master Of Science - Ms, Statistics

Bachelor Of Science - Bs, Applied Mathematics