• Nagpur Maharashtra
Sarang Vaidya

Sarang Vaidya

Oracle Developer


Looking forward for a career in Database Development where I can exercise my expertise and knowledge that fosters quality, creativity and continuous learning.

Experience Summary

  • Over 3.10 years of programming experience as an Oracle PL/SQL Developer using the Oracle Relational Database Management System (RDBMS).
  • Involved in all phases of the Software Development Life Cycle from analysis, design, development, testing and maintenance with timely delivery against aggressive deadlines.
  • Experience with Data Modeling and Database normalization theory.
  • Good knowledge of key Oracle performance related features such as SQL Tuning, Explain Plan, Indexes, Clusters and Hints.
  • Effectively made use of Collections, Indexes, Table Partitioning, Analytical functions, Materialized Views.
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers.
  • Expertise in use of JOIN, Ref Cursor, Dynamic SQL, and Exception handling.
  • Loaded Data into Oracle Tables using SQL Loader and External tables from external data files.
  • Use of Global Temporary Table to record user session data and session logs.
  • Use of Oracle provided utilities like utl_file, utl_smtp, dbms_ddl and wrap.
  • Created Shell Scripts for invoking SQL scripts and scheduled them in crontab. Effectively used basic UNIX commands to search and manipulate the scripts.
  • Excellent Communication, Interpersonal and Analytical skills and strong ability to perform as part of a team.


  • Promoted to Lead Developer after 18 months of employment.
  • Got 3 times Nielsen Star of the Month award.
  • Did numerous SIPs (System Improvement Process) and Automations of repeating issues in the project.
  • Published numerous white papers and Ideas in Knowmax portal of TCS.

Technical Skills

  • Databases: Oracle 10g/11g (SQL, PL/SQL)
  • Operating Systems: Windows XP/Vista/ 7, UNIX, LINUX, MAC
  • Data Modeling: SQL Developer Data Modeler
  • Languages/Utilities: SQL, PL/SQL, UNIX shell scripting, HTML, XML, SQL*Plus
  • Other Tools: Oracle SQL Developer, SQL Navigator, Putty, Winscp, Tortoise SVN, Fiddler, Advance rest client, Notepad++



Bachelor of Engineering

2007 - 2011
G. H. Raisoni College of Engg.

With specialisation in Computer Science and Engineering, RTMNU, Nagpur, India, 2011

Work History

Work History

Lead Developer

Oct 2014 - Present
Tata Consultancy Services Ltd

Digital Data Reference System

DDRS (Digital Data Reference System) is the singular tool which allows user to classify the digital information like sites, streams, audio, video, mobile apps, pc apps etc. among all the brands/ channels across the globe.

Reverse engineering, Debugging business logic of existing applications, Analyzing and gathering the requirements, Creating ERD model and CRUD matrix for database design, Allocating the tasks to the team, Core development, Unit and integration testing.

Software Developer

Nov 2013 - Sep 2014
Tata Consultancy Services Ltd

TOOLS Database Migration from Oracle 10g to 11g

This project is about to migrate TOOLS database server to new 11g database server. The project scope includes Migrating data and code, change in database objects like database links, code and server configuration, web application configuration, scheduled jobs. Also lot of effort includes coordinating with all the teams which are using the TOOLS database.

Requirement and gathering, Technical and functional design, Reverse engineering the tools based on the database, Analyzing all the changes required for 10g to 11g migration, Working with DBA, UNIX server configurations, Communicating with the Business Users.

Software Developer

Dec 2011 - Oct 2013
Tata Consultancy Services Ltd

Recruitment Application for online subscribers

Panel recruitment is conducted using a proprietary methodology that combines the representativeness of a Random Digit Dial (RDD) panel with the depth provided by an online-recruited panel (Mega-Panel). This methodology provides a baseline for representative demography and online behaviour. To invite the panellists for recruitment there are monthly incentives and lucky draws for active panellists.

Requirement gathering, Project estimation and cost analysis, ERD model, Technical and functional design, Core Development, unit and integration testing, Organizing and syncing the code into the repository, Communicating with Business users, Coordinate with the Different team involved in the project.

Personal Details

Date of Birth                       April 27, 1988

Sex                                         Male

Nationality                           Indian

Marital Status                     Single

Current Location               Pune, India

Languages Speak               English, Hindi, Marathi

Hobbies                                 Hiking, Shopping, Table Tennis, Chess