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 errors to maintain accuracy and relevance.· Developed and optimized stored procedures for repetitive tasks, improving execution speed and resource utilization.· Partnered with finance, marketing, and operations teams to understand their data needs and provide tailored analytical solutions, ensuring data-driven decision-making across departments.

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 data, detected outliers, identified abnormal electronic usage accounts, and reported to the revenue team, preventing predicted revenue loss by 3%⠂ Designed a monthly report of all accounts that were billed with the reduced rate during the previous month and included rate and usage details to prove how many people used critical care and asked for compensation from the government.⠂ Developed automated SQL database and Tableau dashboards based on project needs; generated and presented reports with actionable insight through working with cross-functional stakeholders (e.g., clients, sales and revenue team, leadership) to continue to drive strategy optimization and data-driven decision making

⠂ 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 insights using collaborative filtering in Tableau for existing customers and newcomers with cold-start challenges⠂ Delivered $30K campaign by leading in customer lifetime value forecasting and personalized incentive campaigns for loyalty (e.g., “Dollar off” or “Meal on us”) based on subscribers’ recency, frequency, and monetary value, and presented campaign performance insights to the marketing team to help further campaign planning and optimization⠂ Contributed significantly to the development to Starve Bird marketing campaigns and enabled large-scale and real-time decision engines to be deployed at the request of stakeholders.

⠂ 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 regression for a 13-month monitoring period.

⠂ 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 a real time decision.⠂ Assisted with all policy renewals including compiling renewal data for underwriting submissions.

Master Of Science - Ms, Statistics

Bachelor Of Science - Bs, Applied Mathematics