Prerna Kapoor

• Prototyped 3+ intelligent wellness workflow automations using LLMs and GenAI — processing Zoom Events analytics and session data, automating email reminders and calendar invites for 50+ events/month, reducing scheduling errors across 30+ client companies.  • Architecting and deploying a multi-tenant client-facing wellness dashboard using MemberPress for role-based data isolation, integrating HubSpot CRM with WordPress across 30+ client companies, reducing manual session reporting effort by ~40%.  • Building end-to-end data pipelines using Make (Integromat), PHP, and Toolset to automate data sync from HubSpot tickets, forms, and spreadsheets, cutting integration time by ~50% and eliminating manual data entry across 15+ workflow stages.

• Migrated legacy on-premise systems to AWS (S3, Redshift) using Python ETL frameworks, automating 20+ pipelines processing 500GB+ of data across 8 business units.  • Improved query performance by ~35% through SQL cleansing, indexing, and performance tuning across fault-tolerant, high-availability pipelines.  • Built distributed backend microservices using C#, Python, SQL, Cosmos DB, and Snowflake to support an enterprise constraint management tool, following distributed system design patterns for scalability and reliability across 10+ teams.  • Delivered a robust internal tool that improved system usability by 18% and achieved ~99.5% uptime by integrating CI/CD pipelines, automating unit testing, and replacing fragmented manual processes with a centralized, observable solution.  • Supported enterprise-scale cloud adoption by automating and modernizing data movement across 50+ workflows serving 10 teams, reducing manual effort by 30% and enabling scalable, accurate reporting infrastructure.  • Led metadata management in Alation to improve data accessibility across business units; partnered with business owners, data engineers, and global stakeholders to define governance standards, present weekly performance metrics, and align onshore and offshore teams.  • Coordinated cross-team deployments across 6+ Agile sprints, delivering weekly demos and ensuring on-time releases across 10 teams.

Developed backend (Java, MySQL) and frontend (AngularJS, HTML5, CSS3) features for a payroll automation tool, streamlining strategic planning and budgeting while automating test cases with Selenium to boost testing efficiency by 60%.

Relevant Coursework: Machine Learning Fundamentals, Large Language / Generative AI, Model Development, Data Visualization, Big Data, Text Mining, Foundations of Data Analytics

Master's Degree in Computer Science

1. Participated as a delegate in ‘TSEC-MUN’ (Model United Nations) 2014 in the DISEC (Disarmament and International Security) Committee. 2. Attended a workshop on ’Programming and Data Management on Oracle Databases’ by IEEE-TSEC 2014. 3. Participated in ‘Debugger’ Coding Competition conducted by CSI-TSEC 2014. 4. Participated in ‘Cloud Computing’ held by IEEE-TSEC ISAAC committee 2014. 5. Attended a workshop on ‘Ethical Hacking and Cyber Forensics’ conducted by Skynet Solution in 2011. 6. Participated in ‘Technovention’ Coding competition by CSI-TSEC 2014. 7. Attended the ‘MATLAB’ course by IEEE-TSEC 2014. 8. Attended ‘Google Develop Group DevFest’. 9. Participated and was the runner up in the inter-college debate competition.