Gavin Ellis
Chicago,IL
Summary
Business intelligence analyst proficient in Power BI, Tableau, and SQL, delivering interactive dashboards, data models, and actionable insights that drive informed decision-making and enhance business performance.
Overview
1
1
Certification
5
5
years of professional experience
Work History
Business Inteligence Anaylst
Tire Rack
Elkhart, IN
12.2024 - Current
- Facilitated cross-department communication to align business intelligence initiatives.
- Worked with stakeholders to align data initiatives with business objectives and strategies.
- Formulated actionable insights from comprehensive data analysis to support decision-making.
- Developed strategic recommendations that enhanced operational performance and contributed to revenue growth.
- Designed interactive dashboards to share key metrics and insights with stakeholders.
- Developed visual reports that communicated complex data to non-technical audiences.
- Translated business requirements into technical requirements for reporting, visualizations, data models, and databases.
- Identified and prioritized data optimization and process automation opportunities.
- Conducted data analysis, profiling, and quality assessment to maintain business data integrity.
Business Intelligence Developer
The AME Group
South Bend, Indiana
03.2022 - 12.2024
- Developed broad range of BI solutions from concept through implementation.
- Built Power BI dashboards to support AME Group client reporting needs.
- Developed SQL queries for comprehensive business intelligence data analysis.
- Supported ETL process development for AME Group data sources.
- Modeled datasets to support accurate executive reporting.
- Gathered and clarified stakeholder requirements for effective dashboard and report updates.
- Wrote complex T-SQL queries with joins across multiple tables in MS SQL Server and Oracle databases.
- Improved data collection processes, analysis procedures, and visualization methods.
- Built, tested, and deployed standard reports and dashboards based on business requirement document specifications.
- Documented requirements in functional specifications and technical design documents.
- Applied database design, coding standards, query optimization, and error handling best practices.
Education
Bachelor of Science - Business Management
Purdue University
West Lafayette, IN12-2021
Master of Science - Business Intelligence
Purdue University
West Lafayette, IN10-2026
Skills
- Business intelligence analysis
- Data analysis and visualization
- Power BI and Tableau
- SQL querying and data integration
- Data modeling and dashboard design
- Data integration
- Dashboard creation
- Data dashboard design
- Trend analysis and machine learning
- Trend analysis
- Machine learning
- Python
- Stakeholder communication and requirements gathering
- Requirements gathering
- Business analysis and intelligence
- Tableau software
Certification
- Python Programming
- Data bricks - Work in Progress
Timeline
Business Inteligence Anaylst
Tire Rack
12.2024 - Current
Business Intelligence Developer
The AME Group
03.2022 - 12.2024
Bachelor of Science - Business Management
Purdue University
Master of Science - Business Intelligence
Purdue University