Summary
Overview
Work History
Education
Skills
Personal Information
Disclaimer
Timeline
Generic

Prasad Yalapalli

Hyderabad

Summary

Software Engineer with 4.5 years of experience on SQL, Python, Pyspark, and Linux

Overview

5
5
years of professional experience

Work History

Analyst

Dimensions Infotech
08.2019 - 11.2022

Software Developer

LTIMindtree
11.2022 - Current

CITI BANK

Bengaluru, Karnataka
10.2023 - Current
  • The aim of the project is to Ingesting the source data in raw format from different types of files (CSV, Parquet), transform it and then persist into target data warehouse(Hive)
  • We will be creating data loaders for each entity as background jobs using Pyspark scripts and running them on Autosys (Orchestration) for incremental data
  • Responsible for understanding requirements automation solutions using Pyspark and Hive to ingest and validate the data load
  • Technologies: SQL, Python and Pyspark

S & P GLOBAL INC
12.2022 - 09.2023
  • The project is to Consuming the source data in raw format, transform it and then persist into target data stores
  • We will be creating data loaders for each entity as background jobs using SQL Stored Procedure and running them as Kubernetes deployment for incremental data and historical backfills
  • Creating stored procedures to handle the different stages of data Ingestion of data to different tables in SQL server using Stored Procedure Optimizing the SQL Stored Procedure based on the running time of SP Resolving the tickets depends on the priority
  • Monitoring the scripts and resultant tables on a Daily, Weekly and Monthly basis and resolving if any failure or error occurred
  • Exploring various Stored Procedures and modifying it based on client's requirements
  • Technologies: Microsoft SQL Server, T-SQL, Automation (Python)

Recon
10.2020 - 11.2022
  • Project is to find discrepancies between accounting balances of various systems, compare daily accounting and monthly accounting and consolidate different entities to generate reconciliation report for financial statement and further this report will be published in other downstream systems
  • If there are any discrepancies found then they will adjust by manually uploading excel file through the site, manually adjusted balances will go through approval process of various levels Technologies : Angular 10+, C#, Web API with .Net Core, TypeScript and JavaScript Database : Sql server

STL
11.2019 - 10.2020
  • The aim of the project is to generate Commodity Trade confirmation and invoice generation for buyers and sellers
  • Post booking the deal by Front Office and validated by Back office, the deal is eligible for the confirmation and invoice generation for all types of deals
  • Technologies : Asp.net MVC, C#, Entity Framework, Web API Database : Sql Server

Education

B.Tech in Mech -

S.V College Of Engineering, JNTU Anantapur

Skills

    SQL

    Python

    Pyspark

    Linux

Personal Information

  • Father's Name: Y Moorthy
  • Date of Birth: 09/04/97
  • Gender: Male
  • Marital Status: Single

Disclaimer

I hereby declare that above information is true to the best of my knowledge.

Timeline

CITI BANK

Bengaluru, Karnataka
10.2023 - Current

S & P GLOBAL INC
12.2022 - 09.2023

Software Developer

LTIMindtree
11.2022 - Current

Recon
10.2020 - 11.2022

STL
11.2019 - 10.2020

Analyst

Dimensions Infotech
08.2019 - 11.2022

B.Tech in Mech -

S.V College Of Engineering, JNTU Anantapur

Similar Profiles

CREATE PROFILE
Prasad Yalapalli