Qingyang Wang Email & Phone Number

Mountain View, Ca, Us

Gb

• Analyze product feature data sources and pipelines and work with engineering team to identify product risk for high profile social media client, develop data visualization and dashboards to communicate findings to non-technical stakeholders• Perform testing on design of controls of feed ranking algorithm to reduce problematic and low-quality content, verify the effectiveness of metrics and alerts developed for monitoring health with analytical testing procedures using Presto queries for high profile social media client• Conduct end-to-end testing of revenue computation process for 3 digital platform clients, developing SQL queries to extract large volume of transactional data from data warehouses and recompute key FSLIs to validate ETL pipelines and ensure financial reporting accuracy and compliance to support audit team delivering report within critical deadlines• Lead offshore resource team to perform Account Payable (AP) Analytics to identify unique payment patterns and find hidden leases using Python and SQL to help software clients assess and monitor risk• Coordinate with client and manage offshore team to implement IA SOX compliance testing over key Information Technology (IT) process for 80+ controls in 20+ systems and identified potential gaps and remediation plans for web infrastructure client

Gb

Earned Data Analytics and Machine Learning badges displaying knowledge on advanced data analytics tools to help clients evaluate and manage business risk.

Zurich, Ch

• Utilized Python to scrape 20+ years financial filing data from SEC EDGAR website, creating a clean and consolidated dataset• Applied different feature engineering techniques to build machine learning models which resulted in predicting the target of investor activism• Analyzed the impact of investor activism on the risk and return of stocks using regression models

Gb

• Created and consolidated 2 data analytics dashboards using Tableau to help the client assess and monitor risk with Oracle/SAP ERP systems during M&A process• Performed Journal Entry Testing using Python and SQL queries to insure financial reporting accuracy and compliance to support auditing team for 10+ client companies• Created bots using Robotic Process Automation (RPA) tools such as Alteryx and Automation Anywhere to reduce repetitive workload and improve efficiency

Dallas, Tx, Us

• Booked 50 journal entries and allocated over million dollar costs in SAP system to support 6 monthly financial close processes for 3 EMEA legal entities, ensuring accurate financial reporting according to US GAAP and local statutory law• Conducted cash and exposure forecasting for Texas Instruments France monthly with Business Planning and Consolidation application, reducing currency risk by 50%• Reconciled 20 cash accounts with bank statements on a weekly basis using Electronic Banking System and SAP system, analyzing uncleared items and minimizing cash-in-transit balance • Calculated and reported tax liabilities for Texas Instruments France both to local authorities and internally using Excel, ensuring compliance with tax regulations

Herzogenaurach, Bavaria, De

• Created and updated 4 seasons’ product information in adidas’ internal databases, providing accurate information for operation team to place manufacturing orders to factory • Generated 12 sales reports for Creation Center Shanghai athletic products on monthly basis with data cleaning, integration and transformation from different data sources, presenting overview of sales and references for future planning• Classified and organized 400 samples and created sample hangtags using Excel, conveying information including product tracking number, retail price, margin and sales volume, etc. • Built 40 merchandising boards with detailed information of 500+ products to improve efficiency by 50% for cross-functional meetings• Organized focus group of 54 participants to collect consumer insights on products and visualized feedback to charts and diagrams using PowerPoint

Master Of Science - Ms, Business Analytics

Bachelor Of Business Administration (Bba), Finance And Accounting

Bachelor Of Management Science