Rishi Vishal Garlapati
Ascension
Boston
1
Certification
8
years of professional experience
Senior Software Engineer (Python) with 9+ years of experience designing, developing, and supporting enterprise-scale software applications, data platforms, and cloud-native processing systems. Experienced in building scalable Python applications, developing reusable ETL frameworks, automating secure file processing, orchestrating Apache Airflow workflows, optimizing SQL and Oracle databases, and delivering high-performance enterprise solutions.
Strong expertise in Python, SQL, Oracle, PostgreSQL, Apache Airflow, AWS, BigQuery, CI/CD, Docker, Git, and enterprise workflow automation. Proven success designing batch processing systems, configuration-driven applications, secure FTP/SFTP integrations, data validation frameworks, production monitoring, and operational support for mission-critical business applications.
Experienced across the full software development lifecycle, including application design, development, testing, deployment, production support, performance optimization, technical documentation, and cross-functional collaboration. Passionate about developing maintainable, scalable, and reusable software solutions that improve operational efficiency and business reliability.
Work History
Senior Software Engineer
3 Months- Designed, developed, and maintained scalable Python applications supporting enterprise-scale data processing, workflow automation, and cloud-native integration solutions for high-volume business operations.
- Engineered reusable Python frameworks to automate secure FTP/SFTP file ingestion, validation, transformation, archival, and downstream processing, reducing manual intervention and improving operational efficiency.
- Developed complex SQL solutions using BigQuery and Oracle-compatible SQL, leveraging CTEs, window functions, recursive queries, and performance optimization techniques to support enterprise reporting and operational analytics.
- Built configuration-driven ETL workflows capable of processing structured and semi-structured data from CSV, Excel, JSON, XML, and flat-file sources while ensuring consistency and maintainability across deployments.
- Designed automated validation and reconciliation frameworks that compared source, staging, and target datasets to identify missing records, duplicate transactions, schema mismatches, and processing exceptions.
- Collaborated with software engineers, architects, QA teams, and business stakeholders to deliver scalable enterprise applications following Agile development practices and SDLC standards.
- Developed and optimized scheduled batch-processing workflows, improving application performance, processing throughput, and reliability for business-critical production systems.
- Implemented comprehensive logging, exception handling, monitoring, and operational alerting to improve production stability, simplify troubleshooting, and reduce incident resolution time.
- Supported CI/CD deployment activities, release validation, user acceptance testing (UAT), production cutovers, regression testing, and post-production verification to ensure reliable software releases.
- Authored technical design documents, operational runbooks, deployment procedures, API documentation, and knowledge transfer materials to support long-term maintainability and successful team collaboration.
Senior Software Python Developer
2 Years 9 Months- Designed and developed scalable Python and SQL applications to automate enterprise data processing, validation, and reporting workflows across multiple business domains.
- Engineered reusable ETL pipelines to ingest, transform, and process large volumes of structured enterprise data from multiple source systems into centralized analytical platforms.
- Developed high-performance SQL queries, stored procedures, and database objects using Snowflake, Oracle, and SQL Server to support business-critical reporting and operational applications.
- Built automated data validation and reconciliation frameworks that compared source, staging, and target datasets, ensuring data accuracy, completeness, and processing integrity.
- Collaborated with software engineers, QA teams, product owners, and business stakeholders to gather requirements, design scalable solutions, and deliver high-quality software releases.
- Automated recurring operational processes using Python and SQL, significantly reducing manual effort while improving processing speed, consistency, and reliability.
- Performed application performance tuning by optimizing SQL queries, refining ETL workflows, and improving database execution plans, reducing processing time by more than 40%.
- Supported production deployments, release validation, user acceptance testing (UAT), defect resolution, and post-production monitoring to ensure stable enterprise applications.
- Implemented comprehensive logging, exception handling, root cause analysis, and production support processes to improve application reliability and minimize operational disruptions.
- Created technical documentation, workflow diagrams, operational procedures, and knowledge transfer materials to support software maintenance, onboarding, and long-term platform scalability.
Software Engineer
2 Years 2 Months- Designed, developed, and maintained enterprise software solutions using Python, SQL Server, and SSIS to automate business-critical data processing and reporting workflows.
- Engineered scalable ETL pipelines to extract, transform, validate, and load high-volume transactional data from multiple enterprise systems into centralized SQL Server data warehouses.
- Developed reusable Python utilities to automate file processing, data cleansing, transformation, validation, and report generation, significantly reducing manual effort.
- Built modular data processing components capable of handling CSV, Excel, XML, JSON, and fixed-width file formats while ensuring data integrity and consistency across environments.
- Developed and optimized T-SQL queries, stored procedures, views, and indexing strategies, improving application performance and reducing ETL execution times by over 40%.
- Implemented robust data validation and reconciliation processes to verify data completeness, identify processing anomalies, and ensure consistency between source and target systems.
- Collaborated with software engineers, QA teams, and business stakeholders throughout the software development lifecycle, participating in requirements analysis, solution design, testing, deployment, and production support.
- Developed interactive Power BI dashboards and automated reporting solutions that provided operational insights, reduced manual reporting efforts, and improved business decision-making.
- Led a cross-functional team of nine engineers and analysts, coordinating development activities, conducting code reviews, mentoring junior team members, and ensuring timely delivery of high-quality software solutions.
- Authored technical specifications, ETL design documents, deployment guides, operational runbooks, and knowledge transfer documentation to support long-term application maintenance and future enhancements.
Software Engineer
1 Year 11 Months- Designed and developed scalable Python applications to automate enterprise data processing, integration, and workflow automation across cloud-based platforms.
- Engineered robust ETL pipelines using Python, AWS Glue, Amazon Redshift, and Apache Airflow to process high-volume enterprise datasets from multiple business systems.
- Developed and maintained Apache Airflow DAGs to orchestrate complex workflows, automate scheduling, manage task dependencies, and improve pipeline reliability.
- Built reusable Python libraries for secure FTP/SFTP file ingestion, automated validation, transformation, exception handling, and downstream data processing.
- Designed configuration-driven ETL solutions using modular Python components and YAML configuration files, enabling reusable deployments across multiple environments.
- Developed optimized SQL queries, views, and stored procedures to support enterprise reporting, operational analytics, data reconciliation, and performance optimization.
- Integrated Amazon S3, AWS Glue, Glue Crawlers, and Redshift to build scalable cloud-native data platforms supporting enterprise reporting and business operations.
- Implemented comprehensive logging, monitoring, alerting, retry mechanisms, and exception handling, improving production stability and reducing operational failures.
- Collaborated with cross-functional software engineering teams using Agile methodologies, Git, Jenkins, and CI/CD pipelines to deliver reliable software releases.
- Authored technical design documents, ETL specifications, deployment guides, operational runbooks, and knowledge transfer documentation to support long-term platform maintenance.
Education
Bachelor of Science - Computer Information Systems
- 3.8 GPA
Skills
Python
SQL (Oracle
PostgreSQL
MySQL
SQL Server
BigQuery)
T-SQL
R
SAS
Core Python
Object-Oriented Programming (OOP)
Pandas
NumPy
REST API Integration
File Processing
JSON
XML
YAML
CSV
Exception Handling
Logging
Multithreading (basic)
Modular Application Development
ETL Development
Data Pipelines
Batch Processing
Data Migration
Data Validation
Data Reconciliation
Workflow Automation
Enterprise Data Integration
File-Based Processing
Secure File Processing
Apache Airflow (DAG Development)
SnapLogic
AWS Glue
SSIS
Job Scheduling
Workflow Orchestration
Process Automation
Oracle
PostgreSQL
SQL Server
MySQL
BigQuery
Snowflake
Amazon Redshift
Database Performance Tuning
Stored Procedures
Views
CTEs
Window Functions
AWS (S3
Glue
Redshift)
Google Cloud Platform (BigQuery
Cloud Storage)
Microsoft Azure
Git
GitHub
Jenkins
Docker
CI/CD Pipelines
Unit Testing
Version Control
FTP
SFTP
Paramiko
File Automation
Secure File Exchange
Flat Files
Excel
CSV
XML
JSON
Production Support
Root Cause Analysis
Logging
Monitoring
Alerting
Performance Optimization
Incident Management
Release Support
UAT
Agile
Scrum
SDLC
Jira
Confluence
Power BI
Tableau
dbt
Certification
GCP machine learning engineer | Comptia A+ | AWS Cloud Practitioner
Timeline
Senior Software Engineer
Ascension
04.2026 - CurrentRead More
Senior Software Python Developer
Premier Inc
06.2023 - 03.2026Read More
Software Engineer
COE Software Inc
02.2020 - 04.2022Read More
Software Engineer
Neerinfo Solutions
02.2018 - 01.2020Read More
JNTU
Bachelor of Science from Computer Information Systems
Read More