Matthew Kelleher
Seattle,WA
Summary
Motivated analyst with five years experience in credit, inventory, and operations. Experienced in leveraging Lean Six Sigma techniques to identify business problems, implementing data driven solutions, and using data to drive continuous improvement. Experienced with data analytics tools including Excel, SQL, R, and Power BI. Innovative and team-oriented worker that thrives in fast paced environments.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Inventory Analyst
Northstar Energy
Seattle, WA
04.2023 - Current
- Utilized Lean Six Sigma tools to identify root causes of fuel invoice inaccuracies; collaborated with project manager to create, implement, and document corrective measures for the process
- Created flowcharts with Visio for package product delivery process and performed root cause analysis to identify bottlenecks and suggested fixes to address root causes
- Collaborated with fuel operations leadership during accounting software upgrade to define deliverables for operations and accounting teams and built out new sales reconciliation and posting process
- Leveraged SQL, Excel, and Power BI to create dashboard to warn key teammates when billing performance falls below customer expectations
- Owned all aspects of inventory accuracy including reviewing and posting all purchase and sales orders for two companies
- After implementing billing KPI reporting, I was promoted to Inventory Analyst in April 2023
Credit Operations Analyst
Northstar Energy
Seattle, WA
07.2020 - 04.2023
- Spearheaded the installation of a new billing process with the fuel dispatch team to increase billing efficiency; improving daily billing time by 75%
- Designed a monthly Past Due report to direct Collections towards larger balances for efficient collection efforts; reduced accounts receivable balances by over 10%
- Built Power BI dashboards to display custom billing operations metrics company-wide to assist with company initiatives to lower accounts receivable balance
- Revamped fuel invoicing process for $150M+ revenue company and documented the entire process to create first billing standard operating procedures
Commercial Credit Analyst
Western Truck Center
Seattle, WA
08.2018 - 07.2020
- Analyzed both credit information and financial statements to forecast risk before financing portfolios of up to several million dollars
- Collaborated with accounting to create and maintain month-end financial portfolio reports in Excel that show the remaining balances on outstanding loans to keep track of how close each contract is to maturity
- Promoted to Commercial Credit Analyst after six months as finance department administrator
Education
Bachelor of Arts - Economics
University of Washington
Seattle, WA06.2018
Skills
- SQL queries, joins, and aggregations
- Power BI data visualizations and dashboards
- Excel formulas, pivot tables, and power query
- KPI implementation and continuous improvement
- Lean Six Sigma strategies
- Microsoft Visio flowcharts and diagrams
- Cross-team collaboration and problem solving
Certification
- Lean Six Sigma Green Belt Certification, Emory University (expected completion March 2024)
Timeline
Inventory Analyst
Northstar Energy
04.2023 - Current
Credit Operations Analyst
Northstar Energy
07.2020 - 04.2023
Commercial Credit Analyst
Western Truck Center
08.2018 - 07.2020
Bachelor of Arts - Economics
University of Washington