Zongchen Teng

Full-time · 1 yr 2 mos · San Francisco Bay Area · Hybrid

• Solely developed and deployed 10+ business applications and 25 automations/reports using Power Platform for a Bay Area electric operations organization, ensuring accurate, real-time data across the organization. These applications, relied upon for director-level operational reviews and daily transmission pole operations, streamline workflows, save 25+ hours/week, and deliver $500K+ in annual cost savings.
• Client-facing consultant, identifying organizational challenges and delivering tailored solutions to improve operational efficiency. Mentor and manage junior developers on application and automation projects across multiple organizations, while expanding territory and uncovering new business and sales opportunities.
• Co-founder of the Camping Employee Resource Group (ERG), fostering team bonding, collaboration, and community engagement within the company. 🏕️

Full-time · 2 yrs 1 mo · San Francisco Bay Area

• Served as the sole BI developer, independently managing the full lifecycle of FP&A analytics projects for Blend and its subsidiaries, from project scoping to deployment and ongoing support.
• Designed and delivered 20+ executive Power BI and Mode dashboards for C-suite stakeholders, driving product strategy and investor reporting; visuals were presented in quarterly live streams.
• Elevated core FP&A analytics, covering financial planning, capex, opex, and headcount modeling, creating custom financial visualizations that improved clarity and executive decision-making.
• Revamped the Workday Adaptive system through data model restructuring, cleansing, and performance tuning, achieving a 133% improvement in load times and enabling reliable daily financial insights.
• Consolidated multi-subsidiary reporting pipelines, integrating Power Query, ReTool, Fivetran, and Snowflake into a standardized ETL framework, reducing reconciliation effort by ~30%.
• Implemented scalable Power BI Service architecture across 20+ reports, optimizing dataset performance and cross-functional accessibility.
• Designed automated Power Automate workflows with DAX-driven calculations to trigger real-time budget alerts, improving proactive financial governance.

Part-time · 10 mos · San Francisco Bay Area · Hybrid

• Led an end-to-end BI engagement as a solo consultant, owning project scoping, stakeholder management, data modeling, dashboard development, deployment, and post-launch support.
• Designed and delivered 20+ Power BI, Power BI Report Builder, and SSRS reports, providing actionable insights into order processing and operational KPIs.
• Elevated stakeholder adoption through UI/UX redesign, KPI standardization, and intuitive dashboard architecture.
• Provided ongoing production support, enhancements, and requirements refinement to ensure long-term reporting scalability.

Full-time · 3 yrs 2 mos · San Francisco Bay Area

• Contributed to the design and delivery of 35+ enterprise BI dashboards and Power Apps using Power Platform and Tableau, supporting executive reporting across 8+ industries.
• Developed and optimized ETL pipelines and data warehouse solutions (SQL Server, Snowflake, Oracle, Redshift) supporting datasets up to 100M+ rows.
• Supported the implementation of a self-service Power BI governance framework adopted by 100+ users, reducing report duplication by 40%.
• Improved dashboard performance by up to 50% through DAX optimization, query folding, and enhanced data modeling.
• Increased stakeholder adoption through UI/UX redesign, JSON theming, and development of custom visuals (D3.js, Python, R).
• Automated 15+ workflows, saving 20+ hours of manual reporting effort per month.
• Assisted in delivering Microsoft "Dashboard in a Day" workshops and presented at regional Power Platform events.
• Clients included: KLA Tencor · Adobe · Santa Cruz County · Wetherby Asset Management · PG&E · Pattern Energy · Biggie Crane · Bio Marin