Data Analyst E-Commerce
Resume:
Robert Gauntt
BUSINESS/DATA ANALYST
Profile
A data story-teller with education and a long history in both Financial analysis and computer information systems. 5+ years in financial analysis, dash-boarding, WBR reporting to leadership, cost driving analysis, data modeling, and data visualization. Direct job experience including Salesforce CRM, Tableau ETL and Dash-boarding (certified), building automated reporting with Looker and Thoughtspot. Extensive history of automating manual workflows with Excel/VBA.
Employment History
Sales Specialist II, Nike (Contract ETW), Beaverton
JANUARY 2025 — APRIL 2025
●Daily work inside SAP, Cognos, Thoughtspot, Looker, and Tableau.
●Automated Mass returns process with automatic template creation for internal systems.
●Performed Daily Specialized research to solve issues with order routing and billing.
●Coordinated mass returns for client with 3rd party logistics companies.
Senior Sales Performance Analyst / Manager, Walmert e-commerce, Portland
APRIL 2021 — AUGUST 2024
●Established weekly performance reporting for leadership to stand up Walmart Connects Sales advertising arm for 3rd party marketplace sellers.
●Built critical metric tracking for leadership to track sales teams progress. Socialized data via Tableau Dashboards
●Created forecasting and helped plan targets to establish long term goal planning for e-commerce.
●Automated business processes and built policy to help sales team focus on growing ad sales
●Helped take Walmart e-commerce net sales from $39M to past $1BB
Strategic Accounts Manager, Walmart e-commerce, San Bruno
FEBRUARY 2020 — APRIL 2021
●Extensive experience with multiple levels of sales roll-ups, sales velocity, and general marketplace data.
●Extensive data research via Tableau exports for daily and weekly reporting as well as on ad-hoc basis
●Have driven many cross-team initiatives to help drive new product builds and unlocks for marketplace sellers
●Built automated reporting tools and dashboards (Tableau, Looker, and Thoughtspot) to provide real time updates to my team and upper leadership teams
Vendor Performance Manager, Walmart e-commerce, San Bruno
APRIL 2019 — FEBRUARY 2020
●Worked to establish performance benchmarks for Walmart Marketplace sellers and DSVs
●established reporting and communications on on time shipping and delivery including breakouts by region and carrier for marketplace sellers to improve weak areas
●established both data sources and dashboards (Tableau and Thoughtspot) to appraise leadership of progress towards specific KPIs (shorter delivery windows for sellers, higher on time ship and delivery, lowered returns and cancellations)
Contract Operations/ VOC Customer Analyst, Walmart e-Commerce, San Bruno
MAY 2018 — APRIL 2019
●Worked on ad-hoc data analysis on DSV health monitoring, including regional sales trends and general warehouse performance (on time ship and delivery data)
●Worked to build text analysis on customer NPS surveys to provide insights to leadership on how to improve customer surveys.
Contract Data Analyst, M Financial, Portland
JULY 2017 — JANUARY 2018
●Worked on database maintenance (ETL and appending tables) and data sanitation on a database which populated customer facing financial dashboards
●Leveraged financial data to build tax liability forms which were also supplied to our clients
●Built a geo-map data model to find areas of low policy coverage to generate sales leads
Contract Supply Chain Data Analyst, Bount, Portland
FEBRUARY 2017 — JULY 2017
●Built financial models that helped validate, prove, and discover supply chain improvements
●Financial models also helped expose areas of cost savings (warehouse vs long shipping times) (inventory consolidation points) in the tens of millions.
●Worked to geo-map freight data to find areas of cost savings on both fuel spend and efficient inventory housing and positioning
●Built several Excel automation (VBA and Power Query) to perform in house data analysis on unorganized data living outside database housing (bills of lading and financial invoices)
●Analytical insights helped provide members of the supply chain team with both cost savings validation and new opportunities for supply chain contract negotiation.
Contract Financial Analyst, Epiq Systems, Hillsboro
JULY 2016 — JANUARY 2017
●Reconciled massive, multi-million dollar accounts.
●Helped process large member class action settlements, with thousands of payouts per month. High detail oriented work.
●Reconciliation payment network for OFAC violations and S.E.C Compliance
Economic Researcher Internship, Bureau of Business and Economic Research, Albuquerque
JULY 2014 — JUNE 2016
●Worked on data aggregation, data sanitation, and geo-mapping (ArcGIS) of city address data for contracts from the City of Albuquerque and State of New Mexico departments of planning.
●Data and conclusions helped city council and planners justify legislation and changes to city zoning as well as housing legislation
●Well trained in specific data techniques (statistics and simple series) and data management practices
Education
B.B.A Management, University of New Mexico, Albuquerque
AUGUST 2012 — MAY 2016
●elective concentrations in financial management, financial analysis, data analysis (investments data), and mathematics (statistics and engineering calculus over business calculus)
A.A.S. Computer Science, Central New Mexico Community College, Albuquerque
AUGUST 2008 — MAY 2010
●Journeyman project on data aggregation, gathered online data from specific sources and coalesced into an app (Made a home-brew weather widget for android)
References
Alex Halen from Walmart e-Commerce
****.*****@*******.*** · 201-***-****
Annie Zhou from SAMs Club
*****.*****@*******.***
Alexandra De Burh from Walmart e-commerce
*******@*******.*** · 203-***-****
Details
***********@*****.***
Links
Skills
Tableau Dashboarding
Excel VBA and Power Query
Looker Dashboarding
Thoughtspot Dashboarding
Data Analysis
Forecasting and Planning
Leadership Reporting
Project Management
Microsoft Power BI
SAP
Cognos
Hana
Languages
French
Contact this candidate