Somnath Kondhare
PL/SQL Consultant with 8 years of Oracle SQL and PL/SQL development experience
Hire this person
Send a job offer directly to this candidate
About
I Have 8 years hands on experience in Oracle SQL, PL/SQL development.
Experience in client facing role with knowledge of SDLC and comprehensive experience in Database Development, Advance Data Analysis, SQL, and PL/SQL Programming. Proficient experience in SQL, PostgreSQL and PL/SQL, Cursors, GTT, Materialized View, Ref Cursor, Stored Procedure, Function, Packages, Exceptions, Collections, Transactions, Triggers, Tables, Constraints, Views, Joins, Sub Query, Indexes, Synonyms, Sequences, SQL Loader, Bulk Collect, Performance Tuning and Query Optimization, DB Design, DB modification. Expertise in requirement gathering, project management and onsite implementation using different Methodology like Software Development Life Cycle (SDLC), Agile, Scrum.
Tuned performance of query using Explain Plan, Query Optimization Techniques. Working knowledge of GCP services like compute engine, Big-query, cloud storage, Composer, AirFlow, cloud SQL and AWS services like EC2, CloudWatch, Simple storage services, RDS etc.
Experience
PL/SQL Consultant - Dicetek LLC - Dubai, UAE
(2024-07)
Senior Software Engineer - Coforge Limited - Pune
(2023-07 - 2024-02)
Senior Associate - Synechron Technologies - Pune
(2021-10 - 2023-07)
Senior Project Engineer - Vara Infotech-Wipro Limited - Airoli, Navi Mumbai
(2019-05 - 2021-10)
Software Engineer - Web werks India Pvt ltd - Airoli, Navi Mumbai
(2019-03 - 2019-05)
Junior Test Engineer (SQL) - Qualitas Global - Pune
(2017-09 - 2018-09)
Developer - Abu Dhabi Commercial Bank Dubai - Dubai
- Involved in the end-to-end Software Development Life Cycle for the development, enhancement, maintenance, and support of loyalty program applications, including rewards, points management, and redemption functionalities.
- Worked on co-branded card solutions, including transaction processing and partner integrations.
- Collaborate with cross-functional teams to deliver high-quality solutions.
- Troubleshoot issues and provide production support
- Worked on Design, Develop and enhance PL/SQL stored programs, packages, stored functions/procedures, synonyms, sequences etc.
- Efficiently developed complex business logic in Oracle PL/SQL
- Optimized SQL queries and implemented advanced PL/SQL, bulk-SQL, collections.
- Interacting with other Clients/Application owner to understand the new requirements.
- Written SQL queries using joins, subqueries, and correlated sub queries.
- Analyzed and optimized application performance by fine-tuning SQL queries, improving PL/SQL procedures.
- Expertise in handling Incident, Change and problem management using BMC remedy.
Developer - HSBC
- Incorporated business rules and constraints and created new tables for all modules.
- Modifying stored procedures, functions, packages, views, and SQL queries as per new business requirements/changes.
- Written logical SQL queries using joins, sub queries and correlated sub queries.
- Worked with Dynamic SQL
- Involved in the development backend code, altered tables to add new columns, Constraints, Sequences, and Indexes as per business requirements.
- Writing SQL queries which will fetch client Requested data from DB and giving it to them.
- Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.
- Tuning SQL queries to improve response time.
- Worked on Google cloud Platform services like compute engine, Big-query, cloud storage, Composer, AirFlow, cloud SQL.
Developer - ICICI BANK Ltd.
OFSA is an oracle product. There are many feed systems for OFSA is Finacle, Finnone and MUREX etc. Raw data from these sources is not compatible with OFSA's format. So, OFSA AUTOMATION is developed (using .net 3.5 technology with oracle 9i DB) to upload and/or transform the data from these sources.
OFSA AUTOMATION is designed in such a way that stake holders can upload the data into master through Maker-Checker concept or bulk upload which will acknowledged through a mail to the registered stake holders. Thereafter transformation will be done with the help of stored procedures into OFSA Instrument tables (which can be used by OFSA Product for Risk analysis, Transfer pricing, Budgeting & planning and regulatory reports generation to RBI etc.).
- Writing common Package/Procedure/Function used throughout the system.
- Closely worked with Business Analysts and End-users to provide strategic solutions.
- SQL Analysis and advance PL/SQL programming in Financial Compliance Systems.
- Collaborate with project stake holders and define functional / technical change and deliverable.
- Comprehensively used assorted techniques such as Oracle indexes, complex views, procedures, and packages
- Advanced data analysis and report generation for senior management using SQL.
- Interacting with other Clients/Application owner to understand the new requirements.
- Written SQL queries using joins, subqueries, and correlated sub queries.
- Worked with Dynamic SQL.
- Providing development related support for the Application owner during the testing phases. And pivotal role in solving many Production issues.
- Worked on HP quality center and has taken proactive measures to reduce and prevent defects.
- Analyzed and optimized application performance by fine-tuning SQL queries, improving PL/SQL procedures, and leveraging Oracle APEX best practices.
- Created database objects such as tables, views, synonyms, Indexes, sequences.
Education
Bachelor of Engineering - Information Technology - Pune University
