AADITYA TIWARI

Seattle, Washington +1-857-***-**** adwlov@r.postjobfree.com https://www.linkedin.com/in/aadityatiwari23/ Business Intelligence and Data Analyst with about 4 years of professional experience in assisting Fortune 50 firms make efficient data-driven decisions using math, technology and industry acumen PROFESSIONAL EXPERIENCE

Lowe’s

Senior Business Analyst (November 2021 to June 2022)

• E-Commerce Order Cancellation Analysis: Drove the project to streamline & develop holistic data pool containing cancellation and OMS data from 3 different businesses falling under Lowe’s Canada. Identified KPIs and developed numerous automated dashboards to report key factors involving high cancellations. Recommendations sent to all 3 businesses’ stakeholders which helped drive down website order cancellations.

• Category Experience Enhancement (Lowes.ca): Employed web analytics to improve lowes.ca user experience by deep diving in page performance metrics, user behavior and interactions on the website, filter usage, campaign medium, internal search behavior, competitor’s assortment and pricing etc. The insights were presented to the UI/UX stakeholders and VP of omnichannel which led to changes on lowes.ca leading to better user journey

• KPI 360: Used Adobe Analytics combined with Data Visualization (PowerBI) to build an automated dashboard that captured various digital metrics like bounce rate, clicks, page views, average order value, conversions, cart additions etc. on a high level with freedom for the end users to dive deep on various levels with the help of slicers

• Survey Sentiment Analysis: Extracted reviews data for 3 sub banners under Lowe’s Canada (RONA/RenoDepot/Lowe’s) and performed sentiment analysis to categorize sentiment for various product departments and services offered. The insights were discussed weekly with respective stakeholders to determine action steps (if needed) Business Analyst (June 2020 to October 2021)

• Email Performance Tool: Developed a dynamic dashboard that allowed marketing team’s stakeholders to track the customer’s interactions and gain quantified insights regarding the email campaigns on a daily & weekly basis. Automated the report to garner information from different mail performance reports and feed out insights and KPIs directly to the marketing teams

• Marketing Planning 360: Digital transformation of a PDF report derived from multiple sources to one single source of truth containing an overview of the previous month’s marketing performance covering various avenues like demographic, chronological, regional, product hierarchy, flyer, web audience, search performance saving 18 hours of manual work of 3 different marketing teams Mu Sigma

Trainee Decision Scientist (September 2018 to May 2020)

• Search Engine Marketing for one of the biggest search engines: Goal Setting & Forecasting goal metrics for several features of the advertising platform using time series analysis. Built and improved existing reports and performed numerous ad-hoc analyses to help the client’s program managers

• Digital Transformation for one of the profound pharmaceutical retailers in the US: Enabling the firm to achieve strategic goal of digital transformation and making informed and data-driven business decisions by identifying the right business KPIs, implementing the logic and business rules to create a data layer EDUCATION

University of Washington – Seattle, Washington (June 2022 to June 2023) Master of Science: Business Analytics

Vellore Institute of Technology – Vellore, India (July 2014 to May 2018) Bachelor of Technology: Major in Electronics & Communications Engineering SKILLS

SQL, Power BI, Microsoft Excel, Adobe Analytics, Python, R, Data Analytics (descriptive, predictive, prescriptive), Search Engine Marketing, E- commerce, Storytelling, Basic Tableau, Requirement Gathering, Client communication, Data Visualization, Digital Analytics MISCELLANEOUS

SPOT Award: Lowe’s India (10/2021) The Business Intelligence Analyst Course 2020 – Udemy (01/2020) Hobbies: Soccer, Golf, Travel, Electronic Music Volunteering: AIESEC in VIT (Team Leader, Global Exchanges)