Tianyu Zhang

+1-414-***-**** ad4tdl@r.postjobfree.com www.linkedin.com/in/tzhang610

SUMMARY

Lead analytics professional managing customer journey, finance, risk and data projects and portfolio, optimizing strategies, recommending decisions, data mining/science, KPI dashboard visualization, coaching analysts, creating financial models. Engaged executives and over 100 employees from 20+ teams through over 10000+ dashboards views that drove 60+ business projects’ decisions; Designed national strategic plans to expand services to major 50 cities; Created financial models and business plans deciding $110 million investment acquisition.

SKILLS

●SQL, Tableau, Python, Alteryx, SAS, Snowflake, Dynatrace, Elasticsearch, Kibana, Hadoop, Grafana, AWS, Power BI, Salesforce, Github, Linux, Adobe Analytics, IBM Netezza, OBIEE, Oracle, R, Trello, Jira, Teradata, Microsoft Projects, Visio, VBA, C, Hyperion, SAP Crystal Reports, Argus, Access, QuickBooks

EXPERIENCE

Lead Data Analyst Frisco, TX

TIAA 11/2022 – present

●Used Python Natural Language Processing toolkit to dissect 8000 survey comments from omni channels to highlight complaint topics, sentiments and actions; set up workflows using Alteryx with data from across Snowflake, Hadoop, OracleSQLDeveloper, OBIEE and AWS postgreSQL to alert various product teams from web, call center and operations through notifications to fix top issues and connect with impacted customers.

●Created data queries standards using unstructured Telemetry data from Elasticsearch, Kibana and Grafana tools to link customer journeys from transactions like withdrawal, funding, forms across touchpoints on different platforms; identified bottlenecks and solutions of awaiting status that blocked request completion.

●Leveraged Dynatrace and Adobe Analytics platform to analyze web errors, user sessions and page flow to identify technical issues and processing inefficiencies; facilitated creation of a data application Journey Center to real-time track product performances, issues and guide downstream actions distributed.

●Managed and developed over 20+ production dashboards using Tableau/PowerBI and SQL on survey comments, sentiments, client and customer performances, web visit activities and fund flows and transactions from a variety of cloud data sources.

Lead Data Analyst / Manager Plano, TX

Toyota Financial Service 08/2019 – 11/2022

●Managed data sourcing, governance, mapping, transforming, improving, and validating risk strategy models for new consumer lending business; led a 5-people group collaborating across different functions through twice-weekly reviews, deep research to resolve bottlenecks of Python coding and SQL scripts, prioritizing tasks and managing expectations through communication and beating deadlines with agile methodologies.

●Redesigned and implemented scalable analytics solutions and efficiently engineered data pipelines using SQL, PowerBI, Tableau and Alteryx through generation, transformation, optimization of visualization, automation, and improving project management processes and saved 8 days per month and 873 business hours.

●Coached 10+ analysts across the enterprise on data structures, analytics using SQL and Python, dashboards, and efficiency; managed offshore staff through weekly meetings to prioritize tasks and suggest resolutions to issues; promoted better practice in the analytics community and gained SME recognition in related groups.

●Developed 100+ SQL-based reports in IBM OBIEE, Oracle, Snowflake and AWS databases; built 60 dashboards and over 130 pages using Tableau, Power BI and Alteryx on portfolio performance, collection strategies, deferral programs, dealer and debt servicing, and credit loss that led to 10000+ views including executive meetings.

●Won the Champion of Toyota Data Analytics Competition 2021 by leading a 3-people group competing against 50 participants and delivered 3 rounds of recommendations to senior executives; used Python natural language processing NLP libraries and text-mined hundreds of job descriptions.

●Designed A/B testing and validated hypotheses and managed the production of new strategies and saved 33 service employees through optimization of collection strategies and evaluation of impact; helped lowering portfolio delinquency and loss through deferral program adjustment during the early pandemic.

●Examined large datasets’ quality for model training/testing sets; evaluated effectiveness of classification and regression models through Confusion Matrix, AUC/ROC, ensemble models, VIF, outfitting testing, root mean square errors and cross-validation.

●Governed and evaluated data platforms’ integration, structures, metadata, data quality, enablement, usage, archiving, and validation of Unix, SAS, Tableau servers, and different data warehouses and marts.

●Managed IFRS and FASB attrition models and 15 SOX controls quarterly in OBIEE to forecast discounted cash flows and credit loss, and used macro-economic data through SQL from Moody’s and credit bureau to generate scenario analysis and stress testing to meet requirements from external/internal audit, legal and treasury.

Lead Analyst Dallas, TX

AT&T 01/2018 – 10/2018

●Used SQL server to extract and transform raw data from eCommerce, ERP, and vendors to data warehouses; identified data anomalies, correlations, and root causes of business inefficiencies using data mining.

●Used Tableau, Adobe Analytics, and other BI tools to analyze business data and forecast trends.

●Created weekly KPI dashboards with real-time data and presented visualization reports to executives.

●Managed reporting enhancement and reduced expense by 15% using the Agile development process.

●Designed business expansion plans to strategically increase national customer coverage by 100%.

●Designed A/B test experiments and recommended efficient layouts to increase 20% traffic.

Senior Analyst New York, NY

IHS Markit 05/2016 – 01/2018

●Evaluated and priced 7,560 global fixed-income securities on a daily real-time basis, covering valuation, benchmark, liquidity, and reference data of investment-grade and high-yield bonds.

●Programmed SQL and Python codes to profile bond reference and pricing data on ad-hoc analysis.

●Identified incorrect parsing and reference data during data warehousing; corrected data errors and communicated with developers to fix algorithm issues.

●Used Tableau to create visualized reports on product updates, improvements, and customer satisfaction.

●Researched corporate and market information to adjust pricing and added 1270 new issuance to coverage.

Financial Analyst Dallas, TX

OAXACA Interests 07/2013 – 04/2016

●Built 12 Excel-based leveraged buyout models to forecast cash flows, budget planning, and capital expense.

●Calculate funds and investors’ ROI using NPV/IRR methods through sensitivity tests and waterfall structure.

●Co-led 7 acquisitions and performed DCF/Comps valuation, fundraising, due diligence, and accounting.

●Managed asset transactions in syndicated secured loans, mezzanine loans, and equities funds.

●Used QuickBooks to consolidate monthly financial statements and monitor liquidity coverage risk.

●Created VBA Macros to automate stress /sensitivity tests and generate investor reports 10 times faster.

EDUCATION

Southern Methodist University Dallas, TX

Master’s in Finance

GPA: 3.6/4.0

●Finalist of 2013 Oil & Gas Investment Banking Case Competition, Houston

University of Wisconsin Milwaukee, WI

Master’s in Biological Sciences

GPA: 3.8/4.0 (with proposal and defended thesis)

●Chancellor’s scholarship award Outstanding UWM leadership

Lanzhou University Lanzhou, China

Bachelor’s of Science in Biological Sciences

ADDITIONAL INFORMATION

●Language: English, Mandarin

Contact this candidate