Abbas Khan Pathan

• Design and Implementation for Hive to GCS and GCS to Bigquery migration
• Implemented the Bigquery Administration tasks like storage, slots, DBMS and snapshot implementation
• Designing the PII data implementation using the Google Data Catalog
• Redesign partitioning and clustering strategies to get cost benefits in GCP realm
• Load GCS data into Bigquery table and perform SCD using BQ Dynamic SQLs
• Having hands on experience on Cloud Spanner Instance and Spanner database management
• Auto provisioning solutions to VMs and Configuring the Cloud Sql - MySQL setup
• Implemented historical data migration using GCP transfer appliance and STS
• Provisioning the Vertex AI notebooks and integration with GCS for storing notebooks
• Setup the MLOps infrastructure using DataProc, DataFlow and Vertex AI Pipelines
• Having good hands on Cloud Storage versioning, Storage Classes and ACL
• Orchestration in Cloud composer setup and administration
• Configuring and implementation of IAM Groups, roles using Terraform
• GCP VM Administration like Disk management, software installation and User management
• Bed Bath & Beyond Inc
• Is an American-owned chain of domestic merchandise retail stores in the United States, Puerto Rico, Canada and Mexico
• Formed in 1971, the stores sell goods primarily for the bedroom and bathroom, as well as kitchen and dining room
• One Kings Lane is a home decor business that operates a furniture and home accessories sales and was acquired by Bed Bath & Beyond
• Trained on Kubernetes CKA: Having knowledge on Kubernetes architecture and its components
• Managing Resources like Pods, Labels & Selector, Replica Set, Service and DaemonSets
• Scheduling Resources using Taint and Tolerance and Deployment Strategies
• Managing Storage using PV & PVC and User access management using Role and RoleBinding
• Designing and provisioning the CICD pipeline implementation using Git and Jenkins
• Troubleshooting Cluster, Node and Pods and Logging & Monitoring
• Interacting with the onsite Coordinator for analyzing and gathering requirements

• Client Overview: Yum! Brands, Inc., based in Louisville, Kentucky, is the world's largest restaurant company in terms of system restaurants with over 39,000 restaurants in more than 130 countries and
• territoriesAnalyzed requirements, designed architecture, and developed technical solutions to meet customer needs.
• Lead a cross-functional team of engineers to develop highly scalable web applications using modern technologies such as Java, ReactJS, NodeJS.
• Planned and followed through with inventory management for each store.
• Managed resources across multiple projects by tracking progress, resolving conflicts, and meeting deadlines.

Client Overview: Yum! Brands, Inc.

• Yum! Brands, Inc., based in Louisville, Kentucky, is the world's largest restaurant company in terms of system restaurants with over 39,000 restaurants in more than 130 countries and territories
• Yum! is ranked #201 on the Fortune 500 List with revenues of over $13 billion in 2012
• The Company's restaurant brands - KFC, Pizza Hut and Taco Bell - are the global leaders of the chicken, pizza and Mexican-style food categories

Responsibilities:

• Expertise in data distribution on defining the keys using DISTKEY and SORTKEY
• Creating and Managing the query history and Amazon Redshift Workload management
• Having good exposure on External tables, Vacuum, Analyze and Zoned Maps
• Worked with IBM support for hardware issues
• Performing audit of host failure
• Interacting with the client for analyzing and gathering requirements
• ANALYZE, VACUUM and ZONEMAPs on tables
• Involved in PSQL and COPY scripts development
• Creating the User, Groups and role privilege management
• Yum! Brands, Inc., based in Louisville, Kentucky, is the world's largest restaurant company in terms of system restaurants with over 39,000 restaurants in more than 130 countries and territories
• Yum! is ranked #201 on the Fortune 500 List with revenues of over $13 billion in 2012
• The Company's restaurant brands - KFC, Pizza Hut and Taco Bell - are the global leaders of the chicken, pizza and Mexican-style food categories

Client Overview: CIBC - Canadian Impercial Bank of Commerce.

• Card Products uses DSE-MIS environment and services to carry out business analytics exercises and initiatives
• The current environment consists of two major components: the Mainframe environment (SY06) and a SAS (UNIX) environment
• Currently, the mainframe (SY06) stores 7+ year historical data (~40+ TB of raw data) for Statistical Analysis System (SAS) to process analytics and reports, both ad-hoc and pre-scheduled
• Involved in Netezza NPS upgrade from 7.1.1 to 7.2 patches
• Netezza migration from Twinfin to Mako
• Creating the User, Groups and role privilege management
• Involved in NZSQL, PSQL, ET, NZLOAD scripts development
• Creating and Managing the query history
• Netezza maintenance activities like host backup and nz_manual_vacuum
• Implemented dashboards for database utilization and Disk topology
• Workload management based on the business requirement
• Identifying a Slow disk, Proactively Failed a disk
• Assisting Development and ETL teams for new enhancements
• Prepared the NZBACKUP and NZRESTORE scripts
• Monitoring the NZPORTAL for Query performance and system usage
• Card Products uses DSE-MIS environment and services to carry out business analytics exercises and initiatives
• The current environment consists of two major components: the Mainframe environment (SY06) and a SAS (UNIX) environment
• Currently, the mainframe (SY06) stores 7+ year historical data (~40+ TB of raw data) for Statistical Analysis System (SAS) to process analytics and reports, both ad-hoc and pre-scheduled

• Creating/Managing User Accounts, Databases, Roles, Profiles
• Monitoring the system health, aborting the bad running queries, intimating the users about the same and helping them to tune the queries
• Database, User, Role and Profile creation and maintain
• Fixing any errors in Fast Load/MultiLoad scripts
• Database housekeeping activities like deleting unwanted tables, collecting necessary stats etc
• Good exposure to NetBackup, TARA for Database backup and restore
• Co-coordinating users and support teams during Un/Planned system outages
• Hands on exposure of primary technology/tool of Teradata are Fast load, Multiload, Fast Export, BTEQ, SQL Assistant, Teradata Administrator, ViewPoint, and TSET