Brian Sullivan

Data Warehouse Architect at Harvard University

Brian Sullivan is an experienced IT professional with over 10 years of extensive experience in Data Analysis, Data Migration, Data Integration, Data Warehousing, ETL processes, and Business Intelligence.

He has a strong background in developing stored procedures, functions, views, triggers, and complex queries using SQL, TSQL, and Oracle PL/SQL.

With 8+ years of Database Development experience using Oracle and Microsoft SQL, Brian has expertise in Data Cleansing, Data Profiling, and Data Analysis, along with skills in UNIX Shell Scripting, SQL, and PL/SQL coding.

Brian is proficient in using tools such as Relational Junction ETL Manager and Relational Junction for Salesforce, with a deep understanding of ETL architectures and Data Warehousing SDLC.

He has a proven track record in designing Data Loading Design Documents for various Cloud, RDBMS environments, and Data Warehouses.

Brian Sullivan has worked with multiple RDBMS systems including Oracle 11g/10g/9i, SQL Server, MySQL, Microsoft SQL, Sybase ASA, and MS Access.

He possesses expertise in building and managing complex infrastructure across platforms using Amazon Web Services' EC2, RDS, and VPC offerings.

His skills also include Database and ETL Performance Tuning, where he has experience in Database Development optimization techniques and configurations.

Brian has practical experience in setting up and configuring Salesforce organizations.

In addition to his database skills, he has beginner-level experience in building RESTful APIs to expose database functionality and JSON-formatted data stored in data warehouses.

Brian Sullivan is known for his excellent analytical and problem-solving abilities. He is a team player with effective communication skills throughout the development process.

Brian studied at Wentworth Institute of Technology and has held positions like Data Warehouse Architect at Harvard University, Technical Consultant at roundCorner, Consultant II at Blackbaud, Technical Analyst III at Target Software, and Network Analyst at Digital Geographic Technologies.