Data Analyst

TRI NANG MANH TRAN

571-***-**** (C) ***********@*****.***

PROFESSONAL EXPERIENCE

Data Analyst – United Airlines, Dulles, VA 4/2018 – PRESENT

Research and develop observation methods to collect the qualitative and quantitative data.

Clean and combine large data from data collector team using Excel.

Design and develop a model and techniques for analysis.

Analyzed data to discover and interpreted patterns, trends, variances, and gaps.

Prepare visually impactful dashboards in Excel for data reporting by using pivot tables.

Prepare effective PowerPoint presentation for the weekly or monthly meeting.

Data Analyst - Arlington County, Arlington, VA 6/2017 – 3/2018

Collected, cleaned and combined large structured and unstructured data from multiple sources.

Analyzed data to discover and interpreted patterns, trends and variances into meaningful information using R or Python.

Researched, designed and developed a model, algorithms, and techniques for analysis.

Created a resilience index formula specific to Arlington County.

Created interpretable visualizations using Excel and Tableau for data reporting.

Evaluated, documented and presented the results of research and analysis to a supervisor and Arlington County Board Members.

Data Science - DTSV (USCIS), Crystal City, VA 12/2016 – 5/2017

Extracted and transformed data through normalization and other techniques to standardize and prepared data for analysis.

Constructed new data assets by combining data from multiple sources.

Used data and analytics languages Python and R to design and built statistical analysis model on large datasets.

Mined and analyzed complex unstructured data sets using statistical methods, and machine learning algorithms.

Applied different methods in Statistic Algorithms (Linear Regression, and Naïve Bayes) on training data set and tested data set to mine data, and calculated confusion matrix to make sure the results are not biased.

Presented the collect result to a client using dashboards in Tableau and Power BI to support decision-making.

Database Design - Cornerstones, Reston, VA 1/2016 – 12/2016

Gathered client requirements and created the business rules.

Designed and implemented the entity relationship model based on the business rules.

Performed ETL process to transfer the data into database.

Performed normalization to ensure requirements were met.

Used SQL to build and tested relational database.

Designed and ran custom SQL database queries.

IT Consultant - Pev’s Paintball & Airsoft Park, Aldie, VA 1/2015 – 12/2015

Defined and analyzed business operations.

Researched, classified, and recommended applications and database types preferred.

Designed and implemented external view, conceptual schema, and internal schema.

Normalized relational table to make sure there is no redundancy and an appropriate key to supporting query command.

Supported validation structured data and created of ETL processes.

Built, tested, and debugged relational database using SQL or Java Object-Oriented using Agile methodology.

Analyzed data and built insightful visualizations in Tableau, Power PI, and Excel.

EDUCATION

George Mason University, Fairfax, VA

MS in Data Analytics Engineering GPA 3.80/4.0 May 2018

BS in Applied Information Technology GPA 3.55/4.0 December 2015

CERTIFICATION: ITIL v3 Foundation, Comp TIA Security+ CE, CCNA: Cisco Certified Network Associate, LPI Linux Essentials, VMware Certified Professional 5 Data Center Virtualization

COMPUTER SKILLS

Solid understanding of data mining, machine learning, and data warehouse.

Proficient in Data and Analytics Tools/Languages: Java, R, Python, SQL, Microsoft Excel, Power BI, SAS, Tableau.

Good working knowledge of Window, Unix, Linux, Anaconda (Jupyter Notebook), notebook++.

Strong knowledge of NoSQL database types: Key-value stores, Document databases, Graph stores, Wide-column stores.

Knowledge of statistics method: Linear regression, Classification, Support Vector Machines, and Decision Tree.

Contact this candidate