SQL Server Developer Resume

SUMMARY

Around 3 years of IT Experience in SQL Server Database, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments.
Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
Excellent in Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T - SQL.
Great ability to create and manage various database objects like tables, views.
Worked Extensively on ETL process using SSIS package.
Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.
Experience in Performance Tuning and Query Optimization.
Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
Strong communication skills; Good at team work and cooperate well with team members with excellent analytical skill and problem solving abilities.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Profiler, Export & Import (DTS), SSIS, SSRS.

RDBMS: MS SQL Server 2000/2005/2008/2014 , MS Access,Teradata,Oracle.

Languages: Transact SQL, C, Visual Basic 6.0

Operating Systems: Windows95/98, Windows2000/NT/XP, MS DOS.

Reporting Tools: SSRS.

Other tools: Microsoft Visual Studio 2005 and MS Office.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Developer

Responsibilities:

Worked as a developer on databases like MS SQL Server 2000, MS Access.
Created Database Objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
Involved in Creation of Dimensions using Star and Snow Flake Schema.
Monitored performance and optimized SQL queries for maximum efficiency.
Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
Used Lookups Transformation to get the data from reference data sets.
Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
Creating Reports as per user requirements using MS Reporting Services 2000/2005
Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
Involved in Creation of Dimensions using Star and Snow Flake Schema.
Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
Maintained the consistency of the client’s Database using DBCC.

Environment: MS SQL Server 2008/2014, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential

Jr.SQL Server Developer

Responsibilities:

Creation, manipulation and supporting the SQL Server databases.
Involved in the Data modeling, Physical and Logical Design of Database.
Created tables, indexes, sequences, constraints, triggers and procedures.
Stored procedures and triggers were used to implement business rules.
Helped in integration of the front end with the SQL Server backend.
Used DDL and DML for writing triggers, stored procedures, and data manipulation.
Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
Created documentation as required.

Environment: MS SQL Server 2000, T-SQL, DTS.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship