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

Languages: T-SQL, PL/SQL, VB.Net, HTML, C, C++, Python

Services: Database Engine, SSIS, SSRS (Visual Studio 2012, 2008, 2005)

RDBMS: MS SQL Server 2012, 2008, 2005, 2000, 7.0, MS Access

Reporting Tools: BIDS, Report Builder 2.0, Pentaho 5.0

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1

Operating Systems: Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5.

Other Tools: DTA, SQL Profiler, DTS XCHANGE, Citrix, Diagnostic Manager, SQL Litespeed, RedGates

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 20013.
• 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.
• 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.
• Worked on complex SSIS packages using proper control and data flow elements
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Worked on different kid reports (DFAST, DQ Dashboard, KDE Dashboards etc.)
• Extensively worked building DataMart (Risk DM) from scratch
• Worked on SQL Work book to standardizing SQL Server access by different users.

Confidential

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server. Monitored Administered user, user groups, and scheduled instances for reports in Tableau.
• Created report schedules, data connections, projects, groups in Tableau server.
• Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

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

Confidential, Los Angeles, California

Sr. SSIS/SSRS 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, Folsom, CA

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, San Ramon, California

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, Memphis, TN

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, Plano, Texas

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.
• GeneratedSub-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 Reporting Services (SSRS),SQL Server 2005 DTS, MS Access 2003, MS Excel 2003, VB.Net, OLEDB, Visio 2003, Microsoft Outlook 2003, Windows 2003 Server/XP.

Confidential

SQLServerDeveloper/ DBA

Responsibilities:

• Participated in joint application development session (JAD) to gather information about clients need and to get familiar with vendorsproduct.
• Wrote T-SQLstatements to ensure data consistency by filtering corrupt data and implemented variousconstrainsandtriggersto preserve data integrity.
• Developed effectivestoredprocedures, functionsto implement business logic.
• UsedBCPto move in or out data from different sources.
• UsedBulk Inserttocopy large amount of data into database.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Backing upmaster & system databases andrestoring.
• Design and automation of disaster recovery procedures.
• DevelopedMerchandise Business Analysis reportfor Top management and Category Buyers using reporting services(SSRS)and deployed to reportserver.
• Migrated data from text files and Excel spreadsheets toSQLServerdatabases using Integration Services (SSIS).
• Maintained and createdReplication:Merge,Transaction and Snapshotand also implemented data transformation to the published articles
• Increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by usingPerformance Monitor,Profiler, andIndex tuning wizard.
• Participated in testing and debugging to validate data after the export/import/delete.

Environment: SQLServer2005, VB 6.0, XML, VB.Net, SSRS, SSIS