| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLE EMAIL AVAILABLE LINKEDIN LINK AVAILABLESUMMARYLead 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.SKILLSSQL, 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, QuickBooksEXPERIENCELead Data Analyst Frisco, TXTIAA 11/2022 presentUsed 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, TXToyota Financial Service 08/2019 11/2022Managed 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 Moodys and credit bureau to generate scenario analysis and stress testing to meet requirements from external/internal audit, legal and treasury.Lead Analyst Dallas, TXAT&T 01/2018 10/2018Used 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, NYIHS Markit 05/2016 01/2018Evaluated 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, TXOAXACA Interests 07/2013 04/2016Built 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.EDUCATIONSouthern Methodist University Dallas, TXMasters in FinanceGPA: 3.6/4.0Finalist of 2013 Oil & Gas Investment Banking Case Competition, HoustonUniversity of Wisconsin Milwaukee, WIMasters in Biological SciencesGPA: 3.8/4.0 (with proposal and defended thesis)Chancellors scholarship award Outstanding UWM leadershipLanzhou University Lanzhou, ChinaBachelors of Science in Biological SciencesADDITIONAL INFORMATIONLanguage: English, Mandarin |
