Data Analyst

Michael Scott

United States

linkedin.com/in/michaelbrianscott

***********@*****.*** 336-***-****

Summary

MBScott1997.github.io

My passion for business and tech derives from my passion of connecting people. In this rapidly changing technological world, businesses are better equipped than ever to connect people with products or services that change the way people see and interact with the world around them.

Throughout my school and work careers I have held a myriad of leadership positions where I learned first-hand the importance of time-management, prioritization, and relationship building. I have also had the opportunity to work with multiple so wares, including Microso Office, specifically Excel and Azure DevOps; Adobe Creative Cloud, specifically Photoshop and InDesign; Tableau; Salesforce; Wrike; and Trello. I am also currently taking classes in Python, SQL, and R. I am always looking for new opportunities to learn new skills and enhance my creativity through my work. I am passionate about what I do, and am working towards a career in Product Management in the tech sector. Experience

Program Management Intern

Amazon

Jun 2020 - Present (3 months +)

Working within the Amazon PIT (Powered Industrial Trucks) team, I am tasked with performing analysis on the efficiencies of forkli s in the warehouse, and establishing baselines for repair cost forecasting.

• Compiled, cleaned, and analyzed data from multiple sources and discovered key correlations to help FC Safety Officers using R and SQL

• Created a benchmark for future repairs, utilizing Excel, to allow for more accurate cost forecasting

• Created KPI’s to monitor the impact of new technologies on employee efficiency and safety Chief Financial Officer

MotMot Coffee

Jun 2019 - Jun 2020 (1 year 1 month)

MotMot is an all student-run sustainable nonprofit which sells coffee and donates all profits back to coffee farmers in Nicaragua and Vietnam. As a student-run company, we focus on empowerment for the children of farmers living in politically and financially complex areas.

• Created MotMot's first company budget and projection forecasts

• Outlined first onboarding and training mechanism for new hires

• Onboarded new sales and accounting so wares into MotMot's financial workflow Operations Intern

Xenon arc

Oct 2019 - Mar 2020 (6 months)

Responsible for inventory management across warehouses and developing a strategy to forecast unit sales with an unpredictable customer market. Michael Scott - page 1

• Created Xenon Arc’s purchase planning data analytics strategy utilizing Excel and SQL

• Improved stocking strategy to create a more efficient weekly inventory ordering

• Managed day-to-day vendor relationships to ensure logged inventory and Microso Dynamics ERP are aligned

Program Management Intern

Amazon

Jun 2019 - Sep 2019 (4 months)

Working within the Alexa organization within Amazon I was tasked to take existing internal mechanisms and systems and improve their efficiency and to create a better customer experience for our internal and external customers.

• Created a more efficient feature request intake process with the goal of reducing project delays by 25%

• Managed internal development requests, utilizing Jira agile project management

• Created stakeholder feedback loop to ensure long term sustainability of the team through organizational changes

Management Associate Intern

Arvato Financial Solutions

Feb 2019 - Jun 2019 (5 months)

Operating in a startup environment, my role is to be flexible and use my well-rounded skill set to help whichever team needs me. Key projects include creation of marketing collateral, research for sales and long term business growth, and leading the recruitment effort to grow our team.

• Managed the project management system improving team efficiency and productivity

• Created new presentations and collateral for marketing and sales divisions utilizing Adobe InDesign and Photoshop

• Led internal recruiting effort, utilizing LinkedIn Recruiter and Vettery

• Conducted market research to manage new product development and SOC II compliance Intern

Empirical Wealth Management

Sep 2018 - Jan 2019 (5 months)

Working at a growing wealth management firm I was tasked with creating supporting documents and filling out paperwork for clients. Creation of excel documents to build client portfolios, design of sales and marketing material, and administrative duties.

• Created more efficient system for building sales material packets for potential clients

• Performed weekly data analysis through Excel to manage client information and billing information

• Valuation and research on ETF's and Mutual Funds

• Created visuals for client meetings and potential client interactions

• Optimize client 401k's and assist in developing portfolio allocation and tilts Program Management Intern

First Tech Federal Credit Union

Jul 2018 - Sep 2018 (3 months)

Worked with the Program Management team of a large credit union. Created internal informational documents, conducted research, and weekly reporting tasks with Excel.

• Conducted research for potential new market expansion to Senior Vice President

• Created and presented proposal for 2019 Retail Strategy to Senior Leadership Team Michael Scott - page 2

• Compiled data utilizing Tableau, Archer, and Excel

• Created intra-Credit Union communications, utilizing Photoshop and Microso Office Vice President of Finance

Washington Student Association

May 2017 - Jun 2018 (1 year 2 months)

The Washington Student Association is a nonprofit based out of Olympia, Washington that is the voice for all college students in the state. The WSA focuses on voter registration and accessibility, college affordability, and promotes the overall well being of college students.

• Created and Managed $94,000 budget of 501(c)(4) statewide nonprofit

• Spearheaded organizational dues restructure to ensure long-term sustainability

• Secured $10,000 grant from major statewide coalition

• Created platform to receive fundraising dollars and distributed to individual campuses ASCWU Vice President for Legislative Affairs

Central Washington University

May 2017 - Jun 2018 (1 year 2 months)

Working within the ASCWU, I represented the 11,000+ students of Central Washington University to the Washington State Legislature in Olympia, where I was writing and lobbying on policy that promoted college affordability and accessibility, voter registration, mental health support, and more.

• Managed two separate $35,000 budgets and 4 employees

• Registered 472 students to vote in between Sep. 15-Oct. 8

• Created the CWU Student Legislative Action Committee

• Represented the 11,000+ students of CWU to the Washington State Legislature

• Lobbied on 15 passed pieces of legislation

• Wrote bill funding mental health services for student veterans and passed the Washington State Senate unanimously

Education

Seattle University

In Progress, Analysis and Functional Analysis

2018 - 2020

Skills

R • SQL • Python • Excel • Data Visualization • Data Analysis • Cluster Analysis • Program Management • Product Management • Amazon Web Services (AWS)

Michael Scott - page 3

Contact this candidate