Technical Support Lead / Assistant Manager / Manager — production support with SQL/API data validation and incident troubleshooting (Infinity Learn / Rank Guru Technology Solutions Pvt Ltd).
Performed troubleshooting-oriented data analysis by querying and reconciling production data across multiple relational tables to identify and resolve discrepancies impacting application operations. Supported incident investigation by examining SQL-derived results, API responses, and logs to validate hypotheses and confirm fixes in a production setting. Coordinated with cross-functional teams to run validations and ensure SLA-compliant outcomes for enterprise workflows. • Built and optimized SQL queries (joins, subqueries, group by, order by, distinct, like, aggregates) for validations and troubleshooting • Conducted reconciliation across user, billing, package, payment gateway, invoice, subscription, and transaction entities • Used JIRA for tracking production issues and prioritizing resolutions within SLA timelines • Tested and validated REST API request/response payloads using Postman and Swagger (GET/POST/PUT/DELETE)