Personal details

Ranjan - Remote data engineer

Ranjan

Based in: 🇮🇳 India
Timezone: Chennai (UTC+5.5)

Summary

I want to share my knowledge with seekers and want to expand my own. I found Codementor to be an exceptional platform for doing this and as a codementor I look forward to spreading knowledge and ideas.

My expertise:

  • C
  • Dart
  • MySQL
  • Microsoft SQL Server
  • Oracle sqldeveloper
  • PostgreSql (PgAdmin 4)
  • Flutter (for Android)
  • Flask Web Framework
  • Informatica PowerCenter
  • SQL Server Integration Services (SSIS)
  • Data Migration
  • Admob
  • Supabase
  • Firebase

Work Experience

ETL Developer/Senior Software Engineer
Ernst and Young GDS India LLP, Bangalore | Jan 2021 - Present
SQL
SSIS (SQL Server Integration Services)
Soap ui
Data Integration
Snowflake
Informatica PowerCenter

Creating complex SQL views and Stored Procedures in SQL server and in sqldeveloper. Creating ETL workflows/jobs in SSIS and in Informatica PowerCenter. Optimizing and performance tuning SQL queries and ETL workflows. Execution and Unit Testing ETL workflows. Handling multiple projects for the client. Fixing the defects and performing production loads. Creating complex SQL queries in AWS Snowflake. Execution of XML scripts in SOAPUI.

ETL Developer/Senior Software Engineer
Ernst and Young GDS India LLP, Bangalore | Jan 2017 - Jan 2019
SQL
SSIS (SQL Server Integration Services)
Data Integration
Informatica PowerCenter

Understanding requirements under Insurance domain and proposing data conversion solutions. Creating complex SQL views and Stored Procedures in SQL server and in sqldeveloper. Creating ETL workflows/jobs in SSIS and in Informatica PowerCenter. Optimizing and performance tuning SQL queries and ETL workflows. Execution and Unit Testing ETL workflows.

Education

THE NATIONAL INSTITUTE OF ENGINEERING
Bachelor's degree・Computer Science and Engineering
Jun 2013 - Jun 2017

Personal Projects

IntelAI – AI Chatbot
2023
Dart
Telegram API
Flutter
VS Code
An android app for users to get responses and answers for queries via ChatGPT in real-time. Deployed on Google Play Store. Voice input enabled and text-to-speech enabled.
RippleAI – AI Art Generator
2023
Dart
Flutter
VS Code
OpenAI
An android app that generates AI art and images using DeepAI text-to-image API. Deployed on Google Play Store. Voice input enabled.