M GAYANI
Bangalore
Summary
Results-driven SQL Developer with 3.6 years of experiece at Infosys Limited, adept in optimizing SQL queries and enhancing database performance. Skilled in MySQL and problem-solving, I successfully delivered data-driven solutions and ensured system stability through rigorous testing and collaboration with clients and QA teams. Detail-oriented SQL Developer skilled in database performance optimization and data-driven solutions. Proven ability to conduct unit and regression testing, ensuring high-quality outcomes and minimal defects.
Overview
4
4
years of professional experience
Work History
SQL Developer
Infosys Limited
Bangalore
07.2022 - Current
- Engineered and optimized SQL queries to meet business and system requirements, enhancing database performance.
- Proficiently utilized SQL Server Management Studio (SSMS) throughout the software development lifecycle for database management and query development.
- Strong knowledge of SQL concepts including DDL, DML, DCL, TCL, and DRL commands.
- Collaborated directly with clients to gather requirements and deliver timely, data-driven solutions to resolve critical issues.
- Conducted rigorous unit and regression testing on database code, minimizing production defects and ensuring data quality.
- Contributed to job monitoring and issue resolution, ensuring scheduled tasks, automated workflows executed reliably in production. This ensured continuous availability and reliability of the automated workflows.
- Partnered with the QA team to perform regression testing, validating database changes across applications and ensuring system stability.
- Actively monitored database performance during QA phases, proactively identifying and resolving potential issues.
- Created and delivered weekly client-facing presentations and reports detailing ETL job updates, environment changes, and status summaries using PowerPoint and Excel.
- The objective is to provide end-users a full dashboard solution to visualize real time KPI during manufacturing of the A220 100-300. Chronos is thought to consolidate data from many sources and gives to the final user, a data easy to interpret.
Education
Bachelor's Degree - Electronics and Communication
Sreenivasa Institute of Technology and Management Studies
01.2022
Skills
- MySQL
- Python
- Microsoft SQL Server
- Jira
- MS SQL Server Management Studio (SSMS)
- Visual Studio
- Notepad
- MS Office
- Unit Testing
- Regression Testing
- Problem solving
Timeline
SQL Developer
Infosys Limited
07.2022 - Current
Bachelor's Degree - Electronics and Communication
Sreenivasa Institute of Technology and Management Studies