Mengyi(Maggie)Wang

214-***-**** Dallas adg5v2@r.postjobfree.com linkedin.com/in/mengyi-maggie-wang-62316968

• SKILLS: SQL, SSRS, Python, SAS, SAS EG, PowerBI, Tableau, Hadoop, Spark, Crystal Reports, Advanced Excel, Servicing Director

• CERTIFICATE: Certified Base Programming for SAS 9 BUSINESS EXPERIENCE

Data Service Analyst, Real Time Resolutions Inc., Dallas, TX March 2019-Current

• Build 20+ Exception Checks by T-SQL to capture erroneous data and improve deficient processes in an effective manner

• Develop stored procedures for 130 investors by compiling T-SQL to implement the latest financial functions of loan data points

• Create and deploy 5+ ad-hoc SSRS automated reports for operation teams using MS Visual Studio and SQL Server

• Establish template procedures and documentation for fixing various loan issues by T-SQL and advanced excel

• Generate 20+ ad-hoc reports and compile daily collection reports using SQL Server and Advanced Excel functions

• Build and updated 30+ rpt letters and map terms with stored procedures or views using SAP Crystal Reports and SQL Server Business Analyst Intern, Real Time Resolutions Inc., Dallas, TX October 2018-December 2018

• • Accelerated the process of service release, charge off, and reactivate loan by collaborating with operation team

• • Reconciled and imported data accurately, promptly and insistently, which largely increased overall efficiency of report delivery

• Analyzed inconsistent data population via SQL programming which significantly increased the normalization of database

•

• Audit and Data Processing Intern, PricewaterhouseCoopers LLP (PwC), Tianjin, China July 2014–August 2014

• Manipulated and analyzed financial data through SAP and MS Excel which boosted the efficiency of semi-annual tax auditing

• Generated consolidated financial statements for 70+ entities to analyze the discrepancies between subsidiaries and the parent company by quickly learning and utilizing PwC’s customized data processing tool and knowledge of financial statements ACADEMIC PROJECT

Car sales Data analysis using SAS Enterprise Guide August 2020

• Generated SUV sales report by filtering the origin in Asia and USA and sorting out the distinct observations

• Pulled SAS Summary Statistics and Summary Table that shows average invoice summary by vehicle type and origin

• Used Query Builder to obtain any Make which has invoice price greater than their average price and calculated order discount House Price Model Prediction in Python July 2020

• Predicted house price using linear regression model and optimized model to reduce overfitting by build Ridge regression

• Evaluated the training and testing linear regression model using residual scatter plot, MSE and R square Real-World Financial Analysis in Python May 2020

• Measured and visualized securities’ rates of return, covariance of securities and portfolio risk using python

• Forecast stock prices with multivariate regression model and monte carlo simulation using python Home Credit Default Risk with Python January 2020

• Analyzed and visualized the correlations between borrower’s features and the possibility of repaying a loan using python

•Built default model by logistic regression and random forest to predict default risk of borrower by the most relevant features Morris Marketing Analytics Competition (one of six finalists) September 2018

• Analyzed and visualized customers’ and competitors’ demographics and life styles using advanced Excel and Tableau

• Used Logistic Regression to bundle products, built RFM and Random forest model to segment customers by Python Transportation Tools Sales Visualization with Tableau April 2017

• Visualized sales performance of transportation tools via Tableau into sales growth chart, pie chart, segmentation dashboards etc., to display sales growth and distribution which helps us decide the profitable segment we should develop EDUCATION

Master of Science in Business Analytics, The University of Texas at Dallas December 2018 Bachelor of Science in Accounting, Tianjin University of Finance and Economics, Tianjin, China June 2015