Oracle Database Developer with 14+ Years Experience

Vishal P. Raut

Shivshaktti Appt, Sec **, Sanpada, Navi Mumbai

Mobile: +91-950******* / +91-880******* Email: ******.******@*****.***

OBJECTIVE

Seeking a challenging role in Database Development to leverage my expertise in Oracle SQL and PL/SQL, driving quality, innovation, and continuous learning in a dynamic environment.

SUMMARY

•IT Professional with a B.E. in Computer Science Engineering and over 14+ years of experi- ence in Oracle Database, SQL, and PL/SQL (11g/19c) development on Windows and UNIX platforms.

•Proficient in PL/SQL programming, including cursors, procedures, functions, packages, trig- gers, views, indexes, sequences, exception handling, constraints, joins, and subqueries.

•Experienced in performance-oriented SQL query optimization and runtime exception han- dling using pre-defined and user-defined exceptions.

•Skilled in coding, debugging, testing, and documentation, with expertise in Oracle Forms and Reports 10g for ERP solutions.

•Currently serving as an Oracle Developer at IDBI Bank (Data Center), CBD Belapur, with contributions to external projects like South Indian Bank.

•Strong client communication skills, adept at requirement analysis and proposing effective solutions.

TECHNICAL SKILLS

•Databases: Oracle 11g, Oracle 19c, MySQL

•Utilities: Oracle Forms 10g, Reports 10g, PL/SQL Developer

•Languages: SQL, PL/SQL, T-SQL

•Development Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Ser- vices (SSRS), SQL Server Analysis Services (SSAS), Crystal Reports

•Operating Systems: Windows, UNIX

EDUCATION

B.E. in Computer Science & Engineering 2009

Sant Gadge Baba Amravati University, Amravati

PROFESSIONAL EXPERIENCE

•Oracle Developer, IDBI Bank (Data Center), CBD Belapur Aug 2021 – Present

•Senior Software Engineer (Oracle PL/SQL Developer), Clover Infotech Pvt. Ltd. (De- ployed at Mahindra & Mahindra Finance, Mumbai) Jun 2017 – Aug 2021

•Software Engineer (Oracle PL/SQL Developer), Cryptograph Technologies (Deployed at Tech Mahindra, SBI Life Insurance) Sep 2016 – Jun 2017

•Software Engineer (Oracle PL/SQL Developer), Triumph Systems and Solutions Pvt. Ltd. (Deployed at ICICI Bank, Mumbai) Jun 2015 – Jul 2016

•Software Engineer, Magna InfoTech Pvt. Ltd. (Deployed at ATOS India Pvt. Ltd.) Jan 2015 – May 2015

•Software Engineer, Virtual Galaxy InfoTech Pvt. Ltd. Jun 2011 – Dec 2014

TRAININGS

•Oracle Certified Associate (OCA) – Oracle 9i Database Administration, Path InfoTech Pvt. Ltd., Noida (Oracle University)

•Oracle PL/SQL on Linux, Wilshire Software Technologies, Hyderabad Mar 2010 – Apr 2010

•Oracle 9i DBA on Linux, Path InfoTech Pvt. Ltd., Noida Aug 2009 – Nov 2009

•Oracle Forms and Reports on Windows, Metasoft Solution, Nagpur

WORK EXPERIENCE IN PROJECTS

Income Recognition and Asset Classification

Internal Project: IDBI Bank (Data Center), CBD Belapur

External Project: South Indian Bank Aug 2021 – Present

Role: Oracle Developer Environment: Oracle 19c, UNIX, MySQL Team Size: 10

Developed stored procedures, views, and functions to identify Non-Performing Assets (NPA) per RBI guidelines, fetching data from FINACLE servers for asset classification. Supported pan-India business and bank users by resolving application bugs and ensuring system reliability. Conducted requirement gathering and testing to deliver robust solutions.

Loan Operating & Management System

Client: Mahindra & Mahindra Finance Jun 2017 – Aug 2021 Role: Senior Software Engineer (Oracle PL/SQL Developer) Environment: Oracle 11g Team Size: 12

Migrated legacy Oracle Forms-based loan processing application to a Java framework, developing procedures and functions by analyzing trace data. Performed database performance tuning, created business intelligence reports, and integrated web services using PL/SQL. Supported system analysis, design, and documentation for enhanced functionality.

Management Information System (MIS)

Client: SBI Life Insurance, Mumbai Sep 2016 – Jun 2017 Role: Software Engineer (Oracle PL/SQL Developer) Environment: Oracle 11g, MSBI, SSIS, SSRS, SQL Server Team Size: 10

Developed complex PL/SQL queries, functions, and procedures for a data warehouse, optimizing per- formance using explain plan utilities. Designed SSIS packages and SSRS reports, including tables, matrices, and dashboards for insurance data analytics. Coordinated user acceptance testing (UAT) and maintained reports to meet client requirements.

Automated Data Flow – RBI Regulatory Returns

Client: ICICI Bank, Mumbai Jun 2015 – Jul 2016

Role: Software Engineer (Oracle PL/SQL Developer) Environment: Oracle 11g, SAS,

UNIX, Windows Server 2008 Team Size: 12

Automated regulatory return submissions to RBI by developing procedures and functions with cur- sors and nested loops for data consistency. Conducted requirement gathering, data analysis, and report maintenance to ensure accurate submissions. Coordinated UAT and resolved issues to meet regulatory standards.

ERP Software Development – Thomas Built Buses

Client: Thomas Built Buses Jan 2015 – Jun 2015 Role: Software Engineer Environment: Oracle 11g, Forms 10g, Reports 10g

Team Size: 10

Developed and debugged Oracle Forms for the Sales Order Management module of an ERP system for bus manufacturing. Customized reports and resolved client issues to ensure seamless integration of sales processes. Contributed to functional and technical specifications for efficient application deployment.

ERP Software Development – Aryan Sugars Pvt. Ltd.

Client: Aryan Sugars Pvt. Ltd. Jun 2011 – Dec 2014 Role: Software Engineer Environment: Oracle 11g, Forms 10g, Reports 10g

Team Size: 6

Designed and developed master and master-detail forms for ERP modules including Cane Purchase, Weighbridge, Finance, Sales, and Stock Management. Created stored procedures, functions, and triggers to support business logic, and customized reports for operational efficiency. Conducted pre-

and post-deployment testing and user role management.

CO-CURRICULAR ACTIVITIES

•Participated in National Level Poster Presentation at INSIGHT-2008, Anuradha Engineering College, Chikhli, Maharashtra.

•Won awards in Painting Competitions for sketches and posters.

• Actively participated in National Service Scheme (NSS) Camp.

PERSONAL PROFILE

•Father’s Name: Purushottam K. Raut

•Date of Birth: October 7, 1978

•Address: Shivshaktti Appt, Sec 08, Sanpada, Navi Mumbai

Contact this candidate