SUMMARY

• SIX years of experience in analysis, design and implementation in translating the business requirements into the SQL Server 2000, SQL Server 2005, and SQL Server 2008 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 Migration from SQL Server 2008 to SQL Server 2012, 2005 to 2008.
• 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 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 systems using various Extraction Transformation and Loading (ETL). SQL tools such as DTS, SSIS, Bulk Copy, and Bulk Insert).
• 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/2008r 2/2008/2005.

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++, Java.

Application Packages: MSOffice.

Operating Systems: Windows 7(X64)/Windows 2000/ Windows Server 2003 /Windows XP.

PROFESSIONAL EXPERIENCE

Confidential, Beaverton, OR

SQL Server Developer

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, Minneapolis, MN

SQL Developer

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 heterogeneous 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, Concord, CA

MS SQL Server DBA

Responsibilities:

• Responsible for Database support, troubleshooting, planning and migration. Resource planning and coordination for application migrations with project managers, application and Web app teams.
• Project involved guidance and adherence to standardized procedures for planned data center consolidation for worldwide centers using in-house corporate and third party applications based on SQL 2008 in upgrade project to SQL 2012.
• Monitoring of database size and disk space in Production, Staging & Development environments conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration.
• Security and architectural planning issues met as well as testing and training. Performed installation of SQL Enterprise 2012 64bit version on Windows 2008 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity. Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
• Design, deployment and control MS SQL 2012 at VMware environment. Working with Oil Traders to ensure all the trading systems are running through Linux, UNIX and IBM Aix. Configured Database mail, linked servers in SQL server 2012.
• Installing, Configuring and maintaining Lite Speed for SQL Servers for backups & Restores. Developing SSIS packages to migrate data from OLTP to OLAP servers. Created monitoring scripts to alert for blocking, dead locks, SQL agent job failures, backups etc.
• Working with SCOM to monitor server across all the domains. Maintaining databases as per SOX standards and generating different kinds of SOX reports for auditors.

Environment: SQL Server 2012/2008/R2/2008/2005, Windows 2008 server, Windows Server 2008(x64), Windows Cluster Server, BIDS 2005/2008/R2, SQL Server Management Studio, Query Analyzer, SQL Profiler, Performance Monitor, SSIS, SSRS, Remedy, VMware Lite Speed, TSQL, BCP, Data Compression, Partitioning, SAN, Active Directory, ODBC.

Confidential, St. Lois, 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, Lake way, 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.