Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic
RAVI KUMAR PANDEY

RAVI KUMAR PANDEY

Senior Data Specialist
Pune

Summary

Senior Data Specialist with 10+ years experience in IT industry, specializing in Data Engineering. Skilled in project delivery for E-commerce and Telecom sectors. Expertise in Google Cloud platform with certification as Google Cloud Professional Data Engineer.

Overview

11
11
years of professional experience
2015
2015
years of post-secondary education
1
1
Certification

Work History

Senior Data Specialist

Brillio Technologies
12.2024 - Current
  • Designing new pipeline to brought the data from the source to BigQuery.
  • Fixing the data discrepancy in the existing pipeline.
  • Using GCP services like Composer for pipeline designing.
  • Using Code Search as repository.
  • Working on Terraform to deploy the schema changes and Rapid to deploy the SQL and DAGs.

Technical Lead

Wipro
02.2022 - 12.2024
  • Currently Working as a Data Engineer in GCP (Google cloud platform) on services like BigQuery, Airflow, cloud buckets, Composer, GCS, cloud SQL etc
  • Developed DAG's in airflow, custom templates in Dataflow
  • Use github to store the built codes on github to deploy it to other environments
  • Deployment of built codes over target environments via GitHub & Jenkins
  • Having good knowledge in other GCP services like Cloud storage, Compute Engine
  • Worked as GCP data Analyst lead for US telecom company where I have analyzed the data from different source and did source to target mapping for GCP
  • Increased customer satisfaction by resolving DB issues in Cloud Applications
  • Used shell and Python for scripting.

Sr. Software Engineer

Datametica
03.2021 - 02.2022
  • Migration of hive data to Google cloud Platform
  • Conversion of existing hive, SQL code to BigQuery codes
  • Involved with the data loading from cloud bucket to BigQuery and data validation and code optimization
  • Created the Airflow Dags using the python which includes connecting to GCP, connecting to remote servers, pushing the data and fetching the data with the external sources
  • Monitoring the workflows from Airflow web UI

Software Developer

Amdocs
06.2017 - 03.2021
  • Bug fixing at the time of Portfolio testing and UAT to ensure smooth progress of development lifecycle
  • Code and design review of peer developers
  • Developed utility on Oracle to automate report generation and transfer to customers
  • Created Oracle functions, stored procedures, cursors, triggers, tables, views, constraints, sequences, index
  • Used shell and python scripts to automate manual task
  • Conduct Training and KT for juniors.

Delivery Associate Software Engineer

Mphasis
11.2014 - 05.2017
  • Provide production application support and Telstra Intermediate mediation applications
  • Understanding the requirement of the project involved
  • Involved in software development
  • End to End application and meeting SLA of the application
  • Involved in the manual testing phase of the application
  • Responsible of trouble shooting of issues related with current production application/servers
  • Responsible for fixing production support issues and client issues
  • Responsible for error analysis and resolution of issues within SLA time escalated by various down-streams.

Education

MCA - Computer Application

Acharya Institute of Technology

Bachelor of Computer Applications - Computer Application

Raniganj Institute of Technology
Raniganj, West Bengal

HSC - Science Education

Kendriya Vidyalaya

SSC - Science Education

Kendriya Vidyalaya

Skills

  • GCP
  • Airflow
  • BigQuery
  • Google Cloud SDK
  • SQL
  • PL SQL
  • Core Java
undefined

Certification

Google Cloud Certified Professional Data Engineer

Accomplishments

  • I have total of 6 month of experience at client side in telecom domain, where I know how to interact and handle our client.
  • Awarded as 'Summit Award' in Q2-2015 and Q4-2016 for excellent dedication towards project with excellent quality of deliverables and possessing overall knowledge of the project.
  • Many times received on call appreciation from the client for individually handling projects issues.
  • Awarded as Star of the quarter for developing aggregation and export framework to ease the report extraction and transfer to customer.

Timeline

Senior Data Specialist

Brillio Technologies
12.2024 - Current

Technical Lead

Wipro
02.2022 - 12.2024

Sr. Software Engineer

Datametica
03.2021 - 02.2022

Software Developer

Amdocs
06.2017 - 03.2021

Delivery Associate Software Engineer

Mphasis
11.2014 - 05.2017

Bachelor of Computer Applications - Computer Application

Raniganj Institute of Technology

HSC - Science Education

Kendriya Vidyalaya

SSC - Science Education

Kendriya Vidyalaya

MCA - Computer Application

Acharya Institute of Technology
RAVI KUMAR PANDEYSenior Data Specialist