Meng Cai Email & Phone Number

Irvine, Ca, Us

Rocklin, Ca, Us

Data Engineering, Data Warehouse, Data Lake.ETL data pipelines connecting SQL, MongoDb, Snowflake.Python automation and robots for data reporting, auditing, scraping.BI analytics and predictive modeling.Managing data team and leading data projects.In-depth collaboration with all business lines and company functions.

Houston, Texas, Us

Provided weekly executive dashboard reports monitoring key business performance indicators by collecting, analyzing, and synthesizing large utility data sets using Python, Excel, and Salesforce. Built and maintained various Python automation programs streamlining the solar interconnection processes, including web portal data collection, multi-sourced data integration, data audit, and solar rating calculation. Generated batch-updating reports for solar home application activities using Microsoft Access and VBA programs. Documented solar interconnection processes with flow chart diagrams. Provide ad-hoc reporting for senior leadership.• Significantly reduced the manual searching time by creating web scraping programs that frequently retrieve the latest solar application status from 5+ utility company portals and solar permits from 30+ municipal websites.• Streamlined batch data updates in Salesforce by building data analyzing programs that collect and analyze solar home application data from utility company portals and generate update reports.• Minimized errors in sales/operations by building data auditing programs that identify outliers and discrepancies, transform, and compare 80,000+ records of solar new homes between JD Edwards and Salesforce data sources.• Improved business processes by identifying new opportunities for improvements -- the DocuSign eSignature Pilot Program that enabled automatic generation of customer agreements and collection of homeowner signatures/ information using DocuSign APIs.

West Hollywood, California, Us

Executed data-driven design approaches with quantitative metrics for information collection, decision making, client communication, budget control, and construction administration throughout the project life cycle. Led daily production and allocated design team resources, organized cross-disciplinary collaboration with contractors, architects/engineers, and suppliers, maintained seamless client communication, and managed multiple projects simultaneously with impeccable attention to detail. Produced high-quality, professional illustrative graphics, technical drawing sets, and choreographed presentations.

Co-founded QFITNESS, a gym startup providing convenient venues and various personal training classes promoting and helping people adopt a healthy, active lifestyle. Managed company operations with quantitative, data-driven approaches and motivated a team of 25+ employees in the sales, training, and customer care divisions. • Maintained 20%+ annual sales increase and saved 15% of annual operational costs by driving insights from large, conglomerated sets of sales and operations data utilizing Excel, Access, and CRM tools.• Accomplished constant business growth by devising metrics measuring and tracking market funneling/prospect conversion/sales closing rates, customer care, and the fast progression towards sales and training goals.• Streamlined business information collecting, analyzing, and sharing processes by creating an inter-departmental info-integration system with network/server/pc/mobile equipment setup and SaaS services configuration. • Distilled key business insights by monitoring operational activities and KPI indicators for sales of membership/training/snack products with a wide range of executive reporting dashboards utilizing Excel Pivot Table and Power Pivot. • Projected sales volumes that guided quarterly growing goals by implementing linear regression models in Excel with curated large data sets from daily sales activities.• Improved accuracy and proficiency by automating tiered commission calculating and internal financial reporting utilizing high-level Excel functions, Pivot Table, and Power Query.• Optimized staffing/scheduling and identified trending activities of the active members by utilizing Linear Programming models in Excel Solver.

Sausalito, Ca, Us

𝗧𝗲𝗮𝗺 𝗖𝗮𝗽𝘁𝗮𝗶𝗻 / 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗗𝗲𝘀𝗶𝗴𝗻𝗲𝗿 / 𝗜𝗻𝘁𝗲𝗿𝗻𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 𝗖𝗼𝗼𝗿𝗱𝗶𝗻𝗮𝘁𝗼𝗿• Coordinated cross-cultural collaboration among developers, consultants, engineers, and government agencies for multiple high-end real estate development projects at large scales.• Conducted research and analyses on demographic, economic, climate, and geographic aspects to deliver impactful and sustainable solutions for large-scale urban design and urban planning projects.• Managed effective communication and production for multiple international projects at one time to maintain project schedules and moderate competing conflicts.• Built trust with prospective developers from various business backgrounds, facilitated complex contract negotiation, and delivered designs that overcame societal, economic, and cultural challenges.

Seattle, Wa, Us

Seattle, Wa, Us

Master Of Science - Ms, Applied Data Science

Bla, Landscape Architecture, Cum Laude

Liberal Arts And Sciences, General Studies