SUMMARY:

• Over 7+ years of experience in Database design and development in SQL 2014/2012/2008 R2 in production and support environment.
• Experience in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Experienced in implementing business logic using objects like tables, views, Cursors, stored procedures, roles, triggers and constraints using Data Definition Language (DDL) and Data Manipulation Language (DML) concepts.
• Strong knowledge of Relational Database Management Systems (RDBMS) concept in several databases like SQL Server 2008 R2/ 2012/2014 and Oracle 11g/10g/9i.
• Experienced in designing reports including sub reports with complex logic using SQL Server Reporting Services (SSRS)
• Proficient in Designing and Documentation of SQL Server Strategies and plans
• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation using Water fall model and Agile methodology.
• Generated MS Data Reports using SSRS Reporting tools.
• Strong experience in data transfer from Oracle, Sybase 15.7 and MS Access to MS SQL Server 2008 R2 using ETL tools like SSIS and MS DTS.
• Worked in Health Care domain with FACETS 4.51 version.
• Provided 24x7 support and trouble shoot production issues on high availability systems.
• Excellent team player and efficient in handling multiple project priorities with outstanding communication, presentation.
• Thorough Knowledge of Relational Database Management systems.
• Monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views
• Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.
• Has strong Object Oriented Analysis, design and programming technical skills, ability to learn new emerging technologies and adapt quickly.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Created, Built and deployed SSIS Packages by using BIDS Packages to pull data from Access, Excel and Flat files to SQL Server .
• Developed Parameterized, Drill - down, Drill-through, Sub-Reports and Charts in SSRS.
• Uploaded reports on to the report manager and organized them into folders.
• Created annual, seasonal and monthly reports of sales using Report Parameters in SSRS.
• Enhanced existing reports as needed by the client.
• Alter the schema for the required objects.
• Created Indexes on tables for new database to faster retrieval of data for the Reports.
• Tested code in T-SQL and SSIS Packages in the testing environment
• Actively participated in gathering User Requirement and System Specification

Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), TSQL, Windows XP, Microsoft Office, Microsoft Outlook, Microsoft Excel

SQL Developer

Responsibilities:

• Captured requirements from Business & Systems Analysts and business users, documenting them as detailed statements and requirements
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Documented and updated bugs/defects along with workaround solutions using Quality Center.
• Optimized SQL queries for efficiency and the front end developer with their queries and procedures.
• Configured Server for sending automatic mails to the respective people when a job is failed or succeed.
• Alter the schema for the required objects
• Created views to restrict access to data in a table for security
• Created Indexes on tables for new database to faster retrieval of data for the Reports.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), TSQL, Windows XP, Microsoft Office, Microsoft Outlook, Visual Source Safe, Quality Center,Team foundation server

SQL Developer

Responsibilities:

• Created numerous simple to complex queries involving self joins, correlated sub-queries, functions, cursors, dynamic T-SQL.
• Written Stored Procedures to display the data in front end application.
• Utilized T-SQL on a daily basis in creating customs view for data and business analysis.
• Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
• Optimize existing T-SQL code.
• Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
• Analyzed Execution Plans to troubleshoot potential performance issues.
• Customized script utilizing expressions and VB scripting to enhance tasks in SSIS.
• Created and maintained SSIS packages designed for replication of data.
• Used the SQL Server Profiler tool to monitor the performance of SQL Server - particularly to analyze the performance of the stored procedures.
• Design high availability solutions and implemented database mirroring and replication for the data security.
• Evaluated the physical model and employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers.
• Assist in Unit Testing on different scopes of Data Architecture

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

SQL Developer

Responsibilities:

• Understanding and articulating requirements from user interviews and then convert them into Business Process documents to develop and maintain applications.
• Developed tables, Views, Stored Procedures and Triggers using SQL Server Management Studio
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Extensively used Joins and Sub-Queries to simplify Complex Queries involving multiple tables.
• Fully utilized the Software Development Life Cycle processes including requirements gathering, design, implementation, quality and deployment.
• Tuned SQL to reduce the runtime and increase performance & efficiency
• Implemented Constraints on tables
• Created Indexes to speed up the queries

Environment: MS SQL Server 2008 R2, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler

SQL Developer

Responsibilities:

• Involved in Requirement gathering - Solution design
• Actively Invovled in Normalisation of Database
• Designed DDL and DML for MS SQL Server
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimize query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL
• Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Install and Configured SQL Server 2000 on development server for designing and testing.

Environment: MS SQL Server 2005, T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler