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, India06-2015
High School Diploma -
Kendriya Vidyalaya 2 NHPC
Uttarakhand06-2010
High School Diploma -
Kendriya Vidyalaya 2 NHPC
Uttarakhand06-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
Similar Profiles
Kapil SharmaKapil Sharma
Senior Business Analyst – Digital & Payments at Tata Consultancy Services (Client- NAB)Senior Business Analyst – Digital & Payments at Tata Consultancy Services (Client- NAB)
RUSHIKESH KADAMRUSHIKESH KADAM
Assistant Consultant at Tata Consultancy Services: Deutsche BankAssistant Consultant at Tata Consultancy Services: Deutsche Bank
ROSHIL RAJUROSHIL RAJU
Project Manager at Tata Consultancy Services | Deutsche BankProject Manager at Tata Consultancy Services | Deutsche Bank
Manvendra KumarManvendra Kumar
Manager- Finance & Costing at Genpact India Private LimitedManager- Finance & Costing at Genpact India Private Limited
Rohit PajhalRohit Pajhal
Director Network Operations at Indian Air ForceDirector Network Operations at Indian Air Force