SUMMARY

• Over 7+ years of experience MS SQL Application/Data Warehouse developer in the analysis, design, development, implementation, testing, maintenance, and documentation of Database and Client Server applications.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, and strong understanding ofBIapplication design and development principles.
• Extensive experience in using MicrosoftBIstudio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Excellent knowledge in RDBMS concepts and constructs along with Object creation such as Database, Tables, Normalization, User Defined Functions, SPROC, Views, Cursors and Triggers.
• Hands on Experience in writing complex stored procedures, Indexed Views and also creating and Updating tables for Data consistency and Data manipulation by executing DBCC commands.
• Experience in creating SSIS packages, DTS Migration and Metadata Management. Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Automated manual process with SSIS packages for import, export and bulk insert data with transformations from various data sources.
• Experience in designing report layouts and developing Custom Reports and different types of Tabular/Matrix/Adhoc/Sub/drill down/drill through Reports and Charts in multiple formats using SSRS.
• 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 usingSQLServer Reporting Services (SSRS).
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Good exposure or knowledge working on C#, VB.NET framework.
• Developed OLAP Cubes by usingSQLServer Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi - dimensional expression (MDX), Perspectives and Roles.
• Expertise in Writing Complex TransactSQL(T-SQL) Queries, Sub queries, Co-related sub queries, DynamicSQLqueries etc.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Extensive experience in using all kinds ofSQLServer Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Expertise in generating reports usingSQLServer Reporting Services, Crystal Reports and MS Excel spreadsheets and Power Pivot.
• Comprehensive knowledge on essential data warehousing concepts such as dimensional modeling, star and snowflake schemas, Data marts, front end/Back end architecture, security and Report distribution.
• Has excellent analytical, programming and problem solving skills.
• Flexible, enthusiastic and project oriented with excellent communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

RDBMS: MSSQL Server 2012, 2008, 2005, MS ACCESS 2007, 2003, 2000.

Database Utilities: Enterprise Manager,SQLServer Management Studio,BIDevelopment, Studio, Visual Studio, Configuration Manager,SQLServer ProfilerSQLQuery Analyzer,SQLRefractor,SQLServer Agent.

ETL Tools: Data Transformation Services (DTS), SSIS, Pervasive Data Integrator, Import/ export wizard, Bulk Insert, BCP.

BITools: SSRS, SSAS, Crystal Reports.

Office Tools: MS Word, MS Excel, MS PowerPoint, MS Outlook.

Languages: MSSQL, PL/SQL, T-SQL, MDX, C/C++, Java, HTML, XML.

Web Technologies: HTML, DHTML, XML.

Architecture: Relational DBMS, Client-Server Architecture, OLAP and OLTP.

O/S: Windows XP,7,10, Vista.

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

MS SQL Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• DDL Scripts for generating Tables, Views, Functions.
• Analyzed and designed software and database solutions.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Performed daily tasks including backup and restore by usingSQLServer 2008 tools likeSQL Server Management Studio,SQLServer Profiler,SQLServer Agent, and Database Engine Tuning Advisor.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading intoSQLserver.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing with different data sources (SQLServer, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQLServer Integration Services (SSIS).
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Configured Reporting Services inSQLServer 2008.
• Worked with Business Analysts,Developersand customers to resolve and escalate project issues.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: MSSQLServer 2012/2008/2005 , SSRS, SSIS, SSAS, Windows2003 Advanced Server, ASP.Net, TSQL, Oracle.

Confidential

SQL Developer

Responsibilities:

• Generated database monitoring and data validation reports inSQLServer Reporting Service (SSRS).
• Created partition table for very large database for good performance.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writingSQLqueries, stored procedures, views, triggers, T-SQLand DTS/SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Involved in creation of Data Warehouse Cubes inSQLServer Analysis Service (SSAS).
• Migrated data using ETL Tool in SSIS.
• Maintained system monitoring jobs and provided high availability support.
• Worked on Migration of packages from DTS usingSQLServer Integration Service (SSIS).
• Participated Databases Architecture and data modeling design.
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Reviewed and developed data models and database designs with development team.
• Designed and developed OLAP using MSSQLServer Analysis Services (SSAS).
• Designed and developed MSSQLServer Reporting Services (SSRS) underSQLServer 2005.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: MSSQLServer 2005, SSRS, SSIS, SSAS, C#, ASP.NET, OLAP, DTS/SSIS.

Confidential, NYC, NY

MS SQL Developer

Responsibilities:

• Understanding the report design Requirements and Constraints.
• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Performing query plans and making sure each and every query is using appropriate useful Indexes.
• Creating and Modifying T-SQLStored Procedures/Triggers for validating the integrity.
• Used Performance Monitor andSQLProfiler for Monitoring memory, processor, Disk I/O,SQL Queries, other etc.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed the created SSIS packages in Development and Testing environments.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server usingSQLServer Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data usingSQLServer Reporting Services (SSRS).
• Promoted RDLs to Reporting Service Server (SSRS).
• Implemented business Intelligence dashboards using MOSS 2007 Report Center and Excel services producing different summary results based on user view and role membership.

Environment: MSSQLServer Management Studio 2008/2005, Index Tuning Wizard, MSSQLServer Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MSSQLServer Reporting Services (SSRS).

SQL Server Developer

Responsibilities:

• Worked with Business Analyst and System Analyst in gathering business requirements and specifications from different stakeholders.
• Developed SSIS Packages to extract, load and transform data on daily, weekly and monthly basis using SQL Server Agent Jobs from SQL server to different files and external databases.
• Created parameters, Expressions and calculate the expressions according to the business requirements.
• Involved in design, development, and enhancement, testing of DTS&SSIS packages.
• Developed Dynamic and Static Stored Procedures and Queries to maintain central Database and store details of locations and consumer lines.
• Developed MSSSIS Packages to load very large data set in less time which enhanced DW data loading performance.
• Interacted directly with various business users as a part of team involved in requirements collection and analysis.
• Extensively used SQL Server Reporting Services 2008R2(SSRS) with relational and multidimensional data.
• Created user defined functions to split the string in the multi valued parameters and pass to the main query.
• Implemented business logic by extracting data from different sources like Flat files and loaded the results into the target table.
• Extracted data according to specification and created a new table.
• Designing and Deploying Tabular, Matrix, List and Chart reports with Drill Down, Interactive sort, Drop down menu option, Parameterized and Sub reports.
• Developed several 2008R2SQL Reporting Services (SSRS), with Visual Studio and supporting Stored Procedures.
• Develop SSIS Packages to transform data from Excel/Access file to SQL Server database.
• Defined report layouts including report parameters.
• Created parameterized, drill down in MS SQL environment using SSRS 2008R2.

Environment: SQL Server 2008R2/2005 Enterprise, SSRS, SSIS, Crystal Reports, Windows Enterprise Server 2000, DTS, SQL Profiler, and Query Analyzer, DBCC Utilities.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, involved in Design, Development and testing of the system.
• DevelopedSQLServer Stored Procedures, TunedSQLQueries (using Indexes).
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote ComplexSQLQueries to generate Crystal Reports.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Automation and execution of data transformation scripts.
• Designed multiple stored procedures for the Report data sources.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Optimized SQL queries for improved performance and availability.
• Designed, analyzed and upgraded databases.
• Developed Transact-SQL scripts to enforce business rules.
• Environment: MS SQL Server 2000, Windows 2000, MS Access, T-SQL, DTS, VB 6.0.
• Creating and automating the regular Jobs.
• Tuned and OptimizedSQLQueries using Execution Plan and Profiler.
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: Windows 2000 Server,SQLServer 2005, Query Analyzer, Enterprise Manager, Import and Export,SQLProfiler.