Brian Ahn Email & Phone Number

Irvine, California, United States

• Managing multiple renewable energy projects that persists of fulfilling financial requirements, monthly operating reports, and quarterly covenants. • Leading monthly and quarterly meetings with the C-level executives to inform our month to month performance, while analyzing major changes throughout each month.• Setting up monthly budget analysis, working hand to hand with the O&M department.• Fulfilling Ad hoc assignments to maintain energy projects to be profitable.

La Palma, California

My role as an Data Analyst, is to increase efficiency and maximize profitability by forecasting and analyzing trends.• Planning and analyzing forecasts to see the market trend and planning for future possible outcome.• Leading weekly meetings with the C-level executives to inform our week to week forecast, while forecasting major changes throughout each week.• Usage of SAP and SCM to analyze and forecast future changes.• Setting up monthly forecast for the sales department.• Analyzing data using ICIS, IHSMarkit, Panjiva, Salesforce, SAP, and SCM.• Visualizing data by using Tableau.

Irvine, California

6-month bootcamp that focuses on Python, Excel, Javascript, SQL Database, Tableau, for Data Analysis and Data Visualization. Criteria for Certification ✔ ★Python: Creating a Python Script that analyzes financial records of a fictitious company, printing results and exporting as a text file with results. Creating a Python script that analyzes poll data from multiple counties. Creating a representative model of weather across world cities using Matplotlib, JupyterNotebook, Pandas and the OpenWeatherMap API. ★Web Visualization: Creating a website to host visualization dashboard. Creating a web application using HTML, CSS, JavaScript, and D3 that displays information from a dataset in a table. Creating and deploying a Flak web application to Heroku that includes a dashboard page showcasing interactive charts based on a dataset. Creation of scatter plots showing data on health risks and factors of each state from two different data sources compared on multiple variable using D3. ★Databases and ETL: Create SQL queries that return various data from across multiple tables in a database. Creation of climate analysis using Python and SQLAlchemy for a specific set of dates, creating plots for different variables such as precipitation and temperature. Designing a Flask API based on the queries developed in the climate analysis that returns data in JSON format. Creating a production database that combines 2 or more sources of data from either databases, APIs, or web scraping, and then performing the ETL process on the data.★Fundamental Statistics: Creating a dashboard, story, and report with Tableau showcasing aggregate data from a public dataset, including a static map with data plotted overlaid on top, and a dynamic map showing changes over time.★Advanced Excel: Analyzing a database using Excel, formula,s pivot table, pivot charts. Utilizing VBA scripting that works on multiple sheets of data in Excel

Los Angeles, California

LMU-Match was a school organization that helped students prepare for interviews and edit resumes. We worked with LMU Alumni to match students and their interest with various full-time and internship positions. Through this organization, many students found opportunities to widen their horizon.

Los Angeles, California

Riot Games is the creator of League of Legends, a multiplayer online battle arena (moba) genre video game. By 2012, League of Legends was the most played PC game in North America and Europe. By January of 2014, over 67 million people played League of Legends per month. At Riot Games, I was a translator for professional gamers for creation of the Youtube series called "Legends Rising". The content of Legends Rising was mostly focused on the background of how professionals gamers became who they were. As a translator, I helped video producers create Legends Rising by supporting them with translations and quality check.

Gangnam-Gu, Seoul, Korea

Interned at Samjong KPMG (KR), and was in the Deal Advisory team. At Samjong KPMG, I worked with two others to help support the deal advisory team. My work mainly focused on data creation and analysis.

Los Angeles California

Interned at Radio Korea, and utilized many programs like Final Cut Pro, and many adobe programs.

Honolulu, Hi

Hilo Hattie is Hawaii's largest retailer and manufacturer of Made in Hawaii apparel, gifts, and accessories. This company has had over 2 million shoppers world-wide at retail locations in Oahu, Kauai, and Maui.

Data Analytics

Activities and Societies: A 24-week intensive program focused on gaining technical programming skills; Advanced Excel, Python, JavaScript.

Bachelor'S Degree, Finance, Junior

Activities and Societies: Tennis Club

Education record