Mia Wang Email & Phone Number

Hayward, Ca, Us

San Ramon, California, United States

* Data Analysis & Reconciliation: Analyzed and reconciled financial data in Excel and ASC, improving accuracy for pension plan valuations and compliance testing, leading to more efficient reporting and decision-making processes;* Database Management: Managed pension plan and clients databases, optimize queries, and generate reports in MS Access, enhancing database performance and streamlining benefit distribution processes with a 15% reduction in processing time;* Regulatory Compliance: Prepared government filings and reports, ensuring 100% adherence to pension plan regulations, reducing audit risks and maintaining client trust.

Sunnyvale, California, United States

* Budget Control: Oversaw budgets for production, and venue expenses, utilizing Google Sheets to track and allocate resources efficiently. Implemented strategic cost-saving measures, reducing actual expenses by 20%, saving $220+ out of a $1,100 budget. Regularly conducted financial reviews to ensure the project remained under budget; * Project Management: Managed multiple projects at Monday.com by coordinating with various guest teams to confirm requirements and organizing interviews through live-streaming events. Developed detailed project plans to ensure smooth execution, resulting in a 30% increase in active user engagement; * Human Resources Management: Attracted and engaged volunteers by creating promotional materials in LUMA and organizing them to execute marketing activities. Managed schedules to meet deadlines which contributed to attracting over 2,000+ live viewers during streaming events.

Hayward, California, United States

* Database Construction: Established an Autonomous Database in ORACLE Cloud by creating data warehouse, allow user to access database actions and upload files into database; * ETL Process: Led the end-to-end ETL process by extracting rows of vehicle insurance claim data, transforming it through data cleaning and validation using Python, and loading the processed data into an ORACLE Cloud Autonomous Database; * Data Analysis: Utilized ORACLE SQL to select and filter columns, discovered key features of suspicious claims through detailed exploration, developed plots with automatic dashboard for visual representation, and offered the features as references for fraud detection in the subsequent supervised learning phase; * Machine Learning: Built One-Class SVM machine learning model based on ORACLE SQL, predicted probabilities of fraud for each claim and ranked the claims using window functions, which generated a clear understanding of each claim.

Nanjing, China

* EDA: Retrieved and aggregated data from POS and ERP system and compiled it into a digestible and actionable format, performed explanatory data analysis on periodic sales trends and customer distributions in Python; * Variance Analysis: Used Excel and Pivot tables to analyze sales and raw material inventory, assess monthly raw material usage, work with department managers to review financial performance, explain budget-to-actual variances, and recommend corrective actions where necessary, reducing COGS by 10% and saving $2,000; * Vendor & AP Management: Managed daily communication with vendors to confirm and track purchase orders, verified invoices against orders, and oversaw on-site receiving of goods. Collaborating with the finance team to control accounts payable cycles and improve payment efficiency; * Marketing Research: Conducted market research to understand marketing price and trends in catering industry from assessing real-time quotation from suppliers and analyzing metrics like Turnover Period to evaluate the capabilities; * Financial Reporting: Utilized Power BI to create automated dashboards for tracking monthly operational performance and visualizing key metrics, supported month-end financial close processes, and presented clear financial reports to non-financial stakeholders for transparency and accountability.

Master Of Science - Ms, Business Analytics, Master Of Science

Bachelor'S Degree, Financial Management