Experience

• 

  Tata consultancy services

  Dec 2012 - Feb 2016

  System engineer

  - Achieved a 45-minute performance enhancement by fine-tuning existing stored procedures, significantly improving system efficiency.- Earned three "On the Spot" awards for outstanding contributions to projects and team success.- Orchestrated a seamless upgrade of the data processing server from SQL Server 2008 to SQL Server 2012, automating tasks with a custom PowerShell script for efficient execution.- Implemented Delta load functionality for flat files, resulting in a 30-minute performance boost and enhanced data processing capabilities. Show less

• 

  Egain corporation

  Feb 2016 - May 2017

  Software engineer 1

  - Worked on SQL Server- Worked on adding support for Always on “Availability group” to improve system robustness.- Cleaned up system so as to be able to use filtered index.- Automated creation of SSIS catalog using Powershell while installing the application.- Added support for giving Data Extracts using “Change Tracking” feature of SQL.

• 

  Tsys

  May 2017 - Apr 2018

  Senior distributed database administrator

  - Creating/modifying stored procedures, views and other database objects as per business requirements.- Review code written by team members.- Maintain and troubleshoot issues of data replication between main and reporting server.

• 

  Microsoft

  Apr 2018 - Feb 2023

  - Enhanced performance of Azure Databricks Streaming jobs, achieving a 50% reduction in end-to-end processing time through strategic performance optimization techniques.- Leveraged Power BI and Azure Data Explorer to optimize data models within ADX, resulting in improved performance of Power BI reports.- Established automated deployment pipelines using Azure DevOps Pipelines to seamlessly deploy solutions across higher environments, streamlining the deployment process. - Proficient in Azure data technologies including Azure SQL, Azure Data Factory, Azure Data Warehouse, and PowerShell, ensuring the delivery of complex projects with high quality.- Demonstrated quick learning ability across various technologies, leading to the delivery of high-quality code aligned with project requirements.- Practiced Agile methodology, adhering to best practices and maintaining accurate status tracking for stakeholders.

  • Consultant

    Jan 2020 - Feb 2023

  • Associate Consultant

    Apr 2018 - Jan 2020
• 

  Microsoft

  Apr 2023 - now

  Senior consultant

  - Led a team of 10 data engineers in developing a high-performance streaming solution, processing over 50 million scans daily from diverse sources in near real time.- Facilitated discussions with clients and architects to refine requirements, establish architectural frameworks, devise delivery schedules, and optimize project costs.- Applied expertise in Azure technologies such as Databricks, Cosmos DB, Data Explorer, and Power BI to architect and implement effective solutions meeting client needs and project objectives.- Improved performance of Databricks streaming job to bring processing time down from 10 minutes per micro batch to within 2 minutes.- Led the initiative to optimize costs by replacing Azure Functions with a custom application hosted on Azure Kubernetes Service (AKS), resulting in annual savings of $500,000. Show less