Andrew James Email & Phone Number

Oceanside, CA, US

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.

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.

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.

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.

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.

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.

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.

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 &.

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.

=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.

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.

=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.

- 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.

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.

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.

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.