Sign In

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 currently holds the position of Data Warehouse Architect at Harvard University.

Key aspects of Brian Sullivan's professional profile include:

  1. Strong background in developing stored procedures, functions, views, triggers, and complex queries using SQL, TSQL, and Oracle PL/SQL.

  2. 8+ years of Database Development experience using Oracle and Microsoft SQL.

  3. Expertise in Data Cleansing, Data Profiling, and Data Analysis, along with skills in UNIX Shell Scripting, SQL, and PL/SQL coding.

  4. Proficiency in tools such as Relational Junction ETL Manager and Relational Junction for Salesforce.

  5. Experience in designing Data Loading Design Documents for various Cloud, RDBMS environments, and Data Warehouses.

  6. Worked with multiple RDBMS systems including Oracle 11g/10g/9i, SQL Server, MySQL, Microsoft SQL, Sybase ASA, and MS Access.

  7. Expertise in building and managing complex infrastructure using Amazon Web Services' EC2, RDS, and VPC offerings.

  8. Skills in Database and ETL Performance Tuning, including Database Development optimization techniques and configurations.

  9. Practical experience in setting up and configuring Salesforce organizations.

  10. Beginner-level experience in building RESTful APIs to expose database functionality and JSON-formatted data stored in data warehouses.

Brian Sullivan studied at Wentworth Institute of Technology and has held positions such as Technical Consultant at roundCorner, Consultant II at Blackbaud, Technical Analyst III at Target Software, and Network Analyst at Digital Geographic Technologies before his current role at Harvard University.

Highlights

Team – Vista Equity Partners
Jan 17 · hksinc.com
Brian Sullivan | HKS Architects
Brian Sullivan | HKS Architects

Related Questions

What specific projects has Brian Sullivan worked on at Harvard University?
How did Brian Sullivan transition from IT to data warehouse architecture?
What tools and technologies does Brian Sullivan specialize in?
Can you provide examples of Brian Sullivan's contributions to data warehousing?
What are Brian Sullivan's key achievements in his career?
Brian Sullivan
Brian Sullivan, photo 1
Brian Sullivan, photo 2
Add to my network

Location

Cambridge, Massachusetts, United States