PROFESSIONAL SUMMARY:

• Over 6 years of professional experience on design, development and maintenance of database using tools of MS SQL Server 2008/2012/2014 as a Developer.
• Experience in Installing, Upgrading, Configuring, Monitoring and Troubleshooting Microsoft SQL Server 2014/2012/2008
• Experience with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2008/2012/2014 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 and using Store Procedure, Views, User Defined Functions, implementing Business Intelligence solution using SQL Server 2008/2012/2014
• 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 SSIS packages using SQL Server Data Tools (SSDT)
• Excellent experience in migration of data from Excel, Flat file, Oracle to MS SQL Server by using SSIS and DTS utility.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Reports Models and Ad-hoc reports using SQL Server Reporting Services (SSRS) based on client’s 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/2014
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports using SSRS.
• Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server.
• Experienced in ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data Warehouse Environment.
• Experienced 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 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 containers and variables.
• 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.
• Creative, Aggressive and highly motivated team player and ready to take challenges with proven ability.

TECHNICAL SKILLS:

Languages:  C#, ASP.Net,PHP HTML, Java, JavaScript

Databases:  MS SQL 2005/ 2008/2012/2014 , T-SQL, Oracle 9i/10g, MySQL, MS Access

Development Tools:  MS Visual Studio, MS SQL Server Management Studio, SQL Developer, Toad

Project Methodologies:  Waterfall, Agile, Spiral, SDLC, and UML

Reporting Tool:  SQL Server Reporting Service (SSRS)

Bug Reporting Tool:  Jira, HP ALM/Quality Center

Business Modeling Tools:  MS Visio

PROFESSIONAL EXPERIENCE:

NY

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.
• 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.
• 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.
• 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.

PA

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.

NJ

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.
• 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.

Confidential

NJ

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.