SUMMARY:

• 6 years of experience MS SQL Server 2005/2008 and worked extensively on MS SQL Server Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Experience in installation, up gradation and configuration of MS SQL Server database.
• Excellent understanding of all the phases of Data warehousing cycle(SDLC) .
• Experience working on Relational database management systems (SQL Server).
• Expertise in RDBMS concepts with hands on exposure in the development of relational database environment using T - SQL, Cursors, Stored Procedures, Functions,Triggers and CTE (Common table expression).
• Expertise in Performance Tuning by using Indexes, partitioning, switching partitions and by updating statistics.
• Expertise in troubleshooting high priority production issues.
• Worked with DMV(dynamic management views) and DMF( dynamic management functions) for diagnosing problems in SQL Server.
• Experience in Conceptual,logical and physical data modeling, data mapping, and data normalization.
• Experience in Dimensional data modeling using Star schema and snowflake schema.
• Experience with creating Linked Servers for connecting servers at remote site locations and then querying the group of servers using T-SQL statements.
• Experience in solving Deadlocks/Long running queries using Performance Monitorand SQL Profiler.
• Extensive experience with Monitor, tune and analyze db performance and allocate server resources to achieve optimum db performance.
• Strong experience in Development and Design of ETL methodologies using SSIS (SQL Server Integration Services) with real time exposure to business.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text based files, Excel spreadsheets to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Extensively worked on Automation of ETL processes by creating .Net utilities to create SSIS package on run time to support download and load of large number of files.
• Experience and understanding of SSAS, MDX,OLAP cube and Architecture.
• Experience in designing and managing reports using SSRS (SQL Server Reporting Services).
• Experience with Team Foundation Server (TFS) and Microsoft Visual Source Safe (VSS) .
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and Normalizations.
• Experienced in with functional and technical aspects of Data Warehouse development.
• Worked on preparing Technical Specification documents, Functional Specification documents, mapping documents for various migrations and up gradation projects.
• Experience in handling offshore and Onsite co-ordination.
• Experience in performing end to end deployment and provided technical support.
• Proven excellent communication and documentation skills and ability to work in highly challenging atmosphere.
• Ability to learn quickly and apply new skills to existing problems.
• Committed team player with multitasking capabilities.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2008/2005/2000 , MS Access

SQL Server Tools: SQL Server Management Studio,Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, Database Engine Tuning Advisor, Windows System Performance monitor, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS).

Programming Languages: VB.NET, ASP.NET.

Data Modeling Tool: MS Visio

Query languages: SQL,T-SQL

Developer IDE: Visual Studio 2005/2008

Application Software: Microsoft Office Suite

Source Control: Visual Source Safe (VSS), Source Off Site (SOS), Microsoft Team foundation Server (TFS).

Operating Systems: Windows NT 2000/2003, Windows XP/98

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, Washington

Sr. SQL Server Developer

Responsibilities:

• Extensively worked in creating SQL Procedures, functions, triggers, cursors and CTE (Common table expression).
• Created complex T-SQL queries for retrieving data.
• Extensively worked on performance tuning by creating Indexes, partitioning, switching partitions and by updating statistics.
• Used SQL Profiler to view indexes performance to mostly eliminate table scan.
• Worked on SSIS packages to perform ETL operations like Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Created ETL mapping document, which specified source-target for the dimensions and facts.
• Extensively worked on automation by creating .Net utilities to create SSIS packages at run time.
• Created SQL Jobs to call the SSIS packages and T-SQL objects in a required sequence and scheduled them for daily and weekly loads.
• Worked on building cube using SSAS and validating the data using MDX.
• Experience in designing,deploying and managing reports using SSRS.
• Created Maintainance Plans for daily backups and recreating indexes.
• Stored package configuration in XML files and SQL Tables.
• Responsible for creating Unit test plans and functional specification and review of technical specification and deliverables
• Worked on end to end deployment testing and provided technical support to testing team.
• While working at client location being responsible for requirement gathering and defining estimation for deliverables.
• Extensively worked with production support team to work on production issues during deployment or daily and weekly loads.

Environment: Windows 7,SQL Server Management Studio (SSMS) 2008/2005, Visual Studio 2005,SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)., SQL, MS Access.

Confidential, Seattle, Washington

SQL Server Developer

Responsibilities:

• Extensively worked in creating SQL Procedures, functions, triggers, cursors and CTE (Common table expression).
• Worked on complex T-SQL queries for retrieving data.
• Extensively worked on performance tuning by creating Indexes, partitioning, switching partitions and by updating statistics.
• Create ETL mapping/document, which specified source-target for the dimensions and facts.
• Worked on building cube using SSAS and validating the data using MDX.
• Created SSIS Packages to perform ETL operations like Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Stored package configuration in XML files and SQL Tables.
• Used SQL Profiler to view indexes performance to mostly eliminate table scan.
• Worked on SSAS to deliver OLAP functionality.
• Designed and implemented Parametrized Reports, Drill Down Reports using SSRS 2008.
• Responsible to review the technical specification and deliverables.
• Responsible for creating Unit test plans and functional specification.
• Responsible for handling offshore-On-site communication from offshore and requirement gathering and defining estimation for deliverables.

Environment: Windows 7,SQL Server Management Studio (SSMS) 2008/2005, Visual Studio 2005,SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)., SQL,MS Access.

Confidential, Seattle, Washington

SQL Programmer

Responsibilities:

• Worked on end to end production deployment.
• Extensively worked on production monitoring during daily and weekly load.
• Worked on production issues reported by business users within the defined SLA.
• Extensively worked to automate the daily refresh of excel reports.
• Extensively worked in creating SQL Procedures, functions, triggers, cursors and CTE (Common table expression).
• Created complex T-SQL queries for retrieving data.
• Worked on validating cubes using MDX.
• Worked on SSIS to perform ETL operations like Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Created and managed SQL Jobs to call the SSIS packages and T-SQL objects in a required sequence and scheduled them for daily and weekly loads.
• Created package configuration and stored into Environment variable and tables and updated configuration values into the production.
• Responsible for managing dashboards, scorecards and building reports using SSRS.
• Created excel reports with pivot tables based on production data for business users.
• Created reports with Bar chart and pie chart to publish the number of issues reported every week and corresponding response time.
• Responsible to work on request like taking backup, restoring database, and updating statistics to boost the performance.
• Responsible for arranging technical sessions for new and upcoming technologies and also worked on arranging knowledge transfer sessions with development teams.

Environment: Windows XP,SQL Server Management Studio (SSMS) 2008/2005, Visual Studio 2005,SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL,MS Access.