Summary
Overview
Work History
Education
Skills
Accomplishments
Hobbies
Timeline
Generic

Sandeep Kumar

New Delhi

Summary

Professional developer with passion for high-quality software solutions. Specialized in PL-SQL development, SQL optimization, and exhibiting strong problem-solving and time management skills. Highly reliable team player with focus on collaboration and adaptability. Skilled in software architecture, coding, and agile methodologies.

Overview

9
9
years of professional experience

Work History

PLSQL Developer

Tata Consultancy Services Ltd - Deutsche Bank
08.2015 - Current
  • Worked on creating, maintaining and migration of complex process of rating calculation for companies in Banking domain from legacy to highly optimized data model.
  • Involved in migration and new design setup model for highly efficient and data centric model for maintaining historical data based on business days, audit information, applications based mutations using GraphQL schemas and Data Access Layer (DAL) application.
  • Migration of SQL queries, views, mviews, procs and other database objects from old model to new optimized data model involving structure and query optimization.
  • Worked in workflow based application to design various processes to trigger warnings, notifications to business users based on calculated events and configurable through UI based on database logical expressions.
  • Supported various live deliveries with batches, database deployment and datafixes.
  • Conducted comprehensive code reviews, ensuring adherence to established coding standards and improving overall code quality.
  • Discussed project progress with customers, collected feedback on different stages and directly addressed concerns.
  • Developed scalable applications for efficient data processing and management.
  • Contributed to the architecture design of complex software systems, ensuring scalability and maintainability.
  • Optimized algorithms for enhanced computational efficiency, reducing processing times significantly.
  • Mentored junior developers, providing guidance on best practices and coding techniques for improved productivity.
  • Delivered high-quality code on time by effectively managing project timelines and prioritizing tasks accordingly.

Education

Bachelor of Science - Computer Science

G B Pant University of Agriculture & Technology
Pantnagar, India
06-2015

High School Diploma -

Kendriya Vidyalaya 2 NHPC
Uttarakhand
06-2010

High School Diploma -

Kendriya Vidyalaya 2 NHPC
Uttarakhand
06-2008

Skills

  • Expertise in PL-SQL programming - stored procedures, functions and packages
  • Highly efficient in SQL optimization techniques for query performance tuning
  • High experience in creating tables, view, mvies, triggers, cursors, user defined exception, indexes
  • Experienced in creating procedures bases on pragma autonomous transactions for real time application
  • High problem-solving generic abilities and SQLs based on analytic functions
  • Decision-making, architecture design and flow for data
  • Good knowledge of DBA related activities to support ongoing tuning and query execution work
  • Experienced in Control-m based batch creation and execution
  • Experience of creating advanced logical programs based on real world requirements based on language like C, C, Python
  • Good knowledge of data structure concepts including linked list, arrays, stack, binary trees, sort
  • Basics of No-SQL MongoDB based on JSON

Accomplishments

  • Delivered multiple project work based on SQL in record time and in efficient manner.
  • Multiple Star of the Month awards - TCS Awarded for significant contributions in multiple major releases.
  • Multiple Best Team Award, TCS - Honored for exceptional teamwork in meeting project deadlines and delivering high-quality solutions.

Hobbies

  • Cricket
  • Badminton
  • Computer games

Timeline

PLSQL Developer

Tata Consultancy Services Ltd - Deutsche Bank
08.2015 - Current

Bachelor of Science - Computer Science

G B Pant University of Agriculture & Technology

High School Diploma -

Kendriya Vidyalaya 2 NHPC

High School Diploma -

Kendriya Vidyalaya 2 NHPC
Sandeep Kumar