Product Solutions Engineer Candidate

Prachi Lotake

Software Engineer (Strategy & Agile)

*******@********.*** 315-***-**** NewYork www.linkedin.com/in/prachi-lotake PROFILE

Detail-oriented Operations and Industry professionals with 3+ years of experience in performance monitoring, process improvement, and automation using Python and SQL. Eager to contribute analytical expertise to optimize performance and support scalable management operations . Demonstrated success applying systematic test methodologies, designing process improvement experiments, and documenting SOPs that reduce defects, improve throughput, and ensure compliance. Strong cross-functional collaboration skills with a data-first mindset aligned to Lean and continuous improvement principles. Eager to apply process sustaining expertise and technical rigor to Tesla's LFP Cell Manufacturing line. EXPERIENCE

Graduate Teaching Assistant - Database Systems

Clarkson University

•Administered structured process evaluation frameworks for 60+ graduate students working on SQL- based data systems, improving project accuracy by 40% through systematic troubleshooting and data validation methodologies directly analogous to process inspection workflows. 08/2024 – 05/2025

Potsdam, NY

•Designed and maintained documentation processes for lab evaluation procedures, ensuring consistency and repeatability mirroring SOP development and qualification schedule maintenance required in manufacturing environments.

•Leveraged MySQL to build and optimize structured query workflows, reinforcing proficiency directly aligned with Tesla's JD requirement for MySQL-based process data management. Software Test Engineer

DAG Infotek

•Sustained and monitored end-to-end process validation pipelines for enterprise financial platforms, responding to out-of-control process deviations and implementing rapid countermeasures that improved platform reliability and reduced production-impacting defects by 30%. 09/2020 – 09/2023

Pune, India

•Designed and executed structured test automation frameworks (analogous to DOE-based process experiments) using Python and Selenium, reducing regression cycles by 55% and decreasing manual inspection effort by 40% measurable yield improvement in a quality-controlled process environment.

•Led non-conformance investigation and disposition of 100+ production-impacting defects per release cycle; conducted root cause analysis, authored corrective action reports, and escalated systemic issues to engineering leads with full defect dossiers.

•Qualified and validated 4 new platform process configurations (CI/CD pipeline integrations) by authoring qualification protocols, executing structured test runs, and documenting pass/fail criteria directly paralleling equipment/process qualification activities in manufacturing.

•Partnered with cross-functional DevOps, product, and business teams to maintain process Cpk- equivalent quality metrics across distributed environments, ensuring data integrity and system stability for global financial clients.

•Authored and maintained 30+ SOPs, rework procedures, and work instructions updated on Agile sprint cycles, and trained team members on revised processes ensuring zero knowledge gap at each process release.

Software Engineer (Intern)

SGM Infotek

•Developed a web-based IT asset tracking system using Python/.NET to manage hardware inventory 05/2020 – 08/2020

Pune, India

•Gathered and documented business requirements, converting them into functional specifications

•Designed database schema and implemented CRUD operations for asset lifecycle management

•Conducted unit testing, UAT, and deployment planning to ensure system reliability

•Improved asset tracking accuracy and reduced manual record-keeping errors EDUCATION

Master of Science in Computer Science

Clarkson University

Courses: Computer network, Operating System, Cryptography, Database System, Artificial Intelligence 01/2024 – 05/2026

New York

GPA : 3.2/4.0

Bachelor of Computer Science Engineering

Pune University

GPA : 3.9/4.0

06/2016 – 05/2020

Pune, India

LEADERSHIP & ACHIVEMENTS

•Planned and executed 5+ events, engaging 100+ participants and external stakeholders

•Developed and implemented targeted outreach strategies, increasing participation by 30%

•Coordinated messaging, communications, and audience engagement initiatives

•Collaborated with teams to execute campaign-style event strategies under deadlines SKILLS

Languages & Tools

Python, Java, .NET

Tools & Version Control

Git & GitHub

Cloud & Platforms

AWS (EC2, S3, Lambda, Redshift)

Testing & Automation

Selenium, Protractor, Page Object Model, API Testing, Test Automation Frameworks Agile & Delivery

Agile Methodology, SCRUM, Sprint Planning, Cross-Functional Collaboration, Root Cause Analysis, Stakeholder Communication, Mentoring & Training, Root Cause Analysis & Countermeasure Implementation, Yield & Defect Reduction Databases & Data

SQL, PostgreSQL, JSON, MySQL

Strategic & Business Impact skills

Process Improvement & Optimization, Technology Research & Evaluation, Adaptability & Multitasking CERTIFICATES

Strategy Consulting Job Simulation –

Boston Consulting Group (Forage), 2026 –

Market Research, Financial Modeling,

Data Analysis, Strategic

Recommendations

Contact this candidate