Ashish Srivastava

Migrating complex IBM DB2 stored procedures into Dataform SQLX models, enabling scalable and cloud-native data transformations in BigQuery. Designing and orchestrating real-time and batch data pipelines using Pub/Sub, Dataflow, Airflow Composer, and Cloud Functions. Automating ETL workflows and CI/CD tasks with Python, PowerShell, and MS SQL, improving efficiency and reducing manual work. Implementing automated reporting solutions using PyAutoGUI and MSS to capture and email dashboards with zero manual effort. Using Cloud Monitoring and Logging for proactive pipeline health checks, job failure alerts, and performance tuning across GCP services. Performing distributed data processing with PySpark in Dataproc, optimizing large-scale data transformation and analytics workloads.

Managed MS SQL Server services including Database Engine across production and development environments. Handled database mirroring, log shipping, replication, and configured disaster recovery (DR) and high availability solutions. Performed regular backups, restores, and implemented automated maintenance plans for index fragmentation and stats updates. Tuned performance by analyzing query plans, resolving blocking/deadlocks, and optimizing indexes and stored procedures. Automated tasks using SQL Agent jobs and PowerShell, managed security, access controls, and ensured compliance and audit readiness.

Managed and optimized supplier catalog data pipelines by integrating internal tools with GCP services like Cloud Storage and BigQuery for centralized reporting. Analyzed large volumes of product and supplier feedback data, using SQL and BigQuery to generate insights for resolving catalog-related issues. Automated ingestion and processing of catalog files using Cloud Functions and scheduled batch jobs, improving supply chain data freshness. Collaborated with cross-functional teams to migrate legacy supply chain workflows into scalable GCP-based pipelines. Used Cloud Monitoring to track data flow issues and ensure reliable performance of supplier issue resolution systems. Built and maintained dashboards for catalog operations using BigQuery views, enabling visibility into item availability, pricing accuracy, and supplier SLAs.