SQL Server Developer Resume Profile

Professional summary:

Experience

Over three years of professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2012/2008R2/2008/2005.
Ability to deliver comprehensive Business Intelligence through integration of BI suite of products SSIS, SSRS including MS solutions like MS EXCEL 2007/2010, Microsoft Office.
Strong Experience in various Extracting, Transforming and Loading ETL/SSIS data flow ETL/SSIS using SSIS.
Excellent in writing T-SQL, working on DTS, SSIS, SSRS, also created Indexed Views, complex Stored Procedures, Triggers, and effective functions.
Highly Proficient in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts.
Experience in report writing using SQL Server Reporting Services SSRS and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
In depth understanding of SQL Server Migrations and problem management.
Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
Having excellent communication skills, analytical skills, and understanding of business requirements in various domains.

TECHNICAL EXPERTISE: MSSQLServer2012/2008R2/2008/2005,SSRS, SSIS, MS-Access 2000, MS Excel, Erwin, Crystal Report , Oracle, T-SQL, PL/SQL, HTML, XML, VB Script, C, Windows NT/ 2000 Server/XP

PROJECT EXPERIENCE:

Confidential

SQL Server Developer

Worked with business, application developers, production teams and across functional units to identify business needs and discuss solution options.
Participates actively in all phases of system development including planning and analysis, design, development, and testing.
Deliver Business Model, logical and physical data models using Erwin and also responsible for Forward Engineering in Data Modeling, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
Pushed all the created store procedures and functions to the development, training and production servers.
Maintains application performance and scalability with a focus on performance tuning SQL queries, table design, indexing, query plan analysis.
Created trace in SQL Profiler and used Database Engine Tuning Advisor DTA for Performance tuning on stored procedures and Scripts.
Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
Migrated data from different sources text based files, Excel spreadsheets, and Access to SQL Server databases using SQL Server Integration Services SSIS .
Worked with Tabular reports, Matrix reports ,Parameterized reports, Sub reports, Drill down reports according to business requirements in time restricted environment using SQL server reporting services SSRS 2008.
Provide support to BA/SA/QA teams to verify data and provide data profiling related analysis.
Work with the QA team to create SQL based queries to validate data and provide support.
Communicate effectively both in writing and verbally.

Environment: MS SQL Server 2008, MS SSRS 2008, MS SSIS 2008, T-SQL, Windows Server 2007, Erwin 8.0

Confidential

SQL Server Developer/.NET Developer

Developed the functional specifications from the business requirements.
Analysis and design of databases and user interfaces.
Designed the front-end navigation and user authorization system.
Designed the GUI using .NET.
Developed complex T-SQL code for the application.
Designed and implemented processes for deploying, upgrading, managing and extracting data for reporting.
Tested to optimize the Stored Procedures and Triggers to be used.
Monitored performance and optimized SQL queries for maximum efficiency.
Developed ADO.NET code to access the database for different SQL queries, views and procedure.
Developed daily reports using Crystal Report
Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
Planned Backup strategy based on projects requirements.

Environment: ASP.NET, VB.NET, Web Forms, PL/SQL, ADO.NET, IIS, XML, XSLT,

Visual Studio 2003,2008, SQL SERVER 2005, Windows 2000, HTML.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship