· Manage team of 14 people and guide them technically/ functionally whenever required.

· Attend daily/weekly/Monthly customer meetings.

· Prepare projects specific daily/weekly/Monthly reports for higher management.

· Design, develop, support, and deliver solutions using multiple technologies including JAVA/J2EE, Angular Js, Oracle. etc;

· Work on customer specific application ETA, application defects and apply appropriate fixes and make enhancements to the application to meet customer requirements;

· Maintain currently developed applications and support business in technical issues arising in incident management, service requests, problem management and enhancements/projects.

· Analysis of BSR documents and prepare estimate for them

· Creating packages, procedures, functions, triggers... etc. as per the client request.

· Performance tuning of oracle queries and procedures functions.

· Preparing the project related documents for future reference.

· Executing daily incidents, service request, changes & problem tickets reported through Service Center 2.0 ticketing tool and completing them on time.

· Admin related activities including jobs monitoring and analyze the Unix job alerts

· Preparing Oracle Queries and Excel templates based on client requirements to ease processing of the requests

· Participated in code reviews, unit test plan reviews, and other quality reviews defined by the system development lifecycle (SDLC). Identified and escalated issues that impacted testing progress

· Mentored junior programmers in Oracle database design and development

· Worked on a sub project using .NET. Designed web pages and web services support .

· Worked on Quality Assurance, Worked on Version control Systems

· Involved in enhancements and maintenance

· Involved in code walk through and review sessions with the development team

· Involved in production support

This project is to track the vehicles right from order entry till customer delivery.

· Creating packages, procedures, functions, triggers... etc. as per the client request.

· Performance tuning of oracle queries and procedures functions.

· Executing daily requests for data additions, updating both manually and through SQL mass load files, reported through SDM12 ticketing process and completing items accordingly.

· Admin related activities including jobs monitoring and analyze the Unix job alerts

· Preparing Oracle Queries and Excel templates based on client requirements to ease processing of the requests

· Developed most of the database packages, procedures, functions, views, triggers, tables….

· Performance tuning of oracle objects as well as SQL’s used in application.

· Developed whole dedupe process including external as well as internal dedupe logic

· Developed all interfaces with client third party system using java classes.

· Individually setup UAT,SIT and production environment from offsite

· Analyze the change request and prepare the documents like Impact analysis, functional specification …

· Prepare unit & integration test scripts.

· Review the work done by team members.

· Creation of project level documents like functional specification, program specification...

· Creating packages, procedures, functions, triggers... etc. as per the client request

· Design and develop of LOS workflow procedures in oracle and integrate it in application

· Active participation in oracle migration from 10g to 11g

· Develop web pages as per the client request as a part of change request.

· Doing end to end testing of the applications and Error casual analysis.

· Creation of project level documents like function specification, program specification....

· Performance tuning of oracle objects as well as SQL’s used in application.