Prerna Kapoor

About Prerna Kapoor

Data-driven and result-oriented Software Engineer with 5+ years of experience in data analytics, ETL processes, and data visualization. Skilled in delivering scalable, automated solutions for complex business needs. Proficient in Python, SQL, and Tableau with hands-on experience in data warehousing, reporting, and analysis. Adept at collaborating with cross-functional teams to design and implement solutions that enable data-driven decision-making.

Experience

1. Software Engineer Ii

   LTIMindtree

   Mar 2019 — Present · Seattle, WA, US

   Migrated legacy files from on-premise systems to cloud infrastructure using AWS (S3), Redshift, and Python-based ETL frameworks; automated pipelines and optimized data through SQL cleansing, indexing, and performance tuning.• Collaborated with cross-functional teams and vendors to implement keyless authentication, update shell scripts, and test formats; developed and presented weekly metrics and system performance updates to global stakeholders.• Supported enterprise-scale cloud adoption by automating and modernizing data movement, reducing manual effort by 30%, enabling scalable and accurate reporting infrastructure.• Built web-based backend solutions using C#, SQL, Python, Cosmos DB, and Snowflake to support an internal constraint management tool.• Worked in Agile sprints with cross-functional teams, delivering weekly demos, incorporating stakeholder feedback, and using Git for version control and DevOps tools to manage releases.• Delivered a robust internal tool that streamlined data workflows and improved system usability by 18%, by integrating CI/CD pipelines and automating unit testing thereby replacing fragmented manual processes with a centralized solution.• Led metadata management in Alation to streamline dashboard development and improve data accessibility across business units; collaborated with business owners, data engineers, and global stakeholders to define governance standards, gather requirements, and bridge communication between onshore and offshore teams through daily standups, ensuring timely and aligned deliverables.

Education

• Shri Bhaghubai Mafatlal Polytechnic

  Diploma in Information Technology, Information Technology

  2010 — 2013

• Illinois Institute of Technology

  Master’s Degree, Computer Science with a specialization in Computational Intelligence

  2016 — 2018

• Thadomal Shahani Engineering College

  Bachelor’s Degree, Information Technology

  2013 — 2016

Skills

• Microsoft Excel
• Microsoft Powerpoint
• Microsoft Office
• C
• Javascript
• Mysql
• Java
• Research
• Html
• C++
• Php
• Cascading Style Sheets (Css)
• Management
• Public Speaking
• Sql
• Leadership
• Microsoft Word