Drew Gallagher Email & Phone Number

Novi, Mi, Us

Columbus, Ohio, United States

- Coded solutions to standard suite of computing problems using Java and C# - Designed ER Diagrams and used them to create an SQL Database hosted on AWS - Wrote custom queries to retrieve analytics information in Microsoft SSMS - Developed specifications for an HTML web page and coded said page for compatibility with desktop and mobile browsers - Served as Team Leader in a variety of agile development Scrum scenarios - Studied efficient search and sort algorithms for use… Show more - Coded solutions to standard suite of computing problems using Java and C# - Designed ER Diagrams and used them to create an SQL Database hosted on AWS - Wrote custom queries to retrieve analytics information in Microsoft SSMS - Developed specifications for an HTML web page and coded said page for compatibility with desktop and mobile browsers - Served as Team Leader in a variety of agile development Scrum scenarios - Studied efficient search and sort algorithms for use processing big data - Reviewed AWS services and completed AWS Academy Cloud Practitioner training Show less

Columbus, Ohio, United States

- Tested Panasonic Automotive navigation and audio software to determine performance issues - Prepared and composed software bug reports in Japanese and English using documented software specifications - Responded to a wide variety of client demands on short notice, conforming to new user requirements - Used command line tools to install custom logging tools and applications in an Android development environment - Used Go programming language to write a program to encrypt… Show more - Tested Panasonic Automotive navigation and audio software to determine performance issues - Prepared and composed software bug reports in Japanese and English using documented software specifications - Responded to a wide variety of client demands on short notice, conforming to new user requirements - Used command line tools to install custom logging tools and applications in an Android development environment - Used Go programming language to write a program to encrypt confidential company data - Installed custom Panasonic debugging apps on iOS and Android environments - Reported highest number of specification violations in software in first 2 years on job within my debugging team - Responded to tickets relating to self-reported and customer-reported software defects on a daily basis - Actively participated in English and Japanese video conferences involving participants in multiple time zones (e.g. Japan Standard Time, Pacific Standard Time, Eastern Standard Time) - Complied with evolving safety standards for both Panasonic and Honda facilities throughout the COVID-19 pandemic (temperature checks, travel documentation, mask requirements) - Maintained communication with clients to ensure fulfillment of data security and occupational safety requirements - Accurately reported reproduction procedures and timing for software bugs, tested procedures multiple times and under different conditions to assist developers in determining cause of bug - Analyzed Android ADB software logs to determine if ostensibly similar phenomena resulted from a different code issue - Kept accurate, detailed records of daily work results, including driving distance and expense sheets for business travel - Assisted non-native English speakers in registering with Honda plant security - Analyzed detailed software specifications (Japanese language) to confirm expected software behavior before and after a release - Conducted quarterly inventory of proprietary equipment Show less

Lewis Center, Ohio, United States

- Created and revised custom python code to alter text in games - Tested games for release on multiple versions of Windows - Converted Shift-JIS game code into more universally executable Unicode formats - Fluent in Japanese (JLPT N1 Level) - Translated and edited material (incl. software/comics/audio files/legal documents) for corporate clients - Translated news articles/TV programs/software on private commission - Consulted with creators throughout the translation… Show more - Created and revised custom python code to alter text in games - Tested games for release on multiple versions of Windows - Converted Shift-JIS game code into more universally executable Unicode formats - Fluent in Japanese (JLPT N1 Level) - Translated and edited material (incl. software/comics/audio files/legal documents) for corporate clients - Translated news articles/TV programs/software on private commission - Consulted with creators throughout the translation process using spoken and written Japanese - Confirmed creators' preferred meanings for key terminology and maintained a consistent style guide - Produced English-subtitled videos using Aegisub - Authored PR tweets and blog entries Show less

Tokyo, Japan

- Taught ESL classes to students (mainly adults, but also children) - Prepared lesson plans for 1-on-1 and small group lessons - Handled special needs and adjusted language levels for customers from a wide range of cultural backgrounds

College Park, Maryland, United States

- Authored and Edited C++ code to process large quantities of data - Learned to use custom code specific to modeling the satellites of giant planets - Modified code to fit my project's specific needs - Produced movies of rocks in space to aid in visual comprehension/presentations - Used Linux OS

Software Developer Certificate, Computer Science, 4.00

- Coded solutions to standard suite of computing problems using Java and C# - Designed ER Diagrams and used them to create an SQL Database.

Bachelor'S Degree, Astronomy/Physics (Double Major), 3.67

-Graduated with honors. -Studied python coding and SQL queries in a Summer 2011 astronomy research internship. -Practiced presentations.