Jyoti Rai
Senior Data Engineer | Authorized To Work In Spain | Pursuing Masters In ML And Cloud
Barcelona
Summary
Passionate data engineer looking for better opportunities in Data Engineering. 8+ year of experience in `Data Engineering & PL/SQL Development in Airlines, Banking and Telecom Domain.
Overview
8
8
years of professional experience
5
5
years of post-secondary education
Work History
Senior Data Engineer
Veersa Technologies
Noida
09.2022 - 02.2024
- Worked on data analysis for health care data to get insights for prediction of Insurance claim denials.
- Worked on preprocessing of data and extracted important feature to be used in training model.
- Created multiple machine learning models to check performance.
- Developed Multiple Data pipelines to transfer data between servers through Azure data factory.
- Worked on 2 Projects simultaneously.
- Created Google BigQuery instance to retrieve data similar to report developed in Google Analytics 4.
- Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
Associate Module Lead
QUALTECH EDGE CONSULTANT PRIVATE LIMITED
Noida
04.2020 - 07.2022
- Worked on CSV data to predict that whether loan of person is going to be approved or not.
- Worked on pre-processing of data by using scikit learn library.
- Handling team of PL/SQL, Frontend, and Backend Developers for Delivering miFin Platform to Customer.
- Developed and delivered moratorium functionality to more than 5 clients.
- Developed and delivered advance EMI repayment to multiple users.
- Involved in monthly meeting to showcase whatever have done good in work in last one months and also area of improvement required.
- Assigning task to teammates.
- Provided technical help if any member in team facing any technical issue.
- Acting as Scrum Master to Unblock teammates and Manage Efforts
Senior Software Engineer
NIIT Technologies
Noida
08.2019 - 03.2020
- Involved in production support to resolve production bugs and issues.
- Interacted with more than 5 client to understand problems..
- Interacted with internal teams to get issue resolved.
- Involved in providing news ideas and modification related to product for customer benefits.
- Involved in enhancement of product and implemented new changes raised by customers.
Engineering Analyst
QUALTECH EDGE CONSULTANT PRIVATE LIMITED
Noida
11.2017 - 08.2019
- Collected user requirements by participating in meetings and studying existing system.
- Created database object procedures, packages, triggers, sequences, tables, cursors, functions.
- Developed 3 new module in existing project.
- Interacted with internal teams to get new changes completed.
- Provided PLSQL training to new Teammates.
- Created wrapper procedures and functions for mobile web services.
- Involved in various technical specification documents and functional specification documents.
- Used sql loader to get data bulk uploaded in database tables.
- Used advanced PLSQL and explain plan for performance tuning.
- Created jasper reports in particular format according to requirement using iReport tool.
- Involved in modifying various existing procedure, function, cursor, packages and also created new objects according to business requirement.
- Provided technical and functional knowledge transfer to Quality Assurance team and production support team for any new changes developed.
- Involved in analyzing ADDM and AWR report for performance related issues.
- Worked on production issues, testing code fixes.
Software Engineer
INFOZECH SOFTWARE PRIVATE LIMITED
Noida
09.2015 - 11.2017
- Collected user requirements by participating in meetings and studying existing system.
- Created database object procedures, packages, triggers, sequences, tables, cursors, functions.
- Involved in impact analysis for any change request.
- Involved in various technical specification documents and functional specification documents.
- Involved in production support to resolve production bugs and issues also interacted with business user whenever required.
- Wrote various complex queries using joins,sub queries to retrieve data from database
- Involved in modifying various existing procedure, function, cursor, packages according to new business requirement and improve performance by 10%
Education
Master of Science - Machine Learning And Cloud
Liverpool John Moores University
Liverpool 12.2021 - 12.2023
Bachelor of Technology - Computer Science And Engineering
IMS Engineering College
Ghaziabad 07.2012 - 05.2015
Skills
Cloud Services : Azure Data Factory,Azure Blob storage,Azure pipeline,S3,RDS,EMR(Hive,Hadoop),EC2,Google Analytics, Google big query
Language : Python, SQL/PLSQL, Unix Scripting(Basic)
Libraries/Frameworks : Scikit - Learn, Numpy, Pandas, Apache Spark(Basics)
Tools : Jupyter, Anaconda, SQL developer, PLSQL developer, iReport, git
Certifications : Machine Learning A-Z™: Hands-On Python & R In Data Science, Machine Learning By Andrew Ng(Coursera)
Database : Oracle 10g,11g, MySQL Server
Timeline
Senior Data Engineer
Veersa Technologies
09.2022 - 02.2024
Master of Science - Machine Learning And Cloud
Liverpool John Moores University
12.2021 - 12.2023
Associate Module Lead
QUALTECH EDGE CONSULTANT PRIVATE LIMITED
04.2020 - 07.2022
Senior Software Engineer
NIIT Technologies
08.2019 - 03.2020
Engineering Analyst
QUALTECH EDGE CONSULTANT PRIVATE LIMITED
11.2017 - 08.2019
Software Engineer
INFOZECH SOFTWARE PRIVATE LIMITED
09.2015 - 11.2017
Bachelor of Technology - Computer Science And Engineering
IMS Engineering College
07.2012 - 05.2015