Meiling Wang Email & Phone Number

Kirkland, WA, US

Seattle, Washington, United States

Los Angeles, California, United States

Los Angeles, California, United States

• Collaborate with new and existing business partners to develop analytics adoption roadmap in advancing the current capability
• Mentor a team of 3 staffs and manage risk, communication, and delivery of multiple work-streams while helping managers in scoping and planning
• Transform gross-to-net revenue analysis process by designing, building, and testing ETL workflows, metrics, and Tableau dashboard with cross functional teams, saving thousands of hours
• Present the standard gross-to-net revenue workflow and dashboard to leaderships resulting in high adoption after launch
• Reduce manual hours by 90% for a fortune 50 company engagement by automating manual data pull from 25 disparate data source, converting low-accuracy profiling approach to full population validation and analysis, and.
• Identify operation deficiency by consolidating approval tracking reports from multiple systems and analyzing approval timing and patterns

Los Angeles, California

Washington, District Of Columbia, United States

• The client is thrilled with our pro bono service and decide to invest and scale up the projects.
• Created web parsers in Python to extract products and nutrition data from 6 retailers and applied fuzzy matching techniques to compute missing data
• Defined key business logic, performed exploratory data analysis, and applied optimization and machine learning algorithms to recommend products to procure in disaster area
• Crafted compelling stories, made insightful recommendations, and provided live demo of the final product (an App) to client leaderships

Greater Atlanta Area

• Discovered 2,000 exceptions that indicate the root-cause of an operation deficiency by extracting, combining, and validating data from multiple sources using SQL in the absence of a project manager
• Identified transactions not tied to the correct general ledger by mining text in Python
• Communicated with internal stakeholders and process owners to understand loan hierarchy and balance calculation across disparate data source and optimized SQL queries
• Predicted credit score of commercial customers by training and validating machine learning models in H2O and developing a custom grid search algorithm to tune hyperparameter

Washington D.C. Metro Area

-Assessed risks by analyzing financial and non-financial information extracted from S&P Capital IQ, Audit Analytics, and SEC fillings

Sugar Land, Texas Area

-Completed 18 IT control tests related to various business processes and information systems with minimal supervision while managing relationship with external auditors-Discovered the cause of $100k potential annual overtime abuse by analyzing and visualizing data from multiple dimensions -Consolidated and cleaned user access records extracted from 6.

Master Of Science - Ms, Business Analytics

1. Tools: Python, R, SAS, SQL, Tableau, Spark, PowerShell 2.Courses: Programming for Analytics, Visualization for Analytics, Data.

Bachelor Of Arts (B.A.), Accounting, Business Administration, And Math

1. Accounting Courses: Intermediate Accounting I, II, and III, Auditing, Fraud Examination, Accounting Information System, Cost.