Adish Shetty
Database Developer with 10 years of experience
Hire this person
Send a job offer directly to this candidate
About
A logical, analytical thinker having 10 years of experience in Database Development and have recently started working on Azure databricks. Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures, functions, and triggers using Oracle PLSQL tool.
Experience in writing, debugging and tuning complex queries, SQL, PL/SQL stored procedures, functions, and triggers. Participated in complete Software Development Life Cycle (SDLC) for proper analysis, development, testing, deployment and enhancement of the code. The core areas of expertise in issue analysis, coding and implementation using Oracle PL/SQL and Performance Tuning.
Cooperating with the other teams across organisation for efficient work progress. Having exposure to Unix shell scripts, Python, Autosys, Power Bi, Azure Databricks along with PLSQL.
Experience
Database Developer at Synechron (2021-07 – Present)
Working on Regulatory reporting system Datawarehouse implemented in batch system for UBS client.
- Working on Regulatory reporting system Datawarehouse implemented in batch system.
- Have worked on implementation of reports for regulators like SFC OTCR, MMSR, EMIR, SEC
- Working on Oracle Database for creating packages, managing database and writing PL/SQL code for implementing the required client's functionalities, and Unix shell script, Python script for fetching data and sending reports, Autosys for scheduling jobs and various File transfer protocols like SFTP, SSH, SCP
- Worked on AC5 compliance for my current project to be compliant with AC5 standards set by organization
- Worked on Azure databricks for delivering dashboard to end user, involves working on databricks workflows in pyspark and power bi for dashboard
- Knowledge of fitnesse tool used for unit testing
- Also looking into L3 issues raised by user and resolving it in given timelines.
- Worked on RHEL7 to RHEL8 migration of server for Dev, UAT and Prod servers, Pre and Post-migration validation testing to guarantee system stability
Database Developer at MITS Consulting (2019-12 – 2021-07)
Worked on Back-office banking application for BNP Paribas India Solutions Pvt. Ltd.
- Worked on Back-office banking application to develop the features which are required as per the new banking standards.
- Worked on 12c Database for creating packages, managing database and writing PL/SQL code for implementing the required client's functionalities
- Worked on Shell Script batches, SQL Loader, Data Pump, Copy command to load the data.
- Working on Front-Office banking application to upgrade to newer version by writing application logic in database and fine tune existing working queries to improve the performance of application.
- Resolving performance issues in the database by analysing the AWR Report, creating complex queries for generating report
- Co-ordinate with APAC teams to resolve database issues on UAT and Prod Env.
- Used advance SQL and Analytical functions
Database Developer at ALPS Consulting (2019-03 – 2019-12)
Worked on ICICI Prudential Life Insurance application support and development.
- Managed the support requests related to the application logic or database problem.
- Handling the change request in the current project.
- Managing of change requests activity from UAT to production and post live.
- Developed and optimized complex queries, procedures, functions, and packages using SQL and PL/SQL concepts including joins, subqueries, cursors, varrays, and database objects using best possible approach.
- Created scripts to create new tables, views, queries for new enhancement in the application and created indexes on the tables for faster retrieval of the data to enhance database performance.
- Performed SQL and PL/SQL tuning and Application tuning using tools like EXPLAIN PLAN and using hints to direct the optimizer to choose an optimum query execution plan.
Database Developer at Majesco LTD. (2016-07 – 2019-03)
Developing database objects and providing production support.
- Developing stored procedures, packages, triggers and other database objects using Oracle PL/SQL programming language on Oracle 11g database.
- Part of the discussions with the business team and as well as the other teams involved regarding the feasibility of the requirement.
- Creation of SQL queries to provide Operation critical data and reports for the business requirement.
- Resolving defects and bugs raised by operations team and giving production support.
- Modified existing Report using Report Builder.
Education
Bachelor of Engineering in Computer Engineering – Watumull Institute, Mumbai University (2016-07)
Diploma in Computer Engineering – M.M.B.G.I.T, MSBTE (2012-07)
