Tejas Pawar (TSP)
Oracle PL/SQL Developer | Power BI Data Analyst (PL-300) | 3+ Years @ TCS
Hire this person
Send a job offer directly to this candidate
About
Oracle PL/SQL Developer with 3+ years of experience at Tata Consultancy Services, specialising in Oracle Database 19c development, SQL query optimisation, and database performance tuning. Proven expertise in designing and optimising PL/SQL packages, stored procedures, functions, triggers, cursors, and exception handling.
Microsoft Certified
Power BI Data Analyst (PL-300) with hands-on experience in ETL processes, data modelling, and data migration. Adept at Agile/Scrum delivery and cross-functional collaboration to deliver secure, scalable, high-quality database solutions.
Experience
Oracle PL/SQL Developer - Tata Consultancy Services (TCS) - Mumbai, Maharashtra
(2022-10)
- Designed, developed, and optimised Oracle PL/SQL packages, stored procedures, functions, and triggers on Oracle 19c, improving code reusability and reducing deployment errors by 30%.
- Implemented advanced PL/SQL constructs — cursors, REF cursors, exception handling, Bulk Collect/FORALL, dynamic SQL, and collections — reducing average query execution time by 40%.
- Developed and optimised complex SQL queries using indexing, partitioning, and execution plan analysis to improve query performance by up to 50%.
- Collaborated with application developers to design database schemas, scripts, and data models enabling seamless integration across 5+ enterprise applications.
- Implemented ETL processes and data migration strategies, successfully migrating 10+ GB of legacy data with zero data loss and 99.9% uptime.
- Managed database backup, disaster recovery, and database security protocols, reducing system downtime by 25% through proactive monitoring.
- Provided technical support and defect resolution across Dev/QA/Production environments, resolving 95% of reported issues within SLA timelines.
- Created and maintained technical documentation (knowledge base articles, troubleshooting guides), improving team onboarding time significantly.
- Contributed to Agile/Scrum sprints and code reviews, driving a 20% reduction in post-release defects.
- Deployed production-ready applications across multiple environments with rollback procedures ensuring smooth releases.
Education
Bachelor of Engineering - Electronics & Telecommunication - MCT's Rajiv Gandhi Institute of Technology, Mumbai University (2022-08)
