Tejas Chavan Email & Phone Number

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.
• 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.

• 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