• Involved with study of existing system, preparing the Functional (MD050), Technical (MD070) design document and Conversion Mapping Document (CV040) to extract data from legacy system into Oracle Applications open interface tables.

• Formulated program testing processes with Oracle PL/SQL programming language.

• Worked on Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.

• Involved in JSP & JAVA object oriented related applications, customization and creation of JSP files & java classes.

• Developed RTF and XML reports of weekly Material Transactions for all the Inventory Organizations to track the Lot Weights, Planning Parameters, and Shipping Parameters.

• Generated RTF and XML reports to track the Sub inventory Material Availability to scale Raw inventory, finished goods and quarantined goods.

• Developed API for mass Purchase Order List price and PO Category as per the business requirement.

• Customized account generator workflow as per business requirements.

• Imported Items from legacy system Oracle Inventory (INV) to third party using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.

• Extracted data from Oracle base tables and transmit flat files via FTP/SFTP.

• Created custom Tables, Synonyms, Views and referential integrity constraints using SQL.

• Wrote Database Triggers, Procedure & Functions using PL/SQL.

• Imported EBS BOM Data from legacy system into Agile PLM using the Standard Oracle Interface program.

• Involved in all extraction process from Oracle r12 to Cloud, for Purchasing Payables and INV. Worked on Tunning of queries.

• Worked on Java, Eclipse/ J2EE, tested programming code & Applications, collaborated with team and management.

• Created & maintained a centralized repository of UI components, participated in usability testing & research.

• Wrote and executed test cases based on written design, as well as based on product knowledge that resulted in greatly improving the software. Researched and documented software bugs and created and implemented fix.

• Prepared Unit test cases and reviewing test results. Designed and developed front end using JSP and JSTL.

• Responsible for investigating the issues, defects, determining problem root cause, formulating corrective action recommendations & implementing them. Created web services using SOAP and producing WSDL to the Client side.

• Created detailed design documents using UML (Use case, Class, Sequence, and Component diagrams).

• Provided up skills training to associates on process modules, Technical advancements, and

abilities required to perform given responsibilities and tasks as related to the scope of project.

• Took part in Weekly Business Reviews (WBRs) and Monthly Business Reviews (MBRs) with the client and senior management.

• Provided constant feedbacks and trainings to the teammates who were lagging behind in the project.

• Conducted PKTs (Process Knowledge Tests) every month and ensured team was updated on all the new issues scenarios and issues reported by the client.