Associate Business/Data Analyst

Colton Stenerson

*** ******** ** *** ****, NY ***02 952-***-**** ***************@*****.***

Education

Arizona State University, W.P. Carey School of Business Tempe, AZ

Bachelor of Science, Computer Information Systems Graduated: August 2018

Major: Computer Information Systems

Minor: Applied Business Data Analytics

CFA Institute, 2020 Level II Chartered Financial Analyst Candidate

Professional Experience

Associate Data/Business Analyst August 2018 – Present

Ameriprise Financial Services, Inc. Minneapolis, MN

Tasks include designing and modeling data tables, analyzing internal and external data, various programming initiatives using Python and SQL, while working across the organization to ensure business requirements are appropriately created and met by the team.

Extensive experience with data profiling, manipulation and wrangling to ensure datasets are consumable to end-users. This includes transforming raw data to business-oriented metrics in order to enhance our overall business.

Working with multiple teams to gather and create business requirements, creating documentation of processes/procedures for enhancement. Following projects from beginning to user acceptance testing (UAT).

Organizing meetings across teams/projects to ensure everyone is aligned on necessary updates, while discussing and solutioning any gaps found.

Business Operations Analyst September 2017 – August 2018

Cubex LLC Phoenix, AZ

Worked in a rotational program within Cubex, an inventory management technology company based out of Phoenix, AZ. Rotational departments included Finance, Marketing and Sales, Information Technology and Logistics.

Major responsibilities across departments included: Interacting with clients regarding necessities and order requests, worked heavily with Microsoft Excel to track inventory and analyze customer orders, profiling customer and inventory data to produce helpful metrics for the firm.

Technology Intern May 2017 – August 2017

Ameriprise Financial Services, Inc. Minneapolis, MN

Collaborated with the Brokerage Experience Production Support team, which assists advisors and clients with numerous issues revolving around the Ameriprise Brokerage Platform (ABP). The ABP is the software used to place trades, analyze stocks, rebalance accounts, etc. by the advisors.

Utilized and adapted to many new tools/software including the Ameriprise Brokerage Platform, HP Quality Center, TestComplete, and ServiceNow all to complete data validation for the team.

Leadership

Ameriprise Financial Minneapolis, MN

Numerous Leadership Positions August 2018 – Present

Recruitment/Mentorship Committee: Travel to surrounding universities to attend career fairs and recruit potential employees on behalf of Ameriprise. Upon hiring, mentor new employees to assist with the onboarding process and any help needed within their role.

Volunteer Committee Chair: Organize monthly philanthropic events within the Twin Cities area. Examples include: Habitat for Humanity, People Serving People, Open Arms.

Young Professionals Network: Collaborate with a group of professional peers bi-monthly to network, share ideas, and expand company knowledge. Participate in organization/engagement of events.

Department of Information Systems Club (DISC) Tempe, AZ

VP of Finance August 2016 – August 2017

The DISC is a dynamic social organization comprised of motivated professionals-in-training.

Club holds numerous networking events with large, respected companies.

Task was to plan our budgetary expenses successfully for the year including member needs, networking event coordination and corporate collaboration.

Other

Academic Achievement Scholar (2014 – 2018)

Strongly proficient in Microsoft Excel, Access, Word, PowerPoint and Visio

Experience with Python, R, SQL, Java, C#, HTML, CSS, JavaScript, and Amazon Web Services

Exposure to visualization software such as Tableau and Microsoft PowerBI

Contact this candidate