Summary
Overview
Skills
Work History
Accomplishments
Education
Work Preference
Certification
SoftwareEngineer
Rajesh Yadav

Rajesh Yadav

Data Engineer
Thane

Summary

Experienced in database development, performance monitoring, troubleshooting issues and optimizing database objects. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.

Overview

7
7
years of professional experience

Skills

  • Database Development
  • Azure Data Factory
  • Azure Databricks
  • SnowFlake
  • Data Warehousing
  • Data Migration
  • Data Modeling
  • SQL
  • Python

Work History

Data Engineer

Deloitte
Mumbai
01.2022 - Current
  • Developed and managed xAI Consumer Analytical Insights system, capturing raw data from consumer historian servers into Azure SQL database, transforming it using SQL stored procedures, and executing these procedures via Python jobs on Azure Linux VMs for periodic updates.
  • Implemented data integration with Power BI, scheduling transformed data loads via Power BI enterprise gateway, and utilized Microsoft Power App and Power Automate for recording master data and user entries, along with an alert system for proactive issue mitigation to enhance productivity and reduce losses.
  • Onboarded five global Consumer Production Plants for Analytical Insight Project, driving operational expansion and leveraging technology to enhance production capabilities.
  • Implemented strategic optimizations in stored procedures and Power Bi Views resulting in notable improvements in system performance and user experience.
  • Designed and optimized a robust data pipeline with Azure Databricks and Azure Data Factory, enabling near real-time data processing of Plant Data from Historian and Azure SQL Server
  • Spearheaded deployment of crucial infrastructure elements including ADF Pipelines, Azure SQL Server, CronJobs, Python Scripts, and Notification services across all environments, ensuring seamless integration and operation.
  • Proactively managed platform issues such as pipeline failures, Service Account Changes, and Power BI dataload and refresh failures, mitigating risks and ensuring uninterrupted operations across development, QA, and production servers.
  • Developed and optimized over 60+ stored procedures tailored for PowerApp integration to dynamically handle multiple plant data and KPI calculation logic, streamlining data retrieval.
  • Optimized Power BI dataload and refresh processes, reducing processing time from 45 minutes to under 10 minutes, significantly enhancing data accessibility and decision-making capabilities.

Database Developer

EbixCash
Mumbai
07.2019 - 01.2022
  • Developed, implemented, and optimized PL/SQL procedures, functions, packages, and database triggers for Integrated Transport Management Product.
  • Created a VB.Net Windows Form application for end users, providing intuitive frontend interface.
  • Wrote over 50 complex MIS PL/SQL scripts to meet client requirements and integrated them with Crystal Reports.
  • Participated in all phases of SDLC (Software Development Life Cycle), from analysis and design to development, testing, implementation, and maintenance, consistently delivering projects on time.
  • Provided friendly and efficient service to clients, handling challenging situations with ease and professionalism.
  • Improved application performance by identifying root causes of issues and implementing immediate resolutions.
  • Generated weekly Oracle AWR reports to monitor database performance and optimized scripts with high elapsed times.
  • Managed Web Application Server by creating application pools, deploying Crystal Reports, and updating web services.
  • Designed and developed interfaces that simplified overall application workflow and enhanced ease of use.
  • Supported business acquisition efforts by designing customized solutions for proposals to potential customers.

Software Developer

Shahi Dynotechs
Mumbai
10.2018 - 06.2019
  • Tested ERP system and databases queries to identify issues and make necessary modifications
  • Developed and added new features in existing application as per client requirement
  • Created 70+ Table model and update queries on Oracle PLSQL that integrated with Android and Web Application API.

GIS Data Analyst

Here Technologies
Navi Mumbai
08.2017 - 10.2018
  • Facilitated training for new associates through knowledge sharing and weekly team performance review
  • SME for Team of 22 Members for Lidar Review and SPART Project for Inline Quality Check and Clearing Doubt
  • Carried out task of weekly report creation using BI Dashboard regarding Quality Review and Team KPIs.

Accomplishments

  • Spot Recognition from Manager for efforts in creating Reports and Sharing KPI's within team and demonstrating HERE Values of "Give Back" and "Win Together".
  • Winner of the TCOE (Technical Center of Excellence) Award amongst 16 teams of the same project organized by Here Management Team.
  • Secured 2nd Rank among 300+ entries in Virtual Placement Competition organized by KCCOE Training and Placement Cell.
  • Received ‘Innovation Gladiator’ award for Move the Innovation during Innovation Olympiad 3.0 for Asset ‘Code Convertor’

Education

Bachelor of Engineering - Electronics And Telecommunication

K.C College of Engineering

HSC - Science

G.V.M High School
03.2012

Work Preference

Work Type

Full Time

Location Preference

Hybrid

Important To Me

Career advancementCompany Culture

Certification

Databricks Lakehouse Fundamentals

https://credentials.databricks.com/7e7b0b2c-6247-4674-90be-60132e682556

Scripting with Python and SQL

https://coursera.org/share/aff07cca78a154ea1b72adbbae00e3d5

SnowFlake Hands On Essentials - Data Warehouse

https://www.credly.com/earner/earned/badge/0177896d-4472-4f62-9387-d181c6f581d9

SnowFlake Data Cloud Deployment Framework

https://www.credly.com/badges/6406b0c3-c4a3-4cb7-aec2-6336bafd8e48

Similar Profiles

CREATE PROFILE
Rajesh YadavData Engineer