Professional Summary:

• 6 years of professional experience on design, development and maintenance of database using tools of MS SQL Server 2000/2005/2008/2008 R2/2012.
• Experience in Installing, Upgrading, Configuring, Monitoring and Troubleshooting Microsoft SQL Server 2000/2005/2008/2008 R2/2012.
• Experience with all phase of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2000/2005/2008/2008 R2/2012, Business Intelligence in MS SQL Server Integration Service SSIS , MS SQL Reporting Service SSRS , and MS SQL Server Analysis Service SSAS .
• Expert in T-SQL, creating Store Procedure, Views, User Defined Functions, implementing Business Intelligence solution using MS SQL Server 2000/2005/2008/2008 R2/2012.
• Expert in developing ad-hoc T-SQL scripts using Join, Sub query, Derive table, Temp table, Temp variable, Merge, Union, Union All, Except, Pivot, Un-Pivot, CTEs, Dynamic SQL, Cursor etc.
• 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.
• Experienced in writing C .net code for SSIS 2005/2008/2012 packages.
• Excellent experience in migration of data from Excel, Flat file, Oracle to MS SQL Server by using SSIS and DTS utility.
• Expert in designing reports using SQL Server Reporting Service SSRS and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Expert in designing complex reports like reports using Cascading parameters, Parent-Child Reports, Drill-Through Reports, Parameterized Reports and Ad-hoc reports using SQL Server Reporting Services SSRS based on clients requirements.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS 2012/2008/2005.
• Experienced in Logical and Physical Database design, development, normalization and data modeling using Erwin and SQL Server Enterprise Manager.
• Expert in utilizing various types of table Constraints to enforce the data integrity and utilizing various types of Indexes for better query performance.
• Excellent experience in Data Extraction, Transformation and Loading ETL using various tools such as SQL Server Integration Service SSIS , DTS, Bulk Insert and Bulk Copy Program utility.
• Experience in Designing, Development and Maintaining Web Application using Visual Studio .Net, Asp.Net C , ADO.NET 4.0/3.5/3.2
• Experience in logical, Physical and dimensional data modeling, data mapping and, data normalization, Proficient in creating T-SQL DDL, DML, DCL and TCL , Indexes, Views, Table Variables, Complex Store Procedure, User and System Defined Functions.
• Highly experienced in creating, configuring and scheduling the Dynamic SSIS packages using package configurations and variables.
• Expert in developing and deploying cubes using MS SQL Server 2005/2008 Analysis Service involving multidimensional data.
• Worked extensively in Query Optimization and Performance Tuning using tool SQL Profiler, Index Tuning Wizard in Database Engine Tuning Advisor.
• Experience in Database Backup and Disaster Recovery procedure and Replication.
• Experience in defining queries, generation drill down report, complex formulas, sub-reports, on-demand reports in Crystal Reports and Tableau.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs.
• Creative, passionate and highly motivated team player and ready to take challenges with proven ability.

Technical Skills:

• Operating System: Win XP/7, Win 2000/2003/2008 Server
• Languages: C, C , C , ASP.NET, HTML, Visual Basic, Java, Java Script, VB Script, Perl, PHP
• Databases: MS SQL 2000/2005/2008/2012, T-SQL, Oracle 8i/9i/10g/11g, Teradata V2R6.1.1, Teradata SQL Assistant, Progress, MySQL, MS Access
• Development Tools: MS Visual Studio 2005/2008/2010/2012, MS SQL Management Studio, SQL Plus, Toad, Navicat
• Project Methodologies: Waterfall, Agile, Spiral, SDLC, and UML
• Reporting Tool: SQL Reporting Service SSRS , Cyber query,
• Crystal Report, Cognos, Tableau
• Bug Reporting Tool: Mercury Quality Center
• Business Modeling Tools: MS Visio, ERWIN

Professional Experience:

Confidential

Database Developer

Responsibilities

• Involved in planning, defining and designing data and provided documentation.
• Involved in Logical and Physical Database design, Identified Fact Tables, Transaction Tables.
• Developed SQL Script to create database object like Table, Views, Index, Synonyms and Sequences.
• Created and modify existing Stored Procedure, Functions, Packages and Cursors in SQL.
• Created SSIS packages to get data from LDAP and get user information and Permission level by Corporate, Region, Division and Facility Level.
• Created packages to validate, extract, transformation and load data to a centralized SQL Server using OLEDB provider from the existing diversified data sources.
• Created package get information from Mirth Repository to read data HL7 Format to Send Data to End Client.
• Created package for Single Sign user feed for end Client System.
• Created complex SSIS package using proper control and data flow elements.
• Created stored procedures for generating reports by using SSRS, and Views for performance tuning and retrieval of data.
• Improved performance of database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using Query Optimizer.
• Created reports to retrieve data using Store procedure that accepts parameters.
• Designed report models based on user requirements, explained and trained users to use reports builders to generate their own personalized reports.
• Performed T-SQL tuning and optimizing queries for reports which take longer time in executions SQL Server.
• Responsible for optimizing all indexes, SQL queries, store procedure to improve the quality of software.
• Generated Sub-Reports, Drilldown reports, Drill through reports and Parameterized reports using SSRS and Tableau.
• Experienced in writing Complex Queries, Sub Queries, Constraints, Index, View, Store Procedures, Functions, Joins, Packages, and Cursors using T-SQL in SQL Server.
• Wrote complex SQL statements such as DDL, DML, DCL and, DQL.

Hardware/Software:

SQL Server 2005/2008/2008R2/2012, ETL/SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Management Studio, Visual Studio 2008/2010/2012, Team Foundation Server TFS 2010, .Net 2.0/4.0 Framework, Java Script, Mirth Connect

Confidential

MS SQL Server Developer/Report Developer

Responsibilities

• Involved in planning, defining and designing data and provided documentation.
• Worked with project lead and business users to understand business processes, gather and document project requirements and translate into functional and non-functional specifications for BI reports and applications.
• Migrated data from Heterogeneous data source and legacy system to centralized SQL Server database using SQL Server Integration Service SSIS to overcome transformation constraints.
• Created packages to validate, extract, transformation and load data to a centralized SQL Server using OLEDB provider from the existing diversified data sources.
• Created packages in SSIS with error handling.
• Created SSIS package to move the data from Teradata and Oracle into SQL Database. Also made dynamic SSIS Packages which did data scrubbing, including data validation checks.
• Created complex SSIS package using proper control and data flow elements.
• Improved performance of database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL Profiler.
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Created dill down and sub-reports from SSAS cubes that can be browsed on web.
• Responsible for optimizing all indexes, SQL queries, store procedure to improve the quality of software.
• Generated Sub-Reports, Drilldown reports, Drill through reports and Parameterized reports using SSRS and Tableau.
• Involved in scheduled reports on a daily basis and weekly basis that was generated details of FedEx Package by Region and by Service Type.
• Created reports to retrieve data using Store procedure that accepts parameters.
• Designed report models based on user requirements, explained and trained users to use reports builders to generate their own personalized reports.
• Performed T-SQL tuning and optimizing queries for reports which take longer time in executions SQL Server.
• Worked with T-SQL to create Tables, Views, Triggers and Store Procedures.
• Developed Store Procedure and trigger to facilitate consistent data entry into database.
• Documented all processed involved in maintaining the database for future references.

Hardware/Software:

SQL Server 2005/2008/2008R2, Oracle 10g/11g, Teradata V2R66.1.1, Teradata SQL Assistant, ETL/SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SSAS, Tableau 8.1, Management Studio, MS Query Analyzer, SQL Profiler, Database Tuning Advisor, Visual Studio 2008/2010

Confidential

MS SQL Server Developer

Responsibilities

• Involved in planning, defining and designing data and provided documentation.
• Migrated data from Heterogeneous data source and legacy system to centralized SQL Server database using SQL Server Integration Service SSIS to overcome transformation constraints.
• Improved performance of database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL Profiler.
• Created packages to validate, extract, transformation and load data to a centralized SQL Server using OLEDB provider from the existing diversified data sources.
• Involved in maintaining batch log tables and error logging table to handle errors using event handlers.
• Involved in creating SSIS package to Export and Import data from SQL Server to Access, Text and Excel file and Configuring SQL Mail agent for sending mails upon package deployment.
• Migrated packages from development server to production server using package configuration.
• Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Service SSAS .
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Created dill down and sub-reports from SSAS cubes that can be browsed on web.
• Worked on Designing, developing, implementing and, maintaining reporting frameworks.
• Responsible for optimizing all indexes, SQL queries, store procedure to improve the quality of software.
• Generated Sub-Reports, Drilldown reports, Drill through reports and Parameterized reports using SSRS.
• Involved in scheduled reports on a daily basis and weekly basis that was generated details of Produce Parts on each Assembly Line for managements.
• Created reports to retrieve data using Store procedure that accepts parameters.
• Involved in the design / development of web forms for the application using Asp.Net, DHTML, XML/XSLT and CSS.
• Developed pages with Asp.net Ajax Control as per CSS with C as back-end coding language.
• Implemented Client side and server side validation using java script and Asp.net validation control.
• Used ADO.NET objects such as data reader, data adapter, and dataset to fetch and handle user data with store procedures from SQL Server 2008.
• Performed daily task including back and restore by using by the SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Hardware/Software:

SQL Server 2005/2008, ETL/SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , SQL Server Analysis Service SSAS , Management Studio, Visual Studio 2008, Oracle 10g, ASP.NET 3.0/3.5, Progress Database, MySQL Database, Crystal Report v10, Cyber Query, Perl, JavaScript, Visual Basic, SharePoint Server

Confidential

MS SQL Server Developer

Responsibilities

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate into functional and non-functional specifications for BI reports and applications.
• Worked on SQL Server Integration Service SSIS to integrate and analyze data from multiple heterogeneous information sources.
• Created packages in SSIS with error handling.
• Created SSIS package to move the data from tab delimited flat files into SQL Database. Also made dynamic SSIS Packages which did data scrubbing, including data validation checks.
• Created complex SSIS package using proper control and data flow elements.
• Worked on Designing, developing, implementing and, maintaining reporting frameworks.
• Used Lookups Transformation to get the data from reference data sets SSIS .
• Creating reports for users in different departments in different continents using web-enabled reporting by SQL Server reporting Service SSRS .
• Created Sub-reports to present more detailed information about the summary.
• Designed report models based on user requirements, explained and trained users to use reports builders to generate their own personalized reports.
• Performed T-SQL tuning and optimizing queries for reports which take longer time in executions SQL Server.
• Worked with T-SQL to create Tables, Views, Triggers and Store Procedures.
• Involved in querying and manipulating multidimensional cube data through MDX Scripting.
• Developed Store Procedure and trigger to facilitate consistent data entry into database.
• Participated in different testing and debugging procedures for the system.
• Encapsulated frequently used SQL Statements into store procedure there by reducing the execution time.
• Documented all processed involved in maintaining the database for future references.

Hardware/Software:

SQL Server 2005/2008, ETL/SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Management Studio, Visual Studio 2008, Oracle 9g/10g, ASP.NET 2.0/3.0

Confidential

MS SQL Server Developer

Responsibilities:

• Gathered user requirements analyzed and designed software solution and database.
• Created Complex Store Procedure, DTS Packages, triggers, cursors, tables, views and SQL Joins and statements for application.
• Developed T-SQL DDL, DML statements using dynamically generated SQL.
• Design an OLAP with help of Erwin to visualize data structure.
• Extracted and reviewed data from heterogeneous sources from OLTP to OLAP using SQL Server Integration Service SSIS 2005.
• Created SQL Server Analysis Projects and Created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific area using SSAS.
• Improved query performance by cube partitioning.
• Generated daily, weekly and Monthly reports using SSRS 2005.
• Developed measures and dimension members using Multi-Dimensional Expression MDX to meet additional needs that were calculated from existing measures.
• Defined referenced relationship with the measure groups and fact tables.
• Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
• Extensively used Profiler to identify and repair database lookup, deadlocks and, other issues.
• Established a backup and recovery policies and procedures.

Hardware/Software:

SQL Server 2005/2008, ETL/SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Management Studio, Team Foundation Studio, SharePoint Server.

Confidential

Jr. MS SQL Server Developer

Responsibilities:

• Involved in Installation and Configuration SQL Server 2000.
• Involved in Created Logins, Users and Maintenance Plan, Managing use Disk Space, Memory and connection to the database.
• Involved in creation of Table, Views, Trigger and Store Procedure using T-SQL according to the requirements of the projects.
• Involved in Performance tuning and optimizing for SQL Server Application by using Performance monitor.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP Bulk Copy, Indexes and, DTS
• Created and automated regular Jobs such as Daily/Weekly Report Generation.
• Involved in Backup and Disaster Recovery plan of the system.