PROFESSIONAL SUMMARY

• Over 7 years of IT experience in Database Design, Development and maintenance of database applications on SQL Server 2000/2005/2008 R2/2012 in OLTP/OLAP/BI environment.
• Experienced with all phase of Software Development Life Cycle (SDLC) involving Requirement Analysis, Design, Development and Implementation.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Extensive experience in MS SQL Server 2000/2005/2008R2,2012, Business Intelligence in MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS).
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databasessuch as Oracle, MS Excel and Flat files.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation using SQL Server SSIS.
• Experience in creating SQL Agent jobs and schedule DTS/SSIS Packages.
• Experienced in writing Parameterized Queries for generating reports, Formatting report layout, reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using Visual Studio 2008/2010.
• Experience in creating reports and Dashboards using Tableau 7.0,8,9.1.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
• Experience in Database administration tasks such as Adding/Removing Logins, Database back up, Restoring the database and shrinking of the database.
• Highly proficient in the use of T - SQL for developing Stored Procedures, Triggers, Cursors, Tables, User Defined Functions andSQLjoins.
• Expert in using tools like MS SQL Profiler, Query execution plan for monitoring and tuningSQLServer performance.
• Experience in developing & deploying cubes usingSQLServer Analysis Services involving multidimensional data.
• Energetic and self-motivated team player with excellent communication, interpersonal, and leadership skills, thrives in both independent and collaborative work environments.

TECHNICAL SKILLS

DataBases: SQL server 2005/2008R2,2012, Oracle 10g

Database Tools: MS SQL server Management Studio, TOAD,SQL Developer, SQL server Profiler

Framework: .Net 2.0,3.0,4.0

Programming Languages: T-SQL,C#, PL/SQL, Visual Basic

Operating System: Windows Server 2003/Windows server 2005/2008,Windows XP, IIS 5, 6,7

Reporting Tools: Tableau 7/8/9,SQLServer reporting services (SSRS)2008R2,2012

Other Tools: MS Visual studio 2005/2008/2010,TFS

PROFESSIONAL EXPERIENCE

MSBusiness Intelligence Developer

Confidential, Tampa, FL

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements, design, testing and implementation
• Involved in preparing the System requirement specification document and design document.
• Created ETL packages dealing with different data sources (SQL Server, Flat Files,Oracle) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) Applied SSIS transformations such as Aggregate, Conditional Splitto the data being loaded into the database.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources(Excel,Oracle, Flat-files) using Visual Studio 2010.
• Developed the Stored Procedures, Triggers, Views using MS SQL server 2012.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Worked on various task such as Execute SQL Task, Execute package task using SSIS.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and adding the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Developing Multi-dimensional Objects (Cubes, Dimensions) on datawarehouseusing SQL Server Analysis Services (SSAS).
• Develop the parameterized reports using SQL server reporting service 2008/2012.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Build adhoc reports to clients using Tableau Desktop.
• Generated Tableau Dashboard with quickglobal filters, parameters and calculated fields on Tableau reports.
• Migrated DTS packages from SQL server 2000/2005 to SQL server 2012 as SSIS packages.
• Performing unit testing for the SSIS packages and reports.
• Prepare environment for quality assurance and user acceptance testing.
• Prepare deployment document for rollout.
• Deploy the packages and reports into production.

Environment: Windows server 2008,SQL server 2012/2008R2,Windows 7,Visual Studio 2008/2010,MS Visio,IIS 6,Tableau 8/9,VB,SQL server agent,SQL Profiler,Toad.

MS Business Intelligence Developer

Confidential, Phoenix, AZ

Responsibilities:

• Involved in gathering the requirements from the clients and preparing the analysis, design and test case documents.
• Developed ETL packages in SSIS using Control Flow and Data Flow Tasks.
• Developed SSIS packages using the Control Flow elements like For Each loop and Sequence container, Execute SQL Task, Execute Process Task.
• Develop code in vb.net for writing the functions for SSIS.
• Created SSIS packages for application dat would transfer data among servers and perform other data transformations
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Creating Stored Procedures for reports generation
• Experience in DB Admin tasks such as DB Backup, Shrinking Database (Transaction logs) and Updating Statistics after loading the daily huge load data.
• Involved in design, programming, deploy and Unit Testing of requested Reports
• Developed stored procedures, Cursors, Tables, Views, SQL Joins for applications using TSQL.
• Involved in creating dashboards with tableau for showing sales trend according to the time period using filters, trend lines.
• Deploying the report and configuring the report server
• Deploy the SSIS packages into production.
• Performed code fixes for issues araised in quality assurance.
• Developed linked and sub-reports using SSRS.

Environment: Windows server 2008/windows server 2005,Windows 7,VB.net,SQL server 2008R2,Visual Studio 2008,MS Visio,IIS,SQL server agent,SQL Profiler,Tableau 7,MS Analysis Services 2008.

MS SSIS/SSRS Developer

Confidential, Maryland, U.S.A.

Responsibilities:

• Identified the Business Requirements of the project.
• Involved in preparing the Detailed Design document for the project.
• Designed databases and database objects such as tables
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes
• Optimization of queries by looking at Execution Plan for better tuning of the database
• Developed SSIS packages to transfer data from sources such as flat files/excel to SQL server.
• Scheduled the SSIS packages to run according to the business requirements.
• Performed Unit Testing on the application developed.
• Worked on bug fixing and enhancements on change requests.
• Involved in capturing the business requirements, design, development and testing of the application.
• Created reports using the SQL server reporting services.
• Involved in fixing post production issues.

Environment: Windows server 2005,Windows XP,MS Office,MS Visual Studio 2008,MS SQL

C#/SQLDeveloper

Confidential

Responsibilities:

• Involved in installation and setup of SQL server 2008R2.
• Migration of SQL server 2000 to SQL server 2008R2
• Involved in preparing the dependency sheets which contains the details of the server to be migrated.
• Developed Stored Procedures,Tables, Views,Indexes and functions using TSQL.
• Experience in database maintenance tasks such as backup and recovery of the database.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Migrated the DTS packages to SSIS.
• Involved in database purge and run update statistics jobs on sql server for performance.
• Migrated the lower versions(1.0,2.1) of .net applications to higher versions(3.0)
• Developed console applications using C#.
• Scheduled to run the application according to business requirement using windows scheduler.
• Designed windows form screen using gridview control.
• Worked on fixing the bugs raised during the QA.
• Involved in Unit Testing.
• Creation of deployment document and document issues encountered during roll out.
• Involved in post-production support.

Environment: Windows XP, Windows server 2005, MS Sql server 2000/2005/2008,MS Visual Studio 2005/2008, IIS, MS Office, C#

SQL Server Developer

Confidential

Responsibilities:

• Installed and configured Visual Studio 2005/SQL server 2005.
• Understanding the existing system and customer requirements.
• Involved in creating the database tables and enforcing the relationship between the tables.
• Enforced unique/null/check and other integrity constraints in tables.
• Developed Windows forms using Visual Studio 2005 and .net framework 2.0.
• Used dataset, data reader, data view to read data using ADO.Net objects.
• Wrote T-SQL queries in creating views and stored procedures in SQL Server. Used joins, unions to get data from different tables and databases.
• Involved in performance tuning of queries for query efficiency.
• Involved in creating the environment for development, testing and production.
• Involved in database creation and back up.
• Built the set up file using Visual Studio 2005.
• Involved in defect fixes.
• Was involved in user acceptance testing to ensure customer satisfaction.

Environment: Windows XP, Windows server 2005, MS Sql server 2005/2000, MS Office, C#