SUMMARY

• Overall 15+ years of IT experience and around 7+ years of experience in SQL Server Suite of products (SSIS and SSRS) with business analysis and involved in all phases of Software Development life cycle from gathering requirement, development, implementation, testing and support with Government. Quick learner and Good Performer both in team and independent job environments.
• Experience in development of conceptual and logical data model for OLTP systems
• Experience in Sub - queries, CTE’s (common table expressions) and Physical Temp Tables.
• Experience in creating Tables, Views, Indexes, Stored Procedures, Inner and Outer joins, Triggers, Except Clause using T-SQL (DML and DDL) as well as analyzing and debugging existing stored procedures. Hands on using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).
• Experience in using Query Execution Plan to solve long running queries.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience is object oriented design (OOD) and object orientated programming (OOP) methodologies

TECHNICAL SKILLS

Relational Databases: SQL SERVER / R2, MS Access, Oracle, DB2

Database Tools / Technologies: ADO.Net, SQL Server Integration Services, Data Transformation Services (DTS), SQL Server Analysis Services, SQL Server Reporting Services, SQL Profiler, Database Engine Tuning Advisor, OLAP (Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio)

Development Skills: T-SQL, SSIS / SSRS / SSAS, ASP.Net

Programming Languages: T-SQL, C#, C, HTML, Javascript, XML OOD, PL/SQL

Reporting Packages: SQL Server Reporting Services (SSRS), Crystal reports, MS Excel

Methodologies / Tools: MS Visio, Physical & logical data modeling, FACT & Dimensions tables, Star Schema / Snowflake Schema modeling, MS Visual Studio 2010/2012, MS Visual Source Safe, MS Project, MS Office Suite, Sharepoint, Toad for Oracle, ERWin

Operating Systems: Windows NT / / 2008 Server, Windows XP / 7 / 8

PROFESSIONAL EXPERIENCE

Sr. SQL Server Developer

Confidential, Washington, DC

Responsibilities:

• Developed report specifications, created and modified reports using SSRS 2008.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Actively involved in Normalization (3NF) of database.
• Created and maintained indexes, views, triggers, functions, T-SQL queries, stored procedures, agent jobs, schedules, and automated scripts. Hands on using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Facilitated user meetings and determined user / business / functional requirements.
• Wrote user guides, technical documents, SoPs, and provided training support, implementation and post implementation services.
• Investigated and proposed recommendations for resolution of business and software issues.
• Identified multiple application modernization opportunities / projects to improve system performance, staff efficiency, funding analysis and reporting
• Developed conceptual and logical data model for OLTP systems
• Designed, developed, tested and deployed web-application using C#, .NET framework and SQL Server.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, Visual Studio 2010, VSS, MS Visio, Windows NT/2003, ASP.NET, .NET framework, T-SQL, C#, MS Access, Oracle, PL/SQL

SQL Server Developer

Confidential, Washington, DC

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers.
• Planned, defined and designed data based on the business requirement.
• Designed, Developed and Deployed reports inMS SQL Serverenvironment usingSSRS-2005
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Developed stored procedures and triggers in T-SQL.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Converted all existing DTS packages of MS SQL 2000 to SSIS - 2005
• Maintained OLAP Cubes from the integrated data and generated reports on those cubes.

Environment: SQL Server, XML, MS Access, MS Visio, VSAM.