LILI ZHANG

• Developed dynamic Tableau dashboards for cards, partnerships, and Enterprise Payments to improve analytics capabilities.
• Collaborated with Enterprise Payment Strategy team to analyze projects and derive actionable insights.

Project 1) Conducted analysis of digital wallet provisioning, indicating increased client engagement with provisioned cards.

Project 2) Analyzed international money transfers and cross-border transactions for strategy formulation support.

• Delivered projects promptly post-onboarding, showcasing swift adaptability.
• Utilized SAS, SQL, Python (with Copilot), DBeaver, Hue to manage large data ETL processes in Teradata, Datalake, Snowflake, and/or UNIX server environments.
• Advanced in Tableau. Led Tableau initiatives, leading in the team’s Tableau server consolidation and simplification efforts.
• Competent in Excel (VBA, Power Pivot, etc.).

• Produced insights on client frustration index alongside NBO data modeling team to identify key issues.
• Designed RBC media spend dashboard for improved strategic decision-making at the senior leadership level.
• Performed intake-to-delivery analytics of various campaigns for CRM marketing teams within personal banking and BFS sectors.
• Optimized fund transfers by analyzing inflow and outflow data between RBC and financial partners.
• Led management of trigger dashboard project, coordinating numerous campaigns during team transition.

• Conducted data analysis and reporting for RBC insurance marketing campaigns across multiple lines of business.
• Collaborated with stakeholders to gather data insights, manage ETL processes, and deliver performance insights.
• Developed Tableau dashboards and reports to facilitate strategic decision-making on a monthly and quarterly basis.
• Adapt to changes in clients' requirements on short notice.

• Retrieved large datasets from SQL Server, validating, and processing data.
• Conducted channel analysis to assess client purchase behavior, developing targeted marketing campaigns to boost conversion rates.
• Generated monthly summarized reports and dynamic visual dashboards using Excel and Tableau.
• Performed web intelligence analysis on registered clients, designing impactful web campaigns to enhance target client conversion rates.
• Executed segmentation analysis on return merchandise authorization products based on problem codes, producing monthly reports via Tableau.