SUMMARY

• 7+ years of experience in analysis, design and implementation in translating the business requirements into the SQL Server 2000 and SQL Server 2005 database management system as a SQL Server developer.
• Extensive knowledge in data modeling and database architecture based on functional requirement of the system.
• Experienced in OLTP/OLAP environment with SQL Server.
• Experienced in Migration from SQL Server 2008 to SQL Server 20 .
• Experienced in designing and developing reports in SQL Server Reporting Services by gathering business requirements and translating them into technical specification and creating reports with respect to business requirement.
• Expert in writing advanced T - SQL queries (DDL, DML).
• Proficient in implementing business crucial logic and implementing them in backend using efficient stored procedures and functions.
• Experienced in strategically implementing the indexes such as Clustered index, Non-Clustered index, Covering index appropriately on data structure to achieve faster data retrieval.
• Extensive knowledge in database maintenance and SQL Server optimization using SQL tools such as SQL Profiler, Index Tuning Wizard, DBCC commands, Statistics.
• Experienced in importing and exporting the data between homogenous and heterogeneous systems using various Extraction Transformation and Loading (ETL).
• SQL tools such as DTS, SSIS, Bulk Copy, Bulk Insert.
• Excellent in developing OLAP cube by using MSSQL 2005 Analysis Services.
• Highly motivated and possess ability to think, to analyze and to communicate with users and discuss their data, application and project requirement in a team environment.

TECHNICAL SKILLS

Database Management System: MSSQL Server 2012/2008r2/2008/2005, MS-Access

Database Utilities: Enterprise Manager, Query Analyzer, SQL Server Profiler, SQL Server Management Studio

ETL tools: Data Transformation Services(DTS),SQL Server Integration Services(SSIS)

Analysis Services: MSSQL Server Analysis Services

Reporting Tools: MSSQL Server Reporting Services, Crystal Reports

Data Modeling Tools: Visio 8.0

Programming Language: TSQL, C, C++, Visual Basic.Net, ASP.NET, HTML, VB script

Application Packages: MSOffice

Operating Systems: Windows 9x/Windows 2000/Windows NT/Windows Server 2003/Windows XP.

PROFESSIONAL EXPERIENCE

Confidential, MN

SQL Developer/DBA

Responsibilities:

• Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel, AS/400 and SQL Server 2012 using SSIS.
• Developed reports using SSRS 2012. Used table control, matrix control for cross tab reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Created various reports using SQL Server 2012 Reporting Services.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers
• Loaded stored procedures and user defined functions implemented by developer teams into the databases.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries and Stored Procedures.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2012 using SSIS, BCP and Bulk Insert.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
• Planned and co-coordinated database security measures.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes

Environment: SQL Server 2012(SQL Server Management Studio, Query Analyzer,SQL Profiler, Index Tuning Wizard, SQL Server Integration Services (SSIS), MSSQL Server2005 Analysis Server),MS-Reporting Services, XML, ASP.Net, VB Script.

Confidential, MO

SQL Developer/DBA

Responsibilities:

• Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS.
• Successfully migrated data between different heterogenous sources such as flat file, Excel and SQL Server 2008r2 using SSIS, BCP and Bulk Insert.
• Developed reports using SSRS 2008r2. Used table control, matrix control for cross tab reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• We handled lo t of production issues like data correction and resolves error handling
• Checked the configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Loaded stored procedures and user defined functions implemented by developer teams into the databases.
• Configured the new servers using failover clustering and SAN technology.
• Installed the SQL Server 2008r2 on the new servers and applied Service Pack 2
• Migration of all the databases from old servers to new servers to test for a month.
• Convert DTS packages to SSIS packages
• Generated test data and tested new databases consistency with existing databases to meet the functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
• Planned and co-coordinated database security measures.
• Writing and testing stored procedures

Environment: SQL Server 2008r2 Enterprise, Windows Enterprise Server 2003, Server 2004, IIS 6.0, .XML, Microsoft Visio 2006, SFTP, SQL Server Reporting services (SSRS), JAVA,J2EE

Confidential, MO

SQL Server developer /DBA

Responsibilities:

• Actively involved in the complete software development life cycle for a design of database for new Financial Accounting System.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Created various reports using SQL Server 2008 Reporting Services.
• Converted logical database design into Physical Schema using either 2nd or 3rd Normalization to obtain highest performance.
• Successfully implemented the physical design of the new designed database into MSSQL Server 2008.
• Used MS SQL Server 2008 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, data center services, system events support and billing.
• Efficient Stored Procedures and effective functions were written to handle major business crucial calculations.
• Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries and Stored Procedures.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Created Linked Server for load balancing and increasing performance of the Data warehouse.
• Created necessary triggers on tables to ensure data and referential integrity incorporating business logic.
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multidimensional views for data analysis.
• Defined Check constraints, rules, indexes and views based on the business requirements.
• Documented all the procedures involved in the database for future reference.
• Managed the historical data in the data warehouse from various data sources.

Environment: SQL Server 2008(SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SQL Server Integration Services (SSIS), MSSQL Server2008 Analysis Server),MS-Reporting Services, XML, ASP.Net, VB Script, JAVAJ2EE.

Confidential, TX

SQL Developer/DBA

Responsibilities:

• Actively involved in analyzing the old database system and mapping tables, relationships, columns to SQL Server 2008.
• Efficiently worked in installation, configuration, design, implementation of staging database for data migration and data entry.
• Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS, BCP in staging database from MS Access, Sybase, excel.
• Assisted in designing and creating website utilizing ASP.Net technologies for the system using ADO.Net, HTML, XML in designing form, validating inputs and connecting to backend database.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Improved data load performance by analyzing database design and query plans.
• Performed Changes in the Schema of the proposed database as required and informed those changes to the application development team.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into Staging Area.
• Documented different Stages of data transformation, procedures and scripts.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Used Crystal Reports v 8.0 to create drill down reports.
• Created Reports using SQL Server 2008 Reporting Services using Microsoft Visual Studio 2003.

Environment: SQL Server 2000(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server), Crystal Reports 8.0, XML, ASP.Net, VB Script.

Confidential

SQL Developer/DBA

Responsibilities:

• Actively involved with the front end .net developers as a part of a team for gathering and analyzing the needs of User Requirement.
• Modified existing database to fit new business requirement by adding tables and relationships to support Customer Information System.
• Created efficient Stored Procedure and functions which implement necessary business logic to support the front end application.
• Created indexed view to optimize query performance by facilitating easy user interface implementation.
• Created linked server for load balancing and increasing the performance of the Database.
• Created instead of trigger on indexed view to facilitate consistent data entry into the database Used SQL reporting services.
• Optimized the query performance by removing unnecessary columns, redundant and inconsistent data. Query performance was improved by normalizing tables, establishing necessary joins and creating useful indexes wherever necessary.
• Worked on Client/Server tools such as SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance planner for the performance of SQL Server, which includes Database Integrity Checks, Update Database Statistics and Re-index the fragmented indexes.
• Created DTS packages to migrate data from various sources to the SQL Server 2005.
• Created and maintained Users/Logins.
• Optimized database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Created Reports using SQL Server 2005 Reporting Services using Microsoft Visual Studio 2003

Environment: MSSQL Server 2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS),2005 Reporting services ASP.Net, VB.Net, VB Script.