Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Projects
References
Personal Information
Timeline
Generic

SELVINA SWARNA

Syracuse

Summary

Data analyst with proven track record at Quodeck Technologies, achieving a 30% increase in data accuracy through meticulous data cleaning and preprocessing. Expertise in Python and Tableau facilitates effective cross-functional collaboration. Delivers actionable insights that enhance decision-making processes.

Overview

1
1
Certification

Work History

Lab Assistant

Mumbai University
Mumbai
01.2024 - 05.2024
  • Led 20 lab sessions in programming, databases, and web development, enhancing student task completion by 40% through hands-on support.
  • Ensured 95%+ lab uptime by troubleshooting technical issues, supporting uninterrupted sessions for 20+ students weekly.

Data Analyst Intern

Quodeck Technologies
Mumbai
11.2023 - 01.2024
  • Conducted data analysis using Python and SQL to derive insights from large datasets, created interactive dashboards in Tableau to visualize key metrics, and assisted in data cleaning and preprocessing to improve data accuracy by 30%.
  • Built and implemented dynamic Power BI reports to showcase insights, streamlining data presentation for stakeholders and cutting down manual analysis by 60%.
  • ETL & Data Integration: Talend, Informatica, ETL Pipeline Design, Data Cleaning & Preprocessing, Data Wrangling.
  • Cloud Platforms & Data Warehousing: Azure Data Lake, AWS (S3, Redshift, Glue), Snowflake, Azure Synapse Analytics.
  • Big Data Technologies: Apache Hadoop, Apache Spark.
  • Programming & Scripting: Python (Pandas, PySpark), Java, SQL.
  • Business Intelligence & Visualization: Power BI, Tableau - Dashboard Design, Reporting Optimization.
  • Data Modeling & Architecture: Star and Snowflake Schema, Data Lake Architecture, Data Quality Assessment.
  • Agile Development & Tools: Agile Methodology, Scrum, JIRA, Confluence.
  • Soft Skills: Problem Solving, Data-Driven Decision Making, Cross-Functional Collaboration, Requirement Gathering, Communication, Stakeholder Engagement, Adaptability.

Education

M.S. - Information Systems

Syracuse University
05.2026

Bachelors - Computer Science and Cybersecurity

Mumbai University
05.2024

Skills

  • Talend and Informatica
  • ETL pipeline design
  • Data cleaning and preprocessing
  • Data wrangling
  • Azure Data Lake and AWS (S3, Redshift, Glue)
  • Snowflake and Azure Synapse Analytics
  • Apache Hadoop and Spark
  • Python (Pandas, PySpark) and Java
  • SQL proficiency
  • Power BI and Tableau dashboard design
  • Reporting optimization
  • Star and snowflake schema design
  • Data lake architecture
  • Data quality assessment
  • Agile methodology and Scrum
  • JIRA and Confluence usage
  • Problem solving skills
  • Data-driven decision making
  • Cross-functional collaboration
  • Requirement gathering techniques
  • Effective communication
  • Stakeholder engagement strategies
  • Adaptability

Certification

  • Data Analysis & Visualization, Quastech Institute, Mumbai, 07/01/24
  • Python Development & Django Framework, Quastech Institute, Mumbai, 07/01/23
  • Amazon Web Services (AWS) Security Specialty, 05/01/23
  • Oracle Database Certification Course, 03/01/22
  • Cisco Cybersecurity Virtual Internship, 05/01/21

Languages

English
Professional

Projects

Energy Consumption Prediction Dashboard – ECS Energy                                             January 2025 - May 2025

• Developed an energy forecasting platform using R, integrating multi-source .parquet datasets with arrow, and applying feature engineering and linear regression for predictive modeling.

• Built and deployed a Shiny web application featuring dynamic UI elements including time-based filters, user inputs, and visual analytics using ggplot2, enabling real-time energy consumption insights across 5,000+ buildings

AI-Powered Academic Advising System                                                               August 2024 - December 2024

• Implemented an AI-driven academic advising system in the Orange Now App, boosting student support for 5,000+ users by providing personalized course recommendations and real-time degree progress tracking using predictive analytics.

• Combined AI-based predictive modeling with Data Flow Diagrams (DFD) and Entity-Relationship Diagrams (ERD) to automate 70% of course registration tasks, cutting manual advisor workload by 40%.

Disease Prediction System January 2023 - May 2023

• Designed a disease prediction system leveraging ML algorithms, analyzing 50,000+ patient records to aid early diagnosis. Improved prediction accuracy by 85% and reduced diagnostic time by 40%, enhancing clinical decision-making.

• Utilized Technologies such as: Python libraries (Pandas, Numpy, Matplotlib, and OpenCV) ML algorithm (Decision Tree), Anaconda (R programming IDE)

References

References available upon request.

Personal Information

Timeline

Lab Assistant

Mumbai University
01.2024 - 05.2024

Data Analyst Intern

Quodeck Technologies
11.2023 - 01.2024

M.S. - Information Systems

Syracuse University

Bachelors - Computer Science and Cybersecurity

Mumbai University