We provide IT Staff Augmentation Services!

Data Analyst Intern Resume

TECHNICAL SKILLS

Computer: MS Word, PowerPoint, Excel, Python, SQL, Tableau, AutoCAD.

Technical: Solids Modeling, Data Visualization, Optimization analysis, Project management, Technology assessment, Technical writing ability.

PROFESSIONAL EXPERIENCE

Data Analyst Intern

Confidential

Responsibilities:

  • Analyzed and reported on large datasets from multiple sources
  • Formatted from raw data into clean data, Updating and correcting clean data
  • Used to write complex SQL queries using joins, sub queries and correlated sub queries
  • Presented data using Pivot - Tables with Python pandas package
  • Performed unit testing to check teh validity of teh data at each stage
  • Performed various tasks that included data transformations into various file formats
  • Identified trends, outliers, and norms with Python packages
  • Created reports for teh users using Tableau by connecting to multiple data sources like MS Excel, PostgreSQL.

Data Analyst Intern

Confidential

Responsibilities:

  • Used Python scripts to update content in teh database and manipulate files.
  • Incorporated pivot-tables and data models to display/manipulate useful information
  • Perform importing, cleaning, transforming and validating data
  • Used SQL helped design and build a new database for company's financial data
  • Knowledge on Extraction Transformation and Loading (ETL) process
  • Used SQL for Querying teh database in PostgreSQL environment
  • Experience in data visualization including producing tables, graphs using Tableau

RESEARCH Data analyst

Confidential

Responsibilities:

  • Analyzed user experience with data modelers to identify entities and relationship for data modeling
  • Collected raw dataset from parking homepage which include teh audiences' experience
  • Queried teh databases, wrote test validation scripts
  • Incorporated pivot-tables and data models to display/manipulate useful information
  • Performed Data Profiling, Data cleaning, and Data Quality
  • Data visualization with Python packages and Tableau
  • Identified teh trends, outliers, norms, null hypothesis, p-value with Python packages
  • Generated final report after testing and discussing with team

Hire Now