# Vic Ofori

Vic Ofori is a remote worker on Himalayas, Student Consultant and Analyst at M&M Strategic Solutions, based in United States.

Source: https://himalayas.app/@vicofori

```text
Data Analyst turning SQL and Python data into dashboards, reliability insights, and clean, usable metrics.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | United States |
| Authorized to work in | United States |
| Job categories | Data Analyst, Business Intelligence Analyst, Reporting Analyst, Data Visualization Analyst, Analytics Consultant, Associate Data Analyst, Data Analytics Specialist |
| Skills | SQL Queries, Python Programming, R, Excel, Tableau, Power BI, Power Automate, VBA, Microsoft Copilot, SharePoint Online, Data Analysis, Data Visualization, Statistical Analysis, Data Cleaning, Data Quality, ETL Processes, Data Modeling, Data Mining, Machine Learning, Predictive Analytics, Predictive Maintenance, Pandas, NumPy, Matlab, Google Sheets, GitHub, Canva, SQL, Solidworks, Airflow, Autocad |
| Portfolio | https://github.com/Ofori7 |

## What I'm looking for

```text
I’m looking for a role where I can build trustworthy reporting with SQL and Python—improving data quality, supporting metrics dashboards, and helping ensure database operations run cleanly in a government contracting environment.
```

## About

```text
I turn messy engineering and operational data into dashboards and decisions using SQL, Python, and careful data cleaning. In my Aircraft Manufacturing Engineering Intern role at Shenyang Aerospace University’s KLFSND, I refined aerospace component models with CATIA, validated material-selection criteria from collected datasets, and supported structural simulations in ANSYS and MATLAB.

On reliability and retention projects, I analyzed years of aviation incident and maintenance records (~5,000 entries) with Python and SQL to find failing-system patterns and reliability trends, including data quality validation and workflow documentation. I also ran regression analysis on workforce data (1,000+ records) with Python and R to identify turnover predictors.

Now, as a Student Consultant and Analyst at M&M Strategic Solutions (remote), I’m building a functional KPI reporting dashboard prototype for small business owners and translating survey findings into dashboard design requirements—using Google Sheets with the option to replicate in Tableau or Power BI.
```

## Experience

### Student Consultant and Analyst (current)

M&M Strategic Solutions. May 2026 - Present

```text
Leading stakeholder kickoff meetings and developing slide decks to communicate project scope. Conducting market research and developing a KPI reporting dashboard prototype.
```

Skills: Market-Research, Dashboard-Design, Google-Sheets, Project-Management

### Aircraft Manufacturing Engineering Intern

Shenyang Aerospace University Key Laboratory of Fundamental. Mar 2023 - Jan 2024

```text
Designed and refined aerospace component models using CATIA, improving design precision by 80%. Conducted structural simulations in ANSYS and MATLAB to optimize prototype performance.
```

Skills: Catia, Ansys, Matlab, Structural-Analysis, Data-Cleaning

### Student Volunteer Team Member

Shenyang Aerospace University. Jan 2021 - Dec 2023

```text
Managed a network of dorm leaders to relay student issues and digitized logs for real-time data access. Streamlined onboarding for new students by assisting with documentation and visa procedures.
```

Skills: Digitalization, Coordination, Problem-Solving

### COVID-19 Monitoring Team Member

Shenyang Aerospace University. Jan 2020 - Dec 2022

```text
Monitored and recorded temperatures for 200+ students daily, ensuring compliance with safety protocols. Streamlined health data reporting by transitioning manual logs into a centralized Excel database.
```

Skills: Data-Entry, Excel, Data-Reporting

## Education

### McDaniel College

Master of Science, Data Analytics. 2024 - Present

```text
Pursuing a Master of Science in Data Analytics at McDaniel College.
```

### Shenyang Aerospace University

Bachelor of Engineering, Aeronautical Engineering. 2020 - 2024

```text
Earned a Bachelor of Engineering in Aeronautical Engineering from Shenyang Aerospace University.
```

## Tech stack

- GitHub
- NumPy
- Pandas
- MATLAB
- Google Sheets
- Airflow
- SOLIDWORKS
- Canva
- SQL
- AutoCAD

To contact Vic, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Jeffrey Ezugwu](https://himalayas.app/@jeffreyezugwu): Senior Data Analyst, Lockheed Martin
- [brooks bryant](https://himalayas.app/@brooksbryant): Data Analytics Trainee, 365 Careers
- [Olivia Kyeni](https://himalayas.app/@oliviakyeni): Data Analyst, Insight Enterprises
- [Sophia Chadsey](https://himalayas.app/@sophiachadsey): Data Analyst, AT&T
- [Sai Preethi User](https://himalayas.app/@saipreethiuser): Data Analyst Intern, Hitachi Vantara
- [Syd Hurst](https://himalayas.app/@sydhurst): Graduate Engineer, FLSmidth
- [Cassandra Lobo](https://himalayas.app/@cassandralobo1): Lead Ambassador, DePaul University
- [Sunil kumar User](https://himalayas.app/@sunilkumaruser): Data Analyst, Community Dreams
- [Linh Le](https://himalayas.app/@linhle2): Executive Assistant / Project Coordinator, ChenMega Machinery LLC
- [Erick Guevara](https://himalayas.app/@erickguevara): Metric & Data Analyst, Lockheed Martin
