Tej M

Experience

• 

  Patra Corporation

  Jan 2021 - Jun 2022

  Data Analyst

  ·Developed interactive dashboards using Tableau to present financial and operational insights to stakeholders.·Enhanced database performance by optimizing complex queries and indexing, reducing query times by 30%.·Conducted data integrity checks and implemented automation workflows in Databricks, improving reliability across analytics processes.

• 

  Clarkson University

  Aug 2022 - May 2024

  ·Architected an analytics platform on Redshift by designing and deploying ETL workflows, automating data cleaning, transformation, and modeling processes to streamline data warehousing and support advanced analytics.·Migrated 140GB of structured and unstructured data from legacy servers to AWS S3, optimizing storage for analytical workloads and enabling scalable data processing and real-time insights generation.·Conducted distributed data analysis using Hadoop and Spark to uncover trends from datasets, enabling actionable insights for academic research.·Organized meetings between my professors, directors and clients team members, and managers to gather requirements, develop project outlines, and ensure alignment on deliverables.·Documented code, workflows, and processes while actively contributing in an Agile environment to enhance collaboration and efficiency. Show less

  • Graduate Assistant

    Jan 2023 - May 2024

  • Graduate Teaching Assistant

    Aug 2022 - Dec 2022
• 

  Simtra BioPharma Solutions

  Apr 2024 - now

  Data Engineer

  ·Designed and deployed batch and stream processing data pipelines for integrating EHR data and clinical trial records, ensuring compliance with HIPAA and GDPR standards.·Implemented real-time anomaly detection, enhancing data integrity and reducing error rates by 25%.·Developed a centralized data lake leveraging AWS Glue, streamlining schema evolution and enabling analytics across various research departments.·Achieved a 20% reduction in data storage costs by optimizing ETL workflows and leveraging cost-effective storage solutions on AWS S3.·Collaborated with cross functional teams to create dashboards showcasing patient demographics, trial enrollment funnels, and adverse drug reaction trends using Tableau. Show less