Pavan Kolluri
Hyderabad
Summary
Accomplished Senior Software Engineer at JETA Software India Pvt Ltd, specializing in ETL workflows and SQL performance tuning. Proven ability to enhance data accuracy and streamline processes, leveraging strong data management skills and agile methodologies to deliver impactful BI solutions. Recognized for optimizing system performance and collaborating effectively with cross-functional teams.
Overview
6
6
years of professional experience
Work History
Senior Software Engineer
JETA Software India Pvt Ltd
Hyderabad
05.2024 - 12.2025
- Developed, implemented, and optimized stored procedures and functions using T-SQL.
- Architected robust ETL workflows using SSIS, ensuring seamless data integration and automation across reporting systems.
- Developed and automated SSIS packages to extract, transform, and load data from legacy systems to target databases.
- Created and optimized SQL queries, stored procedures, and database objects to support reporting needs.
- Analyzed existing SQL queries for performance improvements.
- Developed procedures and scripts for data migration and ETL process.
- Developed auto mailers using DB mailer and scheduled the SQL jobs based on business requirements.
- Responsible for database backup/restore, log shipping, and maintenance activities.
- Applied filtering, grouping, and cascading parameters for dynamic reporting using SSRS.
- Hands on with SQL Queries for Data analysis
- Hands-on with Excel for Data Analysis.
- Collaborated with cross-functional teams to define project requirements and specifications.
- Led code reviews to ensure adherence to best practices and maintainability standards.
- Improved system performance through the optimization of existing codebases.
Senior Software Developer
Shore Infotech Pvt. Ltd
Hyderabad
07.2021 - 04.2024
- Worked on implementing and optimizing stored procedures and functions using T-SQL and MySQL.
- Implemented SSIS packages for automated ETL from the source to the data warehouse.
- Developed procedures and scripts for data migration and ETL process.
- Developed auto mailers using DB mailer and scheduled the SQL jobs based on business requirements.
- Responsible for database backup/restore, log shipping, and maintenance activities.
- Wrote complex T-SQL scripts and stored procedures to support reporting logic, and enhance data accuracy.
- Worked on Azure databases and migrated the databases from co-location to Azure cloud storage.
- Collaborated with cross-functional teams to gather requirements and deliver actionable, compliance-focused BI solutions.
- Implemented agile methodologies to improve project delivery timelines.
Software Developer
Targray India Pvt. Ltd
Gurgaon
09.2020 - 05.2021
- Implemented SSRS reports using the SQL data sources.
- Built views, procedures, and functions for the stakeholder requirements.
- Collaborated with stakeholders to gather reporting requirements and deliver impactful BI solutions aligned with business goals.
- Designed user interfaces focusing on usability and customer experience improvements.
- Ability to work in the Agile model.
- Used JIRA as the task assigning and tracking tool for the priorities of the JIRA tool.
Software Engineer
Zeelog Logistic Solutions
New Delhi
05.2020 - 09.2020
- Utilized strong SQL skills for querying, validating, and preparing data for reporting layers.
- Created insightful SQL functions to support data-driven decision-making.
- Designed and published SSRS reports tailored to business operations and client needs.
- Engaged with stakeholders to understand reporting goals and deliver user-friendly visual analytics.
Education
M. Tech - Electrical and Electronics Engineering
JNTU Hyderabad University
Telangana, India08.2016
B. Tech - Electrical and Electronics Engineering
JNTU Hyderabad University
Telangana, India05.2014
Skills
- Data modeling
- Data management
- ETL
- SQL Server
- SSIS
- SSRS
- Data Warehousing
- Azure SQL Database
- Data proficiency
- TSQL
- MS SQL
- PL/SQL
- Microsoft Data Fabric
- T-SQL programming
- ETL workflows
- Data migration
- SQL performance tuning
- Cloud database management
- Agile methodology
- Maria DB
- DB Security
- Data Warehouse
- Performance Optimization
- Query tuning
- Streamlined ETL processes
- Data compliance
- Data governance
Timeline
Senior Software Engineer
JETA Software India Pvt Ltd
05.2024 - 12.2025
Senior Software Developer
Shore Infotech Pvt. Ltd
07.2021 - 04.2024
Software Developer
Targray India Pvt. Ltd
09.2020 - 05.2021
Software Engineer
Zeelog Logistic Solutions
05.2020 - 09.2020
M. Tech - Electrical and Electronics Engineering
JNTU Hyderabad University
B. Tech - Electrical and Electronics Engineering
JNTU Hyderabad University