Tingyi (Vivianna) Lu Email & Phone Number

Austin, Tx, Us

Lincolnshire, Il, Us

• Developed Comprehensive Analytical Datasets: Leveraged BigQuery to create and implement comprehensive analytical datasets, optimizing standard reporting processes and empowering data-driven decision-making.• Built User-Friendly Tableau Applications: Designed and developed multiple user-friendly Tableau applications that provided actionable insights to the customer success team. These applications enabled efficient and accurate access to crucial customer usage information, resulting in enhanced customer satisfaction.• Cost Optimization in Google Cloud: Implemented query efficiency optimization techniques, leading to a significant reduction in usage costs for Google Cloud services.• Ensured Data Integrity and Accuracy: Resolved data inconsistency issues by performing thorough data analysis and cross-validation. Identified root causes and implemented effective solutions, ensuring data integrity and accuracy across all reporting processes.• Delivered On-Demand Data Analysis: Provided on-demand data analysis support to the customer success team, enabling them to make informed decisions and respond proactively to customer needs.

Austin, Tx, Us

• Led company wise BI function and initiated end-to-end monthly business intelligence reporting by integrating data from multiple sources and developed innovative Tableau Dashboards to track KPIs and identify improvements with the reporting process • Reduced FinPath platform cost by 20% after implementing and automating a procedure to identify and remove 9800+ ineligible participants from the database • Optimized performance tracking KPIs and provided actionable insights to reduce participants’ churn rate • Improved business workflows at the system level by collaborating with Tech Team to troubleshoot issues and provide platform users well documented guide with solutions

Hoboken, Nj, Us

Toronto, On, Ca

•Data Quality Assessment -Analyzed potential data quality issues using Excel such as Accuracy, Completeness, Consistency, etc. -Communicated actively with the client to identify data quality issues and strategies to mitigate in future•Data Insights -Explored the customer and transaction data regarding underlying trend, feature selection and transformation, modeling and reporting-Presented interim plan to Sprocket Central Pty Ltd’s executive of the detailed approach for completing the analysis•Data Insights and Presentation -Established RFM model in Python by creating the three matrices, i.e. Recency, Frequency and Monetary-Deployed the RFM model for customer segmentation in Tableau; visualized the Top 1000 customers with highest RFM score and their segmentation-Created Tableau Dashboard for deliverables; proposed to Sprocket Central Pty Ltd’s marketing team customer targets and strategies to grow their business

Hoboken, Nj, Us

For course " Database Engineering" at Financial Engineering Department.

Cn

• Client Analysis - Won the Financial Advanced Individual Award by building classification models (KNN, Logistic Regression, Random Forest) in Python to predict whether a customer will leave the bank based on over 2,000 customer information ike demographics, balance, number of products, and proposed a new strategy of ‘Cross Marketing’ based on the result• Customer Expansion - Improved customer base by 40% through strengthening the analysis of the marketing research data using SQL and adjusting the marketing strategy to meet customers’ financial needs• Customer Maintenance - Leveraged customer retention rate by 20% through analyzing customers’ most recent three year daily activity data, discovered cohort patterns, and provided customized recommendation for their optimal financial products• Risk Analysis - Reduced credit card default rate by 80% through monitoring and analyzing customer's credit card usage and consumption, highlighting the customers with high default risk • Communication & Reporting - Acted as the liaison between customers and Product Department; prepared analysis report and product introduction using Tableau and Powerpoint slides

Cn

Master'S Degree, Business Intelligence & Analytics

Accounting