
Macy's & Bloomingdale's 2018-2024, MarTech Operations
At Macy's & Bloomingdale's, I worked on the Partner Integrations team from 2018-2024, where I started as a Senior Analyst and was promoted twice to Manager and then Senior Manager. My team sat between our Digital Marketing teams and our Engineering, Data Governance, and DevOps teams. We were responsible for the sourcing, maintenance, and definition for 200+ data attributes used for Macy's & Bloomingdale's marketing, retail media, and marketplace. In addition to this, my team managed the onboarding process for all new partnerships as it related to their data requests. In total, we managed over 60 daily file transfers and file configurations. Example of a product data feed: Google's Product Data Specifications.
My team interacted with Paid Search, Paid Social, Email, Affiliate, Retail Media, and Marketplace teams regularly. Additionally, we were the point of contact for all new data requests and reports for these teams. As a result, we also worked closely with Site Merchandising, Supply Chain and Distribution, Analytics, Site & Product, Promotions and Personalization, Pricing, Legal, Trust & Safety, and Procurement. See here for diagram details.
Notable Projects
-
Product Type & Google Product Category Overhaul
-
Dead Net Profitability
-
Competitive Pricing Initiative
-
uCVR A/B Testing
-
Category Top Performers
-
Google Merchant Center Suspension Warnings
-
SEO Migration - Yext to RIO SEO
-
Cookieless Future Audit
-
Data File Frequency ROI
-
Meta CAPI/AMAPI
-
Google Promotion Support
-
Master Page Traffic Campaigns
-
Data Dictionary
-
Onprem to Cloud Migration
-
Google Cloud to ProductsUP Migration
-
Affiliate Migration - Rakuten to CJ
Notable Partnerships
-
Google Team
-
Meta Team
-
Spark Agency
-
RIO SEO Team
-
Criteo Team
-
Kargo Team
-
Commission Junction Team
-
Rakuten Team
-
MediaOcean Team
-
Dentsu Team
-
ChannelAdvisor Team
-
LilyAI Team
Tools and Platforms
-
ProductsUP to expedite the configuration and customization for data feeds and delivery thereof to third parties
-
Google Big Query and Google Cloud Storage to query our datamart and archive delivered files for Bloomingdale's team
-
Google Merchant Center to upload and manage online catalog of goods for sale and manage promotions
-
Google Business Profile to manage all Macy's and Bloomingdale's store location details
-
Facebook Business Manager to uload and manage online catalog of goods for sale and manage promotions
-
PowerPoint to create and present summaries, project details and status to leadership and project stakeholders
-
Excel to do ad hoc analysis and reporting
-
STELLA for product information management of product item catalog data
-
Confluence to create, publish, and disseminate SOPs and archive information
-
JIRA to store, track and archive work items and stories
-
Figma to collaborate on projects cross-functionally
-
Trello to collaborate and manage team work flows
-
GitLab for version control of data files and scripts
-
ServiceNow to submit and archive service tickets to other teams
-
Outlook to communicate across internal and external teams
Strong Skills
-
SQL
-
Cross-functional collaboration
-
Agile/Waterfall Methodologies and SCRUM
-
Leadership & Team Management
-
Project Management
-
SOPs, ERDs, Data Flow Diagrams
-
Data: Management, Analysis, Visualization, Reporting, Presenting
Working Knowledge
-
Google Ads, GA4
-
Salesforce
-
Facebook Ads
-
Programmatic (The Trade Desk)
-
Tags, Pixels, Server-to-Server
-
Python, JS, HTML, CSS
-
CDPs, DMPs, CRMs
-
Attribution and MMM
-
PowerBI, Tableau, Adobe Analytics
Google 2017-2017, PixelBook Dogfood Team
I joined Google's dogfood team for the PixelBook. There, I worked as a data sourcing and dashboarding analyst. I was responsible for understanding what data was necessary to support the dogfood team's analysis of users' feedback about what was great about the product, what wasn't so great, what bugs and issues it had, as well as users' behaviors and usage trends for the pixelbook. Working at Google was a great experience that offered me first-hand exposure to how to navigate such a large network of enterprise teams and stakeholders. I made several connections on the various data teams and legal. I learned to navigate privacy issues when it came to what data was and wasn't suitable for the dogfood program's use and access. I was able to successfully stand up dashboards that showcased daily escalations on bug tickets, net promoter scores, max and min use trends and habits. Later we grouped and clustered the bugs and successes into categories to assess areas of success and areas that needed attention before product launch.
Wells Fargo 2017-2017, Corporate Properties
I joined Wells Fargo to assist in the curation of a datamart that would aggregate the company's various property holdings financial information for internal controls and reporting. This was a short-lived project as the conditions for pre-launch were discovered to be unmet. The necessary stakeholders that would need to be involved were not yet prepared to dedicate the time and attention necessary to run a successful project and the budget was quickly eaten up with several deadlines being pushed back. Ultimately, the project was dissolved prematurely. That said, it was a great experience to work with several stakeholders each with strong backgrounds in data management and was another opportunity to leverage my skills in a different domain of data.
I joined Salesforce on a contract to backfill a maternity leave. There, I was able to experience the culture of big tech and be exposed to several arms of operations there. Ultimately responsible for contributing to the Technology and Readiness team's BAU process for receiving incoming update timelines for the Salesforce platform and module updates. We in turn would identify the clients that needed different standards of notifications while supporting large and sensitive clients transitions timelines and communicating with internal teams on any extensions needed for them as well as setup and support emergency sessions with clients during transitions to different versions of the platform.
Salesforce 2016-2017, Technology & Readiness
I joined ICON Aircraft at an early stage in it's development. It had been a startup for several years before my joining but had operated in an early inception and design phase. As I joined, the company was transitioning from proto-type to production phase and was in the first stage of implementing it's Enterprise Resource Planning system, "PLEX". At ICON, I was the main lead on implementing the various modules for the ERP (Manufacturing, Quality Control, Supply Chain, Production Monitoring, Accounting and Finance). This was a great opportunity to wholistically learn the various divisions of a manufacturing company, network and engage with stakeholders from all professional backgrounds. I later contracted our help with a specialized consulting group to help expedite our rollout of the system. This was a fantastic opportunity that basically crammed 4 years of experience into 1.5 years. I learned a ton from this role.
ICON Aircraft 2015-2016, ERP Implementation
At Interamerican, I conducted inventory and sales forcasting and planning for 68,000 items. I leveraged SAP and Excel to adjust the figures in the ordering system to avoid supply interruptions across the company's network of warehouse depots and consulted with product line managers for ad hoc requests and exceptions.
InterAmerican Motor Corporation 2014-2015, Inventory & Sales Management
At Makita, I conducted inventory and sales forcasting and planning for 4,500 items. I leveraged BPCS (AS400) and Excel to adjust the figures in the ordering system to avoid supply interruptions across the company's network of warehouse depots and consulted with product line managers for ad hoc requests and exceptions.
Makita Corporation 2013-2014, Inventory & Sales Management
Pacican English 2012-2013, English as Second Language
I spent a year abroad after University, teaching English as a second language in Shanghai, China to students K-12