Prashant Porwal

I.T. Analyst

Tata Consultancy Services Ltd•  June 2022 - Present

◦ Planning: Designed and developed a high performance codebase and database schema. ◦ Data Flow: Streamlined the processing of large data retrieval, enabled seamless generation of CSV files, secure transmission via SFTP, retrieval of acknowledgement files, and real-time database updates. ◦ Optimization and Automation: Achieved 80% reduction in manual processing time and ensured 100% data accuracy and integrity. ◦ Data Warehouse: Efficiently handled the ETL (Extract, Transform and Load), large data retrieval, bulk data insertion and updation. ◦ Ownership: Independently worked on code and database activities. ◦ Mentoring: Had mentored junior team members for any technical challenges or functional flows.

Senior Project Engineer

Wipro Technologies•  October 2019 - May 2022

◦ Reporting: Web application which collects data from different servers(plants) through SSIS package and store into the centralized server which is used for generating different types of reports for business needs. ◦ Data Analysis: Generated customized reports for clients as per the business needs. ◦ Enhancements: Implemented new features and provided regular maintenance for Windows application installed in the manufacturing unit, facilitating accurate declaration of production material and reducing errors by 80%. ◦ Development: Worked on enhancements like Implementation of new server, Globalization of application, Upgrading to specific or newer version. ◦ Production Support: Have resolved critical production issues of Windows application installed in Plants. ◦ Team Management: Cooperated with team to improve overall customer deliveries.

Vidyavardhini College of Engineering and Technology, Vasai

Computer Science & Engineering, BE•  August 2015 - May 2019

Graduated with 8.07 CGPI