Unleashing data insights using the latest technology
High impact Technical Program Manager and Data Architect. Experienced in data driven development and business critical service management. Have extensively worked as Data consultant/solution architect delivering database, business intelligence and analytics solutions. Proficient in driving business and technical partnerships and delivering results with software and service engineering teams.
Work Authorization: Canada (Permanent Resident)
Microsoft SQL Server, SQL Server Performance Tuning & Optimization, High Availability & Disaster Recovery, SQL Server Replication, Service Broker, NoSQL, ELK (Elasticsearch)
Cloud/Azure: SQL Azure Database, Azure Machine Learning, Stream Analytics, HDInsight, Event Hubs, Data Catalog, Azure Data Factory (ADF), Azure Storage, Microsoft Azure Service Fabric, Azure Data Lake (ADLA/ADLS)
Program Management: Strategic Planning, Agile Software Development, SCRUM Methodology, Product Development and Release management.
Business Intelligence: SQL Server Analysis Services (Tabular & Multidimensional), Data Mining, SSIS (ETL), SQL Server Reporting Services, Data Modelling, SharePoint Integration, Self Service BI with SQL Server (Power BI), Enterprise Information Management (DQS & MDS), Master Data Management Solutions (MDM), SharePoint Administration
Solution architect in Database and BI technologies.
Design and architect systems and services to manage, operate and support the MS Sales working with internal engineering teams.
Leading two teams, driving the Infrastructure and Database engineering for the environment.
Projects: Design and maintain the Data Analytics infrastructure for Worldwide Operations.
Leading two teams driving the SQL Server and BI infrastructure and data platform Drive DevOps implementation in the environment with support and engineering teams Own and drive projects to optimize performance by enhancing the architecture Plan and implement Azure Migration of on premise servers and application Design and implement Telemetry solution for monitoring overall services health.
SQL Service Engineer/ Solution Architect (SQL Server & BI)01/2014 to 01/2016
As a Program Manager/Service Engineer in Database and BI technologies, Designs and architect systems and services to manage, operate and support for the Microsoft Product Release Services working with internal engineering teams.
Drive DevOps model implementation.
Accomplishments: Designed and implemented the telemetry architecture for the Power BI infrastructure for the application Service analysis to define the KPI for the services and build analytics on the KPIs Managed the relationship with the Product group to stabilize the SQL Server environment Implementation of DevOps model to create collaborative environment for software engineering and Operations/Service engineering.
Designed and implemented telemetry data pipeline using Elasticsearch cluster, Xpert and Cosmos.
SQL Server environment stabilization by performance tuning and design enhancement Develop and maintain monitoring solution for the environment using Elasticsearch, PowerBI and SCOM Monitoring and Alerting for Codesign using ElasticSearch, Asimov/xpert and Cosmos.
Premier Field Engineer01/2011 to 01/2014Database & Business Intelligence Microsoft UK
Delivered onsite, remote and dedicated support services in SQL Server and BI, for Premier customers around the world to promote health in their IT environments.
As part of Customer Support Services, partnered with Commercial Technical Support and Enterprise Services to strengthen the Microsoft Services field engineering.
Accomplishments: Architected the SQL Server consolidation solution for large environments like Nomura Holdings, UK Optimized business critical environments of Ladbrokes, EasyJet for SQL Server and SSAS performance Self Service BI End to End Implementation Consultant at ARUP International, UK Database Performance Consultant for SQL Server Integration with SharePoint 2013 project at HSBC Inc, UK Performance tuning of OLTP SQL Server at Nationwide Building Society, UK SQL Server environment review and performance tuning at National Bank of Iceland, Iceland.
01/2007 to CurrentMicrosoft CorpRedmond, WA
Designed and implemented the telemetry system using Elasticsearch, Cosmos for Codesign service.
Designed and implemented the MIS using Power BI and SharePoint for Ove Arup International.
Built the anomaly detection service from CodeSign telemetry data using Azure Machine Learning SQL Server solution design and optimization for the SharePoint implementation at HSBC Inc, UK.
Built the SQL Server consolidation strategy for the Nomura Inc SQL Server team.
Implemented Azure HADR solutions for the WW Ops BI Platform for Microsoft.
Program Management and Service Delivery Collaborated with MCS and TAM community to deliver consistently high customer satisfaction Designed the Power BI implementation for Code Signing in Microsoft, service monitoring Managed the relationship with the Product group to stabilize the SQL Server environment at WW Ops BI.
Implemented DevOps model to enhance service quality for Software Engineering and Operations.
Migration to Azure platform for the Worldwide Ops BI platform infrastructure at Microsoft.
Managed the Database and BI Infrastructure for the Worldwide Ops BI Team at Microsoft.
Delivered POC and pilot projects on Azure backup, Azure Data Lake and Azure Datawarehouse Database and Business Intelligence Consulting Established the Business Intelligence practice in the Microsoft UK PFE business Developed SQL Server & BI workshops for critical environments like VISA, Unilever, Merrill Lynch/BofA etc Designed SQL Server consolidation solution for large environments like Nomura Holdings, UK Optimized LOB applications at Ladbrokes, EasyJet, Nationwide, Unilever etc., for SQL Server performance Optimized the SQL Server environment by consolidation at Worldwide Ops BI at Microsoft Performance assessment and optimization of SQL Server and SSAS environment for multiple big customers like Unilever, Philip Morris, Gazprom, Atos, HSBC Inc, BNP Paribas, Nedbank etc.
Developed and Delivered Perf tuning and optimization clinic as service to Microsoft customers in Europe.
Developed the BI Academy as a service for the customers onboarding to Microsoft BI Platform.
Tech Lead01/2007 to 01/2011
GTSC SQL Server & Business Intelligence Support) (Microsoft India As part of the SQL Support team, was responsible for delivering high quality SQL Server solutions for Microsoft customers.
Utilizing knowledge of the customer environment, we delivered timely and high quality solution, root cause analysis of complex issues and proactive health improvements.
Effectively led a team of 12 engineers to provide consistent results year over year.
Accomplishments: Created and managed one of the most viewed blogs on SQL Server (http://blogs.msdn.com/sqlserverfaq ) Technical leadership for the team as the escalation resource and SME Multiple ACE (Architects of Excellence) awards in Product Support Services for Microsoft SQL Server.
System Analyst01/2006 to 01/2007Tech Mahindra Satyam Computer Systems Limited
SQL Server SME and team lead for Merrill Lynch Database Support Team.
Analyst & Team Lead01/2003 to 01/2006Infosys TechnologiesHyderabad, India
Managed the Remote IT Change Management for the worldwide offices of Microsoft Corporation from inside the Microsoft Global Delivery Centre, India (GDCI).
The team provided 24*7 supports for the datacenters worldwide with a team of more than 40 members.
Engineering Consultant01/2001 to 01/2003VM EngineersNew Delhi, India
for the heavy industry.
Education and Training
Bachelor of Engineering: Mechanical Engineering2001North Orissa UniversityMechanical Engineering