Prasad Chawan profile photo 1 on Tal

Prasad Chawan

Senior Software Engineer | Oracle PL/SQL | SQL Performance Tuning | NICE Actimize IFM | Banking & Finance

Pune District

7+ years of work experience

Xoriant
May 20251 yr 1 moPresent

Pune, Maharashtra, India

• Working on the NICE Actimize IFM platform supporting fraud monitoring applications for Goldman Sachs. • Handling customizations and new business requirements, including enhancements to existing UI and backend components. • Actively involved in application and infrastructure upgrades, including: • ActOne, AIS, and IFM upgrades • Oracle Database upgrades • RHEL/Linux upgrades • Performing server monitoring and health checks, preparing and sharing environment health reports. • Creating and managing virtual machines using Jenkins for upgrade testing and validation. • Deploying changes across multiple environments using Unix shell scripting, including client testing and production. • Following a complete end-to-end delivery workflow: • Development in internal DEV environments • Requirement clarification with Business Analysts • QA testing and defect resolution • Client environment deployment and validation • Production deployments during scheduled weekend release windows • Preparing effort estimates, technical documentation, and release notes. • Using Wiser (NICE Actimize ticketing tool) for tracking requirements, changes, incidents, and deployments. • Coordinating with internal infrastructure and support teams for issue resolution.
Tata Technologies
Nov 20231 yr 6 mosApr 2025

Mumbai, Maharashtra, India

• Coordinated with the Business team to provide them with the necessary Data, reports & views. • Wrote Oracle Complex SQL Query, Procedure, Package and functions as Per Business and Functional Requirement. • Prepared functional specification (FS) document according to Business Requirements Document (BRD). • Involved in Unit Testing, Integration testing and User Acceptance. • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using Toad. • Used SQL*Loader as an ETL tool to load data into the staging tables. • Using PLSQL Procedure to first Extract data from txt file to the database in staging table and apply business logic to extract data from staging table to main table • Provide auto mail facility to business through Oracle procedure by creating database scheduler job. • Error Handling through Exception in PLSQL procedure and insert into the table and also report to the concern team through auto mail.
Clover Infotech
Aug 20194 yrs 3 mosOct 2023

Mumbai, Maharashtra, India

• Having database experience using Oracle 10g/11g/12C, 19C SQL, PL/SQL development and production support. • Good in understanding of business logic and ability to work well as part of team and as an individual. • Expertise in understanding the problem statement, solving the issues with business users, delivering workable solution. • Proficient in writing SQL queries, collections, cursors, triggers, sub programs like procedure, functions in pl/sql. • Ability to implement existing logic to new fuctionalities • Exposure to developing and optimizing/tuning of sql queries. • Good exposure to Oracle SQL queries • Expertise in developing SQL and PL/SQL codes through various procedures, fuctions & packages to implement the business logic. • Expertise in production support at all levels, debugging the code at production level.

Education

University of Mumbai

Bachelor of Engineering - BE, Information Technology

University of Mumbai

20163 yrs2019

Diploma of Education, Information Technology

Government polytechnic thane

20133 yrs2016

Join Prasad and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Prasad Chawan on Tal

Headline

Senior Software Engineer | Oracle PL/SQL | SQL Performance Tuning | NICE Actimize IFM | Banking & Finance

About

I am a Senior Software Engineer with 6+ years of experience specializing in Oracle PL/SQL development, database design, and SQL performance tuning within the banking and financial services domain. My core expertise lies in building, enhancing, and optimizing high-performance, data-intensive backend systems. I have hands-on experience across the complete software development lifecycle (SDLC), including requirement analysis, development, testing, deployment, production support, estimation, and documentation. I have worked extensively with Oracle SQL & PL/SQL, developing complex packages, procedures, functions, and optimized SQL queries to support large-scale transactional and reporting systems. My experience includes ETL-style data processing, data validation, batch jobs, and automation using Unix/Linux shell scripting. Alongside database development, I have been involved in application upgrades, environment management, server monitoring, and release deployments, working closely with cross-functional teams such as business analysts, QA, and operations. I also have exposure to CI/CD tools, cloud infrastructure basics, and version control systems, contributing to reliable and controlled releases. I am passionate about writing clean, efficient, and maintainable code, improving system performance, and continuously expanding my skill set toward ETL, data engineering, and modern backend data platforms.

Location

Pune District

Work experience

Senior Software Engineer | NICE Actimize IFM – Client: Goldman Sachs at Xoriant, May 2025 - Present · 1 yr 1 mo, Pune, Maharashtra, India, • Working on the NICE Actimize IFM platform supporting fraud monitoring applications for Goldman Sachs. • Handling customizations and new business requirements, including enhancements to existing UI and backend components. • Actively involved in application and infrastructure upgrades, including: • ActOne, AIS, and IFM upgrades • Oracle Database upgrades • RHEL/Linux upgrades • Performing server monitoring and health checks, preparing and sharing environment health reports. • Creating and managing virtual machines using Jenkins for upgrade testing and validation. • Deploying changes across multiple environments using Unix shell scripting, including client testing and production. • Following a complete end-to-end delivery workflow: • Development in internal DEV environments • Requirement clarification with Business Analysts • QA testing and defect resolution • Client environment deployment and validation • Production deployments during scheduled weekend release windows • Preparing effort estimates, technical documentation, and release notes. • Using Wiser (NICE Actimize ticketing tool) for tracking requirements, changes, incidents, and deployments. • Coordinating with internal infrastructure and support teams for issue resolution.

Senior Developer – Client: Tata Motor Finance Limited at Tata Technologies, Nov 2023 - Apr 2025 · 1 yr 6 mos, Mumbai, Maharashtra, India, • Coordinated with the Business team to provide them with the necessary Data, reports & views. • Wrote Oracle Complex SQL Query, Procedure, Package and functions as Per Business and Functional Requirement. • Prepared functional specification (FS) document according to Business Requirements Document (BRD). • Involved in Unit Testing, Integration testing and User Acceptance. • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using Toad. • Used SQL*Loader as an ETL tool to load data into the staging tables. • Using PLSQL Procedure to first Extract data from txt file to the database in staging table and apply business logic to extract data from staging table to main table • Provide auto mail facility to business through Oracle procedure by creating database scheduler job. • Error Handling through Exception in PLSQL procedure and insert into the table and also report to the concern team through auto mail.

Software Engineer – Client: ICICI Lombard at Clover Infotech, Aug 2019 - Oct 2023 · 4 yrs 3 mos, Mumbai, Maharashtra, India, • Having database experience using Oracle 10g/11g/12C, 19C SQL, PL/SQL development and production support. • Good in understanding of business logic and ability to work well as part of team and as an individual. • Expertise in understanding the problem statement, solving the issues with business users, delivering workable solution. • Proficient in writing SQL queries, collections, cursors, triggers, sub programs like procedure, functions in pl/sql. • Ability to implement existing logic to new fuctionalities • Exposure to developing and optimizing/tuning of sql queries. • Good exposure to Oracle SQL queries • Expertise in developing SQL and PL/SQL codes through various procedures, fuctions & packages to implement the business logic. • Expertise in production support at all levels, debugging the code at production level.

Education

Bachelor of Engineering - BE, Information Technology, University of Mumbai

Diploma of Education, Information Technology, Government polytechnic thane

Prasad Chawan - Senior Software Engineer | NICE Actimize IFM – Client: Goldman Sachs in Pune District | Tal