Stella Zhou Email and Phone Number

Amazon Advertising

• Owned and launched 30+ dashboards in Tableau business server powered by Excel/SQL across the office, finance, capital markets, accounting sectors, and 20+ submarkets which allow brokers to track portfolio activities. This work has led to a 90% reduction in overdue leases which saved $850k in operational cost.• Led a multicultural team of 3 to restructure data quality improvement strategies by cleaning, integrating, and validating data from four platforms. Designed an R-based procedure by using dplyr, tidyverse, ggplot2 packages which increased internal data accuracy by 70% and external by 40% in 4 months.• Compiled quarterly market statistic reports on investments and leases by verifying different market conditions through real estate data to help senior management oversee investment performance and monitor sales growth of 2000+ properties throughout Maryland, Virginia, and Washington D.C.• Created new metrics with the General Service Administration team to identify unusual tenants in market moves which led to a business decision on new tenant management solutions that accelerated 5% monthly revenue growth.

• Worked with Marketing, Sales, and Technology teams to understand the processes and standards in place to ensure data integrity through the appropriate use of de-duping, loading and exporting tools for a bulk of data using Data Loader, DemandTools.• Collected, standardized and appended new attributes to existing records in SFDC & Marketo and making significant changes to the existing account hierarchy.• Formulated procedures for migration of source data, developed data migration templates and managed all vendor relationships

• Created rich Tableau dashboards for the billing department and prepared user stories to detect outliers, identify high risk and deliver actionable insights.• Analyzed user and business requirements and attended periodic meetings for changes in the application requirements and documents.• Created line and bar charts to show data in a breakdown of weekly, quarterly, and yearly timescales.

• Played a key role in running a nonprofit student organization to promote exchange opportunities to colleges, monitored and analyzed operating results against budgets to keep financial sustainability.• Planned, executed and supervised over 20 on-campus events and coordinated cross-functional efforts with marketing and outgoing exchange teams to develop 50 overseas volunteer programs.

• Applied operational, financial and SOX audits to assure financial statements are fairly presented in alignment with GAAP for electronics and technology manufacturer which is Fortune 500.• Conducted multi-cultural communication among teams across the U.S, Mainland of China and Hong Kong for the semi-annual audit to better understand the regulations.• Created & analyzed preliminary & final analytics for clients, tying prior year numbers to current years, while making sure there were no material differences.

• Actively assisted with preparation for audits for a regional government infrastructure division by documenting and evaluating audit scope and objectives, developing timetables and schedules.• Verified over 1,000 assets and liabilities by comparing items to documentation and maintained internal control systems by updating audit programs.• Produced detailed reports and recommended internal control improvements to enhance organizational efficiency and support client service and growth targets

- Prepare journal entries- Assist with financial statements