Jeff Collen
**** ********** ***, *******, ** ****6
206-***-****, **********@*****.***
Summary
Highly motivated professional with expertise in data visualization reporting and analysis. Organized, detail-oriented, and conscientious self-starter, able to strategize and prioritize effectively to accomplish company objectives.
Professional Experience
Wave Broadband Kirkland, Washington
Business Data Analyst ll Dec 2016 – Present
Led the creation of Tableau reporting and analysis across all departments company wide.
Created the Tableau reporting processes, look, feel and best practices at Wave.
Tableau SME and educator at Wave, coached team members through hands on training and internal wiki.
Provided actionable business insights supporting key company objectives for executive leadership
Worked across departments to automate and improve existing reporting utilizing Python, SQL and Tableau.
Acted as Tableau Server Administrator, working with IT to handle upgrades, permissions and compatibility
Led spatial analysis projects using QGIS and Tableau.
Metrics and Reporting Analyst Feb 2016 – Dec 2016
Responsible for all reporting on the Fiber Design and Construction team with over 80 million in 2016 CAPEX.
Built from scratch FDC’s KPI’s and reporting for the executive team
Created standardized reports for key FDC stakeholders concerning CAPEX, construction, permitting and staffing
Dashboard creation using Tableau and Excel to improve business intelligence and visibility to KPI’s.
Collected data from multiple teams and sources including SQL, Excel, Oracle and custom applications.
Effectively communicated complex problems and ideas to different audiences leveraging data visualization.
Data validation and reconciliation enabling accurate and effective reporting and analysis
Numera Corporation Seattle, Washington
Operations Manager June 2013 – May 2015
Worked directly with the heads of finance, sales, and operations to develop financial reporting tools and operational efficiency metrics
Responsible for accurate billing reporting and analysis across product lines and varying contract structures
Utilized complex data sets to create actionable reports and forecasts for the sales and executive team relating to revenue, orders, shipments and cellular activations
Maintained bill of materials for each product line and conducted gross margin and competitive pricing analysis enabling management to effectively price products
Managed international shipping logistics and created SQL databases to track units as required under ISO 13485
Marketing Associate November 2011 - June 2013
Conducted ROI analysis on marketing and advertising efforts leading to a more efficient use of resources
Led creation of comprehensive competitive analysis of both telehealth and mPERS industries
Implemented Google Analytics reporting and became SME.
Skills
A proven ability to learn, adapt and produce results in a fast paced, constantly changing environment
Working across multiple teams and disciplines to achieve company objectives
Business Analysis, Financial Analysis, Spatial Analysis
Tableau, Excel, SQL, Python, Google Analytics, QGIS
Tableau Qualified Associate Certification
Education
University of Michigan Current
Applied Data Science with Python
Duke University 2015 - 2016
Coursework in SQL and Tableau
Florida State University 2013 - 2014
Certificate in Financial Planning
University of Washington 2010 - 2011
Bachelor of Arts: Politics, Philosophy, and Economics