Avneesh Sharma

About Avneesh Sharma

I specialize in architecting high-performance.NET systems and modernizing high-availability systems for healthcare and enterprise with critical workloads where 99.99% uptime isn’t just goal it’s a necessity.• Strong background across classic and modern.NET stacks - from legacy VB.NET/ASP to ASP.NET MVC.NET Core monoliths & microservices, SQL Server internals (20••••22), system migrations, and backend performance tuning.• Mentor engineers, and evaluated candidates during hiring. Conducted several technical assessment rounds for new hiring including group discussions and machine coding rounds.• Designed and developed custom tool for analysing SQL Server, IIS and windows server logs for anomaly detection and performance tuning.• Optimized legacy SQL Server databases (2008 → 2022) for a hospital management system by query optimization, jobs automation and index tuning, workload automation, performance tuning resulting in sustained throughput improvements for bulk data jobs and reducing query latency by 60%.• Database administration & security by migrating to stored procedure, query parameterization, Setup Role Based Access. • Setup High Availability using Replication, Disaster recovery using Transaction-Differential-Full auto backups and implemented Restore Point in Time.• Maintained database Mirroring for Principal-Mirror-Witness architecture.• Billing Software for concurrent users and sensitive data with smart User Session auto refresh & Smart Congestion detection which prevents user from saving bill if database is slow and successfully resolved bill duplication issue, improving overall performance by up to 35–50%.• production safe Product Auto Suggestion service for hospital staff.• Auto Bed Charge Service for Hospital with multiple price slabs and auto detects 48 hour free treatment eligible patients.• Database protection & security layer for protection against SQLMapper tool with logging, detection and response agent.• Diet Management System for Super Speciality Hospital.• Laboratory Management System with fully integrated HL standard machines and advanced reporting.• Developed Patient Portal with appointment scheduling, balance & scheme display, Billing reports and Ledger, Laboratory diagnostic reports and discharge summary all at one place. • Migrated legacy monolithic systems to modular.NET Core architecture• Automated operational tasks using PowerShell reducing manual overhead from Task Scheduler and legacy methods.

Experience

1. Google Could Computer Engineer

   Google

   Mar 2022 — Present

   Objectives- 1) Set up a cloud solution environment2) Plan and configure a cloud solution3) Deploy and implement a cloud solution4) Ensure successful operation of a cloud solution5) Configure access and security• Task- 1) Google Cloud Essentials2) Perform Foundational Infrastructure Task3) Baseline Data Machine Learning and Artificial Intelligence4) Perform Foundational Data Machine Learning and Artificial Intelligence tasks5) Baseline Infrastructure6) Build and Secure Networks7) Create and Manage cloud Resources8) Networking in Google Cloud

Education

• LUCKNOW PUBLIC SCHOOL

  Senior School Certificate Examination (12th)

  2019

• Manipal University Jaipur

  Bachelor of Technology - BTech, Electronic and Communications Engineering