• Writing PL/SQL stored packages, procedures, functions, triggers views, indexes etc.
• Creating common Library functions and templates that can be used by various projects.
• Solution mapping, designing and effort estimation.
• Code Review, System Testing/UAT/Production Implementation as on incremental basis.
• Migration of scripts from 11g to 12c and 18c.

• Successfully worked on Performance Tuning, Monitoring and Optimization of PL-SQL blocks in both Development and Production environment.
• Successfully implemented the indexes such as Clustered index, Non-clustered index appropriately on data structure to achieve faster data retrieval.
• Implemented code changes.
• Worked on Jenkins Implementation
• Successfully implemented DBFit test cases.

Successfully collaborate Product Development and Sourcing Departments, early in the process. It helps in reducing the overall cycle time, as well as improve the overall efficiency of organizations. Sourcing impacts the product development process from line planning all the way through to final delivery of the product. Product Lifecycle Management deals with Apparel industry. It helps to maintain styles, colors, raw material, vendors, mills, suppliers.

• • Identified high-impact SQL, optimized with the help of execution plan, AWR reports and Code Expert.
  • Data conversion and transferred data feed to different third-party applications.
  • Gathered requirements for the application, draw out a plan for releases of the enhancements.
  • Worked on design and implemented IT system solutions for clients.
  • Authored Functional Specifications for client and generated business rules.
  • Technical Suggestion and Discussions with Client and Third-Party Vendors to propose new technologies.
  • Evaluated customer’s needs, defined and established new standards, implemented changes, planned different transitions and tested functionality in order to fulfill organizations’ needs.
  • Documented test cases, managed changes and addressed cost concerns to organizations.
  • Data modelling – logical as well physical.
  • Worked on Jenkins Implementation