Max Aaronson Email & Phone Number

Boston, Ma, Us

Waltham, Ma, Us

- Created lambda-based ETL jobs to pipeline expenditure data from search engine APIs to data lake (S3)- Created Athena-based jobs to perform aggregations and warehousing functions- Used Athena and Redshift Spectrum to create data pipelines from S3 to Redshift and Tableau in service of business intelligence objectives- Wrote ETL jobs to facilitate on-site SQL Server warehousing objectives as needed- Documented pipelines in Lucidchart for use by other developers or teams- Day to day investigations into data anomalies and discrepancies per business requests

Canton, Massachusetts, Us

- Created ETL jobs in Bash, Python, AWK and SQL to process medical claims and enrollment data, used for daily business operations, compliance, and business objectives and analytics. - Wrote the majority of new ETL jobs to support the company-wide expansion into Connecticut- Refactored legacy code and sped up query run times (moved redundant code to function calls, removed unnecessary and costly nested loops, etc)- Debugged software and data issues existing processes- Alternated with other developers in the 24 hour ‘on call’ production support rotation- Collaborated with other developers, business managers and outside vendors

• Collaborated on UI design for Android photo-effects app written in Java and C• Created XML layouts for the UI• Implemented activity lifecycle management and other features in Java• Simplified program architecture by splitting app into several activities (Java Classes)

• Created HTML template for company website, as per client specifications• Created responsive/mobile-friendly CSS layouts that adapt to different screen widths

Dresher, Pa, Us

• Processed enrollments, deposits, withdrawals, changes of ownership and account maintenance• Collaborated with a team to process transactions for four statewide 529 plans around the country• Verified accuracy of all information in each transaction through company database to prevent errors or possible fraud

As a tutor, I made sure that my students not only fully understood their subject matter and concepts, but were ready to prove their understanding in their examinations. I structured my own schedule around my students in order to maximize the time I could spend helping them, and I would stay as late as required to ensure that students not only knew the right answers to problems, but knew the underlying theory or derivation that had led us there.- tutored students in topics ranging from linear algebra to macroeconomics- created custom lesson plans for each student- broke down difficult concepts into smaller pieces to help students gain an understanding bit by bit

As a member of Binghamton University's Financial Council, I worked as a team with other members to evaluate detailed proposals for budget increases for student groups, and also to evaluate groups' utilization of the previous year's budget. Working in this environment taught me to better articulate my ideas to a group and more effectively scrutinize budget breakdowns.-Assisted in allocating $600,000 of funding to student groups for the 2013-2014 year-Met with members of over 150 groups to determine appropriate budgets for each-Worked to further off-campus students’ interests, including building better relations with the town of Binghamton-Planned university events, such as Spring Fair and visits by speakers and artists

-Organized science and recreational activities for students, including plant and tree identification, ecological studies, and community service projects such as invasive species removal and trail construction-Led groups of four to eight students on field trips, bike rides, canoe trips and hikes, including Mt. Monadnock and three-day camping trip to summit of Mt. Washington-Ensured safety of all students, including administering first aid when necessary-Built team cooperation and resolved student conflicts; coached and assisted junior leaders

-Lectured to groups of beginner and intermediate students about several aspects of guitar playing, including: -Music theory (Scales and notation) -Chord shapes and proper finger placement -Warm up techniques -Strumming methods and rhythms

Master'S Degree, Computer Science

Bachelor Of Science (Bs), Economics With Concentration In Analysis

Computer Science Certificate

Full Stack Nano Degree, Front And Back End Development

Data Engineering Nano Degree, Data Engineering