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