Zhongjie Shen (Jeffrey)

Senior Data Integration Specialist

BC Hydro

• Build and maintain the data pipelines and models behind forecasting, research and revenue reporting for a customer base of over 2 million accounts.
• Own a multi-source analytics data library that combines internal transactions with government and third-party datasets, with monthly ingestion fully automated.
• Designed a record-matching and pattern-detection algorithm that flags misclassified records, with validation rules that reject bad data but keep it traceable for audit.
• Led a legacy modernization that replaced 20 SAS scripts with one SQL pipeline, cutting runtime from 2–3 hours to about 10 minutes.
• Migrated month-end revenue and daily reporting to the enterprise data platform, cutting runtime from 6+ hours to about 30 minutes and reducing variances for Finance.
• Built weather-normalized demand forecasts in Python and Power BI on a cross-team rotation with planning engineers.

Data Integration Specialist

BC Hydro

• Ran the core monthly data process and reporting, and delivered ad hoc data requests for teams across the organization.
• Took over a reporting program from external contractors and automated the monthly dashboard refresh from a full day of manual work to about 30 minutes.
• Built an in-house SQL decoder for vehicle identification data that processes the full dataset in under an hour and keeps sensitive data off external APIs.
• Evaluated a paid data API and proposed an open government dataset instead, saving over $1,000 in licensing costs.
• Produced analysis that supported regulatory reporting and pricing proposals.
• Mentored co-op students and trained Finance staff on self-serve reporting.

Advanced Analytics Intern

Boeing

• Ran association-rule and market-basket analysis on historical sales data alongside the data science team.
• Built an interactive sales performance dashboard (Python for cleaning, Tableau for visualization) and automation tools on SQL Server and SSRS for resource planning.

Documentation Specialist Co-op

Motorola Solutions

• Improved the CMS backend in PHP and MySQL, cutting document turnaround time by up to 70%, and redesigned the frontend on a customized Bootstrap framework.
• Hardened the Linux VM against phishing and SQL injection with no downtime or breaches during the term, and integrated Google Analytics for usage data.

Earlier roles