Vishal Chauhan
Pune
Summary
Skilled PLSQL Developer with comprehensive experience in database design, development, and optimization. Possess deep knowledge of Oracle Database Server technology and strong analytical skills for complex problem-solving. Notable ability to deliver high-quality work on tight schedules while maintaining focus on project coordination and team collaboration. Previous work has resulted in significant improvements in system efficiency and data integrity.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Senior Associate/ PLSQL Developer
Cognizant
Pune
05.2022 - Current
- Worked as an EDI Developer for a healthcare clearing house, leveraging PL/SQL to process and validate EDI transactions.
- Performing enhancement/intakes on the existing jobs according to new requirement or issue.
- Performed detailed functional study, requirement analysis, existing programs, unit testing and implementation.
- Preparing test scenarios that would effectively verify whether a functionality change is working.
- Developed and optimized backend logic for claims routing, error handling, and acknowledgment automation.
- Used MS SSIS to build ETL workflows for data integration and reporting. Also supported data processing for clinical modules including Nurse Notes, Transition of Care Management (TCM), Field Case Management (FCM), and Utilization Review (UR), ensuring smooth coordination between clinical and claims systems.
- US based healthcare project - Genex Services
Senior PLSQL Developer
Nityo Infotech
Mumbai
03.2019 - 04.2022
- Built a secure transaction platform for Key Partners to manage customer financial operations (FD creation, withdrawals, loans, renewals, repayments, TDS).
- Enabled real-time customer approval via SMS authentication.
- Developed SQL-based reporting queries (deposit collections, performance, earnings trends).
- Developed a module for Key Partner (KP) empanelment to onboard and manage business partners authorized to perform financial transactions on behalf of customer.
- Included functionality for capturing partner details, validating credentials, assigning access rights, and setting transaction limits.
- Automated customer KYC re-validation through CKYC and Aadhaar XML integration.
- Implemented classification system (HIGH, MODERATE, LOW) to monitor and track KYC expiry.
- Designed SMS/email notification workflows to ensure timely compliance.
- Developed feature for customers to update maturity instructions before deposit renewal or repayment.
- Automated reminder system via SMS/email to notify customers of upcoming maturity actions.
- HDFC Limited – Investment Banking Sector
Senior PLSQL Developer
Paramount Health Services
Thane
11.2017 - 02.2019
- The application is utilized by Third-Party Administrators (TPAs), insurance companies, and corporate organizations to efficiently track and manage claim-related details, ensuring a seamless and transparent claims processing experience.
- Collaborated with the front-end design team to develop and optimize stored procedures and packages, ensuring seamless data integration and providing insights for efficient application functionality.
- Converted daily schedule report into live report using triggers.
- Involved in the continuous enhancements and fixing the production problems.
- Uploading excel data in the database tables using xml procedures.
- Writing complex queries for creating reports for different insurance company.
- Debugging procedures using oracle SQL developer tool.
- Tuning the reports queries.
- Creation of database objects like tables, views, indexes, sequences, synonyms, procedures and functions, packages using oracle tools like PL/SQL Developer.
- TPA Insurance – Medical Claim Processing System
Associate/ Developer
Tata Consultancy Services
Mumbai
05.2015 - 10.2017
- Performance Optimization for Daily Interest Calculation (EOD): This project aimed to optimize the response time of scheduled jobs involved in daily interest calculations while enhancing the understanding of the Bancs-24 lifecycle.
- Optimized interest calculation schedule job by reducing DB calls to improve system performance by 30%.
- Interest Calculation: This facility is tuned by reducing DB calls and shared memory access in SBI EOD that provides interest accumulation options to the bank’s customers.
- SMS: This facility generates sms alerts for various charge deductions running in single stream has been converted into multi-stream approach for faster processing and reduced time.
- Disaster Recovery Drills and Production Promotion Assistance.
- Guiding other team members in resolving production issue.
Data Programmer
Ugam Solution
Mumbai
07.2013 - 10.2014
- Developing complex custom reports based on the client requirement.
- Verifying my own deliverables before sending reports to QA and clients.
- Resolving QA identified data issues.
- Ensuring deliverables sent to client on time & without any errors.
- Interacting with clients on project when needed.
- Market Research data programmer – IPSOS Client
Education
Bachelor’s Degree - Information Technology
Patkar Varde
Mumbai01.2013
Higher Secondary Education -
Jr. SVIS College
Mumbai01.2010
Secondary Education -
RC Patel High School
Borivali (W)01.2008
Skills
- Oracle SQL
- Oracle PL/SQL
- Performance tuning
- Unix shell scripting
- Oracle Forms and Reports
- T-SQL (MSSQL)
- Oracle SQL Developer
- SQL Loader and external tables
- Oracle BI Publisher
- Cloud platforms (Azure, AWS)
- SQL Server Integration Services (SSIS)
- ETL workflows
- Power BI
- Python
- Spark and PySpark
- Databricks
- LLM and Langchains
Certification
- Oracle Database SQL Expert (1Z0-047)
- OCA Oracle Database 11g : Administration I (1Z0-052)
- Oracle Cloud Infrastructure 2022 (IZ0-1085-22)
Personal Information
Total Experience: 11 years
Timeline
Senior Associate/ PLSQL Developer
Cognizant
05.2022 - Current
Senior PLSQL Developer
Nityo Infotech
03.2019 - 04.2022
Senior PLSQL Developer
Paramount Health Services
11.2017 - 02.2019
Associate/ Developer
Tata Consultancy Services
05.2015 - 10.2017
Data Programmer
Ugam Solution
07.2013 - 10.2014
Bachelor’s Degree - Information Technology
Patkar Varde
Higher Secondary Education -
Jr. SVIS College
Secondary Education -
RC Patel High School