Yogesh Garchar
Ahmedabad
Summary
PostgreSQL and Oracle PL/SQL Developer with extensive experience at Tata Consultancy Services. Specializes in database performance optimization and scalable solution development. Proficient in SQL and performance tuning, with a strong focus on collaboration. Achieved significant reductions in execution time for large datasets, improving system reliability and efficiency.
Overview
16
16
years of professional experience
Work History
PostgreSQL & Oracle PL/SQL Developer
Tata Consultancy Services (TCS)
Ahmedabad
12.2023 - Current
- Designed and optimized PostgreSQL database objects including tables, views, stored procedures, and functions.
- Improved performance through indexing and tuning, reducing execution time for large datasets.
- Supported deployment cycles, troubleshooting, and system reliability improvements.
- Developed PL/SQL packages and ETL workflows supporting Oracle E-Business Suite modules.
- Collaborated with business and analytics teams for scalable database solutions.
- Tools: PGAdmin, SQL Developer, Git, GitHub Copilot, JIRA
Oracle PL/SQL and Crystal Report Developer
DDB Mudra Group
Ahmedabad
03.2010 - 11.2023
- Developed and maintained enterprise database applications supporting campaign management, billing, sales & finance.
- Built advanced PL/SQL packages, stored procedures, and ETL logic for large advertising data volumes.
- Performed database tuning and optimized SQL queries to increase system performance.
- Designed Crystal Reports for financial and operational reporting automation.
- Provided production support and improved system automation and data accuracy.
- Tools: TOAD, Crystal Reports
Education
Oracle 9i OCP
ITS Institute
Ahmedabad03-2009
Bachelor of Arts - English
RR Lalan College
Bhuj, Kutch04-2008
Skills
- Databases: Oracle 9i/10g/12c
- PostgreSQL
- Programming: SQL
- PL/SQL
- Stored Procedures
- Functions
- Packages
- Triggers
- Performance tuning: explain plan
- Hints
- Indexing
- Query optimization
- Tools: SQL Developer
- TOAD
- PGAdmin
- Git
- GitHub
- JIRA
- Crystal Reports
- Concepts: ETL
- Data Modeling
- Production Support
- Agile
- EBS
- Gen AI Tool: Github Co-Pilot
Core Technical Skills
Oracle 9i, Oracle 10g, Oracle 12c, PostgreSQL, SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, Explain Plan, Hints, Indexing, Query Optimization, SQL Developer, TOAD, PGAdmin, Git, GitHub, JIRA, Crystal Reports, ETL, Data Modeling, RCA, Production Support, Agile, EBS, Github Co-Pilot
Timeline
PostgreSQL & Oracle PL/SQL Developer
Tata Consultancy Services (TCS)
12.2023 - Current
Oracle PL/SQL and Crystal Report Developer
DDB Mudra Group
03.2010 - 11.2023
Oracle 9i OCP
ITS Institute
Bachelor of Arts - English
RR Lalan College