DEVENDRA SONAWANE

• PROJECT 1 - Worked with Gartner for SSC Migration project.
• DESCRIPTION - SSC MIGRATION – All oracle database objects migrated into SQL server (SSMS)
• TOOLS-SQL Server(SSMS),SQL Developer,Putty, Synapse
• ROLES AND RESPONSIBILTY-
• Involved in gathering the Requirements, analysis, design & Development of the Project.
• Experience in implementing business logic from various sectors using Cursor, Indexes, Views and Stored procedures &Functions.
• Responsible for creating reports based on requirements using SSRS Report.
• Writing SQL queries to implement business logics.
• Design of report using dynamic stored procedure for user-defined inputs used cursors.
• Application of Static & Dynamic Pivot in SP Create Global and Temporary Tables.
• Data flow using Azure pipelines.
• PROJECT 2 -Working With BAJAJ AUTO FINANCE in Data Engineering team.
• DESCRIPTION - Working Development of oracle objects and enhancement.
• TOOLS-SQL Server(SSMS),SQL Developer, Putty, Pentaho,

Apache Superset,Anaconda(Jupyter Notebook).

• ROLES AND RESPONSIBILTY-
• Involved in gathering Requirements, analysis, design & Development of the Project.
• Developed Database like objects procedure, functions, view, Mview, index, type,Collections etc.
• Developed Data mart For RBI(Reserve bank of India)
• Developed Exceptions On Datamart for RBI
• Automate report on Pentaho and Superset.
• Automate Unix Script

• PROJECT- Worked with TCS(Tata Consultancy Service) for Object Migration Project(Vodafone and Idea)
• TOOLS - SQL Developer, Putty
• KEY RESPONSIBILITIES -
• Developed various back end application programs, such as views, functions, procedures using SQL and PLSQL languages
• Solving end users query regarding applications
• Developed new functions and stored procedures using PLSQL
• Involved in tuning of SQL queries to improve performance
• Extracting logs and analysis
• Responsible for debugging and troubleshooting complex SQL queries.

• PROJECT - Worked With Axis Bank for IPSLITE project
• TECHNOLOGIES - PLSQL, SQL, Performance Tuning, Query Optimization, Finacle Support
• TOOLS - SQL Developer, putty, FINACLE(Infosys product for Core Banking)
• DESCRIPTION - Worked with Axis bank mutual fund web application name as IPSLITE which is a leading web application for investing in mutual funds.
• ROLES & RESPONSIBILITY -
• Developed various back end application programs, such as views, functions, procedures using SQL and PLSQL languages.
• Involved in Unix scripting
• Worked on Unix command.
• Extracting logs and analysis
• Responsible for debugging and troubleshooting the complex SQL queries.