Shreyash Patil

Software Engineer

VOIS, Inc.•  August 2023 - Present•  Pune

1. **Level 2 (L2) Support:** - Provide L2 support for OMS (Order Management System) and Amdocs CRM systems, ensuring timely resolution of incidents and service requests. 2. **Incident and Problem Management:** - Analyze and resolve application issues, perform root cause analysis, and debug database-level problems to maintain system performance and ensure data accuracy. - Escalate major bugs to the L3 team with thorough L2 analysis and collaborate for fixes and enhancements. 3. **Database and Query Optimization:** - Write and optimize SQL queries for high performance and low cost. - Develop and debug PL/SQL functions, stored procedures, and packages to support data operations. - Manage DB links for seamless inter-database communication. 4. **Automation and Scripting:** - Create and deploy automation scripts to streamline recurring tasks and reduce incident volumes, improving operational efficiency by up to 50%. - Key scripts include HED Request Handler, Missing Relation ID Checker, and Parse Error Finder. 5. **Data Management:** - Conduct bulk data patches and data correction using finely tuned SQL queries to address impacted customer records. 6. **System and Platform Maintenance:** - Perform health checks, housekeeping, and batch processing to ensure platform stability and uptime. - Monitor and manage interfaces to maintain seamless application performance. 7. **Collaboration and Documentation:** - Collaborate with cross-functional teams to gather information, resolve issues, and ensure smooth deployment processes. - Document workflows, automation processes, and resolutions to improve knowledge sharing and operational efficiency. 8. **Release and Deployment Support:** - Support release and deployment activities, ensuring proper platform scaling and stability in a distributed environment.