Categories
Analytics Troubleshooting

Improving Our Data Collection

(Decorist : 6/19-6/19)

Challenge

Anytime instrumentation changes were made, different engineers applied different standards of implementation, causing discrepencies in data collection.

Action

Created templatized checklist in Jira (in conjunction with Dir of Data Sci) to improve analytics instrumentation.

Results

  • Introduced checklist leading to consistent data analytics collection, growing trust with non-technical stakeholders.
Categories
Budgeting Process

Understanding Costs

(Decorist : 9/18-6/19)

Challenge

Inherited an engineering budget without a clear inventory of costs and corporate parent wanted company’s Engineering Cap/OpEx (which had never been formulated.)

Action

For whatever reason, prior to my arrival, no one paid attention to engineering costs (AWS, subscriptions, etc.)

I worked with Accounting to create and maintain a budget, revising and reviewing on a monthly/quarterly/annual basis, while also determining Cap/OpEx, and in so doing, found an allocation on P and L leading to $45K/yr savings.

Results

  • Created monthly budget giving company ability to forecast engineering costs for first time in its history.
Categories
Process Site Reliability

Preventing Business Failure

(Decorist : 5/19-5/19)

Challenge

Realized a key analytics ETL server was a crucial component of the engineering infrastructure and without redundancy.

Action

  • Crafted a plan to remediate risk.
  • Performed AWS devops necessary to bring up 2nd instance.
  • Trained-up data engineer.
  • Worked with Data Engineer and offshore Tiger Team of 2 to deliver a process for spinning up a Docker-based backup server.

Results

  • Created replacement Docker image (and recovery process) to be spun-up, ensuring business continuity in catastrophic situation.
Categories
Analytics Troubleshooting

Missing Mixpanel

(Decorist : 3/19-5/19)

Challenge

Late discovery that new initaitive/partnership was missing a key metrics instrumentation.

Action

Jumped in and instrumented, verifying in Mixpanel. Worked with Director of Data Science to formulate Jira stories breaking down the problem into discrete chunks/units-of-work towards cleaning up/adding new events in the future.

Results

  • Launched new strategic initiative on time and empowered the business to have greater analytics clarity.
Categories
Mobile Process SEO

Mobile First

(Decorist : 4/19-4/19)

Challenge

Realized most users were using mobile devices on the site when Engineering was developing/testing on larger screensizes.

Action

Dug into Google Analytics to identify data pointing to predominance of usage of mobile screensizes.

Results

  • Modified release process to incorporate FE review (“Mobile First”) on iPad, iPhone, improving site’s overall UX.
Categories
eCommerce Process SEO Troubleshooting

Improving SEO

(Decorist : 3/19-3/19)

Challenge

Received word that a number of key UXes weren’t rendering for SEO, likely impacting our rankings.

Action

  • Setup local emulation as Googlebot/Chrome 41.
  • Identified problem as having been ongoing since prior October (through git bisect.)
  • Introduced process for ensuring SEO/M compatability for releases going forward.

Results

  • Intro of process has engineers developing proficiency on key aspect of business: SEO.
Categories
Architecture AWS EC2 VR

Cutting Cloud Costs

(Decorist : 3/19-3/19)

Challenge

Given trends in 2018, AWS budget was projected to increase 92%.

Action

  • Worked with full-stack engineer on web team to tweak EC2 configs.
  • Iteratively introducing Reserved Instances to add to cost savings.
  • Worked with VR team to optimize the rendering pipeline.

As part of the VR work, we found that EC2 instances were running unneccessarily 24/7 so we adapted processes to more efficiently utilize those resources.

Results

  • Reduced AWS MoM spend by 40%.

 

Categories
3D Collaboration Process Troubleshooting VR

Salvaged PR Opportunity

(Decorist : 3/19-3/19)

Challenge

Marketing opportunity showcasing company’s proprietary shop-the-room modeling was four months behind and at-risk after key in-house designer departed and PR client was losing patience.

Action

I took ownership of project management, working with new designer and remote Pakistani VR engineering team, introducing a lightweight process (spreadsheet-based and daily 15m check-ins) in order to get backlog of shop-the-room models modeled and bundled into our VR (Unity-based) design app.

Results

Categories
Management Monitoring Process Site Reliability Troubleshooting

All the False Positives

(Decorist : 9/18-12/18)

Challenge

Inherited a situation where there were incomprehensible 1000+ issues per day in exception reporting software (Sentry.)

Action

Identifed and delegated KR to FE lead to create a daily process to chip away at remediation. Encouraged accountability by having FE lead give status report weekly.

Results

  • 1000+ to 7 system alert notifications.
Categories
Growth Marketing Troubleshooting

FB Pixel Headache

(Decorist : 10/18-12/18)

Challenge

The business wasn’t confident in ROI on FB marketing spend because FB pixel wasn’t firing (and no one internally was a Subject Matter Expert.)

Action

Worked with a SF-based, non-technical marketing consulting and delegated to a Delhi-based junior frontend engineer to get familiar with FB Pixel.

We went back and forth, encumbered by the 12.4h time difference and lack of holistic understanding about how to best run campaign and test the efficacy of the pixel.

Finally, after weeks of simply not being able to get to “Done,” I jumped in and found the FB Pixel Helper:

With the problem solved, we were able to finally turn up our marketing spend.

Results

  • Got FB pixel tracking for PageView and AddToCart.