__________________________________________________________________________________________________
Enthusiastic data analyst eager to be a collaborative communicative team player, bringing agility, and adaptability with desire to learn and grow. Ready to utilize Python-Pandas-JavaScript-SQL for data pipelines, accessibility, automation, cleaning, joining, queries, optimization, analytics and visualization.
__________________________________________________________________________________________________
TECHNICAL SKILLS
Scripting: |
Python, Pandas/Jupyter, JavaScript |
(data visualization, statistical eval, cleaning, automation) |
SQL: |
Postgres, SQLite, SQL Alchemy, MongoDB, JSON, API |
(queries, tables, views, HTML) |
Web Dev: |
D3, HTML, CSS, BootStrap, Flask, Jinja, Leaflet |
(web scraping, data viz, UI, database) |
__________________________________________________________________________________________________
APPLICATIONS & PROJECTS
Global Economics Map
|
Link:
https://global-econ.herokuapp.com/
- Collaborated with a small team to produce an interactive global map, web page displaying economic categories.
- Provided full stack development, ETL for GEOJSON w/ automated updating, created database & queries w/ flask API integration, front end user control, JavaScript JSON pointers, map formatting by category & tooltip info.
- Technology Utilized : VS Code, JavaScript, HTML, Leaflet, D3, GEOJSON, Python Flask & Pandas, SQL Alchemy, SQLite, DB Browser
US Health Care Cost Compare
|
Link:
https://github.com/BrandinO771/viper_proj_1
- Collaborated with small team to analyze healthcare costs across all hospitals in three states using Medicare data.
- With ETL, categorized, binned, merged, cleaned, organized data for statistical evaluation/visualization.
- Automated the visualization & statistical testing of null hypothesis for cost variance correlations.
- Technology Utilized : Python, Pandas, Jupyter Notebook : Numpy, Maplotlib
Project Zerb,The Video Game
|
Link: https://gamejolt.com/games/Project_Zerb/281415
- Full-time development, created a fully functional, single player retro PC game app. Created all code, graphics, audio, and game design. Developed optimized, modular, scripts for: user input, obj /enemy ai behavior & controllers, menus, sequenced events, analytics reporting.
- Utilized : Unity 3D Engine, Mono Development, 95% JavaScript, 5% C#
__________________________________________________________________________________________________
EXPERIENCE
Seedbox Solution | Database ETL / APP Developer - Contract
4/2020 - 7/2020
Created relational database and single-page front-end web interface, for (client requested) one click data reporting and upload.
Wrote versatile Python ETL script for XML & CSV data sources, with upload & error log reporting. JavaScript used to listen,
and process user HTML query requests to and from REST API. DB data outputs in formatted HTML tables, with CSV & PDF download options.
User can also set custom report parameters to output batch CSV reports.
Independent Game Developer
11/2012 - 4/2018
Created polished single player video game pc app with Unity 3D. As the sole developer on the project, gained experience with most facets of game app development.
Union Bank, NA
11/2009 - 9/2012
Vice President, Manager Investment Fund Administration
Supervised three Trust Administrators serving in a fiduciary capacity for collective investment funds.
- 2012 Project lead on flagship fund closure, closed 30 year old fund, on target day with no residual issues.
- 2010 Improved client satisfaction and retention, by successfully overhauling our Funds annual audit process.
- 2009 Facilitated the launch of 4 new Investment Funds, driving multi-million dollar asset growth for the Bank.
__________________________________________________________________________________________________
EDUCATION
- Certificate of Completion | UCSD Extension, Trilogy: Data Visualization Bootcamp, San Diego, CA
Experience completing weekly front/back-end, solo & collaborative group projects leveraging industry standard skills to integrate large multi-data sets into visually cohesive interactive analysis. Received an A+ for the 24 week course.
- BA, Traditional & Computer Arts | Academy of Art University, San Francisco, CA