Prarthana Shetty - data portfolio
Prarthana Shetty

About Me

4 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

  • Senior Data Analyst
    Mar 2026 – Present · OnPoint Insights (Contract) · Boston, MA, USA
    Microsoft FabricPower BIPower QueryDAXMedallion ArchitectureDashboard Reporting
    • Supported a medallion architecture (Bronze, Silver, Gold) in Microsoft Fabric for standardizing insurance & financial datasets for 5+ clients, including financial and insurance claims datasets. Developed Silver & Gold layer mappings,SQL validation scripts & Power BI semantic models supporting resource planning, financial reporting accuracy, & data quality
    • Designed executive Power BI dashboards & structured reports by translating stakeholder requirements into clear insights, usability improvements, & recommendations for cross-functional stakeholders across Billing Transactions, Premium Billing, & Correction Audit reports
  • MS Computer Science (Big Data Engineering & Business Analysisg)
    Sep 2023 - Dec 2025 · Northeastern University · Boston, MA, USA · GPA: 3.84
    SQLPower BITableauAlteryxTalendSnowflakeGen AI

    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
    Jan 2025 - Aug 2025 · Combined Jewish Philanthropies · Boston, MA, USA
    SQLSnowflakeCRMETLMuleSoftSalesforcePower BIDAXPower QueryPythonDashboard Reporting
    • 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 migration validation with deduplication checks, schema conformance, and null checks across 100,000+ records; post-migration data quality issues down ~35%.
    • Tuned high-volume Snowflake SQL and data models leveraging AI tools to cut average dashboard refresh time.
  • Office Operations Analyst & Representative
    Nov 2023 - Dec 2024 · Northeastern University · Boston, MA, USA
    ExcelVBACompliancePivot TablesPower Pivot
    • Analyzed course approval, registration, scheduling, and compliance data using Advanced Excel, VBA, PivotTables, Power Pivot, and MS Access to improve administrative reporting accuracy for 20+ users
    • Created shared trackers and Power Point summaries for structured reporting templates across cross-functional academic and administrative teams.
  • Custom Data Engineering Analyst
    Jun 2021 - Jul 2023 · Accenture · Client: State Farm Insurance
    SQLSplunkRoot Cause AnalysisAgileStakeholder ManagementServiceNow
    • Led cross-functional root cause identification and operational analysis of production data discrepancies for claims, policy, & financial transaction data using SQL, reducing incident resolution time by 15% & improving reliability for business users
    • Hot-patched erroneous production data with real-time SQL, correcting live data without a full deployment cycle.
    • Used Splunk logs and root cause analysis; 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 & RCA to identify repeat failure modes in claims workflows and improved resource allocation.
  • Quality Assurance Intern (SDLC Compliance)
    Dec 2020 - Jun 2021 · CeX Webuy Entertainment
    QMetryQualityTestingUAT
    • Executed UAT website testing for software releases across regional website segments, validating functionality,documenting defects, and ensuring alignment with SDLC release requirements
    • Developed 30+ QMetry test cases supporting test automation; reduced manual testing effort ~25% and documented bugs to improve release quality.
  • Bachelor of Engineering (BE), Computer Science
    2017 - 2021 · Fr. Conceicao Rodrigues College of Engineering

    Activities: CRCE Formula Racing (marketing & web), Entrepreneurship Cell (tech head), drama club, Rotary 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, including Microsoft's Dashboard in a Day (DIAD) and Fabric Analyst sessions, to stay current in the data space. I now also host DIAD workshops for fellow analysts, turning what I learn into practical Power BI sessions others can use. 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!^_^