Senior Rate Analyst
Current
Jan 2024 - Present
AeroLeads people directory · profile
Trevor Lopez Email & Phone Number
Senior Rate Analyst
at
Xcel Energy
1 work email found
@dpsk12.org
LinkedIn matched
✓ Verified May 2026
4 data sources
Profile completeness 100%
Who is Trevor Lopez? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
Trevor Lopez is listed as Senior Rate Analyst at Xcel Energy, based in Aurora, Colorado, United States. AeroLeads shows a work email signal at dpsk12.org and a matched LinkedIn profile for Trevor Lopez.
Trevor Lopez previously worked as Business Intelligence Developer at Denver Public Schools and Senior Financial Analyst at Denver Public Schools. Trevor Lopez holds Masters, Business Analytics from University Of Denver.
Company email context
Email format at Xcel Energy
This section adds company-level context without repeating Trevor Lopez's masked contact details.
{first}_{last}@dpsk12.org
86% confidence
AeroLeads found 1 current-domain work email signal for Trevor Lopez. Compare company email patterns before reaching out.
Profile bio
About Trevor Lopez
As a Business Intelligence Developer at Denver Public Schools, I created and delivered data-driven solutions for various customers, including leadership. I designed and developed dashboards in Power BI, build reports in SQL Server Management Studio, and lead meetings for report requests. I also research and navigate FTE in Infor HR, a cloud-based human capital management system.I am currently pursuing a Masters in Business Analytics at the University of Denver, where I am learning advanced skills and techniques in data manipulation and modeling with Excel, Power BI, SQL, Python, and RStudio. I have a background in finance, with previous roles as a Senior and Financial Analyst at DPS, where I managed, analyzed, and reported on grant budgets up to $46m. I also have a certificate in data science from Woz U and a PCEP certification in Python. I am passionate about using data to improve decision-making, optimize performance, and drive positive outcomes.
Listed skills include Customer Service, Sales, Leadership, Microsoft Office, and 36 others.
Current workplace
Trevor Lopez's current company
Company context helps verify the profile and gives searchers a useful next step.
11 roles
Trevor Lopez work experience
A career timeline built from the work history available for this profile.
Business Intelligence Developer
Create SQL queries to pull data for customersBuild reports in SQL Server Management Studio for customers including leadershipDesign and develop dashboards from scratch in Power BIRefresh, modify, and update reports and dashboards in Power BILead meetings for report requests from customersResearch and navigate FTE in Infor HR
Jan 2023 - Nov 2023
Senior Financial Analyst
Managed $46m in Title dollars including the reporting and monthly billingDeveloped analysis reports in Oracle using Oracle Business IntelligenceResearched grant dollars to ensure proper reimbursement and billingLead budget setup with Grant ManagersProduced forecasts in Excel and Google Sheets
Jun 2022 - Jan 2023
Financial Analyst
Provide financial support and analysis to Grant Managers and Business Partners for grants up to $1.5mLead budget setup and forecasting for fiscal year and multi-year grantsBuild budgets and forecasts in Excel and Google SheetsCreate and run reports in Infor Lawson and DPS Proprietary BI reporting toolBuild and submit billings for Grant Managers for monthly.
Jun 2021 - Jun 2022
Financial Analyst
Performed budget setup for Director of FinanceRan ad hoc reports, journal entries, and processed commissions in SAPLead account reconciliation for company AMEX cards with $300,000 limits
Sep 2020 - Jun 2021
Data Analyst
Reviewed over 200 accounts weekly for accuracy in Salesforce for third-party salespeopleActed as point of contact for sales team regarding account decisionUploaded datasets ranging from 10-300 rows in SQL with Salesforce Data Loader
May 2020 - Sep 2020
Financial Reporting Analyst
Performed three report rebuilds in Excel to consolidate and streamline Accounts Payable and CFS reportsAssisted with building and publishing reports in Power BIDistributed daily, weekly, monthly report analysis to colleagues and executive leadership.Ad hoc reporting as requested
Oct 2019 - May 2020
Pricing Analyst
Responsible for monitoring RBDC promotions and discounts as dictated by Key Account Managers Managed the updating and fusion reporting in MySQL based route accounting software – EncompassWorked closely with field sales team to ensure discounts applied correctly and troubleshot discount errorsLead analysis with Collections department for short pay invoice.
Jul 2018 - Oct 2019
Pricing & Route Accounting Analyst
Performed monthly pricing analysis for different customer account levelsFilled in for Pricing Analyst when needed to update promotions planner via RBDC BI toolLead pricing report rebuildsAssisted field sales team with customer account creation and discount discrepancies
Dec 2017 - Jul 2018
Sales & Use Tax Specialist
Part of a 2-person team tasked with acquiring resale certificates for customers across the nationSaved RBDC $7million in potential tax feesLead WebEx meetings to train field employees and managers on resale certificate retrievalPerformed weekly reporting and analysis in Excel with various functions including SUMIFS, VLOOKUP, and utilizing Pivot Tables
Nov 2016 - Dec 2017
Personal Banker
Built customer relationshipsRanked top 5% among other Personal Bankers in districtBrought in over $500,000 new money to branch
Oct 2014 - Sep 2016
3 education records
Trevor Lopez education
Masters, Business Analytics
University Of Denver
Bachelor'S Degree, Finance, General
University Of Colorado Colorado Springs
Certificate, Data Science
Woz U
FAQ
Frequently asked questions about Trevor Lopez
Quick answers generated from the profile data available on this page.
What company does Trevor Lopez work for?
Trevor Lopez works for Xcel Energy.
What is Trevor Lopez's role at Xcel Energy?
Trevor Lopez is listed as Senior Rate Analyst at Xcel Energy.
What is Trevor Lopez's email address?
AeroLeads has found 1 work email signal at @dpsk12.org for Trevor Lopez at Xcel Energy.
Where is Trevor Lopez based?
Trevor Lopez is based in Aurora, Colorado, United States while working with Xcel Energy.
What companies has Trevor Lopez worked for?
Trevor Lopez has worked for Xcel Energy, Denver Public Schools, Bona Ab, Centurylink, and Graebel Companies, Inc..
How can I contact Trevor Lopez?
You can use AeroLeads to view verified contact signals for Trevor Lopez at Xcel Energy, including work email, phone, and LinkedIn data when available.
What schools did Trevor Lopez attend?
Trevor Lopez holds Masters, Business Analytics from University Of Denver.
What skills is Trevor Lopez known for?
Trevor Lopez is listed with skills including Customer Service, Sales, Leadership, Microsoft Office, Banking, Microsoft Excel, Microsoft Word, and Hospitality.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trial