Garrett Ellison is a lead Data Analytics 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 can 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 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 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.
RELEVANT PROJECT EXPERIENCE
Blue Cross Blue Shield of Louisiana (BCBS), Data Excellence EDW Implementation
P&N is assisting Blue Cross Blue Shield of Louisiana with Agile Project Management and Data Planning on an analytics transformation program with the goal to develop new capabilities including Big Data and Master Data Management (MDM) while executing on an EDW consumption strategy intended to retire and replace legacy systems. The Program is still in existence to this day.
Garrett performed in a Solutions Architect role for the BCBSLA program specifically working with the business intelligence visualization team. Garrett provided best practice solutioning and consulting services to assist the team with dashboard performance, visualization, and metric reporting. Garrett also provided solutioning services for data set architecture as well as custom development of an external security platform for dashboard security and accessibility.
Louisiana Department of Children and Family Services
P&N works with the Louisiana Department of Child and Family Services Special Projects Team to implement a Comprehensive Child Welfare Information System (CCWIS) that unites processes and procedures across 17+ unique online systems used by the Child Welfare workforce. P&N provides project quality management, training, and organizational change management services to those serving Louisiana's children and families.
Garrett is a Scrum Master over the data integration teams in the CCWIS project. He directly oversees a team integrating over 30 years of data from disparate systems into a single application. Garrett combines his knowledge and understanding of data structures and data integration with his Agile project management knowledge to lead a team to be as efficient, effective, and accurate as possible with their data integration tasks.
-
Education & Certifications
- Certified Business Intelligence Professional
- Bachelor of Science, Information Systems and Decision Science, Louisiana State University
-
Professional Affiliations
- Member, Association of Information Technology Professionals
- Member, Baton Rouge SQL Server User Group
- Member, The Data Warehousing Institute
- Member, Professional Association for SQL Server
-
Civic Involvement
- Contributor/Participant, Juvenile Diabetes Research Foundation