Junyi Gu Email & Phone Number

Burnaby, Bc, Ca

Vancouver, British Columbia, Canada

- Developed and implemented a daily revenue forecasting model using Python, integrating holiday effects and key business drivers, resulting in improved forecast granularity and efficiency in FP&A planning- Designed and optimized data flow processes, advising on the automation and integration of data pipelines within the FP&A EPM, ACS, Databricks, and Snowflake FDH, enhancing forecasting and planning capabilities- Collaborated with external technical teams to integrate advanced data science tools, enhancing the accuracy and efficiency of FP&A predictive models and aligning with overall financial performance goals- Delivered predictive planning reports (weekly and monthly) through decks, Excel models, and PowerBI dashboards, identifying risks and opportunities to support global revenue forecasting and decision-making

Calgary, Alberta, Canada

- Implemented 3 impactful end-to-end BI tools for transportation, risk management, and project management (KPI, prioritization) using PowerBI, HTML and Python, greatly simplifying the process by 20% for management to deliver reports to the leadership team.- Automated data integration from SharePoint, PowerBI, and Oracle databases in PL/SQL Developer through 50+ self-authored SQL queries within ETL processes, improving team efficiency and data integrity by 25%.- Launched 30+ dynamic PowerBI dashboards with 200+ DAX functions and queries through collaboration with internal and external stakeholders, leading to weekly time savings of 15+ hours for key project stakeholders.- Designed 3 user-friendly web-based data input tools using Spotfire and PowerApps, incorporating 50+ Python & R scripts for advanced analytical functions, significantly enhancing data integrity by addressing user input issues.

Vancouver, British Columbia, Canada

- Assisted the Recruitment & Admission team by organizing several virtual events and conducted 50+ coffee chats with upcoming students.

Suzhou, Jiangsu, China

- Provided actionable insights for product development for a material analyzer through collaboration with engine manufacturers, online surveys, text mining, and data analysis to tailor the product to customer needs, resulting in a 20% increase in product enhancement alignment with the department's 2022 work plans.- Forecasted market trends and customer preferences in the manufacturing industry by applying regression models and predictive analytics using R, equipping managers with data-driven insights, resulting in a 15% increase in alignment with market trends for product development and strategic planning.- Enhanced the product quality of a single crystal analyzer by reducing software processing time by 30% by improving UI for user experience and optimizing image processing algorithms with Python. - Streamlined data pipelines using SQL, analyzed cost spend for product development and presented visual reports to a team of 9 key stakeholders using Excel Macros and Tableau.

Yancheng, Jiangsu, China

- Evaluated clients' bond-issuing capabilities by extracting, transforming, and loading local bond issuance data using SQL, conducting financial statements analysis using Excel.- Enhanced investment reports by launching predictive analytics on financial statements of top competitors using R and automating repetitive tasks using VBA for 10+ Excel macros.

Master'S Degree, Master Of Business Analytics, 3.7/4.0

Activities and Societies: Conducted multiple data-driven projects, including Python-based profit and streamline operation optimization.

Bachelor Of Management(Dual Degree), Business Administration, 4.0/4.0

Activities and Societies: - Monitor of Class- Core courses: Applied Statistics, Risk Management, Marketing, E-commerce - Designed.

Bachelor Of Science - Bs, Materials Science And Engineering, 3.7/4.0

Activities and Societies: - Monitor of Class - Launched Winter Warm Project by organizing 2,000 students to donate winter clothes to help.