Data Engineer Analyst Intern

Vismaya Prakasan

Dallas, TX — 682-***-**** — ******************@*****.*** — github.com/vismayap98 — linkedin.com/in/vismaya-prakasan SUMMARY

Driven data professional with 2+ years of experience through internships, volunteering, and projects, building ETL pipelines, dashboards, and analyzing datasets to guide decisions. Skilled at learning fast, taking initiative, and ready to deliver impact EXPERIENCE

University of Texas at Arlington Jul 2025 - Present Data Engineer (Volunteer) Arlington, TX

• Analyzed and cleaned survey data from over 1,000 participants to generate social network graphs using Python

(NetworkX) and Pandas, uncovering behavioral patterns and influence clusters

• Improved ETL pipeline efficiency by 30% by automating data cleaning workflows and standardizing variable structures

• Developed a knowledge-based chatbot integrating PostgreSQL survey data, enabling dynamic querying and insights

• Designed a standardized data dictionary and schema that reduced onboarding time by 40% Campus Recreation -University of Texas at Arlington Jun 2024-May 2025 Student Assistant Arlington, TX

• Improved workflows by 25% through optimized inventory tracking and real-time equipment availability using Excel

• Coordinated logistics for 30+ events, reducing setup delays by 40% through efficient resource allocation

• Reduced student wait times by analyzing usage data with Excel pivot tables and streamlining schedules Zenzys Solution Private Limited Aug 2022 - Jul 2023 BI Analyst Intern Coimbatore, India

• Built and maintained Excel and Power BI dashboards for internal user activity and product engagement, reducing manual reporting time by 40%

• Delivered insights on customer churn and usage trends through drill-through dashboards and custom DAX measures, contributing to a 12% increase in retention and real-time performance tracking across 3 departments RFID Tags and Services Jan 2021 - Mar 2021

System Analyst Intern Thane, India

• Analyzed system requirements and data flow to design PCB layouts in KiCad, enabling SPI-to-Ethernet communication and boosting signal stability by 40% during prototype validation

• Tested, debugged, and validated circuits, reducing communication failures to near zero, and documented workflows to deliver a production-ready solution ahead of deadlines SKILLS

Languages & Analysis: Python, SQL, Pandas, DAX, JSON, NumPy, EDA, Data Cleaning, Data Interpretation Data Engineering: ETL, Pipeline Automation, Feature Engineering, Metadata Management, Data Validation BI & Visualization: Power BI, Tableau, Excel, Looker studio, Matplotlib, Seaborn Modeling & ML:Regression, Classification, SMOTE, scikit-learn, Model, NetworkX Cloud: AWS (Lambda, S3, DynamoDB, Bedrock), Azure (Fundamentals) Tools & Platforms: Jupyter, Git, BigQuery (basic), Snowflake (basic), Office 365, Docker Certifications: Business Analytics (UTA), SQL for Data, Generative AI Fundamentals(Databricks), Plantir Foundry SELECTED PROJECTS

SQL Server Data Warehouse Medallion Architecture, ETL, Star Schema Modeling Jul 2025 – Aug 2025

• Designed and implemented a SQL Server Data Warehouse using the Medallion architecture (Bronze, Silver, Gold), applying SQL scripts and separation of concerns to build a scalable, production-style data pipeline

• Built fully custom ETL workflows using SQL to parse and ingest CSV data, apply business rules, perform data cleansing, and implement TRUNCATE + INSERT full-load strategy for historical tracking

• Modeled a robust star schema using window functions and metadata tracking for scalable analytics and reporting AI Mental Health Companion for Migrants AWS, Llama3 Jun 2025 – Jul 2025

• Designed a serverless architecture using AWS Lambda, S3, Transcribe, and DynamoDB to transcribe multilingual audio, detect distress signals, and store anonymized metadata

• Integrated Bedrock’s Llama3 model to provide empathetic, multilingual responses for mental health support Fake Job Posting Detection with Dialer-Based System Jupyter, Data Mining Aug 2023 – Feb 2025

• Applied classification models, regression techniques and SMOTE for anomaly detection on 500K+ records, showcasing model validation and testing workflows

EDUCATION

Master of Science in Information Systems, University of Texas at Arlington (3.64/4) Aug 2023 – May 2025 Bachelor of Engineering in Electronics and Telecommunication, Mumbai University Aug 2018 – May 2022 LEADERSHIP & AWARDS

• Won 1st place in Deep Learning project competition at Pillai College; awarded INR 10,000 for technical excellence

• Co-authored and published a peer-reviewed paper on deep learning in IJCA Journal View Publication

Contact this candidate