PROFESSIONAL SUMMARY:

• Over 10 years of extensive experience in Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL 2000/ 2005/2008/2008 R2/2012.
• Expert in creating Tables, Views, User Created Data Types, Functions, Indexes, Stored Procedures and Triggers.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used multiple join statements to retrieve data from multiple several tables.
• Experience in writing Complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries.
• Experience in logical and physical data modeling of the database in ERWIN.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Experience in requirements gathering, analysis & design of ETL processes using SQL Server Integration Services (SSIS) and SSRS.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008/2012 ).
• Experienced in extraction & migration of data from heterogeneous data sources like Excel, MS Access to MS SQL Server by using import/export Wizard, DTS/SSIS
• Extensive experience in creating ETL packages using SQL Server Integration Services (SSIS) and scheduling packages, validating data using SSIS.
• Experience in providing Logging, Error handling by using Event Handler for SSIS Packages.
• Good experience in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008/2012 across various environments.
• Experience in creating Ad-hoc reports, data driven subscription by using Report Builder in SSRS.
• Expertise in generating drill down reports, parameterized reports, linked reports, sub reports in SSRS 2005/2008/2008 R2/2012.
• In-depth knowledge of T-SQL, SSRS, SSIS, SSAS, OLAP, BI suite.
• Experience in supporting huge databases, troubleshooting problems, and documenting root cause analysis.
• Extensive experience in database migration and upgrade from SQL Server and 2008 and 2008R2.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Knowledge in Data warehousing, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Platforms: Windows Server 2000/2003/2008, Windows Vista/XP/2003/2000 UNIX, Linux, DOS

SQL Server Tools &Packages/ BI tools: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, Crystal Reports, ETL, SSIS, SSAS, SSRS, Erwin Data modeler

Applications: C/C++, HTML, XML, Visual Studio

Desktop: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

Databases: SQL Server 2000/ 2005/2008/2008 R2/2012, MS Access 97/2003/2005/2008

PROFESSIONAL EXPERIENCE:

Confidential, White Plains, NY

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in Business Analysis & Requirement collection.
• Designed Data Warehouse and Database for the system using Star Schema, which includes Tables, Stored Procedure and Indexes in SQL Server Management Studio.
• Working on the Customer, Loans, and Transactions related complex Queries using the TSql.
• Implemented ETL to Extract and Transform data from Flat File or CSV, SQL Server 2005 instances and to load into Staging Database. The main purpose to load into staging database by looking at the full and differential backups.
• Use Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Create and run Sub-reports, Drill-down reports, Matrix or Crosstab reports and Summary reports in SSRS.
• Create Subscriptions to generate reports on daily and weekly basis via FTP.
• Mange Report Security by using SSMS. Connect to Reporting Server and set different roles and different security level to different users.
• Use SQL Server Profiler for tuning report queries and improve performance in SQL Server.
• Actively participated in review meetings with Project Manager to ensure that the development of projects meet business and system requirements.
• Documenting the development work.

Environment: MS SQL Server 2008, MS Excel, Business Intelligence Development Studio 2008, SQL Profiler.

Confidential, Virginia Beach, VA

SQL Server Developer

Responsibilities:

• Maintain SQL Server Instances in all environments including Development, Test, and production.
• Created databases, tables and wrote stored procedures, cursors and various database objects.
• Created complex Stored Procedures, DTS (Data Transformation Service) packages, triggers, cursors, tables, views.
• Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements
• Using dynamically generated SQL.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server for faster execution.
• Reviewed and modified database structures, stored procedures to convert database tables into XML format and display via web, views, triggers, user-defined functions.
• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Created Complex Reports by using different expressions.
• Designed and implemented stylish report layouts.
• Generated different types of reports using SSRS.
• Experience in using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Agent.

Environment: MS SQL Server 2012, MS Excel, Business Intelligence Development Studio 2012, SQL Profiler, Report Builder 3.0, T-SQL.

Confidential, Newtown, PA

SQL Server Developer

Responsibilities:

• Gathering requirements from Business Managers there by creating tickets according to priority using Help-Star and work accordingly.
• Create databases, tables and wrote stored procedures, cursors and various database objects.
• Create complex Stored Procedures, DTS (Data Transformation Service) packages, triggers, cursors, tables, views.
• Developing T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements
• Using dynamically generated SQL.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Designed, Deployed reports in MS SQL Server environment using Report Builder 3.0.
• Using Report Builder 3.0 delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating Sub-Reports, Drill down reports, Drill through reports, Ad Hoc and Parameterized various Reports Using Report Builder 3.0
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Creation and Maintenance of Indexes for various fast and efficient reporting processes.
• Perform T-SQL tuning and optimizing queries for Reports.

Environment: MS SQL Server 2012, MS Excel, Business Intelligence Development Studio 2012, SQL Profiler, Report Builder 3.0, T-SQL.

Confidential, Richmond, VA

SQL Server Developer/ DBA

Responsibilities:

• Maintain SQL Server Instances in all environments including Development, Test, and production.
• Implementing the tasks, which are required, according to the requirements in the production server.
• Modified or updating the required changes in production.
• Handling the issues, which need to be analyzed in production server.
• Responsible in Creating SQL Queries.
• Handling all criteria’s in developing.
• Performance issues in SQL Server production environments.
• Implementation of SQL Server Security.
• Responsible for monitoring SQL Server performance issues.
• Implement SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2012
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Perform backup and recovery.

Environment: MS SQL Server 2012, MS Excel, Business Intelligence Development Studio 2012, SQL Profiler, SSIS, SSRS, T-SQL, XML.

Confidential, Philadelphia, PA

MS SQL Server /SSIS Developer

Responsibilities:

• Planned, defined and designed data based on the business requirement.
• Worked closely with Business Analysts to produce all required documentation.
• Created complex Stored Procedures, DTS (Data Transformation Service) packages, triggers, cursors, tables, views.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2012
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Responsible for Database and Log backups & Restoration, backup strategies and scheduling backups. Scheduled the SSIS packages and Jobs.
• Scheduling and maintaining SSIS Packages and batch jobs thru SQL Server Agent.
• Enhanced performance by reviewing disk configuration and storage allocation. Generated test data and test database to meet the functionalities deliverables.
• Planned database security measures and Created and updated database document. Supported development effort by providing T-SQL statement tuning and optimized data loading processes.
• Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

Environment: MS SQL Server 2012, MS Excel, BCP, OLE DB, XML, Business Intelligence Development Studio 2012, SQL Profiler, VB.NET,SSIS,SSRS,T-SQL.

Confidential, Olympia, WA

MS SQL Server/ SSRS/ SSIS Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented triggers and stored procedures and enforced business rules via check constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select Statement in certain Queries
• Created views to restrict access to data in a table for security
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using SSRS 2008.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.

Environment: MS SQL Server 2008/2008R2, SQL Profiler, SSIS, SSRS, T-SQL.

Confidential, BOSTON, MA

MS SQL Server/ SSRS/ SSIS Developer

Responsibilities:

• Involved in gathering requirements from Business Managers there by creating tickets according to priority using Jira and worked accordingly.
• Involved in writing T-SQL stored procedures and user-defined functions and perform daily account screening.
• Created databases, tables and wrote stored procedures, cursors and various database objects.
• Created complex Stored Procedures, DTS (Data Transformation Service) packages, triggers, cursors,
• Tables, views.
• Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements
• Using dynamically generated SQL.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server for faster execution.
• Reviewed and modified database structures, stored procedures to convert database tables into XML format and display via web, views, triggers, user-defined functions.
• Planned database security measures and Created and updated database document. Supported development effort by providing T-SQL statement tuning and optimized data loading processes.
• Scheduled and monitored all maintenance activities of SQL Server.
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Created SSIS Package for uploads and schedules them as SQL Server Agent. Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Used SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Identified the Data Source and defined them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2008.
• Designed and implemented stylish report layouts.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Experience in using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Agent.

Environment: MS SQL Server 2008R2, MS Excel, Business Intelligence Development Studio 2008, SQL Profiler, SSIS, SSRS, T-SQL, Windows Server 2003/2008.

Confidential, Minneapolis, MN

MS SQL Server/ BI Developer

Responsibilities:

• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Designed, reviewed, and created objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Wrote various T-SQL queries, Stored Procedures and used them to build packages.
• Created Triggers, Tables, Views and SQL Joins for various applications.
• Responsible for Database and Log backups & Restoration, backup strategies and scheduling backups. Scheduled the SSIS packages and Jobs.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Using SQL Server Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Generated Sub-Reports, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Experience in using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL SERVER 2005, MS SQL Server 2008, SSIS, SSRS, SSAS Business Intelligence Studio, SQL Profiler, Windows XP / NT / 2000/2003, Microsoft Access.

Confidential, Charlotte, NC

SQL Server/ SSRS/ SSIS Developer

Responsibilities:

• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute Sql Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Knowledge of developing reports from Cubes using the KPI’s for decision-making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized various Reports using SQL server 2005 Reporting Services
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL SERVER 2000, MS SQL Server 2005, SSIS, SSRS, Business Intelligence Studio, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Newport Beach, CA

SQL Server Developer/ DBA

Responsibilities:

• Involved in gathering the functional requirements from the client.
• Involved in Creating Complex Store Procedure using T-SQL to evaluate result for the repots to implement using Management studio.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Developed different Scripts for the Data analysts for Verification of reports.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Performed data conversions from flat files into a normalized database structure.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Creation and Maintenance of Indexes for various fast and efficient reporting processes.
• Perform T-SQL tuning and optimizing queries for Reports.

Environment: Microsoft SQL Server 2000, SQL Server Reporting Services (SSRS), Windows XP, MS Excel 2003, VBScripts.