Over five years of experience in designing, developing, implementing, and testing robust database applications. Proficient in Oracle 11g, 12c, and 19c.
Overview
6
6
years of professional experience
Work History
Software Developer
Iqvia
Bangalore
04.2022 - Current
Custom Ad-hoc Data Requests - Contributed to the development and implementation of custom data requests for our pharmaceutical clients.
Developed SQL scripts for data extraction, transformation and to load on staging table.
Understanding of data modeling, schema design and ETL processes.
Worked extensively on ref cursor, External Tables and Collections.
Involved in Performance Tuning activities like creating Indexes, Partitioning Tables.
Expertise in Linux shell scripting.
CI/CD using Git.
Involved in the requirement Analysis, Design phase and development phase of agile model system.
Attended walk through, code review and status meeting to discuss the status of the project.
Associate Consultant
Capgemini
Bangalore
12.2021 - 03.2022
Provided technical assistance in the form of SQL coding advice to other team members.
Resolved customer service requests related to database errors or performance issues quickly and efficiently.
Conducted unit testing of all database objects before deploying them into production environment.
Tested databases and performed bug fixes.
Technical Consultant
Lonar Technologies Pvt Ltd.
Pune
09.2019 - 11.2021
Supported daily production and interacted with business users.
Strong technical expertise in creating and maintain database object-Tables, Views, Materialized views, Sequences, Synonyms and Constraint.
Performed root cause analysis to identify system issues.
Writing complex SQL query using joins, with clause, sub-queries and correlated sub-queries.
Providing timely support and troubleshooting for SQL-related issues.
Writing PL/SQL Programs required to retrieve data using cursors and exceptional handling.