Sandeep Kumar Bantupalli

Background

About Sandeep Kumar Bantupalli

Experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite SQL Server 2008/2012 (Development and Production Environment on business domains like Banking and Energy Retailer). • Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2012/2008. • Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration. • Experience in Microsoft stack of BI solutions - SSRS, SSIS with MS SQL 2012/2008. • Experience in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS. • Experience in Extracting, Transforming and Loading (ETL) data from various sources to several destinations using BCP utility, DTS and SSIS. • Experience in Enhancing and Deploying the SSIS Packages from Development Server to Production Server using Execute Package Utility. • Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort, Data conversion, Pivot and un-pivot and Derived Column for cleaning bad data, validating the data. • Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors. • Experienced in database server performance tuning and optimization of Complex SQL queries. • Experience in Change Management process in creating, updating, closing the Change Request and Problem tickets using ticketing system tool called BMC Remedy. • Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance. • Experience in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.