Shaun O'Donnell Bio

California State University Channel Islands 2017 - Present

Data Manager & Research Analyst

  • Responsible for integrating new Data Warehouse, ETL procedures in SSIS for downloading data from PeopleSoft Campus Solutions (Oracle) into SQL Server 2016 Data Warehouse
  • Utilizing Tableau 3.3 for reporting
  • Part of team that successfully implemented a new data warehouse for the University
  • Data Warehouse Technical Lead
  • ETL development in SSIS downloading tables from PeopleSoft (Oracle) into SQL Server
  • Responsible for development/modifications of Tables/Views/Stored Procedures/Functions
  • Integration of California state files into data warehouse
  • Data Warehouse security
  • Tableau system administration – Sites/Groups/User
  • Tableau security permissions
  • Tableau development of dashboards and views

J.D. Power and Associates 31 Years

Director, Sampling

  • Responsible for all respondent contact information. 150+ million records/200 projects per year
  • Responsible for departmental $2 million budget
  • Led initiative to migrate database from AS/400 DB2 to Windows Server using SQL Server
  • Created automated in-house ETL system to import customer data, clean, transform, randomly select records and load
  • Created the Firm’s “Do Not Contact” database
  • Created the Firm’s VIN decoding system
  • Implemented and maintained the USPS National Change of Address software
  • Created automated ETL load interface for new IBM Data Collection platform
  • Developed on-line Reporting system for all projects
  • Trained on-site resources in database design and ETL tools
  • Documented Sampling processes and specifications for BPM
  • Maintain and develop applications using web services
  • Led development of custom client-facing sites for data delivery. VB client interface and SQL Server data storage
  • Created ETL scripts for custom aggregation scenarios
Back to Top ↑
©