Working 100% remote. 30+ years US experience as highly accomplished Business Intelligence architect, Hands-on cloud Architect for fortune 500 companies. Three dozen of migration projects to AWS/Azure data lakes, Redshift & Snowflake warehouses. Specializing in powerful designs to extract maximum business benefit & high ROI from Intelligence & Insight investments. Extensive background in machine learning & data pipelines. Enterprise AI. HIPAA certified by Big 4. Big 4 consulting experiences. Certified AWS Solution Architect for 11 years. Certified Snowflake Technology Partner & SnowPro.Extensive experience in AWS & Azure since 2013. Snowflakes migrations since 2016, architecture, administration, optimization & POCs. Completed authorized AWS instructors training. Certified Data Vault Practitioner 2.0. AWS Well-Architected Framework certified. Big 4 consulting experiences.Over 25 Years’ experience as an architect building Data Warehouses, Data Lakes & Lambda architecture.Azure Cloud Migrations: Architect for companies like NRG Energy, E3Retail & fortune 500. Use of ADF, Azure Blob Storage, Azure Containers, VPC & Azure ADAWS Cloud Migrations: Key player or one-man team, hands-on AWS migrations & modern enterprise architecture. Expert in Kafka, SQL & NoSQL databases. AWS, Azure, private & hybrid Cloud. Senior DBA: DB2, Postgres, Mongo, DynamoDB, Cassandra. Aurora, Oracle, MySQL, SQL*Server.AWS: Lake Formation, Quicksight, EMR, GLUE, EC2, EBS, S3, RDS, VPC, Aurora, DynamoDB, Route53, ELB, IAM, CloudFront, CDN, Cloud Formation Lambda, Python. Linux, JSON.AWS Security: AWS IAM, SCIM, SSO, SAML 2.0, OAuth 2.0, OKTA, OpenID Connect OIDC, DAC, RBAC, Encryption E2EE, ADFS, VPC, Vault, Guardrail, IPS/IDS, Snowflake Security.Over 25 Years’ experience as an architect building Data Warehouses, Data Lakes & Lambda architecture. Taught in University of California Graduate Program: AWS, Spark, ML, Postgres, Python & Big Data.Enterprise & Data architecture: Requirements, Modeling, Hadoop, database design, ETL, HA/DR, SaaS. Expert in migrating enterprises to Modern Enterprise Architecture using cloud technology, data governance, MDM. Roadmaps, strategies charters, stack selections, pilots and vendor co-ordination.ETL, CDC & SCD: Informatica, Informatica Cloud, Snaplogic, Talend, SSIS, OBIEE, Cognos.Data modeling (logical, physical, dimensional, data vault & Kimball), ERWIN, Sparx EA, ER Studio, TOGAF. Metadata, mapping & aggregation strategies.AI/ML: Machine Learning, LLM, NLP, text analysis, Supply Chain Control Tower, Snowflake Cortex.
-
Cloud Modernization – Health Care Modernization - Snowflake Azure Edw Migration ContractLeading Health Care Insurace Company 2024 - Jul 2024Leading health insurance provider migration from Netezza to Snowflake Azure Data Vault 2.0, Erwin data modeler 12.5, DBT, dimensional model, HL7 ADT, EPIC, FACETS, SAP, Claims, Membership, Eligibility. Data modeling standards. Data Modeling Review committee member, Story board, JIRA, CI/CD, data profiling, Review of vendor deliverables, large volume data profiling & analytics. Medicaid, Medicare, EHR, EMR, HIPAA, HHS. Migration procedures optimization and best practices.
-
Aws Data Architect – Health Care Digital Transformation - ContractHealth Care - Remote Contract 2023 - Dec 2023Leading health care provider requested an audit of their analytics PostgreSQL & Redshift based architecture, database model, poor performance issues and replacement of AWS data pipelines. Investigated Redshift design, recommended server & software configuration upgrades. AWS Glue POC with Spark, Studio, Kafka, Kubernetes, HIPAA, workflow & Aurora. Educated team on advanced features to streamline ETL. Presented CEO with modern enterprise event based architecture. Data modernization initiative: Prepared Redshift to Snowflake Azure detailed migration roadmap, strategy, cost benefit analysis and code needed to migrate with zero downtime. Presented findings to Leadership. HL7, ADT, Claims, Membership & Eligibility.
-
Aws Snowflake Data Architect – Retailer, Supply Chain & Wms Digital Modernization, Enterprise AiLeading Retailer - Supply Chain & Wms Domain - Enterprise Ai Feb 2022 - Nov 2022Received the highest recommendation letter from the company leadership on successful implementation of Snowflake EDW. Responsible for the giant retailer data platform migration from On-premise Hadoop to Snowflake/AWS, S3 data lake, Snowflake data warehouse using Data Vault 2.0, dimensional modeling, Talend, Tableau & Microstrategy. Integration to SAP ERP, SAP BW, Data Governance, 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. Snowflake stored procedures, Snowflake scripting, Snowflake RBAC, Kafka, Kubernetes, AWS security, Snowflake HA/DR & Secure Data Sharing. Data Standards, Data Modeling, Canonical Models, information governance standards in agile environment. Architecture Review Board, PostgreSQL, TOGAF, ABB & SBB.
-
Senior Aws Snowflake Data Architect – Tabula Rasa Health Care Digital ModernizationHealth Care - Hipaa Remote Contract Apr 2021 - Feb 2022Data modernization project: Migrating health care company SaaS analytics from PostgreSQL to Snowflake AWS & new development. Data warehouse, Data Vault 2.0, dimensional modeling, Talend, Tableau, Kafka, IDERA data modeling tool, MDM, Architecture. Designed and implemented Snowflake data model, account setup/configuration, HIPAA, PII data masking, RBAC security model, Cost efficient optimal scalable architecture. Administration, production support, problem solving, performance tuning & monitoring.
-
Oracle-Sql Server-Sales Force To Aws Redshift Data Migration ArchitectLeading Usa University - Remote Contract Sep 2020 - Apr 2021Received the highest recommendation letter from the company leadership on successful implementation of Redshift. Digital modernization project: Received the highest recommendation letter from the company leadership on successful migration & implementation of AWS & Redshift. Migrating to AWS from Oracle & MS SQL include Salesforce, PeopleSoft & Financials. Building AWS Data Lake, Data Warehouse, Data Catalog, MDM, security model, network, monitoring & cost optimization infrastructure following best practices. AWS GLUE, Python, PySpark, Redshift Spectrum, PostgreSQL, S3, Transient Gateway, IAM, DMS, Kafka, Kubernetes, Lambda Layers, API Gateway, Serverless Framework, Serverless Application Model (SAM), Athena & Lake Formation.
-
Data Engineer (Remote)Leading Health Care Government Agency 2021 - 2021Support 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.
-
Aws Redshift Administrator - Aws Migration From Sql Server & Ibm MainframeLeading Usa Insurance Company Sep 2019 - Aug 2020Received the highest recommendation from the company leadership on successful implementation of Redshift EDW. Evaluated Azure vs. AWS echo system. Built new AWS Data Warehouse/Data Lake. Data Migration and analytics to AWS from IBM mainframe & SQL Server. Technology stack selection. Design, architecture and implementation of Data Warehouse, Data Lake, data model, Salesforce, databases, ETL from legacy systems to AWS S3, GLUE, Kafka, Kubernetes, SSO, Postgres, QuickSight, PowerBI & Redshift. Snowflake, designed and implemented POC.
-
Aws Redshift To Snowflake Migration - Cloud Data Warehouse & Analytics - Remote Dba/ArchitectLeading Software As A Service Provider - Concurrent Remote Contracts 2019 - Mar 2020** The leading retailer migrating MySQL, MDM to Aurora MySQL, building data lake, MDM and data analytics on AWS using S3, GLUE, Lake Formation, Athena & SageMaker. As AWS architect/DBA, I designed & maintained current system, security model, HA/DR, provide architecture/tools and migrate to AWS environment. Complex ETL design and development. Attended AWS Data Lake Labs in Amazon Seattle.** The leading SaaS provider with over 80,000 customers elected to migrate their EDW, Data Lake & Data Science Analytics platform from AWS Redshift to Snowflake, S3, Python, Snowflake powerful SQL/ETL, Snowflake Functions & Matillion ETL. I was brought in to optimize their future Snowflake infrastructure, data model, security, HA/DR, design, ETL & S3 architecture. Recommend & implement data model enrichment, optimal, scalable & cost-efficient architecture working with talented leadership and data engineers. Sources: SalesForce, MS SQL SSIS & TSYS.
-
Aws Data Architect – Ibm Mainframe & Ms Sql To Redshift - Remote Contract Dba/ArchitectLeading Insurance Co 2019 - Mar 2020Digital modernization project for insurance: Received the highest recommendation from the company leadership on successful implementation of Redshift EDW. Evaluated Azure vs. AWS echo system. Built new AWS Data Warehouse/Data Lake. MDM, Data Migration and analytics to AWS from IBM mainframe & SQL Server. Technology stack selection. Design, architecture and implementation of Data Warehouse, Data Lake, data model, Salesforce, databases, ETL from legacy systems to AWS S3, GLUE, Kafka, Kubernetes, SSO, PostgreSQL, QuickSight, PowerBI & Redshift. Snowflake, designed and implemented POC.Another role: AWS Data Architect - IBM mainframe, Oracle & MS SQL to Redshift:Digital modernization project for retailer: AWS migration from MS SQL/Oracle. AWS Data Lake design & implementation with SageMaker recommender - for leading retailer using AWS Lake Formation, Aurora MySQL RDS, S3, Redshift, EMR, Mulesoft, GLUE, Kafka, Kubernetes, PostgreSQL, Kinesis, MKS, PySpark & Python. Snowflake evaluation vs AWS tools like Redshift. Enterprise architecture recommendation. Working with Chief architect, CSO, infrastructure and engineering teams. Salesforce, Mainframe DB2, Security, DMS, KMS encryption, HA/DR and ETL architecture. Informatica MDM Customer 360, Mulesoft & Data Governance. AWS IAM, SCIM, SSO, SAML 2.0, OAuth 2.0, OKTA, OpenID Connect OIDC, DAC, RBAC, Encryption E2EE, ADFS, VPC, Vault, Guardrail, IPS/IDS. Binary classification, regression.
-
Data Steward - Aws Data Compliance ContractorLeading E-Commerce 2019 - Sep 2019Interface 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.
-
Data Warehouse Architect, Data Architect, Dba (Oracle, Postgres, Mysql, Aws, Ms Sql, Dynamodb)Independent - Concurrent Remote Contracts Jun 1989 - Sep 2019I specialize in migrating SQL/No SQL to the Cloud, on-time and Under Budget. No BS. SENIOR Database administrator for large scale data warehouses or mission critical OLTP applications. Experience on premise/cloud (AWS, Azure or hybrid). Certified AWS Solution Architect with over 14 large scale database migrations to AWS.AWS RDS, Redshift, Oracle, Postgres, MySQL, MongoDB, SQL*Server, DB2, Aurora and some Cassandra. Implement AWS Data Lake & ETL pipelines for Change Data Capture from RDBMS to S3 using, Glue, Python SDK, Spark, Lambda, DMS.Building data lakes to integrate AWS S3, Redshift, Kinesis, Athena, Glue, Elasticsearch, SageMaker & QuickSight. Experience with Private & Hybrid cloud.Experience scripting in Linux bash, Python, regex, SAS, RStudio, Big Data (Hive, Kafka< kinesis).Extensive Experience with Spark, PySpark, SQL, R, RStudio, Anaconda Jupyter, Spyder, Zeppelin.Performance Tuning, JMeter, benchmarks TPC-H, TPC-D.AWS S3, EBS, VPC, EC2, Cloud Front, CLoudFormation, Ansible, NGinx, automation.Few decades consulting for Oracle, Microsoft, HP, Sun, global gaming companies, cruise lines, airline reservation, banks, insurance companies and health care HIPAA. Google Cloud SQL For Postgres, Cloud Shell, BigQuery.In addition, Taught classes in University of California, AWS, Big Data & advanced analytics. Technical coordinator working with professors, Data Scientists & Machine Learning graduate students to prepare their big data for machine learning & AI real life projects with leading companies in areas such as customer churn, fraud detection, sales forecasting and healthcare analytics. Started & managed the AWS program account, managed security for in-house and external companies, providing cost-efficient architecture for the university budget saving the university thousands every month.Over 15 years experience with IBM mainframe, DB2, TSO/ISPF, COBOL, SAS and transformation to modern enterprise architecture.
Andrew J Education Details
-
University Of Toronto EquivelantElectrical Engineering
Frequently Asked Questions about Andrew J
What is Andrew J's role at the current company?
Andrew J's current role is Certified AWS Architect, Data Warehouse Architect, Data Architect, Cloud Modernization, Cloud Migration, Digital Transformation, Digital Modernization, Cloud DBA, Analytics Architect, Database Architect, Enterprise AI..
What schools did Andrew J attend?
Andrew J attended University Of Toronto Equivelant.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial