Andre Araujo-Kerry

New York, NY

• Built a firm-wide Accounts Payable dashboard to improve internal reporting and team efficiency, designing a scalable relational schema for data warehousing and writing Python ETL to consolidate several external sources.
• Automated 10+ accounting and internal analysis workflows with NetSuite's SuiteScript 2.0, saving about 15 hours of reporting and analysis a week.
• Assessed wildfire exposure by mapping property-level data to portfolio collateral, querying ArcGIS REST APIs with Python to identify 30+ loans affected by the Palisades and Eaton fires.

Boston, MA

• Created 30+ SQL data checks to ensure the completeness and accuracy of investment data for every fund on MFS.com, meeting legal requirements.
• Developed a Java service layer to handle exceptions and data mapping for investment details, testing JSON responses with Postman on Red Hat JBoss.
• Implemented 10+ UI changes on MFS.com with HTML, CSS and Adobe Experience Manager.
• Worked in Agile ceremonies with Jira and Bitbucket across several codebases and environments.

Python, SQL, TypeScript

• Built a Python text-analysis pipeline that parses LinkedIn posts and metadata to detect job-change events, enriched with role, company and location to surface real-estate leads.
• Designed a normalized relational database and ingestion workflows to warehouse and track lead records across outreach stages.
• Developed a TypeScript dashboard to manage client statuses, contributing to 6 closed sales and 30+ active client relationships.

Python, scikit-learn

• Used demographic characteristics to predict the outcomes of adverse drug reactions with the FDA Adverse Event Reporting System dataset and Python.
• Performed exploratory data analysis to clean and reformat the data, identifying errors and new relationships between variables.
• Trained three machine learning models (k-NN, random forest and SVM), using hyperparameter tuning to maximize the accuracy of the final model.

B.S. Computer Science and Business Administration (Finance) · GPA 3.7

Relevant coursework: Computer Systems, Object-Oriented Design, Algorithms and Data, Database Design, Foundations of Data Science, Fundamentals of Software Engineering