Deepak Jadhav

• Handling team of 12 members as Scrum Master for ODI Project. Following all ceremonies of Scrum master. • Scheduling and allocating work, providing advice and guidance, and resolving problems to meet technical performance and financial objectives. • Involved in creation and updates of several Oracle packages and procedure. • Reviewing team member Code and providing guidance . • Daily work logged in Jira tool for planning & tracking development process. • Working on Jenkins, flyway, Git, DevOps tools.

Managed end-to-end complex data migration, conversion and data modeling. • Developed database procedures, functions and Tuned database queries. • Ensure security in reporting and data warehousing. • Delivering innovative BI & Data warehouse solutions. • Supported deployment of solution, cut over planning and execution activities. • Experience in Data Migration/ ETL. • Define the migration strategy and plans

Identifying and closing the gaps in Requirement Gathering phase and Creating PL/SQL stored procedures, functions, packages, triggers, cursors, views, Collections. • Create database objects (tables, indexes, etc.) • Writing and tuning complex SQL statements, complex joins views and sub-queries.

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes to implement business logic using SQL Navigator. • Involved in writing PL/SQL queries for accessing back-end of application. • Involved in creating UNIX shell Scripting. Defragmentation of tables, indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes for performance optimization. • Worked on Tableau Reporting tool to generate reports