Roger L.

Experience

1. Financial Data Analyst

   Xplorie

   Dec 2021 — Present · US

   Built over 2 dozen Tableau KPI Dashboards, Reports, and Stories for company-wide use (Certified Tableau Specialist) Execute SQL queries to join multiple tables to create optimized data sources for Tableau reporting. Use Python Pandas for ETL processes to perform data cleaning, manipulation, advance calculations, and filtering. Advance Excel, Power Query, VBA Macros, Data Cleaning & Functions Develop and maintain Visual Basic (VBA) Macro projects on a weekly basis with the purpose of automatingfinancial accounting procedures, ETL processes, journal entry preparation, generating invoice statements, sending emails, and splitting bank statements. NetSuite and Salesforce experience

Education

• Pepperdine Graziadio Business School

  Master of Science - MS, Real Estate Investment and Finance

  2017 — 2018

• Novancia Business School Paris

  International Business

  2016 — 2016

• University of Michigan

  Master of Science - MS, Applied Data Science

• Galvanize

  Data Science Immersive, Data Science, Python, Machine Learning.

• Vanguard University of Southern California

  Bachelor of Arts - BA, Business Administration and Management, General

  2015 — 2017

Skills

• Weapons
• Training
• Microsoft Powerpoint
• Basic Food Handler's Course (California)
• Handle Confidential Information
• Leadership
• Firearms
• Team Leadership
• Financial Analysis
• Afghanistan
• Army
• Organization
• Public Speaking
• Management
• Active Dod Secret Clearance
• Active Dod Top Secret Clearance
• Discipline
• Pianist
• Teamwork
• Military
• Customer Service
• Special Operations
• Investments
• Microsoft Word
• Fitness Training
• Excel
• Argus Modeling
• Microsoft Excel
• Financial Modeling
• Combat
• Data Analysis
• Team Building
• Military Operations
• Argus Real Estate
• Airborne School
• Portfolio Management
• Research
• Microsoft Office
• Finance
• Highly Motivated Self-Starter