Ruozhuo(Zara) Wang Email & Phone Number

Oakville, Ontario, Canada

Cleaned and processed billing data, analyzed resource usage and spending patterns to identify cost optimization areas. Developed dashboards and reports to track and demonstrate cost optimization efforts. Developed financial models for forecasting and monitoring cloud expenses.

Markham, Ontario, Canada

• Built monthly and quarterly GTA real estate market reports consisting of graphs, recognized trends and insights, posted on social media to boost the company’s image, generate leads, and save advertisement costs.• Redesigned regularly market reports focus on specific areas and property types to meet agents’ and clients’ needs, received positive feedback from both manager and agents.• Completed company and agent sales statistics analysis monthly to reveal the company’s performance… Show more • Built monthly and quarterly GTA real estate market reports consisting of graphs, recognized trends and insights, posted on social media to boost the company’s image, generate leads, and save advertisement costs.• Redesigned regularly market reports focus on specific areas and property types to meet agents’ and clients’ needs, received positive feedback from both manager and agents.• Completed company and agent sales statistics analysis monthly to reveal the company’s performance against our competitors’ and support strategic decision-making. Meanwhile converted the sales data into captivating graphs and emailed them to our agents and clients, earning 200 new agents joining us in the past year. • Updated the local database monthly with transaction information scraped from MLS.• Guided functional teams to discuss data requirements, independently accomplished ERD and schema design, designed a data model that ensures all data objects generated in the business process are accurately represented, efficiently organized, and easily maintained.• Organized training sessions for agents weekly on how to use a cloud-based real estate technology platform. At the end of the training, 30% of the new agents showed interest and applied for registration. • Awarded with a 15% end-of-year bonus for the year 2021. Show less

Beijing City, China

Cost data analyst -Collected purchase prices, construction costs, fees, and other cost-related data from a wide range of sources, uploaded them to database, and updated regularly to ensured data validity and applicability. Saved searching time by 80%. -Led the cost estimating group to build bid price and prepared commercial documents to support the market department in 5 large bidding projects. -Tracked and recorded cost-related data of projects in operation… Show more Cost data analyst -Collected purchase prices, construction costs, fees, and other cost-related data from a wide range of sources, uploaded them to database, and updated regularly to ensured data validity and applicability. Saved searching time by 80%. -Led the cost estimating group to build bid price and prepared commercial documents to support the market department in 5 large bidding projects. -Tracked and recorded cost-related data of projects in operation, analyzed cost performance, identified trends and problems, and developed annual and monthly cost reports (more than 50 reports every year) to support project management team decision-making. -Communicated with owner representatives and colleagues from the market, technical, financial, procurement departments daily to facilitate the project execution. 100% of the projects I led completed on schedule.Purchasing Assistant -Coordinated internal departments to prepare purchasing plans and tender documents -Collected suppliers’ quotes, organized tender openings, completed the opening records -Supported the evaluation of the bidders’ performances, maintained and developed the lists of qualified bidders for goods and services -Assisted in organizing contract negotiations and took the minutes -Prepared and issued contract documents for the procurement of goods and services, such as purchase orders, procurement tenders and proposal documents -Uploaded the bidding and contract documents to CMS system Contract Cost Control Engineer -Estimated procurement prices for materials and equipment -Evaluated commercial bids of procurement and construction contracts according to tender documents and company policies and procedures -Verified and approved contractual and non-contractual payments -Entered the contract budget and actual cost data into ERP system -Prepared the monthly contract performance report Show less

Certificate Of Data Analytics Boot Camp, Data Analytics (Part Time), Academic Average A

Advanced Excel • Pivot Tables • VBA Scripting Python Programming • Python 3 • NumPy • Pandas • Matplotlib • API Interactions • Social.

Master Of Engineering - Meng (Project Management+Transportation), Civil Engineering, 3.9/4

- Construction contract documents: Studied the law of tendering and bidding by using real cases, standard construction contracts.

Bachelor'S Degree, Construction Management