PROFESSIONAL SUMMARY:

• Over 10+ years of experience in IT industry which includes 8+ years of experience in Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2012/2008/2005.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Excellent experience in SQL Server Programming (T-SQL), Integration services (SSIS), Analysis Services (SSAS), Notification Services and Reporting services (SSRS) in SQL 2005/2008R2/2012.
• Proficient in SQL Server and T-SQL in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Excellent experience in maintaining Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Excellent experience in developing stylish Drill Down, Cascading, Drill through, Parameterized, Sub reports and Charts using Global Variables, Expressions and Functions using SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Developed Cubes using SQL Analysis Services (SSAS).
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

Operating Systems: Windows 2003 Enterprise Server, XP, 2000, 2008, 2012, Windows XP Professional, UNIX, Linux

Web Servers: IIS, Tomcat and Apache

Programming skills: C, C++, HTML, JavaScript, T-SQL, PL/SQL, Java, C#, ASP, ASP.NET, VB.NET, XML, MDX

Databases: MS SQL Server 2000/2005/2008/2012/2014, Oracle 8i/ 9i, 10g/11g

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS)(SSAS), (SSRS), Import Export Data, Bulk Copy Program (BCP), Talend Open Studio

Tools: Used:: SQL Enterprise Manager, SQL Server, Management Studio, SQL SERVER Profiler, Query Analyzer, Database Engine Tuning Advisor, SQL, Prompt, Team Viewer, VNC, Power DesignerSpy Schema.

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

SQL/BI DEVELOPER

Responsibilities:

• T-SQL development in database object creation and data manipulation with Tables and Views, User Defined functions, Indexes, Stored Procedures, CTE, Constraints and Triggers.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2014 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Restructuring existing data structures to increase performance.
• Processing analyses and design throughout the database implementation.
• Transformed data from one server to other servers using SQL Server Integration Services(SSIS).
• Developed data visualization reports and built dashboards using MicrosoftPowerBI to translate data into visual representations.
• Designed and modified existing packages accordingly by using the transformation tasks such as Lookup, derived column, condition split, union all, copy column, aggregate and audit transformation.
• Advised on SQL optimization, stored procedure design and other Database performance issues.
• Performed database backup and restore.
• Resolved bugs.

Environment: MSSQL Server 2012, 2014, SQL Server Integration Services(SSIS), T-SQL, MDX, XML, Data Transformation Services (DTS), Win Server 2008, 2012, Unix, Linux, Win XP/NT, MS SQL Reporting Services(SSRS)

Confidential

SQL DBA/DEVELOPER

Responsibilities:

• Creating table, Writing Stored Procedures, Triggers and User Defined Functions for the benefit of users.
• Creating Indexes whenever it is required by analyzing the queries
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Identify columns for Primary Keys in all the tables at the design time and create them.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user .
• Designed dynamic DTS and SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created packages using DTS and SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server using ETL Tool.
• Created many rich and highly interactive Web forms for user management module using ASP.Net 2.0, VB and HTML.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Upgraded MS SQL Server 2000 database to MS SQL Server 2005, by using Detach/Attach, Back up & Recovery.
• Moved the static data from various text files to SQL Server 2005 database using BCP Import and Export, Bulk Insert.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Provided support to the application developers on the application databases.
• Configured and Deployed different reports in the Servers using SQL Server 2005 Reporting Services.

Environment: MS SQL Server 2005, ASP.Net 3.5, C#.net 3.5, ADO.Net, Business Intelligence Development studio, Microsoft.NET, MS Office Access 2003, MS Office, MS Outlook 2003, VBScript

Confidential

SQL DEVELOPER

Responsibilities:

• Involved in Table Design and creation of indexes.
• Interact with the users to understand requirements and document them.
• Analyzing the system requirements, business logic and specific line of business.
• Involved in Tuning of queries to enhance Performance.
• Involved in the Data migration activities to load the Data into different DB Schemas.
• Effectively supporting for decision making throughout the organization.
• Reviewed many T-SQL issues using management studio for better performance.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• Created many complex Stored Procedures / Functions and used them in to generate reports on the fly.
• Providing consultation on SQL Server to our development teams.
• Endure that the code is written keeping in mind any security issues such as SQL Injection.
• Develop reports in SQL Server Reporting Services.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Interacted with the business users to gather information about the report.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.

Environment: SQL Server SQL Server v2008/2008R2, Win NT v4, win 2000, Win 2003

Confidential

Technical Support Specialist (System Database Administrator)

Responsibilities:

• Provided Technical Support to IBM’s corporate clients all over the North America
• Helped customers regarding their IT related needs and provide best solutions for their software, hardware or networking requirements
• Fixed issues by using technical knowledge, troubleshooting and problem solving skills
• Provided technical knowledge and after the solution implementation or issue resolution
• Installed, configured and supported different applications, system and database software which includes Windows, Linux, Lotus Notes, SQL Server, Ms Office and more
• Acted as a mentor for newly hired or junior associates when necessary
• Helped others at the department level in maintaining and improving service level

Environment: SQL Server, Windows NT/2000/XP, Linux, Lotus Notes