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