SUMMARY:-

• 8 years of IT experience in Database Design, Data Modeling, Data and Database Security, Requirements Analysis, Application Development, Testing, Implementation and Deployments using SQL Server 2012/2008/2005/2000.
• Experience with Multi- Servers and Multi-Terabyte Databases design for Very Large Databases 2 Terabytes .
• Created, Built and deployed successfully dynamic SSIS packages into SQL Server 2012/2008/2005 databases and scheduled them according to requirements.
• Experience in working with Reporting tools like MS SQL Server Reporting service SSRS .
• Rendered reports in CSV, PDF, XML and Delivered reports by file share and E-mail according to schedule.
• Created, designed and deployed Tabular, Matrix, Chart, Cascade, Drill-down and Ad-Hoc reports on report server.
• Experience in Database Design activities including Data Files and File group organization, Capacity Planning, Data Partitioning, Data Normalization and De-normalizing.
• Hands on experience with Data Modeling tool like Microsoft Visio.
• Proficiency and Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Experience in Creating complex Views, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Good hands-on with creating Partitioned Tables and Partitioned Views.
• Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Expert in Query Tuning and activities including Updating Statistics, Re-building and Re-organizing Indexes.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2008/ 2005.
• Monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views.
• Worked in both Production and Development environment.
• Expert in creating and maintaining Documents for future needs.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer

Responsibilities:

• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio BIDS and Visual studio 2013.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS, Excel Pivot that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Used SSIS as ETL Tool to extract the data from production servers to OLAP Data ware house.
• Responsible for creating the reports basing on the requirements using SSRS 2012. These are Cascade, Drilldown, Linked, Tabular and Matrix reporting.
• Designed SQL SSIS Packages in Business Intelligence Development Studio BIDS , to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 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 in Visual Studio 2012.
• Prepared and documented Backup Restore Plans.
• Backing up master system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• 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
• Developed SSRS Templates which can be used to develop SSRS such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Environment: SQL Server 2012/2014, SSIS, SSRS, Visual studio 2013, ETL, MS Visio 2007, XML, VB.Net, ASP.NET. C Sharp, Oracle 11g

Confidential

Sr. SQL Server Developer

Responsibilities:

• Created various packages using SSIS as per the specifications.
• Migrated data from heterogeneous data sources Data mart, Access, Excel, Flat file to centralized SQL server databases using SQL Server Integration Services SSIS to overcome transformation constraints.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Scheduling the SSIS packages and Jobs.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Helped Quality Assurance Team to generate Test Plans and Test Executions.
• Worked on performance point server to create dashboard and scorecards for business intelligence.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Experience in creating complex SSIS packages using proper control and data flow elements
• Involved in updating slowly changing dimensions strategies
• Worked on relational DBMS and object oriented DBMS.
• Participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-20012 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, ETL, OLAP, OLTP, Erwin, Performance Point Server, UNIX, Office-2007, MS Excel, C .NET, ProClarity Analysis, MS SharePoint.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Performed data migration from SQL Server 2005 to SQL Server 2008.
• Migrate and Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Build new could server in Amazon AWS and Windows Azure and migrate database and all objects to new Cloud Server.
• Create different kinds of Report in SSRS and Pentaho BI tool.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio BIDS and Visual studio 2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS, Excel Pivot that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports basing on the requirements using SSRS 2008 and 2012.
• Designed SQL SSIS Packages in Business Intelligence Development Studio BIDS , to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 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 in Visual Studio 2012.
• Prepared and documented Backup Restore Plans.
• Backing up master system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• 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
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio BIDS .

Environment: SQL Server 2012/2008/2005, SSIS, ETL, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net, ASP.NET. C Sharp, PHP, Oracle 11g.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in interaction with users, team lead, DBA's and technical manager to fully understand the requirements of the system.
• Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Performed data conversion from flat file into a normalized database structure.
• Created Triggers to enforce data and referential integrity.
• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio BIDS and Visual studio 2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS, Excel Pivot that could be used to send information to diverse group of users, clients, and managers.
• Designed SQL SSIS Packages in Business Intelligence Development Studio BIDS , to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008, 2005 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 in Visual Studio 2008.
• Prepared and documented Backup Restore Plans.
• Backing up master system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• 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.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Developed, monitored and deployed SSIS packages.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Environment: SQL Server 2012/2008/2005, SSIS, SSRS, Visual studio 2008, MS Visio 2007, XML, VB.Net.

Confidential

SQL Server Developer

Responsibilities

• Designed and applied schema change scripts to existing objects to synchronize with changing business rules.
• Created stored procedures, triggers, views, added/modified tables for data load transformation extraction and manipulation.
• Filtered bad data using complex T-SQL statements, Cursors and UDFs and implemented various constraint and triggers for data consistency.
• Build table relationships and wrote stored procedure to clean the existing data.
• Managed database changes based on feedback.
• Migrating DTS package from SQL Server 2005 to SSIS in SQL Server 2008.
• Created new SSIS packages according the business rules.
• Participated in creating reports using SSRS.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Configured SQL mail agent for sending automatic e-mails to employees for Invoice using SSIS packages.

Environment: SQL Server 2008/2005, SQL Server 2008 Integration Services SSIS , SQL Server 2008

Confidential

SQL Server Developer/ DBA

Responsibilities:

• Participated in joint application development session JAD to gather information about clients need and to get familiar with vendors product.
• Wrote T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constrains and triggers to preserve data integrity.
• Developed effective stored procedures, functions to implement business logic.
• Used BCP to move in or out data from different sources.
• Used Bulk Insert to copy large amount of data into database.
• Designing, testing and managing disk tape Backups and Recovery strategies.
• Backing up master system databases and restoring.
• Design and automation of disaster recovery procedures.
• Developed Merchandise Business Analysis report for Top management and Category Buyers using reporting services SSRS and deployed to report server.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using Integration Services SSIS .
• Maintained and created Replication: Merge, Transaction and Snapshot and also implemented data transformation to the published articles
• Increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by using Performance Monitor, Profiler, and Index tuning wizard.
• Participated in testing and debugging to validate data after the export/import/delete.

Environment: SQL Server 2005, VB 6.0, XML, VB.Net, SSRS, SSIS