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 profiling & analytics. Medicaid, Medicare, EHR, EMR, HIPAA, HHS. Migration procedures optimization and best practices.

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

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

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 security model, Cost efficient optimal scalable architecture. Administration, production support, problem solving, performance tuning & monitoring.

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

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.

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 model, Salesforce, databases, ETL from legacy systems to AWS S3, GLUE, Kafka, Kubernetes, SSO, Postgres, QuickSight, PowerBI & Redshift. Snowflake, designed and implemented POC.

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

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

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.

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