Shantanu G.

Linkedin: shantanufrom4387 Github: shantanugupta Stackoverflow: /users/203262/shantanu-gupta Medium: @shantanufrom4387 - 16 years of experience working in service/product/start-up-based organizations - Designed large-scale solutions both on the application side as well as the database side with extensive experience in relational and non-relational database systems. - Well-versed in AWS, T-SQL, PL-SQL, SQL Server, PostgreSQL, and MongoDB along with strong programming background in C#, Python, PowerShell, Bash, JMeter, Docker, CloudFormation, Linux, and Scala which compliments writing Infrastructure as code for spinning up resources on AWS - Leading the DBA team to drive automation, migration, alerting, cost optimization and other DBA-related activities. Saved $800k/yr. Currently leading DBA team - Managing 300+ RDS, 100+ MongoDB, 70 Redis Cache & 30 Elastic Search clusters - Leading cost optimization efforts by identification, downscaling, de-duplication, prioritization etc – saved $800k - Driving automation for a bulk upgrade, patching, migration, alerting and monitoring - Designed and brainstormed data model for supporting generic access management system - Scaled system to fit multiple use cases around access management - Integrated sensors like RFID, Biometric, QR code, and barcode to link with access management - Designed ORM using Entity framework, C# with database first approach - Implemented TPT, TPC, TPH, Entity splitting in EF6.0, design patterns like Factory, Abstract, Template, Repository, Singleton, MVVM, Pub/Sub while writing Web API 2.0 in C# .NET - Created custom HTTP handlers and modules to inject API key, token handler, OAuth, NLog integration - Writing client applications in WPF structure using MVVM model by integrating command pattern, message bus, and Syncfusion components - Wrote SPA application using AngularJS 1.4, WebSocket using SignalR - Did performance improvement, indexing decisions, load testing using JMeter - Setup routine tasks like database backup, stats update, clean-up, etc - Extended Microsoft SQL Server Job scheduler to integrate with this system In application development, I have exposure to various devices which includes 1. UHF readers- Alien Reader(ALS-9900) 915 MHz, Unitech handheld reader 965Mhz, Window CE 5.0) 2. HF proximity readers- Fieg(ID IS C.PR101-USB) 13.56 MHz, RFIDEAS 3. Centrak readers for RFID locating 4. Active/Passive tag e.g. wrist bands, ID badges, key tags, centrak tags some of which include reading the writing on tag memory. 5. Magnetic Script reader- Credit card, debit card reading 6. OCR- Passport - Driver’s license scanning 7. Web camera integration 8. Notification- Email, SMS, Facebook Integration 9. Virtual keyboard- Eyesboard for Touch screen applications 10. Thermal printing- XID printer for label printing, card printing