Ruchi Pandey

Master's

Computer Science

SMCP

Data Engineer

- Scripted a customized data pipeline process using Python and SQL, providing real-time tracking of brand progress for the Finance department - Optimized complex SQL transformation query, achieving a 50% reduction in processing time through query restructuring - Automated the daily sales report using web scraping tools, resulting in a time-saving of 60 hours per month in manual effort - Managed and optimized relational databases (e.g., MySQL, PostgreSQL) for high-performance data storage and retrieval - Integrated Tableau with existing data infrastructure, ensuring seamless data connectivity and real-time updates - Developed a data visualization dashboard that provides real-time insights into sales performance, enabling data-driven sales strategies - Established data pipelines to extract data from Redshift and deliver it to downstream systems via 53 and Sftp