John Gabriel De Leon

Experience

• 

  Bell

  Sept 2019 - Apr 2023

  •Prepared and managed financial models all property and different marketing development types.•Collaborated with cross-functional teams and stakeholders to ensure the accuracy of financial models.•Supported the Real Estate finance team with data and financial analysis, including cash flow and scenario analysis, ad hoc financial and capital structure analysis.•Conducted market research to verify key assumptions and determine market economics.•Prepared economic summaries for Bell’s income-producing assets, updated rent rolls, and performed operating cost/recoveries analysis.•Tracked cash flow and assist with regular reporting requirements of the real estate development portfolio.•Summarized and presented findings and recommendations succinctly to management. Show less • Gave customers a great customer experience and helped build customer trust by explaining every detail to them while performing upgrades and new activations, as evidenced by positive Google reviews.• Received the company-wide Top Performer Award for 2022 by completing 110% of the store's annual target throughout the year.• Provided accurate information on customer accounts to identify potential savings and sales opportunities, while maintaining relationships to ensure repeat business.• Executed regular inventory counts and supply audits to monitor shrinkage and generate insight intorequesting inventory decisions through SAP.• Created various sales strategies and motivated my colleagues to look for monthly opportunities to help hit our store targets. Show less

  • Commercial Real Estate Analyst Intern

    Jan 2023 - Apr 2023

  • Retail Sales Consultant

    Sept 2019 - Dec 2022
• 

  TC Energy

  May 2023 - Jul 2024

  Project Cost Control Intern - Canada Gas Pipeline and Facilities

  • Provided Accounting Firms with project progress reports and schedules to verify active status of projects for year-end audit classification.• Utilized Microsoft Power BI and Excel to create reports needed by Management, Project Managers, and Controllers to make key decisions on projects.• Oversaw the closeout activities of over 50 projects within my team and provided solutions to controllers of any problems they may have related to the task.• Conduct monthly financial reports using SAP to analyze variances and manage budget by comparingaccruals, actuals, and forecasts to higher management.• Supported Cost controllers with projects worth over $1 million throughout the duration of the work term.• Trained new Project Controllers with processes and software that are used in our daily operations.• Efficiently closed POs and projects, ensuring cost savings by finalizing invoices with vendors and halting internal charge times.• Managed vendor communications for purchase order follow-ups and invoice confirmations.• Successfully setup and implemented over 200 projects using Project Information Management Systems, while also training Project Controllers and Engineers on cost control estimates, forecast trends and Show less

• 

  UFA

  Jul 2024 - now

  Petroleum Supply Chain Analyst
• 

  Prolific Basketball Team

  Sept 2024 - now

  Head Coach U16