SQL Lead (Freelance) - Infy Hive Technologies
(2025-03 - 2025-07)
Client: Direct ChassisLink, Inc. (DCLI) | Domain: Transport and Logistics
- Optimized 10+ reporting queries for chassis and transaction data covering 80,000+ records using Oracle views, reducing report runtime from over 20 minutes to under 5 minutes.
- Partitioned 7 high volume tables by transaction date and region using Oracle table partitioning, improving query I/O and parallel execution.
- Analysed execution plans using Oracle SQL Developer to identify missing indexes and join issues, stabilising daily reporting.
Technical Architect - Nityo Infotech
(2024-03 - 2024-06)
Client: Infosys | Project: Trade Execution Reporting | Domain: Banking and Financial Services
- Gathered and analysed business requirements from stakeholders to design and develop reporting solutions covering trade transactions, fund details, broker information and client data.
- Delivered automated CSV and PDF reports for trade and fund data using Oracle 19c PL/SQL, reducing manual effort by 60%.
- Built and tuned 5+ PL/SQL procedures using collections, BULK COLLECT and ref cursors, improving execution time by 40%.
- Reduced report runtime from 30 minutes to 10 minutes by tuning SQL using execution plans and indexes.
- Executed unit testing with 90% coverage using PL/SQL test scripts, lowering production defects by 40%.
System Analyst, Oracle PL/SQL and UNIX Shell Scripting - Hexaware Technologies
(2021-03 - 2023-05)
Project: Portfolio Management and Liability Driven Investment | Domain: Banking and Financial Services
- Developed 2 PL/SQL packages and 9 procedures on Oracle 19c to meet functional requirements, loading equity and portfolio files through ETL validation.
- Monitored and analysed Oracle database performance using AWR reports and execution plans.
- Improved SQL performance within procedures from 15 minutes to 2 minutes by tuning queries with execution plans, optimizer hints and indexes.
- Automated 10+ batch processes using UNIX shell scripts integrated with Oracle procedures.
- Migrated 70+ jobs from FTP to SFTP using Linux shell scripts, meeting 100% security compliance.
- Scheduled and monitored 30+ production jobs using Control-M, reducing Sev-2 and Sev-3 incidents by 30%.
Technical Lead - Tech Mahindra
(2018-01 - 2019-11)
Project: Bill of Materials Application | Domain: Telecom
- Developed and enhanced Oracle SQL and PL/SQL components for a Bill of Materials application supporting telecom operations.
- Worked alongside the development team on live production issues, carrying out code fixes and data corrections to restore service.
- Scheduled UNIX jobs running PL/SQL packages and procedures through the Control-M scheduler.
Application Development Specialist - Jconnect Infotech
(2017-07 - 2017-12)
Domain: Finance
- Developed Oracle PL/SQL components for a finance application covering transaction processing.
- Created UNIX shell scripts to automate loading of incoming transaction feed files and to schedule the associated jobs.
Application Development Team Lead - Accenture
(2010-08 - 2017-04)
Domains: Telecom, Life Sciences
- Built 13+ procedures, 5 packages, 25 tables, 5 views and 3 materialized views using Oracle SQL and PL/SQL, supporting enterprise applications across multiple clients.
- Wrote 6+ SQL*Loader scripts to load incoming feed files into target database tables.
- Improved stored procedure response times from 11 to 16 minutes down to 4 to 7 minutes through SQL tuning, indexing and table partitioning.
- Created 4+ UNIX shell scripts to transfer feed files from the landing directory to the database directory using FTP, load the data through SQL*Loader, and archive processed files.
- Scheduled 12+ UNIX jobs running PL/SQL packages and procedures through the Control-M scheduler.
- Monitored 30+ production jobs using Control-M, resolving Sev-2 and Sev-3 tickets within SLA and lowering defects by 30%.
- Prepared 3 technical design documents for new business requirements and updated design content for existing applications under change requests.
Software Engineer - Future Focus Infotech
(2010-06 - 2010-08)
Domain: Telecom
- Developed Oracle PL/SQL components to capture and maintain telecom equipment information.
Senior Software Engineer - Melstar Technologies
(2009-09 - 2010-02)
Project: CRM Application | Domain: Telecom
- Developed Oracle PL/SQL procedures, packages and functions for a telecom CRM application.
- Automated batch processing using UNIX shell scripting.
- Prepared module level technical documentation for the development team.
Software Engineer - Wipro Technologies
(2006-07 - 2009-05)
Domains: Telecom, Media, Manufacturing, Retail
- Developed Oracle SQL and PL/SQL components supporting enterprise applications across telecom, media, manufacturing and retail clients.
- Provided production support, investigating and resolving live application and database issues.
Programmer, IT Infrastructure - JSYS (Contract), Government of Karnataka
(2001-06 - 2006-07)
World Bank Irrigation Project | Domain: Government, Water Resources
- Led a team of 5 members at the State Project Unit in Bangalore and coordinated around 8 district programmers across project units.
- Maintained the MIS section infrastructure including server and client nodes, networking and software installation across district offices.
- Collected and consolidated project data from district offices and uploaded it to the State Project Unit in Bangalore for centralised reporting.
- Generated MIS reports and submitted them to management for project monitoring and analysis.
- Supported procurement planning by defining hardware and software infrastructure requirements.
Programmer Trainee - Hindustan Latex Ltd
(1999-02 - 2001-06)
Domain: Manufacturing, Healthcare
- Modified and enhanced the existing Management Information System application to suit the Belgaum branch office.
- Covered Production, Stores, Purchase and Marketing modules using Oracle and PL/SQL.
