Piyush Kushvaha

Experience

• 

  Tata Consultancy Services

  Nov 2009 - now

  System Engineer

  Role and Responsibility Highlights:- Analyzing and finalizing the Business requirement documents (BRD) along with Business Analysis Group. Assigning the BRD to other Team members as per the complexity of the requirement and the available skill set. Completing myself the design and implementation of complex Requirements being a PL/SQL Programmer. Design and implementation of complex database schemas, procedures, triggers, and functions Enforcing and ensuring standards in database development. Assisting team members functionally and technically to complete their tasks Ensuring the work quality of other team members by reviewing the code and other supportive documents. Providing quick resolution of critical and high priority(L3) issues Knowledge management Creation of Checklists Creation of Reusable components Research on alternate solutions Research on new product functionality Competency development Proof of concept Performance Tuning - Creation of High Performance Database, Enhancing/Tuning current system design, Tuning existing and new code to improve System performance Data Migration Debug Database Related Issues Training Project Planning and Scheduling Tracking the execution of assigned tasks Automating the routine tasks to save efforts Reverse Engineering of chosen Oracle Apps modules Schedule complex and chained Jobs Assisting Java development team with complex queries Assisting Testing team with desired data required for testing Ensuring timely execution and completion of all the assigned tasks Troubleshooting, fixing and implementing bug fixes and enhancements within tight deadlines. Perform Impact Analysis due to changes Maintaining the code versions in the versioning tool. Ensuring the code merging in common code components Ensuring the timely completion of Design/Performance/Security approval of the code Preparing the final Component list for deployment of the code in production environment Show less