Summary
Overview
Work History
Education
Skills
Timeline
Generic

Navya Ch

Cary,NC

Summary

A qualified SQL Developer with 7 years of IT experience known for high productivity and efficient task completion. Specialize in database design, query optimization, and performance tuning. Possess advanced skills in T-SQL programming, data analysis, and ETL processes. Excel in problem-solving, teamwork, and communication, ensuring successful project outcomes and effective collaboration with cross-functional teams.

Overview

7
7
years of professional experience

Work History

Senior SQL Developer

Victoria Secret
Remote
08.2023 - Current
  • Created stored procedures, functions, views, triggers and indexes for efficient data manipulation.
  • Developed and implemented complex SQL queries to extract data from multiple databases.
  • Designed complex reports using SQL Server Reporting Services.
  • Maintained security by creating user accounts and granting appropriate privileges as needed.
  • Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications.
  • Performed database tuning activities such as indexing, partitioning and performance monitoring.
  • Optimized existing queries by analyzing query plans and execution times.
  • Developed database schemas, scripts, and models in collaboration with application developers to meet project requirements.
  • Monitored database performance metrics and made adjustments to configurations and hardware to meet scalability demands.
  • Managed database backups and disaster recovery plans to ensure data preservation.
  • Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
  • Identified gaps in existing processes and provided recommendations on improving overall efficiency.
  • Ensured compliance with security policies defined by the organization.
  • Analyzed existing schema structures and modified them as per changing requirements.
  • Migrated databases from one server to another while ensuring minimal downtime.
  • Developed test cases for new features developed by team members.
  • Worked closely with Business Analysts to understand functional requirements and translate them into technical designs.
  • Monitored system resources utilization and optimized the same for better performance of applications.
  • Implemented automated processes for loading, unloading data into, from the databases using SSIS packages.

SQL Developer

US Bankcorp
Remote
03.2022 - 07.2023
  • Designed and developed complex SQL queries for data analysis and extraction to support business decisions.
  • Created and maintained database objects including tables, views, indexes, and triggers to ensure data integrity and performance efficiency.
  • Developed stored procedures, functions and triggers to support application requirements.
  • Created and presented dynamic reports and visualizations using Power BI and SSRS, effectively communicating insights to management and stakeholders.
  • Optimized existing queries for better performance using SQL query tuning techniques.
  • Designed complex reports using SQL Server Reporting Services.
  • Monitored database performance and troubleshooted issues related to slow running queries or deadlocks.
  • Analyzed business requirements and translated them into logical data models.
  • Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
  • Generated ad hoc reports upon request from stakeholders utilizing Microsoft Excel Pivot Tables or Access Queries.
  • Created and maintained technical documentation and reporting requirements, ensuring clarity and consistency in BI deliverables.
  • Documented SQL development processes, creating a knowledge base for best practices and troubleshooting.
  • Automated routine database tasks through scripting, reducing manual intervention and improving productivity.
  • Collaborated with cross-functional teams to gather requirements and translate business needs into technical specifications.

SQL Developer

Infosys Ltd.
08.2017 - 02.2022
  • As a developer, I was responsible for developing stored procedures, functions, and triggers to support application requirements.
  • Developed and executed database queries to conduct thorough analyses, delivering timely insights for strategic decision-making.
  • Participated in data governance initiatives, contributing to quality assurance and compliance in reporting processes.
  • Prepared charts and diagrams to illustrate system operation results to staff in other departments.
  • Prepared detailed documentation including diagrams, flowcharts, entity relationship models, to describe system functionality.
  • Implemented data integrity rules to ensure accuracy of data in databases.
  • Analyzed code and corrected errors to optimize output.
  • Assisted with the development of web-based applications utilizing SQL server technologies.
  • Installed and configured SQL Server databases, ensuring full functionality of the database environment.
  • Performed daily backups and recovery operations in accordance with established procedures.

Education

Bachelor in Information Technology -

Vasavi College of Engineering
Hyderabad
05-2017

Skills

  • Databases: SQL Server, Azure SQL Databases, Azure Data Factory
  • Languages: SQL, T-SQL
  • BI Tools: Power BI, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)
  • Development Tools: Version Control (Git), Azure DevOps

Timeline

Senior SQL Developer

Victoria Secret
08.2023 - Current

SQL Developer

US Bankcorp
03.2022 - 07.2023

SQL Developer

Infosys Ltd.
08.2017 - 02.2022

Bachelor in Information Technology -

Vasavi College of Engineering

Similar Profiles

CREATE PROFILE
Navya Ch