Nick Rock

Senior Business Analyst, Gap Inc. Operations

San Antonio, Texas, United States

About

Accomplished and highly adaptable Sr. Analyst with proven history of demand forecasting, KPI development and tracking. Proficient in the full BI problem solving pipeline, including problem identification, data exploration, solution implementation and results communication. Looking to synthesize prior experience in a business-savvy role with statistical rigor.

Experience

  • Gap Inc. (4 yrs 10 mos)
    • Sr. Analyst - Central Returns
      May 2023 - Present · 3 yrs 2 mos

      Optimizing returns policy for Gap Inc. brands. Cross-functional reporting development in SQL, Python, and Power BI. Versatile returns analytics with actionable brand- and Inc.-level policy recommendations that inform senior leadership decisionmaking. Understanding customer behavioral patterns and unaddressed needs to optimize customer experience.

    • Sr. Analyst - Athleta Decision Support
      Sep 2021 - May 2023 · 1 yr 9 mos

      Conducted A/B testing to improve Athleta Loyalty customers' retention and revenue, typically scoped at $10MM+. • Provided highly cross-functional team with contextual data, A/B test audiences and test results. • Role demanded communication skills, coding flexibility, and deep knowledge of database structure. Developed novel insights in key customer demographics. • Product “Affinity Indexing” provided brand leadership with data-driven customer segment differentiation. • Segmented correlation analysis gave new views into customer closet and hidden links between products. Delivered regular and ad hoc KPI reporting for Athleta's brand leadership. • Blend of SQL, Excel and Python development to produce a wide range of reporting on member data. • Demographic and product data drove leadership's customer targeting decisions.

  • Senior Program Analyst, Loyalty Analytics at Hyatt Hotels Corporation
    Aug 2016 - Sep 2021 · 5 yrs 2 mos

    Developed metric tracking for the World of Hyatt loyalty program. • Blend of SQL, Excel, and Python development to produce a wide range of reporting on member data. • Co-developed and presented reports used by senior leadership to evaluate program success. Forecast and tracked numerous promotional offers for World of Hyatt. • Responsible for providing cost and revenue estimates, and presenting recommendations to program directors. • Once in market, provided periodic reporting on promotion progress. • Promotions ranged from brand-level to global in scope, typically driving $50MM+ in revenue. Produced frequent ad-hoc program reporting to all levels of Hyatt leadership and partners. • Small, agile team fielding all World of Hyatt data requests from hotels, regions, corporate, and external partners. • Required flexibility, deep knowledge of available data, querying and communication ability.

  • Analytics Developer at Market6
    Feb 2013 - Apr 2016 · 3 yrs 3 mos

    Designed, developed and operated a regression modeling platform for estimating promotional sales lift. Currently generating Market6's most up-to-date forecast parameters in production. Researched improvements to retail sales forecasting algorithms. Evaluated new methods and variables using R, SQL and Excel, contributing to an estimated 25% forecast error reduction vs. prior system generation. Acquired expertise necessary to streamline research by running a portion of production system tasks. Took on additional responsibility to learn relevant data-preparation operations, reducing testing cycle from a month or more to one week.

  • Software Engineering and Data Engineering Intern at Etsy
    Dec 2011 - Aug 2012 · 9 mos

    Investigated and fixed defects in the site's PHP and HTML code, in a continuous deployment environment. Created an internal tool for viewing event logs. Co-led a seminar on A-B testing for developers.