Sql Server Data

Bhagawat Bhandari

Phone: 817-***-****

********.********@*****.***

Professional Description:

• Over four years of hands on experience as MS SQL Server 2005/2008/2008R2/2012

Database Developer.

• Good experience in creating SQL Server database objects such as tables, procedures,

views, functions and triggers for a project.

• Strong knowledge of RDBMS and experience in creating, maintaining and tuning views,

stored procedures, user defined functions and system functions using SQL Server, T-SQL.

• Good knowledge in SQL Server 2008/2008R2/2012 database development and data

migration.

• Experienced with tools like SQL Server Management Studio, SQL Server 2008/2012

Integration (SSIS) and Reporting Services (SSRS).

• Hands on experience in coding queries using Group By, Order By, Having, Union and

Merge Join Clauses.

• Involved in all phases of project Documentation (requirement gathering), Designing,

Development, Unit testing and Defect fixing.

• Having experience in project Quality Assurance.

• Participated in all phases of SDLC starting from Analysis to Delivery of the application

development projects and also supported enhancements and maintenance of existing

applications.

• Good knowledge in designing ETL data flows using SSIS; creating workflows/mappings

to extract data from SQL Server and data Migration and Transformation from Access/

Excel Spreadsheet using SQL Server SSIS.

• Extracted, transformed, and loaded data from various heterogeneous data sources and

destinations like Excel, Access and Flat files.

• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index

Tuning Wizard.

• Participated in Database Backup, Recovery, and Disaster Recovery procedures.

• Experienced in developing Drill Through, Drill Down, Sub Reports and Charts using

Global variables, Expressions and Functions for business users.

• Involved in creating Ad-reports for Business Intelligence.

• Having sound knowledge on creation and scheduling of T-SQL jobs to run daily.

• Capable to work independently as well as work with teams of varying backgrounds and

have strong verbal and communication skills.

• Self-motivated, project-oriented and determined to accomplish projects on time. Flexible

and versatile to adapt to any environment and eager to work on any project assigned.

Technical Proficiency:

Operating System Windows2000,Windows XP, Windows Vista,

Windows(7/8)

Database Tools MS SQL Server2005/2008/2008R2/2012, MS Excel

ETL Tools Data Transformation Services (DTS)-Export/Import, SQL

Server Integration Services (SSIS)

Language VB, HTML,CSS, SQL

BI Tools SSMS, SSIS, SSRS, SSAS

Academic Qualifications:

Bachelors of Science (Physics)

Tribhuvan University, Nepal.

Microsoft Certifications:

MS SQL Server 2008, Business Intelligence Development and Maintenance

Professional History:

New Breed Logistics

Fort Worth, TX

Dec 2013-Till Date

SQL/SSIS/SSRS Developer

Description: New Breed Logistics is one of the leading Technology-based businesses in the

North America with its mission to meet or exceed customer’s expectation to provide innovative

and value-based technological solutions. The scope of the project which I was involved in was to

design and develop data warehouse and migrate data from various sources into SQL database

using SSIS and generating reports using SSRS.

Responsibilities:

• Created and modified tables, stored procedures, various indexes, triggers and check

constraints.

• Worked on the file import framework procedure for various flat file structures to have

data in our database.

• Created SSIS packages to clean and load data warehouse.

• Created deployment scripts after the development is completed for every project.

• Deploy SSIS Package into production and used package configuration to export various

package properties to make package environment independent.

• Imported various files provided by clients into relational database system.

• Created tabular, matrix, chart, drilldown reports, parameterized and cascaded reports as

per the business needs.

• Created DTS package to schedule the jobs for batch processing.

• Participated in managing historical data form various heterogeneous data sources (Excel,

Access).

• Designed SQL SSIS packages to extract data from various data sources such as Access

database, Excel spreadsheet, and flat files into SQL Server for further data analysis and

reporting by using multiple transformations provided by SSIS such Data Conversion,

Conditional Split, Bulk Insert, Merge and Union all.

• Involved in installing SQL Server Client side utilities and tools for all the front-end

developers/programmers.

• Created business-based stored procedures and functions to support efficient data storage

and manipulation.

• Participated in different 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.

• Worked on DTS packages, DTS Import/Export for transferring heterogeneous database.

• Tested the installation of SQL Server.

• Actively participated in various stages of Project Life Cycle (User Requirement and

System Specification gathering, coding, designing, testing, and maintenance).

• Skilled on data migration (import/export) from text to SQL Server.

• Documentation of all types of projects as per the requirements.

Environment: SQL Server 2008/2008R2/2012, SQL Server Business Intelligence Development

Studio 2008, SSIS, SSRS, T-SQL.

Liberty Bank

Fort Worth, TX

Sep. 2012-Nov 2013

SQL/SSIS/SSRS Developer

Description: Liberty Bank is a full service community bank, providing varying range of

financial services to business and individuals. Among the bank’s market are consumer, small

businesses, mediocre markets and trade finances. The scope of the project was to assist the sales

departments and marketing to categorize their customers based on portfolio of services like

savings accounts and checking accounts.

Responsibilities:

• Created Databases, Tables, Unique/Check Constraints, Views, Stored Procedures and

Triggers.

• Wrote efficient stored procedures for the optimal functioning of the system.

• Responsible for creating modifying T-SQL stored procedures/ triggers for validating the

integrity of the data.

• Generated custom and parameterized reports using SSRS.

• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC

environments.

• Responsible for coding SSIS processes to import data into the Data Warehouse from

Excel Spreadsheet, and OLEDB sources.

• Actively involved in developing SSRS Reports involving Sub-Reports, Matrix/Tabular

Reports, Charts and Graphs.

• Created several packages in SSIS.

• Worked on various tasks and transformations like Execute SQL Task, Execute Package

Task, and Conditional Split, Script Component, Merge and Lookup while loading the data

into the destination.

• Created various Ad-hoc SQL queries for customer reports, execute management reports

and report types like tabular, matrix, sub reports etc.

• Responsible for rebuilding the indexes and tables as part of performance tuning.

• Used SQL Server Agent for scheduling jobs.

• Performed Query Optimization and Performance Tuning.

Environment: SQL Server 2008, SSIS 2008, SSRS 2008, T-SQL, SQL Server Agent, XML, MS

Excel, MS Access.

Western Finance Ltd.

Abilene, TX

Feb 2011-August 2012

SQL/SSIS/SSRS Developer

Description: Headquartered in San Angelo, Texas, Western Finance provides installment loans,

financing of consumer merchandise and every day financing needs of potential consumers. The

project involved building a data repository to organize mortgage loans documents which are

received from customers, submitted through various branches and different sales teams.

Responsibilities:

• Involved in database development using stored procedures, triggers, views and cursors.

• Involved in creating indexes for speedy retrieval of data.

• Designed, developed and maintained relational database.

• Responsible for SSIS activities to move data from text files to SQL Server.

• Scheduled SSIS packages on daily basis.

• Worked with Dynamic Management Views (DMV) for improving query performance.

• Created SSIS Packages to import and export data from Excel Spreadsheet, Text files and

CSV files.

• Monitored the performance and optimized SQL queries for maximum efficiency.

• Scheduled automated jobs using SQL Server Agent.

• Responsible for creating reports using SSRS 2008.

• Involved in SSRS report deployment and report server configuration.

• Created Drill-down, Drill-through and Sub-Reports and linked reports using SQL Server

Reporting Services.

• Identified the database tables for defining the queries for the reports

• Deployed the generated reports onto the server.

• Responsible for deploying reports to Report Manager and troubleshooting errors during

execution.

• Involved in the fine tuning of the database objects and server to ensure efficient data

retrieval.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Agent, SSIS 2008, SSRS 2008,

T-SQL, Windows 2000/2003 Server, XML, MS Excel, MS Access.

Siliguri HDFC Bank Ltd.

August 2009-August 2010

Siliguri, West Bengal, India.

SQL/SSIS/SSRS Developer

Description: It is one of the trusted financial institutions committed to provide financial needs of

customers in the state of West Bengal, India. The main scope of my project was to maintain

user’s saving and checking account and transfer funds.

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and

Views using T-SQL in SQL Server 2005.

• Wrote efficient stored procedures for the optimal performance of the system.

• Validated change requests and made appropriate recommendations. Standardized the

implementation of data.

• Promoted database objects from test/develop to production and coordinated and

communicated production schedules within development team.

• Modified database structures as directed by developers for test/develop environments and

assist with coding, design and performance tuning.

• Involved in ETL architecture enhancements to increase the performance using query

optimizer.

• Involved in complete SSIS lifecycle in creating SSIS packages, building, deploying, and

executing the packages in both the environments (Development and Production).

• Managed user access and created new security accounts.

• Developed User Defined Functions and created Views.

• Performed Backup and restore of databases.

• Developed and implemented database and coding standards to improve performance of

corporate databases.

• Created the DTS Package through ETL Process to vendors in which records were

extracted from Flat file and Excel sources and loaded daily at the server. Updated the

statistics information for both the old and new servers.

• Assisted with various ad-hoc query requests.

• Involved in performance tuning to optimize SQL queries using query analyzer.

• Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server Management Studio 2005, BIDS, SSIS, Windows server 2005,

SQL Reporting Services, MS Excel, XML.

Contact this candidate