Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Certification
Trekking
Receptionist
Praveen Kumar Ravichandran

Praveen Kumar Ravichandran

GCP-BQ Technical Lead
CHENNAI

Summary

Experienced IT Professional with 14 years of dedicated industry expertise, specializing in Google Cloud Platform (GCP) and BigQuery. Adept at leveraging BigQuery for data analysis, migration, and query optimization, with a solid track record of 3 years in GCP-BigQuery migration and Data Analysis projects.

Overview

16
16
years of professional experience
4
4
years of post-secondary education
2
2
Certificates

Work History

GCP BQ Technical Lead

Tech Mahindra
09.2023 - Current

Successfully designed and implemented a data migration process from Teradata to Google BigQuery - Using Dataflow, DataProc and Airflow.

· Impact Analysis, ETL Scripts extraction and transformation from TeraData to BQ, Performance Tuning and Query Optimization.

Technical Lead

BNP Paribas India Solutions
06.2018 - 12.2022

Predicting the characteristic values of financial instruments to decide whether to include/exclude instruments from Portfolios using Classification ML models. Regression models for performance prediction.

  • Implemented and Evaluated Machine learning algorithms for finding best matched financial instruments for Clients requirements.
  • Hands on in Linear Regression, Logistic Regression, Decision Tress, Support Vector Classifiers
  • Random Forest, Boosting and Bagging.
  • NLP and Deep Learning
  • Evaluation of models done using Gradient Descent, Cross Validation, Confusion Matrix, and Accuracy scores.
  • Extensive usage of Python libraries Numpy, Pandas, SKLearn, Seaborn .
  • Utilized data visualization tools to effectively communicate insights.

Senior Software Engineer

CSC
06.2010 - 06.2018
  • Developed or customized packages and procedures using Oracle 11g to meet functional business requirements of Emirates airline.
  • Designed Emirates Airway Bill currently used by Airlines for Cargo transport.

Software Engineer

Firesteamww, Pilot
06.2008 - 06.2010
  • Designed complex reports in Crystal Reports XI for petroleum whole sale product ASCEND
  • Created and enhanced Views, Triggers, stored procedure, Functions and Packages in Oracle 10g

Education

B.Tech - Information Technology Prince

Prince Shri Venkateshwara Collage of Engineering
Chennai
06.2004 - 05.2008

Skills

    Big Query

undefined

Accomplishments

  • ML models to predict the performance growth and risk ratio for Client portfolios. This is based on the data received from credit rating agencies S&P Global Ratings (S&P), Moody's, and Fitch Group. Data provided by Bloomberg is processed using Oracle PL SQL packages before getting loaded into tables.
  • Implementation of Cargo Revenue Optimization project for Emirates airline.
  • Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project plans and work break down structures.

Timeline

GCP BQ Technical Lead

Tech Mahindra
09.2023 - Current

Technical Lead

BNP Paribas India Solutions
06.2018 - 12.2022

Senior Software Engineer

CSC
06.2010 - 06.2018

Software Engineer

Firesteamww, Pilot
06.2008 - 06.2010

B.Tech - Information Technology Prince

Prince Shri Venkateshwara Collage of Engineering
06.2004 - 05.2008

Certification

Google Professional Cloud Architect

Trekking

Himalayas & Eastern Ghats

Praveen Kumar RavichandranGCP-BQ Technical Lead