Data Engineer

• Apr 2022 - Present

Data Analyst

• Oct 2020 - Apr 2022

• Responsible for the pricing of Wayfair commodity products - worked to develop and implement new pricing strategies • Modeled, simulated, and executed large scale price moves to implement new pricing strategies • Worked cross-functionally with engineering teams to develop methods to automate pricing processes • Created dashboards to monitor and track KPIs to determine the efficacy of commodity pricing strategies • Participated in intern mentorship and campus ambassador programs - Provided career, networking, goal-setting, and technical guidance to interns and co-ops - Participated in panels, info sessions, and other recruiting events for campus hires and interns Show less

Competitive Intelligence - Big Data Management Co-op

• Jan 2019 - Jun 2019

• Built 15 new and maintained an additional 30 web scraping bots designed to parse HTML tags and JSON objects to scrape competitor sites for data used by pricing and analytics teams • Managed millions of new web crawls per day within SQL Server databases to ensure data accuracy and completeness • Developed a method to increase web scraping speed up to 80%, generating millions of additional daily crawls • Created a macro-enabled Excel model for an IP proxy cost analysis that saved the team ~$250k annually • Worked on a “criticals” rotation to identify and resolve any critical data and bot issues that occurred • Edited ten SQL stored procedures to increase data completeness within internal SQL servers and improve stored procedure and query speeds Show less

Investment Group Co-op

• Jan 2018 - Jun 2018

• Oversaw and produced a company-wide daily update which summarized the performance of public and private investments, as well as relevant benchmarks and indices • Analyzed 30+ current and prospective client portfolios to provide exposure and characteristic reports • Conducted research on historical and forecasted economic data and trends for analyst models • Generated weekly reports detailing the current fixed income landscape used by portfolio managers to trade securities • Oversaw and produced a company-wide daily update which summarized the performance of public and private investments, as well as relevant benchmarks and indices • Analyzed 30+ current and prospective client portfolios to provide exposure and characteristic reports • Conducted research on historical and forecasted economic data and trends for analyst models • Generated weekly reports detailing the current fixed income landscape used by portfolio managers to trade securities

Global Product - Competitive Analysis Co-op

• Jan 2017 - Jun 2017

• Analyzed 50+ matrices from financial advisors to find opportunities where MFS mutual funds could compete • Conducted competitive analyses on mutual funds, detailing asset flows, performance, investment strategies • Generated 100+ comparison reports between MFS and competitor funds for wholesalers around the country • Provided MFS salespeople with information on competitors in the industry and how MFS products differ • Analyzed 50+ matrices from financial advisors to find opportunities where MFS mutual funds could compete • Conducted competitive analyses on mutual funds, detailing asset flows, performance, investment strategies • Generated 100+ comparison reports between MFS and competitor funds for wholesalers around the country • Provided MFS salespeople with information on competitors in the industry and how MFS products differ

Camp Counselor

• Oct 2013 - Oct 2014

• Oversaw the safety and well-being of approximately 50 eleven to fourteen year olds • Lead groups of various sizes on a number of activities, such as games, songs, sports, nature walks, team-building activities and the opening and closing ceremony • Attended nightly reflection meetings on obstacles faced and how to resolve them • Available at all times to provide assistance and counseling to anyone who needed it • Oversaw the safety and well-being of approximately 50 eleven to fourteen year olds • Lead groups of various sizes on a number of activities, such as games, songs, sports, nature walks, team-building activities and the opening and closing ceremony • Attended nightly reflection meetings on obstacles faced and how to resolve them • Available at all times to provide assistance and counseling to anyone who needed it

Baseball Coach

• Sep 2013 - Nov 2013

• Oversaw the training of a group of approximately 30 elementary school players • Developed the players’ strengths through a variety of different warm-ups and drills • Taught players specific skills, techniques and teamwork skills to help improve their game • Oversaw the training of a group of approximately 30 elementary school players • Developed the players’ strengths through a variety of different warm-ups and drills • Taught players specific skills, techniques and teamwork skills to help improve their game

Intern

• May 2013 - May 2013

• Shadowed one of the firm’s architects as he did research, worked on designs and met with clients • Attended project meetings about plans for ongoing designs with members of the team • Conducted research and wrote summaries on specific Chinese architectural styles • Performed site visits for projects undergoing construction with the lead architect • Shadowed one of the firm’s architects as he did research, worked on designs and met with clients • Attended project meetings about plans for ongoing designs with members of the team • Conducted research and wrote summaries on specific Chinese architectural styles • Performed site visits for projects undergoing construction with the lead architect