SUMMARY:

• 4+ years of experience as Business Intelligence Developer and Data Analyst in various Environments.
• Strong Communication & Management skills with Excellent Role playing capabilities.
• Experience in Installation, Configuration and Updates of SQL Server.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS - Access, Excel.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Experienced in Performance tuning, Optimization, Data integrity.
• Experienced in data warehousing including business intelligence tools- DTS, SSIS and SSRS, Tableau.
• Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012/2014 with T-SQL.
• Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams.
• Experienced in Installation, Configuration and Deployment of SSRS.
• Experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
• Working knowledge of .Net Framework 3.5 (ASP.NET and C#.NET), IIS Web Server.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player

TECHNICAL SKILLS:

Databases: SQL SERVER 2008/2012/2014 , MS-Access and MY SQL

Languages: C#, C, C++, SQL

.NET Technologies: ASP.NET, C#.NET, XML, UML

Web Technologies: Web Services, AJAX, HTML, CSS, Java Script, jQuery, IIS

Operating Systems: Windows 2008/2012, Windows 7

Application Servers: IIS 6.0

IDE / Utilities: Visual Studio .NET 2010/2014, MS Visio

Source Control Tools: MS Visual Source Safe (VSS), TFS.

Methodologies: Agile, Waterfall

PROFESSIONAL SUMMARY:

Confidential, Brentwood, Tennessee

SQL-Server/MSBI Developer

Responsibilities:

• Designed database, tables and views structure for the application.
• Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
• Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into database using SSIS Packages.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2014 and Flat files.
• Responsible for optimizing SQL queries, stored procedures to improve the performance time.

Environment: MS SQL Server 2014, MS SQL Server Integration/Reporting Services/ Analysis Services 2015(SSIS/SSRS/SSAS).

Confidential, Buffalo, New York

SQL-Server/MSBI Developer

Responsibilities:

• Involved in the analysis of the requirements and gathering requirements for closed loop project.
• Involved in creating tables and their relationships in the data warehouse.
• Created Technical Report Requirement document for the Standard Reports.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Developed Dynamic Report Engine for creating the customized reports in SSRS.
• Involved in creating Dynamic Stored Procedures and views.
• Involved in analyzing and gathering the requirements for Row level Security and Role based security.
• Created the technical requirement Documentation for Row level Security and Role Based Security ETL’s.
• Implemented Row level security and Role based Security in the Standard Reports.
• Involved in creating the tree view folder structure in the application using C#.net to handle different reports.
• Involved in Creating and Testing the SSIS packages developed for security.
• Involved in creating SSIS packages to migrate large amounts of data.
• Involved in using SSAS datasources in SSRS, Tableau reports.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Involved in performance tuning of queries for query efficiency.

Environment: MS SQL Server 2014, MS SQL Server Integration/Reporting Services/ Analysis Services 2015(SSIS/SSRS/SSAS), XML.

Confidential

.Net Developer

Responsibilities:

• Involved in the design and offshore development of the Web Application.
• Worked Closely with Database team and architects to design the database of the Application
• Involved in developing both the Admin and Client module.
• Developing UI Layer, Business Logic Layer, created database Stored Procedures, * Unit and Integration testing of the application, Created GUI using ASP.NET, C#.NET and style sheet.
• Used Ajax Control tool kit of .NET 4.0 frameworks to improve the look and feel and the Usability of the application.
• Data binding was extensively used to bind various server controls to the data from Database, Grid View control and Repeater control were used in displaying rows of data in a customized template format.
• Extensively used ADO.NET objects to communicate with SQL Server 2008 database.
• Involved in writing stored procedures for use in different modules of the application.
• Used Visual Source Safe (VSS) as the Source Control in the entire development of the project.
• Performed Functional Testing to check the stability of the product.

Environment: C# 2.0, ASP.NET 4.0, WCF, SQL Server 2008, ADO.NET, Visual Studio .NET 2005, XML,Ajax.

Confidential

Application Engineer Trainee

Responsibilities:

• Installed and configured the database server (SQL Server 2000) in production, development and testing environments
• Developed the Stored Procedures, Triggers, Functions, and T-SQL scripts
• Writing new stored procedures and modifying existing ones and tune them such as they perform well.
• Implemented auditing using triggers and enforcing business rules via checks and constraints.
• Proper use of views to prevent unauthorized access to sensitive data.
• Created Database Tables and database views.
• Created batch job processing, scheduling and production support.

Environment: SQL Server 2000.