Alan Carey San Francisco – Data Architect

February 28, 2017

Alan Carey San Francisco

Alan Carey San Francisco – Data Architect

I’m Alan Carey San Francisco and I have always enjoyed learning how to break down challenges into manageable pieces that help people understand and work through a problem to a solution.

I started my journey as a Coder and eventually migrated to being a Data Architect working primarily on Big Data in industries such as Financial, Retail, Travel and Commercial Real Estate.

My favorite part of being a Data Architect is creating data models for people to rally around and move toward a good design.

I have used my past 20 years of experience to pioneer with new process and technology in the database field as well as having many successful deployments through the entire software development lifecycle.

I am always on the lookout for innovation in business and technology that help create more robust results.

I have recently been investigating Amazon Web Services (AWS) and looking into Hive and Redshift.  The Redshift database looks like a cloud based Teradata database engine.  I like how easy it is to setup a Hadoop cluster in AWS and include Presto, Hive and Spark as different SQL engines.  Also, I have been experimenting with file types such as orc and parquet as well as trying to determine how much of a performance impact is seen with using S3 as a external table.

Data Portfolio

I have built data systems for the following companies

  • Bank of America
  • Goldman Sachs
  • Charles Schwab
  • Blackrock
  • Pine River Capital Management

I have used a large number of systems including

  • Teradata
  • EMR
  • Redshift
  • Sybase IQ
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Sybase ASE
  • Business Objects
  • SSRS and SSIS

Alan Carey on Social Media

Here are some of my other social media sites: