Senior Programmer / Oracle PL/SQL Backend Developer at Sahara India (2023-04 – Present)
Leading backend development for the CRCS Verification Admin Portal, designing scalable and high-performance database solutions.
- Leading backend development for the CRCS Verification Admin Portal, designing scalable and high-performance database solutions
- Developing complex Oracle PL/SQL packages, procedures, functions, and triggers to implement business logic
- Building PL/SQL-based APIs to support UI functionality and ensure efficient application–database interaction
- Writing advanced SQL with analytical functions, BULK COLLECT, FORALL, MERGE, and dynamic SQL for high-volume data processing
- Performing performance tuning using execution plans, indexing strategies, and query optimization
- Designing and managing database objects including tables, views, materialized views, synonyms, sequences, and indexes
- Managing large-scale data migration and daily batch loads using SQL Loader with strong validation controls
- Ensuring data integrity through transaction management, exception handling, and auditing mechanisms
- Supporting legacy components with MS Visual FoxPro while maintaining system stability
- Collaborating with cross-functional teams, handling production support, and managing deployments across environments
Programmer / Oracle PL/SQL Support at Net-Reach Software Ltd. (2022-10 – 2023-03)
Delivered remote Oracle PL/SQL production support to international clients, ensuring high system availability and performance.
- Delivered remote Oracle PL/SQL production support to international clients, ensuring high system availability and performance
- Engineered and optimized complex SQL and PL/SQL (packages, procedures, triggers, functions) to support business-critical applications
- Led code debugging, performance tuning, and query optimization using Explain Plan, indexing, and optimizer hints
- Managed the full development lifecycle – requirement analysis, development, testing, deployment, and post-production support
- Implemented change requests and drove continuous improvements, enhancing database efficiency, stability, and processing speed
Senior Programmer / Oracle PL/SQL Developer at Sahara India Financial Corp. Ltd (2007-04 – 2022-09)
Collaborated within a 4-member technical team to deliver Financial Accounting (FA) reporting systems for DGM (IT), ensuring accuracy and timely data availability.
- Collaborated within a 4-member technical team to deliver Financial Accounting (FA) reporting systems for DGM (IT), ensuring accuracy and timely data availability
- Designed, developed, and maintained complex Oracle PL/SQL components including packages, procedures, triggers, and functions for mission-critical applications
- Engineered advanced SQL queries with multi-table joins and subqueries to support reporting and high-volume data processing
- Led debugging, performance tuning, and query optimization using Explain Plan, indexing strategies, and optimizer hints
- Managed end-to-end lifecycle activities – development, change implementation, testing, production support, and continuous system improvements
Programmer / Oracle Developer at Sahara India Financial Corp. Ltd (1995-06 – 2007-03)
Developed complicated SQL statements with joins and subqueries, handled development, support, testing, and enhancement of business-critical PL/SQL scripts.
- Developed complicated SQL statements with joins and subqueries
- Handled development, support, testing, and enhancement of business-critical PL/SQL scripts
- Optimised PL/SQL code and SQL queries using Explain Plan, Analyse, Indexes, and Hints to improve performance
- Worked as independent in-charge of the FA (Financial Accounting) Data Finalisation Team, reporting to the Assistant Manager
