ETL/Database Developer

Ben Drevitch

**********@***.*** 917-***-**** linkedin.com/in/ben-drevitch-58107016b/

SKILLS

• Programming Languages: Python, SQL, JavaScript, Java, R, React.

• Frameworks: .NET, React, Node, Django

• ETL Tool Proficiency: Azure Data Factory, BigQuery, Snowflake, DBT tools, SSIS tools

• Technical skills: multimodal projects working in multiple languages at once, web scraping, database maintenance, large-scale forecasting, code automation, reward-based machine learning. PROFESSIONAL EXPERIENCE

Ernst & Young, NYC, NY: ey.com

ETL Developer, October 2022 - 2024

• Scraping advertising spots across a client portfolio using Pandas, Python, Postman, and SQL to find opportunities to increase revenue.

• Created pipelines to get data from clients and sort it in a useful manner for data consumption using SQL and Python.

• Developed forecasting queries leveraging data and machine learning to create predictive models using ETL software (a mix of BigQuery and Snowflakw), SQL, Python, and Pandas.

• Helped role out substantial welfare program for a large municipal government in an ELT project using Azure by sorting/extracting survey responses from city residents into usable databases by loading and transforming the responses then showing client which residents qualified for the benefits.

Fidelity Investments, Raleigh-Durham, NC: fidelity.com Software Engineer Intern, Summer 2021

• Worked in Java, Python, and SQL to get greater insight into the day-to-day trading activities of the firm by reviewing trade data internally.

• Set up automatic email alerts in Java to relevant trading desks whenever an anomaly was discovered in daily trade data using an automated Python script which would read through SQL database of trade data.

• Created dashboards in PowerBI for trading desks showing where anomalies laid in daily trades. Ellington Management Group, Greenwich, CT: www.ellington.com Software Engineering Intern, Summer 2019, Winter 2019/2020, Winter 2020/2021

• Created tools for trading desks, accountants, and management team at investment firm.

• Worked to properly value real estate loans with Python scraping stored in SQL to compare REIT values which were then displayed in a web browser using JavaScript.

• Used JavaScript and SQL in tandem to effectively and efficiently view display data in browser form and created new user interfaces while streamlining old ones. EDUCATION

Boston University, Boston, MA

B.A. 2022 Majors: Computer Science and History

PROJECTS

• Used Raspberry Pi and Python to create a functional mini-baseball scoreboard. I am currently working on a personalized bus and train tracker using similar techniques.

• Hosted SQL Server on personal computer to catalogue my restaurants visited.

Contact this candidate