SUMMARY

• 6+ years of experience in information technology as MS SQL database developer and SSIS/SSRS/SSAS Business intelligence analyst.
• Experienced in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2008 R 2/2008/2005.
• Proficient in RDBMS Concepts, Database Management Systems (DBMS), and Database Physical and Logical design, andData Mapping.
• Expert with Dimensional Modeling, ERD Modeling, Star Schema/Snowflake Schema, Fact and Dimension tablesusing tools such as MS SQL server, MS Visio, ERwin, and MS Access.
• Good knowledge of tableNormalization and De - normalization.
• Highly experiencedin creating Tables and enforcing Referential Integrity and Constraints for RDBMS environment.
• Experience increating Views, Indexes, Stored Procedures, User Defined Functions, and Triggers using T-SQL.
• Experience in Data Warehousing and data mining techniques.
• Skilled in ETL tools like DTS, SQL Server Integration Services (SSIS) for creating packages with package configuration and scheduling.
• Experience in Analysis Services (SSAS) to create, analyze and scheduled processing dimension cubes.
• Excellent inReporting Services (SSRS)to create different drill down, drill through, cascading, parameterized etc. reports fortablix, graphs and charts.
• Experience of Business Object Web Intelligence to create query, crosstab, chart, expandable reports.
• Experience of using Excel PowerPivot tool.
• Performed administrative tasks such as replication services, datamirroring, log shipping.
• Good knowledge of modern day programming languages such as C#, VB, .NET, HTML, CSS, AJAX.
• Goal-oriented professional individual with good verbal & written Communication.
• Strong analytical, problem solving skills.
• Confident to work independently and proactive team member.

TECHNICAL SKILLS

Operating system: Windows 95/98/2000/XP/Vista/2007, UNIX.

Databases: SQL Server 2008 R 2/2008/2005/2000/7.0 , MS-Access 2007, MYSQL.

SQL Server Tools: SQL Server Management Studio (SSMS), SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), Export & Import wizard, DTS, SQL Server Profiler, SQL server configuration manager.

Reporting Tools: MS SQL Server Reporting Services (SSRS), Business Object Crystal Reports, Excel PowerPivot.

Data Modeling: ERwin,MS Visio, MS Access

Programming Languages and web technologies: T-SQL, C, C++, C#, Visual Basic, VB.net, C#.net, ASP.Net HTML, Shell Script, CSS, AJAX, IFrames, UML.

Web Servers: Apache Server 2.2.21, Windows IIS Server 2008 R2.

Other Software/tools: Visual Studio 2005/2008/2010 , WinSCP, Putty.

PROFESSIONAL EXPERIENCE

Confidential, Mavern, Pa

SQL Server Developer

Responsibilities:

• Participated in requirement gathering sessions with the client and preparation/modifying of the requirements in Requirement Specification document.
• Participated in understanding and analyzing the project requirements. Designed use cases, class diagrams, sequence diagrams, and entity relation diagram using ERwin.
• Involved in normalization of the database.
• Created tables, queries, sub-queries, functions, and stored procedures using T-SQL.
• Involved in creating DDL, DML and Logon triggers on tables, views and stored procedures.
• Created various clustered and non-clustered indexes to optimize the query performance and faster data retrieval.
• Involved in database De-normalization and creating views to reduce real time joins and improve efficiency.
• Implemented automated database backup and recovery using replication with log shipping.
• Performed Security Administration, Troubleshooting, and Database tuning.
• Created Linked Servers to connect OLE DB data sources and providers.
• Involved in creating SSIS ETL templates and ETL packages.
• Created SSIS Packages to Extract Data from MS Access, Excel, Oracle and DB2 to SQL Server 2008 R2.
• Used SSAS to create dimensional cubes.
• Designed, developed and deployed reports using SSRS.
• Participated in developing web form using grid views and master pages.
• Involved in building three tier network architectureused for presentation layer, the Business and Data Access Layers using C#.

Environment: SQL server 2008 R2, ERwin, Windows XP, SSIS, SSAS, SSRS, .NET Framework 3.5, C#.NET, ASP.NET 3.0, AJAX, HTML, CSS.

Confidential, Mobile, Al

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in requirement gathering and technical documenting process.
• Wrote complex SQL procedures for Implementing billing processes.
• Created indexes, triggers and custom functions to improve performance.
• Effectively used views to reduce real time joins and add security to database tables.
• Tuned SQL queries using execution plans for better performance.
• Involved in Migration of SQL 2005 to SQL 2008.
• Configured and managed Server Aliases and Linked Servers among multiple SQL Servers.
• Implemented Transactional Replication for data transfer between servers.
• Created complex SSIS packages for transferring and reviewing data from heterogeneous sources like (Excel, MS Access, MySQL, Postgre SQL, CSV, flat file, Text Format Data).
• Used SSRS to generate tabular, matrix, chart etc. reports.
• Designed and Developed Drilled-Down, Drilled Through,Sub-Reports using SSRS.
• Involved in Deploying and Scheduling Reports using SSRS.
• Used Business Object Web Intelligence to create filtered queries, Crosstabs, Subtotal reports, folding/unfolding reports, charts.

Environment: Windows7,Windows IIS Server 2008 R2, SQL server 2005, SQL Server 2008,T-SQL, SSMS, SSRS, SSIS, SAP Business Objects, ASP, HTML, AJAX, and CSS.

Confidential, Marietta, GA

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked directly with Clients for gathering details.
• Involved in creating snow flake schema with facts and dimensions tables.
• Extensively used SSIS Import/Export Wizard, for performing the extraction operations from flat files, excel-sheets and other databases.
• Involved in writing Views and Complex Stored Procedures to meet the requirements.
• Involved in data cleansing using various data transformation techniques and automated some of the export through SQL Agent Jobs.
• Enhanced SSIS packages for better performance of the jobs.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Different reports developed by using existing Table, Matrix controls, Chart and also used formulas, functional coding.
• Developed Sub report, Cross tab and Drill Down reports.
• Developed different Column, bar, line and Pie charts.
• Involved in Schedule Jobs to export the reports in the form of Excel (.xls) and web archive (.html) formats.
• Provided Documentation support on SSRS 2005 as assigned.

Environment: Windows XP, SQL server2005,T-SQL, SSMS, SSRS, SSIS, ASP, HTML and CSS.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with clients to gather Requirements and produced technical documentation.
• Involved in developing logical relation database ERD using ERwin.
• Installed, Updated, Configured and Maintained the MS SQL Server environment.
• Created tables normalized to 3rd NF and enforced referential integrity and constraints.
• Defined views, indexes, functions, andstored procedures.
• Addedsecurity by implementing role based access control (RBAC) using SQL Server.
• Wrote complex T-SQL sub-queries for the retrieval of the required data using various joins.
• Involved in database replication using mirroring.
• Involved in database tuning and performance optimizing.
• Developed packages with Data import and export using DTS packages.
• Involved in data cleansing, conversions, transformation and loading.

Environment: SQL server 2005, ERwin, Windows XP, DTS, T-SQL, DTS.

Confidential

Entry Level SQL Server Developer

Responsibilities:

• Installed and configured SQL Server 2000 Servers.
• Involved in requirement gathering and planning processes.
• Created a logical design and physical design of the database tables.
• Wrote stored procedures, functions and created triggers, cursors.
• Created Views and indexes to improve frequent query performances.
• Maintained security and data integrity of the database
• Participated in database tuning, and query optimization.
• Performed database backups to external drives.

Environment: SQL server 2005,TSQL, Microsoft Visio, Microsoft Office XP,SQL Query Analyzer, SQL Profiler, Windows XP.