database developer Team Lead

SWAPNIL YEWALE

PROFESSIONAL SUMMARY

Organized and self-motivated Database Developer with 9 plus years of success designing and implementing database solutions. Goal-orientated with ability to understand business problems and create systems to improve functionality. Work effectively independently and in collaborative settings.

EXPERIENCE

Technical Lead, 05/2024 – 04/2025

Xoriant – Pune, India

Working for developing Rosetta Master module and KMR module in Citi bank

Working with the Business Analysts for requirements gathering, business analysis, testing, metrics and project coordination.

Involved in designing logical and physical relationships of the database.

Developed stored procedures, functions to build application and SQL scripts using PL/SQL.

Loading the data into database tables using SQL Loader from the text and excel files.

Developed data model, SQL coding, SQL query tuning process, and schemas.

Create Packages using PLSQL to build perfect module.

Good knowledge of key Oracle Performance related features such query optimizer, Execution plans and indexes.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application

Senior Oracle Database Developer, 05/2023 -03/2024

Allvue Systems - Pune, India

Previously called as Black Mountain Systems is product based organization developed innovative, tailored solutions for data aggregation, process management, and business reporting. Global investment firms used Black Mountain software and solutions to add operating efficiency and reduce risk by eliminating the boundaries between systems, information, and people, allowing employees to focus on high-value activities that drive investment performance.

Working with the Business Analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.

Involved in designing logical and physical relationships of the database.

Developed stored procedures, functions, Everest application and SQL scripts using PL/SQL.

Loading the data into database tables using SQL Loader from the text and excel files.

Developed data model, SQL coding, SQL query tuning process, and schemas.

Senior Oracle Database Developer, 09/2021 - 02/2023

Calsoft - Pune, India

Working with the Business Analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.

Involved in designing logical and physical relationships of the database.

Developed stored procedures, functions, packages and SQL scripts using PL/SQL.

Loading the data into database tables using SQL Loader from the text and excel files.

Developed data model, SQL coding, SQL query tuning process, and schemas.

Developed SQL scripts, packages, and procedures for business rules check to implement business rules.

Using bulk collections, indexes, and materialized views to improve the query executions.

Using Ref cursors and collections for accessing complex data resulted from the joining of a large number of tables in PL/SQL blocks and even have experience with exception handling.

Senior Oracle Database Developer, 01/2021 - 06/2021

Virtusa - Pune, India

Worked on Citibank project as a Senior PL/SQL Developer and led the entire team.

Working with the Business Analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.

Involved in designing an ER diagram using Visio, to set the logical and physical relationships of the database.

Developed stored procedures, functions, packages and SQL scripts using PL/SQL.

Loading the data into database tables using SQL Loader from the text and excel files.

Developed data model, SQL coding, SQL query tuning process, and schemas.

Developed SQL scripts, packages, and procedures for business rules check to implement business rules.

Using Ref cursors and collections for accessing complex data resulted from the joining of a large number of tables in PL/SQL blocks and even have experience with exception handling.

Senior PL SQL Developer, 12/2018 - 05/2019

Integrated Personal Services LTD - Pune, India

Senior Subject Matter, 06/2014 - 11/2018

Amdocs - Pune, India

EDUCATION

Master of Science, Computer Science

Pune University - Pune India

Bachelor of Science, Computer Science

Pune University - Pune India

CERTIFICATIONS

Agile Scrum Master

1Z0-071 Oracle Database SQL

Oracle certification of Oracle Autonomous Database Cloud 2019 Specialist

Certified course of Hadoop Development

CONTACT

Address: India

Phone: +918*********

Email: ***************@*****.***

CORE QUALIFICATIONS

PLSQL

SQL

Bitbucket

Jenkins

Scrum master

PLSQL Packages

Oracle Database

HBase

MS SQL Server 2019

Everest application

Git

Power BI

RLM

Azure data engineer course in progress

Contact this candidate