Junior Analyst

Miguel Amezcua

***** ***** ** *********, ** ***** Cell 571-***-**** ********@*********.***.***

EDUCATION

Bachelor of Science in Business, Business Analytics Expected Graduation: August 2021

George Mason University, Fairfax, VA

Cumulative GPA 3.13

Relevant Courses: Introduction to Exploratory Data Analysis, Marketing Analytics, Data Mining for Business Applications, Financial Accounting, Financial Management, Business Analytics, Business Information Systems, Database Management Systems, Data Warehousing, Programming for Analytics.

Associate of Science in Business Administration 2016 – 2019

Northern Virginia Community College, Manassas, VA

PROJECTS

Covid-19 Dynamic Report Tracker, MIS 433 Programming for Analytics Course Project

Built a Covid-19 fifteen-day trend report for both reported cases and death, in uses of Johns Hopkin’s University Covid- 19 Data for any desired state to inspect.

Processed raw data by dropping columns, merging two datasets into a DataFrame, converting wide data into a long data structure and eliminating, ‘Not a number’ (NaN) numeric data type.

Utilized Python library, Matplotlib.pyplot for data visualization.

Financial Monthly Report, Independent Research Project

Built a bank financial report with python to track monthly revenues and expenses.

Processed raw data, converting data types into appropriate data for automated calculations.

Used Regular Expression (Regex) in a ‘Description’ column to eliminate unnecessary wildcard characters.

Categorized expenses into a derived column to better manage future expenses.

Provide a visual dashboard to better account for overall financial activity.

EXPERIENCE

Digital Conversion Specialist August 2019 – Present

Kellar Institute for Human Disabilities, Fairfax, VA

Improved accessibility of books by formatting and structuring Microsoft word Documents.

Used Adobe Acrobat to improve accessibility of scanned books.

Sales Consultant April 2019 – August 2019

CarMax, Chantilly, VA

Identified opportunities to clientele for a peace of mind while purchasing a vehicle by enticing CarMax’s extended service plan (MaxCare) and maintained an above average conversion rate of 88% of MaxCare in doing so.

Actively engaged in communication with potential clientele in order to schedules and manage appointments.

Sales Consultant & e-Commerce Management June 2014 – June 2018

Miguel’s Floor, - Proprietorship, Haymarket, VA

Responsible for ordering efficient material giving meticulous attention to detail so that projects were executing in a timely manner.

Helped develop an action plan in order to execute projects.

Engaged in discourse by participating in follow up discussion in addressing any negative comments online.

Expanded Customer base with extensive advertising campaign.

LEADERSHIP

Association of Latino Professionals for America (ALPFA) Spring 2020

GMU Chapter, Intern

Help establish and manage the organization’s leadership executive board

Help develop a Strategic Plan and Operational Calendar to ensure the chapter’s success

Member recruiting and fund-raising events to promote the overall growth of the organization.

Finance Club Member

Northern Virginia Community College

SKILLS

Technical: Adobe Acrobat, QuickBooks, MS Office Access, Excel, PowerPoint, Word, Microsoft Visio, Microsoft SQL Server, Date warehouse development, OLAP, Python: Pandas, Matplotlib, Seaborn, SAS JMP, R & Tableau

Languages: Spanish

Contact this candidate