Prakash Kumar
Kolkata
Summary
A dedicated and enthusiastic professional with 5 years of experience in IT sector application development and maintenance and currently seeking a good opportunity to take my carrier to the next level.
Overview
5
5
years of professional experience
1
1
Certification
Work History
System Engineer
Tata Consultancy Services
Kolkata
05.2022 - Current
- Involved in all phases of the SDLC, from analysis, design, development, testing, implementation, and maintenance, with timely delivery and aggressive deadlines.
- Perform deep-dive analysis of complex issues and collaborate with infrastructure teams, QA, etc.
- Involved in development of complex database objects like stored procedures, packages, triggers, functions, including indexes, views, and materialized views.
- Develop batch processes for financial reporting applications and modules using Unix and shell scripts on Oracle database, with partitions and sub-partitions.
- Work on migration to cloud-based technologies and migration to PG-SQL database from Oracle.
Associate
Cognizant Technology Solutions
Bangalore
10.2019 - 05.2022
- Work on Banking Loan Application projects and do changes related to moratorium at database level.
- Worked on SQL*Loader to load data from flat files obtained from various source system for business work.
- Created scripts to create new tables, views, queries using toad for new enhancements and automations of daily production requirements.
- Worked on SQL and PLSQL tuning of queries to better execution of jobs and queries.
- Worked on Database upgrade from 11g to 19c.
Education
Bachelor of Technology - Electrical Engineering
West Bengal University of Technology
Kolkata06-2019
High School Diploma - Bachelor of Technology
Chinmaya Vidyalaya
Bokaro Steel City Skills
- Oracle SQL and PL/SQL
- MS-SQL
- Unix Shell scripting
- PG-SQL
- MS Azure Basics
- Python Basics
- ETL tools
- Autosys
- Toad
- SQL Developer
- PLSQL developer
- Bash, Visual Studio
- Pycharm
Certification
- Best Resource Award from Client including many appreciations at each deliverables.
- AZ900 Certified (Certification Number : I395-5209) .
- Microsoft AWS certification (pursuing)
Languages
Hindi
First Language
English
Proficient (C2)
C2
Timeline
System Engineer
Tata Consultancy Services
05.2022 - Current
Associate
Cognizant Technology Solutions
10.2019 - 05.2022
Bachelor of Technology - Electrical Engineering
West Bengal University of Technology
High School Diploma - Bachelor of Technology
Chinmaya Vidyalaya
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Sourav MukherjeeSourav Mukherjee
Senior Cloud Tester at Koerber PharmaSenior Cloud Tester at Koerber Pharma