Sanchi Lunawat
Boston,USA
Summary
With over 10 years of analytical expertise, I specialize in e-commerce and retail, collaborating seamlessly with cross-functional teams. Recognized for meticulous attention to detail, I am a proactive team player with robust organizational and technical acumen.
Overview
11
11
years of professional experience
Work History
Sr. Analytics Engineer
Thrasio
05.2021 - Current
- Led analytics for pricing and promotions team, driving price elasticity curves and finding margin opportunities to increase overall revenue by 12%
- Built complex dbt models that transformed raw data, primarily from amazon, into high-quality datasets; reduced manual workload by 60%
- Wrote SQL queries to automate models in snowflake and regularly maintained data pipelines of these models
- Collaborated with data scientists and brand management to implement models that allowed for data driven solutions
- Built complex data models (star schema) and DAX queries in PowerBI to provide user-friendly front-end reporting
Sr. Data Analyst
NoBull Inc
01.2019 - 04.2021
- Constantly analyze company data to provide important insights on customer shopping behavior, LTV assessments, and future sales predictions by using statistical models; worked directly with the CEO to assess changes
- Utilized visual tools such as heat maps to illustrate location-based selling and develop strategies for new store openings
- Led analytical projects to support all aspects of the company: supply chain, product design, marketing, and finance.
Merchandising Analyst
Tapestry
01.2015 - 12.2018
- Provide analytical expertise via business drivers and key performance metrics to Global Merchandising and BU Teams
- Grew lifestyle category by gathering market data, resulting in build of two styles at $8MM quarterly sales
- Manage and mentor various interns and junior merchandise analysts for future success
- Collaborate cross-functionally with supply chain, buying, and marketing teams to optimize growth strategy for women's handbag categories, $2B business at Coach
- Analyzed data to eliminate low margin, low sales styles; reinvested $3M material goods into productive products.
Inventory Planner
Macys Corporate
08.2013 - 12.2014
- Analyzed sales and customer behavior which helped develop customer loyalty program across all 650 locations
Co-Founder
Bollywood Touch (Personal Startup Company)
01.2014 - Current
- Developed business by finding a niche market for South Asian entertainment and catering to that market
- Performed consumer A/B testing by offering different class packages to see which packages were most desired
- Utilized python scripts to extract public client contact information and build stronger database of customers.
Education
Business Finance -
University of Florida
Gainesville, FL05.2013
Skills
- SQL
- DBT
- Power BI & DAX
- Snowflake & Redshift
- Excel
- ETL Pipelines
- Data Cleaning & Modeling
- Data & Analytics
- Documentation
- Data Warehousing
Accomplishments
Udacity Nano Degree - Data Analyst
Languages
English
Native or Bilingual
Hindi
Native or Bilingual
Timeline
Sr. Analytics Engineer
Thrasio
05.2021 - Current
Sr. Data Analyst
NoBull Inc
01.2019 - 04.2021
Merchandising Analyst
Tapestry
01.2015 - 12.2018
Co-Founder
Bollywood Touch (Personal Startup Company)
01.2014 - Current
Inventory Planner
Macys Corporate
08.2013 - 12.2014
Business Finance -
University of Florida
Similar Profiles
Marco Fallas GámezMarco Fallas Gámez
Ecommerce Account Helpdesk at ThrasioEcommerce Account Helpdesk at Thrasio
Andrew FieldAndrew Field
Director, Ad Operations at ThrasioDirector, Ad Operations at Thrasio
Aquaysha ParksAquaysha Parks
Senior Counsel- International Product Compliance & ESG at ThrasioSenior Counsel- International Product Compliance & ESG at Thrasio