Summary
Skills
Work History
Education
Languages
Overview
Work Preference
OfficeManager

SHIVA Nannapaneni

Senior SQL & BI Developer
Hyderabad

Summary

Creative Senior Software Engineer offering 10 years of experience. Enthusiastic about developing forward-thinking solutions to tomorrow's productivity problems. Resourceful and adaptable approach to challenges.

Skills

SQL Server

undefined

Work History

Senior Software Engineer

APTonline (Subsidiary of TCS)
Hyderabad
06.2021 - Current
  • Managed multiple projects, delivering accurate and timely results under tight deadlines
  • Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using MS SQL
  • Enhanced software functionality by identifying and resolving complex technical issues
  • Automated routine tasks using scripting languages, increasing efficiency within daily operations
  • Creation of Jobs, Schedules, Alerts using MS SQL Server Agent and Notifications using MSSQL Mail
  • Mentored junior developers, fostering professional growth and enhancing team productivity
  • Improved data accuracy by conducting thorough data validation and cleansing tasks
  • Deployed and scheduled SSIS Package
  • Developed efficient data migration processes for seamless integration of new systems
  • Developed SSRS reports for business stakeholders, streamlining decision-making processes
  • Subsidiary of TCS

Senior Software Engineer

Quess Corp
Hyderabad
12.2020 - 05.2021
  • Developed database architectural strategies at modelling, design, and implementation stages to address business or industry requirements
  • Developed efficient stored procedures and functions for streamlined data processing, resulting in improved system performance
  • Optimized database performance by fine-tuning complex SQL queries
  • Evaluated and recommended best practices to improve existing SQL codebase, leading to increased efficiency and reduced maintenance efforts
  • Developed custom reporting solutions using T-SQL, meeting unique business needs while maintaining high levels of accuracy and efficiency
  • Performed routine maintenance tasks such as backups, index rebuilds, and updating statistics to maintain optimal system health
  • Managed access control within SQL Server environment by implementing role-based security measures, ensuring appropriate permissions were granted based on user needs

Software Engineer

Core Integra Consulting Services
Hyderabad
08.2016 - 11.2020
  • Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using MS SQL
  • Created & managed the Database Users, Login, Roles, Profiles and Security
  • Automated Backup/Restore Jobs as well as reduce the Backup/Restore time up to significant amount
  • Creation of Jobs, Schedules, Alerts using MS SQL Server Agent and Notifications using MSSQL Mail
  • Worked on performance tuning of Database and Query tuning
  • Involved in resolving blocking and dead lock Issues by using MS SQL commands Using T-SQL
  • Monitoring Event viewer, MS SQL Error logs and Log File Viewer for Software and hardware related errors
  • Work with business stakeholders and application developers do identify business needs and discuss solution options
  • Experience in migration of Data from Excel, Flat file, MySQL to MS SQL Server by using SSIS
  • Deployed and scheduled SSIS Package
  • Installed ODBC drivers of MySQL and Postgres to migrate data into SQL server using SSIS
  • Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with lot of interaction with client
  • Involved in creating traditional as well as Web-based interactive reports like matrix reports, drilldown reports, drillthrough, linked reports using SSRS
  • Created and deployed and scheduled reports using SSRS

Associate Software Engineer

APTonline (Subsidiary of TCS)
Hyderabad
08.2015 - 07.2016
  • Company Overview: subsidiary of TCS
  • Installed and configured SQL Server 2012 along with Integration Services (SSIS), Analysis services (SSAS), and Reporting services (SSRS)
  • Responsible for writing scripts in T-SQL to create stored procedures, views, triggers
  • Created indexes, Constraints and rules on database objects for optimization
  • Database Backup Procedures, Restoration Procedures, Disaster Recovery Procedures and Contingency plans
  • Created SSIS packages from scratch to move data from flat file, Excel and OLE DB sources
  • Created Jobs, Alerts and schedule SSIS Packages
  • Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports by using SSRS
  • Production Support, real-time performance and concurrency issues
  • Authored technical design documents for the schema and stored procedure specifications
  • Subsidiary of TCS

Associate Software Engineer

Dumadu Games
Bengalore
04.2013 - 04.2014
  • Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Rules and Defaults
  • Designed and developed ETL packages for extracting and loading the data into appropriate tables in the database using SQL Server Integration Services (SSIS)
  • Created automated stored procedures for day end operations using SQL Server agent
  • Coordinated with front-end for implementing logic in stored procedures and functions
  • Created jobs, alerts to run SSIS packages periodically
  • Designed SSIS package to export and import data from SQL Server to Access, text files and Excel files
  • Generated periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS) according to the client requirements
  • Performed Server installation and configuration using SQL Server 2008 R2
  • Automated processes using SQL Server jobs

Education

Master of Computer Application -

Godavari Institute of Engineering & Technology (JNTUK)
Rajahmundry
08.2009 - 05.2012

Languages

English
Bilingual or Proficient (C2)
Telugu
Bilingual or Proficient (C2)
Hindi
Intermediate (B1)

Overview

10
10
years of professional experience

Work Preference

Work Type

Full Time

Location Preference

HybridRemote

Important To Me

Career advancementWork-life balanceFlexible work hours

Similar Profiles

  • Amol Phansekar

    Amol PhansekarAmol Phansekar

    Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD

  • SARVESH SHRIYAN

    SARVESH SHRIYANSARVESH SHRIYAN

    Application Consultant /Senior Analyst at Rtv Tech Pvt Ltd (Subsidiary of Rupeeseed Pvt Ltd)Application Consultant /Senior Analyst at Rtv Tech Pvt Ltd (Subsidiary of Rupeeseed Pvt Ltd)

  • YOGA PRAKASH

    YOGA PRAKASHYOGA PRAKASH

    Software Engineer at Sterling software Pvt Ltd, a CAMS SubsidiarySoftware Engineer at Sterling software Pvt Ltd, a CAMS Subsidiary

  • Prakash Gadhamsetty

    Prakash GadhamsettyPrakash Gadhamsetty

    Assistant Consultant at Tata consultancy services limitedAssistant Consultant at Tata consultancy services limited

  • Chemicala Harshitha Reddy

    Chemicala Harshitha ReddyChemicala Harshitha Reddy

    Associate Software Developer at SID Global SolutionsAssociate Software Developer at SID Global Solutions

CREATE PROFILE
SHIVA NannapaneniSenior SQL & BI Developer