Andrew James

Andrew James Email and Phone Number

Certified AWS Data Architect, Snowflake Architect, Data Warehouse Architect, Data Lake Architect, Advanced Analytics ML Architect, Enterprise AI Architect, Enterprise Architect @ Oceanside, CA, US
Oceanside, CA, US
Andrew James's Location
Oceanside, California, United States, United States
About Andrew James

100% REMOTE consultant. Dual residence in CA & FL. Working remote. 30+ US years Hands-on experience as a Data Architect consulting to fortune 500. Certified AWS solution Architect for 12 years with over 3 dozens AWS migrations. Azure migrations since 2016. Enterprise AI Architect, Certified Snowflake Technology Partner & Snowpro. Snowflake architect (or admin) since 2016 with dozen of migrations. Can Be one-man team building first class advanced analytics cloud systems end-to-end. Was a university of CA professor teaching AI/ML graduate program. Digital Transformation or Modernization projects.Expert in data warehousing, dimensional modeling and certified in data vault 2.0.Expert in Redshift (20 large implementations) design & tuning. Machine Learning & Predictive Analytics. BI/DW Architect/DBA of over 70 projects on-premise or cloud. Modernize Enterprise architecture with focus on EDW to deliver value to business. Data lakes. Private & Hybrid cloud. Optimal server-less architecture.Spark, DBT, Airbyte, Talend, Matillion, Data Bricks, Python, Kafka. Encryption, RDS, Azure & Splunk.AI/ML: Machine Learning, LLM, NLP, text analysis, Supply Chain Control Tower, Snowflake Cortex.Lead Infrastructure Architect for Sun Oracle "Business Intelligence Center of Excellence". Hands-On lead to design data center infrastructure for DWs & ERP using servers, storage, networks, load balancers. BI Architect for JP Morgan Chase Architecture Review Board (ARB). Developing cloud strategies, roadmaps. Architecting cloud solutions end to end. Senior DBA: Postgres, Mongo, DynamoDB, Aurora, Oracle, MySQL, SQL*Server, DB2. Expert in IBM mainframe!AWS advisory services to include demos, stack selections and Pilots to provide cost efficient optimal architectures and help enterprises avoid costly mistakes.EC2, EBS, S3, RDS, VPC, DynamoDB, Route53, ELB, IAM, CloudFront, CloudFormation CDN, Lambda, NoSQL or SQL (Oracle, SQL*Server, DB2, MySQL) data modeling & administration.Senior BI Architect for 22 years.ETL tools. OLAP (Cognos, Business Objects, Microstrategy, Jasper, & Tableau), mapping, ERWIN, dimensional modeling using Kimball. Expert in Adobe Marketing Cloud (marketing automation).Experience with Big Data on AWS EMR, Kinesis, HortonWorks.Certified AWS Solution Architect for 12 years. Certified Snowflake Technology Partner & SnowPro.Extensive experience in AWS & Azure since 2013. Snowflakes migrations since 2016, architecture, administration, optimization & POCs. Certified Data Vault Practitioner 2.0. AWS Well-Architected Framework certified.

Andrew James's Current Company Details
Leading Health Insurance

Leading Health Insurance

Certified AWS Data Architect, Snowflake Architect, Data Warehouse Architect, Data Lake Architect, Advanced Analytics ML Architect, Enterprise AI Architect, Enterprise Architect
Oceanside, CA, US
Andrew James Work Experience Details
  • Leading Health Insurance
    Leading Health Insurance
    Oceanside, Ca, Us
  • Leading Health Insurance
    Cloud Modernization - Health Insurace Opimization - Azure Snowflake Migration, Data Warehouse
    Leading Health Insurance 2024 - Jul 2024
    Health insurance migration from Netezza to Snowflake Azure Data Vault. Erwin Data Modeler 12.5, dimensional modeling, Facets, Epic, Claims, plan membership, eligibility, HL7 ADT, EPP & HPCS. Data Warehouse, Data Lake, Digital Health Record. Data modeling, technical reviews of development deliverables to ensure best practices, enterprise standards. Clinical & non-clinical member data, HIPAA.
  • Health Care - Remote Contract
    Aws Data Architect, Redshift Admin, Redshift To Snowflake Migration Advisory
    Health Care - Remote Contract 2023 - Dec 2023
    Leading health care provider requested an audit of their analytics Redshift based architecture, database model, poor performance issues and replacement of their AWS data pipelines. Investigated their Redshift design, recommended server & software configuration upgrades. AWS Glue POC with Spark, Studio, Kafka, Kubernetes, workflow & Aurora. Educated team on advanced features to streamline ETL. Presented CEO with modern enterprise event based architecture based to meet requirements. Prepared Redshift to Snowflake Azure detailed migration roadmap, strategy, cost benefit analysis and code needed to migrate with zero downtime. Presented findings to IT leadership & executives.
  • Leading Retailer
    Enterprise Data Architect – Enterprise Ai Architect - Leading Retailer – Supply Chain & Wms Domain
    Leading Retailer Feb 2022 - Nov 2022
    Responsible for the leading retailer data platform migration from On-premise Hadoop to Snowflake/AWS, S3 data lake, Snowflake EDW data warehouse using Data Vault 2.0, Talend, Tableau & Microstrategy. Integration to SAP ERP, SAP BW, MDM Stibo, Customer Data Platforms like Segment & Lytics. Enterprise AI: Vendor management of Supply Chain Control Tower for Warehouse management, inventory optimization & demand forecasting dashboards. Identifying Snowflake ingestion patterns for the enterprise following best practices. Design of Snowflake HA/DR & Secure Data Sharing. Data Standards, Data Modeling, Canonical Models, information governance standards in agile environment. TOGAF, ABB & SBB.
  • Health Care
    Senior Snowflake Architect & Lead Snowflake Database Administrator
    Health Care Mar 2021 - Feb 2022
    Senior Snowflake architect –Leading health care company migrating its analytics to Snowflake. SaaS from PostgreSQL & new development, AWS, data warehouse, Data Vault 2.0, Talend, Tableau, IDERA data modeling tool, Architecture. Designed and implemented Snowflake data model, account setup/configuration, PII data masking strategies, RBAC security model Cost efficient & optimal scalable architecture. Daily administration, problem solving & performance monitoring.
  • Insurance - Remote
    Aws Data Architect, Data Lake, Data Warehouse, Redshift, Snowflake, Roadmap/Strategy,Stack Selection
    Insurance - Remote 2019 - Apr 2021
    Brand new implementation of AWS Redshift EDW & Data Lake. Working closely with the visionary CTO & Infrastructure Director to move the leading insurance company to the cloud and build first class enterprise cloud data lake in S3 & Redshift data warehouse platform for cost-efficient optimal scalable analytics solution to drive the business analytics to the next level.Hands-on data cloud architect provided architectural artifacts for:* Cloud vendor & technology stack selection* Roadmap & Strategy to move the enterprise to Modern Enterprise Architecture coming from legacy mainframe and Outdated SQL Server. The solution to deliver Enterprise view of the customer & property for the first time as we are joining 2 ERP systems then migrate to Guidewire. Results include significant cost savings & faster time to market.* High Level Design for data lake & data warehouse* developed Data Model for Redshift for business friendly reporting and migrate databases to Redshift* developed ETL CDC Data Pipelines to meet SLA* Working with analysts to select tables to migrate to AWS* Provided options (Snowflake) beside Redshift for POC with extensive Technology Matrix Comparison* Project was a success on time and on budget Data sources: mainframe & SQL Server. Architecture and implementation of databases, ETL to S3 & Redshift.
  • Leading Health Care Government Agency
    Data Architect-Engineer (Remote)
    Leading Health Care Government Agency 2021 - 2021
    Support and enhancement of Center of Medicare and Medicaid (CMS) systems, Medicaid Management Information System (MMIS), State Medicaid Agencies (SMA), EHR, EMR, Federal Financial Participation (FFP), Data & Analytics Services (DAS), Center for Clinical Standards and Quality (CCSQ). Hadoop EMR Hive, Airflow, SAS Viva, Mainframe. Data Warehouse, Data Governance, Claims, Assessments, AWS, CMS MDM, Providers and Beneficiaries.
  • Software As A Service Provider - Concurrent Remote Contracts
    Aws Redshift To Snowflake Migration - Cloud Data Warehouse & Analytics Architect
    Software As A Service Provider - Concurrent Remote Contracts 2019 - Nov 2019
    SaaS provider elected to migrate their EDW, Data Lake & Data Science Analytics platform from AWS Redshift to Snowflake. Audit, optimize and enhance their future Snowflake infrastructure, data model, design, Matillion ETL & S3 architecture. Recommend & implement optimal, scale-able & cost-efficient architecture. Design Data Sharing Strategy. Snowflake powerful SQL, Snowflake Functions to develop optimized scalable data pipelines and ETL.
  • Leading Ecommerce
    Data Steward - Aws Data Compliance Contractor
    Leading Ecommerce 2019 - Sep 2019
    Interface with chief of information security CIS, SVP & CTO to perform extensive audits of the enterprise data compliance. The leading enterprise migrating its whole infrastructure to AWS Cloud. In addition, they sold their largest bus unit. Audit to ensure that they are in compliance with strict regulations. I audited AWS Aurora, SQL Server EC2 & HortonWorks EC2 data. Performed complex analysis in summarized business terms and effectively communicated with technical teams & executives, running extensive queries. Submitted signed professional artifacts to meet future auditing needs to CTO & legal dept.Audited and documented current data warehouse ETL Process Flow down to SQL Queries and made recommendations as they are migrating their analytics/data lake to AWS S3, Glue, Athena, Python & Spark.
  • Renewable Energy (Wind & Solar) Equipments & Sensors Manufacturing Leader - Remote
    Azure/Aws Analytics Architect, Roadmap & Strategy, Technology Stack Selection
    Renewable Energy (Wind & Solar) Equipments & Sensors Manufacturing Leader - Remote 2019 - 2019
    Global leader in manufacturing of renewable energy (wind & solar) equipments & sensors. Telemetry data collected at scale. Working with management, architects, data scientists & engineers to craft roadmap & strategy to guide in their due diligence to migrate to the cloud. Extensive evaluation of cloud vendors, products and technologies, documentation, demos to serve the company in key areas including data advanced analytics & data science scalability issues. Created powerful powerpoints to gain key stakeholders buy-in to highlight benefits, roadmaps and milestones. Understanding of Scada data, wind & solar advanced analytics use cases and competitive global market landscape. Presented architectures to meet requirements and staff skills.Technology comparison matrix, Azure Blob Storage, Data Lake, Data Warehouse & advanced analytics (ML) Data pipeline architecture in Azure Data Functions, Data Catalog & Azure Databricks. AWS Data Lake, Snowflake, Spark, Redshift, DW, Lambda, S3 & GCP storage. Project completed using half budget and timelines.
  • Contractor E-Commerce, Health Care, Manufacturing & Kiosks Vendor - Remote
    Cloud Data Warehouse, Data Lake & Advanced Analytics Architect
    Contractor E-Commerce, Health Care, Manufacturing & Kiosks Vendor - Remote 2018 - 2019
    =AWS Professional Services - Healthcare HIPAA: -Brand new implementation of AWS Analytics & Data Lake. Design/implementation of AWS Data Lake & ETL pipelines for CDC from SQL Server to S3, Glue, Python SDK, Spark, Lambda, DMS & PII challenges. = Brand new implementation of AWS Redshift/Snowflake EDW & Data Lake. E-commerce: Cloud data warehouse, data lake, analytics landscape and tools/vendor evaluation. AWS Redshift & Snowflake with Tableau. Snowflake powerful SQL, Snowflake Functions to develop optimized scalable data pipelines and ETL. - DW Data modeling. - DW & Data Lake best practices-Data Governance Committee Charter,Policy & Program Charter-Business Intelligence Steering Committee Charter & Center of Excellence-Presentation to the executives on business case for Data Warehouse Initiative & Data Strategy--Identifying skills needed and interviewing candidates- Recommendations on Tableau Optimization=Streaming analytics: POC Real time Fraud detection using Spark Streaming, Spark ML, Kafka, Cassandra & Airflow=Health Care: Postgres DBA consultation on performance and migration to AWS HIPPA.Consulting e-commerce leader on Data Warehouse - Data Governance initiative and Center of Excellence, Evaluation of current state & recommendations on Future architecture of Business Intelligence & Predictive analytics (Machine Learning)
  • University Of California, Irvine - The Paul Merage School Of Business
    Aws Architect, Big Data, Machine Learning, Advanced Analytics, Spark, Prds - Contract
    University Of California, Irvine - The Paul Merage School Of Business Aug 2017 - Jun 2018
    Irvine, Ca, Us
    Taught graduate advanced analytics program classes in AWS technologies, Spark, advanced analytics, Big Data (EMR), MongoDB, Postgres, Python, R, Databricks, Jupyter, Zeppelin, Altrex & Databases. Technology coordinator for Data Science & Machine Learning graduate programs. Support real life projects using machine learning models in areas: fraud detection, predictive maintenance, customer retention & demand forecast..Created & managed the AWS account for the graduate program to provide Cost-efficient optimal account structure that delivered SIGNIFICANT COST SAVINGS to the university. Taught classes in AWS, Big Data & advanced analytics. Consulting professors, Data Scientists & Machine Learning graduate students to prepare/clean their big data for machine learning real life projects with leading companies in areas such as customer churn, fraud detection, demand forecasting and healthcare analytics. Python, R, RStudio, Zeppelin, Jupyter, Spark, ML.. Managed AWS program account security for in-house and external companies. Technical resource for the university on challenging AWS projects. Created and managed AWS account for cost efficiency.
    View
  • Retailer Saas Cloud Migration, Telematics Edw Modernization, Education Advanced Analytics - Remote
    Cloud Data Warehouse, Adavanced Analytics, Business Intelligence, Aws Architect, Nosql, Big Data
    Retailer Saas Cloud Migration, Telematics Edw Modernization, Education Advanced Analytics - Remote Jan 2017 - Jun 2018
    =Brand new implementation of AWS Redshift EDW & Data Lake. Building telematics events data warehouse in AWS Redshift, GLUE, Python, PySpark, Spectrum, Paquet, Nested JSON, Kafka, ZooKeeper, S3 Data Lake.=Brand new implementation of AWS Redshift EDW & Data Lake. SPARK, PySpark for data scientists, dataframes, RDD, databricks, Python, R, RStudio, Jupyter, Anaconda, EMR, Zeppelin, SPARK performance and best practices. =Brand new implementation of AWS Redshift EDW & Data Lake. Technical Lead/Architect building next gen AWS data warehouse for community colleges. Managing AWS Data Lake. Redshift, S3, Data pipeline. Student Information System & Student Learning System.=Brand new implementation of AWS Redshift EDW & Data Lake. Telematics EDW & Analytics migration from Oracle, Informatica to AWS Hadoop, HortonWorks HDP, HIVE, Sqoop, Spark,Hybrid (cloud & On-premise) model for efficiency, Cost savings and meeting batch window.Led POCs for Informatica cloud. Recommended Tungsten for cost savings, performance & faster results.=Brand new implementation of AWS Redshift EDW & Data Lake. Consult Retailer building SaaS Multi-Tenant Point of Sale Cloud Analytics Application on cloud vendors selection, technology stack selection, database (SQL/NoSQL), data warehouse/analytics platform, BI/reporting tools & SaaS architecture options with documented cost benefit analysis and capacity plan, vendor negotiations. Initial architect for multiple vendors.Google Cloud SQL For Postgres, Cloud Shell, BigQuery.=Consult software vendor to audit current Oracle database configuration to perform and scale. Document database configuration audit, tuning recommendations and best practices.
  • Independent Contractor
    Most Of Proud Accomplishments
    Independent Contractor 1995 - May 2018
    - Over 3 dozens of successful Cloud EDW & Data Lake implementations using AWS Redshift, Snowflake, S3, RDS, GLUE, Spark, Python.- Business Intelligence Architect for JP Morgan chase to evaluate current state, evaluate BI tools and develop recommendations, roadmap & strategies. Appointed as a member in Architecture Review Board.- Lead Business Intelligence Architect for Sun Oracle BI Center of Excellence building Data Warehouse Reference Platforms for high profile clients from Infrastructure to DW implementations end-to-end managing Large data center & teams.- Selected to teach in University of California to Advanced Analytics Graduate Program (focus on AWS, Machine Learning & AI). Initiated & managed AWS account and architect/implement solutions for professors and Students.- Microsoft kimball: Started in data warehousing in the mid 90's with Big 4 company. Shortly after I joined Dr. Ralph Kimball 4 people team in InfoDynamics to build large data warehouse for Microsoft. - Technical Lead & Data Warehouse Architect for organizations like Health & Welfare Dept, Community Colleges Tech Center & a School District to design Infrastructure for DW implementations end-to-end in AWS Cloud TRYING to make a difference for students/colleges, benefits recipients and communities. Appointed to be a member in Architecture Review Committee.- Since 2014, Obtaining several AWS Architect Certification and selected to be authorized trainer for certified Amazon classes to architects & Big Data professionals.- Few Snowflake certifications as Technology Partner or Snowflake Pro. - HP: evaluated large number of leading BI tools and the eval was published in HP knowledge base as a technical resource for the enterprise in the late 1990's.-Sun: Performance Engineer: delivering best performance for Oracle ERP on Sun platforms
  • Big 4, Social Gaming & Department Of Health Hipaa
    Expert Aws Cloud Architect, Aws Consulting Partner, Big Data, Analytics & Bi/Dw Architect
    Big 4, Social Gaming & Department Of Health Hipaa Jun 2012 - Dec 2016
    Principal Certified AWS Cloud Architect & Technology Partner. Azure, SoftLayer, Private & Hybrid cloud architecture & brokeringBig Data Architect - Hadoop (Cloudera & HortonWorks) , NoSQL (MongoDB)20+ years Business Intelligence/Data Warehousing Architect, DBA, performance engineerHelp companies move to modern enterprise architecture by incorporating Hadoop, cloud technology & NoSQL.Hands-on Leader of over 50 cloud, Hadoop, NoSQL, BI/DW & database evaluations and pilots that delivered high ROI.Cloud projects:Porting HIPPA SaaS Health Care application w PHI from AWS to AzureFast & cost efficient initial assessment. Requirements collection.Cloud vendors evaluationHybrid data warehouse & reporting using DynamoDB, Redshift & TableauOn-premise Oracle migration & Disaster Recovery/HA on AWSMySQL, MongoDB migration to MySQL RDS, AWS DynamoDBPostgres migration to AWS MongoDBAWS infrastructure & Media Streaming for social gaming company, CDN, recommendation enginePre-sales support, projects qualification & sizingAWS Machine Learning, predictive models & PythonBig Data Projects:Telematics IOT Trucking application - Storm, Kafka, Spark, HDPEDW Modernization, Claudera, TalendFast & cost efficient initial assessmentHadoop vendors evaluation & selectionInstallation, configuration, administration & optimization of Cloudera & HortonWorksData Discovery Sandbox, Customer 360, Data Lake pilotDatabase Projects:Installation, configuration, administration, security architecture, optimization and bench marking and stress testing of several SQL/NoSQL databases.NoSQL databases evaluation & selectionMigration from SQL to NoSQL platform like MongoDBNoSQL MongoDB modeling & optimizationSenior Oracle DBA for 10+ yrs.Data Warehouse, Business Intelligence:Data Warehouse modernization with Hadoop, performance tuning.Dimensional modeling for star schemaDatabase, storage and application performance optimizationSalesForce & Pivotal CRM integration
  • Cloud Migration Architect
    Cloud Architect & Strategist
    Cloud Migration Architect Oct 2013 - Nov 2016
    Newport Beach, Ca, Us
    http://www.linkedin.com/company/cloud-migration-architectLeading Hands-on several cloud migration, cost optimization, technology stack selection, vendor evaluation, pilots & implementations for large enterprises or startups.Successful database migrations & optimization from SQL to AWS RDS SQL with near zero downtime. Drastic cost reduction, increase performance, reduce administration workload & eliminate need for patches & upgrades projects.Successful database migrations, modeling & optimization from SQL to AWS NoSQL with near zero. downtime. Improved performance, availability, scaling, simplified replication & reduce cost. Migrate Oracle DR to AWS Oracle RDS.Developing cloud migration roadmap & strategies for HIPAA Health Care SaaS application on AWS & Azure. Audit of AWS architecture & security model.
    View
  • Fortune 500 Companies
    Data Warehouse Architect, Data Architect, Business Intelligence & Analytics, Database Architect
    Fortune 500 Companies Jun 1980 - Jan 2015
    Kapolei, Hi, Us
    Principal AWS Cloud Architect & Certified Technology PartnerBig Data Architect - Hadoop (Cloudera & HortonWorks) , NoSQL (MongoDB)20+ years Business Intelligence/Data Warehousing Architect, DBA, performance engineerHelp companies move to modern enterprise architecture by incorporating Hadoop, cloud technology & NoSQL into their architecture.Hands-on Leader of over 50 cloud, Hadoop, NoSQL, BI/DW & database evaluations and pilots that delivered high ROI.Cloud projects:Fast & cost efficient initial assessment. Requirements collection.Cloud vendors evaluation & selectionData Warehouse & analytics using Redshift, Tableau, PentahoHybrid data warehouse & reporting system using DynamoDB & RedshiftOn-premise Oracle migration to AWSOracle Disaster Recovery/HA on AWSMySQL migration to MySQL RDSMongoDB migration to AWS DynamoDBPostgres migration to AWS MongoDBMedia Streaming for gaming companyPre-sales support, projects qualification & sizingBig Data Projects:Fast & cost efficient initial assessmentHadoop vendors evaluation & selectionInstallation, configuration, administration & opimization of Hadoop for Cloudera & HortonWorks.EDW ModernizationTelematics Trucking use caseData Discovery Sandbox, Customer 360, Data Lake pilotDatabase Projects:Installation, configuration, administration, security architecture, optimization and bench marking and stress testing of several SQL/NoSQL databases.NoSQL databases evaluation & selectionMigration from SQL to NoSQL platefrom like MongoDBNoSQL MongoDB modeling & optimizationSenior Oracle DBA for 10+ yrs.Data Warehouse, Business Intelligence:Built over 50 large scale projects implementing data warehouse or data marts from end to end at different capacity from architect and/or DBA.Evaluation of databases, ETL tools & OLAP tools that was published by top tiers technology companies.Metadata creation & management.Dimensional modeling for star schemasDatabase, storage and application performance optimization
    View

Andrew James Skills

Business Intelligence Data Warehousing Data Modeling Big Data Cloud Computing Hadoop Microsoft Azure Database Administration Mongodb Solution Architecture Database Design Machine Learning Data Migration Strategic Consulting Advanced Analytics Data Visualization Sas Programming Online Gaming Saas Json Salesforce.com Cognos Business Objects Bash Red Hat Linux Centos Ubuntu Docker Amazon Redshift Aws Training Aws Solution Architecture Tableau Architecture Customer Retention Integration Python R Informatica Cloud Databases Amazon Elastic Mapreduce Snowflake Cloud Migration Apache Spark Cloud Cost Optimization Data Science Big Query Google Google Cloud Sql Dimensional Modeling Cassandra Apache Kafka Amazon Web Services Training Regular Expressions Vmware Esx Vmware Infrastructure Virtualization Azure Hdinsight Jenkins Attunity Forecasting Containerization

Andrew James Education Details

  • University Of Toronto Equivalent
    University Of Toronto Equivalent
    Computer Engineering

Frequently Asked Questions about Andrew James

What company does Andrew James work for?

Andrew James works for Leading Health Insurance

What is Andrew James's role at the current company?

Andrew James's current role is Certified AWS Data Architect, Snowflake Architect, Data Warehouse Architect, Data Lake Architect, Advanced Analytics ML Architect, Enterprise AI Architect, Enterprise Architect.

What schools did Andrew James attend?

Andrew James attended University Of Toronto Equivalent.

What skills is Andrew James known for?

Andrew James has skills like Business Intelligence, Data Warehousing, Data Modeling, Big Data, Cloud Computing, Hadoop, Microsoft Azure, Database Administration, Mongodb, Solution Architecture, Database Design, Machine Learning.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.