Ishan Agrawal

Data Engineer

Bengaluru, Karnataka, India3 yrs 11 mos experience

AI EnabledAI ML Practitioner

Key Highlights

Developed financial projection tools for lending institutions.
Created and deployed chatbots using Google Cloud services.
Analyzed aircraft data to improve operational efficiency.

Stackforce AI infers this person is a Data Engineer with experience in Fintech and AI sectors.

Contact

Skills

Core Skills

Data EngineeringPythonCloud ComputingChatbot DevelopmentData Analysis

Other Skills

API GatewaysAPI TestingAWSAWS LambdaAZUREAmazon Web Services (AWS)Artificial Intelligence (AI)Azure Data LakeBrand DevelopmentBusiness DevelopmentBusiness PlanningCloud StorageClusterCluster AnalysisContainerization

Experience

3 yrs 11 mos

Total Experience

1 yr 3 mos

Average Tenure

1 yr 7 mos

Current Experience

Vector ml analytics

Junior Data Engineer

Nov 2024 – Present · 1 yr 7 mos · New York, United States · Remote

Vector is a platform for Lending Institutions which helps them to take a strategic decisions for their business using the financial projections Vector platform does. This platform creates 3 financial statements, does Credit Risk Analysis(Cohort based Analysis etc) , Capital Market reporting for 5 years.
My responsibilities:
Backend RestAPI, FastAPI development in Django framework.
Create efficient, performance optimised, human-readable API code in backend using industry best practices.
Create efficient ETL pipelines by testing multiple architecture level changes and good system design according to use case of client.
Communicate with clients to understand their business, and preparing architecture for them.
Weekly, bi-weekly meeting.
Carry out quality assurance testing on the company portal using Manual and Automation testing according to features. Testing include integration and regression testing.
Skills - Microsoft Excel, Django, Python, AWS, AZURE, POSTGRESQL, GitHub, Pyspark etc.

Microsoft ExcelDjangoPythonAWSAZUREPOSTGRESQL+3

Arthat ai technologies pvt ltd

Artificial Intelligence Automation Intern

Jul 2024 – Sep 2024 · 2 mos · Bengaluru, Karnataka, India · Remote

Roles and responsibilities:
1)Wrote some Python backend API codes(defined pydantic models for API request and response, user login, authentication with CloudSQL database, update of user details API, text splitting API, web crawling API, created database connection with Cloud SQL, added persistent-disk code for storing each created chatbot vector data in Google Cloud additional disk for persistence)
2)Set up configuration for Google Cloud Deployment services for frontend and backend .
3)Created Cloud SQL database, added network settings, created database tables using Google Cloud Shell scripting
4)Set configuration Cloud VM instance with persistent disk for data storage, formatting, mounting of disk making it ready for app deployment using SSH scripting on VM instance.
5)Set up VPC firewall rule, IAM roles and permissions according to various resources used like Cloud storage, SQL, VM instance, Cloud Run, Artifact Registry for docker images.
6)Built docker images in Gcloud SDK Shell, pushed it to Artifact Registry, deployed docker image to Cloud Run and Gcloud VM instance.
7)Testing of all API done using Postman Desktop.
8)Debugged some errors in frontend using Claude AI.
9)Colaboration with Managing Director, Team Lead and other fellow developers about daily updates and different requirements on Cloud.
10)Brain-storming about data-caching for faster access.

Chatbot DevelopmentAWS LambdaCloud ComputingAmazon Web Services (AWS)API TestingAPI Gateways+14

Escape velocity

Data engineering intern

Jul 2024 – Aug 2024 · 1 mo · Remote · Remote

My roles and responsibilities included Python backend coding for some functional API.
Did API testing using Postman.
Used Github for code version control.

Internpe

Machine Learning Intern

Apr 2024 – Apr 2024 · 0 mo · Remote

Career break

Career transition

Jan 2024 – Jun 2024 · 5 mos

Pursuing POST GRADUATION IN DATA SCIENCE with Special track - DATA ENGINEERING.
Here is what i can do with data- Analysis using Pandas, Numpy. Matplotlib, Seaborn, Power BI
Ability to make Machine Learning models, Regression Analysis, Prediction and forecasting,

Indigo (interglobe aviation ltd)

Aicraft Engineering Technician

Feb 2022 – Jan 2024 · 1 yr 11 mos · Jaipur, Rajasthan, India · On-site

Wrote complex SQL queries to import data in Power BI. Created interactive dashboards for scenario based analysis using
features like Calculated columns, DAX, measures, filter context etc. Result- By analyzing the data, I identified key parameters contributing to delays and suggested operational changes. As a result, we managed to reduce average ground time by around 10%, saving significant fuel costs in the process.
Managed availability of aircraft parts using Excel. Results- As a result of this work, we were able to reduce transportation costs by around 4%, which added significant
revenue for the company.
Schedule and unscheduled maintenance of Airbus A320 and ATR aircrafts.
Worked on commercial aircrafts with tasks like replacement of cockpit displays, panels, pilot seats.
Worked with Aircraft Navigation, communication, fire detection & prevention, oxygen, electrical, flight control systems. Did tasks like replacements of Line Replacable Units, sensors.
Visual inspection, oil servicing of Pratt and Whitey, CFM international, IAE engines.
Ground run of engines.
Cordination with Air Traffic Control for maintenance tasks.
Upload and download of Aircraft Condition Monitoring data and Black-box data.
Preparation of daily maintenance and departure reports using Advanced Excel.