Data Analyst Assistant

Trang To

St Paul, MN adhsje@r.postjobfree.com 218-***-**** in/trangtto

SUMMARY

Graduate student passionate about studying how to improve performance and solve business problems with background in Finance. Seeking Data Analyst Internships and Full-time opportunities to leverage data analytical skills to improve corporate performance.

EDUCATION

University of St. Thomas - Master of Science in Data Science 2018 - 2021 Concordia College – Bachelor of Arts in Finance 2012 - 2016 TECHNICAL SKILLS

Programming Languages: Python, SQL, R Basics

Tool: Excel, Access, Tableau, AWS, Oracle SQL, Microsoft SQL Server, Git, Sage50 Accounting, MS Office Suite, Salesforce

Technical skills: Data Analytics & Visualization, Database/ Datawarehouse Design & Management, Bash Scripting, Revenue Modeling & Forecasting.

RELATED EXPERIENCE

Finance Assistant General Assets Group LLC March 2018 – March 2020 Processed weekly payrolls for 50+ internal employees and external staffs, provided payroll reports in a timely and accurate manner using Sage50 Accounting. Collected and consolidated internal data to perform general accounting ledger and prepare monthly balance sheets and P&L statements for company owner. Developed automated Excel reports for budget & forecast analysis to evaluate profit, cost efficiency, and ROI in all company’s real estate properties, ensuring the company’s desired assets turnover ratio. Developed Excel VBA model for automatic data entry, built automated data processing pipeline in Python to expedite the data analysis process of over 200 transactions weekly as well as maintain internal employee database, cutting 90% of time in manual data entry for future staffs. Analyst Intern Saigon-Hanoi Securities Join Stock Company May 2015 – August 2015 Synthesized Vietnamese stock market data, updated daily web reports via Rest API using Python for the analysts and brokerage team, maintained visibility to stock market movement for the company. Analyzed data from 20+ real estate companies industry to identify its potential growth and value from performing forecast analysis. Conducted research project, presented and gave out stock recommendation to investors.

International Student Ambassador Concordia College January 2015 – May 2015 Maintained Concordia College’s student database in Salesforce, managed student’s profiles and generated reports. Improved analytical skills and attention-to-details by processing international transcripts and test scores.

Created marketing contents and outreached to prospective students oversea about admission opportunities, expanding school reputation and improving communication between the admission office and potential international students.

PROJECT EXPERIENCE

Data Analysis & Visualization Class - “How Legendary is Roger Federer?” Analyzed data from ATP database from 1877-2017, using Tableau to visualize and draw insights on Federer’s career achievement.

Database Design & Management Class

Establish and designed a customized relational database system, using advanced SQL filtering and data aggregation in OracleSQL to satisfy business reports. Datawarehouse Class

Implemented ETL to Multidimensional Data Model using Microsoft SQL Server. DevOps Cloud Infrastructure Class

Designed and deployed cloud-scale distributed systems by Infrastructure as Code. Using Github and AWS to generate software delivery pipeline.

Contact this candidate