Kara Stucky Email & Phone Number

Wichita, Ks, Us

Wichita, Kansas, United States

-Support eCommerce team’s requests for changes to Power BI and creation of new metrics -Identify competitor sites and manage web scrape data set and table -Create key performance indicators in Power BI through the use of DAX and visualizations to track metadata content and forecast future completion time frames -Clean and prepare eCommerce metadata and combine with other Lawson data to produce a comprehensive table and manage the daily refresh schedule-Analyze and interpret data to provide actionable insights into customer, sales, pricing, shipping, and other company data on an Ad Hoc basis-Leverage web scrape, Cubiscan, and competitive intelligence data to add descriptions, dimensions, and weight information to the part pages

Wichita, Kansas, United States

-Developed process to forecast hours for individual aircraft based on maintenance and historical hour information -Scraped competitor sites for part and price information, created data set, reports, and Power BI dashboard regarding price competitiveness-Performed Ad Hoc analytics support to business with actionable insights into customer, pricing, part, and parts manufacturer approval (PMA) information-Downloaded PMA data from FAA, built into a table with company data, and created Power BI report with analysis regarding sales activity for parts with PMA-Utilized SimilarWeb to benchmark competitors and to inform pricing as well as landing page suggestions

-Assessed development and implementation of the online residence hall room select program through collaboration on cross-functional teams, testing website functionality, and the use of Microsoft Excel and Microsoft Project to track and manage inventory and scheduling-Gathered marketing research including demographic information, industry analysis, local trends, and historical data to forecast occupancy levels for future terms and prepare a report for management regarding findings-Supervised student office assistant-Oversaw online room selection process for approximately 3,000 incoming residence hall students -Used Qualtrics survey to discover student preferences to determine the viability of new apartment type-Prepared weekly occupancy reports for management and provided rental verifications on behalf of past residents-Problem solved roommate conflicts and facilitated room moves as necessary-Assisted students requiring housing accommodations by determining suitable room options-Managed room inventory for special groups and developed process for transfers within the residence hall system-Determined program and schedule for participants of the Big 12 Directors of Housing and Dining Conference -Winner of Upper Midwest Region-ACUHO Support Staff Award

Manhattan, Ks

-Analyzed demand for room types and provided key indicators to forecast future pricing -Developed focus group to determine valuation of specialty housing option for future pricing decisions-Compiled statistics and prepared weekly cancellation reports for management-Liaison to IT application developers to resolve application issues and test new web application and contracts for functionality and usability-Reconciled student accounts to ensure correct billing

Master Of Business Administration - Mba

Phi Kappa Phi

Bachelor'S Degree, Marketing

Summa Cum Laude