SUMMARY:

• 13+ Years of professional experience in IT industry.
• Experience in Database Development for very large and complex databases in SQL Server 2000/2005/2008/ R2/2012/2014 on various domains like Finance, Insurance, Healthcare and Software Solutions.
• Experience on writing Stored Procedures, Functions, Triggers and creating Views.
• Data modeling ExperienceincludingPhysicalandlogical datamodeling using VISIO.
• Skills in database Backup, Restore, and Linked Servers.
• Extensively used tools like SQL Profiler for tuning and monitoring SQL Server performance.
• Expertise in writing T - SQL Queries, Stored Procedures, User Defined Functions, Triggers, Distributed Queries, and Common Table Expressions (CTEs).
• Expert in BIDS and developing SQL Server Reporting services (SSRS) reports and models.
• Proficient in high level design ofETLs like DTSPackages, and SSIS packagesfor integrating data using OLEDB connection from various sources (Excel, CSV, flat file and Text Format Data).
• Experience in creatingReport Subscription,Data Driven Subscription, Linked, CascadedandParameterized Reports, Complex Drill Down ReportsusingSQL Server Reporting Services.
• Configuring and maintainingReport ManagerandReport Server.
• Experience inCrystal Reports, Visual Basic 6.0 and MS Access.

TECHNICAL SKILLS:

Databases: MS SQL Server 7.0/ 2000/2005/2008/ 2012/2014

Programming: Visual Basic 6.0, C, C++, MS Access

Operating System: Windows

Web Tools: HTML, XML

Reporting Tools: SSRS, Crystal Reports, MS Access

PROFESSIONAL EXPERIENCE:

Confidential, Farmington Hills, MI

SQL Server Developer - DBA

Responsibilities:

• Created views, stored procedures, and functions.
• Created different reports usingSQL Server Reporting Services (SSRS).
• Deployed SSRS reports (RDL files) in Reports Server.

Environment: /Tools: SQL Server 2014, SQL Server Data Tools (SSDT)

Confidential, Ann Arbor, Michigan

SQL Server Developer - DBA

Responsibilities:

• Created different complex reports usingSQL Server Reporting Services (SSRS).
• Deployed and integrated SSRS reports in Share point webserver.
• Developed and created the new database and database objects including tables,views, index, stored procedures and functions, advanced queries.
• Created different SQL jobs which are used to pull data from different databases and insert into the data warehousing database.
• Deployed and scheduled jobs to run at different time intervals.

Environment: /Tools: SQL Server 2012, SQL Server Data Tools (SSDT), Share point 2010/2013.

Confidential, Williamston, Michigan

SQL Server Developer - DBA

Responsibilities:

• Created and modified different complex SSIS packages which pulls data from different sources like SAP and SQL databases and insert into SQL database.
• Deployed and scheduled the SSIS packages to run at different time intervals.
• Created reports usingSQL Server Reporting Services (SSRS).
• Developed new database objects including tables,stored procedures and functions.

Environment: /Tools: SQL Server 2008/2012, SQL Server Data Tools (SSDT).

Confidential, Troy, Michigan

SQL Server Developer - DBA

Responsibilities:

• Created different complex reports using SQL Server Reporting Services (SSRS).
• Deployed SSRS reports on webserver.
• Created the new database and database objects like views, indexes, stored procedures, functions, and advanced queries.
• Created Linked Servers to manage and interacts data between different servers.
• Created Log shipping to move data from one server to another server, and scheduled to move this data at different intervals.

Environment: /Tools: SQL Server 2008/2012, SQL Server Data Tools (SSDT).

Confidential, Charlotte, NC

SQL Server Developer

Responsibilities:

• Workedon Profiler, Performance monitor to tune the databases and query tuning.
• Optimized query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for performance improvement.
• Created, deployed and managed reports usingSQL Server Reporting Services(SSRS)
• Created ER-Diagrams and Data Models for various modules.

Environment: /Tools: SQL Server 2005/2008, MS Visio.

Confidential

SQL Server Developer

Responsibilities:

• Installed andmanaged reports using SQL Server 2005 Reporting Services.
• ConfiguredIIS,Report manager, Report serverand implemented role based security to end users.
• Developed report models for creating Ad-hoc reports using Report builder.
• ConfiguredSQL Server settingsusing configuration manager.
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2005tools likeSQL Server Management Studio, SQL Server Profiler and SQL Server Agent.
• Writingstored procedures, triggers, and functionsand maintained coding standards.
• Used SQL Profiler to capture the activities of the databases and used the trace file for Database Tuning.
• Worked onDTS, Import and Exportutility, for transferring data.
• Maintained views, stored procedures, indexes
• Created Documentation, schema designing, ER Diagrams using MS Visio and involved in architecture and Monitoring, optimizing the performance of the database servers.
• Installation of SQL Server 2008/05 and on Windows Server Clustered environment.
• Planning, managing, assigning and scheduling database tasks to the team members.
• Migrated/Upgraded SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration.
• Data transferred using BCP/Bulk insert from Excel, Flat files to SQL Server vice-versa with different formats.
• Migrated Crystal reports to SQL Server 2005 SSRS instance.
• Developed SSRS custom, sub reports, drill through and drill down reports.
• Created Ad-hoc reports using report models and report builder.
• Modified stored procedures, complex queries and views.
• Involved in configuring table/data partitioning on huge tables for better performance.
• Scheduled jobs using Autosys.
• Created stored procedures and triggers according to the business logic.

Environment: /Tools: SQL Server 2000/05, MS Visio.

Confidential

SQL Developer - DBA

Responsibilities:

• Setup new MS SQL Server instances and databases.
• Going through the clients' requirements and coming up with database design and application architecture.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer.
• Designed new job process, new database maintenance plans, DTS packages.
• Used SQL Profiler utility and trace file, and involved in performance tuning processes.
• Monitor failed and long running MS SQL Server jobs.

Environment: /Tools: SQL Server 7.0/2000/2005

Confidential

Visual Basic & SQL Developer

Responsibilities:

• Developed user interface for various modules in co-operative banking activities using Visual Basic 6.0.
• Installation and designing the database.
• Created Stored Procedures, views and functions.
• Performed Database backup, restore and recovery
• Involved in performance tuning.

Environment: /Tools: SQL Server 7.0/2000, Visual Basic 6.0