Software Engineer Ii
• Extracted data by developing customized SQL queries from the SQL server and performed the data cleaning process in MS Excel by applying advanced Excel techniques.• Worked in a techno-functional role as a Product Specialist with core responsibilities such as customer service, troubleshooting and root cause analysis, product analysis and development, functional testing, implementation, incident management and change management.• Worked with operation teams to define needs, identify opportunities, and project manage the implementation of new solutions.• Worked with various teams to help them understand dashboard reports and determine the root cause of failures.• Provided recommendations for process improvement, benchmarking, and report automation.• Trained new processes and tools (including written work instructions and verbal/web-based training).• Developed and published customized interactive reports and dashboards using the PowerBI tool.• Performed UAT/integration/regression testing and provided 24*7 product support and maintenance services to banking customers along with creating UAT test cases/scripts.• Gathered and presented requirements to the development team to provide specifications for developing solutions.• Performed system troubleshooting, logs research, analyzed the root cause of severe production issues, and rectified bugs/glitches in the production environment
