Amir Noorafkan

Data Analyst

• Analyzed fleet telematics data using statistical tools in Python (Pandas, Scikit-learn), collecting data (API requests to data vendors), preparing datasets using functions to clean and process the raw data.
• Create and maintained data systems and databases to meet new and growing business requirements.
• Built and maintained automation tools using Microsoft Power Platform (PowerApps, Power Automate, SharePoint) that automated manual tasks such as requesting equipment, sending weekly/daily status updates to stakeholders, which streamlined procurement process and reduced errors in billing and scheduling resulting in $1.7 million in estimated savings over 6 months.
• Created Extract, Transform, and Load (ETL) pipelines from MS PowerApps to SharePoint List, as well as automated daily report generation for multiple business units.
• Maintained quality and accuracy of ETL pipelines for telematics data and developed new Python programs (Pandas, NumPy, SQLite) to extract and clean data from internal and external sources (API calls).
• Used Airtable to enhance workflow for managing projects and tasks, prioritizing based on importance and deadlines, increasing visibility, and reducing planning time.

Freelance

• Optimized website for search engines (SEO) to improve visibility and increasing traffic to website by 50%.
• Developed web scraper tool using Python with BeautifulSoup, Requests, and Pandas libraries to extract product data from suppliers’ websites and formatted to according to client’s needs for their website.
• Built static website for marketing agency to attract potential client for the 2022 World Cup in Qatar.

Co-Founder

Lack of ownership, access, and control over our personal data is a growing problem and one of the biggest bottlenecks slowing down progress in areas such as health, transportation, and education. Atlys is a platform that helps people organize their personal data and derive valuable insights to improve their life and community.

• Developed a data-privacy centric platform for people to derive value from the data they produce from their smart devices and share their insights with trusted people and organizations.
• Created business model, designed app UI/UX, performed market research and surveys.
• Implemented agile development methods and scrum framework using Airtable for delegating tasks, tracking bugs, and keeping track of development cycle.
• Supervised one full-time and two part-time developers to implement features for Android and web applications.

Research Data Analyst

• Developed and validated new data driven method for steel quality assessment using Micro X-Ray Fluorescence (MXRF), conducted experiments, collected data, and performed statistical analysis in Python and Minitab to confirm accuracy of results.
• Provided support to various research projects, generating reports and analyzing trends from pulling data from the steel manufacturing database (MS Access) and used SQL to transform, clean, and manipulate data by joining tables, and feature engineering for KPIs and forecasting.
• Designed and performed specialized tests for data acquisition purposes.
• Created concise data visualizations and reports to effectively communicate key insights to management.
• Created data lake of CSV and Excel files to store experiment data.
• Created five new standard operating procedures (SOP), reducing new employee training time by 80%
• Performed root cause analysis on failed components of steel mill, conducted tests to locate fractures, and provided recommendations that prevented $1.2 million in losses by fixing areas that were causing failure.
• Documented test results and troubleshooting procedures in technical reports for knowledge retention within the organization and co-authored two published papers in the AISTech Journal.
• Familiar with several manufacturing processes (CNC machining, sheet metal fabrication, additive manufacturing, sand casting, injection molding, continuous casting)
• Trained on and worked with machining equipment and powered industrial machines; milling machine, band saw, forklift, crane, sand blaster, etc.

Ryerson University

GPA: 3.7