- Proficiently executed data extraction using SQL tools to meet ERP users requests for customized data analysis.- Investigated and resolved various issues, including data discrepancies and operational errors, utilizing SQL tools, PuTTY, and Linux commands for thorough analysis.- Conducted program tracing through JAVA, JSP, and JavaScript to understand program flow and methods, facilitating effective issue resolution.- Provided L2 support, ensuring 24/7 availability to address urgent issues such as EOD batch job failures and database connection issues.- Performed manual recovery processes by triggering failed batch process jobs and monitored their completion to maintain system integrity.- Supported in diagnosing ERP system performance issues, utilizing AWS cloud monitoring and Oracle optimization techniques.- Optimized SQL queries and execution plans using Copy statistics and Gather Statistics in Oracle to improve system performance.- Managed resource allocation by prioritizing processes using Linux commands, enhancing ERP system efficiency.- Conducted month-end integrity checks to reconcile figures between merchandising reports and SAP files, ensuring accuracy for client presentations.- Demonstrated strong analytical skills in identifying root causes of issues and implementing effective solutions.- Maintained meticulous attention to detail in data analysis and integrity checking tasks to ensure accuracy and reliability.- Collaborated effectively with team members to address complex technical challenges and achieve organizational goals.- Conducted User Acceptance Testing (UAT) on program changes and fixes, ensuring adherence to client requirements and correct functionality.- Created and executed various test cases in the UAT environment to validate program changes and fixes before deployment to the LIVE environment.- Prepared and submitted testing documents to clients for review and approval before deploying changes to the LIVE environment.