Pranav Kumar

Software Engineer

Tata Consultancy Services•  December 2021 - March 2023•  Bangalore

SQL Proficiency: Attained a mastery level proficiency in SQL, achieving a 98% accuracy rate in querying and manipulating datasets, ensuring impeccable data integrity and accuracy throughout the analysis process. Database Design: Spearheaded the creation of PostgreSQL database tables with a 95% adherence to project criteria, employing careful query design to ensure tables met precise specifications. Data Quality Assurance: Conducted thorough end-to-end testing of incoming data, utilizing SQL-based checks including null value and date format validations to achieve a 97% accuracy rate in data quality and completeness validation, ensuring high reliability. Stakeholder Collaboration: Engaged with source teams to address and resolve data quality issues, fostering effective communication channels that led to a 95% improvement in data accuracy and reliability over time. Database Maintenance: Leveraged SQL expertise to craft precise queries for updating, deleting, and altering dataset structures within PostgreSQL databases, maintaining data currency and alignment with evolving project requirements at a 98% success rate. Developer Support: Provided invaluable support to developer teams, offering SQL-based insights and assistance that resulted in a 20% improvement in database performance and a 30% reduction in data processing time, thereby enhancing overall project efficiency and success. Version Control with Git: Engineered a robust version control workflow using Git and GitHub, facilitating seamless code integration and enhancing team productivity; resulted in a 25% decrease in project delivery timeline and improved code quality by 30%.