Palak Patel
Malden,MA
Summary
Data Engineer with expertise in R, SQL, and Python, specializing in automated ETL pipelines, Shiny dashboards, and scientific data workflows. Proven track record supporting research and clinical teams by transforming complex datasets into actionable insights. Skilled in modular programming, stakeholder collaboration, and building tools that make data accessible and reproducible.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Test and Data Engineer
MIT Lincoln Laboratory
10.2023 - 05.2025
- Deployed R-based apps for colleagues without master dataset access
- Built automated ETL pipelines: ingest → transform → merge → output
- Customized data subsets for physicists’ unique research needs
- Scheduled 15-min refresh cycles via Task Scheduler
- Partnered with cross-functional teams to validate and optimize workflows
- Maintained version-controlled documentation for reproducibility
IS Programmer Analyst I
Mass General Brigham – Department of Preventive Medicine
09.2021 - 08.2023
- Maintained and enhanced large-scale RShiny dashboards for clinical trial data
- Added UI/server features based on investigator requests; created SRS, SDS, and user guides
- Analyzed COVID-19 and COSMOS study data using SAS and R
- Built Python/PostgreSQL scripts to organize blood lab sample data from large datasets
- Linked SAS and CSV datasets in UNIX environment for integrated research analysis
- Documented combined study datasets using Excel and Microsoft Teams
Software Engineer (Capstone Project)
InSpark Analytics
09.2019 - 12.2019
- Designed and developed a web app to visualize ML model performance
- Created data integration model to display AUC ROC curve in real-time
- Led group meetings and finalized project documentation for client delivery
Education
Data Science & Machine Learning: Making Data-Driven Decisions
Massachusetts Institute of Technology
Boston, MA06.2023
Bachelor of Science - Computer Science & Mathematics (Double Major)
University of Massachusetts
Boston, MA12.2020
Skills
- Languages & Tools: R, Python, SAS, SQL, Java, C
- Data Engineering: ETL Pipelines, Data Wrangling, Data Subsetting, Modular Programming
- Automation: Windows Task Scheduler, Scripting, Directory Monitoring
- Analytics & Reporting: Shiny Dashboards, Statistical Modeling, AUC ROC Curve, PCA
- Databases: PostgreSQL, MySQL, SQL Server, Relational Algebra
- Web Technologies: HTML5, CSS3, jQuery, API Integration
- Collaboration: Cross-Functional Teams, Stakeholder Enablement, Scientific Workflows
Certification
- Applied Biostatistics for Clinical Trials
- QA Manual Testing – Udemy
- MAT Scholarship Recipient (Maintained 3.5 GPA in Calculus I–III)
Languages
English
Full Professional
Hindi
Native or Bilingual
Gujarati
Native or Bilingual
Spanish
Professional Working
Timeline
Test and Data Engineer
MIT Lincoln Laboratory
10.2023 - 05.2025
IS Programmer Analyst I
Mass General Brigham – Department of Preventive Medicine
09.2021 - 08.2023
Software Engineer (Capstone Project)
InSpark Analytics
09.2019 - 12.2019
Bachelor of Science - Computer Science & Mathematics (Double Major)
University of Massachusetts
Data Science & Machine Learning: Making Data-Driven Decisions
Massachusetts Institute of Technology
Similar Profiles
Janice BjornsonJanice Bjornson
Senior Business Analyst | Senior Contract Manager at MIT Lincoln LaboratorySenior Business Analyst | Senior Contract Manager at MIT Lincoln Laboratory
Jason VeerenJason Veeren
Systems Administrator Lead / Information System Security Officer at Beacon Hill Technology Staffing Group – MIT Lincoln LaboratorySystems Administrator Lead / Information System Security Officer at Beacon Hill Technology Staffing Group – MIT Lincoln Laboratory
Connor BelangerConnor Belanger
Technical Assistant at MIT Lincoln LaboratoryTechnical Assistant at MIT Lincoln Laboratory
Amira KotbiAmira Kotbi
Travel Consultant at Adam Travel ServicesTravel Consultant at Adam Travel Services
Alexa MurrayAlexa Murray
Massage Therapist at Skin to SoulMassage Therapist at Skin to Soul