Prerna Gupta
Greater Noida
Summary
Analytical professional with expertise in SQL, Python, Tableau, Power BI, and AWS, specializing in transforming raw data into actionable insights. Proficient in data cleaning, modeling, visualization, and ETL processes to enhance decision-making and performance tracking. Experienced in managing large datasets, automating data quality checks, and developing interactive dashboards for monitoring key business metrics. Certified AWS AI Practitioner and Cloud Practitioner, dedicated to leveraging data for solving complex challenges and achieving measurable results.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Software Engineer
Community Dreams Foundation
Sebring
08.2024 - 07.2025
- Streamlined ETL pipelines using Python and SQL, handling over five million records each month.
- Crafted Power BI dashboards monitoring 15+ KPIs, contributing to a 20% cut in environmental impact.
- Automated validation scripts for data quality, slashing manual review efforts by 40% and improving accuracy.
- Worked alongside cross-functional teams to determine data needs, ensuring analytics aligned with strategic decisions.
Graduate Teaching Assistant
New Jersey Institute of Technology
Newark
01.2023 - 05.2024
- Mentored over 90 students in PL/SQL and NoSQL, raising average project scores by 15%.
- Reviewed and debugged Oracle SQL Developer and Studio3T projects to ensure accuracy.
- Delivered personalized guidance for troubleshooting schema issues, enhancing database operation proficiency.
Quality Analyst
Xceedance Consulting Pvt Ltd
Gurugram
07.2019 - 05.2021
- Analyzed business requirements to develop comprehensive test suite and cases for applications.
- Executed over 1,000 test cases across regression, functional, and data validation testing, achieving a 30% reduction in post-release defects.
- Implemented structured STLC processes and collaborated with developers, reducing defect resolution time by 25%.
- Enhanced product stability and accelerated release cycles through optimized defect tracking and improved test coverage.
Education
Master of Science - Computer Science
New Jersey Institute of Technology
Newark, NJ, USA05-2024
Bachelor of Technology - Information Technology
KIET Group of Institutions
Ghaziabad, UP, India06-2019
Skills
- Python and SQL
- Data visualization (Tableau, Power BI, Excel)
- Amazon Web Services
- ETL processes
- Data modeling and cleaning
- Data analysis and EDA
- KPI tracking
- Dashboard development
- Regression and functional testing
- Mentorship capabilities
Certification
- AWS AI Practioner
- AWS Cloud Practioner
Projects
Netflix Data Analysis and Visualization using Amazon QuickSight
Built an interactive Amazon QuickSight dashboard using S3-hosted Netflix datasets (~1M records) with filters for region, genre, and year.
Flight Data Analysis
Designed an Oozie workflow to process 22 years of flight data, identifying performance trends in airlines and airports. Optimized MapReduce joins across 3 AWS EC2 instances, improving processing efficiency by 35%.
Online Banking Application.
Developed and deployed a banking web application using Python (Flask), HTML/CSS, and SQL, with REST APIs, relational schema, CI/CD on Heroku, and version control via GitHub.
Library Database Management System
Designed and implemented a multi-phase public library database system, covering schema design, logical modeling, and final deployment. Developed SQL scripts to create and populate relational tables while ensuring data integrity and nconsistency. Built a user-friendly, menu-driven application supporting key operations like search, checkout, return, and reservation.
Timeline
Software Engineer
Community Dreams Foundation
08.2024 - 07.2025
Graduate Teaching Assistant
New Jersey Institute of Technology
01.2023 - 05.2024
Quality Analyst
Xceedance Consulting Pvt Ltd
07.2019 - 05.2021
Master of Science - Computer Science
New Jersey Institute of Technology
Bachelor of Technology - Information Technology
KIET Group of Institutions