Summary
Overview
Work History
Education
Skills
Timeline
Generic

Raghu Vamsi Koppisetti

Hyderabad

Summary

Database Engineer with over 5 years of experience in the IT industry, specializing in database design, development, and ETL processes using SQL Server and SSIS. Skilled in optimizing stored procedures, SQL queries, and performance tuning using execution plans. Proficient in database normalization, indexing, partitioning, and schema binding. Strong background in Agile methodologies and delivering robust data solutions for diverse business needs.

Overview

6
6
years of professional experience

Work History

Database Engineer

Nowcom Global Services India
12.2019 - Current
  • Project 1: Marketing and Emanate
  • Client: Westlake Financial Services and Western Funding
  • Environment: Windows, SSIS, Oracle, SQL Server
  • Role: SQL Developer
  • Key Responsibilities:
  • Analysis: Analyzed client specifications and requirements for internal financial applications.
  • Database Development: Created SQL objects including tables, views, stored procedures, and functions.
  • SQL Optimization: Wrote and optimized SQL statements using joins, string/date functions, temp tables, CTEs, and table variables.
  • Data Management: Implemented dynamic data deletion processes independent of data hierarchy.
  • ETL Process: Led the end-to-end ETL process and production support; built efficient SSIS packages for complex data transformations.
  • Automation: Designed automation scripts and scheduled jobs for report generation.
  • Collaboration: Participated in daily status calls and interacted with onsite business analysts to ensure project alignment.
  • Project 2: Polar and Genesis
  • Client: WestLake Direct
  • Environment: Windows, SSIS, Oracle, SQL Server
  • Role: SQL Developer
  • Key Responsibilities:
  • Analysis: Analyzed client specifications and requirements for an underwriting platform.
  • Database Development: Created SQL objects including tables, views, stored procedures, and functions.
  • SQL Optimization: Wrote and optimized SQL statements using joins, string/date functions, temp tables, CTEs, and table variables.
  • Data Management: Implemented dynamic data deletion processes independent of data hierarchy.
  • ETL Process: Led the end-to-end ETL process and production support; built efficient SSIS packages for complex data transformations.
  • Automation: Designed automation scripts and scheduled jobs for report generation.
  • Collaboration: Participated in daily status calls and interacted with onsite business analysts to ensure project alignment.
  • Project 3: DoorAccessTimeClock
  • Client: Nowcom Global Services
  • Environment: SQL Server 2017
  • Role: SQL Developer
  • Key Responsibilities:
  • Database Development: Created SQL objects including tables, views, stored procedures, and functions.
  • SQL Optimization: Improved the performance of payroll processing by optimizing execution plans and archiving data.
  • Application Support: Supported workforce management, including shift timing, leave requests, and payroll processing.
  • Collaboration: Participated in daily status calls for new development requirements.

Education

Bachelor of Technology (BTech) -

Jawaharlal Nehru Technological University Kakinada (JNTUK)
Gudlavalleru
01.2017

Skills

  • Database design and normalization
  • Stored procedures and functions
  • Triggers and views
  • Performance tuning and indexing
  • Table partitioning and schema binding
  • Sub-queries and CTEs
  • Temporary tables and table variables
  • BCP and bulk insert
  • Automation scripts
  • SSIS package design and deployment
  • Production support
  • Unit testing

Timeline

Database Engineer

Nowcom Global Services India
12.2019 - Current

Bachelor of Technology (BTech) -

Jawaharlal Nehru Technological University Kakinada (JNTUK)

Similar Profiles

CREATE PROFILE
Raghu Vamsi Koppisetti