Jayanthi P

Over all 7+ years of experience in all phases of SDLC and oversee aspects of project life cycle for the solution as required, from initial kick-off through requirements analysis, design, development, testing and UAT phases using waterfall methodologies to ensure delivery of the designed solution within timeframes. Develop the customized logic using Stored Procedures, Triggers, Indexes, Views, User Defined Functions and Cursors using SQL Server 2012/2016/2018. Working with string functions, XML data types, case statements, date functions, cursors, while loops, pivot, table variables and temporary tables. SQL Performance tuning, Query Optimization, Data integrity and debugging by using SQL Profiler. Data migrations and transfers, using utilities like Bulk Copy Program and Bulk Insert. Database backups and Shrinking, Performing RCA, Proposing and fixing the issues in case of SQL agent job failures. Bug Fixings/Data Fix/Enhancement in existing Product implementation. Project tracking, Team handling, Onboarding and Training new team Members, driving client calls etc. Performed User acceptance testing with the customers for sign off. Worked with the SQA for various process performance and optimization activities to achieve higher CMMI levels for the projects. Organized solution design, development, testing and production roll-out of change management as well as development for the project. Review the current business procedures and implement the suggested changes. Software administration and production support after delivery. Complex problem-solver with analytical and driven mindset. Experienced in Data modeling and Report Generation and offering skills in SQL/Oracle and Power Bi(Power Query & DAX). Fluent in English and accustomed to working with cross-cultural, global teams.