Abhijit Vyas

About Abhijit Vyas

Seasoned Database Engineer and ArchitectBig Data Technical Experience: 20+ years Databases: Teradata, Oracle, Bigquery, Bigtable, Cloud Spanner, Cloud SQL, SnowflakeETL Tools: Informatica, Cloud DataflowBI Tool: Tableau,Looker, MicrostrategyPublic Cloud: GCP, AWS Programming Language: Shell, Python, SQLSpecialities: Database Administration, Capacity Planning and Budgeting, Performance and Workload Management, Database Security and Compliance, Petabyte Scale Database Migration,Team Building, Data Quality and Governance, Benchmarking and Replatforming, Data ArchitectureCertification: GCP Professional Cloud Architect, Teradata V14 Certified Master

Experience

1. Senior Mts Database Engineer

   PayPal

   Apr 2022 — Present · San Jose, CA, US

   1) Successfully led the migration of a petabyte-scale enterprise data warehouse (EDW) from on-premises Teradata to Google Cloud Platform\'s BigQuery. As the chief architect, I designed and implemented a high-throughput data migration pipeline, ensuring optimal performance and cost-efficiency. My role as a Subject Matter Expert (SME) in GCP included advising on workload optimization during migration. I played a crucial role in SQL translation and contributed significantly to the advancement of GCP\'s BigQuery, tailoring it to meet PayPal\'s complex analytical processing requirements.2) Managed the migration and integration of Venmo\'s Snowflake warehouse into a unified, company-wide EDW. This strategic consolidation combined Data Warehouse and Data Lake into a single platform, enabling centralized data access. This initiative significantly enhanced analysts\' productivity by reducing data quality issues, technical debt, and data duplication. My leadership in this project fostered a more efficient and streamlined data management environment.

Education

• Sardar Patel University

  Master of Engineering, Computer Science

  2002 — 2004

• Sardar Patel University

  Bachelor of Engineering, Information Technology

  1997 — 2001

Skills

• Data Integration
• Geospatial Data
• Erwin
• Sdlc
• Oracle
• Business Intelligence
• Tableau
• Performance Management
• Analytics
• Systems Analysis
• Data Warehouse Architecture
• Data Migration
• Business Objects
• Priority Setting
• Architecture
• Sql
• Capacity Planning
• Linux
• Database Administration
• Big Data
• Hive
• Data Warehousing
• Database Design
• Unix
• Etl
• Enterprise Architecture
• Teradata Hadoop Bridge
• Informatica
• Teradata
• Unix Shell Scripting