Summary
Overview
Work History
Education
Skills
Certification
Projecthighlights
Disclaimer
Timeline
Generic

Siva Pavani Bondu

Senior SQL Developer
Pune

Summary

Accomplished IT professional with 7+ years of experience in software development, specializing as an SQL Developer for 4+ years. Expert in database design, performance tuning, and support across SQL Server environments. Proficient in crafting efficient queries, optimizing database structures, and ensuring seamless data integration and access for complex business applications.

Overview

7
7
years of professional experience
4
4
years of post-secondary education
4
4
Certifications
3
3
Languages

Work History

Senior SQL Developer

Krios Info Solution Ltd
Pune
06.2024 - 11.2024
  • Enhanced database performance through index optimization and query refinement
  • Developed and maintained critical stored procedures to support client requirements
  • Led data migration initiatives between servers using SQL Server Integration Services (SSIS) packages
  • Collaborated with cross-functional teams to streamline data flow and ensure efficient database operations
  • Provided mentorship and technical guidance to junior developers on best practices in SQL and database management
  • Developed custom reporting solutions using T-SQL, meeting unique business needs while maintaining high levels of accuracy and efficiency.
  • Troubleshot critical production issues related to SQL Server databases, providing timely resolutions to minimize downtime.

SQL Developer

Harbinger Group (ISG NOVASOFT Technologies Limited)
Hyderabad
07.2022 - 05.2024
  • Designed and implemented complex SQL queries to support client-specific business logic
  • Collaborated with cross-functional teams to ensure data integrity and optimize system response times
  • Managed database schema updates and enhanced stored procedures per user feedback

Senior Associate

Wipro Limited
Hyderabad
12.2017 - 05.2022
  • Spearheaded database maintenance and backup strategies, ensuring high availability
  • Performed comprehensive performance tuning to address slow-running queries
  • Provided development support for large-scale database systems and conducted regular code reviews
  • Consistently maintained strong relationships with clients, ensuring clear communication and timely updates on project progress.
  • Collaborated with cross-functional teams to drive successful completion of complex projects within deadlines.

Education

B.Tech - Electronics and Communication Engineering (ECE)

BVRIT College of Engineering For Women (JNTU-H)
Hyderabad
09.2013 - 07.2017

Skills

T-SQL Programming

Advanced Query Optimization

Database Object Creation

Stored Procedure Development

Function Development

Performance Tuning

Troubleshooting

SQL Server Agent Job Scheduling

SQL Server Integration Services (SSIS)

Backup Management

Disaster Recovery Planning

Multi-Version SQL Server Expertise

SQL Profiler

SSMS

DDL

DML

CTEs

Subqueries

Joins

Power BI

Table

GCP

Certification

Data Analytics Foundations At NxtWave

Projecthighlights

  • Advanced Database Enhancements and Email Automation, SQL Server, Stored Procedures, Data Integration, Senior SQL Developer, Data Management and Automation, Enhanced the organization’s data management system by implementing robust stored procedures, automating email communication, and improving data processing workflows., Email Automation and Data Integration: Designed and implemented email generation logic using existing templates, ensuring seamless data integration and efficient communication workflows., Error Diagnosis and Resolution: Expertly diagnosed and resolved complex data insertion errors, enhancing data reliability and system stability., Stored Procedure Development: Developed and optimized comprehensive stored procedures (SPs) to improve template management and streamline database operations., Data Migration and Processing: Migrated data from existing tables to temporary tables within stored procedures, boosting data processing efficiency and simplifying transformations.
  • Mahindra App Development Project, SQL Developer, SQL Server 2014, T-SQL, Automotive / Mobile App Development, This project involved creating a backend database for a mobile application for Mahindra. The database was designed to manage user data, app-related activities, product inventory, and service requests. I was responsible for designing the schema, creating tables, and writing complex queries to support the application’s functionalities. Additionally, I populated the database with 10,000 records for testing purposes and ensured data integrity through proper joins and relationships., Database Design & Schema Creation: Designed and created database schema to meet the app's business requirements, including tables for user information, inventory management, service requests, transactions, and product details., Defined relationships between tables using foreign keys, ensuring data integrity and optimizing query performance., Table Creation & Joins: Created 15+ tables for various entities, including Users, Products, Orders, Service Requests, and Payments., Designed complex SQL queries and used joins (INNER JOIN, LEFT JOIN, etc.) to retrieve related data across multiple tables for app-related functions, such as fetching user order history, product availability, and service status., Populating Database with Data: Used T-SQL scripts to generate and insert over 10,000 test records across multiple tables, simulating real-world data for the app’s testing phase., Ensured data consistency and accuracy when inserting records, ensuring the records adhered to the defined relationships and constraints., Performance Optimization: Wrote optimized SQL queries for fetching large sets of data, ensuring quick response times for the app's backend., Applied indexing strategies to frequently queried columns to improve data retrieval times., Stored Procedures & Functions: Developed stored procedures to handle user registrations, order placements, and service request submissions, encapsulating the business logic for efficient processing., Created user-defined functions to calculate order totals, product discounts, and tax computations based on the application’s rules., Data Validation & Integrity: Ensured that data entered into the system was consistent with the business rules by implementing validation checks within SQL queries and stored procedures., Managed referential integrity between tables using foreign keys and constraints., Collaboration & Support: Worked closely with developers and business analysts to ensure the database design aligned with the app's requirements and user experience., Provided ongoing support to the development team for database-related issues and assisted in troubleshooting performance bottlenecks.
  • Insurance Policy Maintenance and Claim Management Process, SQL Server 2014, 2016, Developer, Financial, Contributed to the development of a web application that streamlined policy management and claim processing for insurance agents, enhancing client satisfaction and operational efficiency., Created and maintained database structures and optimized access pathways., Implemented T-SQL solutions involving CTEs, temporary tables, and complex joins., Assisted in configuring SQL Server for report generation and user access.
  • Motor Vehicle Loss and Damage Claim Form, SQL Server 2012/2014, Developer, Financial, Developed a system to manage and verify motor vehicle damage claims, enabling a smooth process from client data submission to server-side validation., Designed scalable database tables and optimized stored procedures., Automated data verification processes to enhance validation accuracy., Provided routine support and resolved high-priority tickets effectively.

Disclaimer

I hereby declare that the information provided above is accurate and reflects my professional background and expertise.

Timeline

Senior SQL Developer

Krios Info Solution Ltd
06.2024 - 11.2024

SQL Developer

Harbinger Group (ISG NOVASOFT Technologies Limited)
07.2022 - 05.2024

Senior Associate

Wipro Limited
12.2017 - 05.2022

B.Tech - Electronics and Communication Engineering (ECE)

BVRIT College of Engineering For Women (JNTU-H)
09.2013 - 07.2017
Data Analytics Foundations At NxtWave
Introduction to Databases At NxtWave
Training on Machine Learning & its Application with Python At EduxLabs India
Programming With Python At NxtWave
Siva Pavani BonduSenior SQL Developer