SUMMARY

• Around 8 years of MS SQL Server Development experience in Finance, Production & Marketing, Telecommunications and Health Insurance domains wif expertise in MS SQL Server 2000/2005/2008/2008 R2/2014 and Microsoft’s suite of products like SSIS, SSAS, and SSRS.
• Highly proficient in teh use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, query writing and SQL joins.
• Expert in Performance Tuning, Handling Indexes, and Query Optimization
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations in teh development of SSIS packages.
• Identified and resolved problems encountered during development and release of teh SSIS code.
• Developed, Monitored and Deployed SSIS Packages from Development environment to Production environment.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in working wif SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations
• Experience in Deploying teh created SSIS packages in Development and Testing environments.
• Good noledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
• Experienced in Designing, Building teh Dimensions, Cubes wif Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2005.
• Proficient in designing Data Mart and Data Warehouse using Star and Snowflake Schemas
• Expert in creating cubes and dimensions, handling multi-dimensional reports
• Generated teh Reports wif all teh subcategory Information to Business users.
• Developed and Deployed different types of Reports like Ad Hoc, List, Drill Down, Drill Through,Matrix, Chart and Sub Reports etc.
• Created and Executed teh Stored Procedures and Complex Queries for Reports.
• Strong communication skills when working wif stakeholders, developers, project managers, system implementers, and application end-users.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS

Relational Databases: SQL Server 2014/ 2008R 2/2008/2005/2000, MS Access.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe,SQL Query Editor

Languages: T-SQL, HTML, XML,SQL,C, VB.Net, ASP.Net

Operating Systems: Windows vista/XP/ 2010/2008/2003/2000/ NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL, IIS(4.0/5.0/6.0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different sources using SQL Enterprise Manager/SSMS on SQL Server 2008 R2 environment, and deploy teh data; scheduled teh jobs to do these tasks periodically.
• Designed and developedSQLServer2008 R2databases, including tables, stored procedures and functions.
• Created, Implemented and Executed T-Sql statements including Triggers
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Stored Procedure development, Enhancements, Performance tuning.
• Provided technical support to internal developers and external clients.
• Created Packages dat dealt wif text files containing dynamic number of columns.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of teh package.
• Designed high level ETL architecture for overall data transfer from teh OLTP to OLAP wif teh halp of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Tested, Cleaned and Standardized Data meeting teh business standards using Fuzzy /exact lookups using SSIS tasks.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder.
• Reports migrations from Actuate to SharePoint/SSRS technology.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Created Drill-down, Parameterized and Sub-Reports using RDL and Promoted RDLs to Reporting Service Server (SSRS).
• Had involved in Start to end of enhancements projects like creating Business Required Document (BRD), Developing, Testing, creating UAT test scripts, opening remedy tickets.
• Involved in organizing meetings wif Production Management and Architecture Approval teams and involved in Production Deployment support.

Environment: MS SQL Server Management Studio 2005/2008R2,MS project,MS SQL Server Integration services(SSIS),SQL Server Reporting Services(SSRS),Microsoft Visual studio 2005/2008R2,Borland Starteam,Microsoft Visual Source Safe, VB.Net, MS Excel, Window XP

Confidential, New York, NY

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at teh database side for performance improvement.
• Design and implementation of Security Model, Policies and Procedures.
• Performing query plans and making sure each and every query is using appropriate Indexes
• Creating and Modifying T-SQL Stored Procedures/Triggers for validating teh integrity
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Deployed teh 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
• Involved in teh Migration of Databases from SQL Server 2005 to SQL Server 2008R2
• Prepared teh complete data mapping for all teh migrated jobs using SSIS.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Understanding teh report design Requirements and Constraints.
• Created Drill-down, Parameterized and Sub-Reports using RDL.
• Promoted RDLs to Reporting Service Server (SSRS).

Environment: MS SQL Server Management Studio 2008/2008R2, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created Star schema dimension modeling for teh data mart using Visio and created dimension and fact tables based on teh business requirement.
• Gatheird report requirements and determined teh best solution to provide teh results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• DesignedSSIS packages to Extract data from different sources like SQL server 2008,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
• Developed SSIS packages using for each loop in Control Flow to process all excel files wifin folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into teh SQL table
• Produced operational reports in SSRS 2008 me.e. drill-down, drill-through, dashboard and matrix reports. Responsible for ETL through SSIS and loading Data to DB from different input sources.
• Used ETL for data flow from different source files like XML, Excel, Tables, and Views to other databases and files wif proper mapping.
• Generated monthly and quarterly reports as bar charts for teh management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Implemented Complex Logging in SSIS Packages.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations
• Converted manual reports pasted together into parameter driven stored procedures to be used wif Microsoft Reporting Services 2008
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in teh design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports
• Responded to AD-HOC requests and special projects dat require immediate attention while at teh same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked wif project manager and technical leads for resolution of technical issues.

Environment: MS SQL Server Management Studio 2008, Query Analyzer,, Index Tuning Wizard, MS SQL Server Integration Services (SSIS), MSSQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe

Confidential, Wilmington, DE

SQL Developer/SSIS/SSRS /SSAS

Responsibilities:

• Installed and Configured SQL Server 2005 and also Upgraded teh existing database to SQL Server 2005.
• Actively supported business users for change requests.
• Created several databases in various Development and Test server by using SQL Server 2005.
• Created several tables, views using SQL Server 2005 Management Studio as well as in Oracle 10g and Oracle 9.0 / 8.6 using Toad. These tables, views are created based upon teh function spec.
• Generated scripts and schemes by using reverse engineering through Toad Data Modeler.
• Responsible for making weekly backup databases by using SQL Server 2005 and restore these databases in different server.
• Responsible for installation, configuration, security, maintenance and restoration of SSRS on Windows Server 2003.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 8i/9i to SQL Server 2005 by using SSIS.
• Involved in SSIS Package, DTS Import/Export for transferring data.
• Imported and exported data in teh tables using Toad for Oracle and SSMS for SQL.
• Performed Designing, Building teh Dimensions, Cubes wif Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server 2005.
• Involved in creating Dimensions, KPI, Measures and calculations in SSAS in SQL Server 2005.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Performed report testing and Verification as per internal reporting system requirements.
• Applied security to web server and database server dat effects report server installation. Managed role-based security to reports and reporting resources.
• Responsible for back up and restoration of SQL Reporting Service.
• Provided Documentation support on SSRS 2005 as assigned.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, SSIS, SSAS,Oracle 8i / 9i / 10g, Toad, Toad Data Modeler, MS Office, Windows XP/NT.

Confidential, Boonton, NJ

SQL Server Developer

Responsibilities:

• Involved in designing teh Logical and Physical data models for teh data warehouse.
• Created tables, stored procedures, views, functions, and triggers using T- SQL.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Created triggers to enforce data and referential integrity, on teh specific table which halped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.
• Involved in database designing using Normalization.
• Create teh clustered/non-clustered indexes on tables; created views, stored procedures and triggers. Trace out for any table required any indexes and determine teh type of index on it.
• Place teh huge table/non-clustered index on teh separate file group to improve teh performance.
• Traced complex stored procedures, SQL queries and monitored using SQL Profiler.
• Efficient use of Joins and sub-queries in queries dat retrieve data from multiple tables.
• Involved in development and debugging of complex batch T-SQL Procedures and functions.
• Partitioned many tables, which have frequent inserts, updates and deletes to reduce teh contention and to improve teh performance.
• Optimized indexes to improve queries and analyzed database performance wif SQL Profiler

Environment: MS SQL Server 2005, Enterprise Manager,Query Analyser,T-SQL,MS Visio, Excel.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Installing, Configuring and Tuning Database
• Database Backups, disaster recovery and database maintenance plan
• Space management
• Security and new user maintenance
• Upgrading to latest version
• Data conversion from Text File, MS-Excel into SQL Server Table
• Data Integrity Validation
• Database and Object Creation: Developed Stored procedures, Triggers, Tables, Views
• Resolving any dead locks issues wif teh Databases/Servers on a real-time basis
• Troubleshoot Database Errors
• Maintaining teh database consistency wif DBCC at regular intervals
• Migrating Data, Tables, Stored procedures and other Objects from SQL Server 7.0 to 2000
• Production support for existing Database
• Documentation of teh systems Tables, Views, Stored Procedures, Jobs, Packages

Environment: MS SQL Server 2000/6.5/7.0, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer

Confidential

SQL Server Developer

Responsibilities:

• Extensively involved in installing and configuring SQL server 2000.
• Transformed data using DTS packages, BCP utility and Bulk Insert statement as and when necessary.
• Improved Performance of databases by analyzing Indexes, Fill Factor and Fragmentation issues
• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
• Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert teh users wif teh field status changes.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Monitoring server performance by using Performance counter.
• Created complex Stored Procedures and Cursors to support applications using T-SQL.
• Prepared Estimates for Database Files and Table size growth. .
• Generated Reports for teh day-to-day as well as weekly/monthly purposes.
• Created Distributed Partition views Using T-SQL.

Environment: MS SQL server 2000, Windows 2000, Enterprise manager, Query analyzer, DTS, SQL profiler.