RAVI KUMAR PANDEY
Pune
Summary
Experienced Senior Data Specialist with a decade in the IT industry, specializing in Data Engineering. Demonstrated success in project delivery within E-commerce and Telecom industries. Holds certification as Google Cloud Professional Data Engineer, with expertise in data analysis and management. Acknowledged for mentoring capabilities and fostering professional growth among team members.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Data Specialist
Brillio Technologies
Pune
12.2024 - Current
- Engineered new pipeline to transport data from source to BigQuery efficiently.
- Corrected data discrepancies in current pipeline, supplying comprehensive root cause analysis.
- Applied GCP services, particularly Composer, for robust pipeline architecture.
- Managed code repository through Code Search to ensure organized codebase.
- Leveraged Terraform for schema updates; Rapid utilized for deploying SQL and DAGs.
- Formulated complex SQL queries with extensive CTE chains to improve processing efficiency.
- Utilized window functions (RANK, DENSE_RANK(), LEAD, LAG) for precise calculations.
- Conducted query optimization focusing on partitioning and clustering strategies.
Technical Lead
Wipro
Pune
02.2022 - 12.2024
- Leveraged Google Cloud Platform services such as BigQuery, Airflow, and Cloud SQL for data engineering initiatives.
- Designed DAGs in Airflow alongside custom Dataflow templates to enhance data workflows.
- Managed code storage on GitHub for deployment to multiple environments.
- Coordinated deployments of applications via GitHub and Jenkins to ensure consistency.
- Enhanced customer satisfaction by addressing data discrepancies with thorough root cause analysis.
- Automated scripting tasks utilizing shell and Python programming languages.
Sr. Software Engineer
Datametica
Pune
03.2021 - 02.2022
- Facilitated migration of hive data to Google Cloud Platform with minimal disruption.
- Transformed hive and SQL code into BigQuery format for enhanced performance.
- Managed data loading processes from cloud bucket to BigQuery, focusing on validation and optimization.
- Created Airflow DAGs using Python to establish connections with GCP and external data sources.
- Oversaw workflow monitoring via Airflow web UI for effective process management.
Software Developer
Amdocs
Pune
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
Pune
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
Bangaluru08.2014
Bachelor of Computer Applications - Computer Application
Raniganj Institute of Technology
Raniganj, West Bengal07.2011
HSC - Science Education
Kendriya Vidyalaya
Andal05.2008
SSC - Science Education
Kendriya Vidyalaya
Andal05.2006
Skills
- Google Cloud Platform and BigQuery
- Data warehousing and SQL
- Core Java and Python
- Data quality management
- Data cleaning
- Version control with Git
- Continuous integration with Jenkins
- Unix command line proficiency
- Database management with PGAdmin
- Project tracking with Jira
- Workflow orchestration with Airflow
Certification
Google Cloud Certified Professional Data Engineer
Accomplishments
- I have a total of 6 months of experience on the client side in the telecom domain, where I know how to interact with and handle our clients.
- Awarded the 'Summit Award' in Q2 2015 and Q4 2016 for excellent dedication to the project, with excellent quality of deliverables and possessing overall knowledge of the project.
- Many times, I received on-call appreciation from the client for individually handling project issues.
- Awarded the Star of the Quarter for developing an aggregation and export framework to ease the report extraction and transfer to the customer.
Personal Information
Title: Senior Data Specialist
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
MCA - Computer Application
Acharya Institute of Technology
Bachelor of Computer Applications - Computer Application
Raniganj Institute of Technology
HSC - Science Education
Kendriya Vidyalaya
SSC - Science Education
Kendriya Vidyalaya