Andrew J Email & Phone Number

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

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

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

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

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

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.

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. Data Migration and analytics to AWS from IBM mainframe & SQL Server. Technology stack selection. Design, architecture and implementation of Data Warehouse, Data Lake, data.

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

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

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

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