PROFESSIONAL SUMMARY:

• Over 15 years of experience as SQL Server Database Architect / Administrator / SQL Server BI Developer in System Analysis, Design, Development and Implementation.
• Around 5 years of experience working in Confidential Main Campus with various Confidential Products and IT development.
• Experienced with multiple RDBMS including, Confidential SQL Server, BI & T - SQL, Oracle, PL/SQL and MS Access.
• Experience as SQL Server Database Administrator/ BI Developer to in the develop MS SQL Servers 2012/2008 R2/ 2005/ 2000 Applications with huge Terabyte databases and support in Production Environments.
• Experience in SQL Azure Cloud Services including create and manage Azure Resource groups, Azure Elastic Pools.
• Experience in create and manage SQL Azure Data warehouse Databases and Virtual Machines (Azure VMs).
• Experience in Azure Data Lake Analytics data transformation and processing using USQL
• Experience in Troubleshooting and resolving database Integrity issues, Performance issues, Blocking and Deadlocking issues, Replication issues, Log issues, Connectivity issues, Security issues etc.
• Extensive experience in Query Analyze, Performance Tuning, troubleshooting and optimization T-SQL Queries using SQL profiler, Query Execution Plan and Performance Monitor.
• Experience with Clustering, Mirroring, Transactional Replication and Peer to Peer Transactional Replication .
• Expert in Designing and Developing T-SQL Adhoc-Scripts, Stored Procedures, User Defined Functions, Tables, Views & Triggers.
• Expertise in creating Packages and ETL Applications using SQL Server Integration Services (SSIS) and Data Transformation Services (DTS) with SQL Server.
• Experience in developing and Deploying various Reports like Ad-hoc, Matrix, Table, Drilldown and Drill through Reports using SQL Server Reporting Services (SSRS)
• Experience in Creating OLAP Cubes in SQL Server Analysis Services (SSAS) with SQL Server 2008 R2.
• Experience in Developing Windows and Web Applications using C#, VB.NET, ASP.NET and WCF.
• Experience in developing ASP.NET Web Applications using MVC Design Patterns, AJAX and Infragistics.
• Experience in IIS Administration and Web Application Configuration of Application Pool and authentication and rebuilding a damaged IIS Installation and Creating IIS Configuration backups.
• Experience in developing Internet / Intranet Web Applications using Active Server Pages (ASP), Visual Interdev 6.0, MTS, COM/DCOM/COM+, Java Script and VB Script
• Expertise in Web-Development technologies like XML, XAML, XSL, XSLT, HTML, VBScript, Java script, Visual Interdev, Flash.
• Experience in using Database External Tools like TOAD to work with Oracle database.
• Experience in working with multiple Version control systems Visual Source Safe (VSS), Visual Studio Team Foundation (VSTF) and GIT.
• Experience in creating builds and Patches and releasing and deploying the code in different environments.
• Strong skills in configuration with multiple database servers on Cluster Environment.
• Expertise in Production support and application support for UAT and SIT environments.
• Possesses excellent communication skills and capable of working as Lead, an individual and also as a part of team.

TECHNICAL SKILLS:

Database: MS SQL Server / 2008 R, Oracle 9i / 8.0, MS Access

ETL: SQL Server Integration Services (SSIS), SQL Server Data Transformation Services (DTS)

OLAP/ Reporting: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Programming: C#, VB.NET, ASP.NET, VB, ASP, VB Script, Java Script, T-SQL, PL/SQL, MDX, C, C++, HTML, XML

Web Servers: Confidential IIS 8.0/ 7.0 /6.0/5.0 and PWS.

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Responsibilities:

• Working with Legal division of Confidential to provide the solutions for “Legal Tracker Application” formerly known as “Serengeti Law” which provides Legal Matter Management, e-Billing and analytics for corporate companies.
• Provided solution to replace all the cold build approach with hot build strategy for patch installation on master schema changes in “Transactional Replication“ with publisher and multiple (over10+) subscribers.
• Designed the process to build the data warehouse in Azure.
• Worked on configuring the Azure cloud resources like creating Azure Elastic Pools, Resource Groups and Virtual Machines.
• Worked on creating Azure Cloud databases and assigned to the Azure Elastic Pools.
• Worked on Azure Resource Manager (ARM) Template to create and deploy the Azure Resources.
• Worked on Power Shell Scripts to automate the resource creation.
• Developed the SSIS ETL packages to push the data into Azure Could database from the exiting OLTP production databases.
• Implemented Patch framework for Hot Build Strategy for Tracker Administration tool using C#.
• Implemented Database Design and Database Modeling to create Database Tables.
• Creating Stored Procedures and User Defined Functions and Complex views with cross join among multiple databases.
• Working on database tuning to improve the performance of database and Reports.
• Database “Transactional Replication” installation process using Tracker Admin tool developed in C#
• Working with Tracker Web application tool enhancements using C# with Model View Controller (MVC) pattern.
• Working on solution to migrate from SQL Server 2008 to SQL Server 2012.
• Provided solution to implement SQL Server “Peer to Peer Transactional Replication” in SQL Server 2012 by replacing existing SQL Server 2008 Transactional Replication.
• Modified the Database Design and Tracker tool to scalable for globalization to support multiple languages.
• Working on the Tracker Master Database and over 600 Company Databases to improve the performance of the Tracker reports.
• Supporting the Applications in SIT and UAT environment and also in Production Support.
• Core member in Code review team and deployment of applications related to database stuff.

Environment: SQL Server, SSIS, SSRS, C#, Visual Studio 2012, Visual Studio Team Foundation and GIT.

Confidential, Redmond, WA

Responsibilities:

• Worked in Confidential CFIT team to develop Confidential product “Plancast” used for Confidential Forecast and Budget process.
• Database architecture design for Onboarding new application into Plancast product.
• Provided Production and UAT Support for Confidential Plancast (Forecast and Budget) Application.
• Worked on improving the performance of Plancast Application by creating Index and rewriting T-SQL queries & Stored Procedures.
• Implementing the Changes Requests (CRs) created by the Business Users to improve the Application Features.
• Created OLAP cubes in SQL Server Analysis Services (SSAS) and deployed to the necessary servers.
• Worked on regular Database Backups and Restore in different environments using production Dumps.
• Developed Generic Architecture to implement business calculation on Confidential Revenue and expenses.
• Developed ETL framework to pull the data from various sources like MS Sales, Mercury and OLTP etc.
• Involved in supporting the Applications in SIT and UAT environment and also in Production Support.
• Involved in Code review and deployment of applications.
• Worked with IXP team to develop a product DxMetrics BI System, the Major Feature Group of DxPlatform in Information Experience Platform (IXP) - Content Publishing of Confidential .
• Involved in the Product Design, Data Analysis of DxMetrics System and Impact Analysis of Dependent Feature groups.
• Worked as Scrum Master with Agile process for DxMetrics product development
• Developed DxMetrics Client Workspace plug-in using C# with WPF.
• Developed WPF DxMetrics Repotting Module to support the customer metrics on Confidential TechNet publishing.
• Developed Restful WCF Web Services and Hosting Web Service on IIS for Data Access layer to provide flexibility to access by all the feature groups of DxPlatform.
• Developing ETL Layer to pull the data from the different sources and store in BI Data Warehouse.
• Involved in the Analysis and review of Functional Specifications documents for Laminar application.
• Involved in JAR meeting to analyze the impacts on existing system for proposed changes.
• Created Technical Specification documents for the application Laminar 1.4 and EMC SMC Sync for OLS Overages.
• Involved in developing UI for EMC Tool to configure Localization using WPF in C#.Net
• Created Technical Specification documents for the changes for EMC SMC Sync for OLS Overages.
• Modified the existing SSIS package to sync the data between multiple servers for OLS Overages- EMC SMC Sync application to accommodate the new business logic.
• Created New Stored procedures and modified the existing stored procedures to implement OLS Overages changes for EMCSMCSync application
• Created and managed Indexes to improve the performance of T-SQL queries in Stored Procedures for Laminar Application.
• Involved in proposal of Re-Design the EMCSMCSync process to avoid the redundancy of the process flow and also to improve the execution time to avoid the delay in sync process.
• Developed Stored Procedures, User Defined Functions, Non-DDL Scripts and Views based on the functional requirements.
• Modified the Existing Stored procedures according to Change Request (CR) created by business team.
• Created and modified SSIS Packages for migrating large amounts of data between different servers and deployed them on to necessary Testing and UAT servers.
• Created the release builds and preparing patches to the builds and release them to the appropriate Testing Environments and uploaded the code in VSTF.
• Involved in Build Verification Test (BVT) after build is released and ran the automated test scripts to check the functional for the code changes.
• Involved in supporting the Applications in SIT and UAT environment and also in Production Support.
• Involved in Code review and deployment of applications.
• Backup and Restore Databases in different environments using production Dumps.

Environment: SQL Server 2012/ 2008, SSIS, SSRS, C#, Visual Studio 2012/ 2010, Visual Studio Team Foundation.

Confidential, Fort Worth, TX

Responsibilities:

• Involved in the architectural design of the software and developed the functional prototype.
• Designed Data Flow Diagrams and Process Flow diagrams using Confidential Visio.
• Involved in Database Design and Database Modeling to create Database Tables including Staging and lookup tables.
• Created Complex Views, Stored Procedures and User Defined Functions and Triggers
• Involved database tuning to improve the performance of database using SQL Profiler.
• Migrated SQL Server 2000 DTS packages into SQL Server 2005 SSIS packages.
• Configured into SQL Server Integration Services (SSIS) packages using Package configuration wizard
• Created ActiveX Scripts for SSIS packages to pass dynamic Command Line and Arguments for Batch Process Tasks in Expression reading from database table and Global Variables.
• Created Error Logging in SQL Server Integration Services (SSIS), so that Error Code, Error Description is saved to the tables in the database.
• Created complex SSIS packages and done work around to solve issue to read text files which are having different number of columns created by Essbase applications.
• Involved in large scale Enterprise Data warehouse (EDW) Database and created Dimensional tables and Fact /Measure tables using Star Schema and Snowflake Schemas.
• Responsible for creating complex OLAP cubes in SQL Server Analysis Services (SSAS) and deployed to the necessary servers.
• Created Excel Reports using VB script with SSAS Cubes Data connections in Excel 2007.
• Created Reports in SQL Serve Reporting Services (SSRS) for populating the Forecast data using SSAS Data source.
• Involved in deployment of SSIS Packages in the Production environment and maintenance of the production Support.

Environment: SQL Server 2005/ 2000, SSIS, SSAS, DTS, C#, ASP.Net, Visual Studio 2005, IIS 6.0, VSTF.

Confidential, Plano, TX

Responsibilities:

• Involved in requirement gathering sessions from several Interfacing teams.
• Created Database Diagrams for management approval of Database design.
• Designed and Created Database Tables and assigning Permissions for the Users.
• Created Complex Views, Stored Procedures, User Defined Functions and Triggers.
• Created SQL Agent Jobs and Scheduling Jobs in SQL Server 2005 database.
• Involved in database Tuning and Improve the performance of database using SQL Profiler.
• Developed ETL application using SSIS packages to get data from different sources and load into SQL server 2005 database using SQL Server Integration Services (SSIS).
• Developed Matrix Reports in SSRS for the RTL Daily Sales Reports and Revenue Reports using multiple parameter selection.
• Developed Star Schema and Snowflake Schemas for Enterprise Data Warehousing.
• Involved in Developing Win Forms for P24 application Toll Violation Match process using C#.
• Developed Windows application to validate comma separated file to avoid data issues in input file using C# with Visual Studio.
• Configured Web Applications and worked with IIS Administration to configure APP Pool and Web App access permission authentication.
• Developed sub reports in SSRS with the URL link option to navigate to the multiple reports upon selection to know the status of the Toll Violation Disputes of the Customer.
• Involved in taking backup and managing the data with multiple servers with Ship Transactional Logs.
• Developed the Business Intelligence SharePoint Portal by Adding Reporting links and Reporting Project status on the SharePoint Server.
• Designed, Developed and Published Web Pages with Web parts in Confidential Office SharePoint Server.
• Involved in Integration of SQL Reporting Services with SharePoint Portal.
• Created Replication of Database using Snapshot and Transactional Replication for coping the data from one server to another server.
• Responsible for off-shore team co-ordination.
• Responsible for Integration of Database Objects which were developed by Off-shore Team.
• Involved in various phases of testing such as unit testing, integration testing & UAT.
• Production Support and Maintenance of the ETL application and Core process of business process.
• Scheduling and monitoring the tasks assigned to the team members at onsite and offshore.

Environment: SQL Server 2005, SSIS, SSRS, C#, ASP.Net, MOSS 2007, Visual Studio 2005, IIS 6.0, VSS.

Confidential, Hartford, CT

Responsibilities:

• Worked with top level management to gather the requirements.
• Developed the prototype for ITG Reporting Tool in ITG Refresh Application.
• Responsible for writing SQL Queries and Fine-tuning of the database.
• Created Views and Stored Procedures, User Defined Functions and Database Triggers.
• Created and Migrated DTS packages into SSIS packages from SQL server
• Responsible for Performance Tuning the Database Objects for better performance of the system.
• Developed custom reports using SQL Server Reporting Services (SSRS).
• Involved in tracing the database objects in SQL Profiler for maintaining the performance of the database.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Designed and Developed Win Forms to grab the data from various databases and to generate the reports in Visual Studio Tools for Office Excel format for ITG Reporting Tool using C#
• Responsible for submitting the weekly project status document to upper level management.
• Responsible for managing resources worked in the team.
• Involved in various phases of system testing such as unit, integrated, acceptance and regression testing.

Environment: SQL Server, SSIS, SSRS, SSAS, C#, ASP.Net, MOSS 2007, Visual Studio 2005, IIS 6.0, VSS.

Confidential, Salt Lake City, UT

Responsibilities:

• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Responsible for maintaining the Confidential Applications.
• Finding solution to the production issues within SLA (Service Level Agreement).
• Developing Stored Procedures, functions and Triggers in SQL Server 2000.
• Performed optimization techniques for the Stored Procedures and Complex Queries to improve the performance.
• Created Test and Development Databases, maintained and updated the tables based in the requirement.
• Developed Data warehousing Database in SQL Server for maintaining the fact, dimensional and aggregated tables for Sales Team.
• Developed DTS Packages for extracting the data from Oracle Data Mart and loading the data to the SQL Server Database.
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Environment: SQL Server 2000, Confidential Visual Basic 6.0, MS Visual Studio 6.0, COM, Visual Source Safe.

Confidential

Sr. Software Engineer / Tech Lead

Responsibilities:

• Involved in analysis & design of the system that included an extensive interaction with the end user and prepared the document for proposed system, which includes work estimation.
• Developed Win Forms and integrated these forms with Windows Services.
• Designed the functional prototype and presented to end users to get further approvals.
• Responsible for the Oracle administration, which included creation and Fine-tuning of the database, backup and restore.
• Responsible for submitting the weekly project status document to upper level management.
• Involved in development of N-tier Architecture.
• Developed ActiveX COM Components to reuse in different modules of application.
• Responsible for creating DLL for report design in HTML format and calling them from ASP pages to provide more security for reports.
• Involved in configuring and using DCOM application using MTS architecture.
• Responsible for creating Stored Procedures in Oracle database.
• Responsible for managing resources worked in the team.
• Involved in various phases of system testing such as unit, integrated, acceptance and regression testing.

Environment: Confidential Visual Basic 6.0, ASP 3.0, Active X, COM, Oracle 8.x, PL/SQL, SQL, Visual Source Safe, Crystal Reports, Visual Interdev, IIS 4.0, HTML, SQL Server, JavaScript, VB Script, Scanning & ICR Software