Garrett Ellison is the BI Manager in the P&N Consulting Services Group. He joined the firm in 2013. He has also achieved the designation of Certified Business Intelligence Professional (CBIP), recognized by The Data Warehousing Institute, with a specialization in Data Integration and Interoperability, and obtaining a Mastery level in Data Warehousing.
Garrett leads Business Intelligence development and is proficient in many analytics and visualization tools. These tools include the full Microsoft SQL Suite of Data Tools (SSMS, SSAS, SSIS, and SSRS), Tableau, SQL, and Power BI.
Garrett is also familiar with the industry's best practices in all facets of BI: data modeling, database performance tuning, and dashboard design. He is able to take data solutions from the concept phase, through the ETL (extract, transform, load) phase, and deliver high-quality data warehouses, reports, and dashboards to end-users. Through Agile implementation and daily Scrum delivery methods, he is able to deliver high-quality solutions to the client as quickly as possible. He also has experience in designing internal/external data service solutions.
He has been instrumental in bringing in new data modeling and management standards to clients in order to ensure end-solution quality. He has also helped to create new ways to automatically cleanse user-input data, and create truly unique/randomized primary keys to improve application efficiency.
Garrett has gained experience on prior projects as a member of the P&N Application Development team and as a member of the BI Development team. As a member of the Application Development team, he assisted in sprint planning, workload balancing, and user story scheduling and updating. He also brought technical problem solving to a program-wide scale. Garrett recently led an enterprise security initiative on a project where he was able to create a simple solution for a complex technical requirement. He is also involved in end-user software selection, data model planning and execution, and more.
As a leader within the BI Development team at P&N, Garrett helps contribute directly to clients with the Agile development of new BI Data Warehouses and Dashboards. He uses his wide breadth of business intelligence capabilities to help clients solve complex technical issues and diagnose unexpected bugs. Garrett also assists with quality assurance and peer review of work performed by team members.
Education & Certifications
- Certified Business Intelligence Professional
- Bachelor of Science, Information Systems and Decision Science, Louisiana State University
- Member, Association of Information Technology Professionals
- Member, Baton Rouge SQL Server User Group
- Member, The Data Warehousing Institute
- Member, Professional Association for SQL Server
- Contributor/Participant, Juvenile Diabetes Research Foundation