Prarthana Shetty

About Me

3+ years of experience turning raw data into reliable pipelines, models, and dashboards across industries, team sizes, and tech stacks.
I care about what happens after launch: validation, documentation, and metrics that hold up over time.
Currently open to Data Engineer, Data Analyst, and Analytics Engineer roles.

Experience & education

  • Data Analytics Engineer Intern
    Mar 2026 – Present · OnPoint Insights (Contract) · Boston, MA, USA
    Microsoft FabricPower BIMedallion ArchitectureETL
    • Designing a Medallion architecture (Bronze → Silver → Gold) in Microsoft Fabric to unify multi-client insurance datasets across ingestion, transformation, and analytics layers.
    • Authoring Silver and Gold-layer transforms: deduplication, schema standardization, and business-rule enforcement to produce analytics-ready tables.
    • Building dimensional Power BI data models and client-facing dashboards translated directly from stakeholder requirements.
  • MS Information Systems (Big Data & Data Engineering)
    Sep 2023 – Dec 2025 · Northeastern University · Boston, MA, USA · GPA: 3.84
    SQL ServerTalend

    Graduate coursework concentrated on distributed data systems, warehouse design, and large-scale ETL — including hands-on projects in SQL Server, Talend, and cloud-native pipelines.

  • Data Analyst Co-Op
    Jan 2025 – Aug 2025 · Combined Jewish Philanthropies · Boston, MA, USA
    SnowflakePower BIMuleSoftAlteryxPython
    • Built executive Power BI dashboards tracking 30+ campaign and donor-engagement KPIs; reduced manual reporting effort ~65% and accelerated stakeholder access to live metrics.
    • Designed and executed a MuleSoft ETL pipeline migrating 100,000+ CRM records from Blackbaud to Salesforce with full schema mapping and field standardization; cut manual reconciliation ~40%.
    • Architected a metadata-driven Snowflake migration framework using schema discovery and dynamic SQL with batched ~50k-record runs; reduced new-dataset onboarding time ~25%.
    • Automated post-migration validation — deduplication, schema conformance, and null checks — across 100,000+ records; post-migration data quality issues down ~35%.
    • Tuned high-volume Snowflake SQL and data models to cut average dashboard refresh time ~25%.
  • Office Operations Analyst & Representative
    Nov 2023 – Dec 2024 · Northeastern University · Boston, MA, USA
    ExcelVBA
    • Built Excel analytical models (PivotTables, VLOOKUP, VBA macros) for course registration data used in compliance reporting; supported 20+ internal users.
    • Maintained shared trackers and structured reporting templates for cross-functional academic and administrative teams.
  • Custom Data Engineering Analyst
    Jun 2021 – Jul 2023 · Accenture Solutions Pvt. Ltd. · Client: State Farm Insurance
    SQLSplunkXMLAgile
    • Diagnosed and resolved production data defects in claims and policy systems using SQL; cut incident resolution time ~15% in a high-visibility, customer-facing context.
    • Hot-patched erroneous XML payloads in production with real-time SQL — correcting live data without a full deployment cycle.
    • Used Splunk for log analysis and root-cause investigation; improved error detection rate ~20%.
    • Drove stakeholder alignment through agile ceremonies (daily standups, sprint reviews); maintained ~95% resolution rate on production data incidents.
    • Conducted incident pattern analysis to identify repeat failure modes in claims workflows and inform resource allocation.
  • Quality Assurance Intern (SDLC Compliance)
    Dec 2020 – Jun 2021 · CeX Webuy Entertainment Pvt. Ltd.
    QMetryUAT
    • Executed UAT across regional e-commerce sites for new feature releases, validating against SDLC acceptance criteria.
    • Authored 30+ QMetry test cases supporting test automation coverage; reduced manual testing effort ~25% and documented defects to improve release quality.
  • Bachelor of Engineering (BE), Information Technology
    2017 – 2021 · Fr. Conceicao Rodrigues College of Engineering

    Activities: CRCE Formula Racing (marketing & web), Entrepreneurship Cell (tech head), drama club, Rotaract Club.

Outside of work

Outside of work I stay close to what I care about: community and learning. I volunteer with Startup Boston and signed up to help when the World Cup comes to the city.

I learn best by doing, so I keep taking hands-on workshops—recently Microsoft's Dashboard in a Day and a Fabric Analyst session—to stay current in the data space. Conferences and certifications are part of that habit too; last year I earned the Salesforce Data Architect certification.

When I step away from the screen, I'm usually trying a new restaurant or testing a recipe at home.