JH

Joel Hansen

Business Intelligence Analyst · ISS FACILITY SERVICES


Work Experience

Business Intelligence Analyst

ISS FACILITY SERVICES

2018 – Present

Business Intelligence Analyst experienced in operational and project management. Highly analytical and proficient in financial, data and business analytics. Seeking a business or FP&A analysis role.

ISS FACILITY SERVICES Jun' 18 - Present Optimize Operations • Created cost savings over $100,000 and increased staff retention for the Barclays UK Engineering operations through analysis of building square footage and headcount at multiple regional offices. • Resolved a critical issue that prevented efficient workflow through the analysis of site-specific data from troubleshooting 10 pieces of faulty equipment. • Optimized contract management processes on 14 accounts by collaborating with Key Account Managers across the United States.

Analyze and Report Data • Developed an easy to use reporting system for our client to recognize and achieve their waste stream goals by categorizing and streamlining vendor data from over 100 unique client sites. • Led the analysis for account retention of a client by analyzing site data from over 20 international sites. Presented the analysis to key stake holders including the Global Account Director. • Optimized the data collection process by designing three unique templates that improved data input, streamlined analysis and made reporting more comprehensive.

Plan and Forecast Finances • Recognized $5 million in forecasted savings by directing the Specialized Services Price Increase Initiative by coordinating data gathering with key stakeholders across the United States. • Reduced future bidding costs by more than $100,000 through optimizing cost templates which resulted in increased efficiency in RFI and bidding processes. • Analyzed contract and procurement processes for a $10 million product implementation that included the majority of our current business. Resulted in more efficient project progression.

Master chef

ROBERT HALF FINANCE & ACCOUNTING

2017 – 2018

Aug' 17 - Jun' 18

Analyze and Interpret Finances • Secured more accurate product volume and pricing from our national vendors by analyzing and identifying volume discrepancies in the baseline data. • Limited the financial impact of adding additional products beyond our initial scope by identifying similar products from our national distributor that would meet the business needs. • Recognized $1 million in forecasted savings by closely monitoring the savings tracking process.

Ensure Data Integrity • Captured a $15 million favorable credit adjustment by evaluating key metrics from diverse sources and increasing accuracy of equipment and parts inventory. • Established a comprehensive method to manage the financial performance of an office complex by creating a tracking system for financial charges and payments for all units within the complex.

Report and Present Finances • Decreased spend by $1,000 of our company per month by exposing inventory supply misallocation in the corporate balance sheets. • Identified cost saving opportunities by organizing a multi-sourced data set that used pattern recognition and data correlation to identify unchecked cost growth.

TECHNOLOGY PROFICIENCES • Tableau, Microsoft Power BI (Data • SFDC (Salesforce) Visualization) • SharePoint, Teams, Zoom (Collaboration) • R, Python, SQL, Excel VBA (Languages) • Microsoft O365 (Excel, Word, PowerPoint)

https://public.tableau.com/profile/joel.hansen

PERSONAL • Worked in 8 international countries in 18 months (2019-2020) • "Master chef" - cooks neighborhood favorite marinara sauce and summer BBQ green beans • Learned all about load bearing structures during our kitchen remodel (2017)

Education

B.A.

University of California San Diego

B.A.