Learn Data Skills
Beta
Alonzo Morales

Alonzo Morales

Business Analyst

Target

Technologies

My Portfolio Highlights

My New Course

Understanding Data Science

My New Course

Understanding Data Science

Mindful analyst, decoding patterns to unravel the big picture.

My Work

Take a look at my latest work.

course

Intermediate SQL Queries

course

Understanding Data Science

course

SQL for Joining Data

course

Intermediate SQL Queries

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Understanding Artificial Intelligence
Understanding ChatGPT
Understanding Data Science

My Work Experience

Where I've interned and worked during my career.

Target | May 2022 - Present

Senior Market Analyst

• Designed and implemented scalable, automated dashboards in Domo, improving accessibility to critical market insights and enhancing data-driven decision-making. • Integrated generative AI tools like ChatGPT to enhance reporting accuracy and automate repetitive tasks, contributing to operational efficiency and innovation. • Leveraged advanced SQL, Python, and Excel skills to analyze market trends and deliver actionable insights that informed capital investments. • Streamlined manual reporting processes with automated market-level solutions, saving over 300 hours annually and reducing operational overhead. • Partnered with technical teams and leadership to maintain detailed documentation in Confluence and manage projects using Jira.
Show More

Target | Aug 2020 - May 2022

Senior Business Analyst

• Delivered advanced analytics for Roundel programmatic advertising, enabling the team to exceed a $12M revenue target in 2021 through precision reporting and insights. • Championed product strategy and execution, collaborating with stakeholders to deliver innovative data solutions aligned with business objectives. • Created advanced visualizations in Domo, connecting data pipelines from Hadoop using Hive SQL and Python for cross-team reporting. • Partnered with product owners to develop product strategy, fulfill related roadmap, support, and troubleshoot existing products, and help deliver the business objectives utilizing agile tools including Jira and Confluence.

3M | Mar 2019 - Aug 2020

Data Analyst

• Automated key business processes, including item obsolescence workflows, improving efficiency by 70%. • Built dynamic dashboards and ad hoc reports in Power BI and SAP Business Objects to support data-driven strategies. • Provided actionable insights from large datasets using Python, SQL, and Excel, driving improved product marketing efforts. • Managed business requests for 3M Personal Safety Division and collaborated with multiple business partners using Salesforce, Jira, and SharePoint to ensure completeness and accuracy of data.

Target | May 2018 - Feb 2019

Inventory Analyst

• Analyzed sales of apparel brand including metrics such as OOS %, sales units, sales dollars, on-hand units, and weeks of supply. • Optimized inventory strategies by analyzing sales and performance metrics, leading to better allocation across 1,800+ stores. • Developed segmentation strategies that improved inventory efficiency, reducing stockouts. • Proactively engaged with multiple internal and external business partners including Merch Buyer, Merch Planner, and import and domestic vendors.

3M | Apr 2017 - May 2018

Data Reporting Analyst

• Pulled, modeled, and manipulated large volumes of data from multiple sources to generate training completion reports using Excel, Access, and SAP. • Automated Excel-based reporting tools, reducing processing times by 65% and increasing report reliability. • Validated data and collaborated on the development of SAP BI tool, enhancing reporting capabilities and user satisfaction.

Weisman Art Museum | Jan 2015 - Jan 2016

Visitor Services Assistant

N/A

Weisman Art Museum | Jan 2013 - Jan 2016

Gallery Guard

N/A

Cambridge University Press | Jun 2015 - Aug 2015

Social Media Marketing Intern

• Generated content for social media channels such as Facebook and Twitter with the aim of promoting more awareness of the Cambridge University Press brand in Spain. • Conducted competitive analysis and designed media strategies that improved engagement. • Made recommendations to Marketing Director to increase visibility and engagement with social media marketing strategies

My Education

Take a look at my formal education

University of Minnesota-Twin Cities

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free