Sql Server Data

Abhishek Dontineni

Summary:

Abhishek posseses over five years of experience in the MS SQL Server space. He has worked and excelled at organizations such as Anthem and Volkswagen. In addition to his experience working with SQL as a DBA, he has a very strong background with SSRS, SSIS and SSAS and the handling of performance-related issues such as database backup, transaction log backup and server tuning. Abhishek is also familiar with interfacing with the various stakeholders that are involved with any major project.

Technical Summary:

SQL Server, MS Excel and Access, database objects, queries, stored procedures, triggers, tables, joins, merges, unions, diagramming, performance monitoring, SQL Server Profiler, report generation, scheduling, BI, SSRS, SSIS.

Education & Certifications:

University of Michigan-Flint

Flint, MI

Masters in Computer Science, 2015

Professional Summary:

Anthem – Norfolk, VA- January 2016 until September 2016

DBA- contract

•Design, install and configure Microsoft SQL Server software and related products in a cluster/non-cluster environment working with cross-functional teams.

•Create database objects such as tables, views, stored procedures, triggers etc

•Address database failure and recoveries in a timley manner

•Perform database migrations

•Develop, manage, schedule and document BI operations and tasks, including extraction, movement, loading, archival, security, backup and aggregate table creation

•Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability

•Wrote queries for drill down reports to get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports using Global variables and expressions

•Create Entity Relationship (ER) Diagrams to the proposed database

•Develop reports in SQL Server Reporting Services

•Design, Develop and Deploy SSIS Packages

•Monitor industry trends and identify emerging technologies that should be adopted

•Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual Studio 2008

•Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments

•Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse groups of users, clients, and managers

•Responsible for creating the reports based on the requirements using SSRS 2008

Sipit Solutions –Flint, MI- November 2014 until December 2015

DBA- Intern

Provided Microsoft SQL Server support related to database and applications

Proactively monitored systems in order to resolve any incidents with the database

Developed Logical and physical data model using ERWIN and mapped the data into database objects

Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases

Optimized the database by creating various clustered, non-clustered indexes and indexed views

Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes

Diagnosing and tuning the server optimal performance using SQL Server 2008, SQL Profiler and Database Engine Tuning Wizards

Created Alerts for successful or unsuccessful completion of Scheduled Jobs

Run database full Backup, Transaction log backup & differential backup in daily Routine

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse

Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse

Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task

Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets

Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS

Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS

Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS)

Managed incident tickets and time tracking systems

Audit DataBank – Hyderabad, India- August 2013 to July 2014

ETL/SQL Developer - contract

Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system

Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key

Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio

Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION statement & using the TOP operator to limit the Select Statement in certain Queries

Created views to restrict access to data in a table for security

Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report

Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS

Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server

Scheduled the monthly/weekly/daily reports to run automatically

Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS

Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union

Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks

Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts

Tata Consulting Services- Hyderabad, India- May 2011 to August 2013

MS SQL Server and ASP.NET Developer- contract

Designed and developed database solutions based on functional requirements

Web module development and deployment using ASP.net MVC3.0 with jQuery

Implemented theme library with CSS classes and skins

Made integration with file server from web code to write attachments on a file server

Implemented database solutions that met expected quality standards

Monitored project status to meet milestones and resolve issues that might impact on quality or the ability to deliver to timescales or estimates

Implemented session tracking and auto save page data using times

Implemented single sign on with parent frame application

Produced technical design documents for the schema and stored procedure specifications

Troubleshoot production, real-time performance and concurrency issues

Deliver work on time and to specification, with minimal supervision

Created Stored Procedures, User Defined Functions, Views and TSQL Scripting for complex business logic

Created Stored Procedures which generated the necessary fact and dimension tables and functions that allowed performing necessary calculations depending upon the requirements

Responsible for migration of data from SQL Server 2005 to SQL 2008

Migrated heterogeneous databases to MS SQL Server 2008

Designed and created different ETL packages using SSIS from Oracle source to SQL server as destination

Created SSIS Packages to export and import data from Text files, CSV files and Excel Spreadsheets

Designed and implemented SSIS packages for data integration

Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them

Used N-tier architecture to plug reports to presentation layer using Report viewer control

Extensively worked on Cross tabbed and Matrix reports using SSRS

Designed and implemented indexing to optimize transactional and reporting performance

Implemented data integration processes to handle XML file generation or processing

Created XML schemas to validate data feeds

Used XPATH and XQUERY for XML parsing

Coordinated with web development team in .Net framework programming solutions

Integrated ASP.Net Web Pages to the SQL Server 2008 Back End

Contact this candidate