Shashikant Nalawade

Software Technical Apprentice June 2025 – Present S&P Global Technology Resources | Hyderabad, India Project: Global Trade Application | Tech Stack: Angular 20 · .NET 8 Web API · PostgreSQL 14 · AWS · Terraform Backend Development • Engineered .NET 8 Web API endpoints handling CRUD operations with robust validation, error handling, and PostgreSQL 14 database consistency checks. • Architected OAuth2 authorization with identity provider (IdP) integration, enforcing role-based access control (RBAC) and token/refresh flows to secure all backend API endpoints. • Fetched state machine execution metadata from AWS S3 using the S3 client library and persisted data to PostgreSQL for downstream consumption, reducing the response time from 5 minutes to 8-40 seconds. • Developed AWS Lambda functions triggered on scheduled intervals to invoke specific API endpoints, automating backend workflows. • Configured dual connection strings with appropriate Read/Write permissions to support simultaneous multi-database connectivity as per application requirements. • Applied MediatR pattern with dedicated handlers to enforce clean, maintainable, and testable backend architecture (CQRS). • Authored unit test cases for each API endpoint, ensuring high test coverage and reliable API contracts. • Integrated identity providers for centralized user management, reducing unauthorized access risks and providing a scalable security foundation between Angular clients and .NET backend services. Frontend Development • Integrated CodeMirror 6 as a custom SQL editor within Angular, enabling syntax highlighting, autocompletion, and a tailored light theme for an enhanced SQL authoring experience. • Built real-time SQL validation using multilayered analysis (regex, lexical, structural pattern matching, and AST parsing via node-sql-parser), surfacing errors through gutter markers, tooltips, and error lists.