Summary
Overview
Work History
Education
Skills
Timeline
Additional Information
Languages
Accomplishments
Interests
Generic
Bhavana Kodali

Bhavana Kodali

Hyderabad

Summary

Dedicated and accomplished MS SQL Developer with 5 years of experience in designing and implementing innovative and actionable database solutions. Proficient in Transact-SQL (T-SQL), SQL, and SSIS, with a strong track record of delivering robust database systems for insurance products, including Property, Casualty, Accident, Death, Health, and Life insurances. Adept at presenting data insights and solutions to all levels of leadership. Skilled at bridging the gap between developers and end-users to shape and achieve business goals through data-driven, scalable solutions. Seeking a rewarding and challenging position with opportunities for professional growth and potential advancement into upper management.

Overview

6
6
years of professional experience

Work History

MS SQL Developer

Sapiens International Corporation
Bangalore
01.2023 - Current
  • Utilized VRM Tool as a front-end software in the Insurance domain by Sapiens.
  • Developed and communicated Root Cause Analysis (RCA) to customers for reported issues and queries.
  • Generated reports using Report Builder tool connected to SQL Server for data retrieval and report generation.
  • Supported activities included monitoring, root cause analysis, code fixes, and reporting.
  • Currently engaged in development, defect fixing, daily monitoring, and support tasks.
  • Managed customer issues and inquiries on a daily basis.
  • Estimated effort required for defect fixes and provided timely resolutions.
  • Deployed client-specific changes in SQL DB ensuring no impact on other clients.
  • Customized the product to meet specific client requirements.
  • Monitored and troubleshooted long-running jobs and performance-related issues.
  • Assisted in designing new database structures based on stakeholder requirements.
  • Conducted unit testing on newly developed objects to ensure accuracy before production deployment.
  • Designed and implemented complex SQL queries for data analysis and extraction supporting business decisions.

MS SQL Developer

IQVIA Pharmaceutical company
Bangalore
01.2022 - 01.2023
  • Utilized CIRT Tool, an Interactive Response Technology (IRT) software, within Clinical Trials and Health Care domains.
  • Facilitated client meetings to secure approval for changes and enhancements.
  • Currently engaged in software development and defect resolution using IRT solutions.
  • Accountable for interpreting and constructing studies according to client specifications.
  • Collaborated effectively with cross-functional teams to accomplish project objectives.
  • Implemented end-to-end process automation for forms and tasks in the Drug Supply Chain.
  • Developed forecast models to analyze drug and dose dispensing data.
  • Leveraged SQL for developing forms and tasks in the CIRT Tool, ensuring efficient data storage.
  • Applied business logic through Indexes, Views, and Stored Procedures.
  • Evaluated and optimized existing business procedures, recommending and implementing improvements.
  • Updated and maintained Stored Procedures and Rules using SQL Server 2013.

MS SQL + SSIS Developer

Cognizant Technology Solutions
Chennai
01.2019 - 01.2022
  • Collaborated with Business Users and Supervisors to gather and refine business requirements.
  • Engaged in development, defect fixing, daily monitoring, and support activities.
  • Deployed client-specific changes in Visual Studio ensuring no impact on other clients.
  • Tested and debugged business logic, writing comprehensive Unit Test Cases.
  • Ensured data integrity and consistency.
  • Processed XML data from files into SQL Server tables.
  • Developed queries and stored procedures using T-SQL in SQL Server 2005 and 2013.
  • Employed joins, sub-queries, and optimized procedures and indexes for enhanced query performance on production servers.
  • Resolved data issues and SQL 2008Database-related concerns.
  • Generated reports using SQL.
  • Provided prompt responses to client queries.
  • Created and tested SSIS Packages in SQL Server 2008 for data transfer between staging and production servers.
  • Implemented complex queries, joins across multiple tables, stored procedures, triggers, and utilized SSIS Packages.
  • Managed clustered and non-clustered indexes to optimize SQL Server performance.
  • Prepared Root Cause Analysis (RCA) and communicated findings to customers for reported issues and queries.

Education

Bachelor of Technology - Information Technology

VR Siddhartha Engineering College
01.2019

Intermediate -

Sri Gayatri Jr College
01.2015

Narayana High School
01.2013

Skills

  • Technical skills Microsoft Office tools
  • SSIS
  • Microsoft SQL Server
  • SSRS
  • Soft skills Effective communication
  • Troubleshooting
  • Relationship’s builder
  • Proper phone etiquette
  • Drive and Initiative
  • Adaptability
  • Stored Procedures
  • Error Handling
  • Teamwork and Collaboration
  • Data Validation

Timeline

MS SQL Developer

Sapiens International Corporation
01.2023 - Current

MS SQL Developer

IQVIA Pharmaceutical company
01.2022 - 01.2023

MS SQL + SSIS Developer

Cognizant Technology Solutions
01.2019 - 01.2022

Bachelor of Technology - Information Technology

VR Siddhartha Engineering College

Intermediate -

Sri Gayatri Jr College

Narayana High School

Additional Information

  • Cognizant (Chubb Insurance) Business appreciation for delivering tasks with in the timelines and adding valuable inputs Cognizant (Chubb Insurance) Business On-Spot Team Award for delivering a critical task in an emergency. Cognizant (Chubb Insurance), Interests Skills Achievements

Languages

Telugu
First Language
English
Proficient (C2)
C2
Hindi
Intermediate (B1)
B1
Tamil
Beginner
A1

Accomplishments

  • Received “Amber” award for delivering best performance in first quarter as a new joiner in the organization. Cognizant (Chubb Insurance)
  • Business appreciation for delivering tasks with in the timelines and adding valuable inputs Cognizant (Chubb Insurance)
  • Business On-Spot Team Award for delivering a critical task in an emergency. Cognizant (Chubb Insurance)

Interests

  • Playing Nine Men's Morris.

Similar Profiles

CREATE PROFILE
Bhavana Kodali