Jr. Data Analyst

Danny Yin

**** ****** **, *** *******, CA ***** 323-***-**** ***********@*****.***

EDUCATION

Bachelor of Science in Information Systems May 2018 California State University, Northridge, CA

IS Courses: “System Development Project”, “Database Management Systems”, “System Analysis and Design”, “Information Systems for Business”, “Business Data Communications and Networking”,

“Information Technology in Business”

SKILLS

Databases: SQL, Microsoft Access, Relational Databases Applications: MicroStrategy, Power BI, Excel (VLOOKUP, IF Statements, Pivot Tables), Jira, MS Office Other Skills: Agile Methodology, Data Visualization EXPERIENCE

American Financial Network, Brea, CA July 2018 – Present Compliance Analyst

• Accurately audit loans to validate loans are compliant with mortgage and investor regulations.

• Communicate extensively with loan officers and funders to confirm loans were complied precisely to be sold according to the investor’s needs.

• Interact with loan processors to troubleshoot and provide customer service with borrowers to ensure their demands are met.

• Communicate with loan processors in a timely manner so that they may advise clients effectively throughout the various stages of the loan process. CSUN Child and Adolescent Department, Northridge, CA June 2016 – June 2018 Office Manager / Data Analyst

• Collect and convert data into charts/graphs using Tableau to present to major faculty and staff.

• Created dashboards and reports to illustrate the logistics and usages of the office

• Oversee and maintain a database for every student/faculty registered to the office.

• Successfully coordinate and assist in events that help the research assistants and professors with their data collection.

• Initiate any scheduling, event planning, and reservations for all administrators and faculty. PROFESSIONAL INVOLVEMENT CERTIFICATES

Management Information Systems Association January 2017 – May 2018 IBM Databases and SQL for Data Science May 2019

Advanced Google Analytics March 2020

Projects

Database Design August 2017 – December 2017

• Developed a relational database design for a local clothing store using Microsoft office.

• Created databases for all products and developed a spreadsheet of all transaction.

• Created SQL Queries that helped analyzed the store’s business process.