Pat Alvarado

About Pat Alvarado

Teradata Certified Master providing technical consultation on analytic ecosystem architecture, workload distribution, and multi-genre analytics across multiple platform and analytics technologies.I started my career as a hardware engineer in the early eighties building test instrumentation for mil-spec components and later point of sale systems for fine dining restaurants. After developing firmware for my micro controller hardware designs I moved into software engineering developing data management applications with open source GNU software on distributed UNIX servers and disk-less workstations based on the Berkeley Software Distribution (BSD) as a departure from the proprietary AT & T UNIX and became known as FreeBSD. Joined Teradata in 1989 providing technical education to hardware and software engineers on the DBC/1012 architecture and was part of the team building out the parallel software development environment on ClearCase.Presently provide consulting and thought leadership on open source software (OSS) and SQL engine architecture, document and NOSQL database systems, Hadoop distributed file systems (HDFS), exploratory analytics platforms, etc. both on-premise and in the cloud via SQL, SQL-ML, Java, Python and other open source languages and architectures for structured, unstructured, and evolving schemas. Manage technical consultants in the development and implementation of data analytics and machine learning. Development of relational and dimensional data models and universal modeling to bridge relational and non-relational schemas to support business processes.Japan liaison for establishing relationships between U.S. and Japan organizations through business processes. Leveraging cultural approaches to manufacturing through continuous process flow and leveling workload (heijunka) and applying a continuous improvement process (kaizen).

Experience

1. Sr Solutions Engineer, Oss & Sql Engine Architecture Consulting

   Teradata

   Jun 1989 — Present · Los Angeles, CA, US

   Provide technical consultation and implementation of analytical ecosystems based on the application of statistical methods across multiple platform and analytics technologies. This includes open source software (OSS) and open source technologies, Teradata SQL Engine, document and NOSQL database systems, Hadoop distributed file systems (HDFS), exploratory analytics platforms, etc. via Python, Java, SQL, SQL-MR, R, and other open source procedural languages and architectures for structured, unstructured, and evolving schemas. Leverage object relational mapping (ORM) to define relationships between non-relational and relational data sets. Active member to UCLA Extension Data Science Advisory Board representing Teradata leadership in enabling data science in an analytical ecosystem composed of open source, NoSQL, and relational technologies.Transform business objectives and goals into requirements for defining an analytical ecosystem architecture and roadmap. Manage resources in the development and implementation of data integration, business intelligence, and data science applications.Development of analytical applications leveraging statistical methods such as natural language processing (NLP), maximum entropy and Naive Bayes classification, sentiment analysis, etc. ETL and ELT application development combining SQL, Python, and Linux shell scripting. Performance analysis and tuning through SQL rewrites, collecting statistics, workload management, and physical database architecture.

Education

• Los Angeles Harbor College

  Computer Science and Statistics

• California State University, Los Angeles

  Electrical and Electronic Engineering

Skills

• Agile Application Development
• Big Data
• E-Learning
• C/C++
• Linux Shell Scripting
• R
• Software Project Management
• Crm
• Ieee 829 Software Testing Standards
• Mapreduce
• Universal Data Modeling
• Enterprise Data Modeling
• Data Architecture
• Linux System Administration
• Firmware
• Data Modeling
• Data Warehouse Architecture
• Analytics
• Database Design
• Software Development
• Python
• Olap
• Data Integration
• Data Science
• Hardware Engineering
• Databases
• Hadoop
• Etl
• Enterprise Architecture
• Learning Strategies
• Sql-Mr
• Consulting
• User Acceptance Testing
• Unified Data Architecture
• Oracle
• Requirements Analysis
• Integration
• Educational Technology
• Intel Assembly Language
• Teradata Data Warehouse