SUMMARY

• Enterprise Technology professional with more TEMPthan 20 years of experience in Enterprise Architecture, Requirement Analysis, Designing, Development and Project Delivery.
• 10+ years’ experience as Manager, Project Lead, Architect (Application & Enterprise) and Database Administrator.
• 8+ years as Azure architect using service and hosting solutions such as private/public cloud PaaS and SaaS platforms. DevOps engineer and with a primary focus on Azure DevOps, CI/CD.
• Extensive experience as Azure Architect / DevOps engineer and with a primary focus on Azure DevOps, CI/CD.
• Extensive experience in Business Analysis and Agile Project Management
• Database/Application health and performance monitoring experience using services such as application insight
• Experienced SQL Server Database Administrator/ BI Developer - MS SQL Servers 2016/2012/2008 R2/ 2005/ 2000 Applications with huge Terabyte databases and support in Production Environments.
• Experienced Microsoft Azure Cloud Services including create and manage Azure Resource groups, Azure Elastic Pool, and Azure SQL Databases.
• Experienced in creating and managing Azure SQL Databases/Data Warehouse and Azure Virtual Machines.
• Well versed in Azure Data Lake / Data Factory to migrate and transfer data from On-Prem database to Azure cloud.
• Experience in Dashboards and Interactive Reports with Azure Power BI using teh Azure SQL databases.
• Experience on High Availability and Disaster Recovery, Failover Cluster and Always on Availability Groups.
• Experience with Clustering, Mirroring, Transactional Replication and Peer to Peer Transactional Replication.
• 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.
• 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 autantication and rebuilding a damaged IIS Installation and Creating IIS Configuration backups.
• 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.

TECHNICALSKILLS

Could: Microsoft Azure, Power BI, Data Lake, Data Factory, Azure Dev Ops

Database: MS SQL Server 2019 / 2016 / 2012 / 2008 R2 / 2005 /2000, Oracle 9i / 8.0, MS Access

BI Stack: SSIS, DTS, SSAS, SSRS

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

Scripting Languages: PowerShell, Python, VB Script, Java Script, Kusto.

PROFESSIONAL EXPERIENCE

Confidential

Database Administration Manager

Responsibilities:

• Managing 150 + SQL IAAS SQL Server Databases on over 30+ Azure Virtual Machines.
• Managing DBA team Onsite and Offshore with 24 X 7 support on Azure Databases and applications.
• Managing Tier 1 support with consulting company on legacy and Confidential Modern applications.
• Migrated SQL Server On-prem servers into Azure VMs in IAAS and Migrated Databases into Azure Databases in PAAS.
• Working on provisioning Azure Virtual Machines and configuring NSG, Vnet and Subnets.
• Worked on Azure App Insights, Log Analytics & Metric Alert Rules for monitoring Database performance, usage, and activity.
• Creating Power Shell Scripts to automate teh database activities like Maintenance tasks etc.
• Working experience with Google Cloud Platform Big data queries.
• Working with Terraform scripts to create and maintain teh resources in Azure.
• Working with Rapid7 (Nexpose) application to Monitor and solve Azure Security Center Vulnerabilities.
• Working with IDERA monitoring tool to monitor teh Servers and Database performance and Alerts.
• Working on Patching Windows and SQL Server updates and features on monthly update from Microsoft.
• Supporting teh Applications in Development environment and Production Support.
• Working with COSMO ticketing system to release teh scripts and deploy teh code on all environments.
• Working with Azure DevOps for Source Control and pull requests and release teh builds.
• Using JIRA for planning and managing teh project stories and task in agile process.

Environment: Microsoft Azure, Azure SQL Database, GCP, GIT, JIRA, IDERA, Rapid7 (Nexpose) and SolarWinds.

Confidential, Hanover, MD

Azure Architect / Lead Azure SQL DBA

Responsibilities:

• Managing 150 + SQL IAAS SQL Server Databases on over 30+ Azure Virtual Machines.
• Migrated SQL Server On-prem servers into Azure VMs in IAAS and Migrated Databases into Azure Databases in PAAS.
• Working on provisioning Azure Virtual Machines and configuring NSG, Vnet and Subnets.
• Worked on Azure App Insights, Log Analytics & Metric Alert Rules for monitoring Database performance, usage, and activity.
• Creating Power Shell Scripts to automate teh database activities like Maintenance tasks etc.
• Working experience with Google Cloud Platform Big data queries.
• Working with Terraform scripts to create and maintain teh resources in Azure.
• Working with Rapid7 (Nexpose) application to Monitor and solve Azure Security Center Vulnerabilities.
• Working with IDERA monitoring tool to monitor teh Servers and Database performance and Alerts.
• Working on Patching Windows and SQL Server updates and features on monthly update from Microsoft.
• Supporting teh Applications in Development environment and Production Support.
• Working with COSMO ticketing system to release teh scripts and deploy teh code on all environments.
• Working with Azure DevOps for Source Control and pull requests and release teh builds.
• Using JIRA for planning and managing teh project stories and task in agile process.

Environment: Microsoft Azure, Azure SQL Database, GCP, GIT, JIRA, IDERA, Rapid7 (Nexpose) and SolarWinds.

Confidential, Plano, TX

Lead Azure SQL DBA

Responsibilities:

• Configured Azure Resources like creating Azure Elastic Pools, Resource Groups and Virtual Machines.
• Created Azure databases and Azure Data warehouse.
• Automated teh various processes with Runbooks and scheduling them.
• Worked on Azure App Insights, Log Analytics & Metric Alert Rules for monitoring Database performance, usage and activity.
• Created Azure Data Lake/ Data Factory to load teh data into Azure DW from various sources in Azure Data Lake
• Created deployment Scripts with Azure Resource Manager (ARM) Template to create and deploy teh Azure Resources.
• Created Power Shell Scripts to automate teh database activities like Maintenance tasks etc.
• Implemented Azure Security Center Vulnerability Rules.
• Provide access on teh database using Active Directory users and roles.
• Implemented Database Design and Database Modeling to create Database Tables.
• Performing Database Tuning to improve teh performance of databases and Reports.
• Supporting teh Applications in Development environment and Production Support.
• Worked with Azure DevOps for Source Control and pull requests.
• Using JIRA for planning and managing teh project stories and task in agile process.
• Supporting teh Applications in SIT and UAT environment and also in Production Support.

Environment: Microsoft Azure, Azure SQL Database, C#, Visual Studio 2017, GIT and JIRA.

Confidential, Bellevue, WA

Sr. SQL DBA / Azure Data Engineer

Responsibilities:

• Worked with Legal division of Confidential to provide teh solutions for “Legal Tracker Application” formerly known as “Serengeti Law” which provides Legal Matter Management, e-Billing and analytics for corporate companies.
• Working on Application Insights for creating and monitoring Legal Tracker statistics.
• Working on configuring teh Azure cloud resources like creating Azure Elastic Pools, Resource Groups and Virtual Machines.
• Working on creating Azure Cloud databases and assigned to teh Azure Elastic Pools.
• Working on Azure Resource Manager (ARM) Template to create and deploy teh Azure Resources.
• Working on Azure Data Lake/ Data Factory to migrate On-Prem SQL Server database into Azure SQL Server Databases
• Working on Power Shell Scripts to automate teh resource creation.
• Worked on Power BI report for teh customer report and Admin Reports using Azure SQL Server Databases as source.
• Developed teh SSIS ETL packages to push teh data into Azure Could database from teh exiting OLTP production databases.
• Expert in Implementing High Availability Solutions for MS SQL Server Environments. Including SQL Server Always-On High Availability.
• Installation of Replication Server, Configuration and Monitoring teh replication, implemented Transactional Replication writing scripts for automation, for creating publications, articles and running teh snapshot agent job, so that teh same scripts can be used from system test to production.
• Implemented Patch framework 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 teh 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 teh Database Design and Tracker tool to scalable for globalization to support multiple languages.
• Working with Azure DevOps for Source Control and pull requests.
• Working on teh Tracker Master Database and over 1500+ Company Databases to improve teh performance of teh Tracker reports.
• Supporting teh 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 2012 / 2008, SSIS, SSRS, C#, Visual Studio 2012, Visual Studio Team Foundation and GIT and JIRA.

Confidential, Redmond, WA

Sr. Software Development Engineer

Responsibilities:

• Worked in Microsoft CFIT team to develop Microsoft product “Plancast” used for Microsoft Forecast and Budget process.
• Database architecture design for Onboarding new application into Plancast product.
• Provided Production and UAT Support for Microsoft Plancast (Forecast and Budget) Application.
• Worked on improving teh performance of Plancast Application by creating Index and rewriting T-SQL queries & Stored Procedures.
• Implementing teh Changes Requests (CRs) created by teh Business Users to improve teh Application Features.
• Created OLAP cubes in SQL Server Analysis Services (SSAS) and deployed to teh necessary servers.
• Worked on regular Database Backups and Restore in different environments using production Dumps.
• Developed Generic Architecture to implement business calculation on Microsoft Revenue and expenses.
• Developed ETL framework to pull teh data from various sources like MS Sales, Mercury and OLTP etc.
• Involved in supporting teh 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, teh Major Feature Group of DxPlatform in Information Experience Platform (IXP) - Content Publishing of Microsoft.
• Involved in teh 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 teh customer metrics on Microsoft TechNet publishing.
• Developed Restful WCF Web Services and Hosting Web Service on IIS for Data Access layer to provide flexibility to access by all teh feature groups of DxPlatform.
• Developing ETL Layer to pull teh data from teh different sources and store in BI Data Warehouse.
• Involved in teh Analysis and review of Functional Specifications documents for Laminar application.
• Involved in JAR meeting to analyze teh impacts on existing system for proposed changes.
• Created Technical Specification documents for teh 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 teh changes for EMC SMC Sync for OLS Overages.
• Modified teh existing SSIS package to sync teh data between multiple servers for OLS Overages- EMC SMC Sync application to accommodate teh new business logic.
• Created New Stored procedures and modified teh existing stored procedures to implement OLS Overages changes for EMCSMCSync application
• Created and managed Indexes to improve teh performance of T-SQL queries in Stored Procedures for Laminar Application.
• Involved in proposal of Re-Design teh EMCSMCSync process to avoid teh redundancy of teh process flow and also to improve teh execution time to avoid teh delay in sync process.
• Developed Stored Procedures, User Defined Functions, Non-DDL Scripts and Views based on teh functional requirements.
• Modified teh 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 teh release builds and preparing patches to teh builds and release them to teh appropriate Testing Environments and uploaded teh code in VSTF.
• Involved in Build Verification Test (BVT) after build is released and ran teh automated test scripts to check teh functional for teh code changes.
• Involved in supporting teh 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

Sr. Software Engineer

Responsibilities:

• Involved in teh architectural design of teh software and developed teh functional prototype.
• Designed Data Flow Diagrams and Process Flow diagrams using Microsoft 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 teh 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 teh tables in teh 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 teh 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 teh Forecast data using SSAS Data source.
• Involved in deployment of SSIS Packages in teh Production environment and maintenance of teh production Support.

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

Confidential, Plano, TX

Sr. Software Engineer / DBA

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 teh 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 teh 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 teh 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 autantication.
• Developed sub reports in SSRS with teh URL link option to navigate to teh multiple reports upon selection to know teh status of teh Toll Violation Disputes of teh Customer.
• Involved in taking backup and managing teh data with multiple servers with Ship Transactional Logs.
• Developed teh Business Intelligence SharePoint Portal by Adding Reporting links and Reporting Project status on teh SharePoint Server.
• Designed, Developed and Published Web Pages with Web parts in Microsoft Office SharePoint Server.
• Involved in Integrationof SQL Reporting Serviceswith SharePoint Portal.
• Created Replication of Database using Snapshot and Transactional Replication for coping teh 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 teh ETL application and Core process of business process.
• Scheduling and monitoring teh tasks assigned to teh 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

Sr. Database Developer

Responsibilities:

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

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

Confidential, Salt Lake City, UT

Sr. Software Engineer

Responsibilities:

• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Responsible for maintaining teh Confidential Applications.
• Finding solution to teh production issues within SLA (Service Level Agreement).
• Developing Stored Procedures, functions and Triggers in SQL Server 2000.
• Performed optimization techniques for teh Stored Procedures and Complex Queries to improve teh performance.
• Created Test and Development Databases, maintained and updated teh tables based in teh requirement.
• Developed Data warehousing Database in SQL Server for maintaining teh fact, dimensional and aggregated tables for Sales Team.
• Developed DTS Packages for extracting teh data from Oracle Data Mart and loading teh data to teh 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, Microsoft 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 teh system that included an extensive interaction with teh end user and prepared teh document for proposed system, which includes work estimation.
• Developed Win Forms and integrated these forms with Windows Services.
• Designed teh functional prototype and presented to end users to get further approvals.
• Responsible for teh Oracle administration, which included creation and Fine-tuning of teh database, backup and restore.
• Responsible for submitting teh 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 teh team.
• Involved in various phases of system testing such as unit, integrated, acceptance and regression testing.

Environment: Microsoft 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 ScriptScanning & ICR Software