Miranda Chen Email & Phone Number

Sunnyvale, California, United States

• Automated the ETL pipeline and delivery of the daily revenue report to senior leadership using Apache Airflow, SQL, Ruby, and Python, driving data-informed decision-making and growth within the Sponsored Products team• Constructed a Tableau dashboard to monitor critical Advertising Technology KPIs, including advertiser churn, keyword profitability, and ad campaign efficiency, enabling data-driven optimization such as identifying high-traffic, under-monetized keywords for revenue growth• Proactively addressed data privacy concerns by developing a proof-of-concept for data segmentation on GCP, leveraging buckets and AD groups to establish a robust data protection framework

Lehi, Utah, United States

• Presented key insights to C-suite and senior leadership to guide future strategy for the Search product• Queried AWS Redshift data warehouse using Python and SQL through Alation to answer a series of ad hoc questions from the product manager on current user behavior and pain points with the Search product• Designed an A/B test in Statsig to evaluate the impact of a new Match Explainer feature from start to finish; ran a power analysis in R, performed a smoke test, monitored the ongoing experiment, and effectively communicated the final recommendation to stakeholders to ship the new feature• Implemented a customer churn model based on the Cox survival regression to evaluate the time-varying effects of user interactions such as viewing documents on customer retention

Silicon Valley

• Cleaned trial balance data using Alteryx and requested additional information to build Excel models to prepare quarterly and year-end income tax provisions for timely and accurate financial statements• Collected financial data from clients, cleaning and analyzing the information to produce Excel models comparing different tax elections to generate 5% in tax savings• Led associates and interns in tax compliance and provision preparation, providing review comments to help develop strong team members for increased productivity

Silicon Valley

• Prepared quarterly and year-end income tax provisions in accordance to ASC 740• Prepared federal and state corporate tax returns, estimates, and extensions for corporations with over $500 million in revenue• Assisted in audits, reviewing tax provisions to provide reasonable assurance of the fair representation of clients’ financial statements

Silicon Valley

• Supported tax compliance engagement teams to prepare extensions and returns for corporate clients• Assisted in provision preparation and review for clients’ financial reporting and tax planning purposes• Managed client documents and internal workpapers in internal document management system

La Jolla, Ca

• Organized team building events and a mentorship program to keep members engaged and encourage further personal development beyond athletics• Planned and hosted weekly socials as well as the annual team banquet with over 80 attendees• Organized annual 3-day team retreat to foster team building and trust

La Jolla, Ca

• Publicized the team as a competitive sports club on campus to pique interest and recruit 80+ prospective members• Planned and coordinated fundraisers throughout the school year generating over $1000 in revenue to fund the team's race fees, equipment, and travel expenses• Launched and curated the team Instagram (@ucsddb) building a follower base of 130+• Coordinated food purchases for race day, providing enough for 40-50 members

La Jolla, Ca

• Planned and executed social events for UAS to improve membership participation• Tracked membership and participation at general body meetings and events hosted by UAS• Improved relations between general body members and the executive board

Palo Alto, Ca

• Generated Salesforce reports to identify expiring support licenses for Sales to follow up with to increase customer retention, successfully renewing 15+ contracts throughout the summer• Designed a Frequently Asked Questions document with 265 questions spanning eight subtopics by extracting common themes in past customer support inquiries; created a base resource for clients’ reference on recurring issues and questions

La Jolla, Ca

• Operated the cash register, handling up to $300 of transactions per hour• Handled merchandise stocking, dish cleaning, and pizza and drink production• Maintained cleanliness of the store and workspace

Saratoga, Ca

• Assisted in supervising a Kindergarten class• Explained how to do English and math problems to the kids• Corrected and graded homework

Master Of Science - Ms, Business Analytics, Magna Cum Laude

Customer Analytics, Machine Learning for Decision Making, Competitive Analytics, Prescriptive Models & Data Analytics, Optimization.

Bachelor’S Degree, International Business, Magna Cum Laude

Activities and Societies: Phi Beta Kappa, TMC Honors Program, Undergraduate Accounting Society, Dragon BoatProduct Marketing.