Navin Gupta

Experience

1. Technical Project Manager

   Tata Consultancy Services

   Jun 2017 — Present

   Client: Deutsche BankProject #1: Data Warehouse – GCP Data Engineering (Feb 2024 – Aug 2025)· Designed and implemented data pipelines using Google Cloud Dataflow to ingest and transform raw datasets from Google Cloud Storage (GCS) into BigQuery for analytics.· Built data warehouse models in BigQuery, optimizing schema design, partitioning, and clustering for performance and cost efficiency.· Developed end-to-end BI reporting by integrating BigQuery datasets with Looker dashboards, delivering actionable insights for business stakeholders.· Automated and scheduled ETL pipelines with Cloud Composer (Airflow on GCP) ensuring reliable, timely, and monitored data workflows.Project #2: BHW Home Loan and Saving Plan – On-Prem to On-Prem Migration (Feb 2024 – June 2025)· Migrated Solaris-based Oracle + COBOL + VB6 application from legacy infrastructure to modernized on-prem environment while preserving 100+ desktop clients.· Installed and configured core middleware components including CTG, UC4 Agent, and Oracle Agent; aligned security policies and firewall configurations with enterprise standards.· Integrated with Managed Microsoft AD to enable seamless SSO, eliminating credential sprawl and manual user provisioning.· Designed and implemented CI/CD pipeline using Bitbucket (source control), Artifactory (artifact management), and uDeploy (deployment automation) for end-to-end release lifecycle.· Led DevOps setup from scratch: installed agents, configured environments, defined deployment processes, and automated rollout to target application servers.· Authored detailed runbooks, audit compliance checklists, and SOPs; conducted operations training to ensure zero-day go-live readiness and post-migration support stability.Project #3: Unity Data Migration – Legacy Mainframe to Optimized DWH (Aug 2020 – Dec 2023)· Directed 20-member cross-shore team in executing high-volume SAS + JCL data movement.· Engineered ETL pipelines with zero data loss across

Education

• Uttar Pradesh Technical University

  Master of Computer Applications

• RBMI

  Bachelor of Computer Applications

Skills

• Sas Programming
• Jcl
• Market Research
• Db2
• Marketing Research
• Team Management
• Sas Certified Base Programmer
• Ibm Mainframe
• Sql
• Fileaid
• Advance Sas Certified Programmer
• Business Intelligence
• Data Warehousing
• Olap
• Oltp
• Sas
• Data Analysis
• Analysis
• Mainframe