Yadi Gong Email & Phone Number

Los Angeles, Ca, Us

Culver City, California, Us

Culver City, California, Us

Westlake Village, California, Us

Los Angeles, California, Us

•Improved and automated the data collection pipelines from writing complex SQL queries, fed into data manipulation R script, validated and loaded formatted output into visually impactful PowerBI dashboard reports to facilitate stakeholders’ decision-making process. • Built interactive visualizations for revenue forecasting on 1000k rows of live data, helping finance team gain quick access and insights into general revenue trend.• Wrote SQL queries to grasp data from databases for the related analysis and achieved automatic data collection of longitude/latitude from Google api based on the provided address.• Independently managed benefit-conflict-detection project for city council, directly reporting to Principle Deputy Controller to improve the financial management system and avoid benefit conflicts. Used NLP to detect human names in Python, cleaned data by developing algorithms to classify formats of names and address and using ngrams for typos, and applied string distance algorithms to fuzzily match 126,000 vendors and employees, to increase the identity identification accuracy to 90%.

Shanghai, China, Cn

• Sampled data from SAP and Oracle financial systems, implemented quantitative models in Excel to estimate potential misstatement risk for extensive accounting sections. • Conducted text analysis and predictive analysis to detect unusual records in the historical transactions, by using Python. Built unsupervised model, used PCA to conduct feature engineering, and used Tensorflow and Keras to detect anomaly.• Communicated with four local inventory warehouses of clients for physical counts and trained incoming interns.

● Assisted in contracting format processing for Regulatory Affairs and traders.Wrote payment instructions; participated in the whole process of operations for putting interest.● Conducted data collection from web scraping, data preprocessing, strategy back-testing, missing value datasets processing and feature engineering for FM department to monitor profit level of financial products using Python. ● Wrote self-examination documents and asset monitoring reports for Financial Markets Department to the China Banking Regulatory Commission (CBRC).● Participated in the following businesses: private placement, liquidity appreciation letter, ABS (asset securitization business), major shareholders' latest directed holdings of a large domestic company, structured bonds and trusteeship, daily reports of FTP (fund transfer price).

●Worked as an intern in the departments of AR (Account Receivable), AP (Account Payable), travel claims, Tax, Cost Management, etc. Learned SAP financial system, and the processes of goods orders and settlement.● Studied the mergers and acquisitions (M&A) process and basic operations of consolidated statements for large multinational companies, due to the whole integration of financial systems and reporting processes during the acquired time of Freescale.● Conducted research on the principles and operating procedures of Transfer Pricing cooperated by Freescale and PwC, and learned general Transfer Pricing models of other multinationals, at the Tax Department.

Master Of Science - Ms, Business Analytics

Bachelor'S Degree, International Accounting

Exchange Student, Economics

Summer Session Student, Security Analysis And Computing For Applied Science