Prachi Kumari
Kolkata
Summary
Results-driven Data Engineer skilled in ETL development, SQL optimization, and database management. Proven ability to design efficient data solutions that enhance performance and support collaborative team efforts.
Overview
6
6
years of professional experience
Work History
Data Engineer
Tata Consultancy Services
Kolkata
11.2023 - Current
- Developed data processing pipelines using Python and SQL for efficient data transformation.
- Designed and developed ETL processes for loading enterprise data into Data Warehouse.
- Optimized SQL queries and database schemas to enhance data retrieval performance.
- Collaborated with teams to gather requirements for new data initiatives.
- Participated in code reviews, ensuring adherence to best coding practices and standards.
- Assisted in maintaining data quality through rigorous validation and cleaning processes.
- Created stored procedures to automate periodic tasks in SQL Server.
- Researched database management best practices and optimization techniques.
Backend Developer
Tata Consultancy Services
Kolkata
08.2022 - 11.2023
- Designed and maintained backend components for core banking applications using TCS BaNCS framework.
- Implemented business logic and transaction processing modules aligned with BFSI requirements.
- Developed and optimized APIs to support enterprise-grade banking operations.
- Conducted schema design, query optimization, and data integrity assurance for relational databases.
- Ensured application security and performance compliance with banking standards.
- Participated in requirement analysis and technical design discussions for impactful outcomes.
- Performed debugging and root-cause analysis for production and UAT issues.
- Supported deployment activities, version upgrades, and post-production maintenance tasks.
Support Engineer
Tata Consultancy Services
Kolkata
03.2020 - 08.2022
- Adapted testing processes within Agile environment to enhance STLC efficiency.
- Implemented triggers, stored procedures, functions, and packages at database and form levels using PL/SQL, focusing on performance tuning.
- Developed procedures and packages for order reconciliation and stock level calculations in Supply Chain module.
- Conducted disaster recovery testing across various SCM applications.
- Migrated ODI codes between environments, ensuring compliance with documentation standards.
- Coordinated with onshore-offshore teams to uphold product quality.
- Collaborated with team and business analysts to identify automation opportunities and execute manual testing where needed.
- Upgraded Web Logic server across multiple SCM and GBF applications.
Education
Masters of Computer Application - Computer Science
Sastra Deemed University
Thanjavur, India04-2022
Bachelor of Computer Applications - Computer Application
Ranchi Women's College
Ranchi06-2019
Skills
- Data processing
- ETL development
- SQL optimization
- Database management
- API development
- Data architecture
- Python
- Java
- SOA
Languages
English
Advanced (C1)
C1
Timeline
Data Engineer
Tata Consultancy Services
11.2023 - Current
Backend Developer
Tata Consultancy Services
08.2022 - 11.2023
Support Engineer
Tata Consultancy Services
03.2020 - 08.2022
Masters of Computer Application - Computer Science
Sastra Deemed University
Bachelor of Computer Applications - Computer Application
Ranchi Women's College