Dan Ingraham
Aloha,OR
Summary
Experienced Data Warehouse and Business Intelligence Architect with 10+ years of experience designing and implementing data solutions for Fortune 500 companies. Proficient in systems architecture, data modeling, ETL processes, and BI tools to drive data-driven decision-making and operational efficiency.
Overview
23
23
years of professional experience
1
1
Certificate
Work History
Business Intelligence Solutions Architect
Warn Industries
Portland, OR
06.2016 - 09.2024
- Designed, developed, implemented, and administered the Data Warehouse and Business Intelligence (BI) environments, enhancing enterprise data integration and business processes
- Developed multidimensional databases and online analytical process (OLAP) cubes for optimal performance using business intelligence tools and analytics data models hosted on Microsoft SQL Servers
- Developed ETL processes using SQL Server Integration Services (SSIS) and Microsoft Visual Studio
- Drove architectural and process improvements to accommodate the growing user base and reporting needs.
Business Intelligence Senior Consultant
Daimler Trucks North America
Portland, OR
01.2016 - 06.2016
- Enhanced Business Intelligence quality, credibility, and user satisfaction practices through strategic improvements
- Implemented a resource management system and a new Systems Development Life Cycle (SDLC)
- Established new testing and Quality Assurance (QA) procedures, including a Version Control System
- Improved project documentation, approvals, testing, and post-implementation analysis.
Data Warehouse and Business Intelligence Solutions Senior Consultant
Blue Cross Blue Shield of Tennessee
Chattanooga, TN
06.2013 - 01.2016
- Gathered requirements and developed functional design specifications for Business Intelligence solutions.
- Utilized Teradata SQL Assistant for integrating multiple data sources hosted on SQL and IBM AIX servers.
- Developed physical and logical data models for the Teradata Database.
- Prepared OLAP cubes for IBI WebFOCUS and IBM Cognos BI tools.
- Authored development standards and best practices guides, and provided training for BI staff and users.
Senior Systems Analyst
Brunswick Corporation
Knoxville, TN
09.2001 - 06.2013
- Implemented data warehouse solutions and administered business intelligence platforms in three organizations using Oracle, IBM Db2, and MS SQL Servers. Designed ETL processes with Informatica and Microsoft's SSIS to support data management. Created data models and designed OLAP cubes for the OBIEE platform and Business Objects' solution suite.
- Created efficient multidimensional databases (MDB) and streamlined system architecture through creation of optimal stored procedures and SQL.
- Defined and streamlined reporting requirements in collaboration with stakeholders.
Education
Bachelor of Science - Finance and Law
Portland State University
Portland, ORSkills
- Big data technologies
- Data architecture
- Data Quality Management
- Performance Tuning
- Data Warehousing
- Data Modeling
Certification
- Data Warehousing Architect
- Erwin Data Modeler
- Power BI
- Business Objects
- Oracle Business Intelligence
- Web Development
- Toastmasters Club
- T-SQL
- PL/SQL
- Java
Affiliations
- Guest Speaker for the Chamber of Commerce
- Chamber of Commerce Community Volunteer
- Member of the American Institute of Philanthropy
- Volunteer Head Coach for Various Youth Sports
- Toastmasters Club Officer
Timeline
Business Intelligence Solutions Architect
Warn Industries
06.2016 - 09.2024
Business Intelligence Senior Consultant
Daimler Trucks North America
01.2016 - 06.2016
Data Warehouse and Business Intelligence Solutions Senior Consultant
Blue Cross Blue Shield of Tennessee
06.2013 - 01.2016
Senior Systems Analyst
Brunswick Corporation
09.2001 - 06.2013
- Data Warehousing Architect
- Erwin Data Modeler
- Power BI
- Business Objects
- Oracle Business Intelligence
- Web Development
- Toastmasters Club
- T-SQL
- PL/SQL
- Java
Bachelor of Science - Finance and Law
Portland State University
Community Service
- Guest Speaker for the Chamber of Commerce
- Member of the American Institute of Philanthropy
- Chamber of Commerce Community Volunteer
- Volunteer Head Coach for Various Youth Sports
- Toastmasters Club Officer
Similar Profiles
KATIE GREENEKATIE GREENE
HR Assistant at Warn IndustriesHR Assistant at Warn Industries
Jasmine RehderJasmine Rehder
Production Worker at Warn Industries Inc.Production Worker at Warn Industries Inc.
Robert RussellRobert Russell
Millwright at Warn Industries Inc.Millwright at Warn Industries Inc.