Summary
Overview
Work History
Education
Skills
Timeline
Generic

Nischal G Lingeswara

West Haven,CT

Summary

Dedicated SQL Developer with over 2.5 years expert grasp of SQL code generation, analytics, reporting and business intelligence. Diverse knowledge of complex T-SQL coding instances. Conversant in up-to-date and legacy programming languages, standards and tools. Adept in leading all stages of software development and troubleshooting.

Overview

5
5
years of professional experience

Work History

SQL Developer

Eversoft Technologies LLC
08.2023 - Current
  • Extensively used SQL server reporting services to generate reports on weekly basis for particular sales type in given period.
  • Involved in scheduling reports to run weekly, quarterly, and monthly based on data to be reviewed by manager.
  • Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports, and Parameterized reports using SSRS 2008.
  • Created reports using Global Variables, Expressions, and Functions using SSRS 2008.
  • Used complex query statements like sub-queries, correlated queries, derived tables, and CASE functions to insert data depending on criteria into the tables of the hub.
  • Wrote T-SQL queries, and created dynamic Stored Procedures by using input values.
  • Extensively used BCP and BULK INSERT to import and export data from flat files, Excel, and MS Access to MS SQL Server databases.
  • Applied monthly patches and hotfixes.
  • Created Alerts for successful and unsuccessful completion of Scheduled Jobs.
  • Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard, and SQL Query Analyzer in MS SQL Server 2008.
  • Developed reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers.
  • Designed and implemented Stored Procedures and Triggers for automating tasks.
  • Maintained the table performance by following the tuning tips like Normalization, Creating Indexes, etc.
  • Enhanced intricate SQL queries, leading to a $50,000 yearly cost reduction through decreased processing time and resource usage.
  • Successfully deployed a new database structure that resulted in a 40% increase in data retrieval efficiency and a 20% decrease in query response time.
  • Senior management recognized my exceptional performance in fixing major database issues under duress and my proactive approach to problem-solving.

Junior SQL Developer

Kubex Computer Software Pvt Ltd
02.2020 - 06.2021
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Created and Improved SQL queries to expedite data loading, transformation, and extraction (ETL) operations, increasing processing speed and efficiency by 25%.
  • Participated in 10% faster project delivery times by working together with senior engineers to design and build database solutions customized to customer needs.
  • 30% less time was spent on average for query execution, thanks to my assistance in performance tweaking SQL queries and stored procedures.
  • Over 50 customized reports were produced each month to assist business decision-making processes.
  • Data analysis and report generation were carried out using SQL Server Reporting Services (SSRS).
  • Found and fixed problems with databases, keeping important systems up and running at 99.8%, and guaranteeing users' continuous access to data.
  • Communicated effectively with stakeholders to gather requirements and provide project updates, ensuring 100% client satisfaction with project deliverables.

Student Intern

Xcelerator.ninja
08.2019 - 01.2020
  • In order to write and optimize SQL queries for data retrieval and analysis, I helped senior SQL developers.
  • Contributed suggestions for enhancing data accessibility and organization during database design discussions.
  • To guarantee accuracy and dependability of database entries, quality assurance and data validation tests were carried out.
  • Gained experience with real-world SQL challenges by working with teammates to troubleshoot and fix database-related issues.
  • Improved team knowledge sharing and documentation standards by documenting SQL scripts and procedures for future reference.
  • I have helped to create SQL reports and dashboards with Power BI and SQL Server Reporting Services (SSRS) as reporting tools.
  • Participated in training sessions and workshops to enhance SQL proficiency and be informed about most recent SQL technology and optimal methodologies.

Education

Master of Science - Electrical And Computer Engineering

Cleveland State University
Cleveland, OH
05.2023

Bachelor of Science - Electronics And Communications Engineering

Acharya Institute Of Technology
India
05.2020

Skills

  • Database Management: Installation, Configuration, and Maintenance (SQL Server 2012-2019), Fail-Over Clustering (SQL Server 2012), Always-On Environments, Replications
  • Database: Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite
  • Database Design Principles: Normalization, Entity-Relationship (ER) modeling, Database schema design
  • Database Objects: Tables, Views, Indexes, Stored procedures, Triggers, User-defined functions (UDFs)
  • Query Optimization: Indexing strategies, Query execution plan analysis, Performance tuning
  • Data migration and Transformation: Extract, Transform, Load (ETL) tools, SQL Server Integration Services (SSIS)
  • Reporting and Visualization tools: SQL Server Reporting Services (SSRS), Power BI, Tableau
  • Scripting Languages: Python, PowerShell

Timeline

SQL Developer

Eversoft Technologies LLC
08.2023 - Current

Junior SQL Developer

Kubex Computer Software Pvt Ltd
02.2020 - 06.2021

Student Intern

Xcelerator.ninja
08.2019 - 01.2020

Master of Science - Electrical And Computer Engineering

Cleveland State University

Bachelor of Science - Electronics And Communications Engineering

Acharya Institute Of Technology

Similar Profiles

CREATE PROFILE
Nischal G Lingeswara