PROFESSIONAL SUMMARY:

• 10 Years of diverse experience in Confidential .NET Technologies, MSBI and MS Azure Cloud computing.
• Extensively used Azure Data Factory V1 & V2 to ingest data from multiple sources.
• Developed Azure Data Factory Pipelines, linked services, data sets, deploy and monitor them
• Scheduling/enabling triggers for the ADF Pipelines developed.
• Great hands on experience on Power BI , various SQL Server Services like Integration Services (SSIS) and Reporting Services (SSRS).
• Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Experience in writing Scope Scripts to deal with Cosmos VIEWs and Raw Data.
• Expertise in writing Constraints, Indexes, Views, Stored Procedures and User Defined Functions.
• Good knowledge on SQL Azure and SQL Server in Azure VM and ability to migrate on - prem SQL Server to SQL Server in Azure VM.
• Experience in Extracting, Transforming and Loading (ETL) data from SQL, Excel, Flat file, OData to SQL Server by using ADF, SSIS services , PowerShell Scripts.
• Good exposure on Kusto .
• Ability to import data from RESTful APIs (VSTS APIs and OData) through C#/Windows PowerShell and build own SQL DB.
• Knowledge on Azure Cloud Service (PaaS & IaaS), Web Apps, Express Route.
• Good experience in hosting applications in cloud using Confidential Azure.
• Knowledge in modern web protocols: JavaScript, XML, PowerShell scripting, RESTful web services.
• Expert in creating simple and parameterized reports and complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs using SSRS.
• Experience in Using Different Tools like Beyond Compare and Fiddler.
• Experience in using Team Foundation Server(TFS), Source Depot.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS:

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

.NET Technologies: WinForms, ASP.NET Web Forms, ADO.NET, Web Services, LINQ to SQL, AJAX, Web API, .NET Framework

Scripting Languages: Windows Power shell, SCOPE Script, JavaScript

Cloud services: Confidential Azure, Windows Azure SDK, IaaS, Azure Data Factory

IDE Tools: Visual Studio 2010/2008/2005 , VS Data Tools, SSMS

Databases: MS SQL SERVER 2014/2012/2008/2016 , COSMOS

Reporting Tools: Power BI, SQL Server Reporting Services (SSRS), SSIS

Servers: Windows Server 2003/NT, Confidential IIS (7.0/6.0/5.0/4.0 )

Web Servers: IIS 7.0/6.0

Version Control Tools: Team Foundation Server(TFS), Source Depot

Project Methodologies: Agile(Scrum), Waterfall

WORK EXPERIENCE:

Confidential

Technical Specialist (Lead)

Responsibilities:

• Responsible in End to End process starting from Data generation to Visualization
• Responsible for gathering/refining requirements from the customer and analyzing accordingly for business requirement.
• Generated multiple Power BI reports and Dashboards for different teams.
• Extensively used Azure Data Factory, created Linked Services on multiple data sources.
• Developed Azure Data Factory Pipelines, linked services, data sets, deploy and monitor them
• Scheduling/enabling triggers for the ADF Pipelines developed.
• Created complex pipelines for data transformation from multiple sources.
• Using ADF, SSIS and PowerShell scripts Migrated data from different sources like: Cosmos, OData, Excel, Flat file in Sharepoint path, VSTS APIs, Stripe DB etc. to SQL DB.
• Managed Power BI Group Workspace, Content Pack, OneDrive services to manage the PBIX files and report sharing across the team.
• Extensively used Power BI Desktop, Personal Gateway, Enterprise Gateway and direct connect (SQL Azure) for refreshing the data.
• Using PowerShell pull the deployment status (WMI data) from large batch of servers and generate CSV file and exporting this CSV data to SQL Table
• Using C# read the VSTS REST APIs and export data to SQL Table.
• Used VS Data Tools the Integration Services packages to get data into the database
• Familiar in writing scope scripts to import data from COSMOS VIEWS
• Scheduled Sangham Job to import data from Cosmos Structured Stream to SQL
• Migrated On-Prem SQL Server to SQL Server in Azure VM. Handled all jobs and connection issues for further data synchronization.
• Using Azure Express Route joined On-Prem local server with Azure VM, it helped to connect local SQL Server seamlessly without permission issues.
• Maintained Azure Server for Creating Websites, Database Storage, Uploading Certificates, Adding Resource group and creating the Subscriptions.
• Imported Incidents data from Kusto Clusters using Kusto queries and visualized in Power BI.
• Power BI report on System Center Configuration Manager (SCCM) data
• Expertise in developing Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Scheduled SQL jobs to run SSIS packages, PowerShell scripts to import data from different sources to SQL Server. Expertise in adding cascading parameters, drilldown, and drill through reports.
• Used SQL Jobs for period refresh and used SQL Server Database Mail to send email notifications.
• Created and administered all SQL Server databases, objects, logins, users, and permissions in each registered server.
• Creating Views, Stored Procedures, Configuration files in SQL to get the data into the dashboards.
• Closely work with many teams to help improving the team performance and targeting for the SLA attainment.

Confidential

Team Lead

Responsibilities:

• Leading and building Windows Azure Support (WASU) team in China for Mooncake ( Confidential Azure National cloud in China)
• Worked as Technical Consultant and SME of Confidential Azure Support Operations
• Identifying and fixing the parity between public cloud and national cloud operations
• Coordinating Production Support team in effectively identifying and resolving the defects.
• Improving the Support process through automated applications.
• Implementing new process and Tools to investigate / fix the customer reported issues and proactively identified issues. ensuring quality of deliverables.
• Measurement & Analysis of the KPI, feedbacks, reporting.
• Facilitating training on Azure architecture and different internal components of Windows Azure.
• Facilitating training and assisting on setting up environment for Azure Support process.
• Troubleshooting and Resolving customer reported issues as per SLA agreement
• Deep Investigation and root cause analysis of the windows azure production Issues
• Preparing the training documents and played mentoring role for team members and new joiners.

Confidential

Technical Specialist

Responsibilities:

• Involved in the Production Support activities along with the development work and troubleshooting the user problems.
• Developing tools for monitoring the health of the Azure datacenter machines Troubleshooting and Resolving customer issues as per SLA’s
• Deep Investigation and root cause analysis of the windows azure production Issues
• Finding out the critical bugs which cause customer impact and fixing them.
• Troubleshooting the customer reported incidents and resolving based on user errors, platform errors or any external error.
• Involved in Design and Developing components of the applications using ASP.NET, MVC, C#.NET, JavaScript, JQuery, XML.
• Maintained Azure Server for Creating Websites, Database Storage, Uploading Certificates and creating the Subscriptions.
• Developed Views, controllers and business logic models using C#.
• Worked on creating Rest Services using ASP.NET Web API and C#.
• Used LINQ to SQL as the data provider for communicating with the SQL Server Database.
• Maintained Application state using Cookies, Application object and Caching.
• Written T-SQL Queries, Stored Procedures for the SQL Server backend.
• Worked on Query Optimization of the SQL Server T-SQL queries and optimized the applications
• Worked with different tools like Beyond Compare for comparing the Code Repository, File Zilla for uploading the Missing files in the Server and Fiddler for Debugging and Analyzing the Issue
• Managed, maintained Build and deployed to Test and PROD environments
• Responsible for Testing and deploying solutions to the cloud by using Confidential Azure.
• Preparing the training documents and played mentoring role for team members and new joiners.
• Involved in Background Grooming, Sprint Planning and retrospective meetings.
• Worked on Agile/Scrum methodology and actively participated in daily scrum meetings.
• Exporting and importing the data migration within different environments by using data migration tool.

Confidential

Technologies: ASP.NET, C# and Synergy

Development and Testing

Responsibilities:

• Involved in Use case analysis meeting & Risk Analysis meetings with Client
• For certain modules involved in End to End development.
• After development involved in Unit Testing & Code Review.
• Involved in Analysis, Estimation & Fixing of change request.

Confidential

Technologies: ASP.NET3.5, C#.NET, JavaScript, Ajax, Enterprise Library, SQL Server, XML, XSL, MML, Interleaf LISP API, Java, VB6, HTML.

Development and Testing

Responsibilities:

• Form validations using JavaScript
• Involved in writing Style Sheets
• Implementing web services
• Involved in development of Administrator and Import/Export modules.
• UI design and validation using Java Script
• Involved in Graphic conversion.
• Validating the output Xml file with schema and checking wellformedness of XML.