SUMMARY:

• SQL Server Developer with Seven years of IT experience in development, analysis, design, testing, presentation and implementation experience using SQL Server 2008/2005/2000.
• Involved in all the stages of Software Development Life Cycle including Requirements, Analysis and Design, implementation, integration and testing, deployment and maintenance.
• Hands on experience in installing, configuring, managing, monitoring SQL Server 2008/2005/2000
• Good Knowledge in T - SQL
• Creation such as Tables, Views, User Created Data Types, Indexes, Stored Procedures, Cursors, Triggers and more.
• Experience in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Experience in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and DTS.
• Experience in using Dynamic SQL and TOAD.
• Understanding of various source transformations, including flat files, XML and relational systems.
• Review, analysis, and modification of programming systems including encoding, testing, debugging and installing to support an organization's client/server software applications.
• Worked to establish connectivity between VB, ASP application servers by using ODBC.
• Maintain existing code and fix bugs whenever needed.
• Experience in Designing Star Schema and Snowflake Schema in implementing Decision Support Systems.
• Extensively worked on Data extraction using the Microsoft DTS/SQL Server integration services.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail.
• Extensive knowledge in Tuning SQL queries & improving the performance of the Database.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility and SSIS.
• Experience in creating new databases logical and physical designs to fit new business requirement and implemented new design using CA Erwin data modeler.
• Experience with version control systems like Microsoft Visual Source Safe (VSS).
• Strong debugging skills and the ability to solve complex problems.
• Adaptable, passionate and project oriented team player with sound communication and leadership skills to develop inventive solution for demanding client needs.
• Good team player with strong analytical skills.

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008 Oracle7/8i/9i, MS Access.

Business Intelligence & ETL Tools: SQL Server 2005 Business Intelligence Development Studio Bulk Copy Program (BCP), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and SQL Server Management Studio.

Workflow Tools: MS-Visio, MS-Excel, MS-Word, MS - PowerPoint, MS-FrontPage.

OLAP Tools: MS OLAP Services Manager.

Languages: C, C++, SQL, T-SQL, XML, HTML, DHTML.

Web services: SOAP, VSS.

Web Servers: IIS 5.0/6.0/7.0.

PROFESSIONAL EXPERIENCE:

Confidential, VA

SQL Server Developer

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2005 service to SQL Server 2008 with latest service pack.
• Created partition table for very large database for good performance.
• Hands on experience with DTS/SSIS, Reporting and Analysis Services in 2008/2005.
• Analyzing workloads and their response time.
• Migration of DTS to SQL Server Integration Service (SSIS).
• Created database objects like tables, views, indexes, stored-procedures, triggers and cursors.
• Writing Stored Procedures for report generation.
• Developed various Reports using SQL Server Reporting servecies.The Reports involved Matrix, Group Above with complex queries in Data Model, Complex Layouts, Used the functionality of Additional Default Layout, Parameters, Program Units, the use of Report Triggers and Used Anchors for vertical and horizontal positioning of objects
• Knowledge of Reporting Services 2008/2005 API.
• SQL performance tuning.
• Resolving locking and blocking issues.
• Created Data Warehouse Cubes in SQL Server Analysis Services (SSAS)
• Created indexes on the tables for the better performance.
• Rebuilding indexes on various tables.
• Knowledge in Extended Stored Procedure.
• Worked as a team member for 24X7 on call production support.
• Implementing Database Stored Procedures, Joining Local and Remote tables, Updating Data in Transactions.
• Maintaining both Development and Production servers in sync.
• Setting up SQL Database Mirroring on the development server.
• Maintaining reliability and availability of existing MS SQL environments.
• Designing/ Implementing Backup policies for databases.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Created SSIS Packages for data Export/Import.
• Implement SQL Server Log Shipping on the Development Server.
• Creating documentation for error resolving fixtures.

Environment:Microsoft Windos Server 2003, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft Visual Studio, Hardware: HP Proliant 8000 with eight-way 900 MHz Xenon Processors and 16 GB of RAM, HP Storage work Enterprise Virtual Array(EVA) fiber-optic SAN.

Confidential, Dallas, TX

SQL Server /SSRS/SSIS Developer

Responsibilities:

• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Involved in database design physical and logical database structure.
• Generated and debugged complex stored procedures and functions for better performance and flexibility.
• Maintained the physical database by monitoringperformance, integrityandoptimizeSQL queries for maximum efficiency using SQL Profiler.
• Scheduled and maintained routine jobs and alerts.
• Performed performance tuning by studying execution plan, analyzing indexes and using SQL Profiler.
• Create databasemaintenance plansfor the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Worked onException Handlingwith Try/catch
• Developed data access layer using ADO.NET components.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Developed complex stored procedures and functions to create various reports.
• Generated, modified and published reports using SQL Server Services.
• Specialist in writing Multi Dimensional Expressions (MDX) and creating OLAP cubes.
• Responsible forETL operationusingSQL Server Integration Services ( SSIS).
• Involved withSSISfor sending and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data)
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Configured IIS and Deployed Reports and Analysis Project in to server.
• Create a Package to update the data warehouse database using SSIS.

Environment: Visual Studio 2005, SQL Server Management Studio, SQL, SQL Server Reporting Services(SSRS), T-SQL Stored Procedures, SQL Server integration services (SSIS), Office, Excel.

Confidential, Columbus, GA

SQL Server Developer

Responsibilities:

• Involved in various stages like development, system Analysis, design, and creating stored Procedures.
• Involved in upgrading the instance of development environment of SQL Server 2000 to SQL Server 2005.
• Migration of DTS to SQL Server Integration Service (SSIS).
• Designing/ Implementing Backup policies for databases.
• Created DDL/DML triggers in SQL Server 2005/2000
• Creating, maintaining the users, roles and granting privileges.
• Rebuilding indexes on various tables.
• Designed Dimensional Database using SSAS.
• Wrote SQL stored procedures to implement business logic.
• Optimized the performance of queries with modifications in T-SQL queries.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services Planned and modified the permission issues in the server.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Writing stored procedure and SQL Queries.
• Created database objects like tables, views, indexes, stored-procedures, triggers and cursors.
• Designing the Logical and Physical databases and development of SQL Server Database.
• Database testing, maintaining the data and writing the procedures.
• Fine tuning the Database Settings as well as the Server Settings.
• Created Sub-Reports, Drilldown-Reports, Summary reports, Cross Tab reports.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.

Environment: MS SQL Server 2000 & 2005, Windows 2003 Server Enterprise & Web Edition, IIS Server 5.0, Reporting Services, XML,, Visual studio .NET, HP Proliant DL 360 G3 for web servers, HP proliant DL 580 G2 for database servers.

Confidential, San Antonio, Texas

SQL Server Developer

Responsibilities:

• Created new tables, stored procedures for Application Developers and some user defined functions
• Created SQL scripts for tuning and scheduling
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Maintained tables, Primary Key Foreign Key Relationship, check Constraints, Schema Changes.
• Configured Server for sending automatic mails to the respective personnel when a DTS process failed or succeeded.
• Worked on DTS Package, DTS (Import/Export)t for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Performed development support, document reviews, test plan, integration of the system.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Creation/Deletion of Linked Servers.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access)
• Worked with crystal report for report generation.
• Preparing Report for the day to day as well as weekly/monthly purposes.

Environment: SQL Server 2000 Enterprise Edition, Crystal Reports, VB Script, XML, DTS, MS PowerPoint, MS Access 2000, MS excel & Windows Server 2000.

Confidential

Business Analyst

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements
• Developed and pruned the artifact repository and templates to conform the RUP standards
• Extracted the Business Requirements during various sessions with business leads and entered all requirements in Requisite Pro, tracing them all the way to the stakeholder requirements
• Created Business Process Flows across the capability
• Decomposed high-level requirements into a detail functional design specification
• Instrumental in writing the business and system Vision documents, business and System Use Cases, Supplementary Specifications and extracting Stakeholder requirements
• Conducted JAD sessions with extensive involvement from business, development, testing teams, architects, SME’s (Subject Matter Experts) of various business units
• Conducted project related presentations and provided reports to the higher management
• Involved in Defect Management process
• Recognized for excellent ability to multi-task on projects consisting of diverse set of people, platforms and parallel timelines via exceptional communication, organizational and interpersonal skills

Environment: SQL Server 2000 Enterprise Edition, Crystal Reports, VB Script, XML, DTS, MS PowerPoint, MS Access 2000, MS excel & Windows Server 2000.

Confidential

Programmer/Tester

Responsibilities:

• System Analysis & Study, development, coding, debugging and testing.
• Used VB 5.0 to design and develop the User Interface module and SQL Server 6.5 as Database Server.
• Created ActiveX DLLs for listing data items, connecting data sources and validating data fields.
• Crystal Reports 5.0 is used to generate reports.
• Preparing test cases and enhancing the application.
• Used 3rdparty tool Sheridan Controls.

Environment:VISUAL BASIC 5.0 with ACCESS 97