Jasleen Virdi

WORK HISTORY

EDUCATION

ABOUT JASLEEN VIRDI

Currently working for Comviva Technologies, a branch of Tech Mahindra as a Senior Software Engineer with more than 3 years of experience.1. Leading a team of 4 engineers while acting as the SPOC for five mission-critical clientprojects. Designed Unix Shell Scripts to facilitate the automation of monitoring tasks, which led to a 30% reduction in manual effort.2. Managing client interactions, project status updates, and escalations to ensure smooth delivery.3. Providing L2 support including root cause analysis through UI issue replication, SQL query analysis, log analysis, and AWR reporting.4. Oversaw PostgreSQL database management, which included tasks such as data synchronization, user administration, and data purging.5. Addressed production challenges by examining AWR reports, refining inefficient queries, and alleviating database locking issues.6. Composed SQL queries for reporting and application diagnostics, in addition to managing user creation, Tablespace configurations, and the assignment of roles and privileges.7. Fetching and analyzing AWR reports in order to check system at database level such as: Finding long-running queries on database, locking on database.8. Utilized export/import and data dump utilities, along with RMAN, to analyse technical issues, capture essential logs in JSON and XML formats, and resolve product-related problems.9. Executed data purging operations within the database, which involved exporting data dumps, removing partitions, and indexing tables.10. Managed support tickets through SMAX and Jira, developed weekly dashboards, and presented findings during client and governance calls.11. Facilitated meetings with clients and the development team to clarify client inquiries and address Code Change Requests.Prior to that, worked for an elite organization, Techblue Software Solutions as an Application Support Engineer L2 with below roles and responsibilities.1. Creating Reports on Ireport and Jaspersoft (Using SQL Query, and designing the reports)2. Deploying the Reports on Live Server3. Creating XML and XSL Feed files to share Data Feed to Websites and Web Portals4. Handling Accounting, Mail Merge, Digital Signature, Report, WebFeed Modules (Testing for Bugs)5. Debugging errors on Client Side and Server Side Logs (Using Jboss)6. Quality Analyst7. Database Handling (Running Select and Update Commands on Database to fetch and update Client\'s critical data)8. Creating DBCR (Database Change Requests) for Development Team to Run and Deploy