Summary
Overview
Work History
Education
Skills
Core Technical Skills
Timeline
Generic

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
Ahmedabad
03-2009

Bachelor of Arts - English

RR Lalan College
Bhuj, Kutch
04-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
Yogesh Garchar