Tejas Chavan Email & Phone Number

Maharashtra, India

India

Mumbai Area, India

• Develop and deploy efficient PL/SQL code with the extensive use of PL/SQL, procedures, packages, triggers, collections, bulk binding and dynamic cursors in support of Web, UI and Middleware applications across all the environments.• Design Data Warehousing and Business Intelligence platform with efficient data modeling• Create ETL processes for Data Migration, Business Intelligence and Data Warehouse using the Pentaho Spoon ETL tool and PL/SQL programs.• Extract data from XML/JSON files, as well as render relational data into XML/JSON Using Postgres and MS SQL XML and JSON functionalities.• Improve readability, speed of code execution and database memory storage by database performance tuning and testing, query optimization, table partitioning, reviewing PL/SQL code.• Supported a major remodeling of the company’s old legacy application that involved extensive knowledge of its database design and jobs.• Optimize the current databases and took part in re-architecture and redesigning the database objects to improve the speed of the application.• Perform database refreshes, user account management and backup maintenance for the databases in all the environments.• Create shell scripts for task automation which helped to reduce the work efforts by more than 30%. • Maintaining data standards, including adherence to the Data Protection Act, Implement security and encryption• Assist developers and team members in writing efficient PL/SQL code, review code from a quality and performance perspective.• Set up and manage Databases on AWS servers for all of the database code releases and object migrations through the use of the DB Solo tool.• Involve in interviewing and selecting new hire for the DBA team• Deliver database solutions within Agile project methodology for the application delivery, collaborating effectively with product owners, clients, business analyst and QA.

• Application and Database performance and load monitoring• Issue tracing through log analysis, quick fixes and data recovery• Database backups and Data Maintenance• Data retrieval, cleanup, and conversion for Report generation

Mumbai Area, India

• Worked as a team member for the School ERP project which involved backend development usingOracle database (11G) and application development using C#.• Wrote and maintained technical and functional specifications.• Assessed customer needs and modifies existing databases.

Master'S Degree, Data Analysis For Business Intelligence

Activities and Societies: DATA CLUB As a member of the Data Club did a presentation for the Leicester City Council to demonstrate to them.

Bachelor'S Degree, Computer Engineering