Summary
Overview
Work History
Education
Skills
Baselocation
Certification
Workfromhomelocation
Languages
Personal Information
Affiliations
Timeline
Generic

Rohit Bajpai

Noida

Summary

Driven by a passion for innovation and efficiency, I excelled at Telus Digital, leading a team to migrate data warehouses to Google BigQuery, enhancing query performance significantly. My expertise in GCP Data Engineering and adept project management skills ensured seamless transitions, showcasing my ability to blend technical prowess with leadership excellence.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Technical lead

Telus Digital
Noida
05.2018 - Current
  • Company Overview: Telus Communications Inc
  • (TCI) is the wholly owned principal subsidiary of Telus Corporation, a Canadian national telecommunications company that provides a wide range of telecommunications products and services including internet access, voice, entertainment, healthcare, video, smart home automation and IPTV television
  • Website: https://www.telus.com/en
  • Managing team of 6 members (Developers and QA)
  • Working on a Migration project from Onprem Data Warehouse(Oracle, to GCP
  • Performed QA checks and validated data before moving to
  • Strong knowledge of Google Cloud Platform services such as BigQuery, and Pub/Sub
  • Designed and developed scalable data pipelines using GCP Dataflow process large-scale data from various sources
  • Optimized BigQuery performance by partitioning, clustering, and using materialized views, reducing query time
  • Managed and automated ETL processes with Cloud Composer and Airflow, improving data processing efficiency
  • Implemented real-time data streaming solutions using GCP Pub/Sub and Dataflow, ensuring low-latency data processing
  • Migrated on-premise data warehouses to Google BigQuery, leading to a large improvement in query performance and cost reduction
  • Worked with Factory code for Low code development solutions
  • Telus Communications Inc
  • (TCI) is the wholly owned principal subsidiary of Telus Corporation, a Canadian national telecommunications company that provides a wide range of telecommunications products and services including internet access, voice, entertainment, healthcare, video, smart home automation and IPTV television
  • Website: https://www.telus.com/en

Cloud Application SME

DXC technologies
Noida
04.2016 - 05.2018
  • Administering and managing Control-M Servers (Solaris 10\Oracle Linux, Windows server)
  • Experience in interacting with Business Analyst, Developers, Technical support and help them baseline the requirements specifications
  • Expertise in Administration and scheduling jobs in Control-M Enterprise Manager versions 6.2, 7.0, 8.0 and 9.0
  • Designing Control-M Solutions for new customers based on the customer requirements
  • Good experience in analyzing changes and identifying areas of scheduling and DR management
  • Installation and upgrade of Control-M EM, Control-M server and Control-M agents, Additional Control-M components and Fix packs
  • Good working knowledge of major operating systems and applications on Windows/UNIX
  • Involved in Disaster Recovery and performed Control-M activities
  • Ensure the 100% 24
  • 7 availability of the Control-M environment
  • Ability to handle multiple tasks and work independently as well as in a team
  • Good Team player with excellent written and verbal communication and interpersonal skills
  • Having Skill training with latest technologies i.e
  • Shell scripting, Agile Methodology
  • Interaction with Clients on a daily scrum for the daily and weekly updates

Software Engineer

Birlasoft
Noida
10.2012 - 04.2016
  • Responsible for Requirement gathering, data engineering and analysis
  • Responsible for preparation and getting Sign Off from clients on business use cases
  • Participating in Test Case review meetings and preparing the review documents
  • Performing Smoke, Functional, Database, Regression, Web Service, Production and Performance Testing on various SWAT clients (US Air, United Airlines etc.)
  • Executing Test Cases and logging defects in Jira
  • Maintaining and updating defect-tracking database
  • Providing support for Production and server moves
  • Preparing Incident Logs, document of understanding and lesson learned documents
  • Daily and Weekly Status report to client/ Daily Scrum with clients
  • Following Agile Methodology
  • Managing Control M application for all SWAT related applications

Test Engineer

Datacore technologies
Pune
11.2011 - 10.2012
  • Collaborated with Birlasoft under the payroll of Datacore Technologies.

Education

MCA -

GBTU
Lucknow
01.2011

B.Sc. - Physics & Mathematics

CSJM University
Kanpur
01-2008

10+2 -

UP Board
Allahabad
01-2005

Skills

  • Business & Data Analytics
  • GCP Pipeline development
  • Pipeline testing & Automation
  • Unit Testing
  • Data Modeling
  • Project & Team Management
  • Stakeholder & Business communication
  • Agile Implementation
  • CoE /CoP mentorship
  • Team Management and mentorship
  • Agile and scrum methodology
  • GCP Data Engineering
  • Control M
  • Unix
  • Big table
  • Big query
  • GCS
  • Hadoop
  • Git
  • TFS
  • Python
  • SQL
  • Rest API
  • Postman
  • Mobaxterm
  • SSH Client
  • Nifi
  • Pub/Sub
  • Airflow
  • Jira
  • Technology resource integration
  • Functional requirements expertise
  • Team performance management
  • Team leadership
  • Version control
  • Innovation management
  • Data acquisition
  • Continuous integration

Baselocation

Noida, Uttar Pradesh

Certification

  • GCP certified data engineer
  • Scrum fundamental certified
  • ITIL v3 certified

Workfromhomelocation

Kanpur, Uttar Pradesh

Languages

  • English
  • Hindi

Personal Information

  • ReferenceOn demand
  • Passport Number: Yes
  • Date of Birth: 07/20/88
  • Gender: Male
  • Nationality: Indian
  • Marital Status: Married

Affiliations

  • Part of Kanpur ploggers (AN NGO wo works towards platsic pollution solutions

Timeline

Technical lead

Telus Digital
05.2018 - Current

Cloud Application SME

DXC technologies
04.2016 - 05.2018

Software Engineer

Birlasoft
10.2012 - 04.2016

Test Engineer

Datacore technologies
11.2011 - 10.2012

MCA -

GBTU

B.Sc. - Physics & Mathematics

CSJM University

10+2 -

UP Board
Rohit Bajpai