SQL Server Developer Resume Maryland - Hire IT People

SUMMARY:

Microsoft certified professional with great analytical skills and 5+ years’ experience in database design and development on SQL Server.
Self - motivated and team player with a passion for technology accompanied by special interest and expertise in relational databases.

TECHNICAL SKILLS:

Database Technologies: SQL Server 2005/2008/R2/2012, T-SQL, SSRS, SSIS, SQL Server Profiler

Servers: Windows 2003 R2 /2008/2008 R2 / 2012

Languages: C++, Java, PHP

Platforms: Microsoft SQL Server Management Studio, Microsoft Visual Studio

Other Technologies: CSS, JavaScript, HTML, .NET Framework

PROFESSIONAL EXPERIENCE:

Confidential, Maryland

SQL Server Developer

Responsibilities:

Worked with T- SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.
Created drill down and drill through SQL server reports in 2008 R2, 2012 edition.
Created Ad-hoc reports as needed and carry out report projects as required.
Meet with Executive and Department leadership to discuss reporting needs and provide support as needed.
For better Performance created indexes on regular intervals .
Created stored procedures for maintaining history data to load data on daily basis and create reports.
Responsible for the designing of advance SQL queries, Stored Procedure, cursor, triggers
Developed user documentation for all the projects.
Experience in improving performance of SQL server using tools like SQL Server Management Studio, SQL Server Profiler, and Database Engine Tuning Advisor.
Export & Import data from Flat file, Excel sheets and access database into the target SQL Server 2012 database using SSIS packages.

Environment: SSIS, SSRS, MS SQL Server 2012/2008R2, C#, Visual studio 2008, MS Office (Excel, Access…)

Confidential

SQL Server Developer

Responsibilities:

Involved in databases design requirements, and developments.
Maintained, update and monitor the existing database on a daily basis.
Created stored procedures, views, tables, and triggers
Troubleshoot all kinds of database related issues.
Assisted in data compilation, consolidation and conversion tasks when needed.
Coordinated with the management to discuss business needs and designed database solutions accordingly.
Rebuilt the indexes for better performance as needed.
Performed BULK INSERT, Imported and Exported data from different Data Sources using SSIS
Configured and maintained Report Manager and report server for SSRS
Developed reports using SQL Server Reporting Services and Utilizing complex SQL queries and stored procedures.
Wrote complex stored procedures to process customer’s requirement.
Implemented cursors and while loops to address some of the product requirements.
Implemented extensive error handling techniques into stored procedures
Monitored SQL server performance using profiler to boost performance
Worked very closely with Customers, End users and powered users to collect requirements, to train them or to resolve any business process related issues.

Environment: MS SQL Server 2008/R2, SSRS, SSIS, .Net, Visual studio 2008, MS Access, MS Excel

Confidential

Database Developer

Responsibilities:

Responsible in creating Stored Procedures, views, tables, and triggers
Maintain, update and monitor the existing database on daily basis.
Involved in databases design requirements, and developments.
Created SQL server reports against RDBMS.
Coordinated with the management to discuss business needs and designed database solutions accordingly.
Wrote complex views, stored procedures, Sub-queries, other SQL joins and statements for applications using T-SQL.
Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
Excellent understanding of Relational Database Systems (RDBMS), Normalization
Extensively used SSIS Import/Export Wizard for performing the ETL operations
Experience in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform rollup and drill down operations in SSRS 2008/R2