Sql Server Manager

Manpreet Kaur Sandhu

Email Id: ***************@*****.***

Phone: 703-***-****

Summary:

. Over 2 years of extensive experience in database design, development

and administration with MS SQL Server versions 2012/2008 using SSIS,

SSRS.

. Strong experience in creating T-SQL objects, working with DDL/DML,

perform most of the SQL Server Enterprise Manager and Management

studio functionality using T-SQL Scripts and Batches.

. Proficient in creating Indexed Views, complex Stored Procedures,

effective functions, and appropriate Triggers to facilitate efficient

data manipulation and data consistency.

. Experience in writing Distributed Queries between SQL Servers.

. Handled vast financial data, expert level query optimization and

performance tuning experience.

. Expertise in generating reports using SQL Server Reporting Services

(SSRS), and Microsoft Access & Excel spreadsheet.

. Exporting the Database from Local Server to the Remote Server and

Importing the Current running database from remote server to the Local

DB Server using SSIS.

. Experience in creating various reports like drill down, sub reports,

parameterized, multi-valued and various Adhoc reports through Report

model creation using SSRS.

. Excellent Knowledge of Software Development Life Cycle, RDBMS, Data

Warehouse & Data Modeling concepts.

. Proficiency in ASP.NET, VB.Net, Visual Basic, C#, Java Script, HTML,

XML and XSL.

. Good Business and System analysis skills to understand the

requirements and customize client applications.

. Strong troubleshooting and problem solving skills. Strong ability to

prioritize multiple tasks. Excellent communication skills, proactive,

self-managing and teamwork spirits.

. Well-organized, goal-oriented, highly motivated effective team member

with excellent analytical, troubleshooting, and problem solving

skills.

Education & Certification:

. Master of Science (IT)

. Master of Computer Application

Technical Skills:

. MS SQL Server 2012/, MS SSRS 2008/2005/2000, MS SQL SSAS

2008/2005/2000, MS SSIS 2008/2005/2000, MS-Access 2000, C, C++, VB

6.0,Developer 2000, T-SQL, PL/SQL, ASP.NET,, HTML, XML, XSL, Visual

Studio 2005, T-SQL, PL-SQL, Crystal Reports, ODBC, MS Office, Windows

NT/ 2000 Server/ XP.

Celeste XPTech, Chandigarh, India Mar

2012 - Sep 2014

Jr. MS SQL Server Developer

. Celeste XPTech investing business, to help meet the world's power and

fuel needs.

. Businesses that finance with Celeste XPTech benefit from the global

know-how. The main aim of the project was to support the SQL Server

databases and ensure their performance, availability, security and SQL

development for DTS and stored procedure.

Responsibilities:

. Planned, Defined and Designed data based on business requirement and

provided documentation.

. Modified the existing SSIS packages to meet the changes specified by

the users.

. Scheduled Jobs for executing the stored SSIS packages, which were

developed to update the database on Daily basis using SQL Server Agent.

. Involved in creating alerts for successful or unsuccessful completion

of scheduled jobs.

. Generated parameterized reports, sub reports, tabular reports using

SSRS 2012.

. Designed, Developed and Deployed reports in MS SQL Server environment

using SSRS-2012.

. Generated Sub-Reports, Conditional, Drilldown reports, Drill through

reports and parameterized reports using SSRS 2012.

. Created reports to retrieve data using Stored Procedures that accepts

parameters.

. Scheduled the monthly/weekly/daily reports to run automatically onto

the Dashboard.

. Created various database object like stored procedures, functions,

tables, views

. Configured the report viewing security for various users at various

levels using Report Manager.

. Scheduled report and exported in PDF format.

. Fine-tuned SQL Queries for maximum efficiency and performance using SQL

Profiler and Database Engine Tuning Advisor.

. Provided documentation for all kinds of reports and SSIS packages.

. Designed and implemented Stored Procedures and Triggers for automating

tasks.

Tools & Technologies:

MS SQL Server 2008, MS SQL Server 2012, SQL server 2000, MS Excel, T-SQL.

Contact this candidate