Sunil Kumar Kalagarla

Experience

• 

  Trigent Software Inc

  Jul 2020 - Jan 2021

  Software Developer

  ● Developed and fine-tuned SQL queries to enhance data retrieval processes for 3 web applications, improving performance.● Implemented indexing strategies under the supervision of a senior developer, minimizing query execution time by 30 seconds.● Deployed AWS Redshift for a data warehousing project, enabling real-time analytics for 1 enterprise application supporting the integration of diverse datasets, which streamlined data processing and improved report generation speed.● Contributed to the maintenance of PostgreSQL databases for applications by designing basic schemas and triggers to ensure data consistency, daily transactions and maintaining reliable database operations.● Designed Excel spreadsheets incorporating pivot tables and charts to monitor KPIs for 2 projects refining stakeholder visibility into development timelines by presenting clear, enhanced project tracking and informed decision for project management.● Facilitated seamless collaboration among a team of 3 developers, ensuring smooth integration of code changes process by boosting the project’s development workflow and maintaining code quality. Show less

• 

  Dell Technologies

  Feb 2021 - Nov 2022

  Software Developer

  ● Employed Pandas to preprocess and clean 300+ datasets, streamlining data pipelines for a custom business intelligence solution tailored to tech diagnostics ensuring seamless integration with for performance optimization.● Harnessed Python to architect RESTful APIs enabling a system to consistently handle over 10 requests per second by integrating schema validation ensuring both data integrity and system stability under heavy loads.● Enhanced three predictive models with TensorFlow, processing data points per batch to achieve high accuracy in system failure detection for algorithms to slash model execution time by 6 iterative calculations.● Developed Django REST APIs for a transaction processing system, reducing latency by 0.5 seconds per request and● supporting daily operations for a payment gateway and securing endpoints with JWT authentication.● Integrated Tableau with Python-driven APIs to systematize report generation for a cloud analytics tool, cutting manual data processing time by 15 hours/week and automated visualization of 100+ system metrics, empowering stakeholders.● Formulated Agile sprints to deliver 5+ production-ready features per quarter, focusing on scalable backend services for complex applications and managed GitHub commits using CI/CD pipelines ensuring rapid iteration cycles.● Designed DynamoDB-backed microservices using Python, scaling to support 50+ concurrent users for a user management system to minimize API response times by 0.3 seconds, enhancing system responsiveness under peak traffic conditions. Show less

• 

  Purdue University

  Sept 2024 - Dec 2024

  Python Developer (Research Assistant)

  ● Designed and implemented serverless workflows by leveraging Python in conjunction with AWS Lambda, enabling a high-volume university platform to process monthly transactions seamlessly.● Automated PowerBI report generation using Python scripts to streamline the extraction, transformation, and loading (ETL) of university data, delivering actionable insights to over 50 users.● Integrated AWS S3 with Python to create a scalable storage solution for university logistics and dispatch systems, supporting RESTful APIs to manage over 20 requests per second, storing and retrieving critical operational data.● Employed Git as the cornerstone of version control for Python-based projects, managing dependencies and defining project environments to facilitate collaboration among university development teams.● Configured MongoDB databases to enhance network performance for university systems, reducing query latency from 2 minutes to 1 minute fine-tuning connection settings and mapping domain configurations to database servers, Show less

• 

  BNY

  Mar 2025 - now

  Software Developer

  ● Developed and maintained scalable backend modules using Python and SQL, supporting core financial systems for trade execution, reconciliation, and cash management across multi-asset portfolios.● Designed optimized SQL schemas and stored procedures to support real-time transaction processing and compliance reporting, reducing system latency and improving database efficiency.● Built interactive and secure web components using JavaScript and React, enhancing user experience on internal dashboards used by financial analysts and operations teams.● Implemented automated workflows using Python scripts to integrate third-party APIs for real-time market data ingestion, improving the responsiveness of trading and valuation modules.● Participated in full SDLC including code reviews, unit testing, and CI/CD integration via Jenkins and Git, accelerating deployment cycles for business-critical applications. Show less