Sona Shah Email & Phone Number

Dallas-Fort Worth Metroplex

Domestic Pricing Analyst- Managing the pricing environment of domestic markets that make up $164M of yearly revenue for AA

Dallas, Texas, United States

- Worked with the Real Estate and Facilities Analytics team to compile, clean, analyze, and visualize data to improve Southwest’s corporate and airport facilities- Automated an interactive Tableau dashboard for senior managers to visualize training compliance data for 150+ employees- Managed 18 months of equipment and flight data at 19 different airports using SQL, Alteryx, and Tableau, resulting in data-driven recommendations for equipment maintenance and procurement- Generated Alteryx workflows to automate comparisons of over 50,000 rows of employee data and uncover discrepancies between 2 platforms- Loaded Quickbase data into Maintenance Connection for 200+ total assets in all 121 Southwest stations throughout the world- Compiled and cleaned data regarding Southwest's sustainability efforts and EV drivers- Assisted with the development of a model to help predict staffing requirements- Participated in professional development events to understand Southwest’s business model and interact with leaders in different departments

Tempe, Arizona, United States

- Worked with the ASU Barrett Data Science and Misinformation Lab to answer pressing, relevant questions about misinformation, how it spreads, and its consequences- Utilized Python to create visualizations of engagement with social media posts, including likes and retweets- Analyzed trends in the spread of misinformation using Google Trends, Twitter, SMAT, and Crowdtangle- Turned findings into Barrett Honors thesis

Dallas, Texas, United States

- Compiled, cleaned, analyzed, and visualized data focused on the finance, energy, and unemployment sectors for senior research economists Ali Ozdagli and Mike Plante and business economist Tyler Atkins- Wrote a Python script to automate charts modeling employment rates and seasonal adjustment factors, speeding up the charting process by 70% and expanding charting capabilities from 6 charts to over 1000- Conducted a principal component analysis on over 10,000 intraday stock returns in MATLAB, finding 6 factors that affect specific industries and the loadings of these factors on 500 different stocks- Drafted a post and generated eye-catching charts in Excel for the Dallas Fed blog- Engaged with other professionals at the bank, contributing in coding classes, weekly paper reading groups, and discussions with senior economists

Scottsdale, Arizona, United States

- Created and maintained the website using Shopify- Uploaded products and organized them into collections for user-friendliness- Analyzed traffic data to know what to promote on social media and where to target ads- Improved SEO through the use of alt-text on images and meta-descriptions of Google searches- Analyzed previous and current year-to-date sales of products to provide insightful recommendations for 10 large orders

Scottsdale, Arizona, United States

- Developed posts, stories, and reels for Instagram, increasing community engagement by 350%- Highlighted new products through eye-catching pictures and engaging captions- Greeted customers, made product recommendations, stocked products, and handled transactions

Tempe, Arizona, United States

- Selected as a Barrett College Fellow to perform undergraduate research under Dr. Alexander Bick- Designed a follow-up survey of over 200 questions using Qualtrics to understand links between commuting or remote-work frequency, commuting distance, housing choices, geographic mobility, and labor market outcomes following the pandemic- Built a Qualtrics survey template to be shared with other researchers

Tempe, Arizona, United States

- Managed a weekly class of 19 first-year students to provide guidance and structure for a successful transition to college- Prepared and facilitated presentations about key business skills such as professionalism, communication, on-campus involvement, and study skills- Exported and analyzed data regarding students’ grades and academic performances to supervisor using Excel

- Trained on political data methods, such as how to work with census data, the voter file, and VAN- Gathered Census block-level data to produce clear visual representations of racial demographics of 30 precincts in VA-HD-100 precincts using Python- Extracted paginated tables and designed a Python script to compare donor lists of over 10,000 people- Volunteer data analyst for Finale Norton’s campaign for VA House District 100 (June 2021 - Nov 2021)- Volunteer data analyst for Elizabeth Guzman's campaign for Lieutenant Governor of Virginia (March 2021 - April 2021)

Bs, Business Data Analytics; Minors, Economics And Data Science

Activities and Societies: McCord Scholars; Gammage Scholars; RISE Tutoring; Barrett College Research Fellows; Phi Beta Kappa Honor Society.

High School Diploma

Activities and Societies: Varsity Tennis Captain; President of National Honor Society; Vice President of Society of Women Scholars.