Post Job Free

Resume

Sign in

Data Analyst

Location:
Rockville, MD
Posted:
April 14, 2021

Contact this candidate

Resume:

Alan Nguyen

US Citizen

***** ****** *** ******, *********, MD 20850

301-***-**** ● adloyj@r.postjobfree.com

EDUCATION

University of Maryland, Baltimore County Graduated: December 2020

Information Systems – Data Science Track Master of Science

GPA: 3.91

University of Maryland, College Park Graduated: August 2017

Family and Consumer Sciences/Human Sciences Bachelor of Science

GPA: 3.121

Relevant Coursework

Data Communications and Programming

Database Management Information Systems

Fundamentals of Networks

Structured Systems Analysis and Design

Project Management Operations

Computer & Network Security

Information Integration

Fundamentals to Data Mining

Health Information Systems

Introduction to Data Science

Technical Skills

Languages: JAVA, SQL, PL/SQL

Operating Systems: Windows 7, Windows 10

Systems Design: Software Development Life Cycle (SDLC), data flow diagrams, feasibility analysis, ER diagram

Applications: Microsoft PowerPoint, Microsoft Word, Microsoft Access, Microsoft Excel, SharePoint, Salesforce, Splunk, IBM BigFix, Amazon Web Services, Oracle SQL Developer, Microsoft Power BI

WORK EXPERIENCES

Information Technology Intern February 2020 – August 2020 United States Postal Service Washington, D.C.

●Extracted data from multiple sources through Power BI to analyze and outline trends to show correlations relating to mail-related crime to management team to improve USPS mail-handling to prevent future crime.

●Make use of real-time data from MicroStrategy and transferred it over to Power BI by extracting them as Excel sheets or directly from SQL servers.

●Made entity-relationship charts showings entities and relationships in Oracle SQL Developer.

●Created and enhanced PL/SQL queries including functions and procedures to support clients’ requests.

●Assisted Database Admin in completing tasks such as loading data, reporting procedures, extracting data by writing SQL queries and testing stored procedures.

Information Technology Student Trainee June 2019 - August 2019 General Services Administration Washington, D.C.

●Constructed Phishing scenarios to target specific users in GSA to test GSA’s security systems and procedures.

●Created dashboards and visualizations such as graphs showing percentage of users that clicked on fraudulent emails through Splunk.

●Used QA/QC best practices to construct compliance reports through BigFix that were reviewed by Information System Security Officer.

●Created test scenarios with Amazon Web Services to test AWS trusted advisory security systems to prevent security breaches.



Contact this candidate