Swagata Pradhan
Kharagpur
Summary
Dynamic System Engineer with a proven track record at Tata Consultancy Services, excelling in SQL and PL/SQL to optimize database performance. Adept at data analysis and debugging, I enhanced reporting accuracy and ensured data integrity, driving operational efficiency. Passionate about leveraging technical skills to deliver impactful solutions in database management.
Overview
4
4
years of professional experience
Work History
System Engineer
Tata Consultancy Services LTD
Kolkata
10.2022 - Current
- Optimized SQL queries to enhance system performance and reduce execution time.
- Analyzed data using functions, procedures, and packages for accurate reporting.
- Debugged package, procedure, function to ensure data integrity and consistency.
- Developed triggers and cursors for automated database operations.
- Supported Oracle databases 11g & 19c with proficient troubleshooting skills.
- Utilized PL/SQL Developer and SQL Plus for efficient database management.
- Leveraged Forti Client, WebPrompt, and WinSCP tools to streamline processes.
Jr. Executive-IT
Iris Health Services Limited
Kolkata
07.2021 - 09.2022
- Managed, monitored, and updated hospital database to ensure data integrity and security.
- Generated required data in Excel format from database using SQL and PL/SQL.
- Created server pages utilizing Oracle Forms Builder 6i and Report Builder 6i for frontend applications.
- Resolved software-related issues for data entry operators via phone communication.
- Utilized SQL, PL/SQL functions, procedures, packages, and triggers to enhance database functionality.
- Maintained Oracle 10g database to support hospital operations and data accessibility.
Education
B. Tech - Computer Science & Engineering
Swami Vivekananda Institute of Science & Technology
Gobindapur, Kol06.2020
Higher Secondary - Pure Science
Midnapur Collegiate School
Midnapore03.2016
Secondary - General Studies
Dubgohal Vivekananda Siksha Niketan
Kharagpur02.2014
Skills
- SQL and PL/SQL
- Data analysis
- Database functions
- Package development
- Debugging techniques
- Cursor management
- Table management
- View creation
- Trigger implementation
- Production support
Languages
- English
- Hindi
- Bengali
Timeline
System Engineer
Tata Consultancy Services LTD
10.2022 - Current
Jr. Executive-IT
Iris Health Services Limited
07.2021 - 09.2022
B. Tech - Computer Science & Engineering
Swami Vivekananda Institute of Science & Technology
Higher Secondary - Pure Science
Midnapur Collegiate School
Secondary - General Studies
Dubgohal Vivekananda Siksha Niketan
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
Sukhbir SinghSukhbir Singh
Customer Care Executive at Innover Digital Services Pvt LTDCustomer Care Executive at Innover Digital Services Pvt LTD