Praveen Kumar

Involved in complete understanding of the software development life cycle (SDLC) and participated in the analysis, design development testing, Implementation, and maintenance. During tenure, I have tuned many jobs and enhanced the performance of many long-running batch and jobs. Created the database objects including tables, views, indexes, PL/SQL packages, stored procedures, functions, and triggers. Worked on agile methodology and Scrum process framework with various sprints.

Analyzed the requirement and prepared the design documents estimation plan and unit test plan. Prepared technical documentation explaining system design in-depth as well as introduce the product to a non-technical audience. Designed, developed, documented, tested, and debugged applications software and systems that contain logical and mathematical solutions.

System Study, development, customization, implementation and unit testing. My major role was creation of programs unit using PL/SQL such as Procedure, Function, Package and Triggers Involved in Enhancements and creation of Procedures, functions, Packages and Queries. Involved in Enhancements and creation of Business Analytics and MIS Reports to help Day-to-day operational reporting for providing critical decision-making information for management

Designed and developed of various SQL scripts, PL/SQL stored procedures, triggers, functions, and packages. Handling Oracle Supplied Packages, Handling exceptions & Built-in exceptions. Understand the requirements from FO and client and then preparing the design document and flow chart of the new module. Identified areas to improve system performance and impact availability under the system improvement plan (SIP).

I was responsible for Enhancements and Development of Procedures, Functions, Packages, and Queries according to functional requirements. Developed PL/SQL programs in Oracle to automate the project and to maintain them. Designed and developed various SQL scripts, PL/SQL stored procedures, triggers, functions, and packages. Performed unit testing for the entire developed module by the team and then released it in the production environment after getting the UAT Sign off.